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 ('1830258', '73146', '73258', '1830086', '1830146', '1830535', '1840104', '73086', '73535', '74104') AND a.supplierId=4005) OR ( a.articleSearch IN ('330141', '330151', '330287', '330288', '330496', '330103', '330850', '661132') AND a.supplierId=234) OR ( a.articleSearch IN ('1199208200', '1193101200', '1193101600', '1193101700', '1193201600', '1193201700', '1193201800') AND a.supplierId=268) OR ( a.articleSearch IN ('1008100007', '1009190017', '1009190024', '1008009053', '1008009054', '1009190023') AND a.supplierId=144) OR ( a.articleSearch IN ('107258', '103327', '103568', '104108', '104109', '109000', '109385') AND a.supplierId=301) OR ( a.articleSearch IN ('99110119801', '99190078801', '99190079401', '99190079601', '99190079901', '99190080501', '99191782501', '99191782601', '99191796201') AND a.supplierId=4346) OR ( a.articleSearch IN ('GR081', 'ST030', 'ST115', 'ST119') AND a.supplierId=6444) OR (a.articleSearch='82790' AND a.supplierId=4598) OR ( a.articleSearch IN ('ASTR0831', 'ASTR083B1', 'ASTR117', 'ASTR1392', 'ASTR139B2') AND a.supplierId=374) OR ( a.articleSearch IN ('50818', '50821', '51167', '55317', '55318', '56480', '57295', '58110') AND a.supplierId=6558) OR ( a.articleSearch IN ('751027N', '751029N') AND a.supplierId=80) OR ( a.articleSearch IN ('XS2576', 'XS2604') AND a.supplierId=4975) OR ( a.articleSearch IN ('AS2001', 'AS2007', 'AS2018', 'AS2175') AND a.supplierId=4737) OR ( a.articleSearch IN ('150007610', '150009710', '150012610', '150019810', '150038910', '160065410') AND a.supplierId=323) OR (a.articleSearch='PES0194' AND a.supplierId=4337) OR ( a.articleSearch IN ('BTS3001', 'BTS3002', 'BTS3035') AND a.supplierId=475) OR ( a.articleSearch IN ('B13132', 'B13134') AND a.supplierId=4815) OR (a.articleSearch='251919501D' AND a.supplierId=6366) OR ( a.articleSearch IN ('TS2959', 'WS2576', 'WS2579', 'WS2604', 'WS2625') AND a.supplierId=215) OR (a.articleSearch='CCU081' AND a.supplierId=43) OR ( a.articleSearch IN ('CRP5679', 'CST9538', 'CST9539', 'CST9699', 'CST9701', 'CST9976') AND a.supplierId=4334) OR ( a.articleSearch IN ('TS10236', 'TS1023612B1', 'TS10245', 'TS1024512B1', 'TS10275', 'TS10282') AND a.supplierId=89) OR ( a.articleSearch IN ('INJSWS001N', 'INJSWS003N') AND a.supplierId=4882) OR (a.articleSearch='DS1010' AND a.supplierId=471) OR ( a.articleSearch IN ('1040300002', '1040300003', '1040300023', '1040300024', '1040300030', '1040300031') AND a.supplierId=4345) OR (a.articleSearch='1180610' AND a.supplierId=355) OR ( a.articleSearch IN ('295127', '295129', '295163', '295165') AND a.supplierId=211) OR ( a.articleSearch IN ('EV0008', 'EV0038', 'EV0268', 'XTS7708', 'XTS7739', 'XTS7853') AND a.supplierId=4344) OR ( a.articleSearch IN ('059919501A', '357919501A') AND a.supplierId=6367) OR ( a.articleSearch IN ('33620', '33640', '33781', '33783', '34330', '35590') AND a.supplierId=240) OR ( a.articleSearch IN ('18666', '19036', '26103', '30616', '32510', '37028', '37498', '39142') AND a.supplierId=101) OR ( a.articleSearch IN ('TSN22619', 'TSN22949') AND a.supplierId=271) OR ( a.articleSearch IN ('FTS3001', 'FTS3002', 'FTS3035') AND a.supplierId=407) OR ( a.articleSearch IN ('285679', '821326', '82443', '82538', '82539', '82699', '82701', '82976') AND a.supplierId=441) OR (a.articleSearch='29911004S' AND a.supplierId=4727) OR (a.articleSearch='2940054' AND a.supplierId=313) OR (a.articleSearch='994131' AND a.supplierId=4379) OR (a.articleSearch='GV15710004' AND a.supplierId=6456) OR ( a.articleSearch IN ('120000033', '120000035') AND a.supplierId=4524) OR ( a.articleSearch IN ('4RA007507021', '6PT009107141', '6PT009107241', '6PT009107421', '6ZT010967151') AND a.supplierId=4734) OR ( a.articleSearch IN ('70511015', '70511263', '70511509', '70511511', '75614048') AND a.supplierId=72) OR ( a.articleSearch IN ('7472038', '7472050', '7472104', '7472105', '7472617', '7472618', '7472725', 'H7285679') AND a.supplierId=341) OR ( a.articleSearch IN ('52302', '53235', '53599', '55103', '55141', '55142') AND a.supplierId=269) OR (a.articleSearch='10095BL' AND a.supplierId=6277) OR ( a.articleSearch IN ('SD12091', 'SD12098', 'SD12302', 'SD12307') AND a.supplierId=6387) OR ( a.articleSearch IN ('862629001', '862629006', '862629007') AND a.supplierId=286) OR ( a.articleSearch IN ('163364Z', '1633783Z') AND a.supplierId=387) OR ( a.articleSearch IN ('530086', '530146', '530258', '530535', '540104') AND a.supplierId=4006) OR ( a.articleSearch IN ('LWS019', 'LWS039', 'LWS169', 'LWS254', 'LWS286') AND a.supplierId=6518) OR ( a.articleSearch IN ('SNB171', 'SNB239', 'SNB855', 'SNB890', 'SNB935') AND a.supplierId=4501) OR ( a.articleSearch IN ('171916011050', '171916011090', '171916011100') AND a.supplierId=4723) OR ( a.articleSearch IN ('TSE24', 'TSE7') AND a.supplierId=287) OR ( a.articleSearch IN ('88801', '88803', '88804') AND a.supplierId=133) OR ( a.articleSearch IN ('210132', '210134', '210141', '210165', '210168', '500226') AND a.supplierId=403) OR ( a.articleSearch IN ('EPS1830086', 'EPS1830146', 'EPS1830258', 'EPS1830535', 'EPS1840104') AND a.supplierId=4773) OR ( a.articleSearch IN ('7285679', '82038', '82050', '82104', '82105', '82617', '82618', '82725') AND a.supplierId=244) OR ( a.articleSearch IN ('0905015', '0905020', '0905099', '0905228', '0905447', '0905465', '0915046') AND a.supplierId=94) OR ( a.articleSearch IN ('LVCT334', 'LVCT421', 'LVCT447', 'VCT133', 'VCT134') AND a.supplierId=4564) OR ( a.articleSearch IN ('3152', '3170', '4014', '4018', '4034', '851') AND a.supplierId=320) OR ( a.articleSearch IN ('01051', '01094', '01100', '03816', '04500', '11968') AND a.supplierId=4683) OR ( a.articleSearch IN ('P270002', 'PE13016', 'PE13147', 'PE13155', 'PE13157', 'PE13179') AND a.supplierId=4558) OR (a.articleSearch='QF25A00012' AND a.supplierId=4339) OR ( a.articleSearch IN ('XEMS41', 'XEMS56', 'XEMS91', 'XTS60', 'XTT99', 'XTTS33') AND a.supplierId=57) OR ( a.articleSearch IN ('830C0009', '830C0015', '830C0020') AND a.supplierId=6358) OR ( a.articleSearch IN ('3256004', '3256012', '3256013', '3806028') AND a.supplierId=260) OR ( a.articleSearch IN ('E534400', 'E534402', 'E534407', 'E534430') AND a.supplierId=6377) OR ( a.articleSearch IN ('285679', '821326', '82443', '82538', '82539', '82699', '82701', '82976') AND a.supplierId=27) OR ( a.articleSearch IN ('SKCTS0850008', 'SKCTS0850014', 'SKCTS0850019') AND a.supplierId=6357) OR ( a.articleSearch IN ('0601001SX', '0604001SX', '0604002SX', '0604021SX', '0604108SX', '0604126SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30918666', '30919036', '30930616', '30932510', '30937028', '30937498', '32939142') AND a.supplierId=151) OR ( a.articleSearch IN ('862629001', '862629006', '862629007') AND a.supplierId=108) OR (a.articleSearch='0742011' AND a.supplierId=209) OR (a.articleSearch='13621284397' AND a.supplierId=4999) OR ( a.articleSearch IN ('700012', '700104') AND a.supplierId=21) OR ( a.articleSearch IN ('V107209081', 'V107209101', 'V10720915', 'V10990125', 'V15710004', 'V15992014') AND a.supplierId=183) OR ( a.articleSearch IN ('2111110', '2111111', '2111112') AND a.supplierId=303) OR ( a.articleSearch IN ('240670031', '410580021', '410580032', '410580074', '410580075', '410580256', '410580257', '410580356') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1015154', 'WG1015159', 'WG1407259', 'WG1428879', 'WG1445345', 'WG1445363', 'WG1484362', 'WG1486242', 'WG1492406', 'WG1492450', 'WG1492465', 'WG1492466', 'WG1492508', 'WG1496169', 'WG1499599', 'WG1499603', 'WG1499632', 'WG1499638', 'WG1748912') AND a.supplierId=4832) OR ( a.articleSearch IN ('320409', '320415', '320423', '320437', '320439', '320457', '320575', '321099', '330297', '330301') AND a.supplierId=6347) OR (a.articleSearch='TSE7' AND a.supplierId=382)
    -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
    GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
An internal server error occurred.