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 ('B13146', 'B11960', 'B11978') AND a.supplierId=4815) OR ( a.articleSearch IN ('1830378', '1830278', '73378', '73278') AND a.supplierId=4005) OR ( a.articleSearch IN ('29318', '106318', '12409', '33911') AND a.supplierId=101) OR (a.articleSearch='TSN22736' AND a.supplierId=271) OR ( a.articleSearch IN ('01308', '29912', '47897') AND a.supplierId=4683) OR ( a.articleSearch IN ('30929318', '30106318', '30220002', '30933911') AND a.supplierId=151) OR ( a.articleSearch IN ('99190078301', '99190079801', '11211792101', '11211841801', '93160080701', '99191792301') AND a.supplierId=4346) OR (a.articleSearch='81786' AND a.supplierId=4598) OR ( a.articleSearch IN ('51169', '56481') AND a.supplierId=6558) OR ( a.articleSearch IN ('16013800', '16015400', '16075500') AND a.supplierId=139) OR (a.articleSearch='751013N' AND a.supplierId=80) OR (a.articleSearch='XS2607' AND a.supplierId=4975) OR (a.articleSearch='105557' AND a.supplierId=4495) OR (a.articleSearch='AS2004' AND a.supplierId=4737) OR ( a.articleSearch IN ('150011110', '190013310') AND a.supplierId=323) OR (a.articleSearch='PES0095' AND a.supplierId=4337) OR (a.articleSearch='0023001087' AND a.supplierId=4995) OR (a.articleSearch='ST114' AND a.supplierId=6444) OR (a.articleSearch='OR5303' AND a.supplierId=478) OR ( a.articleSearch IN ('BTS3028', 'BTS3079') AND a.supplierId=475) OR (a.articleSearch='WS2607' AND a.supplierId=215) OR ( a.articleSearch IN ('755123', '955245') AND a.supplierId=405) OR ( a.articleSearch IN ('CST9335', 'CST9336', 'CST9336C', 'CST9527', 'CST9538') AND a.supplierId=4334) OR (a.articleSearch='TS10278' AND a.supplierId=89) OR (a.articleSearch='INJSWS002N' AND a.supplierId=4882) OR (a.articleSearch='DS1017' AND a.supplierId=471) OR (a.articleSearch='468269' AND a.supplierId=355) OR ( a.articleSearch IN ('295166', '295188') AND a.supplierId=211) OR (a.articleSearch='074290' AND a.supplierId=10) OR ( a.articleSearch IN ('EV0002', 'XTS7702') AND a.supplierId=4344) OR (a.articleSearch='330546' AND a.supplierId=234) OR (a.articleSearch='06A919501' AND a.supplierId=6367) OR ( a.articleSearch IN ('33784', '33892') AND a.supplierId=240) OR (a.articleSearch='15891' AND a.supplierId=4834) OR ( a.articleSearch IN ('FTS3028', 'FTS3079') AND a.supplierId=407) OR ( a.articleSearch IN ('82335', '82336', '82336A2', '82527') AND a.supplierId=441) OR (a.articleSearch='FSE51169' AND a.supplierId=236) OR (a.articleSearch='2940053' AND a.supplierId=313) OR (a.articleSearch='CSS0001' AND a.supplierId=6443) OR (a.articleSearch='120000034' AND a.supplierId=4524) OR (a.articleSearch='6PT009309331' AND a.supplierId=4734) OR (a.articleSearch='70511539' AND a.supplierId=72) OR ( a.articleSearch IN ('7472128', '7472427', '7472428', '7472428E') AND a.supplierId=341) OR ( a.articleSearch IN ('55106', '55595', '55597') AND a.supplierId=269) OR (a.articleSearch='SD12312' AND a.supplierId=6387) OR ( a.articleSearch IN ('1119606800', '1193101400') AND a.supplierId=268) OR (a.articleSearch='ECT5503' AND a.supplierId=201) OR ( a.articleSearch IN ('862610042', '862629012') AND a.supplierId=286) OR ( a.articleSearch IN ('530278', '530378') AND a.supplierId=4006) OR ( a.articleSearch IN ('LWS053', 'LWS139', 'LWS141') AND a.supplierId=6518) OR ( a.articleSearch IN ('SNB5068', 'SNB5070', 'SNB964') AND a.supplierId=4501) OR (a.articleSearch='171916011110' AND a.supplierId=4723) OR (a.articleSearch='88800' AND a.supplierId=133) OR ( a.articleSearch IN ('210140', '211047') AND a.supplierId=403) OR ( a.articleSearch IN ('EPS1830278', 'EPS1830378') AND a.supplierId=4773) OR ( a.articleSearch IN ('82128', '82427', '82428', '82428E') AND a.supplierId=244) OR ( a.articleSearch IN ('02110', '50288') AND a.supplierId=4664) OR ( a.articleSearch IN ('0905022', '0905466') AND a.supplierId=94) OR ( a.articleSearch IN ('1001210095', '1009190032', '1148210010') AND a.supplierId=144) OR ( a.articleSearch IN ('LVCT468', 'LVCT472', 'VCT131') AND a.supplierId=4564) OR (a.articleSearch='4092' AND a.supplierId=320) OR (a.articleSearch='N5625008' AND a.supplierId=248) OR (a.articleSearch='ECTVW000' AND a.supplierId=6355) OR ( a.articleSearch IN ('AQ22791', 'AQ23851') AND a.supplierId=129) OR (a.articleSearch='PE13166' AND a.supplierId=4558) OR (a.articleSearch='QF25A00019' AND a.supplierId=4339) OR (a.articleSearch='XTT159' AND a.supplierId=57) OR (a.articleSearch='830C0019' AND a.supplierId=6358) OR (a.articleSearch='0963689' AND a.supplierId=4623) OR (a.articleSearch='3256001' AND a.supplierId=260) OR (a.articleSearch='E534406' AND a.supplierId=6377) OR ( a.articleSearch IN ('82335', '82336', '82336A2', '82527') AND a.supplierId=27) OR (a.articleSearch='SKCTS0850018' AND a.supplierId=6357) OR ( a.articleSearch IN ('T402110', 'T450288') AND a.supplierId=4667) OR (a.articleSearch='0604007SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('104529', '109896', '116269') AND a.supplierId=301) OR (a.articleSearch='463699' AND a.supplierId=4970) OR ( a.articleSearch IN ('862610042', '862629012') AND a.supplierId=108) OR (a.articleSearch='0742077' AND a.supplierId=209) OR ( a.articleSearch IN ('032121142', '037121132E', '06A919501A') AND a.supplierId=4999) OR (a.articleSearch='700105' AND a.supplierId=21) OR ( a.articleSearch IN ('V10721309', 'V10990001', 'V15992114', 'V99990001') AND a.supplierId=183) OR (a.articleSearch='2111056' AND a.supplierId=303) OR ( a.articleSearch IN ('410580087', '410580199', '410580200', '410580389') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1407325', 'WG1428761', 'WG1492521', 'WG1499634', 'WG1748849') AND a.supplierId=4832) OR ( a.articleSearch IN ('320489', '350401') AND a.supplierId=6347)
    -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
    GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
An internal server error occurred.