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='70241' AND a.supplierId=4576) OR ( a.articleSearch IN ('180013010', '180010410', '180014110') AND a.supplierId=323) OR ( a.articleSearch IN ('0450906267', '0450906172', '0450906174', '0450906274', '0450906334', '0986424176', '0986460947', '0986467841', '0450906101', '0450906161', '0450906275', '0450906276', '0986467840') AND a.supplierId=30) OR ( a.articleSearch IN ('P50003', 'P50003N', 'P50134', 'P50134N') AND a.supplierId=65) OR ( a.articleSearch IN ('BSG60200001', 'BSG90130012', 'BSG90130037', 'BSG90130039') AND a.supplierId=4455) OR ( a.articleSearch IN ('DN829', 'DN829T', 'DN1929', 'DN325') AND a.supplierId=163) OR ( a.articleSearch IN ('LP468', 'HDF507', 'HDF506', 'HDF516', 'HDF519', 'LP697', 'LP698', 'LP735') AND a.supplierId=89) OR ( a.articleSearch IN ('E148105', 'E148155', 'E148162') AND a.supplierId=4391) OR ( a.articleSearch IN ('16033', '21600', '40607', '103811', '21597', '39732') AND a.supplierId=101) OR ( a.articleSearch IN ('PP839', 'PP837', 'PP838', 'PP8392', 'PP8396') AND a.supplierId=256) OR ( a.articleSearch IN ('P5328', 'P4183', 'P4836', 'PS5937') AND a.supplierId=6356) OR (a.articleSearch='5034' AND a.supplierId=6665) OR ( a.articleSearch IN ('140405', '140405113', '140814') AND a.supplierId=158) OR ( a.articleSearch IN ('1118702700', '1118702600', '1118702900', '1163601410') AND a.supplierId=268) OR ( a.articleSearch IN ('KL75', 'KL180', 'KL41', 'KL43', 'KL77') AND a.supplierId=287) OR ( a.articleSearch IN ('50013181', '50013182', '50013649') AND a.supplierId=432) OR ( a.articleSearch IN ('06740', '05P408', '05P408A', '05P660') AND a.supplierId=283) OR ( a.articleSearch IN ('152071758861', '152071760560', '152071760562', '153071760221', '363710200311', '363710209025', '363916060325', '430216170546') AND a.supplierId=4723) OR ( a.articleSearch IN ('WK8424', 'WK841', 'WK8423', 'WK851', 'WK85311') AND a.supplierId=4) OR (a.articleSearch='2200140' AND a.supplierId=121) OR ( a.articleSearch IN ('30940607', '10916033', '30103811', '30939732', '32921597', '32921600') AND a.supplierId=151) OR ( a.articleSearch IN ('2078401', '2105601') AND a.supplierId=39) OR ( a.articleSearch IN ('GS8151', 'GDB317', 'GDB1067') AND a.supplierId=4501) OR ( a.articleSearch IN ('11270041701', '11270042801', '11270072601', '11270299801', '11270868201') AND a.supplierId=4346) OR ( a.articleSearch IN ('D20107', 'D20108') AND a.supplierId=4814) OR ( a.articleSearch IN ('C1M006ABE', 'C1M007ABE') AND a.supplierId=4426) OR (a.articleSearch='AVR141' AND a.supplierId=265) OR (a.articleSearch='36490' AND a.supplierId=206) OR ( a.articleSearch IN ('AN4180K', 'AN4216WK') AND a.supplierId=4024) OR ( a.articleSearch IN ('1050603', '1050606', '1520004', '1520061', '1520090', '1520094', '1520108') AND a.supplierId=317) OR ( a.articleSearch IN ('SP2003', 'SP972', 'SP973') AND a.supplierId=180) OR ( a.articleSearch IN ('PAD322', 'PAD420') AND a.supplierId=4537) OR ( a.articleSearch IN ('X1510114', 'X1510134', 'X1510458', 'X157107', 'X40073') AND a.supplierId=4975) OR ( a.articleSearch IN ('3004496', '300LL08', '50000530') AND a.supplierId=257) OR ( a.articleSearch IN ('KD7562', 'KD7613') AND a.supplierId=4854) OR (a.articleSearch='13046044012' AND a.supplierId=3) OR ( a.articleSearch IN ('LATG10', 'LATG106', 'LATG33', 'PBP5061') AND a.supplierId=4337) OR (a.articleSearch='290BK08625' AND a.supplierId=6271) OR ( a.articleSearch IN ('M365', 'M365A') AND a.supplierId=4280) OR (a.articleSearch='BA2101' AND a.supplierId=394) OR ( a.articleSearch IN ('510015', '571272D', '571272J', '571521J', '571825J') AND a.supplierId=49) OR (a.articleSearch='2978418004017204' AND a.supplierId=264) OR ( a.articleSearch IN ('ADU174265', 'ADV182347', 'ADV182360') AND a.supplierId=350) OR ( a.articleSearch IN ('BBP1089', 'BBP1335', 'BFF8021', 'BFF8036', 'BFF8048', 'BFF8147') AND a.supplierId=475) OR (a.articleSearch='B10477' AND a.supplierId=4815) OR ( a.articleSearch IN ('AA0279', 'AA0322') AND a.supplierId=4993) OR (a.articleSearch='207840070310' AND a.supplierId=281) OR ( a.articleSearch IN ('BP2238', 'BP2486', 'BP2490') AND a.supplierId=4872) OR (a.articleSearch='BSP20855' AND a.supplierId=157) OR ( a.articleSearch IN ('50010', 'BKM156', 'BKM239', 'BKM492', 'BKM941') AND a.supplierId=4604) OR ( a.articleSearch IN ('571272CH', 'CFF100114', 'CFF100134', 'L114606', 'L134606', 'L142606') AND a.supplierId=43) OR (a.articleSearch='8220140' AND a.supplierId=311) OR ( a.articleSearch IN ('ADB0238', 'CBP0238', 'EFF008', 'EFF018', 'EFF047') AND a.supplierId=421) OR ( a.articleSearch IN ('28000240052', '28000240372', '28000240882') AND a.supplierId=6513) OR ( a.articleSearch IN ('FP4935A', 'FP5038', 'FP5219', 'FT5384', 'FP5248', 'FP5352', 'FP5422', 'FT5385') AND a.supplierId=437) OR (a.articleSearch='DFF4200' AND a.supplierId=6479) OR ( a.articleSearch IN ('DBP468', 'DBP46801', 'DBP697') AND a.supplierId=4587) OR ( a.articleSearch IN ('A120004', 'A120007', 'A120021', 'A120153', 'B110458') AND a.supplierId=186) OR ( a.articleSearch IN ('DF3002', 'DF3004', 'DF3032', 'DF3081', 'DF3218', 'N09633') AND a.supplierId=4396) OR ( a.articleSearch IN ('CVP049', 'PCP1678') AND a.supplierId=278) OR (a.articleSearch='P550587' AND a.supplierId=6723) OR ( a.articleSearch IN ('DP1010101034', 'DP1010101167', 'DP1110130026', 'DP1110130103', 'DP1110130130') AND a.supplierId=4948) OR ( a.articleSearch IN ('DBP239', 'DBP293', 'DFFL147D', 'DFFL180', 'DFFL41', 'DFFL43', 'DFFL75', 'DFFL77', 'DFFL771') AND a.supplierId=4881) OR ( a.articleSearch IN ('120149', '120238', '120486') AND a.supplierId=309) OR ( a.articleSearch IN ('5502223307', '5502223317') AND a.supplierId=4770) OR ( a.articleSearch IN ('BP43347', 'BP43421') AND a.supplierId=271) OR ( a.articleSearch IN ('FVR239', 'FVR752', 'FVR941') AND a.supplierId=62) OR ( a.articleSearch IN ('FBP4143', 'FK5843', 'FK5844', 'FK862') AND a.supplierId=4838) OR ( a.articleSearch IN ('ZP053F', 'ZP054F', 'ZP055F', 'ZP8109FM') AND a.supplierId=4659) OR (a.articleSearch='PF904' AND a.supplierId=4741) OR ( a.articleSearch IN ('FP0927', 'FP0927E') AND a.supplierId=4937) OR (a.articleSearch='FF5312' AND a.supplierId=4581) OR (a.articleSearch='FO426181' AND a.supplierId=4887) OR (a.articleSearch='FBP0315' AND a.supplierId=409) OR ( a.articleSearch IN ('745501910', '745520401') AND a.supplierId=6484) OR (a.articleSearch='0160' AND a.supplierId=295) OR ( a.articleSearch IN ('BL1411A2', 'BL1723A1', 'BL2130A1') AND a.supplierId=54) OR (a.articleSearch='B1G10203092' AND a.supplierId=500) OR ( a.articleSearch IN ('6103179', '6110679') AND a.supplierId=279) OR (a.articleSearch='FG704' AND a.supplierId=4663) OR (a.articleSearch='GBP004730' AND a.supplierId=6529) OR ( a.articleSearch IN ('8DB355006061', '8DB355025721') AND a.supplierId=4734) OR ( a.articleSearch IN ('H123WK', 'H143WK', 'H70WK04', 'H70WK05', 'H70WK12') AND a.supplierId=81) OR ( a.articleSearch IN ('J1334024', 'J1334036') AND a.supplierId=72) OR ( a.articleSearch IN ('SN452', 'SN563', 'SN70204') AND a.supplierId=6309) OR ( a.articleSearch IN ('4111', '4113', '4270', '4329') AND a.supplierId=341) OR (a.articleSearch='HP9329' AND a.supplierId=4998) OR (a.articleSearch='12214071' AND a.supplierId=6359) OR (a.articleSearch='101199' AND a.supplierId=6277) OR ( a.articleSearch IN ('FC496S', 'FCL08S', 'PA0530AF') AND a.supplierId=156) OR ( a.articleSearch IN ('30496', '30L08', '500530') AND a.supplierId=481) OR ( a.articleSearch IN ('B34022PR', 'B3W000PR', 'B3W016PR', 'B3W017PR') AND a.supplierId=4689) OR ( a.articleSearch IN ('FS0001', 'FS0002', 'FS0003', 'FS0048') AND a.supplierId=4378) OR (a.articleSearch='JCP239' AND a.supplierId=4935) OR ( a.articleSearch IN ('FC1131', 'HDF506K', 'HDF507K', 'HDF516K') AND a.supplierId=4461) OR ( a.articleSearch IN ('F300101', 'F300301', 'F301701', 'F302201', 'F311301', 'F316701', 'JQ101478', 'JQ10158') AND a.supplierId=185) OR ( a.articleSearch IN ('004700', '004714', '004730', '014210') AND a.supplierId=286) OR ( a.articleSearch IN ('24141Z', '24308Z', 'FE012Z', 'FE101Z', 'FE115Z') AND a.supplierId=387) OR ( a.articleSearch IN ('1720020', '1720030', '1720140', '1722502', '6001050') AND a.supplierId=4546) OR ( a.articleSearch IN ('1335404', '13354') AND a.supplierId=35) OR ( a.articleSearch IN ('LFDF110', 'LFDF133', 'LFDF163') AND a.supplierId=4973) OR ( a.articleSearch IN ('BD5335', 'LF1010', 'LF1034', 'LF1603', 'LF1903') AND a.supplierId=4600) OR ( a.articleSearch IN ('MBF015648', 'MMF035067', 'MMF035113') AND a.supplierId=4570) OR ( a.articleSearch IN ('63197', '63603', '63806', '6828') AND a.supplierId=133) OR ( a.articleSearch IN ('13046044012NSETMS', '201601000', '202201400', '450001702', '450001712', '450002003', '841KFPCSMS', '8423KFPCSMS', '8424KFPCSMS', '85311KFPCSMS') AND a.supplierId=358) OR ( a.articleSearch IN ('190618', '260142', '260144', '260145', '260655') AND a.supplierId=403) OR (a.articleSearch='MFF3496' AND a.supplierId=4773) OR ( a.articleSearch IN ('4111', '4113', '4270', '4329') AND a.supplierId=244) OR ( a.articleSearch IN ('ELG5210', 'ELG5212', 'ELG5276') AND a.supplierId=218) OR (a.articleSearch='1170351' AND a.supplierId=94) OR ( a.articleSearch IN ('0252078418', '0252078418PD', '1001270004', '1001270006', '1002010011') AND a.supplierId=144) OR ( a.articleSearch IN ('DF323', 'DF327') AND a.supplierId=462) OR ( a.articleSearch IN ('AFFF003', 'E100314', 'E400314', 'E500314') AND a.supplierId=6495) OR ( a.articleSearch IN ('MDB1245', 'MDB1470', 'MDB1585', 'MDB3983', 'MDB1131') AND a.supplierId=73) OR ( a.articleSearch IN ('M276', 'M365', 'M365A') AND a.supplierId=4470) OR ( a.articleSearch IN ('LVXL448', 'VFF142', 'VFF307') AND a.supplierId=4564) OR ( a.articleSearch IN ('FN107', 'FN108') AND a.supplierId=490) OR ( a.articleSearch IN ('NB20784N00', 'NB20934N00') AND a.supplierId=6280) OR ( a.articleSearch IN ('PN0254', 'PN0254W') AND a.supplierId=4682) OR (a.articleSearch='J1334024' AND a.supplierId=248) OR ( a.articleSearch IN ('223307', '223311', '223317', '223305') AND a.supplierId=127) OR (a.articleSearch='H133A34' AND a.supplierId=440) OR ( a.articleSearch IN ('2136763', '2136767', '2136851', '2136879', '2145208') AND a.supplierId=4380) OR ( a.articleSearch IN ('BPA004714', 'BPA004730', 'BPA014210', 'EFF505820', 'EFF506220', 'EFF507420', 'EFF508020') AND a.supplierId=378) OR ( a.articleSearch IN ('9318', '9399', '9525', 'BP09318', 'BP09399', 'BP09525', 'FF01250', 'FF01257', 'FF01260') AND a.supplierId=129) OR ( a.articleSearch IN ('00962', '01680', '03428', '12715') AND a.supplierId=4683) OR ( a.articleSearch IN ('PBP239', 'PF3053', 'PF3056') AND a.supplierId=4558) OR (a.articleSearch='08635900A' AND a.supplierId=63) OR ( a.articleSearch IN ('PF1020', 'PF10201', 'PF10202') AND a.supplierId=4655) OR ( a.articleSearch IN ('15301043', '15301047', '15301050', '50000239') AND a.supplierId=4686) OR ( a.articleSearch IN ('PRP0119', 'PRP0428', 'PRP0593') AND a.supplierId=4520) OR ( a.articleSearch IN ('CS701', 'FCS412B', 'FCS412BV', 'CS182', 'CS197', 'CS197A', 'CS197B', 'CS454', 'CS469', 'FCS197', 'FCS412', 'FCS197V', 'FCS412V') AND a.supplierId=38) OR (a.articleSearch='QF52000' AND a.supplierId=4339) OR ( a.articleSearch IN ('BP1153', 'BP287', 'BP675', 'QFF0070', 'QFF0080', 'QFF0114', 'QFF0223', 'QFF0301', 'QFF0306', 'QFF0045', 'QFF0041') AND a.supplierId=57) OR ( a.articleSearch IN ('RA01980', 'RA01981', 'RA01989') AND a.supplierId=400) OR ( a.articleSearch IN ('RB0405', 'RB0405113', 'RB0814') AND a.supplierId=4955) OR (a.articleSearch='37HO005' AND a.supplierId=4869) OR ( a.articleSearch IN ('004700', '004714', '004730', '014210') AND a.supplierId=153) OR ( a.articleSearch IN ('402B0207', '402B0913', '9F0018', '9F0128', '9F0174') AND a.supplierId=6358) OR ( a.articleSearch IN ('204700', '204714', '204730', '214210') AND a.supplierId=152) OR ( a.articleSearch IN ('FS19960', 'FS19970', 'FS3104', 'FS3105') AND a.supplierId=6405) OR ( a.articleSearch IN ('5SP408', '5SP408A', '5SP660') AND a.supplierId=343) OR ( a.articleSearch IN ('CS3001M', 'CS3002M', 'CS3014M') AND a.supplierId=4263) OR ( a.articleSearch IN ('SP104PR', 'ST303', 'ST304') AND a.supplierId=225) OR ( a.articleSearch IN ('SPA238', 'SPA486', 'SPA490') AND a.supplierId=6331) OR ( a.articleSearch IN ('S6600NR', 'S7600NR', 'S7601NR') AND a.supplierId=142) OR ( a.articleSearch IN ('SKBP0010207', 'SKBP0011507', 'SKFF0870017') AND a.supplierId=6357) OR ( a.articleSearch IN ('058000BSX', '058030SX', '153020SX', '2100018SX', '2100041SX', '2100075SX', '2100147SX', '8200408SX', '8501400BSX', '8501400SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('775023', '775052') AND a.supplierId=6312) OR ( a.articleSearch IN ('GS5937', 'GS66', 'GS67') AND a.supplierId=4011) OR ( a.articleSearch IN ('RN234', 'RN66B', 'RN67B', 'RN57B') AND a.supplierId=91) OR ( a.articleSearch IN ('TX1020', 'TX10201', 'TX10202') AND a.supplierId=4377) OR ( a.articleSearch IN ('102731', '102732', '108503', '116458') AND a.supplierId=301) OR (a.articleSearch='PF1655' AND a.supplierId=4732) OR ( a.articleSearch IN ('811023017', '811023059', '811023774', '811023964') AND a.supplierId=108) OR (a.articleSearch='0235144' AND a.supplierId=209) OR (a.articleSearch='0160' AND a.supplierId=199) OR ( a.articleSearch IN ('2436500', '2436501', '2440000') AND a.supplierId=137) OR ( a.articleSearch IN ('V1003421', 'V1003431', 'V100344', 'V108114', 'V108165') AND a.supplierId=183) OR ( a.articleSearch IN ('587507', '587512', '587526', '598613') AND a.supplierId=21) OR (a.articleSearch='WBP29784A' AND a.supplierId=4498) OR ( a.articleSearch IN ('1511301', '1511302', '1511303') AND a.supplierId=482) OR ( a.articleSearch IN ('4111', '4113', '4270') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1018286', 'WG1018287', 'WG1018553', 'WG1214922', 'WG1214980', 'WG1214984', 'WG1215105', 'WG1215108', 'WG1429157', 'WG1429488', 'WG1429490', 'WG1499029', 'WG1499030', 'WG1499039', 'WG1499042', 'WG1747660', 'WG1747662', 'WG1747789', 'WG1792781', 'WG1792786', 'WG1792800', 'WG1792832') AND a.supplierId=4832) OR ( a.articleSearch IN ('WF8042', 'WF8043', 'WF8045', 'WF8180', 'WF8264') AND a.supplierId=324) OR ( a.articleSearch IN ('P042310', 'P147300', 'P147314', 'P147330') AND a.supplierId=366) OR ( a.articleSearch IN ('110737', '111647', '140297', '140301', '140303', '140657', '210403', '210649', '311957', '311975') AND a.supplierId=6347) OR ( a.articleSearch IN ('BS1151', 'KF5045', 'KF5071', 'KF5210') AND a.supplierId=4894) OR (a.articleSearch='297841801' AND a.supplierId=86)
    -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
    GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
An internal server error occurred.