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 ('ZD168235', 'ZD168226', 'ZD168231', 'ZD168246', 'ZD168417', 'ZD168573', 'ZD168738') AND a.supplierId=6412) OR ( a.articleSearch IN ('33818', '33816', '98593') AND a.supplierId=4576) OR ( a.articleSearch IN ('160067710', '160067510', '160067610', '160067810') AND a.supplierId=323) OR ( a.articleSearch IN ('B11496', 'B11497', 'B11498', 'B11495', 'B11499', 'B11500', 'B19251') AND a.supplierId=4815) OR ( a.articleSearch IN ('DER32011', 'DER32012') AND a.supplierId=4760) OR ( a.articleSearch IN ('11210797602', '11210808502', '18050941902', '18050942002', '18050942102', '11211368802', '18050174402') AND a.supplierId=4353) OR ( a.articleSearch IN ('352033', '352120', '352035', '352037', '352039', '352061', '352067', '352114', '352115') AND a.supplierId=234) OR (a.articleSearch='39164' AND a.supplierId=101) OR ( a.articleSearch IN ('8EW351039171', '8EW351039184', '8EW351039194', '8EW351039794', '8EW351040064', '8EW351040071', '8EW351040081', '8EW351040391', '8EW351040401', '8EW351040411', '8EW351040414', '8EW351043301', '8EW351150324') AND a.supplierId=4734) OR ( a.articleSearch IN ('1199101600', '1199101880', '1199106800', '1199107000', '1199101700', '1199101980', '1199106200', '1199106600') AND a.supplierId=268) OR ( a.articleSearch IN ('414400', '416700', '414500', '416600', '416800', '416900', '417000', '417300') AND a.supplierId=6207) OR ( a.articleSearch IN ('CFF138000S', 'CFF169000S', 'CFF168000S', 'CFF170000S', 'CFF171000S', 'CFF186000P', 'CFF186001S', 'CFF187001S', 'CFF188000P', 'CFF188000S', 'CFF263000P', 'CFF391000S') AND a.supplierId=287) OR ( a.articleSearch IN ('850020', '85680', '850021', '85643', '85644', '85678', '85699', '85733', '85763') AND a.supplierId=123) OR ( a.articleSearch IN ('47387', '47394', '47400', '47381', '47388', '47389', '47395', '47396', '47881', '47915', '47925') AND a.supplierId=205) OR ( a.articleSearch IN ('04567', '06901', '14018', '04564', '04565', '04566', '07899', '11045', '12026', '12901', '13353', '29472', '29504', '30148', '35055') AND a.supplierId=4683) OR ( a.articleSearch IN ('PFN101', 'PFN122', 'PFN238', 'PFN014') AND a.supplierId=4558) OR ( a.articleSearch IN ('2999016SX', '2999261SX', '2999302SX', '2999017SX', '2999606SX') AND a.supplierId=4595) OR (a.articleSearch='30939164' AND a.supplierId=151) OR ( a.articleSearch IN ('89981482101', '91210547801', '91210547901', '99590013901', '99590014001', '99590014201', '99590332401', '99590579501', '99591286201', '11211503301', '99590014301', '99590360401', '99590609901', '99590789801', '99590993501', '99591803401') AND a.supplierId=4346) OR ( a.articleSearch IN ('0030140009', '0030140012', '0030140013', '0030140014', '0480140005', '0530140004', '0530140028', '0530140043', '0530140049', '0530140050') AND a.supplierId=4657) OR ( a.articleSearch IN ('330226', '330303') AND a.supplierId=4654) OR ( a.articleSearch IN ('302081', '302084', '302085', '302086', '302092', '302104', '302106', '302108', '302138') AND a.supplierId=422) OR ( a.articleSearch IN ('54111', '54299', '54589', '54618') AND a.supplierId=6558) OR ( a.articleSearch IN ('048029N', '048056N', '048092N', '048103N', '048106N', '048107N', '048108N', '048113N', '048132N', '488028N', '048620N', '048102N', '048055N') AND a.supplierId=80) OR ( a.articleSearch IN ('GA200496', 'GA200497', 'GA221001', 'GA221003', 'GA221004', 'GA221005', 'GA221006', 'GA221007', 'GA221017', 'GA221018', 'GA221019', 'GA221023', 'GA221024') AND a.supplierId=4688) OR ( a.articleSearch IN ('AI7524', 'VN7528', 'VN7529', 'VN7534', 'VN7535', 'VN7536', 'VN7537', 'VN7551', 'VW7528', 'VW7529', 'VW7534', 'VW7535', 'VW7536', 'VW7537') AND a.supplierId=247) OR ( a.articleSearch IN ('0011023102', '0011030163', '0026001102', '0026001103', '0026001104', '0026001429', '0026008019', '0026015819') AND a.supplierId=4995) OR ( a.articleSearch IN ('LE035', 'LE046', 'LE047', 'LE061', 'LE073', 'LE584', 'LE642', 'LE644', 'LEK014', 'LEK015', 'LEK016', 'LEK017') AND a.supplierId=6444) OR ( a.articleSearch IN ('1K0121205J', '1K0121207T', '1K0959455DL', '1K0959455ES', '1K0959455P') AND a.supplierId=6366) OR ( a.articleSearch IN ('BSG90510009', 'BSG90510015', 'BSG90510016', 'BSG90510017', 'BSG90510018', 'BSG90510019') AND a.supplierId=4455) OR ( a.articleSearch IN ('CEF73004AS', 'CEF73005AS', 'CEF73300AS', 'CEF73343AS', 'CEF73343GS', 'CEF73345AS', 'CEF73346AS', 'CEF73347AS', 'CEF73357AS', 'CEF73363AS', 'CEF73364AS') AND a.supplierId=484) OR ( a.articleSearch IN ('A2C59511337', 'A2C59511338', 'A2C59511339', 'A2C59511340', 'A2C59512885', 'A2C59512886') AND a.supplierId=83) OR ( a.articleSearch IN ('DY8139', 'DY8181', 'DY8182', 'DY8224', 'DY8256', 'DY8257', 'DY8259', 'DY9054', 'DY9055', 'DY9078', 'DY9079', 'DY9144', 'DY9166', 'DY9198') AND a.supplierId=6742) OR ( a.articleSearch IN ('8221414', '8221415', '8221419', '8229503', 'DCL1229', 'DCL1230', 'DCL1231', 'DCL1232', 'DCL1238', 'DCL1243', '2214001', '8229502') AND a.supplierId=253) OR ( a.articleSearch IN ('EVM021N', 'EVM022N', 'EVM024DPSN', 'EVM025N', 'VRM018DPSN', 'VRM018HLLN') AND a.supplierId=4882) OR ( a.articleSearch IN ('EAU031', 'EAU032', 'EAU033', 'EAU034', 'EAU035', 'EVW068', 'EVW069', 'EVW077') AND a.supplierId=4585) OR (a.articleSearch='94SKV031' AND a.supplierId=4969) OR ( a.articleSearch IN ('05102019', '05102020', '05102023', '05102024', '05102041') AND a.supplierId=313) OR ( a.articleSearch IN ('307500018', '307500019', '307500020', '307500021') AND a.supplierId=4524) OR ( a.articleSearch IN ('EV010300', 'EV300490') AND a.supplierId=296) OR ( a.articleSearch IN ('0026307548', '95342601', '95342604', '95342605', '95342606', '95452601') AND a.supplierId=78) OR (a.articleSearch='9904821' AND a.supplierId=4546) OR ( a.articleSearch IN ('LGK014081004', 'LGK014081005', 'LGK014081300', 'LGK014081343', 'LGK014081345', 'LGK014081346', 'LGK014081347', 'LGK014081357', 'LGK014081363', 'LGK014081364', 'OEM014081343', 'OEM014081345', 'OEM014081347', 'OEM014081364') AND a.supplierId=6012) OR ( a.articleSearch IN ('LFAC18K0', 'LFC18K2', 'LFS18K2') AND a.supplierId=4707) OR ( a.articleSearch IN ('RF1510', 'RF1518') AND a.supplierId=4600) OR ( a.articleSearch IN ('069422555010', '069422556010', '069422557010', '069422558010', '069422559010') AND a.supplierId=4723) OR ( a.articleSearch IN ('710027', 'AC260176', 'AC261894', 'AC264897', 'AC265489', 'AC272012', 'AC277242') AND a.supplierId=403) OR (a.articleSearch='MRP2B03' AND a.supplierId=4773) OR ( a.articleSearch IN ('4002001', '4002002', '4002003', '4002004') AND a.supplierId=94) OR ( a.articleSearch IN ('1002360003', '1002360050', '1002360051') AND a.supplierId=144) OR (a.articleSearch='ERDAU012' AND a.supplierId=6355) OR ( a.articleSearch IN ('AD022F003', 'AD022F005', 'AD202F001', 'AD3203300', 'AD320F002', 'AI7524', 'VG055F004', 'VG055F006', 'VN7528', 'VN7529', 'VN7534', 'VN7535', 'VN7536', 'VN7537', 'VW7528', 'VW7529', 'VW7534', 'VW7535', 'VW7536', 'VW7537') AND a.supplierId=340) OR ( a.articleSearch IN ('QF25A00099', 'QF75A00010', 'QF75A00011', 'QF75A00012', 'QF75A00013') AND a.supplierId=4339) OR ( a.articleSearch IN ('40276003BN', '40276343BN', '40276343OE', '40276363BN', '40276400BN', '40276463BN', '40276500BN', '40276543BN', '40276643BN', '40276743BN', '40276753BN') AND a.supplierId=6335) OR ( a.articleSearch IN ('508R0005', '508R0012', '508R0027', '508R0028', '508R0032', '508R0034') AND a.supplierId=6358) OR ( a.articleSearch IN ('SEF730040', 'SEF730050', 'SEF733000', 'SEF733430', 'SEF733431', 'SEF733450', 'SEF733460', 'SEF733470', 'SEF733570', 'SEF733630', 'SEF733640') AND a.supplierId=4592) OR ( a.articleSearch IN ('SKRF0300004', 'SKRF0300012', 'SKRF0300027', 'SKRF0300028', 'SKRF0300032') AND a.supplierId=6357) OR ( a.articleSearch IN ('D8A013TT', 'D8W021TT', 'D8W022TT', 'D8W023TT', 'D8W032TT', 'D8W034TT', 'D8W036TT', 'D8W037TT', 'D8W045TT') AND a.supplierId=4466) OR ( a.articleSearch IN ('111282', '111283', '111284', '111285', '112321', '116982') AND a.supplierId=301) OR ( a.articleSearch IN ('8020001', '8020057', '8370026', '8370027', '8370028', '8370029', '8370030', '8370031', '8370032', '8370051', '8371005', '8371006', '8371011', '8371012', '8371013', '8371014', '8371015') AND a.supplierId=61) OR ( a.articleSearch IN ('1K0959455ES', '1K0959455FR', '1K0959455Q') AND a.supplierId=4999) OR ( a.articleSearch IN ('0332744', '5894744', '5894745', '5894746', '5894747', '5894748', '5894749') AND a.supplierId=36) OR ( a.articleSearch IN ('V15010002', 'V15011869', 'V15011870', 'V15011880', 'V15011881', 'V15011882', 'V15011883', 'V15011886', 'V15011892', 'V15011893', 'V150118931', 'V15011920', 'V15011932', 'V15011934') AND a.supplierId=183) OR ( a.articleSearch IN ('WG1720344', 'WG1720349', 'WG1720350', 'WG1720351', 'WG1720356', 'WG1720357', 'WG1720358', 'WG1720361', 'WG2101642', 'WG2101643', 'WG2101648', 'WG2101709', 'WG2101711', 'WG2101713', 'WG2101715', 'WG2101737', 'WG2101743', 'WG2161701') AND a.supplierId=4832) OR ( a.articleSearch IN ('351327', '351827', '352235', '352237', '352239', '352241') AND a.supplierId=6347) OR ( a.articleSearch IN ('ZVF455C', 'ZVYL7395') AND a.supplierId=6274)An internal server error occurred.