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 ('SB256', 'SB049', 'SB958', 'SB2017') AND a.supplierId=225) OR ( a.articleSearch IN ('70285', '70297') AND a.supplierId=4576) OR ( a.articleSearch IN ('180018110', '180018310', '180024510') AND a.supplierId=323) OR ( a.articleSearch IN ('1457429795', '1457433747', '0986626806', '1457429944') AND a.supplierId=30) OR (a.articleSearch='BSG90135019' AND a.supplierId=4455) OR ( a.articleSearch IN ('CAF100147R', 'CAF100733P', 'CAF100706R', 'U733606', 'W147606', 'W706606') AND a.supplierId=43) OR ( a.articleSearch IN ('MA1037', 'MA1113', 'MA712') AND a.supplierId=163) OR ( a.articleSearch IN ('1616248080', 'E147114', 'E147099') AND a.supplierId=4391) OR ( a.articleSearch IN ('11209', '21106', '31234') AND a.supplierId=101) OR ( a.articleSearch IN ('FAI206', 'FAI211') AND a.supplierId=271) OR ( a.articleSearch IN ('AM422', 'AP1572', 'AP1573', 'AR265') AND a.supplierId=256) OR ( a.articleSearch IN ('CA4219', 'CA5367', 'CA5781') AND a.supplierId=6356) OR ( a.articleSearch IN ('E169L', 'E243L', 'E120L', 'E243L01') AND a.supplierId=81) OR ( a.articleSearch IN ('1118601000', '1118602100') AND a.supplierId=268) OR ( a.articleSearch IN ('A0072', 'A0074') AND a.supplierId=4378) OR ( a.articleSearch IN ('LX314', 'LX537', 'LX538', 'LX99') AND a.supplierId=287) OR ( a.articleSearch IN ('50013286', '50013293', '50013335') AND a.supplierId=432) OR ( a.articleSearch IN ('LA1004', 'LA1011', 'LA10111') AND a.supplierId=4600) OR (a.articleSearch='153071762346' AND a.supplierId=4723) OR ( a.articleSearch IN ('MMF015043', 'MMF015193', 'MMF015116') AND a.supplierId=4570) OR ( a.articleSearch IN ('C17201', 'C172013', 'C29198', 'C291981') AND a.supplierId=4) OR (a.articleSearch='16569' AND a.supplierId=244) OR ( a.articleSearch IN ('EL3510', 'ELP3732', 'ELP3901', 'FA1643', 'FA3149') AND a.supplierId=218) OR ( a.articleSearch IN ('1121290016', '1121290039', '1121290041', '1123210013') AND a.supplierId=144) OR ( a.articleSearch IN ('A266', 'K433', 'A136', 'K4331') AND a.supplierId=462) OR (a.articleSearch='AFAU037' AND a.supplierId=6495) OR ( a.articleSearch IN ('00357', '00356') AND a.supplierId=4683) OR ( a.articleSearch IN ('PF1038', 'PF1090', 'PF1249') AND a.supplierId=4558) OR ( a.articleSearch IN ('A1050', 'A210', 'A879') AND a.supplierId=38) OR ( a.articleSearch IN ('A3103', 'A6809', 'A3101', 'A31011') AND a.supplierId=6405) OR ( a.articleSearch IN ('7100314SX', '7100537SX', '7101661SX', '7101887SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('2719500', '3008500', '3019300', '2798200') AND a.supplierId=137) OR ( a.articleSearch IN ('11290197701', '11290198501', '11290197801', '11290198601') AND a.supplierId=4346) OR ( a.articleSearch IN ('A60259', 'A60415', 'A60492', 'A63516') AND a.supplierId=4814) OR ( a.articleSearch IN ('1500145', '1500146', '1500154', '1500257') AND a.supplierId=317) OR ( a.articleSearch IN ('MD354', 'MD494', 'MD9420') AND a.supplierId=180) OR (a.articleSearch='X1521733' AND a.supplierId=4975) OR ( a.articleSearch IN ('PAL22050', 'PAL22226') AND a.supplierId=442) OR (a.articleSearch='LAT437' AND a.supplierId=4337) OR ( a.articleSearch IN ('P085A', 'R982', 'RA195') AND a.supplierId=4280) OR ( a.articleSearch IN ('ADBP220007', 'ADV182285') AND a.supplierId=350) OR ( a.articleSearch IN ('BFA2092', 'BFA2162') AND a.supplierId=475) OR ( a.articleSearch IN ('EAF218', 'EAF261', 'EAF327') AND a.supplierId=421) OR ( a.articleSearch IN ('28000200372', '28000200932', '28000204312', '28000204582') AND a.supplierId=6513) OR ( a.articleSearch IN ('FL6817', 'FLI6627', 'PA7198') AND a.supplierId=437) OR ( a.articleSearch IN ('A140014', 'A140021', 'A140457', 'A140863') AND a.supplierId=186) OR ( a.articleSearch IN ('DA2131', 'DA2213', 'DA2457', 'DA2704') AND a.supplierId=4396) OR (a.articleSearch='1110010067' AND a.supplierId=4345) OR ( a.articleSearch IN ('P771593', 'P771594') AND a.supplierId=6723) OR ( a.articleSearch IN ('DP1110100219', 'DP1110100275', 'DP1110100600', 'DP1110100737') AND a.supplierId=4948) OR ( a.articleSearch IN ('DAF314', 'DAF537', 'DAF538', 'DAF99') AND a.supplierId=4881) OR ( a.articleSearch IN ('FA1259', 'FA1980', 'FC486') AND a.supplierId=4838) OR ( a.articleSearch IN ('HP2002', 'HP2002A', 'HP915', 'HPU4349') AND a.supplierId=4659) OR ( a.articleSearch IN ('AF25320', 'AF990') AND a.supplierId=4581) OR ( a.articleSearch IN ('AG219', 'AG220') AND a.supplierId=4663) OR (a.articleSearch='SA10940' AND a.supplierId=6309) OR (a.articleSearch='16569' AND a.supplierId=341) OR ( a.articleSearch IN ('B2W009PR', 'B2W017PR', 'B2W037PR') AND a.supplierId=4689) OR ( a.articleSearch IN ('F201601', 'F201801', 'F216201', 'F231601') AND a.supplierId=185) OR ( a.articleSearch IN ('FA102Z', 'FA137Z') AND a.supplierId=387) OR ( a.articleSearch IN ('1710640', '1710670') AND a.supplierId=4546) OR (a.articleSearch='LFAF502' AND a.supplierId=4973) OR ( a.articleSearch IN ('60161', '60206', '60538') AND a.supplierId=133) OR ( a.articleSearch IN ('17177LFPCSMS', '172013LFPCSMS', '291981LFPCSMS', '29198LFPCSMS', '450001702', '450001712', '450002123', '450002132') AND a.supplierId=358) OR ( a.articleSearch IN ('260160', '260161') AND a.supplierId=403) OR ( a.articleSearch IN ('P085', 'R195', 'R982') AND a.supplierId=4470) OR ( a.articleSearch IN ('VFA735', 'VFA905', 'VFA906') AND a.supplierId=4564) OR ( a.articleSearch IN ('PA259', 'PA3516', 'PA415', 'PA492') AND a.supplierId=490) OR ( a.articleSearch IN ('2133127', '2133305', '2133686') AND a.supplierId=4380) OR ( a.articleSearch IN ('EAF321010', 'EAF332210', 'EAF340920') AND a.supplierId=378) OR ( a.articleSearch IN ('FA00868', 'FA00869', 'FA01086') AND a.supplierId=129) OR ( a.articleSearch IN ('15111003', '15121018') AND a.supplierId=4686) OR ( a.articleSearch IN ('QFA0048', 'QFA0138', 'QFA0201', 'QFA0487') AND a.supplierId=57) OR ( a.articleSearch IN ('8A0025', '8A0134') AND a.supplierId=6358) OR ( a.articleSearch IN ('CH1297', 'CP0045', 'CP0045F') AND a.supplierId=4263) OR ( a.articleSearch IN ('S2940A', 'S3085A', 'S3193A', 'S7195A') AND a.supplierId=142) OR ( a.articleSearch IN ('SKAF0060024', 'SKAF0060135') AND a.supplierId=6357) OR ( a.articleSearch IN ('30921106', '60931234') AND a.supplierId=151) OR ( a.articleSearch IN ('AR259', 'AR415PM', 'AR415PMS', 'AR492I') AND a.supplierId=4011) OR ( a.articleSearch IN ('A259', 'A415', 'A492') AND a.supplierId=91) OR ( a.articleSearch IN ('100806', '107000', '112370', '112386') AND a.supplierId=301) OR ( a.articleSearch IN ('V100606', 'V100610', 'V101614', 'V103135') AND a.supplierId=183) OR ( a.articleSearch IN ('585107', '585645') AND a.supplierId=21) OR ( a.articleSearch IN ('WG1018343', 'WG1018348', 'WG1147925', 'WG1216405', 'WG1216586', 'WG1216587', 'WG1216958', 'WG1428513', 'WG1430867', 'WG1792216', 'WG1792472', 'WG2152068') AND a.supplierId=4832) OR ( a.articleSearch IN ('42402', 'WA6094', 'WA6344', 'WA6444', 'WA9468') AND a.supplierId=324) OR ( a.articleSearch IN ('312595', '312635', '312647', '313969') AND a.supplierId=6347) OR ( a.articleSearch IN ('LF1195', 'LF1196') AND a.supplierId=4894)An internal server error occurred.