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='AP8258' AND a.supplierId=178) OR (a.articleSearch='570564N' AND a.supplierId=80) OR (a.articleSearch='0392023015' AND a.supplierId=30) OR (a.articleSearch='CBA5201' AND a.supplierId=4334) OR (a.articleSearch='DP293' AND a.supplierId=42) OR (a.articleSearch='R230' AND a.supplierId=154) OR ( a.articleSearch IN ('630032', '673160') AND a.supplierId=355) OR (a.articleSearch='22SKV024' AND a.supplierId=4969) OR (a.articleSearch='FT57181' AND a.supplierId=4938) OR (a.articleSearch='55201' AND a.supplierId=441) OR (a.articleSearch='30085' AND a.supplierId=6305) OR (a.articleSearch='PA12537' AND a.supplierId=368) OR (a.articleSearch='998258' AND a.supplierId=181) OR (a.articleSearch='AWP025' AND a.supplierId=310) OR (a.articleSearch='7500050' AND a.supplierId=341) OR (a.articleSearch='T0222' AND a.supplierId=185) OR (a.articleSearch='42194Z' AND a.supplierId=387) OR (a.articleSearch='11025' AND a.supplierId=312) OR (a.articleSearch='LAWP1094' AND a.supplierId=4501) OR (a.articleSearch='CW0367' AND a.supplierId=4600) OR (a.articleSearch='20050' AND a.supplierId=244) OR (a.articleSearch='250025' AND a.supplierId=121) OR (a.articleSearch='VWP870' AND a.supplierId=4564) OR (a.articleSearch='WAP846400' AND a.supplierId=378) OR (a.articleSearch='AQ2207' AND a.supplierId=129) OR (a.articleSearch='10790020' AND a.supplierId=4837) OR (a.articleSearch='PE1674' AND a.supplierId=245) OR (a.articleSearch='55201' AND a.supplierId=27) OR (a.articleSearch='45000298SX' AND a.supplierId=4595) OR (a.articleSearch='SYNC40369' AND a.supplierId=6394) OR (a.articleSearch='V30160004' AND a.supplierId=183) OR (a.articleSearch='441450052' AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1780048', 'WG2006059') AND a.supplierId=4832) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Opel (пасажирский) -> Opel VIVARO A c бортовой платформой/ходовая часть (X83) ->Opel 2.0 CDTI, 08.2006- 07.2014, , 114 ->Автономное отопление