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 ('24125300303', '24125300403', '24523701833', '24524301903', '83781302953', '83781201803', '83621302953') AND a.supplierId=3) OR ( a.articleSearch IN ('120031410', '120031510', '120027610', '120027810', '120030210', '120031010') AND a.supplierId=323) OR ( a.articleSearch IN ('1987476018', '1987476717', '1987476402', '1987476719', '1987481534', '1987481535', 'F026A05611') AND a.supplierId=30) OR ( a.articleSearch IN ('T85064', 'T85067', 'T85036', 'T85040', 'T85048', 'T85071', 'T85134') AND a.supplierId=65) OR a.articleSearch='BSG90730010' AND a.supplierId=4455) OR ( a.articleSearch IN ('92BHVK009', '92BHVK024', '92BHVK029', '92BHVK030', '92BHVK085') AND a.supplierId=4871) OR ( a.articleSearch IN ('19025845', '19025895', '19036198', '19020654', '19032528', '19032656', '19033549', '19036197', '19032655') AND a.supplierId=140) OR ( a.articleSearch IN ('1623259380', '1623269680', '1623269780', '1623272580', '1650845780', '1650847180') AND a.supplierId=4391) OR ( a.articleSearch IN ('14042', '14048', '31408', '40961', '40962') AND a.supplierId=101) OR ( a.articleSearch IN ('PH214774', 'PH214775', 'PH214794', 'PH214777') AND a.supplierId=271) OR ( a.articleSearch IN ('FHY2245', 'FHY2166', 'FHY2224', 'FHY2412', 'FHY2431', 'FHY3065', 'FHY3066') AND a.supplierId=62) OR ( a.articleSearch IN ('9004944', '9004945', '9001294', '9001327', '9001344', '9002261', '9004351') AND a.supplierId=279) OR ( a.articleSearch IN ('1161602800', '1161702500', '1161702770', '1161702780', '1161702900', '1161702100', '1161705400') AND a.supplierId=268) OR ( a.articleSearch IN ('6T46584', '6T46748', '6T47870', '6T49155', '6T49156', '6T46696', '6T46746', '6T46800', '6T46884', '6T47441') AND a.supplierId=283) OR ( a.articleSearch IN ('3670', '3861', '3952', '3671', '3863') AND a.supplierId=133) OR ( a.articleSearch IN ('96008', '96011') AND a.supplierId=4664) OR ( a.articleSearch IN ('4119356', '4110336', '4114774', '4114775', '4114795', '4116213', '4119357') AND a.supplierId=94) OR ( a.articleSearch IN ('1005250062S', '1005250063S', '1006110040', '1006110042', '1006110081', '1006110081S', '1005250049') AND a.supplierId=144) OR ( a.articleSearch IN ('8547115', '8547116', '854761', '854767', '854782', '854798', '854772', '854780', '854781') AND a.supplierId=127) OR ( a.articleSearch IN ('01663', '13828', '24796', '26356', '29330') AND a.supplierId=4683) OR ( a.articleSearch IN ('PBH0002', 'PBH0083', 'PBH0149') AND a.supplierId=4558) OR ( a.articleSearch IN ('30931408', '30914048', '30940961', '30940962', '99914042') AND a.supplierId=151) OR ( a.articleSearch IN ('PHA294', 'PHA295', 'PHA327', 'PHA344', 'PHD351', 'PHD944', 'PHD945', 'PHB261') AND a.supplierId=4501) OR ( a.articleSearch IN ('66110562101', '66111110301', '45000055501', '66111601101') AND a.supplierId=4346) OR ( a.articleSearch IN ('C81109ABE', 'C81120ABE', 'C81128ABE', 'C81157ABE', 'C81173ABE', 'C81212ABE', 'C81218ABE') AND a.supplierId=4426) OR ( a.articleSearch IN ('SL4869', 'SL4870', 'SL4887', 'SL5814', 'SL5815', 'SL6084', 'SL3578') AND a.supplierId=206) OR ( a.articleSearch IN ('031225', '031231', '031264', '551232', '551246', '551270', '551271') AND a.supplierId=6414) OR ( a.articleSearch IN ('50911', '50914', '50942', '51669', '51670', '54123') AND a.supplierId=6558) OR ( a.articleSearch IN ('8035', '8038', '8061', '8968') AND a.supplierId=317) OR ( a.articleSearch IN ('BHO4075', 'HOS3159', 'HOS3164', 'HOS3235', 'HOS3385', 'HOS3872', 'HOS3873', 'HOS3950') AND a.supplierId=4537) OR a.articleSearch='77655' AND a.supplierId=4576) OR ( a.articleSearch IN ('PAL30049', 'PAL30050', 'PAL30185', 'PAL30186', 'PAL30275') AND a.supplierId=442) OR ( a.articleSearch IN ('290BK04961', '290BK04962', '290BK05742', '290BK05755', '290BK06329') AND a.supplierId=6271) OR a.articleSearch='BAH0013' AND a.supplierId=394) OR a.articleSearch='0011023253' AND a.supplierId=4995) OR ( a.articleSearch IN ('BBH6634', 'BBH6875', 'BBH6893', 'BBH7298', 'BBH7910', 'BBH7911') AND a.supplierId=475) OR ( a.articleSearch IN ('AH0337', 'AH0338') AND a.supplierId=4993) OR ( a.articleSearch IN ('H4591', 'H4599', 'H4645', 'H4646', 'H4646Q', 'H6004', 'H6435', 'H6918', 'H6918Q', 'H6919', 'H6919Q') AND a.supplierId=4805) OR ( a.articleSearch IN ('TF160X', 'TF530X', 'TF830X', 'TF869X') AND a.supplierId=243) OR ( a.articleSearch IN ('460214', '460216') AND a.supplierId=405) OR ( a.articleSearch IN ('511220', '511547', '511643', '511671', '512189', '518263', '518264') AND a.supplierId=325) OR ( a.articleSearch IN ('LH0207', 'LH0208', 'LH0214', 'LH0334', 'LH0335', 'LH6934', 'LH6935', 'LH0399', 'LH6100', 'LH214') AND a.supplierId=89) OR ( a.articleSearch IN ('35SKV001', '35SKV022', '35SKV026') AND a.supplierId=4969) OR ( a.articleSearch IN ('11507', '11508') AND a.supplierId=4834) OR ( a.articleSearch IN ('180E621E0', '184E865E11', '190E829E0', '190E865E11', '200621E', '266E469E11', '295621E1') AND a.supplierId=54) OR ( a.articleSearch IN ('BH0003', 'BH0074') AND a.supplierId=6443) OR ( a.articleSearch IN ('8AH355460021', '8AH355460441', '8AH355460451', '8AH355461651', '8AH355462551', '8AH355468621', '8AH355468631') AND a.supplierId=4734) OR ( a.articleSearch IN ('172042J', '172449J', '172577J', '172723J', '172724J', '173300J') AND a.supplierId=49) OR ( a.articleSearch IN ('H4591', 'H4599', 'H4645', 'H4646', 'H4646Q', 'H6004', 'H6435', 'H6918', 'H6918Q', 'H6919', 'H6919Q') AND a.supplierId=286) OR a.articleSearch='9539007' AND a.supplierId=78) OR ( a.articleSearch IN ('520012', '520035', '520091', '520120', '520121', '520150', '520151', '520286', '520287') AND a.supplierId=403) OR a.articleSearch='MRP2B03' AND a.supplierId=4773) OR ( a.articleSearch IN ('LVBH1685', 'LVBH1686', 'VBJ196', 'VBJ241', 'VBJ247', 'VBJ282', 'VBJ283', 'VBH996') AND a.supplierId=4564) OR ( a.articleSearch IN ('NBH6018', 'NBH6091', 'NBH6092') AND a.supplierId=190) OR ( a.articleSearch IN ('2446424', '2446644', '2446744') AND a.supplierId=4380) OR ( a.articleSearch IN ('60370', '60377', '60419', '60422', '60521', '60523', '60543', '60722', '60421') AND a.supplierId=331) OR ( a.articleSearch IN ('22405', '27014', '27082', '37909', '50041X', '96005X', '96006X') AND a.supplierId=6304) OR ( a.articleSearch IN ('BFH4686', 'BFH4891', 'BFH4919', 'BFH5569', 'BFH6033', 'BFH6034') AND a.supplierId=57) OR ( a.articleSearch IN ('02020064', '02020074', '02020082', '02020084', '02020092', '02020123', '02020124') AND a.supplierId=6447) OR ( a.articleSearch IN ('83B0020', '83B0094', '83B0155', '83B0238', '83B0272', '83B0275') AND a.supplierId=6358) OR ( a.articleSearch IN ('6T46584', '6T46696', '6T46746', '6T46800', '6T46884', '6T47441', '6T47870', '6T49155', '6T49156') AND a.supplierId=343) OR ( a.articleSearch IN ('6606060', '6606180') AND a.supplierId=260) OR ( a.articleSearch IN ('SKBH0820019', 'SKBH0820093', 'SKBH0820155', 'SKBH0820237', 'SKBH0820271', 'SKBH0820274') AND a.supplierId=6357) OR ( a.articleSearch IN ('T496008', 'T496011') AND a.supplierId=4667) OR ( a.articleSearch IN ('2700000SX', '2700020SX', '2700037SX', '2700062SX', '2700111SX', '2700233SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('031225', '551232', '551246', '551270', '551271') AND a.supplierId=6691) OR ( a.articleSearch IN ('36906', '36956') AND a.supplierId=6312) OR ( a.articleSearch IN ('104414', '104434', '109394', '110413', '114785', '114786') AND a.supplierId=301) OR ( a.articleSearch IN ('892934', '892935') AND a.supplierId=4970) OR ( a.articleSearch IN ('815029211', '815029217', '815029221', '815029223', '815029296', '815029324') AND a.supplierId=108) OR ( a.articleSearch IN ('0735073', '0735147') AND a.supplierId=209) OR ( a.articleSearch IN ('377076', '377322', '377868', '379540', '379946') AND a.supplierId=4730) OR ( a.articleSearch IN ('V101907', 'V101908', 'V104108', 'V104134', 'V104136', 'V104187', 'V104188', 'V104193') AND a.supplierId=183) OR ( a.articleSearch IN ('240141', '240145', '340375', '340953', '340957') AND a.supplierId=6347) OR ( a.articleSearch IN ('BS9051', 'BS9060', 'BS9193', 'BS9243', 'BS9244', 'BS9245') AND a.supplierId=4894)An internal server error occurred.