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 ('ASOPASH', 'AST1539', 'ASNY62', 'ASTGX90') AND a.supplierId=4674) OR (a.articleSearch='CS1539' AND a.supplierId=4600) OR (a.articleSearch='BSG65365004' AND a.supplierId=4455) OR (a.articleSearch='758543' AND a.supplierId=405) OR (a.articleSearch='MST1539' AND a.supplierId=6270) OR (a.articleSearch='39325' AND a.supplierId=4664) OR ( a.articleSearch IN ('NKWUU000', 'SKKME000', 'SKKUU002') AND a.supplierId=6355) OR (a.articleSearch='PUJ1516' AND a.supplierId=4558) OR ( a.articleSearch IN ('QF01E00023', 'QF13C00005') AND a.supplierId=4339) OR (a.articleSearch='T439325' AND a.supplierId=4667) OR (a.articleSearch='2036007SX' AND a.supplierId=4595) OR (a.articleSearch='CC912' AND a.supplierId=4772) OR ( a.articleSearch IN ('ZVRK005', 'ZVRK014') AND a.supplierId=6274)
-- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск
