0 0
Stealth Ignition Switch

Stealth Ignition Switch

Artikelnummer: 640370
Gewicht: 0.658 kg
Dieser Artikel ist nicht auf Lager und muss erst nachbestellt werden.
Stealth Ignition Switch

Es liegen keine Bewertungen zu diesem Artikel vor.

select distinct oxv_oxarticles_de.* from ( select d.oxorderid as suborderid from oxorderarticles as d use index ( oxartid ) where d.oxartid in ( '8e84c99d1994763a437502d2c07972b3' ) limit 50 ) as suborder left join oxorderarticles force index ( oxorderid ) on suborder.suborderid = oxorderarticles.oxorderid left join oxv_oxarticles_de on oxv_oxarticles_de.oxid = oxorderarticles.oxartid where oxv_oxarticles_de.oxid not in ( '8e84c99d1994763a437502d2c07972b3' ) and ( oxv_oxarticles_de.oxissearch = 1 or oxv_oxarticles_de.oxparentid <> '' ) and ( oxv_oxarticles_de.oxactive = 1 and ( oxv_oxarticles_de.oxstockflag != 2 or ( oxv_oxarticles_de.oxstock + oxv_oxarticles_de.oxvarstock ) > 0 ) and IF( oxv_oxarticles_de.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_de as art where art.oxparentid=oxv_oxarticles_de.oxid and ( art.oxactive = 1 ) and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) ) TESZT select oxv_oxarticles_de.* from oxaccessoire2article left join oxv_oxarticles_de on oxaccessoire2article.oxobjectid=oxv_oxarticles_de.oxid where oxaccessoire2article.oxarticlenid = '8e84c99d1994763a437502d2c07972b3' and oxv_oxarticles_de.oxid is not null and ( oxv_oxarticles_de.oxactive = 1 and ( oxv_oxarticles_de.oxstockflag != 2 or ( oxv_oxarticles_de.oxstock + oxv_oxarticles_de.oxvarstock ) > 0 ) and IF( oxv_oxarticles_de.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_de as art where art.oxparentid=oxv_oxarticles_de.oxid and ( art.oxactive = 1 ) and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) ) order by oxaccessoire2article.oxsortTESZT SELECT oxv_oxarticles_de.* FROM oxv_oxarticles_de INNER JOIN oxobject2article ON oxobject2article.oxobjectid=oxv_oxarticles_de.oxid WHERE oxobject2article.oxarticlenid = '8e84c99d1994763a437502d2c07972b3' AND ( oxv_oxarticles_de.oxactive = 1 and ( oxv_oxarticles_de.oxstockflag != 2 or ( oxv_oxarticles_de.oxstock + oxv_oxarticles_de.oxvarstock ) > 0 ) and IF( oxv_oxarticles_de.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_de as art where art.oxparentid=oxv_oxarticles_de.oxid and ( art.oxactive = 1 ) and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) ) TESZT