SELECT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM article a INNER JOIN ( SELECT articleNumber, supplierId, manufacturerId, oemSearch, oemnumber FROM article_oem GROUP BY articleNumber, supplierId, manufacturerId, oemSearch, oemnumber ) 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 (223) WHERE (a.articleSearch='8165065SX' AND a.supplierId=4595) OR (a.articleSearch='65889' AND a.supplierId=4495) OR (a.articleSearch='751821' AND a.supplierId=355) OR (a.articleSearch='583880' AND a.supplierId=10) OR ( a.articleSearch IN ('X0704201', 'X5931401') AND a.supplierId=88) OR (a.articleSearch='2109283712' AND a.supplierId=4257) OR ( a.articleSearch IN ('JD229', 'JD6127') AND a.supplierId=113) OR (a.articleSearch='061201' AND a.supplierId=4623) OR ( a.articleSearch IN ('713395300', '714517900') AND a.supplierId=9) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Fiat (пасажирский) -> Fiat Series 75 ->Fiat 75P, 01.1977- 12.1979, , 122 ->Прокладка / уплотнит. кольцо впускного/выпускного коллектора