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 ('B17962', 'B17963') AND a.supplierId=4815) OR ( a.articleSearch IN ('99051786501', '99051786601') AND a.supplierId=4346) OR (a.articleSearch='56270' AND a.supplierId=6558) OR (a.articleSearch='1K0905851B' AND a.supplierId=6366) OR ( a.articleSearch IN ('101017', '107816', '107817', '36044') AND a.supplierId=101) OR (a.articleSearch='105000011' AND a.supplierId=4524) OR (a.articleSearch='1190450800' AND a.supplierId=268) OR (a.articleSearch='630059' AND a.supplierId=403) OR ( a.articleSearch IN ('ESTVW000', 'ESTVW001') AND a.supplierId=6355) OR (a.articleSearch='21990' AND a.supplierId=4683) OR ( a.articleSearch IN ('30101017', '30107816', '30107817', '30936044') AND a.supplierId=151) OR (a.articleSearch='114221' AND a.supplierId=301) OR ( a.articleSearch IN ('V105316', 'V15800013') AND a.supplierId=183) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw CADDY III Фургон (2KA, 2KH, 2CA, 2CH) ->Vw 2.0 SDI, 03.2004- 08.2010, , 70 ->Внутренний замок