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 ('6139405', '6140405', '6139374', '6140374', '6141374', '6141405', '6142374', '6142405', '6143374', '6144374', '6147374', '6148374', '6149405', '6150374', '6150405', '6151405', '6152405', '6341401', '6341405', '6342401', '6342405', '6471376', '6341376', '6342376') AND a.supplierId=362) OR ( a.articleSearch IN ('PMG0001M01', 'PMG0001M02', 'PMG1220C03', 'PMG1220C04', 'PMG1220G03', 'PMG1220G04') AND a.supplierId=4558) OR ( a.articleSearch IN ('1232M04', '1232M09', '1232M12', '1232M15', '1247G05', '1247G06', '1247M01', '1247M02', '1247M03', '1247M04', '1247M09', '1247M10', '1247M16', '1249M01', '1249M05') AND a.supplierId=4657) OR ( a.articleSearch IN ('540203051361P', '540203051364P', '540203051365P', '5402032001199P', '5402032001201P', '5402032001202P', '5402032001219P', '5402032001220P', '5402032001221P', '5402032001222P', '5402032001223P', '5402032001224P', '5402032001225P', '5402032001226P', '6103011321291P', '610303039353P') AND a.supplierId=4555) OR ( a.articleSearch IN ('BSG30900093', 'BSG30900094', 'BSG30910021', 'BSG30910022', 'BSG30910024') AND a.supplierId=4455) OR ( a.articleSearch IN ('1418027', '1418124', '1418125', '1418324', '1418325', '1428124', '1428224', '1428324', '1428627') AND a.supplierId=253) OR ( a.articleSearch IN ('27092101', '27092102', '27092111', '27092112', '27092747', '27092748', '27093005', '27093006', '27093235', '27093236', '31316841', '41316851', '41316852') AND a.supplierId=4841) OR ( a.articleSearch IN ('32123783', '32133721', '32133821') AND a.supplierId=138) OR ( a.articleSearch IN ('54111564', '54121564', '54311556', '54311564', '54321556', '54321564', '54711556', '54721556', '54731564', '54741564', '55311563', '57311564', '57321564') AND a.supplierId=4965) OR ( a.articleSearch IN ('25331065', '25361041', '25361043', '25361044', '25361061', '25361062', '25561031', '25561033', '25561035', '25561037') AND a.supplierId=78) OR (a.articleSearch='L0667' AND a.supplierId=4572) OR ( a.articleSearch IN ('182209010800', '351991203470') AND a.supplierId=4723) OR ( a.articleSearch IN ('TYC3100117', 'TYC31001171', 'TYC3100118', 'TYC31001181', 'TYC3100132', 'TYC3100134', 'TYC3100138', 'TYC3100189', 'TYC3100190', 'TYC3100191', 'TYC3100192', 'TYC3100206', 'TYC3100208', 'TYC3100210') AND a.supplierId=4652) OR ( a.articleSearch IN ('FD1107323', 'FD1107323P', 'FD1107333', 'FD1107333P', 'FD1107343', 'FD1107343P', 'FD1107534', 'FD4267513', 'FD4267514', 'FD4287323', 'FD4287323P', 'FD4287324', 'FD4287324P', 'OP3547413', 'FD4267534') AND a.supplierId=340) OR ( a.articleSearch IN ('14019', '54685', '54686', '56073', '56074', '56075', '56076', '56077', '56078', '56079', '56080', '56081', '56082', '56083', '56084', '56093', '56094', '56097', '56098') AND a.supplierId=4680) OR (a.articleSearch='L0667' AND a.supplierId=4582) OR ( a.articleSearch IN ('3100117', '31001171', '3100118', '31001181', '3100132', '3100134', '3100138', '3100189', '3100190', '3100191', '3100192', '3100206', '3100208', '3100210') AND a.supplierId=61) OR ( a.articleSearch IN ('1866837', '1866838', '1881808', '1881818', '1881820', '1881828', '1882807', '1882817', '1945807', '1945808', '1945817', '1945818', '1945827') AND a.supplierId=36) OR (a.articleSearch='V25690008' AND a.supplierId=183)An internal server error occurred.