SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.manufacturerId, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps.id AS supplier_product_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 ('26337', '26339', '09146', '10895', '33094', '48625') AND a.supplierId=101) OR ( a.articleSearch IN ('06881', '10776') AND a.supplierId=4683) OR ( a.articleSearch IN ('4001417', '4003366', '4005277') AND a.supplierId=260) OR ( a.articleSearch IN ('60926337', '60600005', '60910895', '60926339', '60933094', '60948625') AND a.supplierId=151) OR (a.articleSearch='50608' AND a.supplierId=4598) OR (a.articleSearch='RNG45677' AND a.supplierId=4987) OR ( a.articleSearch IN ('210476', '211740', '270279', '211349') AND a.supplierId=206) OR (a.articleSearch='2301' AND a.supplierId=317) OR (a.articleSearch='10340646' AND a.supplierId=479) OR ( a.articleSearch IN ('11149AP', '13438AP', '14244AP', '24742AP') AND a.supplierId=6400) OR ( a.articleSearch IN ('30776', '70684') AND a.supplierId=4576) OR ( a.articleSearch IN ('5301100', '7201112R', '7201113') AND a.supplierId=257) OR ( a.articleSearch IN ('10RN2001', '30RN2001', '30RN2003', '30RN2005') AND a.supplierId=4829) OR (a.articleSearch='FT1176' AND a.supplierId=4737) OR (a.articleSearch='110118310' AND a.supplierId=323) OR ( a.articleSearch IN ('4402011', '4402012', '4408039', '4413020', '4413021', '4413022', '4413023', '4413024', '4413025') AND a.supplierId=4306) OR (a.articleSearch='PSD0033' AND a.supplierId=4337) OR ( a.articleSearch IN ('0011020032', '0295008251') AND a.supplierId=4995) OR ( a.articleSearch IN ('042175B', '043171B') AND a.supplierId=49) OR ( a.articleSearch IN ('BU0430', 'TRC7316') AND a.supplierId=478) OR ( a.articleSearch IN ('2056', 'BR1442') AND a.supplierId=208) OR ( a.articleSearch IN ('BBJ5432', 'BCA5971', 'BSK6049') AND a.supplierId=475) OR (a.articleSearch='BSG75315029' AND a.supplierId=4455) OR ( a.articleSearch IN ('020326', '750460') AND a.supplierId=405) OR (a.articleSearch='704000681' AND a.supplierId=6411) OR ( a.articleSearch IN ('CBJ7006', 'CCA2026') AND a.supplierId=421) OR ( a.articleSearch IN ('21652438', '21652451', '49398576', '49398656', '49399143') AND a.supplierId=140) OR (a.articleSearch='CS1003R' AND a.supplierId=4880) OR ( a.articleSearch IN ('TC884', 'TD319W') AND a.supplierId=89) OR ( a.articleSearch IN ('D110162', 'D120194') AND a.supplierId=186) OR (a.articleSearch='B5015' AND a.supplierId=4396) OR (a.articleSearch='1441300' AND a.supplierId=253) OR (a.articleSearch='ARM020N' AND a.supplierId=4882) OR ( a.articleSearch IN ('A11854', 'A12876', 'A12898', 'D11855', 'D12877') AND a.supplierId=471) OR ( a.articleSearch IN ('20001241', '2790577', '37034035') AND a.supplierId=4135) OR ( a.articleSearch IN ('22SB062', '22TC281') AND a.supplierId=4003) OR (a.articleSearch='1634863580' AND a.supplierId=4391) OR ( a.articleSearch IN ('821032310', '829011810') AND a.supplierId=192) OR ( a.articleSearch IN ('SS6260', 'SS6264') AND a.supplierId=267) OR ( a.articleSearch IN ('0360', 'TR428') AND a.supplierId=4834) OR (a.articleSearch='FT15531' AND a.supplierId=4938) OR (a.articleSearch='2420CLIF' AND a.supplierId=4674) OR (a.articleSearch='BJ10042' AND a.supplierId=271) OR ( a.articleSearch IN ('FBJ5432', 'FCA5971', 'FSK6049') AND a.supplierId=407) OR ( a.articleSearch IN ('2200001', '2200008', '2209014', '2209038') AND a.supplierId=4727) OR (a.articleSearch='FZ9570' AND a.supplierId=4467) OR (a.articleSearch='FSB1535' AND a.supplierId=486) OR ( a.articleSearch IN ('R926', 'RSB1') AND a.supplierId=6101) OR (a.articleSearch='CAS0375' AND a.supplierId=6443) OR ( a.articleSearch IN ('510766', 'S060645') AND a.supplierId=373) OR (a.articleSearch='GSP501928' AND a.supplierId=6529) OR (a.articleSearch='J4911059' AND a.supplierId=72) OR ( a.articleSearch IN ('594109', '599009') AND a.supplierId=239) OR ( a.articleSearch IN ('BS112R', 'LB100', 'BS113') AND a.supplierId=156) OR ( a.articleSearch IN ('53100', '72112R', '72113') AND a.supplierId=481) OR ( a.articleSearch IN ('4040100280', '4340300300', '4340300900') AND a.supplierId=268) OR ( a.articleSearch IN ('9040137', '9050266') AND a.supplierId=185) OR ( a.articleSearch IN ('850025519', '850025569', '850025813', '85010214') AND a.supplierId=286) OR ( a.articleSearch IN ('KBJ5432', 'KCA5971') AND a.supplierId=4879) OR (a.articleSearch='47221Z' AND a.supplierId=387) OR (a.articleSearch='6032362' AND a.supplierId=78) OR (a.articleSearch='4215190' AND a.supplierId=4546) OR ( a.articleSearch IN ('2247701', '2248701', '2889203', '22477', '22487', '28892') AND a.supplierId=35) OR ( a.articleSearch IN ('C5244R', 'C8502') AND a.supplierId=4600) OR ( a.articleSearch IN ('301181396200', '301181396400') AND a.supplierId=4723) OR ( a.articleSearch IN ('MCC015595', 'MSA015495', 'MSA016022', 'MSC015378') AND a.supplierId=4570) OR ( a.articleSearch IN ('19197', '33100') AND a.supplierId=133) OR (a.articleSearch='28892PCSMS' AND a.supplierId=358) OR (a.articleSearch='720964' AND a.supplierId=403) OR (a.articleSearch='MSA8113' AND a.supplierId=4773) OR ( a.articleSearch IN ('00360', '52051') AND a.supplierId=4664) OR ( a.articleSearch IN ('55003018', '57020918', '58062802', '87020918') AND a.supplierId=94) OR ( a.articleSearch IN ('16160100007', '16160500007HD', '16166100007HD') AND a.supplierId=144) OR (a.articleSearch='DB35070' AND a.supplierId=6495) OR ( a.articleSearch IN ('L25519', 'L25569', 'L25813') AND a.supplierId=4752) OR ( a.articleSearch IN ('RESB1333', 'REWP0338', 'REWP0338P', 'REWP13766', 'REWP1566') AND a.supplierId=134) OR (a.articleSearch='VSA866' AND a.supplierId=4564) OR (a.articleSearch='N4911036' AND a.supplierId=248) OR ( a.articleSearch IN ('5013912', '5013912PRO', '5103911') AND a.supplierId=127) OR (a.articleSearch='N421N153' AND a.supplierId=440) OR (a.articleSearch='ZWDRE017' AND a.supplierId=6355) OR ( a.articleSearch IN ('0783209', '1215099', '1215300', '0782832') AND a.supplierId=198) OR (a.articleSearch='G403988C' AND a.supplierId=6522) OR (a.articleSearch='2398154' AND a.supplierId=4380) OR (a.articleSearch='SSW104801' AND a.supplierId=378) OR ( a.articleSearch IN ('G6605', 'G82012', 'G9570') AND a.supplierId=129) OR (a.articleSearch='2184' AND a.supplierId=331) OR (a.articleSearch='PSE1282' AND a.supplierId=4558) OR (a.articleSearch='23070095' AND a.supplierId=4686) OR ( a.articleSearch IN ('EMS2186', 'QSA1548S', 'EM2186', 'QSJ1548S', 'QSJ9076S') AND a.supplierId=57) OR (a.articleSearch='R58046' AND a.supplierId=4303) OR ( a.articleSearch IN ('40NI085', '40NI086') AND a.supplierId=4869) OR (a.articleSearch='RH142005' AND a.supplierId=6892) OR ( a.articleSearch IN ('2462S0028', '273C0125') AND a.supplierId=6358) OR ( a.articleSearch IN ('BCREBS006', 'BCSB144', 'TCR735', 'TCR735S', 'TCR745', 'TCR745S') AND a.supplierId=6698) OR ( a.articleSearch IN ('01700401', '96904991') AND a.supplierId=430) OR ( a.articleSearch IN ('935525', '985511', '985518') AND a.supplierId=23) OR ( a.articleSearch IN ('5580', '6171', '805104', '805605') AND a.supplierId=135) OR ( a.articleSearch IN ('VKDS326103B', 'VKDS336016', 'VKDS336024') AND a.supplierId=50) OR ( a.articleSearch IN ('410085', '46450', '50213') AND a.supplierId=6363) OR ( a.articleSearch IN ('SKCA0050122', 'SKSL0260029') AND a.supplierId=6357) OR ( a.articleSearch IN ('T400360', 'T452051') AND a.supplierId=4667) OR ( a.articleSearch IN ('5200161SX', '5702327ASX', '5702327SX', '7223036SX') AND a.supplierId=4595) OR (a.articleSearch='81053' AND a.supplierId=6691) OR ( a.articleSearch IN ('4006187', '4706303', '5700749') AND a.supplierId=4758) OR ( a.articleSearch IN ('RS02', 'RS2671') AND a.supplierId=6312) OR ( a.articleSearch IN ('R735', 'R735S', 'R745', 'R745S', 'REBS006', 'SB144') AND a.supplierId=4414) OR ( a.articleSearch IN ('775402', '785364') AND a.supplierId=4970) OR ( a.articleSearch IN ('850025519', '850025569', '850025813', '85010214') AND a.supplierId=108) OR ( a.articleSearch IN ('JBU160', 'JTC405', 'JTC811') AND a.supplierId=4501) OR ( a.articleSearch IN ('10227', '10227A') AND a.supplierId=6311) OR (a.articleSearch='415866' AND a.supplierId=4730) OR ( a.articleSearch IN ('8628495', '8628496') AND a.supplierId=4999) OR ( a.articleSearch IN ('V460114', 'V469590') AND a.supplierId=183) OR ( a.articleSearch IN ('16026', '17149') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG1795830', 'WG1922790', 'WG1922802') AND a.supplierId=4832)An internal server error occurred.