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 ('YD205585', 'YS209140', 'YP201404', '5PK1113', '5PK1355', '5PK1750S1', '5PK903', '6PK1153', '6PK1199A1', '6PK1199S1', '6PK1238', '6PK1250', '6PK1413', '6PK1420', '6PK1795', '6PK1803', '6PK1835', '6PK1840', '6PK2238', '7PK1793', 'YD201659', 'YD202872', 'YD205527', 'YD205592', 'YD208550', 'YD239163', 'YM203042', 'YP146025', 'YP203294', 'YP208486', 'YP306203', 'YP756618') AND a.supplierId=4924) OR ( a.articleSearch IN ('DC9510', 'DC6100', '6PK1795', '5PK1110', '6PK1200', '6PK1800', '7PK1040', 'DB7301K', 'DB7308K', 'DB7309K', 'DB9502K', 'DB9525K', 'DC6300', 'DC7301', 'DC7303', 'DC7305', 'DC7307') AND a.supplierId=478) OR ( a.articleSearch IN ('1987947953', '1987945900', '1987946031', '1987947926', '1987948435', '1987948493') AND a.supplierId=30) OR ( a.articleSearch IN ('BSG65615012', 'BSG65615022', 'BSG65615040', 'BSG75615001', 'BSG75615002', 'BSG75615006') AND a.supplierId=4455) OR ( a.articleSearch IN ('30200', '1500', '0300', '0596', '100596SP', '119100SP', '13300', '19100', '30100', '500059', '500153', '500172', '500217', '500305', '500323', '500403', '500544') AND a.supplierId=4679) OR ( a.articleSearch IN ('021241', '021239', '021510', '021512', '021513', '482546', '759648', '759649', '769814') AND a.supplierId=405) OR ( a.articleSearch IN ('APV2324', 'APV2159', '6PK1795', '5PK1110', '5PK1115', '6PK1800', '6PK1805', 'APV2064', 'APV2075', 'APV2188', 'APV2323', 'APV2477', 'APV2498', 'APV2527', 'APV3090', 'APV3097', 'APV3180', 'APV3216', 'APV4032', 'KPV072', 'KPV076', 'KPV149', 'KPV152', 'KPV156', 'KPV192') AND a.supplierId=42) OR ( a.articleSearch IN ('1612549680', '1606347480', '1606347580', '1609323180', '1609323280', '1612057580', '1612057680', '1612057880', '1612057980', '1612058480', '1612058580', '1612058980', '1612059180', '1612059380', '1612059480', '1612059780', '1612059980', '1612060280', '1612060480', '1612060580', '1612061280', '1612063480', '1648202080', '1648202380', '1648202980') AND a.supplierId=4391) OR ( a.articleSearch IN ('FT44606', 'FT44599', 'FT44601', 'FT44616', 'FT44624', 'FT44625', 'FT44629', 'FT44632') AND a.supplierId=4938) OR ( a.articleSearch IN ('0290G15RA', '0290J10E', '0287J10E', '2487001', '2487KANI', '2487MAS', '2487MEGII', '2488LOG', '881275L1113') AND a.supplierId=4674) OR ( a.articleSearch IN ('21033', '100155', '100295', '100306', '102152', '22119', '22281', '22329', '23397', '27445', '27835', '28331', '28933', '28981', '30159', '37536', '39784', '44980') AND a.supplierId=101) OR ( a.articleSearch IN ('R54159', 'R34100', 'R34132', 'R34124') AND a.supplierId=271) OR ( a.articleSearch IN ('T38482', 'T36176', '6PK1795', '5PK1113', '6PK1803', '6PK1835', 'K015PK1200', 'K016PK1198', 'K026PK1130', 'K026PK1203', 'K036PK1795', 'T36084', 'T36413', 'T36618', 'T36754', 'T38347', 'T38428', 'T38456', 'T39009', 'T39163', 'T39253', 'T39340', 'T39388', 'T39393') AND a.supplierId=6665) OR ( a.articleSearch IN ('GT70770', 'GTA0050', 'GTA0370') AND a.supplierId=6666) OR ( a.articleSearch IN ('931012', '931037', '931089', '931091', '931095', '931163', '931195', '931214', '931215', '932162', '932273', '932457', '932483') AND a.supplierId=4862) OR ( a.articleSearch IN ('534014230', '532036420', '529000910', '529000920', '529001510', '529005110', '529005410', '529006810', '529006910', '529008210', '529008810', '529011710', '529011810', '529011910', '529012410', '529013610', '529013710', '529014510', '529016410', '529016420', '529016510', '529017810', '529020010', '529022410', '529028310', '529036210', '529036610', '529039610', '529040710', '529041210', '529043210', '529043310', '529043410', '529043510', '529043610', '529043710', '529044110', '529045310', '529051110', '531059130', '531086810', '532024310', '532071510', '532085510', '533012810', '534002710', '534014130', '534026910', '534027110', '534047410', '534047910', '537001710', '537023410', '537023610', 'FB5PK1113', 'FB6PK1795', 'FB6PK1800', 'FB6PK1803', 'FB6PK1830') AND a.supplierId=204) OR ( a.articleSearch IN ('1218302000', '1218100300', '1218105200', '1218301200', '1218301300', '4318201000', '4318201100', '4318301100', '4818101400') AND a.supplierId=268) OR ( a.articleSearch IN ('6PK1795', '5PK1113', '6PK1803', '6PK1835', 'PB5108', 'PB5120', 'PB5132', 'PB5161', 'PB5176', 'PB5222', 'PB5350', 'PB7027', 'PB7130', 'PB7232', 'PB7259', 'PK5002', 'PK5004', 'PK5006', 'PT3035', 'PT3037', 'PT3088', 'PT3138', 'PT3139') AND a.supplierId=4600) OR (a.articleSearch='MB6PK1795' AND a.supplierId=4570) OR ( a.articleSearch IN ('24163', '23171', '23172', '23175', '24172', '24173', '251110', '261200', '261795', '261800', '271332', '93100') AND a.supplierId=133) OR ( a.articleSearch IN ('05262', '05161', '05146', '05157', '05162', '05261', '16251', '58405', '58406') AND a.supplierId=4664) OR ( a.articleSearch IN ('0500061795', '0500051110', '0500051115', '0500051360', '0500061200', '0500061800', '0500061805', '16140090003', '16140200000', '16140200003') AND a.supplierId=144) OR ( a.articleSearch IN ('AG00070', 'AG03109', 'AG03071', '5PK1110', '5PK1113', '6PK1805', 'AD15006', 'AD15100', 'AD15128', 'AD15424', 'AG00028', 'AG00034', 'AG00039', 'AG00119', 'AG00136', 'AG00269', 'AG03000', 'AG03006', 'AG03011', 'AG03013', 'AG03049', 'AG03150', 'AG03321') AND a.supplierId=6495) OR ( a.articleSearch IN ('09649', '10391', '10470', '12623', '12866', '13497', '16966', '17452', '23499') AND a.supplierId=4683) OR ( a.articleSearch IN ('PT36030B', 'PT36031', '6PK1795', '5PK1113', '5PK1115', '6PK1200', '6PK1800', 'PT36020', 'PT36020B', 'PT36038', 'PT36040', 'PT36050', 'PT36050B', 'PT36052', 'PT36055', 'PT36055B', 'PT36072', 'PT36072B', 'PT36146', 'PT36221') AND a.supplierId=4558) OR ( a.articleSearch IN ('1624006', '1624005', '6PK1795', '1624007', '1624008', '1624009', '1624011', '1624013', '1624033', '1624061', '5PK1110', '5PK1120', '6PK1805') AND a.supplierId=260) OR ( a.articleSearch IN ('VKM36030', 'VKM36031', 'VKM34132', 'VKM36020', 'VKM36038', 'VKM36040', 'VKM36050', 'VKM36052', 'VKM36055', 'VKM36058', 'VKM36072', 'VKM36146', 'VKM36221', 'VKM66018', 'VKMA35006', 'VKMA36031', 'VKMA36033', 'VKMA36036', 'VKMA36037', 'VKMA36038', 'VKMA36043', 'VKMA36048', 'VKMA36050', 'VKMA36051', 'VKMA36052', 'VKMA36055', 'VKMA36058', 'VKMA36072', 'VKMA36073', 'VKMA36079', 'VKMA36091', 'VKMA36097', 'VKMA36103', 'VKMA36104', 'VKMA36105', 'VKMA36141', 'VKMA36145', 'VKMA36179', 'VKMA36200', 'VKMA36201', 'VKMA36209', 'VKMAF36033', 'VKMV5PK1110', 'VKMV6PK1792', 'VKMV6PK1793', 'VKMV6PK1795', 'VKMV6PK1805', 'VKMV6PK1832') AND a.supplierId=50) OR ( a.articleSearch IN ('GA35500', 'GA35597', 'BAC340NY14', 'CA5PK1110', 'CA5PK1115', 'CA6PK1148', 'CA6PK1795', 'CA6PK1805', 'GA35504', 'GA35506', 'GA35509', 'GA35511', 'GA35514', 'GA35515', 'GA35527', 'GA35529', 'GA37014', 'KA85503', 'KA85504', 'KA85510', 'KA85511', 'KA85512', 'KA85514', 'KA85516', 'KA85517', 'KA85519', 'KA85520', 'KA85521', 'KA85522', 'KA85526', 'R16036', 'R17306', 'GA35513', 'R16004') AND a.supplierId=110) OR ( a.articleSearch IN ('0340158SX', '0340223SX', '0340635SX', '0601795SX', '0904888SX', '0340124SX', '0340209SX', '0340226SX', '0340274SX', '0340292SX', '0340323SX', '0340365SX', '0340367SX', '0340534SX', '0340585SX', '0340712SX', '0340921SX', '0501110SX', '0601805SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('60921033', '10102152', '10928981', '10944980', '60100155', '60100295', '60100306', '60922119', '60922281', '60922329', '60923397', '60927445', '60927835', '60928331', '60928933', '60930159', '60937536', '60939784') AND a.supplierId=151) OR ( a.articleSearch IN ('SR1358', 'KR5PK1110', 'KR5PK1120', 'KR6PK1200', 'KR6PK1795', 'KR6PK1800', 'KR6PK1805', 'SR1006', 'SR1181', 'SR1186', 'SR1187', 'SR1188', 'SR1510', 'SR1936', 'SR1937', 'SR1938') AND a.supplierId=4894) OR ( a.articleSearch IN ('6PK1795', '5PK1110', '5PK1110K1', '5PK1125K1', '5PK1200K1', '6PK1130K1', '6PK1130K2', '6PK1200', '6PK1200K1', '6PK1795K1', '6PK1800', '6PK1800D1', '6PK1805', 'V85512', 'V85519', 'V85577', 'V85585', 'V85592', 'V85596', 'V85705', 'V85728', 'V85881', 'V85885') AND a.supplierId=6513) OR ( a.articleSearch IN ('10240', '13410', '13601', '13602', '13643', '13650', '13655') AND a.supplierId=4598) OR (a.articleSearch='100110' AND a.supplierId=4381) OR ( a.articleSearch IN ('1570202', '1570212', '1570273', '1570274', '1570324', '1570391', '1570392', '1570427', '1570578', '1570593', '1570595', '1570606', '1570638', '1570669') AND a.supplierId=317) OR ( a.articleSearch IN ('30682', '30684', '30686', '30687', '30691', '55596', '71840', '75323') AND a.supplierId=4576) OR ( a.articleSearch IN ('1125PK1110', '1125PK1115', '1126PK1200', '1126PK1790', '1126PK1795', '1126PK1835', '12801100', '12801101', '12801105', '12805502', '12901105', '12901120', '14001105', '9402291', '9602291', '9601118') AND a.supplierId=257) OR ( a.articleSearch IN ('NSBP010', 'NSBT001', 'RNBP001', 'RNBP003', 'RNBP006') AND a.supplierId=4631) OR ( a.articleSearch IN ('90553', '94889', '99273') AND a.supplierId=4495) OR ( a.articleSearch IN ('5PK1113', '601992', '601994', '602061', '641993', '651064', '651971', '654433', '654434', '654862', '654895', '655100', '655118', '655175', '6PK1795', '6PK1800', '702850', '702851', '702962', '703010') AND a.supplierId=300) OR ( a.articleSearch IN ('KK2011', 'RT1012', 'RT1081', 'RT1200', 'RT1215', 'RT1245', 'RT1484', 'RT1498', 'RT1553', 'RT1572', 'RT1937', 'RT1938') AND a.supplierId=4737) OR ( a.articleSearch IN ('03590', '03639', '0380112', '0380446', '0380687', '0380773', '0380774', '0380776', '0380819', '0381061', '0381227', '0381780', '0381817', '0381819', '0381912', '0381915', '0381952', '0381956', '0381961', '060006', '060024', '060025', '060026', '060027', '060028', '060034', '060050', '060108', '060125') AND a.supplierId=4651) OR ( a.articleSearch IN ('160075810', '160075910', '160076410', '160077510', '160078810') AND a.supplierId=323) OR ( a.articleSearch IN ('A03372', 'A04752', 'A04800', 'A04804', 'A04852', 'A05140', 'A05280', 'A07408', 'A09176', 'A09424', 'A09444', 'A09528', 'A09968', 'AA1152', 'AA1215') AND a.supplierId=4464) OR ( a.articleSearch IN ('5PK1110', '5PK1115', '6PK1790', '6PK1795', '6PK1835') AND a.supplierId=454) OR ( a.articleSearch IN ('0011028048', '0011028110', '0011028112', '0011028147', '0011028159', '0011028174', '0011028246', '0293016089', '0293016090') AND a.supplierId=4995) OR ( a.articleSearch IN ('AD05R1110', 'AD06R1200', 'AD06R1792', 'AD06R1795', 'ADC496504', 'ADN196503', 'ADN196504', 'ADN196509', 'ADN196517', 'ADN19653', 'ADT39639') AND a.supplierId=350) OR ( a.articleSearch IN ('BMS013', 'BMS045', 'BMS087', 'BMS271', 'BMS315', 'BMS329', 'BMS365') AND a.supplierId=6888) OR (a.articleSearch='HK8275' AND a.supplierId=475) OR ( a.articleSearch IN ('KCA0025', 'KCA0028', 'KCA0042', 'KCA0043', 'KCA0045', 'KCA0049', 'POA3234', 'POA3548', 'TOA3240', 'TOA3572', 'TOA3573', 'TOA3578', 'TOA3633', 'TOA3789', 'TOA3812', 'TOA4586', 'TOA4597') AND a.supplierId=195) OR (a.articleSearch='1192500QAF' AND a.supplierId=6366) OR ( a.articleSearch IN ('E28010BTA', 'E2F0014BTA', 'E2G0052BTA', 'E2M0054BTA', 'E2M0056BTA', 'E2R0022BTA', 'E2R0026BTA', 'E2R5527BTA', 'E2R5585BTA', 'E2R5592BTA', 'E2R5597BTA', 'E2R5606BTA', 'E2R5607BTA', 'E380001BTA', 'E3R0001BTA', 'E3R0002BTA', 'E3R0004BTA', 'E3R0005BTA') AND a.supplierId=4693) OR ( a.articleSearch IN ('605310', '606300', '606320', '613760', '801650', '807340', '815240', '824310', '824340', '824650', '824670', '824700', 'SZK10280', 'SZK24890') AND a.supplierId=6549) OR ( a.articleSearch IN ('10163', '17162', '47466', '67867', '77763', '77764', '77766', '87838', '88722', '88846', '89118', '89438') AND a.supplierId=4463) OR ( a.articleSearch IN ('200071404', '200104754', '5PK1110', '6PK1792', '6PK1795', '782328372', '782608550') AND a.supplierId=6411) OR ( a.articleSearch IN ('500666', '502149', '503830', '504219') AND a.supplierId=6263) OR ( a.articleSearch IN ('MR51110', 'MR51115', 'MR61795', 'MR61805') AND a.supplierId=89) OR ( a.articleSearch IN ('5PK1110', '6PK1200', '6PK1795', '6PK1805', 'P222005', 'P226002', 'P226003', 'P226004', 'P226006', 'P326001', 'P326002') AND a.supplierId=186) OR ( a.articleSearch IN ('A3021', 'A3022', 'A3030', 'A3033', 'A3040', 'A3043', 'A3057', 'A3065', 'A3072', 'A7001', 'A7004', 'A7006', 'A7011') AND a.supplierId=4396) OR (a.articleSearch='DCK1005' AND a.supplierId=253) OR ( a.articleSearch IN ('631057', '631058', '631063', '631540') AND a.supplierId=355) OR ( a.articleSearch IN ('DT36020', 'DT36030', 'DT36031', 'DT36038', 'DT36040', 'DT36050', 'DT36052', 'DT36055', 'DT36058', 'DT36072', 'DT66018') AND a.supplierId=4881) OR (a.articleSearch='EBT1925' AND a.supplierId=6364) OR (a.articleSearch='AC50220' AND a.supplierId=224) OR ( a.articleSearch IN ('T1017', 'T1096', 'T1103', 'T1121') AND a.supplierId=267) OR ( a.articleSearch IN ('10070', '10080', '10085', '10183', '14301', '15914', '16251', '4674', '4675', '4679', '5177') AND a.supplierId=4834) OR (a.articleSearch='BP5PK1113' AND a.supplierId=4741) OR ( a.articleSearch IN ('5PK1113', '6PK1795', '6PK1803', '6PK1835', 'F905PK1113', 'F915PK1200', 'F916PK1130', 'F916PK1203', 'F926PK1795', 'FA25961', 'FA99369', 'FS25941', 'FS25949', 'FS99130', 'FS99492', 'FS99494', 'FU25939', 'FU99113') AND a.supplierId=236) OR (a.articleSearch='22145006S' AND a.supplierId=4727) OR ( a.articleSearch IN ('651064', '651971', '654433', '654434') AND a.supplierId=181) OR ( a.articleSearch IN ('BT0010', 'PU0004', 'PU0014') AND a.supplierId=6443) OR ( a.articleSearch IN ('100987', '100989', '150059', '150966', '153428', '153429', '154170', '296PK1795') AND a.supplierId=178) OR ( a.articleSearch IN ('J1051113', 'J1061795', 'J1061800', 'J1141043', 'J1141053', 'J1141066', 'J1141077', 'J1143084') AND a.supplierId=72) OR ( a.articleSearch IN ('1110K5', '1120K5', '1792K6', '1795K6', '1805K6', 'G2013', 'G2015', 'KHV160', 'KHV164', 'KHV174', 'KHV176', 'T0241', 'T0367', 'T0369', 'T0371', 'T0372', 'T0374', 'T0375', 'T0377', 'T0462', 'T0534', 'T0693', 'T0063', 'T0474', 'T0580') AND a.supplierId=239) OR ( a.articleSearch IN ('14010040', '14013160', '14017192') AND a.supplierId=6359) OR ( a.articleSearch IN ('100987', '100989', '101056', '140988', '150059', '150966', '153428', '153429', '153857', '153890', '154095', '154113', '154170', '201845', '201846', '201957', '202005', '295PK1113', '296PK1795', '296PK1800', '64241') AND a.supplierId=262) OR ( a.articleSearch IN ('DV5PK1110', 'DV5PK1115', 'DV6PK1200', 'DV6PK1790', 'DV6PK1795', 'DV6PK1835', 'RP105', 'RP120', 'TP105', 'TS100', 'TS101', 'TS105', 'TS502', 'TT291', 'TV291', 'TV118') AND a.supplierId=156) OR ( a.articleSearch IN ('128100', '128101', '128105', '128502', '129105', '129120', '140105', '5PK1110', '5PK1115', '6PK1200', '6PK1790', '6PK1795', '6PK1835', '94291', '96291', '96118') AND a.supplierId=481) OR ( a.articleSearch IN ('R0156', 'R0171', 'R0179', 'R0182', 'R0184', 'R0188', 'R0189', 'R0387', 'R0399', 'R0400') AND a.supplierId=185) OR ( a.articleSearch IN ('DIP5514', 'DIP6501', 'DIP6502', 'DIP6519', 'DMV5531', 'DMV9018', 'DMV9046', 'DTP4533', 'DTP6504', 'DTP6506', 'DTP6509', 'DIP5502', 'DTP6516', 'DTP6526', 'DTP6512') AND a.supplierId=201) OR ( a.articleSearch IN ('5PK1110', '5PK1113', '63001Z', '63010Z', '63024Z', '6PK1790', '6PK1795', '6PK1800', 'RX36020', 'RX36030', 'RX36031', 'RX36040', 'RX36050', 'RX36052', 'RX36055', 'RX36058', 'RX36072', 'RX36146', 'RXP36050') AND a.supplierId=387) OR ( a.articleSearch IN ('FI11880', 'FI12000', 'FI12010', 'FI12130', 'FI12850', 'FI13200', 'FI18520', 'FI22940', 'FI23560', 'FI24920', 'FI26520', 'FI8430') AND a.supplierId=4462) OR ( a.articleSearch IN ('PU176012RDXW', 'PU176012RMXW2') AND a.supplierId=392) OR ( a.articleSearch IN ('1225087', '1225244', '1225245', '1225325', '1225402', '1225404', '1225443', '1225447', '1225456', '1225475', '1225487', '1225488') AND a.supplierId=4546) OR ( a.articleSearch IN ('1582001', '1720603', '15820', '17206') AND a.supplierId=35) OR ( a.articleSearch IN ('5PK1113L', '6PK1200L', '6PK1795L', '6PK1800L', '6PK1835L', 'LA0011', 'LA0073', 'LA0074', 'LA0082', 'LA0086', 'LA0088', 'LA0184', 'LA0390', 'LA0621', 'LA0622', 'LA0640', 'LA0692', 'LA0726', 'LA0727', 'LAK0001', 'LAK0023', 'LAK0024', 'LAK0034', 'LAK0035', 'LAK0053', 'LAK0057', 'LAK0058', 'LAK0075', 'LAK0079', 'LAK0084', 'LAK0097', 'LAK0104', 'LAK0105', 'LAK0159') AND a.supplierId=4501) OR ( a.articleSearch IN ('331316170014', '331316170056', '331316170087', '331316170184', '331316171357', '331316171426', '340511001110', '340611001200', '340611001795', '340611001800', '340611001805') AND a.supplierId=4723) OR ( a.articleSearch IN ('36031PCSMS', '36055PCSMS', '5PK1110PCSMS', '5PK1115PCSMS', '6PK1200PCSMS', '6PK1790PCSMS', '6PK1795PCSMS', '6PK1800PCSMS', 'N36030PCSMS', 'N36052PCSMS', 'N36055PCSMS', 'R36020PCSMS', 'R36030PCSMS', 'R36031PCSMS', 'R36040PCSMS', 'R36050PCSMS') AND a.supplierId=358) OR ( a.articleSearch IN ('5PK1115', '5PK1190', '6PK1795', 'MIP2015') AND a.supplierId=6270) OR ( a.articleSearch IN ('540259', '540280', '540281', '540306', '540309', '540409', '540533', '540534', '540540', '540558', '540742', '540843', '541237', '541262', '541601', '541622') AND a.supplierId=403) OR ( a.articleSearch IN ('MAT4105', 'MAT4120', 'MRB551110', 'MRB551115', 'MRB561200', 'MRB561790', 'MRB561795', 'MRB561800', 'MRB561805', 'MRB561835', 'MTP4100', 'MTP4101', 'MTP4105', 'MTP4502', 'MTY5105') AND a.supplierId=4773) OR ( a.articleSearch IN ('5PK1110', '5PK1115', '6PK1795', '6PK1805') AND a.supplierId=94) OR ( a.articleSearch IN ('SMAMP01074', 'SMAMP03022', 'SMAMP03041', 'SMAMP03044', 'SMAMP03109', 'SMAMP03318', 'SMAMP03331', 'SMAMP03355', 'SMAMP03407', 'SMAMP03416', 'SMAMP03427', 'SMAMP03441', 'SMAMP04036', 'SMAMV5PK1100', 'SMAMV5PK1110', 'SMAMV5PK1113', 'SMAMV5PK1120', 'SMAMV5PK1125', 'SMAMV5PK1355', 'SMAMV6PK1250', 'SMAMV6PK1413', 'SMAMV6PK1420', 'SMAMV6PK1460', 'SMAMV6PK1795', 'SMAMV6PK1800', 'SMAMV6PK1803', 'SMAMV6PK1805', 'SMAMV6PK1835', 'SMAMV6PK1840', 'SMAMV7PK1793') AND a.supplierId=6279) OR ( a.articleSearch IN ('5PK1100', '5PK1110', '5PK1120', '5PK1135', '5PK1355', '5PK820', '5PK850', '5PK903', '6PK1237', '6PK1245', '6PK1250', '6PK1255', '6PK1415', '6PK1420', '6PK1425', '6PK1430', '6PK1460', '6PK1790', '6PK1795', '6PK1805', '6PK1820', '6PK1835', '6PK1840', '6PK915', '7PK1036', '7PK1045', '7PK1153', '7PK1795') AND a.supplierId=4994) OR ( a.articleSearch IN ('501251113', '501261795', '5PK1113', '6PK1795') AND a.supplierId=6376) OR (a.articleSearch='LVFB845' AND a.supplierId=4564) OR ( a.articleSearch IN ('AST1603', 'AST1652', 'AST1828', 'AST2162', 'AST2403', 'AST2489', 'AST2490', 'AST2492', 'AST2535', 'AST2777', 'AST2943', 'AST3496', 'AST3533', 'AST3535', 'AST3628', 'AST3631', 'AST3668', 'AST3672', 'AST3677', 'ASTA0006', 'ASTA0024', 'ASTA0025', 'ASTA0026', 'ASTA0027', 'ASTA0028', 'ASTA0034', 'ASTA0050', 'ASTA0108', 'ASTA0125') AND a.supplierId=6874) OR ( a.articleSearch IN ('101929E', '5305268E', '5311891E', '531334E', '531341E', '531371E') AND a.supplierId=4535) OR ( a.articleSearch IN ('J1051115', 'J1145038', 'J1145039', 'J1145040', 'N1061795', 'N1061835', 'N1145061', 'N1148021', 'J1051110', 'N1145060', 'N1141047') AND a.supplierId=248) OR ( a.articleSearch IN ('133608', '133614') AND a.supplierId=127) OR ( a.articleSearch IN ('M111I18', 'M111I71', 'N110N01', 'N110N05', 'N111N69', 'T111A43') AND a.supplierId=440) OR ( a.articleSearch IN ('RNKNS006', 'RNKNS032', 'RNKPL010', 'RNKPL014', 'RNKRE000', 'RNKRE001', 'RNKRE004', 'RNKRE019') AND a.supplierId=6355) OR ( a.articleSearch IN ('2329901', '2330326', '2330336', '2330342', '2330440') AND a.supplierId=4380) OR ( a.articleSearch IN ('ACT202300', 'ACT203100', 'ACT204700', 'ACT215500', 'ACT215600', 'ACT220600', 'ACT226500', 'PVB120006', 'PVB179506', 'PVB180506') AND a.supplierId=378) OR ( a.articleSearch IN ('3006UR', '3050SR', '3054SR', '3085SR', '3145UR', '3149SR', '5PK1113', '6PK1795', '6PK1800', '6PK1800SCC', '6PK1820KT1') AND a.supplierId=64) OR ( a.articleSearch IN ('0N1307', '0N1409', '0N1427', '0N1427S', '0N1474', '0N1474S', '0N1476', '0N1476S', '0N1611', '0N1611S', '0N1663', '0N1663S', '0N1664', '0N1664S', '0N2275', '0N2290', '0N2290S', '0N2310', '0N2405', '0N2405S', '0N2472', '0N2472S') AND a.supplierId=129) OR (a.articleSearch='91003' AND a.supplierId=6298) OR ( a.articleSearch IN ('PTA1000079', 'PTA1000114', 'PTA1010064', 'PTA1020043', 'PTA1020045', 'PTA1020048', 'PTA1020285', 'PTA1020345') AND a.supplierId=6457) OR ( a.articleSearch IN ('5PK1110', '6PK1200', '6PK1795', '6PK1800', '6PK1805', 'GA004S', 'GA020', 'GA029', 'GA041', 'GA042', 'GA044', 'GA045', 'GA046', 'GA055', 'GA056', 'KGA4001', 'KGA4002', 'KGA4003', 'KGA4004', 'KGA4005', 'KGA4008', 'KGA4010', 'KGA4019', 'KGA4028', 'KGA4033', 'KGA4034', 'KGA4054', 'KGA4055', 'KGA4057', 'KGA4058', 'KGA4061', 'KGA4062') AND a.supplierId=4655) OR ( a.articleSearch IN ('10140145', '10143022', '10143044', '10143318', '10143331', '10143355') AND a.supplierId=4686) OR ( a.articleSearch IN ('QF00100005', 'QF31P00094') AND a.supplierId=4339) OR ( a.articleSearch IN ('QBR51110', 'QBR51113', 'QBR61200', 'QBR61795', 'QBR61800', 'QDK117', 'QDK89', 'QTA1029', 'QTA1192', 'QTA1217', 'QTA1218', 'QTA1219', 'QTA1322', 'QTA1342', 'QTA1371', 'QTA1457', 'QTA1607', 'QBR51115') AND a.supplierId=57) OR ( a.articleSearch IN ('13NI026', '995PK1110', '995PK1115', '996PK1200', '996PK1790', '996PK1836') AND a.supplierId=4869) OR ( a.articleSearch IN ('RKT1603', 'RKT1652', 'RKT1828', 'RKT2162', 'RKT2403', 'RKT2489', 'RKT2490', 'RKT2492', 'RKT2535', 'RKT2777', 'RKT2943', 'RKT3496', 'RKT3533', 'RKT3535', 'RKT3628', 'RKT3631', 'RKT3668', 'RKT3672', 'RKT3677', 'RKTA0006', 'RKTA0024', 'RKTA0025', 'RKTA0026', 'RKTA0027', 'RKTA0028', 'RKTA0034', 'RKTA0050', 'RKTA0108', 'RKTA0125') AND a.supplierId=4330) OR ( a.articleSearch IN ('305P0133', '310T0040', '310T0049', '310T0065', '310T0146', '310T0205', '312D0009', '312D0012', '312D0063', '541V0030', '542R0011', '542R0023', '542R0050', '542R0056', '542R0066', '542R0081', '542R0170', '542R0289', '542R0509') AND a.supplierId=6358) OR ( a.articleSearch IN ('5532885', '55527', '5552780', '55571', '5557780', '55585', '5558580', '5558581', '55591', '5559180', '55592', '55596', '5559680', '5559681', '55597', '55606', '5560680', '5560681', '5560682', '5560683', '55607', '5560780', '5560781', '5561080', '5561081', '55634', '55636', '57060', '5706080', '5753480', '57715', '5PK1113', '6PK1805') AND a.supplierId=23) OR ( a.articleSearch IN ('076212', '077160', '208280') AND a.supplierId=4623) OR ( a.articleSearch IN ('V202431', 'V203642', 'V207151', 'V401423') AND a.supplierId=6377) OR ( a.articleSearch IN ('5R374', '6R429', 'V479') AND a.supplierId=225) OR ( a.articleSearch IN ('SK6PK1803', 'SKDG1080008', 'SKDG1080011', 'SKDG1080062', 'SKPB0090024', 'SKRBS1200010', 'SKRBS1200019', 'SKRBS1200022', 'SKRBS1200049', 'SKRBS1200055', 'SKRBS1200065', 'SKRBS1200080', 'SKRBS1200169', 'SKRBS1200281', 'SKRBS1200288', 'SKTP0600052', 'SKTP0600061', 'SKTP0600077', 'SKTP0600158', 'SKVB0590029') AND a.supplierId=6357) OR ( a.articleSearch IN ('T405146', 'T405157', 'T405161', 'T405162', 'T405261', 'T405262', 'T416251', 'T458405', 'T458406') AND a.supplierId=4667) OR ( a.articleSearch IN ('106191', '87228', '87229') AND a.supplierId=6691) OR ( a.articleSearch IN ('5KSY1110', '5KSY1110K1', '5KSY1125K1', '5KSY1200K1', '6KSY1130K1', '6KSY1130K2', '6KSY1200', '6KSY1200K1', '6KSY1795', '6KSY1795K1', '6KSY1795K3', '6KSY1800', '6KSY1805', '6KSY1836K3', '7KSY1145K1', '7KSY1785K2', '7KSY1795K3', '7KSY1834K1', 'SY31059130', 'SY31086810', 'SY32024310', 'SY32036420', 'SY32071510', 'SY32085510', 'SY33012810', 'SY34002710', 'SY34014130', 'SY34014230', 'SY34026910', 'SY34027110', 'SY34047410') AND a.supplierId=6394) OR ( a.articleSearch IN ('202335', '207021', '207076', '207077', '408781', '700550', '701184', '701237') AND a.supplierId=301) OR ( a.articleSearch IN ('TA1277', 'TA1285', 'TA1291', 'TA1426', 'TA1461', 'TA1572', 'TA1574', 'TA1692', 'TA1840', 'TA1959', 'TA2159', 'TA2286') AND a.supplierId=4732) OR ( a.articleSearch IN ('425022', '425168', '425169', '425172', '425626', '425678', '425679', '425692', '425993') AND a.supplierId=4970) OR ( a.articleSearch IN ('8640501113', '8640601795', '8640601803', '8640601835', '8641101004', '8641102010', '8641102024', '8641103013', '8641103018', '8641162020', '8641232030', '8641252022', '8641253005', '8641253007', '8641253008', '8641253010', '8641693003', '864210017') AND a.supplierId=108) OR ( a.articleSearch IN ('0219360', '0719188') AND a.supplierId=209) OR ( a.articleSearch IN ('V302460', 'V400201', 'V400202', 'V400822', 'V460004', 'V460318', 'V460420', 'V460728', 'V461719') AND a.supplierId=183) OR ( a.articleSearch IN ('WG1054775', 'WG1054791', 'WG1152867', 'WG1152868', 'WG1153034', 'WG1153110', 'WG1153111', 'WG1153112', 'WG1153519', 'WG1153747', 'WG1153750', 'WG1153781', 'WG1153818', 'WG1252427', 'WG1252660', 'WG1252834', 'WG1252910', 'WG1253144', 'WG1253281', 'WG1253386', 'WG1253387', 'WG1253455', 'WG1253457', 'WG1253568', 'WG1427163', 'WG1427502', 'WG1428694', 'WG1430780', 'WG1430786', 'WG1430797', 'WG1430824', 'WG1430827', 'WG1430830', 'WG1430848', 'WG1430854', 'WG1430920', 'WG1430940', 'WG1460436', 'WG1460445', 'WG1484451', 'WG1700422', 'WG1700426', 'WG1700427', 'WG1710153', 'WG1710171', 'WG1906989', 'WG1907041', 'WG1907092', 'WG1907289', 'WG1907296', 'WG1907297', 'WG1907320', 'WG1907343', 'WG1907480', 'WG1907481', 'WG1907485', 'WG1907486', 'WG1907487', 'WG1907488', 'WG1907575', 'WG1940868', 'WG1966519', 'WG1978444', 'WG1978449', 'WG1978450', 'WG1978451', 'WG1990910', 'WG1991017', 'WG2002233', 'WG2002234', 'WG2002672', 'WG2002673', 'WG2002674', 'WG2004323', 'WG2004334', 'WG2004409', 'WG2004436', 'WG2004563', 'WG2004564', 'WG2004639', 'WG2004659', 'WG2004688', 'WG2005026', 'WG2005031', 'WG2005050', 'WG2006769', 'WG2006774', 'WG2006851', 'WG2006857', 'WG2006864', 'WG2006908', 'WG2059034', 'WG2059035', 'WG2101370', 'WG2101371', 'WG2112119', 'WG2113029', 'WG2136835', 'WG2136840') AND a.supplierId=4832) OR ( a.articleSearch IN ('10818', '10819', '10865', '111365', '150973', '310523', '311669', '313141') AND a.supplierId=6347)
    -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
    GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
An internal server error occurred.