SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM article a
              /*LEFT JOIN supplier s ON s.supplierId=a.supplierId*/
              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 p.id=ps.product_id AND ps.supplier_id IN (223)
              WHERE ( a.articleSearch IN ('PDS0425', 'PDS0426', 'PCV1334', 'PCV1587', 'PCV1798', 'PCV4598', 'PCV4605', 'PDC0044', 'PDS0399', 'PDS0400') AND a.supplierId=4558) OR ( a.articleSearch IN ('55244', '75691', '75750') AND a.supplierId=4576) OR ( a.articleSearch IN ('62000036') AND a.supplierId=257) OR ( a.articleSearch IN ('PGBX1') AND a.supplierId=4631) OR ( a.articleSearch IN ('504172', '504206', '504251', '504265', '820376', '820938', '821205', '821893', '822260', '832436', '832492', '832639') AND a.supplierId=300) OR ( a.articleSearch IN ('G400087', 'G400088', 'G450023', 'G450024', 'G450026', 'G450027', 'G500211', 'G500212', 'G500214', 'G500216') AND a.supplierId=4464) OR ( a.articleSearch IN ('CV1410A', 'CV1423A', 'CV2223A', 'DS6737L', 'DS6737R') AND a.supplierId=478) OR ( a.articleSearch IN ('7809') AND a.supplierId=208) OR ( a.articleSearch IN ('BSG25340001', 'BSG25350005', 'BSG25350006', 'BSG65700333', 'BSG70340013', 'BSG70350011', 'BSG70350012', 'BSG70705009') AND a.supplierId=4455) OR ( a.articleSearch IN ('51275') AND a.supplierId=157) OR ( a.articleSearch IN ('GFT3500K', 'GPG4930K', 'GPG4950K') AND a.supplierId=243) OR ( a.articleSearch IN ('180609', '760225', '760231') AND a.supplierId=405) OR ( a.articleSearch IN ('100410', '100411', '1630', '210482', '210483', '252386') AND a.supplierId=318) OR ( a.articleSearch IN ('5926', '5927', '5928', '5929', 'N5927') AND a.supplierId=393) OR ( a.articleSearch IN ('607717', '607726', '6551308', '6551309', '6551310', '6551311') AND a.supplierId=311) OR ( a.articleSearch IN ('C120059', 'C120075', 'C120083', 'C120089', 'C120102', 'C120537') AND a.supplierId=186) OR ( a.articleSearch IN ('DP2110101153', 'DP2110101154', 'DP2110101628', 'DP2110101629', 'DP2110101631', 'DP2110101632', 'DP2110101756', 'DP2110101757', 'DP2110101772') AND a.supplierId=4948) OR ( a.articleSearch IN ('1239105') AND a.supplierId=355) OR ( a.articleSearch IN ('76FI8027', '76FI8028', '77FI1096', '77FI1100', '77FI5016') AND a.supplierId=4135) OR ( a.articleSearch IN ('T29168', 'T29169', 'T29170', 'T29171') AND a.supplierId=391) OR ( a.articleSearch IN ('125868', '125879') AND a.supplierId=90) OR ( a.articleSearch IN ('FT25078K', 'FT25079K', 'FT27117', 'FT27118') AND a.supplierId=4938) OR ( a.articleSearch IN ('CV16267') AND a.supplierId=271) OR ( a.articleSearch IN ('14380068S', '14380069S', '14398058S', '14398090S', '14398091S') AND a.supplierId=4727) OR ( a.articleSearch IN ('FDS1557', 'FDS2138', 'FDS2139') AND a.supplierId=87) OR ( a.articleSearch IN ('FI1181', 'FI1181K', 'FI3434', 'FI3435', 'FI3462', 'FI3463', 'TK11728') AND a.supplierId=316) OR ( a.articleSearch IN ('CB0079', 'DB0072') AND a.supplierId=6443) OR ( a.articleSearch IN ('217050', '217053', '245176', '610038', '617020', '617028', '617042', '780377', '780378', '817045', '817055') AND a.supplierId=373) OR ( a.articleSearch IN ('353167', '353201', '353246', '353260') AND a.supplierId=178) OR ( a.articleSearch IN ('312951', '312960', '353167', '353201', '353246', '353260') AND a.supplierId=262) OR ( a.articleSearch IN ('GI0036') AND a.supplierId=156) OR ( a.articleSearch IN ('620036') AND a.supplierId=481) OR ( a.articleSearch IN ('5011142', '5011153', '5012011', '5012012', '5012013', '5012014', '5012042', '6501', '6601', '8011', '8012', '8013', '8014', '8744', '8745', 'CT1138975') AND a.supplierId=185) OR ( a.articleSearch IN ('882472') AND a.supplierId=4496) OR ( a.articleSearch IN ('304598', '304599', '304601', '304602', '304603', '304604', '304605', '304606', '304607', '304608', '305814', '305815', '305832', '24282', '24283', '24285', '24286', '24287', '24288', '24289', '24290', '24291', '24292', '25620', '25621', '25638') AND a.supplierId=6363) OR ( a.articleSearch IN ('DS52300', 'DS52301', 'DS52302', 'DS52303', 'KFT745', 'KFT746') AND a.supplierId=283) OR ( a.articleSearch IN ('302004190050', '302004190162', '302009100058', '302015100102', '302015100107') AND a.supplierId=4723) OR ( a.articleSearch IN ('491017', '491226', '491227', '491394', '491897', '491898', '491899', '491900') AND a.supplierId=403) OR ( a.articleSearch IN ('00750', '01750', '12047', '12049') AND a.supplierId=4664) OR ( a.articleSearch IN ('151717', '151726', '171308', '171309', '171310', '171311') AND a.supplierId=121) OR ( a.articleSearch IN ('751090') AND a.supplierId=94) OR ( a.articleSearch IN ('2144980063', '2144980064', '2144980067', '2144980070', '2144980071') AND a.supplierId=144) OR ( a.articleSearch IN ('GA20067', 'GA20072') AND a.supplierId=6495) OR ( a.articleSearch IN ('12161916', '12161918', '18161270', '18162270', '25990024') AND a.supplierId=4653) OR ( a.articleSearch IN ('511923', '511924', '511926') AND a.supplierId=127) OR ( a.articleSearch IN ('NOP188', 'NPWFT010', 'NPWFT011', 'NPWFT039', 'NPZFT037', 'NPZFT038') AND a.supplierId=6355) OR ( a.articleSearch IN ('CVJ565810', 'CVJ571810', 'CVJ572420', 'DRS642500', 'DRS642600', 'DRS644500') AND a.supplierId=378) OR ( a.articleSearch IN ('CT1035', 'CT1036', 'CT1039', 'CT1050', 'CVB10144CR', 'CVB10177CR', 'CVB10535TPE', 'CVB10576TPE', 'CW2521', 'CW2668') AND a.supplierId=129) OR ( a.articleSearch IN ('29962', '29962TE', '33727', '33727TE') AND a.supplierId=331) OR ( a.articleSearch IN ('G1F057PC', 'G5C030PC', 'G5C031PC', 'G6F023PC', 'G7F007PC', 'G7F017PC', 'G8F004PC', 'G8F006PC', 'SALEG8F006PC') AND a.supplierId=4690) OR ( a.articleSearch IN ('JAPGI0036') AND a.supplierId=4652) OR ( a.articleSearch IN ('PNG72472', 'PNG72473', 'PNG72474', 'PNG72475') AND a.supplierId=6381) OR ( a.articleSearch IN ('PRA640', 'PRA745', 'PRJ488', 'PRJ497', 'PRJ545', 'PRJ550', 'PRJ551') AND a.supplierId=4520) OR ( a.articleSearch IN ('QF00000079') AND a.supplierId=4339) OR ( a.articleSearch IN ('C900AN', 'C901AN', 'C902AN', 'C903AN', 'CI88') AND a.supplierId=492) OR ( a.articleSearch IN ('13D0340', '5J0116') AND a.supplierId=6358) OR ( a.articleSearch IN ('10K745', '10K746', 'DS52300', 'DS52301', 'DS52302', 'DS52303') AND a.supplierId=343) OR ( a.articleSearch IN ('06K040', '06K119', '06K557', '221167', '221168') AND a.supplierId=431) OR ( a.articleSearch IN ('CV1202N', 'P251L', 'P251R', 'P263L', 'P263R') AND a.supplierId=4607) OR ( a.articleSearch IN ('VKJA5822', 'VKJC8695', 'VKJC8696', 'VKJC8697', 'VKJC8698') AND a.supplierId=50) OR ( a.articleSearch IN ('SKJK0200311', 'SKJK0200380') AND a.supplierId=6357) OR ( a.articleSearch IN ('T400750', 'T401750', 'T412047', 'T412049') AND a.supplierId=4667) OR ( a.articleSearch IN ('1300534SX', '1300574SX', '1300798SX', '1501815SX', '1501892SX', '1581976SX', '1581980SX', '1582002SX', '1582007SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('76FI8027', '76FI8028', '77FI1096', '77FI1100', '77FI5016') AND a.supplierId=4758) OR ( a.articleSearch IN ('18168A', '18169', '18170A', '18171') AND a.supplierId=6312) OR ( a.articleSearch IN ('301143', '400087', '400088', '450023', '450024', '450026', '450027', '500211', '500212', '500214', '500216') AND a.supplierId=4472) OR ( a.articleSearch IN ('854010522', '854010523', '854010528', '854010529', '854028139') AND a.supplierId=108) OR ( a.articleSearch IN ('10892', '10892T', '31210', '31210T', '31211', '31211T') AND a.supplierId=6311) OR ( a.articleSearch IN ('300105') AND a.supplierId=4730) OR ( a.articleSearch IN ('VE7809') AND a.supplierId=4425) OR ( a.articleSearch IN ('GS4029', 'SM1050S', 'SM1080S') AND a.supplierId=4894)An internal server error occurred.