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 ('73393', '75418', '75698') AND a.supplierId=4576) OR ( a.articleSearch IN ('CV7302A', 'DS7331LA', 'DS7331RA', 'DS7356L', 'DS7356R', 'DS7360L', 'DS7360R', 'DS7361L') AND a.supplierId=478) OR ( a.articleSearch IN ('BSG75340003', 'BSG75340006', 'BSG75350015', 'BSG75350016') AND a.supplierId=4455) OR (a.articleSearch='CV16243' AND a.supplierId=271) OR ( a.articleSearch IN ('850148', '203477', '211024', '250383', '250400', '250425', '250426', '250501', '250510', '250535', '250617', '299201', '602231', '650057', '650140', '850145', '850162', '899213', '250384', '850163') AND a.supplierId=373) OR ( a.articleSearch IN ('151728', '151840', '151519', '171231', '171232', '171374', '171375') AND a.supplierId=121) OR ( a.articleSearch IN ('OJK55007', 'OJK55008', 'DK55061', 'DK55065', 'DK55068', 'DK55097', 'DK55099', 'DK55101', 'DK55102', 'DK55138', 'DK55208') AND a.supplierId=110) OR ( a.articleSearch IN ('GS3927', 'AW4826', 'AW5559', 'GS5081', 'GS5163') AND a.supplierId=4894) OR ( a.articleSearch IN ('RNFLC', 'RNILFLC', 'RNMEGIII') AND a.supplierId=4631) OR ( a.articleSearch IN ('821521', '822500', '822555', '831244', '831741', '831904', '832131', '832927') AND a.supplierId=300) OR ( a.articleSearch IN ('3750DA0006', '3750DA0013') AND a.supplierId=6271) OR ( a.articleSearch IN ('G300783', 'G300808', 'G300895', 'G300897', 'G301076', 'G301077') AND a.supplierId=4464) OR ( a.articleSearch IN ('GRN3840K', 'GRN3870K', 'GRN7450K') AND a.supplierId=243) OR (a.articleSearch='760201' AND a.supplierId=405) OR ( a.articleSearch IN ('230643', '230644', '230754', '230755', '230756', '230757', '3077', '3093', '3095') AND a.supplierId=318) OR ( a.articleSearch IN ('5006Z', '5007Z', '50785', '7243', '7244', '7257', '7258', '7419', '7420', '7443', '7444', '7479', '7827', '7833', '7899', '7900', 'N5006Z', 'N5007Z') AND a.supplierId=393) OR ( a.articleSearch IN ('607519', '607728', '607840', '6551231', '6551232', '6551374', '6551375') AND a.supplierId=311) OR (a.articleSearch='ECV287' AND a.supplierId=421) OR ( a.articleSearch IN ('C120220', 'C120550') AND a.supplierId=186) OR ( a.articleSearch IN ('DP2110100730', 'DP2110100753', 'DP2110100833', 'DP2110100835', 'DP2110101001', 'DP2110101002', 'DP2110101861', 'DP2110101864', 'DP2110101931') AND a.supplierId=4948) OR ( a.articleSearch IN ('DCV899213', 'DDS250383', 'DDS250400', 'DDS250426', 'DDS299201') AND a.supplierId=4881) OR ( a.articleSearch IN ('76RN8157', '76RN8158') AND a.supplierId=4135) OR ( a.articleSearch IN ('CV22605K', 'T49227', 'T49228', 'T49307', 'T49311', 'T49314', 'T49371', 'T49409', 'T49455', 'T49505', 'T99111', 'T99112', 'T99113', 'T99114') AND a.supplierId=391) OR ( a.articleSearch IN ('DA206771', 'DA206901', 'DA206902', 'DA206991', 'DA206992', 'DA20726', 'DA20728', 'DA208011', 'DA208012') AND a.supplierId=224) OR ( a.articleSearch IN ('771058030', '771066930') AND a.supplierId=192) OR ( a.articleSearch IN ('125812', '125813') AND a.supplierId=90) OR (a.articleSearch='2410DUST' AND a.supplierId=4674) OR (a.articleSearch='171922' AND a.supplierId=101) OR ( a.articleSearch IN ('22380086S', '22380087S') AND a.supplierId=4727) OR ( a.articleSearch IN ('FDS2478', 'FDS2844', 'FDS2845') AND a.supplierId=87) OR ( a.articleSearch IN ('RE3363', 'RE3364', 'RE3450', 'RE3451', 'RE3541', 'RE3542') AND a.supplierId=316) OR ( a.articleSearch IN ('312753', '312962', '313027', '332465', '332466') AND a.supplierId=262) OR (a.articleSearch='6996' AND a.supplierId=185) OR ( a.articleSearch IN ('304340', '304687', '305324', '305326', '305764', '305766', '305793', '306734', '306738', '23741', '24375', '25101', '25103', '25570', '25571', '25573', '36555', '36559') AND a.supplierId=6363) OR ( a.articleSearch IN ('DS52222', 'DS52395', 'DS52396', 'KRN700', 'KRN886', 'KRN887') AND a.supplierId=283) OR (a.articleSearch='CO3846' AND a.supplierId=4600) OR ( a.articleSearch IN ('302004190246', '302004190248', '302004190250', '302004190255', '302004190306', '302015100250', '302015100329') AND a.supplierId=4723) OR (a.articleSearch='16122' AND a.supplierId=133) OR (a.articleSearch='151519MSETMS' AND a.supplierId=358) OR ( a.articleSearch IN ('491190', '491298', '491487', '491787', '491833', '491836', '492326', '492327') AND a.supplierId=403) OR (a.articleSearch='12089' AND a.supplierId=4664) OR ( a.articleSearch IN ('16144980027', '16144980050', '16144980063') AND a.supplierId=144) OR ( a.articleSearch IN ('GA20401', 'GC01164') AND a.supplierId=6495) OR ( a.articleSearch IN ('12291904', '12291987', '18291330', '18291530', '18291750', '18291770', '18291840', '18291890', '18292330', '18292530') AND a.supplierId=4653) OR (a.articleSearch='513908' AND a.supplierId=127) OR ( a.articleSearch IN ('NPWRE027', 'NPWRE028', 'NPWRE049', 'NPWRE050', 'NPWRE061', 'NPWRE062', 'NPWRE121', 'NPWRE134', 'NPWRE140', 'NPWRE147', 'NPWRE148', 'NPWRE164', 'NPZRE002', 'NPZRE017') AND a.supplierId=6355) OR ( a.articleSearch IN ('CVJ570510', 'CVJ576510', 'CVJ579410', 'DRS638900', 'DRS647700', 'DRS647800') AND a.supplierId=378) OR ( a.articleSearch IN ('CW3038', 'DS3551', 'DS3560', 'DS3859', 'DS3891', 'DS4215', 'DS4493') AND a.supplierId=129) OR ( a.articleSearch IN ('G1R017PC', 'G1R034PC', 'G1R051PC', 'G7E005PC') AND a.supplierId=4690) OR ( a.articleSearch IN ('PCV1519', 'PCV1767', 'PDS0188', 'PDS0240', 'PDS0529') AND a.supplierId=4558) OR ( a.articleSearch IN ('PNG72336', 'PNG72337', 'PNG72642', 'PNG72871', 'PNG72872', 'PNG72874', 'PNG72925', 'PNG73035', 'PNG73216', 'PNG73226', 'PNG74764', 'PNG74970', 'PNG74971', 'PNG75179', 'PNG75252') AND a.supplierId=6381) OR ( a.articleSearch IN ('PRA106', 'PRA151', 'PRA623', 'PRA746', 'PRJ329', 'PRJ961') AND a.supplierId=4520) OR (a.articleSearch='QF11C00229' AND a.supplierId=4339) OR ( a.articleSearch IN ('R447AN', 'R448A', 'R448AN', 'R730N', 'R750N', 'R930N', 'R931N', 'R965N', 'RE94A') AND a.supplierId=492) OR ( a.articleSearch IN ('13D0060', '13D0212', '13D0220', '5J0045', '5J0160') AND a.supplierId=6358) OR ( a.articleSearch IN ('75526S', '79700S') AND a.supplierId=23) OR ( a.articleSearch IN ('27K700', '27K886', '27K887', 'DS52222', 'DS52395', 'DS52396') AND a.supplierId=343) OR ( a.articleSearch IN ('221780', '221782', '22828', '22829') AND a.supplierId=431) OR ( a.articleSearch IN ('R258AL', 'R258AR', 'R409L', 'R410L', 'R410R', 'R411L', 'R411R', 'R412L', 'R412R', 'R433L', 'R433LN', 'R465L', 'R465LN', 'R465R', 'R465RN', 'R468L', 'R469L', 'R469LN', 'R328L', 'R328R', 'R407L', 'R407R') AND a.supplierId=4607) OR ( a.articleSearch IN ('VKJC5019', 'VKJC5020', 'VKJC5021', 'VKJC6013', 'VKJC6103', 'VKJC6191', 'VKJC6198', 'VKJC6199', 'VKJC6204', 'VKJC6492', 'VKJC8932') AND a.supplierId=50) OR ( a.articleSearch IN ('SKDS0210085', 'SKDS0210269', 'SKDS0210277', 'SKJK0200051', 'SKJK0200117') AND a.supplierId=6357) OR (a.articleSearch='T412089' AND a.supplierId=4667) OR ( a.articleSearch IN ('1501519SX', '1502047SX', '1582044SX', '1582087SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('76RN8157', '76RN8158') AND a.supplierId=4758) OR ( a.articleSearch IN ('38227', '38228', '38307') AND a.supplierId=6312) OR ( a.articleSearch IN ('300783', '300808', '300895', '300897', '301076', '301077', '400707') AND a.supplierId=4472) OR ( a.articleSearch IN ('854025113', '854025136', '854025137', '854025609', '854025610', '854025691', '854025692', '854028514', '854028516') AND a.supplierId=108)An internal server error occurred.