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 IN ('021806', '021807') AND a.supplierId=6665) OR (a.articleSearch='PH2420' AND a.supplierId=4558) OR (a.articleSearch='753671' AND a.supplierId=405) OR (a.articleSearch='43SKV822' AND a.supplierId=4969) OR (a.articleSearch='15657' AND a.supplierId=4834) OR (a.articleSearch='97002' AND a.supplierId=4664) OR (a.articleSearch='223543' AND a.supplierId=331) OR (a.articleSearch='R25488' AND a.supplierId=4303) OR (a.articleSearch='T497002' AND a.supplierId=4667) OR (a.articleSearch='DWW284TT' AND a.supplierId=4466) OR (a.articleSearch='115628' AND a.supplierId=301) OR (a.articleSearch='V104811' AND a.supplierId=183) OR (a.articleSearch='88191698601' AND a.supplierId=4346) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Audi (пасажирский) -> Audi A4 Avant (8ED, B7) ->Audi 2.0, 11.2004- 06.2008, , 130 ->Шланги / трубки