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='1199206000' AND a.supplierId=268) OR ( a.articleSearch IN ('1009370001', '1148300001', '1008300016') AND a.supplierId=144) OR ( a.articleSearch IN ('0242272', '0742064') AND a.supplierId=209) OR ( a.articleSearch IN ('56499', '56681') AND a.supplierId=6558) OR (a.articleSearch='91117' AND a.supplierId=4495) OR ( a.articleSearch IN ('150021010', '150025710') AND a.supplierId=323) OR ( a.articleSearch IN ('B17802', 'B17811', 'B17820') AND a.supplierId=4815) OR ( a.articleSearch IN ('0332201107', '0332207302', '0332207307', '0332207310', '0332207321', '0986332001', '0986332002', '0986332004', '0332207102', '0332207107', '0332207300', '0332207101', '0332207110', '0332207301', '0986332023') AND a.supplierId=30) OR (a.articleSearch='BREL9024' AND a.supplierId=6371) OR ( a.articleSearch IN ('CRE5005', 'CRE9001', 'CRV6002') AND a.supplierId=4334) OR (a.articleSearch='SSPR008N' AND a.supplierId=4882) OR (a.articleSearch='466517' AND a.supplierId=355) OR ( a.articleSearch IN ('661116', '661126', '661165', '661378') AND a.supplierId=234) OR ( a.articleSearch IN ('107803', '34751') AND a.supplierId=101) OR ( a.articleSearch IN ('3232001', '3232304', '3250001', '3250002', '3250005', '3232006') AND a.supplierId=441) OR (a.articleSearch='783601701' AND a.supplierId=6484) OR ( a.articleSearch IN ('GE0025', 'GE0036', 'GE0048', 'GE0050', 'GE0057') AND a.supplierId=4933) OR ( a.articleSearch IN ('990561', '990851', '991381') AND a.supplierId=4379) OR (a.articleSearch='160000014' AND a.supplierId=4524) OR (a.articleSearch='181719' AND a.supplierId=4819) OR ( a.articleSearch IN ('4RA933332531', '4RD007814011', '4RD965453041', '4RD965453047', '4RD965453801') AND a.supplierId=4734) OR ( a.articleSearch IN ('75613169', '75613177', '75614601', '75613174') AND a.supplierId=72) OR ( a.articleSearch IN ('132202', '132203', '2502202', '2502203') AND a.supplierId=449) OR ( a.articleSearch IN ('7232001', '7232304', '7250002', '7250005', '7250007', '7232006') AND a.supplierId=341) OR ( a.articleSearch IN ('MR26', 'MR3', 'MR35', 'MR37') AND a.supplierId=287) OR ( a.articleSearch IN ('500334', '500336') AND a.supplierId=403) OR (a.articleSearch='73250005' AND a.supplierId=244) OR (a.articleSearch='01303' AND a.supplierId=4683) OR (a.articleSearch='207314' AND a.supplierId=4623) OR ( a.articleSearch IN ('3232001', '3232304', '3250001', '3250002', '3250005', '3232006') AND a.supplierId=27) OR (a.articleSearch='8811012SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('30107803', '30934751') AND a.supplierId=151) OR ( a.articleSearch IN ('109544', '115664') AND a.supplierId=301) OR ( a.articleSearch IN ('30765031', '7M0951253A') AND a.supplierId=4999) OR (a.articleSearch='643827' AND a.supplierId=21) OR ( a.articleSearch IN ('V15710007', 'V15710040', 'V30710033', 'V30710045', 'V40710003') AND a.supplierId=183) OR ( a.articleSearch IN ('99510091801', '99510119701', '99510813101') AND a.supplierId=4346) OR ( a.articleSearch IN ('240670087', '240670092', '240670135', '240670137', '240670151', '240670145') AND a.supplierId=4275) OR ( a.articleSearch IN ('350463', '350495') AND a.supplierId=6347)
-- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск