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 ('OP6006', 'OP5001') AND a.supplierId=271) OR ( a.articleSearch IN ('02766', '05161') AND a.supplierId=4683) OR ( a.articleSearch IN ('GA75405', 'GA75403', 'GA75415') AND a.supplierId=110) OR ( a.articleSearch IN ('588001', '588008', '588014', '588032', '588071', '592920', '593490', '599327') AND a.supplierId=21) OR ( a.articleSearch IN ('99030010001', '99030010201', '99031223901', '99031224001', '99031346901', '99031347001', '99031347101', '99031347501', '99031771501') AND a.supplierId=4346) OR ( a.articleSearch IN ('10727', '13312', '13744') AND a.supplierId=4598) OR ( a.articleSearch IN ('YT500005', 'YT500012') AND a.supplierId=4924) OR ( a.articleSearch IN ('885011M', '885015', '885336') AND a.supplierId=4528) OR ( a.articleSearch IN ('54772', '54773') AND a.supplierId=6558) OR ( a.articleSearch IN ('1580002', '1580004', '1580021', '1580110') AND a.supplierId=317) OR ( a.articleSearch IN ('10720004', '10720012', '10723017') AND a.supplierId=479) OR ( a.articleSearch IN ('55194', '55195') AND a.supplierId=4576) OR (a.articleSearch='13005503' AND a.supplierId=257) OR ( a.articleSearch IN ('AFP0009', 'AFP0009INA', 'AFP0009V', 'AFP0010', 'AFP0010INA', 'AFP0010V', 'AFP3014', 'AFP3014INA', 'AFP3014V', 'AP0078BOSCH') AND a.supplierId=4843) OR ( a.articleSearch IN ('621015', '621263') AND a.supplierId=300) OR ( a.articleSearch IN ('RT5000', 'RT5007', 'RT5012') AND a.supplierId=4737) OR ( a.articleSearch IN ('0380340', '0380350', '0380584', '0380646', '0380649', '060044', '060045', '060046', '060047', '060064', '060106', '060109') AND a.supplierId=4651) OR ( a.articleSearch IN ('130071110', '130071210', '130071410', '130071510', '130071810', '130072110') AND a.supplierId=323) OR ( a.articleSearch IN ('A03800', 'A03828', 'A03848', 'A04616') AND a.supplierId=4464) OR ( a.articleSearch IN ('DC0101', 'DC9600') AND a.supplierId=478) OR (a.articleSearch='ADV186101' AND a.supplierId=350) OR ( a.articleSearch IN ('F00M147600', 'F00M147724', 'F00M147801', 'F00M991002', 'F00M991004', 'F00M991045', 'F00M991122', 'F00M991358', 'F00M991378', 'F00M147737', 'F00M991284', 'F00M991043') AND a.supplierId=30) OR ( a.articleSearch IN ('RLA3143', 'RLA3161', 'RLA3162', 'RLA4040') AND a.supplierId=195) OR (a.articleSearch='022903119C' AND a.supplierId=6366) OR ( a.articleSearch IN ('E4W001BTA', 'E4W002BTA', 'E4W005BTA', 'E4W008BTA') AND a.supplierId=4693) OR ( a.articleSearch IN ('609340', '609490', '614280', '803660', 'SZK03650') AND a.supplierId=6549) OR ( a.articleSearch IN ('051000004810', '051000007810', '051000041810', '305517070010', '305517070210', '305517070215', '305517070500') AND a.supplierId=28) OR ( a.articleSearch IN ('57864', '67466', '67469') AND a.supplierId=4463) OR ( a.articleSearch IN ('CCP90100AS', 'CCP90100GS', 'CCP90102AS', 'CCP90102GS', 'CCP90109AS', 'CCP90109GS', 'CCP90130AS', 'CCP90130GS') AND a.supplierId=484) OR ( a.articleSearch IN ('460968', '460970', '460971') AND a.supplierId=405) OR ( a.articleSearch IN ('AP9001', 'AP9002', 'AP9090') AND a.supplierId=6513) OR ( a.articleSearch IN ('500499', '500751', '500757', '500785', '501224') AND a.supplierId=6263) OR ( a.articleSearch IN ('ALP2325', 'ALP2395') AND a.supplierId=42) OR ( a.articleSearch IN ('1180310', '1180312', '1272050') AND a.supplierId=355) OR (a.articleSearch='EAA221445' AND a.supplierId=4359) OR ( a.articleSearch IN ('806102', '826019', '826033', '826039') AND a.supplierId=391) OR ( a.articleSearch IN ('ZN5378', 'ZN5380', 'ZN5632') AND a.supplierId=234) OR ( a.articleSearch IN ('11SKV001', '11SKV002', '11SKV003', '11SKV007', '11SKV009', '11SKV021', '11SKV032') AND a.supplierId=4969) OR ( a.articleSearch IN ('4332', '4333') AND a.supplierId=4834) OR ( a.articleSearch IN ('15254', '15262', '34548') AND a.supplierId=101) OR ( a.articleSearch IN ('455001', '455004', '455013', '455155') AND a.supplierId=441) OR (a.articleSearch='1010062' AND a.supplierId=87) OR ( a.articleSearch IN ('OAP7013', 'OAP7033', 'OAP7087') AND a.supplierId=6665) OR ( a.articleSearch IN ('335171', '335201', '335411', '335591') AND a.supplierId=4379) OR ( a.articleSearch IN ('621014', '621015') AND a.supplierId=181) OR (a.articleSearch='AP0016' AND a.supplierId=6443) OR ( a.articleSearch IN ('230293', '230302', '237320', '332295', '332317') AND a.supplierId=4819) OR ( a.articleSearch IN ('8EL012429951', '9XU358038041', '9XU358038061', '9XU358038071', '9XU358039181') AND a.supplierId=4734) OR ( a.articleSearch IN ('120009', '120010') AND a.supplierId=178) OR (a.articleSearch='32045340' AND a.supplierId=72) OR ( a.articleSearch IN ('4555001', '4555004', '4555013', '4555155') AND a.supplierId=341) OR ( a.articleSearch IN ('DB0246', 'DB0251') AND a.supplierId=239) OR ( a.articleSearch IN ('301008', '301009', '301011', '301096') AND a.supplierId=4862) OR ( a.articleSearch IN ('529000110', '529000210', '529000310', '529000410', '529000510', '529000610', '529002210', '529002310', '529005220', '529009410', '529009810', '529011010', '529013410', '529016230', '529046520', '529046620', '529046720', '529046820', '529046920', '529047020', '529047120', '529047520', '535000110', '535000510', '535001210', '535003610') AND a.supplierId=204) OR ( a.articleSearch IN ('120010', '120258') AND a.supplierId=262) OR (a.articleSearch='RA503' AND a.supplierId=156) OR (a.articleSearch='130503' AND a.supplierId=481) OR (a.articleSearch='1190500100' AND a.supplierId=268) OR ( a.articleSearch IN ('RC003', 'RC008', 'RC015') AND a.supplierId=185) OR ( a.articleSearch IN ('FI11540', 'FI9570', 'FI9620') AND a.supplierId=4462) OR ( a.articleSearch IN ('1220890', '1220896', '1220902') AND a.supplierId=4546) OR ( a.articleSearch IN ('95156001', '95156002') AND a.supplierId=4712) OR ( a.articleSearch IN ('LGK008098100', 'LGK008098102', 'LGK008098109', 'LGK008098130', 'OEM008098100', 'OEM008098102', 'OEM008098109', 'OEM008098130') AND a.supplierId=6012) OR ( a.articleSearch IN ('LOPA0006', 'LOPA0009', 'LOPA0011', 'LOPA0012', 'LOPA0015', 'LOPA0046') AND a.supplierId=4501) OR (a.articleSearch='PA1001' AND a.supplierId=4600) OR ( a.articleSearch IN ('940113010005', '940113010007', '940113010115') AND a.supplierId=4723) OR ( a.articleSearch IN ('14700', '14701', '14706', '14721') AND a.supplierId=133) OR ( a.articleSearch IN ('300044', '300045', '300155') AND a.supplierId=403) OR (a.articleSearch='MAP8503' AND a.supplierId=4773) OR ( a.articleSearch IN ('45001', '45004', '45013', '45155') AND a.supplierId=244) OR ( a.articleSearch IN ('ZN5378', 'ZN5380', 'ZN5632') AND a.supplierId=342) OR (a.articleSearch='05002' AND a.supplierId=4664) OR (a.articleSearch='2170007' AND a.supplierId=94) OR ( a.articleSearch IN ('1000531004', '1000531005') AND a.supplierId=144) OR (a.articleSearch='AG04022' AND a.supplierId=6495) OR ( a.articleSearch IN ('AST2056', 'AST2066', 'AST2300', 'AST2362', 'AST2365') AND a.supplierId=6874) OR ( a.articleSearch IN ('4910061', '4910062', '4910073') AND a.supplierId=127) OR (a.articleSearch='M515I01' AND a.supplierId=440) OR ( a.articleSearch IN ('ESAAU001', 'ESAAU004', 'ESAVW000', 'ESAVW001') AND a.supplierId=6355) OR ( a.articleSearch IN ('ACA300100', 'ACA306200') AND a.supplierId=378) OR ( a.articleSearch IN ('F51004', 'F51006', 'F51169') AND a.supplierId=129) OR ( a.articleSearch IN ('PTA1040001', 'PTA1040002') AND a.supplierId=6457) OR ( a.articleSearch IN ('P5000110', 'P5000510', 'P5001210', 'P5003610') AND a.supplierId=4558) OR (a.articleSearch='JAPRA503' AND a.supplierId=4652) OR (a.articleSearch='81112939' AND a.supplierId=4543) OR ( a.articleSearch IN ('PAL003', 'PAL008') AND a.supplierId=4655) OR ( a.articleSearch IN ('10149002', '10149003') AND a.supplierId=4686) OR ( a.articleSearch IN ('QF41P00002', 'QF41P00004', 'QF41P00018') AND a.supplierId=4339) OR (a.articleSearch='QTR102' AND a.supplierId=57) OR ( a.articleSearch IN ('23058001BN', '23058001OE', '23058031BN', '23058031OE', '23058201BN', '23058201OE', '23058901BN', '23058901OE') AND a.supplierId=6335) OR ( a.articleSearch IN ('RKT2056', 'RKT2066', 'RKT2300', 'RKT2362', 'RKT2365', 'RKTA0044', 'RKTA0045', 'RKTA0046', 'RKTA0047', 'RKTA0064', 'RKTA0106', 'RKTA0109') AND a.supplierId=4330) OR ( a.articleSearch IN ('1390F0003', '1390F0005', '542R0054', '542R0064', '542R0234', '542R0271', '542R0290', '542R0494') AND a.supplierId=6358) OR ( a.articleSearch IN ('5544480', '55451', '55471', '55472', '5548081', '5571480', '5571481', '5571680', '5573180', '55755', '5577680', '5577681', '5577682', '5577780', '5579080', '5630280', '56305802') AND a.supplierId=23) OR ( a.articleSearch IN ('SCP901000', 'SCP901001', 'SCP901020', 'SCP901021', 'SCP901090', 'SCP901091', 'SCP901300', 'SCP901301') AND a.supplierId=4592) OR ( a.articleSearch IN ('1676001', '1676002') AND a.supplierId=260) OR ( a.articleSearch IN ('V500051', 'V500121') AND a.supplierId=6377) OR (a.articleSearch='280467' AND a.supplierId=431) OR ( a.articleSearch IN ('455001', '455004', '455013', '455155') AND a.supplierId=27) OR ( a.articleSearch IN ('VKM03100', 'VKM03107', 'VKM03117', 'VKMAF310001', 'VKMAF310003', 'VKMAF310142', 'VKMAF310201', 'VKMAF31022', 'VKMAF31054', 'VKMAF31098') AND a.supplierId=50) OR (a.articleSearch='STX100192' AND a.supplierId=6382) OR ( a.articleSearch IN ('SKFC1210002', 'SKFC1210004', 'SKRBS1200053', 'SKRBS1200063', 'SKRBS1200233', 'SKRBS1200248', 'SKRBS1200279', 'SKRBS1200289', 'SKRBS1200493') AND a.supplierId=6357) OR ( a.articleSearch IN ('SGP1801', 'SGP1802', 'SGP1803') AND a.supplierId=4771) OR (a.articleSearch='T405002' AND a.supplierId=4667) OR ( a.articleSearch IN ('2001400SX', '8806803SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30140006', '30140008', '30934548') AND a.supplierId=151) OR ( a.articleSearch IN ('111877', '111878', '114101') AND a.supplierId=301) OR ( a.articleSearch IN ('AP1002', 'AP1004', 'AP1022', 'AP1159') AND a.supplierId=4732) OR ( a.articleSearch IN ('423234', '423869') AND a.supplierId=4970) OR ( a.articleSearch IN ('8641104001', '8641104002', '8641294002', '8641294015') AND a.supplierId=108) OR ( a.articleSearch IN ('431828', '431834', '431849', '431874') AND a.supplierId=4730) OR (a.articleSearch='06B903119B' AND a.supplierId=4999) OR ( a.articleSearch IN ('V107526', 'V10230001', 'V10230002', 'V10230004', 'V10230006', 'V10230008') AND a.supplierId=183) OR ( a.articleSearch IN ('2491105', '2491255', '2491256', '24912561', '24912711') AND a.supplierId=4627) OR ( a.articleSearch IN ('471190001', '471190003', '471190011', '471190115') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1013421', 'WG1013432', 'WG1253584', 'WG1253595', 'WG1792909', 'WG1792922', 'WG1907384', 'WG2003997', 'WG2101377', 'WG2112138') AND a.supplierId=4832) OR ( a.articleSearch IN ('350655', '350657', '350663', '350665') AND a.supplierId=6347)An internal server error occurred.