0 0
Magnum by Böker, Balisong Black

Magnum by Böker, Balisong Black

Artikelnummer: 890753
Gewicht: 0.216 kg
Sofort lieferbar
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 ( '3e2da2ae3974e43a42e877be9dc28808' ) 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 ( '3e2da2ae3974e43a42e877be9dc28808' ) 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 = '3e2da2ae3974e43a42e877be9dc28808' 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 = '3e2da2ae3974e43a42e877be9dc28808' 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