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='16457' AND a.supplierId=4683) OR (a.articleSearch='TER058' AND a.supplierId=317) OR (a.articleSearch='XT6843' AND a.supplierId=4975) OR ( a.articleSearch IN ('PTH4858', 'PTH5691') AND a.supplierId=4337) OR (a.articleSearch='0011021473' AND a.supplierId=4995) OR (a.articleSearch='300046' AND a.supplierId=128) OR (a.articleSearch='BBT333' AND a.supplierId=475) OR (a.articleSearch='41026391D' AND a.supplierId=6444) OR ( a.articleSearch IN ('TH684391J', 'TH709591J') AND a.supplierId=215) OR (a.articleSearch='CTH2440' AND a.supplierId=4334) OR (a.articleSearch='DT1020V' AND a.supplierId=42) OR (a.articleSearch='TRM120N' AND a.supplierId=4882) OR (a.articleSearch='161032' AND a.supplierId=211) OR (a.articleSearch='350396' AND a.supplierId=234) OR (a.articleSearch='FTK333' AND a.supplierId=407) OR (a.articleSearch='75666' AND a.supplierId=269) OR ( a.articleSearch IN ('352317000200', '352317100200') AND a.supplierId=4723) OR (a.articleSearch='TX25591' AND a.supplierId=287) OR (a.articleSearch='670058' AND a.supplierId=403) OR (a.articleSearch='4006093' AND a.supplierId=94) OR ( a.articleSearch IN ('20191', '65691K', '71891K') AND a.supplierId=388) OR (a.articleSearch='2457731' AND a.supplierId=4380) OR (a.articleSearch='2340071SX' AND a.supplierId=4595) OR (a.articleSearch='TH684391J' AND a.supplierId=6691) OR (a.articleSearch='862032391' AND a.supplierId=108) OR (a.articleSearch='V20991280' AND a.supplierId=183) OR ( a.articleSearch IN ('WG1091821', 'WG1493010', 'WG2113063') AND a.supplierId=4832) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Fiat (пасажирский) -> Fiat 131 (131_) ->Fiat 1.6 (131A1), 10.1974- 09.1981, , 75 ->Термостат / прокладка