SELECT DISTINCT m.manufacturerName AS cross_brand, ao.manufacturerId, ao.oemSearch, ao.oemnumber, ps.id FROM article a 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 LEFT JOIN products.products_suppliers ps ON ps.product_id = p.id AND ps.supplier_id IN (224,226,223,225,227) WHERE ( a.articleSearch IN ('1830378', '73378') AND a.supplierId=4005) OR (a.articleSearch='BTS3079' AND a.supplierId=475) OR ( a.articleSearch IN ('CST9335', 'CST9336', 'CST9336C') AND a.supplierId=4334) OR (a.articleSearch='295188' AND a.supplierId=211) OR (a.articleSearch='33892' AND a.supplierId=240) OR (a.articleSearch='106318' AND a.supplierId=101) OR (a.articleSearch='FTS3079' AND a.supplierId=407) OR ( a.articleSearch IN ('82335', '82336', '82336A2') AND a.supplierId=441) OR ( a.articleSearch IN ('7472427', '7472428', '7472428E') AND a.supplierId=341) OR ( a.articleSearch IN ('55595', '55597') AND a.supplierId=269) OR (a.articleSearch='862629012' AND a.supplierId=286) OR (a.articleSearch='530378' AND a.supplierId=4006) OR ( a.articleSearch IN ('LWS139', 'LWS141') AND a.supplierId=6518) OR ( a.articleSearch IN ('SNB5068', 'SNB5070') AND a.supplierId=4501) OR (a.articleSearch='211047' AND a.supplierId=403) OR (a.articleSearch='EPS1830378' AND a.supplierId=4773) OR ( a.articleSearch IN ('82427', '82428', '82428E') AND a.supplierId=244) OR (a.articleSearch='1148210010' AND a.supplierId=144) OR ( a.articleSearch IN ('LVCT468', 'LVCT472') AND a.supplierId=4564) OR ( a.articleSearch IN ('29912', '47897') AND a.supplierId=4683) OR ( a.articleSearch IN ('82335', '82336', '82336A2') AND a.supplierId=27) OR (a.articleSearch='30106318' AND a.supplierId=151) OR (a.articleSearch='116269' AND a.supplierId=301) OR (a.articleSearch='862629012' AND a.supplierId=108) OR (a.articleSearch='V10721309' AND a.supplierId=183) OR (a.articleSearch='99191792301' AND a.supplierId=4346) OR ( a.articleSearch IN ('410580199', '410580200', '410580389') AND a.supplierId=4275) OR (a.articleSearch='WG1748849' AND a.supplierId=4832) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw PASSAT Variant (3G5, CB5) ->Vw 2.0 TDI, 11.2014- 03.2024, , 150 ->Датчики