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 ('117030', '117029') AND a.supplierId=301) OR ( a.articleSearch IN ('715276', '715277', '715280') AND a.supplierId=21) OR ( a.articleSearch IN ('109176', '109177') AND a.supplierId=101) OR (a.articleSearch='6NW351344361' AND a.supplierId=4734) OR (a.articleSearch='1195000600' AND a.supplierId=268) OR (a.articleSearch='AA23000P' AND a.supplierId=287) OR (a.articleSearch='271229' AND a.supplierId=403) OR (a.articleSearch='0917687' AND a.supplierId=94) OR (a.articleSearch='CNGAU011' AND a.supplierId=6355) OR ( a.articleSearch IN ('30109176', '30109177') AND a.supplierId=151) OR (a.articleSearch='5Q0907511H' AND a.supplierId=4999) OR ( a.articleSearch IN ('V10771029', 'V10771084', 'V10771088', 'V10771090') AND a.supplierId=183) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw PASSAT (3G2, CB2) ->Vw 2.0 TSI 4motion, 05.2015- 03.2024, , 280 ->Управление / регулирование