SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, ps.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 LEFT JOIN products.products_suppliers ps ON p.id=ps.product_id AND ps.supplier_id IN (223) WHERE ( a.articleSearch IN ('871070', '454260', '886780') AND a.supplierId=10) OR ( a.articleSearch IN ('95LEY50650808C', '95NES65880808C') AND a.supplierId=4674) OR ( a.articleSearch IN ('12489', '46940', '46972') AND a.supplierId=4683) OR ( a.articleSearch IN ('44091596501') AND a.supplierId=4346) OR ( a.articleSearch IN ('OS9601') AND a.supplierId=478) OR ( a.articleSearch IN ('01030118B', '01031878B', '12000767B') AND a.supplierId=140) OR ( a.articleSearch IN ('1150246') AND a.supplierId=4546) OR ( a.articleSearch IN ('046229P') AND a.supplierId=4936) OR ( a.articleSearch IN ('3400101SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('100355', '111038') AND a.supplierId=301) OR ( a.articleSearch IN ('855010023') AND a.supplierId=108) OR ( a.articleSearch IN ('V103268', 'V103331') AND a.supplierId=183) OR ( a.articleSearch IN ('WG1220637', 'WG1700964', 'WG1754519', 'WG1754520', 'WG1222189') AND a.supplierId=4832) OR ( a.articleSearch IN ('ZVCL177') AND a.supplierId=6274) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw PASSAT (3G2, CB2) ->Vw 2.0 TDI 4motion, 11.2014- 03.2024, , 190 ->Уплотнения