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='D5147' AND a.supplierId=351) OR ( a.articleSearch IN ('SM9604', 'SM9603', 'SM9111', 'SM9615') AND a.supplierId=478) OR ( a.articleSearch IN ('12224371', '11268253', '12313204') AND a.supplierId=16) OR ( a.articleSearch IN ('88385A', '891890', '84224A', '84224L', '84287A', '88385L') AND a.supplierId=14) OR ( a.articleSearch IN ('BSG90700046', 'BSG90700119', 'BSG90700189', 'BSG90700066', 'BSG90700067', 'BSG90705022') AND a.supplierId=4455) OR ( a.articleSearch IN ('80001575', '80001707', '80003872') AND a.supplierId=140) OR ( a.articleSearch IN ('814015410', '713007920', '815007830', '713042520', '810009410', '810012810', '811009730', '814015510', '814018710', '814018810', '815008630') AND a.supplierId=192) OR ( a.articleSearch IN ('2329004KIT', 'VWBT5', 'VWBTRT5F', 'VWSST5', 'VWSSTRT5F') AND a.supplierId=4674) OR ( a.articleSearch IN ('23116', '33391', '106305', '103192', '104065', '106307', '172135', '26556', '33390', '36568', '37344') AND a.supplierId=101) OR (a.articleSearch='SMB24070' AND a.supplierId=271) OR ( a.articleSearch IN ('11412007K', '29412001S', '29407074S', '29407492S', '29498021S') AND a.supplierId=4727) OR ( a.articleSearch IN ('514552', '519011', '5405030PK', '514552S', '518060', '532859') AND a.supplierId=373) OR ( a.articleSearch IN ('1142401900', '1142402000', '1142602300') AND a.supplierId=268) OR ( a.articleSearch IN ('910136', 'SM1715') AND a.supplierId=85) OR ( a.articleSearch IN ('2822801', '3394601', '3394701', '3833801', '3928401', '3945001', '3990701', '28228') AND a.supplierId=35) OR ( a.articleSearch IN ('MCC015226', 'MCC015261') AND a.supplierId=4570) OR ( a.articleSearch IN ('05415', '05410', '51301') AND a.supplierId=4664) OR ( a.articleSearch IN ('1006410004', '1006400012', '1006411002HD', '1006410002', '1006410005') AND a.supplierId=144) OR (a.articleSearch='DB47125' AND a.supplierId=6495) OR ( a.articleSearch IN ('PK330', 'L29917', 'L29918', 'MK271', 'MK346', 'MK372') AND a.supplierId=4752) OR ( a.articleSearch IN ('F86540', 'F87494', 'F87575') AND a.supplierId=129) OR ( a.articleSearch IN ('16730', '09091', '33788') AND a.supplierId=4683) OR ( a.articleSearch IN ('PSE4056', 'PSE4518', 'PSE4437', 'PSE6329') AND a.supplierId=4558) OR ( a.articleSearch IN ('802337', '801454', '900189', '802455', '801055', '803104', '803170', '803283') AND a.supplierId=32) OR ( a.articleSearch IN ('2656060', '2656082', '2656134') AND a.supplierId=260) OR ( a.articleSearch IN ('863411', '863419KIT', '863418', '864400', '864401') AND a.supplierId=135) OR ( a.articleSearch IN ('KBLF41803', 'KB65715', 'M25408') AND a.supplierId=110) OR ( a.articleSearch IN ('1217386SX', '1298191SX', '1127357SX', '1237078SX', '1198109SX', '2617130SX', '2617187SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30933391', '32923116', '30103192', '30104065', '30106305', '30106307', '30926556', '30933390', '30936568', '30937344', '33101196') AND a.supplierId=151) OR ( a.articleSearch IN ('6301788', '6310942', '6308105') AND a.supplierId=4758) OR (a.articleSearch='JSB143' AND a.supplierId=4501) OR ( a.articleSearch IN ('44120813201', '44121789301', '44120025301', '44120070101', '44121439901', '44121784201', '44121789401') AND a.supplierId=4346) OR ( a.articleSearch IN ('SM3007S', 'GM2022', 'GM8017') AND a.supplierId=4894) OR (a.articleSearch='45VW4500' AND a.supplierId=4829) OR (a.articleSearch='45760' AND a.supplierId=4598) OR (a.articleSearch='55624' AND a.supplierId=6558) OR ( a.articleSearch IN ('170351', '23305', '23306', '233352', '23343') AND a.supplierId=317) OR (a.articleSearch='79801' AND a.supplierId=4576) OR (a.articleSearch='SMA0195' AND a.supplierId=257) OR ( a.articleSearch IN ('FT1957', 'FT2204', 'FT2206') AND a.supplierId=4737) OR ( a.articleSearch IN ('110069010', '110191710') AND a.supplierId=323) OR ( a.articleSearch IN ('0011016592', '0011021109', '0011028898', '0011028907', '0011028961') AND a.supplierId=4995) OR ( a.articleSearch IN ('043824B', '047167B', '047168B') AND a.supplierId=49) OR ( a.articleSearch IN ('51893', '52007', '53231', '6456', '6584') AND a.supplierId=208) OR ( a.articleSearch IN ('BSM5205', 'BSM5212', 'BSM5312') AND a.supplierId=475) OR ( a.articleSearch IN ('7E0412331', '7H0412249A', '7H0412303A') AND a.supplierId=6366) OR ( a.articleSearch IN ('461216', '462444', '462453', '462454') AND a.supplierId=405) OR ( a.articleSearch IN ('CTSM9013', 'CTSM9046') AND a.supplierId=421) OR (a.articleSearch='502051' AND a.supplierId=6263) OR (a.articleSearch='PK4209' AND a.supplierId=6479) OR ( a.articleSearch IN ('BSJ10085', 'BSJ20024', 'BSJ30016') AND a.supplierId=89) OR (a.articleSearch='D600032' AND a.supplierId=186) OR (a.articleSearch='B1072' AND a.supplierId=4396) OR ( a.articleSearch IN ('7324041', '7324826', '7325594') AND a.supplierId=4135) OR (a.articleSearch='520146' AND a.supplierId=4512) OR ( a.articleSearch IN ('31SK211', '31SM822', '31SM823', '31SM824', '31ST822', '31ST823') AND a.supplierId=4003) OR ( a.articleSearch IN ('SS7880', 'SS7881', 'SS9124') AND a.supplierId=267) OR ( a.articleSearch IN ('10329', '10334', '13212', '15927', '16210') AND a.supplierId=4834) OR ( a.articleSearch IN ('FSM5205', 'FSM5212', 'FSM5312') AND a.supplierId=407) OR (a.articleSearch='FL5439J' AND a.supplierId=236) OR (a.articleSearch='GK385' AND a.supplierId=4639) OR ( a.articleSearch IN ('SBB0040', 'SM0423') AND a.supplierId=6443) OR ( a.articleSearch IN ('200069', '590146', 'KS198') AND a.supplierId=239) OR (a.articleSearch='SM0195' AND a.supplierId=156) OR (a.articleSearch='SMJ0195' AND a.supplierId=481) OR (a.articleSearch='MS33005' AND a.supplierId=6786) OR (a.articleSearch='209038' AND a.supplierId=185) OR ( a.articleSearch IN ('850029917', '850029918', '850029939', '850029940', '850029941') AND a.supplierId=286) OR (a.articleSearch='21628Z' AND a.supplierId=387) OR ( a.articleSearch IN ('4090060', '4090810') AND a.supplierId=4546) OR ( a.articleSearch IN ('MA1088LR', 'MA5060LR') AND a.supplierId=4600) OR ( a.articleSearch IN ('A7W017MT', 'A7W028MT', 'A7W038MT', 'A7W041MT', 'A7W042MT', 'A8W021MT') AND a.supplierId=4427) OR ( a.articleSearch IN ('32899', '36959', '37854') AND a.supplierId=133) OR ( a.articleSearch IN ('721291', '723406', '723590', '723657') AND a.supplierId=403) OR ( a.articleSearch IN ('6490243', '6490252', '6490279', '6490293', 'WMF2332') AND a.supplierId=94) OR (a.articleSearch='VOSB10087' AND a.supplierId=134) OR ( a.articleSearch IN ('LVSM1028', 'LVSM1061', 'LVSM1102') AND a.supplierId=4564) OR ( a.articleSearch IN ('664704', '674715', '694732') AND a.supplierId=127) OR ( a.articleSearch IN ('ADVW001', 'ADVW003') AND a.supplierId=6355) OR ( a.articleSearch IN ('DCK504804', 'SMK301800') AND a.supplierId=378) OR ( a.articleSearch IN ('34216', '34217', '34218', '342182', '34273', '35162', '35163', '351632', '37255', '37685', '37686', '48511', '50759') AND a.supplierId=331) OR ( a.articleSearch IN ('23140293', '23140505') AND a.supplierId=4686) OR ( a.articleSearch IN ('EMA6134', 'EMR6134', 'QAM164') AND a.supplierId=57) OR ( a.articleSearch IN ('R52212', 'R52513', 'R52513K', 'R54539', 'R54540', 'R54540K', 'R54936') AND a.supplierId=4303) OR ( a.articleSearch IN ('815406', '825409', '825409S', '825410', '835422', '845404', '865403') AND a.supplierId=23) OR (a.articleSearch='KS31012' AND a.supplierId=6377) OR ( a.articleSearch IN ('410424', '410425', '413057', '413378', '413379') AND a.supplierId=6363) OR ( a.articleSearch IN ('T405410', 'T405415', 'T451301') AND a.supplierId=4667) OR (a.articleSearch='KSU6826' AND a.supplierId=6312) OR ( a.articleSearch IN ('112051', '112869', '112903', '114886', '117606', '118213') AND a.supplierId=301) OR (a.articleSearch='782105' AND a.supplierId=4970) OR ( a.articleSearch IN ('850029917', '850029918', '850029939', '850029940', '850029941') AND a.supplierId=108) OR ( a.articleSearch IN ('0730213', '0731225') AND a.supplierId=209) OR ( a.articleSearch IN ('61137', '61138', '61138B', '61143') AND a.supplierId=6311) OR ( a.articleSearch IN ('392880', '392880C', '392881') AND a.supplierId=4730) OR ( a.articleSearch IN ('V100785', 'V102715', 'V103006', 'V105385', 'V106085') AND a.supplierId=183) OR ( a.articleSearch IN ('VE51893', 'VE52007', 'VE53231', 'VE6456', 'VE6584') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG1795332', 'WG1994941', 'WG2029908') AND a.supplierId=4832) OR ( a.articleSearch IN ('321759', '380917', '381053', '381065', '381073') AND a.supplierId=6347) OR (a.articleSearch='ZVTM085A' AND a.supplierId=6274)An internal server error occurred.