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 ('TC2326', 'TC2327') AND a.supplierId=89) OR ( a.articleSearch IN ('REWP7903', 'REWP7904', 'REBJ7431', 'REBJ7432', 'RESB7433', 'RESB7434') AND a.supplierId=134) OR ( a.articleSearch IN ('5013953', '5013954', '5043325', '5043945') AND a.supplierId=127) OR ( a.articleSearch IN ('7474003', '7474005', '2254002', '2254003', '7574008', '7574009') AND a.supplierId=260) OR ( a.articleSearch IN ('5874', '5875', '5286', '5287') AND a.supplierId=135) OR ( a.articleSearch IN ('4001396', '4001395', '4009796', '4009797') AND a.supplierId=4758) OR ( a.articleSearch IN ('30RN5606', '30RN5607', '10RN5605', '10RN5606') AND a.supplierId=4829) OR ( a.articleSearch IN ('211247', '211248', '220508', '220509', '271476', '271477') AND a.supplierId=206) OR ( a.articleSearch IN ('18986', '18987') AND a.supplierId=317) OR ( a.articleSearch IN ('10340849', '10340850', '10341305', '10341306') AND a.supplierId=479) OR ( a.articleSearch IN ('18661AP', '18662AP') AND a.supplierId=6400) OR ( a.articleSearch IN ('80797', '80798', '80871', '80872') AND a.supplierId=4576) OR ( a.articleSearch IN ('PAL51232', 'PAL51233') AND a.supplierId=442) OR ( a.articleSearch IN ('4402001', '4402002', '4413001', '4413002') AND a.supplierId=4306) OR ( a.articleSearch IN ('290RT00696', '290RT00697') AND a.supplierId=6271) OR ( a.articleSearch IN ('0011027733', '0011027734') AND a.supplierId=4995) OR ( a.articleSearch IN ('047792B', '047793B', '047796B', '047797B') AND a.supplierId=49) OR ( a.articleSearch IN ('TRC7307', 'TRC7308') AND a.supplierId=478) OR ( a.articleSearch IN ('BR1016', 'BR1017', 'CD3668', 'CS3668') AND a.supplierId=208) OR ( a.articleSearch IN ('BBJ5587', 'BBJ5588', 'BCA6777', 'BCA6778') AND a.supplierId=475) OR ( a.articleSearch IN ('BSG60310290', 'BSG75310051', 'BSG75310052', 'BSG75315031', 'BSG75315032') AND a.supplierId=4455) OR ( a.articleSearch IN ('CBJ5019', 'CBJ6019', 'CCA1077', 'CCA2077') AND a.supplierId=421) OR ( a.articleSearch IN ('49395980', '49398270', '49399485', '49399604', '49401020', '49401170') AND a.supplierId=140) OR ( a.articleSearch IN ('CBRE6L', 'CBRE6R') AND a.supplierId=4553) OR ( a.articleSearch IN ('D110255', 'D110256') AND a.supplierId=186) OR (a.articleSearch='B7076' AND a.supplierId=4396) OR ( a.articleSearch IN ('2020719', '2020720', '2023157', '2023158') AND a.supplierId=4135) OR ( a.articleSearch IN ('15TC431', '15TC432', '22SB058', '22TC320', '22TC321') AND a.supplierId=4003) OR ( a.articleSearch IN ('821095210', '821095310', '825033910', '825034110') AND a.supplierId=192) OR ( a.articleSearch IN ('SS7033', 'SS7034', 'SS7048', 'SS7049') AND a.supplierId=267) OR (a.articleSearch='RS188' AND a.supplierId=4834) OR ( a.articleSearch IN ('FT15748', 'FT15749', 'FT17121', 'FT17122') AND a.supplierId=4938) OR ( a.articleSearch IN ('NABJ10B', 'RNAB010') AND a.supplierId=4674) OR ( a.articleSearch IN ('172560', '172561', '36121', '36122', '39023', '39024') AND a.supplierId=101) OR ( a.articleSearch IN ('FBJ5587', 'FBJ5588', 'FCA6777', 'FCA6778') AND a.supplierId=407) OR ( a.articleSearch IN ('FL10197G', 'FL10198G', 'FL10587D', 'FL10588D') AND a.supplierId=236) OR ( a.articleSearch IN ('2200034', '2200035', '2204037', '2204038', '2209042', '2209043') AND a.supplierId=4727) OR ( a.articleSearch IN ('FZ3294', 'FZ3295') AND a.supplierId=4467) OR ( a.articleSearch IN ('F4092', 'F4093') AND a.supplierId=486) OR ( a.articleSearch IN ('R602', 'R602K', 'R603', 'R603K', 'R970', 'R971') AND a.supplierId=6101) OR ( a.articleSearch IN ('510743', '516186', 'S060892', 'S060893', 'S080612', 'S080613') AND a.supplierId=373) OR ( a.articleSearch IN ('4340300570', '4340300580') AND a.supplierId=268) OR ( a.articleSearch IN ('9040121', '9040122') AND a.supplierId=185) OR ( a.articleSearch IN ('8500235043', '8500235044', '850025553', '850025554', '850025555', '850025556') AND a.supplierId=286) OR ( a.articleSearch IN ('47273Z', '47274Z', '47533Z', '47534Z') AND a.supplierId=387) OR ( a.articleSearch IN ('3198901', '3199001', '3370701', '3381601', '4259301', '4259401') AND a.supplierId=35) OR ( a.articleSearch IN ('C1309L', 'C1309R', 'C5413L', 'C5413R', 'C8613', 'C8614') AND a.supplierId=4600) OR ( a.articleSearch IN ('301181365600', '301181365700', '301181396600', '301181396700') AND a.supplierId=4723) OR ( a.articleSearch IN ('MSA015387', 'MSA015388', 'MSA025159', 'MSA025160') AND a.supplierId=4570) OR ( a.articleSearch IN ('33119', '33120', '49162', '49163') AND a.supplierId=133) OR ( a.articleSearch IN ('722537', '722543', '725323', '725324') AND a.supplierId=403) OR ( a.articleSearch IN ('57026301', '57026402', '58070301', '58070402') AND a.supplierId=94) OR ( a.articleSearch IN ('16146100002', '16146100006', '16146100007', '16160100012', '16160100013', '16160500045', '16160500046', '16166100002', '16166100003', '16166100011', '16166100013') AND a.supplierId=144) OR (a.articleSearch='DB68008' AND a.supplierId=6495) OR (a.articleSearch='142100470' AND a.supplierId=6376) OR ( a.articleSearch IN ('L25553', 'L25554', 'L25555', 'L25556') AND a.supplierId=4752) OR ( a.articleSearch IN ('LVSA1421', 'LVSA1422', 'LVSJ1095', 'LVSJ1096', 'VSK696') AND a.supplierId=4564) OR ( a.articleSearch IN ('ZWDME053', 'ZWDME054') AND a.supplierId=6355) OR ( a.articleSearch IN ('0483214', '0493214', '0783214', '0793214', '1215954', '1215955') AND a.supplierId=198) OR ( a.articleSearch IN ('4795C', '4796C', 'G404795C', 'G404796C') AND a.supplierId=6522) OR ( a.articleSearch IN ('2398302', '2399040') AND a.supplierId=4380) OR ( a.articleSearch IN ('SSB114401', 'SSB114410', 'SSW127901', 'SSW127910') AND a.supplierId=378) OR ( a.articleSearch IN ('G31061', 'G31062', 'G61452', 'G61453') AND a.supplierId=129) OR ( a.articleSearch IN ('PS5392L', 'PS5392R') AND a.supplierId=4558) OR (a.articleSearch='QF30D00019' AND a.supplierId=4339) OR ( a.articleSearch IN ('QSA2413S', 'QSA2414S', 'QSJ3471S', 'QSJ3472S') AND a.supplierId=57) OR ( a.articleSearch IN ('R52052', 'R52053') AND a.supplierId=4303) OR ( a.articleSearch IN ('RH032029', 'RH032030', 'RH043069') AND a.supplierId=6892) OR (a.articleSearch='273C0947' AND a.supplierId=6358) OR ( a.articleSearch IN ('BJR754', 'BJR755', 'TCM188', 'TCM189', 'TCR758', 'TCR758S', 'TCR759', 'TCR759S') AND a.supplierId=6698) OR ( a.articleSearch IN ('01700444', '9390419156', '9390419256', '96904781', '96904782') AND a.supplierId=430) OR ( a.articleSearch IN ('925506', '925507') AND a.supplierId=23) OR ( a.articleSearch IN ('VKDS316016', 'VKDS316017', 'VKDS326047B', 'VKDS326048B', 'VKDS336029', 'VKDS336059') AND a.supplierId=50) OR ( a.articleSearch IN ('50636', '50637', '50638', '50639') AND a.supplierId=6363) OR (a.articleSearch='SKCA0050947' AND a.supplierId=6357) OR ( a.articleSearch IN ('5703552SX', '5703553SX', '5703851SX', '5703852SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('88551', '88552', '88586') AND a.supplierId=6691) OR ( a.articleSearch IN ('33101412', '33101416', '60936121', '60936122', '60939023', '60939024') AND a.supplierId=151) OR ( a.articleSearch IN ('RS10791', 'RS10792', 'RS12153', 'RS12154') AND a.supplierId=6312) OR ( a.articleSearch IN ('M188', 'M188S', 'M189', 'M189S', 'R754', 'R755', 'R758', 'R758S', 'R759', 'R759S') AND a.supplierId=4414) OR ( a.articleSearch IN ('700826', '700827') AND a.supplierId=301) OR ( a.articleSearch IN ('785715', '785716') AND a.supplierId=4970) OR ( a.articleSearch IN ('8500235043', '8500235044', '850025553', '850025554', '850025555', '850025556') AND a.supplierId=108) OR ( a.articleSearch IN ('0231199', '0231200', '0231331', '0231332', '0231333', '0231334') AND a.supplierId=209) OR ( a.articleSearch IN ('JBJ813', 'JBJ814', 'JTC2293', 'JTC2294') AND a.supplierId=4501) OR (a.articleSearch='10518' AND a.supplierId=6311) OR ( a.articleSearch IN ('392744', '392745') AND a.supplierId=4730) OR ( a.articleSearch IN ('V302517', 'V302518', 'V460329', 'V460330') AND a.supplierId=183) OR ( a.articleSearch IN ('26258', '26259') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG2034690', 'WG2034691') AND a.supplierId=4832) OR ( a.articleSearch IN ('GM5805', 'TG5378', 'TG5379') AND a.supplierId=4894)An internal server error occurred.