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='A906006' AND a.supplierId=271) OR (a.articleSearch='ZS80002' AND a.supplierId=156) OR (a.articleSearch='PGS017706' AND a.supplierId=4558) OR (a.articleSearch='ESTZSA80002' AND a.supplierId=6372) OR ( a.articleSearch IN ('10100418', '10100584') AND a.supplierId=4657) OR (a.articleSearch='A640093' AND a.supplierId=4364) OR (a.articleSearch='127082' AND a.supplierId=317) OR (a.articleSearch='ZSA80002' AND a.supplierId=257) OR (a.articleSearch='ADK85803' AND a.supplierId=350) OR (a.articleSearch='SG0914' AND a.supplierId=6479) OR (a.articleSearch='GS10449' AND a.supplierId=89) OR ( a.articleSearch IN ('2031793', '2032153') AND a.supplierId=4585) OR (a.articleSearch='33345' AND a.supplierId=101) OR (a.articleSearch='ZSJ80002' AND a.supplierId=481) OR (a.articleSearch='30929591' AND a.supplierId=138) OR ( a.articleSearch IN ('GH0441664', 'GS28676', 'JB425450') AND a.supplierId=4032) OR ( a.articleSearch IN ('7092143', '7092144', '7092550') AND a.supplierId=185) OR (a.articleSearch='871010207' AND a.supplierId=286) OR ( a.articleSearch IN ('421051', '421052', '462022') AND a.supplierId=176) OR (a.articleSearch='8507005' AND a.supplierId=4546) OR ( a.articleSearch IN ('8126151', '8126152', '8188922') AND a.supplierId=175) OR (a.articleSearch='430719084400' AND a.supplierId=4723) OR (a.articleSearch='91021' AND a.supplierId=133) OR (a.articleSearch='121722' AND a.supplierId=403) OR (a.articleSearch='2110491' AND a.supplierId=94) OR (a.articleSearch='33409100010' AND a.supplierId=144) OR (a.articleSearch='ML5779' AND a.supplierId=4752) OR ( a.articleSearch IN ('AEFT028', 'AESU000') AND a.supplierId=6355) OR (a.articleSearch='GSR613100' AND a.supplierId=378) OR ( a.articleSearch IN ('AG40937', 'AG50144', 'AG40944') AND a.supplierId=129) OR (a.articleSearch='QTS828036' AND a.supplierId=57) OR (a.articleSearch='219G0291' AND a.supplierId=6358) OR ( a.articleSearch IN ('GS1279', 'GS1280', 'GS1401') AND a.supplierId=401) OR (a.articleSearch='8507005' AND a.supplierId=6405) OR (a.articleSearch='017706' AND a.supplierId=126) OR (a.articleSearch='SKGS0220309' AND a.supplierId=6357) OR (a.articleSearch='70933345' AND a.supplierId=151) OR (a.articleSearch='871010207' AND a.supplierId=108) OR (a.articleSearch='92851233105' AND a.supplierId=4999) OR ( a.articleSearch IN ('V240499', 'V640093') AND a.supplierId=183) OR (a.articleSearch='51428' AND a.supplierId=4425) OR ( a.articleSearch IN ('301427', '321427') AND a.supplierId=6003) OR (a.articleSearch='GF2165' AND a.supplierId=4894) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Fiat (пасажирский) -> Fiat SEDICI (FY_) ->Fiat 1.6 16V, 06.2006- 10.2014, , 107 ->Упругие элементы