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 ('32218', '30429', '30604', '30846', '73559') AND a.supplierId=4576) OR ( a.articleSearch IN ('D8000E', 'D8524T', 'D8534', 'D8538T') AND a.supplierId=351) OR ( a.articleSearch IN ('BSG75705004', 'BSG75705013', 'BSG75705015') AND a.supplierId=4455) OR ( a.articleSearch IN ('500284E', '500407T', '500474T', '500444') AND a.supplierId=4512) OR ( a.articleSearch IN ('0217PB30', '0217PN16', '2415LAGIIT', 'BTUN') AND a.supplierId=4674) OR ( a.articleSearch IN ('100042', '100195', '100041', '100194', '100321', '100322', '100429', '100430', '100439', '100440') AND a.supplierId=101) OR ( a.articleSearch IN ('700129', '250487', '760179', '780157', '780392', '780436') AND a.supplierId=373) OR ( a.articleSearch IN ('KB176', 'KB195', 'KB230') AND a.supplierId=156) OR ( a.articleSearch IN ('304879', '304882', '190964', '304101', '304877', '305608', '305623', '305863', '306575', '23146', '24606', '24608', '24611', '25385', '25400', '25669', '36396') AND a.supplierId=6363) OR ( a.articleSearch IN ('01246', '01267', '00246', '00267', '10118', '10298', '10318', '10323', '11118', '11298', '11318', '11323') AND a.supplierId=4664) OR ( a.articleSearch IN ('130346', '130347', '130364', '130381', '130382', '130390', '130611', '130699') AND a.supplierId=121) OR ( a.articleSearch IN ('1904007', '1904012', '1904023', '1900034', '1900035', '1904025', '1904033', '1904036') AND a.supplierId=260) OR ( a.articleSearch IN ('VKJP01001', 'VKJP01001S', 'VKJP1307', 'VKJP1388', 'VKJP1417', 'VKJP1438', 'VKJP1460', 'VKJP1493', 'VKJP8353', 'VKJP1355', 'VKJP1385', 'VKJP1424', 'VKJP3163') AND a.supplierId=50) OR ( a.articleSearch IN ('IBK55013', 'OBK55011', 'IBK55018') AND a.supplierId=110) OR ( a.articleSearch IN ('60100042', '60100195', '60100041', '60100194', '60100429', '60100430', '60100439', '60100440', '82100321', '82100322') AND a.supplierId=151) OR ( a.articleSearch IN ('18077', '18077KLR', '180782', '180782KLC', '180783', '180783KLC', '18094', '18094KLR', '18316', '18316KLR', '184935', '184935KLC') AND a.supplierId=317) OR ( a.articleSearch IN ('6301176', '6301195', '6302230') AND a.supplierId=257) OR (a.articleSearch='ASBTJ31B' AND a.supplierId=4631) OR ( a.articleSearch IN ('504176', '504181', '504258', '504318', '504412') AND a.supplierId=300) OR ( a.articleSearch IN ('G500231', 'G500255', 'G500257', 'G500261', 'G500680', 'G500761') AND a.supplierId=4464) OR ( a.articleSearch IN ('7185KM', '7504KM', '7549KM', '7623KM', '7658KM', '7659', '7919KM') AND a.supplierId=208) OR ( a.articleSearch IN ('ADM58170', 'ADT381107') AND a.supplierId=350) OR ( a.articleSearch IN ('BCB6060', 'BCB6190', 'BCB6196', 'BCB6201', 'BCB6210') AND a.supplierId=475) OR ( a.articleSearch IN ('021292', '021300', '021301', '021303', '021368', '021369', '021380', '021429', '021430', '030603', '030648', '700998', '700999') AND a.supplierId=405) OR ( a.articleSearch IN ('222321', '222375', '222391') AND a.supplierId=318) OR ( a.articleSearch IN ('1084', '1191', '1214', '1217', '1417', '1431', '1504', '1611', '1613') AND a.supplierId=393) OR ( a.articleSearch IN ('613346', '613347', '613364', '613381', '613382', '613390', '613611', '613699') AND a.supplierId=311) OR ( a.articleSearch IN ('22BK101', '22SK101', '22SK143') AND a.supplierId=4003) OR (a.articleSearch='772038230' AND a.supplierId=192) OR ( a.articleSearch IN ('2121', '9684', '9688', 'K2121', 'K9684', 'K9688') AND a.supplierId=4834) OR ( a.articleSearch IN ('FCB6060', 'FCB6190', 'FCB6196', 'FCB6201', 'FCB6210') AND a.supplierId=407) OR ( a.articleSearch IN ('K22502', 'TK13705') AND a.supplierId=316) OR ( a.articleSearch IN ('CB0039', 'CB0084', 'CB0121', 'DB0035', 'DB0085', 'DB0103') AND a.supplierId=6443) OR ( a.articleSearch IN ('353171', '353176', '353253', '353313', '353407') AND a.supplierId=178) OR ( a.articleSearch IN ('353171', '353176', '353253', '353313', '353407') AND a.supplierId=262) OR ( a.articleSearch IN ('63176', '63195', '63230') AND a.supplierId=481) OR ( a.articleSearch IN ('CD22021', 'CD28011', 'CD43005') AND a.supplierId=6786) OR (a.articleSearch='4143600810' AND a.supplierId=268) OR (a.articleSearch='CVB9009' AND a.supplierId=201) OR ( a.articleSearch IN ('4413775', '4415680', '4418710') AND a.supplierId=4546) OR (a.articleSearch='18553' AND a.supplierId=133) OR ( a.articleSearch IN ('MF2061', 'MF2127', 'MF2831') AND a.supplierId=6270) OR ( a.articleSearch IN ('491072', '491431', '491849', '491850', '491851', '491852') AND a.supplierId=403) OR ( a.articleSearch IN ('MOB8176', 'MOB8195', 'MOB8230') AND a.supplierId=4773) OR ( a.articleSearch IN ('751047', '751086', '751087', '751110') AND a.supplierId=94) OR ( a.articleSearch IN ('16144950017', '16144950020') AND a.supplierId=144) OR ( a.articleSearch IN ('GD00003', 'GD00017', 'GD00017G', 'GD00018', 'GD00018G') AND a.supplierId=6495) OR (a.articleSearch='N2882022' AND a.supplierId=248) OR ( a.articleSearch IN ('523709', '524505') AND a.supplierId=127) OR (a.articleSearch='NOP041' AND a.supplierId=6355) OR (a.articleSearch='SJK706800' AND a.supplierId=378) OR ( a.articleSearch IN ('CVB10312CR', 'CVB10534TPE', 'CVB10553TPE', 'CVB10645TPE', 'CVB10648TPE', 'CVB10721TPE') AND a.supplierId=129) OR ( a.articleSearch IN ('29332', '31670', '32848', '32848TE', '33526', '33622', '33834', '33834TE', '33841', '33848', '33973', '33973TE', '36751', '36917', '36917TE', '36925') AND a.supplierId=331) OR (a.articleSearch='35485' AND a.supplierId=4683) OR ( a.articleSearch IN ('G5R031PC', 'G6R012PC') AND a.supplierId=4690) OR ( a.articleSearch IN ('PDC0035', 'PDC0047', 'PDC0063', 'PDC5608') AND a.supplierId=4558) OR ( a.articleSearch IN ('JAPKB176', 'JAPKB195', 'JAPKB230') AND a.supplierId=4652) OR ( a.articleSearch IN ('QF31C00030', 'QF31C00031', 'QF31C00043') AND a.supplierId=4339) OR (a.articleSearch='756911' AND a.supplierId=23) OR ( a.articleSearch IN ('4413765', '4413775') AND a.supplierId=6405) OR ( a.articleSearch IN ('06K053', '06K147', '06K155', '06K236', '06K664') AND a.supplierId=431) OR ( a.articleSearch IN ('BK1039', 'BK602') AND a.supplierId=4607) OR ( a.articleSearch IN ('T400246', 'T400267', 'T401246', 'T401267', 'T410118', 'T410298', 'T410318', 'T410323', 'T411118', 'T411298', 'T411318', 'T411323') AND a.supplierId=4667) OR ( a.articleSearch IN ('1300529SX', '1300541SX', '1300592SX', '1300741SX', '1300780SX', '1300873SX', '5600140SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('701931', '701932') AND a.supplierId=301) OR ( a.articleSearch IN ('500231', '500255', '500257', '500261', '500680', '500761') AND a.supplierId=4472) OR ( a.articleSearch IN ('854025822', '854025823', '854025915', '854025922', '854025923', '854028815', '854028829', '854040816') AND a.supplierId=108) OR ( a.articleSearch IN ('10452', '10452T', '10668', '10668T', '10723', '10723T', '31458', '31458T', '41539', '41539T', '41587', '41587T') AND a.supplierId=6311) OR ( a.articleSearch IN ('310340H', '310340H2', '310341H', '310341H2', '310343', '310367H', '310367H2', '310393H', '310393H2') AND a.supplierId=4730) OR ( a.articleSearch IN ('VE7185KM', 'VE7504KM', 'VE7549KM', 'VE7623KM', 'VE7658KM', 'VE7659', 'VE7919KM') AND a.supplierId=4425) OR ( a.articleSearch IN ('SM1023S', 'SM1026S', 'SM1121S') AND a.supplierId=4894) OR (a.articleSearch='ZVP48YN' AND a.supplierId=6274)An internal server error occurred.