SELECT DISTINCT m.manufacturerName AS cross_brand, ao.manufacturerId, ao.oemSearch, ao.oemnumber, ps.id AS supplier_product_id, ps.supplier_id AS real_supplier_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 ('028PI00119000', '028PI00119001', '028PI00134000') AND a.supplierId=287) OR ( a.articleSearch IN ('41198600', '41198620', '40247600', '40759600', '40759620') AND a.supplierId=432) OR ( a.articleSearch IN ('3104343000', '3104343050', '3104587000', '3104587050', '4343000', '4343050', '4587000', '4587050') AND a.supplierId=4402) OR ( a.articleSearch IN ('B13583', 'B18741', 'B18990', 'B18993') AND a.supplierId=4815) OR ( a.articleSearch IN ('DRM21602', 'DRM21604') AND a.supplierId=6534) OR ( a.articleSearch IN ('PM006300', 'PM006300ET', 'PM006300KS', 'PM006400', 'PM006400ET', 'PM006400KS') AND a.supplierId=4514) OR ( a.articleSearch IN ('PK28000', 'PK28050') AND a.supplierId=267) OR (a.articleSearch='PI086600' AND a.supplierId=238) OR (a.articleSearch='7150660000' AND a.supplierId=4717) OR ( a.articleSearch IN ('WG1016439', 'WG2022638', 'WG2101352') AND a.supplierId=4832) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Audi (пасажирский) -> Audi A5 (8T3) ->Audi 2.0 TFSI, 11.2008- 03.2012, , 180 ->Поршень в сборе