SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.manufacturerId, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps.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 ('SM0103', 'SM9616') AND a.supplierId=478) OR ( a.articleSearch IN ('BSG90923019', 'BSG90923020', 'BSG90700235', 'BSG90720234') AND a.supplierId=4455) OR ( a.articleSearch IN ('GM2010', 'IK1356', 'IK1357') AND a.supplierId=4894) OR ( a.articleSearch IN ('45725', '45742', '45743', '45759') AND a.supplierId=4598) OR ( a.articleSearch IN ('50201', '50202', '50235', '51215S', '51215SET') AND a.supplierId=6558) OR ( a.articleSearch IN ('17728', '17763', '17764', '900297') AND a.supplierId=317) OR (a.articleSearch='SMA0242' AND a.supplierId=257) OR ( a.articleSearch IN ('FT1946', 'FT1953') AND a.supplierId=4737) OR ( a.articleSearch IN ('110031110', '110031210', '110045810') AND a.supplierId=323) OR ( a.articleSearch IN ('0023001059', '0028015488', '0028015489') AND a.supplierId=4995) OR ( a.articleSearch IN ('043491B', '043494B', '043495B', '043807B', '049216B') AND a.supplierId=49) OR (a.articleSearch='12117239' AND a.supplierId=16) OR ( a.articleSearch IN ('50170', '50171', '5954') AND a.supplierId=208) OR ( a.articleSearch IN ('84031A', '87404A', '88561A', '88130A', '2256087404A') AND a.supplierId=14) OR ( a.articleSearch IN ('BSM5012', 'BSM5118') AND a.supplierId=475) OR (a.articleSearch='B12237' AND a.supplierId=4815) OR ( a.articleSearch IN ('191512333', '191512335', '1J0513353C') AND a.supplierId=6366) OR ( a.articleSearch IN ('460188', '461036') AND a.supplierId=405) OR ( a.articleSearch IN ('CTSM9059', 'CTSM9109') AND a.supplierId=421) OR ( a.articleSearch IN ('21652954', '21652963', '21652964') AND a.supplierId=140) OR (a.articleSearch='502317' AND a.supplierId=6263) OR (a.articleSearch='BSJ10005' AND a.supplierId=89) OR ( a.articleSearch IN ('D600066', 'D600067') AND a.supplierId=186) OR ( a.articleSearch IN ('B1023', 'B1067', 'B1093') AND a.supplierId=4396) OR ( a.articleSearch IN ('1221103', '1221206') AND a.supplierId=253) OR ( a.articleSearch IN ('7324027', '7324106', '7324695', '7326180') AND a.supplierId=4135) OR ( a.articleSearch IN ('02SM301', '31ST851', '31ST852') AND a.supplierId=4003) OR ( a.articleSearch IN ('814007010', '815004130') AND a.supplierId=192) OR (a.articleSearch='SS3066' AND a.supplierId=267) OR ( a.articleSearch IN ('2705', '2718') AND a.supplierId=4834) OR ( a.articleSearch IN ('10819', '14954', '14956', '14958', '22986', '37879') AND a.supplierId=101) OR ( a.articleSearch IN ('FSM5012', 'FSM5118') AND a.supplierId=407) OR ( a.articleSearch IN ('FL4279J', 'FL4391J', 'FL4392J') AND a.supplierId=236) OR ( a.articleSearch IN ('29407111S', '29512002S', '29512004S') AND a.supplierId=4727) OR ( a.articleSearch IN ('GK312', 'GK314') AND a.supplierId=4639) OR ( a.articleSearch IN ('SM0026', 'SM0429') AND a.supplierId=6443) OR ( a.articleSearch IN ('510040', '510041', '510072', '518228S', '532150K') AND a.supplierId=373) OR ( a.articleSearch IN ('597165', '597166', '597167', 'KS134', 'KS136', '590009', 'KS135') AND a.supplierId=239) OR (a.articleSearch='SM0242' AND a.supplierId=156) OR (a.articleSearch='SMJ0242' AND a.supplierId=481) OR (a.articleSearch='MS33011' AND a.supplierId=6786) OR ( a.articleSearch IN ('1152300200', '1152300300', '1152300600', '1152700700') AND a.supplierId=268) OR ( a.articleSearch IN ('2019020', '209135', '209136', '209231') AND a.supplierId=185) OR ( a.articleSearch IN ('850029906', '850029909') AND a.supplierId=286) OR (a.articleSearch='21200Z' AND a.supplierId=387) OR ( a.articleSearch IN ('4090290', '4090585', '4090586') AND a.supplierId=4546) OR ( a.articleSearch IN ('SM9700', 'SM9704') AND a.supplierId=85) OR ( a.articleSearch IN ('2179401', '2707201', '3526901', '21794', '27072', '2709301') AND a.supplierId=35) OR (a.articleSearch='MA1125LR' AND a.supplierId=4600) OR (a.articleSearch='030607020756' AND a.supplierId=4723) OR ( a.articleSearch IN ('A7W004MT', 'A7W005MT', 'A7W012MT') AND a.supplierId=4427) OR ( a.articleSearch IN ('33911', '33962', '33963', '34856', '348562') AND a.supplierId=133) OR ( a.articleSearch IN ('180097000', '180097040') AND a.supplierId=358) OR ( a.articleSearch IN ('720325', '720326', '720327') AND a.supplierId=403) OR ( a.articleSearch IN ('04311', '04320') AND a.supplierId=4664) OR ( a.articleSearch IN ('6490281', 'WMF3353G') AND a.supplierId=94) OR ( a.articleSearch IN ('1005120007', '1005120008', '1005121008', '1005130001', '1005131001') AND a.supplierId=144) OR (a.articleSearch='DB31005' AND a.supplierId=6495) OR ( a.articleSearch IN ('L29906', 'L29909', 'MK118', 'MK133') AND a.supplierId=4752) OR ( a.articleSearch IN ('VOSB10061', 'VOSB10063') AND a.supplierId=134) OR (a.articleSearch='LVSM1051' AND a.supplierId=4564) OR ( a.articleSearch IN ('672312', '674712') AND a.supplierId=127) OR ( a.articleSearch IN ('ADVW007', 'ADVW020', 'ADVW021') AND a.supplierId=6355) OR ( a.articleSearch IN ('SMT200100', 'SMT204100') AND a.supplierId=378) OR ( a.articleSearch IN ('F85380', 'F85402', 'F85403', 'F86382', 'F86382S') AND a.supplierId=129) OR ( a.articleSearch IN ('32258', '32259', '32317', '323172', '35085', '350852', '37256', '37273') AND a.supplierId=331) OR (a.articleSearch='01096' AND a.supplierId=4683) OR ( a.articleSearch IN ('PSE4018', 'PSE4024', 'PSE4232') AND a.supplierId=4558) OR ( a.articleSearch IN ('23140026', '23140183', '23140184') AND a.supplierId=4686) OR (a.articleSearch='EMR6011' AND a.supplierId=57) OR (a.articleSearch='R55451' AND a.supplierId=4303) OR ( a.articleSearch IN ('1180S0103', '1180S0197') AND a.supplierId=6358) OR ( a.articleSearch IN ('825405', '825477S') AND a.supplierId=23) OR ( a.articleSearch IN ('802100', '802374', '802535', '802262') AND a.supplierId=32) OR (a.articleSearch='9005630' AND a.supplierId=260) OR ( a.articleSearch IN ('KS31007', 'MS41011') AND a.supplierId=6377) OR (a.articleSearch='70014K' AND a.supplierId=6322) OR ( a.articleSearch IN ('863500', '863501', '863502') AND a.supplierId=135) OR ( a.articleSearch IN ('VKDA40101T', 'VKDA40104T') AND a.supplierId=50) OR ( a.articleSearch IN ('KB95700', 'KB95704') AND a.supplierId=110) OR ( a.articleSearch IN ('413060', '413061', '413062') AND a.supplierId=6363) OR ( a.articleSearch IN ('SKSS0670017', 'SKSS0670068', 'SKSS0670102', 'SKSS0670198') AND a.supplierId=6357) OR ( a.articleSearch IN ('T404311', 'T404320') AND a.supplierId=4667) OR ( a.articleSearch IN ('1217122SX', '1217575SX', '7111052SX', '7111053SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30540021', '30540024', '30540027', '30550013', '30937879', '32922986') AND a.supplierId=151) OR ( a.articleSearch IN ('6301693', '6302169', '6304971', '6311547') AND a.supplierId=4758) OR ( a.articleSearch IN ('KSA6811', 'KSA6815') AND a.supplierId=6312) OR ( a.articleSearch IN ('102828', '102829', '108242') AND a.supplierId=301) OR ( a.articleSearch IN ('783723', '783839') AND a.supplierId=4970) OR ( a.articleSearch IN ('850029906', '850029909') AND a.supplierId=108) OR (a.articleSearch='0730018' AND a.supplierId=209) OR ( a.articleSearch IN ('JSB118', 'JSL249') AND a.supplierId=4501) OR ( a.articleSearch IN ('391819', '391820', '391882') AND a.supplierId=4730) OR ( a.articleSearch IN ('1J0513353G', '357412331A') AND a.supplierId=4999) OR ( a.articleSearch IN ('V101406', 'V101407', 'V101412') AND a.supplierId=183) OR ( a.articleSearch IN ('249907', '44099', '44100', '44134', 'VE50170', 'VE50171', 'VE5954') AND a.supplierId=4425) OR ( a.articleSearch IN ('45120545901', '45120546001', '45130004701') AND a.supplierId=4346) OR (a.articleSearch='WG2030555' AND a.supplierId=4832) OR ( a.articleSearch IN ('380497', '380503', '380519', '380717', '380835', '381153') AND a.supplierId=6347)An internal server error occurred.