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 ('SM5085', 'SH4025P') AND a.supplierId=225) OR ( a.articleSearch IN ('802001560', '802002940', '802003050') AND a.supplierId=6376) OR ( a.articleSearch IN ('ADV182107', 'ADV182104', 'ADV182122') AND a.supplierId=350) OR ( a.articleSearch IN ('B10527', 'B12814', 'B12821') AND a.supplierId=4815) OR ( a.articleSearch IN ('1457429301', 'F026407181', 'F026407183') AND a.supplierId=30) OR ( a.articleSearch IN ('BSG90140014', 'BSG90140019', 'BSG90140020') AND a.supplierId=4455) OR ( a.articleSearch IN ('COF100540E', 'COF100622S', 'C286606', 'COF101286S', 'XE540606') AND a.supplierId=43) OR ( a.articleSearch IN ('DO5509', 'DO5519', 'ML1726') AND a.supplierId=163) OR (a.articleSearch='B160P0011' AND a.supplierId=6476) OR ( a.articleSearch IN ('1611660880', 'E149120') AND a.supplierId=4391) OR ( a.articleSearch IN ('37441', '38599', '49665', '49666') AND a.supplierId=101) OR ( a.articleSearch IN ('MLE1418', 'ZP3250', 'ZP3250MG') AND a.supplierId=4659) OR ( a.articleSearch IN ('OE6502', 'OP6411', 'OP6412') AND a.supplierId=256) OR (a.articleSearch='LF911' AND a.supplierId=4741) OR ( a.articleSearch IN ('CH9706ECO', 'PH10757A', 'PH10757') AND a.supplierId=6356) OR ( a.articleSearch IN ('OG118', 'OG200ECO') AND a.supplierId=4663) OR ( a.articleSearch IN ('E320H01D84', 'H312W01', 'H314W01', 'H312W', 'H314W') AND a.supplierId=81) OR ( a.articleSearch IN ('1118500600', '1118500700', '1118506100') AND a.supplierId=268) OR ( a.articleSearch IN ('C0071', 'C0080', 'OE0042') AND a.supplierId=4378) OR ( a.articleSearch IN ('OC5933', 'OC5934', 'OX341D') AND a.supplierId=287) OR ( a.articleSearch IN ('50013682', '50014298', '50014544') AND a.supplierId=432) OR ( a.articleSearch IN ('LC1041', 'LC1902', 'LO1040', 'LK3077', 'LK30771', 'LK3080', 'LK30801', 'LK3082', 'LK4015', 'LK4017', 'LK4021', 'LK40211', 'LK4023', 'LK40231', 'LK4026', 'LK40261', 'LK4028', 'LK40281', 'LK4030', 'LK4031', 'LK4033') AND a.supplierId=4600) OR ( a.articleSearch IN ('152071760690', '153071762341', '153071762457') AND a.supplierId=4723) OR ( a.articleSearch IN ('EEOW0002Y', 'MMF045151') AND a.supplierId=4570) OR ( a.articleSearch IN ('HU7126X', 'W71293', 'W71294', 'W71290', 'W71291') AND a.supplierId=4) OR ( a.articleSearch IN ('64811', '64903', '64908') AND a.supplierId=133) OR ( a.articleSearch IN ('14077', '15566', '15575') AND a.supplierId=244) OR ( a.articleSearch IN ('ELH4356', 'ELH4400', 'ELH4505', 'ELH4400X') AND a.supplierId=218) OR ( a.articleSearch IN ('1003220015', '1001150014') AND a.supplierId=144) OR ( a.articleSearch IN ('TF6533', 'TF6539', 'TE4016') AND a.supplierId=462) OR ( a.articleSearch IN ('AFOS071', 'AFOS077', 'AFOE029') AND a.supplierId=6495) OR ( a.articleSearch IN ('17110', '05775', '12491') AND a.supplierId=4683) OR ( a.articleSearch IN ('PF4200', 'PF4231') AND a.supplierId=4558) OR (a.articleSearch='15410183' AND a.supplierId=4686) OR ( a.articleSearch IN ('C31080', 'C31081', 'EO31950') AND a.supplierId=6405) OR ( a.articleSearch IN ('2050341SX', '2050505SX', '2050624SX', '2050744SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('2349400', '2357300', '2504700') AND a.supplierId=137) OR ( a.articleSearch IN ('11150059501', '11150314301', '11151768601', '13050755401', 'K11783501') AND a.supplierId=4346) OR ( a.articleSearch IN ('OF4030', 'OF4336E') AND a.supplierId=4894) OR ( a.articleSearch IN ('E50248', 'L40632', 'L40634') AND a.supplierId=4814) OR (a.articleSearch='19372679' AND a.supplierId=6307) OR ( a.articleSearch IN ('1510081', '1510124', '1510223') AND a.supplierId=317) OR ( a.articleSearch IN ('MD535', 'SP1350', 'SP1373') AND a.supplierId=180) OR ( a.articleSearch IN ('X1524540', 'X1596411', 'X1596412') AND a.supplierId=4975) OR ( a.articleSearch IN ('70104', '77659', '77701') AND a.supplierId=4576) OR (a.articleSearch='10ECO092' AND a.supplierId=257) OR (a.articleSearch='PAL28029' AND a.supplierId=442) OR ( a.articleSearch IN ('LATH68', 'LATH68X', 'LATI35') AND a.supplierId=4337) OR ( a.articleSearch IN ('LA115', 'Z104', 'ZA180') AND a.supplierId=4280) OR (a.articleSearch='80259' AND a.supplierId=208) OR ( a.articleSearch IN ('BFO4079', 'BFO4158', 'BFO4179') AND a.supplierId=475) OR (a.articleSearch='BSP21679' AND a.supplierId=157) OR ( a.articleSearch IN ('EOF171', 'EOF226', 'EOF250') AND a.supplierId=421) OR ( a.articleSearch IN ('28000221002', '28000221062', '28000221292') AND a.supplierId=6513) OR ( a.articleSearch IN ('FA5675ECO', 'FT6035') AND a.supplierId=437) OR ( a.articleSearch IN ('A210176', 'A210401', 'A210672') AND a.supplierId=186) OR ( a.articleSearch IN ('DL1225', 'DL1263', 'DL1284') AND a.supplierId=4396) OR ( a.articleSearch IN ('1110020036', '1110020061') AND a.supplierId=4345) OR ( a.articleSearch IN ('DP1110110091', 'DP1110110113', 'DP1110110164') AND a.supplierId=4948) OR ( a.articleSearch IN ('DOFC5933', 'DOFC5934', 'DOFX341D') AND a.supplierId=4881) OR ( a.articleSearch IN ('F579', 'F590', 'F659') AND a.supplierId=4838) OR (a.articleSearch='CT10718' AND a.supplierId=313) OR ( a.articleSearch IN ('SO7145', 'SO7211', 'SO7229') AND a.supplierId=6309) OR ( a.articleSearch IN ('14077', '15566', '15575') AND a.supplierId=341) OR (a.articleSearch='FOECO092' AND a.supplierId=156) OR (a.articleSearch='1ECO092' AND a.supplierId=481) OR (a.articleSearch='B1W036PR' AND a.supplierId=4689) OR ( a.articleSearch IN ('F109801', 'F114701', 'F114801') AND a.supplierId=185) OR ( a.articleSearch IN ('FH099Z', 'FH138Z') AND a.supplierId=387) OR ( a.articleSearch IN ('1700320', '1700400') AND a.supplierId=4546) OR ( a.articleSearch IN ('LFOE235', 'LFOS111', 'LFOS111X', 'LFOS319') AND a.supplierId=4973) OR ( a.articleSearch IN ('450002023', '450002033', '450002183', '450002193', '450002203', '7126XOFPCSMS', '71290OFPCSMS', '71291OFPCSMS') AND a.supplierId=358) OR ( a.articleSearch IN ('MFCE409', 'MFCE418') AND a.supplierId=6270) OR ( a.articleSearch IN ('260314', '260871', '260873') AND a.supplierId=403) OR (a.articleSearch='MOF3E92' AND a.supplierId=4773) OR (a.articleSearch='2370067' AND a.supplierId=94) OR ( a.articleSearch IN ('L115', 'Z140', 'Z140X') AND a.supplierId=4470) OR ( a.articleSearch IN ('LVFL747', 'LVFL790', 'VFL517') AND a.supplierId=4564) OR ( a.articleSearch IN ('FO632', 'FO634', 'FOP248') AND a.supplierId=490) OR ( a.articleSearch IN ('2136206', '2145116', '2145118') AND a.supplierId=4380) OR ( a.articleSearch IN ('EOF409810', 'EOF420520', 'EOF423920') AND a.supplierId=378) OR ( a.articleSearch IN ('FO00039', 'FO00265') AND a.supplierId=129) OR ( a.articleSearch IN ('L353', 'LS391') AND a.supplierId=38) OR ( a.articleSearch IN ('QFL0066', 'QFL0228', 'QFL0306') AND a.supplierId=57) OR ( a.articleSearch IN ('7O0036', '7O0037', '7O0082') AND a.supplierId=6358) OR (a.articleSearch='CE1057E' AND a.supplierId=4263) OR ( a.articleSearch IN ('S3494R', 'S3573R', 'S5047PE') AND a.supplierId=142) OR ( a.articleSearch IN ('SKOF0860035', 'SKOF0860036', 'SKOF0860081') AND a.supplierId=6357) OR ( a.articleSearch IN ('30937441', '30938599', '30949665', '30949666') AND a.supplierId=151) OR ( a.articleSearch IN ('OL09706E', 'OL71290', 'OL71294') AND a.supplierId=4011) OR ( a.articleSearch IN ('OP248', 'R722') AND a.supplierId=91) OR ( a.articleSearch IN ('110053', '112937', '113149') AND a.supplierId=301) OR ( a.articleSearch IN ('0718049', '0718060', '0718061') AND a.supplierId=209) OR ( a.articleSearch IN ('V100665', 'V102102', 'V105897', 'V109599') AND a.supplierId=183) OR ( a.articleSearch IN ('586092', '586141', '586598') AND a.supplierId=21) OR (a.articleSearch='VE80259' AND a.supplierId=4425) OR ( a.articleSearch IN ('14077', '15566', '15575') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1018584', 'WG1019139', 'WG1019272', 'WG1217203', 'WG1217204', 'WG1217355', 'WG1429072', 'WG1746601', 'WG1746744', 'WG1746750', 'WG1889882', 'WG1889883') AND a.supplierId=4832) OR ( a.articleSearch IN ('WL7410', 'WL7467', 'WL7494') AND a.supplierId=324) OR (a.articleSearch='311987' AND a.supplierId=6347)
    -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
    GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
An internal server error occurred.