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 ('BSG65700009', 'BSG65700013', 'BSG65700034') AND a.supplierId=4455) OR ( a.articleSearch IN ('814002510', '713001920', '810006410', '814005610', '814006410', '815003430') AND a.supplierId=192) OR ( a.articleSearch IN ('08157', '26934', '03373', '26929', '26935', '37768', '37804', '45042') AND a.supplierId=101) OR ( a.articleSearch IN ('519009', '510922', '510922S', '511651', '518111', '511651S') AND a.supplierId=373) OR ( a.articleSearch IN ('1242401100', '1242401700', '1242401800', '1242400400', '1242401200') AND a.supplierId=268) OR ( a.articleSearch IN ('SM1313', 'SM1312', 'SM1308', 'SM1309') AND a.supplierId=85) OR ( a.articleSearch IN ('1605302', '3469901', '3470001', '2118703', '16053', '21187') AND a.supplierId=35) OR ( a.articleSearch IN ('MCC015245', 'MCC015235', 'MCC015246', 'MCC015259', 'MCC015266') AND a.supplierId=4570) OR ( a.articleSearch IN ('33777', '36720', '337772', '33778', '337782', '33783', '347772', '347782') AND a.supplierId=133) OR ( a.articleSearch IN ('04214', '05910', '00192', '04313', '06297', '55432') AND a.supplierId=4664) OR ( a.articleSearch IN ('6140340007', '6146410001', '6146411007', '6140340011') AND a.supplierId=144) OR ( a.articleSearch IN ('DB31126', 'DB31127', 'E400476') AND a.supplierId=6495) OR ( a.articleSearch IN ('MK149', 'MK343', 'L24913', 'L24914') AND a.supplierId=4752) OR ( a.articleSearch IN ('06071', '09512', '12536', '05919') AND a.supplierId=4683) OR ( a.articleSearch IN ('PSE4108', 'PSE4564', 'PSE4430', 'PSE10912', 'PSE4007', 'PSE4063', 'PSE4486') AND a.supplierId=4558) OR ( a.articleSearch IN ('802052', '801045', '802473', '802071') AND a.supplierId=32) OR ( a.articleSearch IN ('2656012', '2656028', '2656063', '9001688') AND a.supplierId=260) OR ( a.articleSearch IN ('809406', '809407KIT', '809424') AND a.supplierId=135) OR ( a.articleSearch IN ('KB65312', 'M25308', 'KB65313', 'KBLF41771', 'KBLF41772', 'KB65308', 'KB65309') AND a.supplierId=110) OR ( a.articleSearch IN ('40540006', '40926934', '40540010', '40926929', '40926935', '40937768', '40937804', '40945042') AND a.supplierId=151) OR ( a.articleSearch IN ('6304908', '6301789', '6302151', '6309563') AND a.supplierId=4758) OR ( a.articleSearch IN ('206042', '200447', '200448', '205455', '205466') AND a.supplierId=301) OR ( a.articleSearch IN ('GM2029', 'GM8023', 'GM9500', 'GM2030') AND a.supplierId=4894) OR ( a.articleSearch IN ('40458', '45403') AND a.supplierId=4598) OR ( a.articleSearch IN ('50146', '51122', '51536', '51866', '56897S', '56897SET', '56898S', '56898SET') AND a.supplierId=6558) OR ( a.articleSearch IN ('280091', '28034') AND a.supplierId=317) OR (a.articleSearch='18452AP' AND a.supplierId=6400) OR (a.articleSearch='SMA0131' AND a.supplierId=257) OR (a.articleSearch='38OP7100' AND a.supplierId=4829) OR ( a.articleSearch IN ('FT1960', 'FT1961', 'FT1962', 'FT2220', 'FT2221') AND a.supplierId=4737) OR ( a.articleSearch IN ('110150610', '110164210', '110170510', '110171010') AND a.supplierId=323) OR (a.articleSearch='4408070' AND a.supplierId=4306) OR ( a.articleSearch IN ('043508B', '043510B', '043752B', '045570B', '047098B', '047947B', '048524B') AND a.supplierId=49) OR ( a.articleSearch IN ('SM9504', 'SM9505', 'SM9507', 'SM9510', 'SM9511', 'SM9513', 'SM9517', 'SM9523', 'SM9639') AND a.supplierId=478) OR ( a.articleSearch IN ('12117376', '12117390', '12224036', '12297825') AND a.supplierId=16) OR ( a.articleSearch IN ('50657', '5642', '5643', '59086', '59087', '59105', '59106', '59176', '59177', '6058') AND a.supplierId=208) OR ( a.articleSearch IN ('87373A', '87373L', '87394A', '22500012401', '2250087394A') AND a.supplierId=14) OR ( a.articleSearch IN ('BSM5044', 'BSM5170', 'BSM5290', 'BSM5313', 'BSM5314', 'BSM5350') AND a.supplierId=475) OR ( a.articleSearch IN ('480518', '480519', '480541', '481134', '482515', '754789') AND a.supplierId=405) OR ( a.articleSearch IN ('CTSM9009', 'CTSM9014', 'CTSM9018', 'CTSM9064', 'CTSM9085') AND a.supplierId=421) OR ( a.articleSearch IN ('21652931', '21652932', '49417215') AND a.supplierId=140) OR (a.articleSearch='500663' AND a.supplierId=6263) OR ( a.articleSearch IN ('D600014', 'D600015') AND a.supplierId=186) OR ( a.articleSearch IN ('7324042', '7324088', '7324638', '7324642') AND a.supplierId=4135) OR ( a.articleSearch IN ('19SM452', '19SM477', '19SM847', '19ST838', '19ST839', '19ST847') AND a.supplierId=4003) OR ( a.articleSearch IN ('SS6004', 'SS7517', 'SS8173', 'SS9108') AND a.supplierId=267) OR ( a.articleSearch IN ('10741', '15240', '15241', '15242', '15243', '2596', '2707') AND a.supplierId=4834) OR ( a.articleSearch IN ('FSM5044', 'FSM5170', 'FSM5290', 'FSM5313', 'FSM5314', 'FSM5350') AND a.supplierId=407) OR ( a.articleSearch IN ('FL4337J', 'FL4352J') AND a.supplierId=236) OR ( a.articleSearch IN ('20407391S', '20421003S', '20421004S', '20421006S', '20421007S') AND a.supplierId=4727) OR ( a.articleSearch IN ('GK330', 'GK373', 'GK375') AND a.supplierId=4639) OR ( a.articleSearch IN ('SM0070', 'SM0071', 'SM0072', 'SM0436') AND a.supplierId=6443) OR ( a.articleSearch IN ('594181', '597159', 'KS92', 'KS93') AND a.supplierId=239) OR (a.articleSearch='SM0131' AND a.supplierId=156) OR (a.articleSearch='SMJ0131' AND a.supplierId=481) OR (a.articleSearch='MC52001' AND a.supplierId=6786) OR (a.articleSearch='209014' AND a.supplierId=185) OR ( a.articleSearch IN ('850024913', '850024914', '850024912') AND a.supplierId=286) OR ( a.articleSearch IN ('21624Z', '21633Z') AND a.supplierId=387) OR ( a.articleSearch IN ('4061509', '4091582', '4091630', '4091632', '4091642') AND a.supplierId=4546) OR ( a.articleSearch IN ('MA1139LR', 'MA1140LR', 'MA5062LR') AND a.supplierId=4600) OR (a.articleSearch='030607020743' AND a.supplierId=4723) OR ( a.articleSearch IN ('A7X014MT', 'A7X015MT', 'A7X018MT', 'A7X029MT') AND a.supplierId=4427) OR (a.articleSearch='180013120' AND a.supplierId=358) OR ( a.articleSearch IN ('720304', '720305', '722682', '722957') AND a.supplierId=403) OR ( a.articleSearch IN ('6490153', '6490155', '6490156', '6490159', '6490163', '6490290', '8070672', '8070677', 'WMF3115', 'WMF3116', 'WMF4000', 'WMF4001') AND a.supplierId=94) OR ( a.articleSearch IN ('OPSB16971', 'OPSB16978', 'OPSB16982', 'OPSB9720', 'OPSB9722') AND a.supplierId=134) OR ( a.articleSearch IN ('LVSM1017', 'LVSM1019', 'LVSM1043', 'LVSM1045') AND a.supplierId=4564) OR ( a.articleSearch IN ('673610', '683612', '683609', '673608') AND a.supplierId=127) OR ( a.articleSearch IN ('ADPL010', 'ADPL011') AND a.supplierId=6355) OR ( a.articleSearch IN ('SMK303100', 'SMK303500', 'SMT203100') AND a.supplierId=378) OR ( a.articleSearch IN ('F85448', 'F85463', 'F86323', 'F86517', 'F87372', 'F88085', 'F88214', 'F86322') AND a.supplierId=129) OR ( a.articleSearch IN ('31334', '313342', '31344', '31413', '31415', '314152', '31446', '314462', '31447', '314472', '31792', '36162', '361622') AND a.supplierId=331) OR ( a.articleSearch IN ('KSA041', 'PCM398') AND a.supplierId=4655) OR ( a.articleSearch IN ('23140134', '23140135', '23140509') AND a.supplierId=4686) OR ( a.articleSearch IN ('EMA1841', 'EMA1842', 'EMR1841', 'EMR1842', 'EMR4901', 'QAM157') AND a.supplierId=57) OR ( a.articleSearch IN ('R53146', 'R59008', 'R59084', 'R59084K', 'R59085', 'R59085K') AND a.supplierId=4303) OR (a.articleSearch='1180S0005' AND a.supplierId=6358) OR ( a.articleSearch IN ('BCOPSM005', 'BCOPSM010', 'BCST20', 'BCST90') AND a.supplierId=6698) OR ( a.articleSearch IN ('825303', '825328', '825328S', '835308', '865308', '865308S') AND a.supplierId=23) OR (a.articleSearch='MS41003' AND a.supplierId=6377) OR ( a.articleSearch IN ('70009K', '70013K') AND a.supplierId=6322) OR ( a.articleSearch IN ('VKDA35519', 'VKDA35519T', 'VKDA35528', 'VKDA35528T') AND a.supplierId=50) OR ( a.articleSearch IN ('410409', '413273', '413274') AND a.supplierId=6363) OR (a.articleSearch='SKSS0670004' AND a.supplierId=6357) OR ( a.articleSearch IN ('T400192', 'T404214', 'T404313', 'T405910', 'T406297', 'T455432') AND a.supplierId=4667) OR ( a.articleSearch IN ('1137048SX', '1217093SX', '1217416SX', '2617132SX', '2617178SX', '8707341SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('KSU6423', 'KSU6424') AND a.supplierId=6312) OR (a.articleSearch='00501821' AND a.supplierId=4593) OR ( a.articleSearch IN ('OPSM005', 'OPSM010', 'ST20', 'ST90') AND a.supplierId=4414) OR (a.articleSearch='ASMOP1004' AND a.supplierId=4340) OR ( a.articleSearch IN ('788204', '788205', '788900') AND a.supplierId=4970) OR ( a.articleSearch IN ('850024913', '850024914', '850024927', '850024912') AND a.supplierId=108) OR ( a.articleSearch IN ('JSB138', 'JSB529', 'JSL282', 'JSL325') AND a.supplierId=4501) OR ( a.articleSearch IN ('91132', '91144', '91181') AND a.supplierId=6311) OR ( a.articleSearch IN ('391536', '391553', '391557') AND a.supplierId=4730) OR ( a.articleSearch IN ('V400278', 'V400568', 'V401247', 'V401248', 'V404140') AND a.supplierId=183) OR ( a.articleSearch IN ('44072', '44073', '44121', '44122', 'VE50657', 'VE5642', 'VE5643', 'VE6058') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG1795661', 'WG2032730') AND a.supplierId=4832) OR ( a.articleSearch IN ('381477', '560045', '560473', '560941', '580197', '580198', '580199') AND a.supplierId=6347)An internal server error occurred.