SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.manufacturerId, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps.id AS supplier_product_id,     -- Получаем ID всех найденных деталей
    ps.supplier_id AS real_supplier_id -- Видим, какому именно поставщику принадлежит строка
FROM article a 
LEFT JOIN article_oem 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 (224, 226, 223, 225, 227) 
WHERE ( a.articleSearch IN ('CSCN002', 'CSCERE02', 'CSCN003', 'CSCN005') AND a.supplierId=4951) OR ( a.articleSearch IN ('34615', '30417', '32666', '75751', '76725') AND a.supplierId=4576) OR ( a.articleSearch IN ('ADN13653', 'ADR163601', 'ADBP300001', 'ADBP300002', 'ADN130159', 'ADN130160', 'ADN130204', 'ADN130221', 'ADN130232', 'ADN130234', 'ADN130250', 'ADN130255', 'ADN130275', 'ADN13672', 'ADN13673C', 'ADR163032', 'ADR163036', 'ADR163045', 'ADR163046', 'ADR163047', 'ADR163048', 'ADR163049', 'ADR163050', 'ADR163054', 'ADR163056', 'ADR163057', 'ADR163058', 'ADR163059', 'ADR163061', 'ADR163072', 'ADR163603', 'ADR163606', 'ADR163607', 'ADN130223') AND a.supplierId=350) OR ( a.articleSearch IN ('0986486646', '0986486648') AND a.supplierId=30) OR ( a.articleSearch IN ('1666659680', '1666659880', '1666660080', '1666663780', '1680363780') AND a.supplierId=4391) OR ( a.articleSearch IN ('CSC400', 'CSC405') AND a.supplierId=399) OR ( a.articleSearch IN ('1101731', 'ZA3108331', '1100730', '1100930', '1101030', 'ZA300541', 'ZA300741', 'ZA300841') AND a.supplierId=54) OR ( a.articleSearch IN ('4030300200', '4330300400') AND a.supplierId=268) OR ( a.articleSearch IN ('3243', '3489', '3493', '3497') AND a.supplierId=283) OR ( a.articleSearch IN ('510009010', '510009710', '510009810', '510011110', '510016410', '600019700', '600020400', '600026800', '618308633', '618308634', '619303633', '619304334', '619305033', '619315433', '620311933', '620311934', '620322433', '620322434', '620331033', '620335933', '620342033', '621310333', '622306133', '622306134', '622309633', '622309635', '622309636', '622310133', '622310135', '622310333', '622310334', '622311033', '622311034', '622312633', '622312733', '622312734', '622313733', '622315633', '622319933', '622322333', '622322334', '622332634', '622336033', '622336034', '622336233', '622342133', '622342733', '622342734', '622342933', '622342934', '623327533', '623327733', '623329733', '623330533', '623332133', '623341333', '623341633', '623341933', '623355333', '623370133', '623370933', '624353933', '624390233', '625303833', '625305233', '625305635') AND a.supplierId=204) OR ( a.articleSearch IN ('12156', '12150', '12151', '12153') AND a.supplierId=133) OR ( a.articleSearch IN ('GE16020', 'GE16030', 'GE16021') AND a.supplierId=6495) OR ( a.articleSearch IN ('PHCB11', 'PHCB20', 'PHCB22', 'PHCB27') AND a.supplierId=4558) OR ( a.articleSearch IN ('3182654146', '3182654165', '3182654204', '3182600121', '3182600129', '3182600138', '3182600140', '3182654169', '3182600208', '3182600179') AND a.supplierId=32) OR ( a.articleSearch IN ('5354005', '5354007', '5354002', '5354008') AND a.supplierId=260) OR ( a.articleSearch IN ('CT0903', 'CT0904', 'CT0902', 'CT0906', 'CT1401') AND a.supplierId=4772) OR ( a.articleSearch IN ('804527', '804544', '810086', '1100730', '1100930', '1101030', '1101731', '804510', '804525', '833733', '834519', '810032') AND a.supplierId=21) OR ( a.articleSearch IN ('51223', '61257', '61260', '75355') AND a.supplierId=206) OR ( a.articleSearch IN ('88592', '88593', '88612', '88637') AND a.supplierId=317) OR ( a.articleSearch IN ('9001112', '9001113', '90RERE01', '92011003', '92011007', '92011025', '92011043', '92011044', '92011052', '92011053', '9201183', '9801106', '9801107') AND a.supplierId=257) OR (a.articleSearch='CPDREN201C' AND a.supplierId=6531) OR ( a.articleSearch IN ('290CL00501', '290CL00505') AND a.supplierId=6271) OR (a.articleSearch='0011016428' AND a.supplierId=4995) OR ( a.articleSearch IN ('BCS109', 'BCS131', 'BCS148', 'BCS153', 'HKT1177') AND a.supplierId=475) OR ( a.articleSearch IN ('RFI1018', 'RFI1024', 'RFI1033') AND a.supplierId=195) OR ( a.articleSearch IN ('E68003', 'E68005', 'E68006', 'E68007') AND a.supplierId=65) OR (a.articleSearch='3062000Q0J' AND a.supplierId=6366) OR ( a.articleSearch IN ('9961C', '9962C', '9965C', '9966C') AND a.supplierId=243) OR ( a.articleSearch IN ('506042', '506045') AND a.supplierId=311) OR ( a.articleSearch IN ('MCK0408CSC', 'MCK04109CSC', 'MCK04122CSC', 'MCK04136CSC', 'MCK04139ACSC', 'MCK04139CSC', 'MCK0413CSC', 'MCK0459CSC', 'MCK0460CSC', 'MCK0463ACSC', 'MCK0463CSC', 'MCK0470CSC', 'MCK0471ACSC', 'MCK0471CSC', 'MCK1958CSC', 'MCK2306CSC', 'MCK2306CSCA', 'MCK2322CSC', 'MCK2322CSCA', 'MCK2324CSC', 'MCK2324CSCA', 'MCK2331CSC', 'MCK2331CSCA', 'MCK2335CSC', 'MCK2335CSCA', 'MCK2346CSC', 'MCK2349CSC', 'MCK2349CSCA', 'MCK2349DCSC', 'MCK2349ECSC', 'MCK2351CSC', 'MCK2351CSCA', 'MCK2353CSC', 'MCK2368ACSC', 'MCK2368ACSCA', 'MCK2368CSC', 'MCK2368CSCA', 'MCK2381ACSC', 'MCK2381CSC', 'MCK2383CSC', 'MCSC018', 'MCSC024', 'MCSC138', 'MCSC138A', 'MCSC150') AND a.supplierId=4358) OR ( a.articleSearch IN ('782764612', '782764613') AND a.supplierId=6411) OR ( a.articleSearch IN ('CS37', 'CS41', 'CS52', 'CS58') AND a.supplierId=421) OR ( a.articleSearch IN ('K300037', 'K300040', 'K300049', 'K300054') AND a.supplierId=186) OR ( a.articleSearch IN ('T1034', 'T1072', 'T1075', 'T1076') AND a.supplierId=4396) OR ( a.articleSearch IN ('CGF010LUKN', 'CGF010N') AND a.supplierId=4882) OR ( a.articleSearch IN ('13SKV013', '13SKV015') AND a.supplierId=4969) OR ( a.articleSearch IN ('FT67035', 'FT68042', 'FT68057') AND a.supplierId=4938) OR ( a.articleSearch IN ('P2319', 'P2405', 'P2835', 'P3002') AND a.supplierId=271) OR ( a.articleSearch IN ('FHC6186', 'FHC6187', 'FHC6190', 'FHC6193') AND a.supplierId=62) OR ( a.articleSearch IN ('J2411000', 'J2411004', 'J2411005') AND a.supplierId=72) OR (a.articleSearch='CHB010' AND a.supplierId=4756) OR ( a.articleSearch IN ('20013105', '20013105M', '20013110', '20013113', '20013115', '20113110C', '20113112', '20113192E', '20413090', '20413110') AND a.supplierId=6359) OR ( a.articleSearch IN ('CF112', 'CF113', 'CFRE01', 'KF1003', 'KF1007', 'KF1025', 'KF1043', 'KF1044', 'KF1052', 'KF1053', 'KF183', 'KV106', 'KV107') AND a.supplierId=156) OR ( a.articleSearch IN ('90112', '90113', '90RE01', '921003', '921007', '921025', '921043', '921044', '921052', '921053', '92183', '98106', '98107') AND a.supplierId=481) OR ( a.articleSearch IN ('CSCN003K', 'HBNS001', 'KN314K') AND a.supplierId=4461) OR (a.articleSearch='CC010' AND a.supplierId=185) OR ( a.articleSearch IN ('961800CSC', '962106CSC', '962531CSC', '962666CSC', '962901CSC', '963046CSC', '963052CSC', '963054CSC', '963136CSC', '990072', '990089', '990094', '990095', '990169') AND a.supplierId=286) OR ( a.articleSearch IN ('30133Z', '30136Z', '30137Z') AND a.supplierId=387) OR ( a.articleSearch IN ('W03215J08', 'W06200B08') AND a.supplierId=4718) OR ( a.articleSearch IN ('LCSC0010', 'LCSC0101', 'LCSC0201', 'LCSC0203', 'LCSC0314', 'LCSC0362', 'LCSC0367', 'LCSC0370', 'LKCA690009C', 'PJQ163', 'PJQ169', 'PJQ170', 'PJQ192', 'PJQ227', 'PJQ229', 'PJQ231') AND a.supplierId=4501) OR ( a.articleSearch IN ('CL8193', 'CL8201', 'CL8217', 'CL8250') AND a.supplierId=4600) OR ( a.articleSearch IN ('360319030088', '360319030096', '360319030097', '360319030105') AND a.supplierId=4723) OR ( a.articleSearch IN ('003215908', '006200108') AND a.supplierId=470) OR (a.articleSearch='182600140PCSMS' AND a.supplierId=358) OR ( a.articleSearch IN ('610068', '610085', '610097', '610103') AND a.supplierId=403) OR ( a.articleSearch IN ('AISCSCN002', 'AISCSCN003', 'AISCSCN005', 'EXECSC400', 'EXECSC405', 'MCB1112', 'MCB1113', 'MCB1130', 'MCB1RE01') AND a.supplierId=4773) OR ( a.articleSearch IN ('MHB8529', 'MHB8530', 'MHB8533', 'MK10072', 'MK10072A', 'MK10098', 'MK10101', 'MK10273', 'MK9692', 'MK9937', 'MK9956A') AND a.supplierId=4559) OR ( a.articleSearch IN ('560042', '560045') AND a.supplierId=121) OR ( a.articleSearch IN ('VCC19', 'VCC34', 'VCC37', 'VCC52') AND a.supplierId=4564) OR ( a.articleSearch IN ('NSC0037', 'NSC0041', 'NSC0052', 'NSC0058') AND a.supplierId=190) OR (a.articleSearch='F1R202NX' AND a.supplierId=4694) OR ( a.articleSearch IN ('N2101001', 'N2101002', 'N2101003', 'N2101004') AND a.supplierId=248) OR ( a.articleSearch IN ('132255', '132259', '142201', '143902', '143903', '143905') AND a.supplierId=127) OR ( a.articleSearch IN ('N200N211', 'N241N42', 'N241N44', 'N241N45') AND a.supplierId=440) OR ( a.articleSearch IN ('NWSRE001', 'NWSRE005', 'NWSRE006', 'NWSRE007') AND a.supplierId=6355) OR ( a.articleSearch IN ('2277345', '2277368', '2277388', '2277576', '2278003', '2278119') AND a.supplierId=4380) OR ( a.articleSearch IN ('FSC408810', 'FSC408910', 'FSC409110', 'FSC409210') AND a.supplierId=378) OR ( a.articleSearch IN ('16309', '16310', '35446') AND a.supplierId=4683) OR (a.articleSearch='JAPCFRE01' AND a.supplierId=4652) OR ( a.articleSearch IN ('BH021', 'BH024', 'BH028', 'BH041', 'KTE153BH') AND a.supplierId=4655) OR ( a.articleSearch IN ('25302423', '25303003') AND a.supplierId=4686) OR ( a.articleSearch IN ('PRH6018', 'PRH6036') AND a.supplierId=4520) OR ( a.articleSearch IN ('QF50B00001', 'QF50B00002', 'QF50B00014') AND a.supplierId=4339) OR ( a.articleSearch IN ('CSC023', 'CSC040', 'CSC042', 'CSC052') AND a.supplierId=57) OR ( a.articleSearch IN ('RCS20033', 'RCS20038', 'RCS20047', 'RCS20053', 'RCS20106') AND a.supplierId=400) OR ( a.articleSearch IN ('25NI081', '25NI083', '25NI128') AND a.supplierId=4869) OR ( a.articleSearch IN ('47C0027', '47C0032') AND a.supplierId=6358) OR ( a.articleSearch IN ('CSC023530', 'CSC040530', 'CSC042530', 'CSC052530') AND a.supplierId=4828) OR ( a.articleSearch IN ('M30230', 'M30459', 'M30463', 'M30467') AND a.supplierId=343) OR ( a.articleSearch IN ('11750678', '11750679') AND a.supplierId=6303) OR ( a.articleSearch IN ('SKCSC0630030', 'SKCSC0630035') AND a.supplierId=6357) OR ( a.articleSearch IN ('0700808SX', '0700813SX', '0700817SX', '0700841SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('9961', '9962', '9965', '9966') AND a.supplierId=6691) OR ( a.articleSearch IN ('TKA840003', 'TKA840005', 'TKA840007') AND a.supplierId=6312) OR ( a.articleSearch IN ('626901', '701136') AND a.supplierId=301) OR ( a.articleSearch IN ('WCSC018', 'WCSC024', 'WCSC062', 'WCSC067', 'WCSC070', 'WNS060CSC', 'WNS104CSC', 'WNS112CSC', 'WRN009CSC', 'WRN058CSC') AND a.supplierId=4561) OR ( a.articleSearch IN ('KS4301', 'KS6032', 'KS6056', 'KS6057') AND a.supplierId=4894)An internal server error occurred.