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='FT59168' AND a.supplierId=4938) OR (a.articleSearch='342030' AND a.supplierId=205) OR (a.articleSearch='15740' AND a.supplierId=4683) OR (a.articleSearch='GSE154' AND a.supplierId=6444) OR (a.articleSearch='160214' AND a.supplierId=4654) OR (a.articleSearch='55287' AND a.supplierId=6558) OR (a.articleSearch='740151N' AND a.supplierId=80) OR (a.articleSearch='77170' AND a.supplierId=4576) OR (a.articleSearch='GA15526' AND a.supplierId=4688) OR (a.articleSearch='150062110' AND a.supplierId=323) OR ( a.articleSearch IN ('CRS71028AS', 'CRS71028GS') AND a.supplierId=484) OR (a.articleSearch='CRV9084' AND a.supplierId=4334) OR (a.articleSearch='673082' AND a.supplierId=355) OR ( a.articleSearch IN ('EH1090', 'XHR0091') AND a.supplierId=4344) OR (a.articleSearch='665108' AND a.supplierId=234) OR (a.articleSearch='95SKV041' AND a.supplierId=4969) OR (a.articleSearch='109084' AND a.supplierId=441) OR (a.articleSearch='3510074' AND a.supplierId=313) OR (a.articleSearch='RE35109' AND a.supplierId=6456) OR (a.articleSearch='261409' AND a.supplierId=4819) OR (a.articleSearch='9ML351332251' AND a.supplierId=4734) OR (a.articleSearch='75614923' AND a.supplierId=72) OR (a.articleSearch='K109084' AND a.supplierId=341) OR (a.articleSearch='109084' AND a.supplierId=4399) OR ( a.articleSearch IN ('LGK026079028', 'OEM026079028') AND a.supplierId=6012) OR (a.articleSearch='ABR90000P' AND a.supplierId=287) OR (a.articleSearch='570109' AND a.supplierId=403) OR (a.articleSearch='K109084' AND a.supplierId=244) OR (a.articleSearch='0917073' AND a.supplierId=94) OR (a.articleSearch='ERDRE003' AND a.supplierId=6355) OR ( a.articleSearch IN ('40073820BN', '40073820OE') AND a.supplierId=6335) OR (a.articleSearch='1385C0047' AND a.supplierId=6358) OR ( a.articleSearch IN ('SRS710280', 'SRS710281') AND a.supplierId=4592) OR (a.articleSearch='109084' AND a.supplierId=27) OR (a.articleSearch='SKCU2150046' AND a.supplierId=6357) OR (a.articleSearch='888706' AND a.supplierId=6691) OR (a.articleSearch='DEX006TT' AND a.supplierId=4466) OR (a.articleSearch='701808' AND a.supplierId=301) OR (a.articleSearch='V46790006' AND a.supplierId=183) OR (a.articleSearch='K109084' AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1778306', 'WG2160274') AND a.supplierId=4832) OR (a.articleSearch='ZVYL7742' AND a.supplierId=6274) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Opel (пасажирский) -> Opel MOVANO Combi (X70) ->Opel 3.0 DTi (JD), 10.2003- выпускается, , 136 ->Приборы управления