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 ('HK9601', 'CH9615') AND a.supplierId=478) OR (a.articleSearch='49424987' AND a.supplierId=140) OR (a.articleSearch='721982' AND a.supplierId=10) OR (a.articleSearch='0056028' AND a.supplierId=237) OR (a.articleSearch='171887' AND a.supplierId=101) OR ( a.articleSearch IN ('023780501', '613780500') AND a.supplierId=9) OR ( a.articleSearch IN ('K11768201', '11031776101', '11031789401') AND a.supplierId=4346) OR (a.articleSearch='10209200' AND a.supplierId=139) OR (a.articleSearch='HG1939' AND a.supplierId=267) OR (a.articleSearch='H4070500' AND a.supplierId=88) OR (a.articleSearch='SH0990' AND a.supplierId=4600) OR (a.articleSearch='41251' AND a.supplierId=4683) OR (a.articleSearch='33101062' AND a.supplierId=151) OR (a.articleSearch='WG2100876' AND a.supplierId=4832) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw POLO (6R1, 6C1) ->Vw 1.2 TSI, 01.2014- 10.2017, , 110 ->Прокладка головки цилиндра