SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, (SELECT ps_sub.id FROM products.products_suppliers ps_sub WHERE ps_sub.product_id = p.id AND ps_sub.supplier_id IN (224,226,223,225,227) LIMIT 1) AS id FROM article a /*LEFT JOIN supplier s ON s.supplierId=a.supplierId*/ LEFT JOIN article_oem ao ON ao.articleNumber=a.articleNumber AND ao.supplierId=a.supplierId LEFT JOIN manufacturer m ON m.manufacturerId=ao.manufacturerId LEFT JOIN products.brands b ON b.title=m.manufacturerName LEFT JOIN products.products p ON p.article=ao.oemSearch AND p.brand_id=b.id WHERE (a.articleSearch='FWI210' AND a.supplierId=62) OR (a.articleSearch='06504' AND a.supplierId=4683) OR (a.articleSearch='39522' AND a.supplierId=206) OR (a.articleSearch='X70128' AND a.supplierId=4975) OR (a.articleSearch='24819007062' AND a.supplierId=3) OR (a.articleSearch='1047F' AND a.supplierId=4306) OR (a.articleSearch='BAV1029' AND a.supplierId=394) OR ( a.articleSearch IN ('BWS1041', '581338') AND a.supplierId=49) OR (a.articleSearch='50799' AND a.supplierId=208) OR (a.articleSearch='A00260' AND a.supplierId=65) OR (a.articleSearch='WI0522' AND a.supplierId=4872) OR (a.articleSearch='50048' AND a.supplierId=4604) OR (a.articleSearch='SU082' AND a.supplierId=311) OR ( a.articleSearch IN ('LZ0113', 'LZ0125') AND a.supplierId=89) OR (a.articleSearch='EA5162' AND a.supplierId=4344) OR (a.articleSearch='170039' AND a.supplierId=309) OR (a.articleSearch='05113' AND a.supplierId=101) OR (a.articleSearch='FWI5093' AND a.supplierId=409) OR (a.articleSearch='SU082' AND a.supplierId=295) OR (a.articleSearch='BZ1019WSET' AND a.supplierId=54) OR (a.articleSearch='6312802' AND a.supplierId=279) OR (a.articleSearch='8DK355250091' AND a.supplierId=4734) OR (a.articleSearch='1297301600' AND a.supplierId=268) OR (a.articleSearch='WS0124A' AND a.supplierId=286) OR (a.articleSearch='6121590' AND a.supplierId=4546) OR (a.articleSearch='KS0087' AND a.supplierId=283) OR (a.articleSearch='56709' AND a.supplierId=133) OR (a.articleSearch='SU082' AND a.supplierId=121) OR (a.articleSearch='WK17033' AND a.supplierId=94) OR (a.articleSearch='MWI0124' AND a.supplierId=73) OR ( a.articleSearch IN ('280025', '890025') AND a.supplierId=127) OR (a.articleSearch='WKT50088K' AND a.supplierId=129) OR (a.articleSearch='WS0124A' AND a.supplierId=6304) OR (a.articleSearch='BWI1011' AND a.supplierId=57) OR (a.articleSearch='KS0087' AND a.supplierId=343) OR (a.articleSearch='WI0522' AND a.supplierId=6331) OR (a.articleSearch='99905113' AND a.supplierId=151) OR (a.articleSearch='98012600' AND a.supplierId=39) OR (a.articleSearch='TX3093' AND a.supplierId=4377) OR (a.articleSearch='881915' AND a.supplierId=4970) OR (a.articleSearch='811524006' AND a.supplierId=108) OR (a.articleSearch='SU082' AND a.supplierId=199) OR (a.articleSearch='GIC128' AND a.supplierId=4501) OR (a.articleSearch='VE50799' AND a.supplierId=4425) OR (a.articleSearch='G04453' AND a.supplierId=6347) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Opel (пасажирский) -> Opel OMEGA A универсал (V87) ->Opel 2.4 i (F35, M35), 09.1988- 03.1994, , 125 ->Датчик износа