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='BSG90340018' AND a.supplierId=4455) OR ( a.articleSearch IN ('607414', '607415', '607771', '607921') AND a.supplierId=311) OR ( a.articleSearch IN ('2310PV', '23115021', '2311PV', '0216F15', '2310030', '2314PVLH', '2314PVRH') AND a.supplierId=4674) OR ( a.articleSearch IN ('306216', '306655', '304436', '24089', '36037', '36476') AND a.supplierId=6363) OR ( a.articleSearch IN ('151414', '151771', '151415', '151921') AND a.supplierId=121) OR ( a.articleSearch IN ('5147129', '512374') AND a.supplierId=127) OR ( a.articleSearch IN ('54980016701', '44981773701', '44981774001') AND a.supplierId=4346) OR ( a.articleSearch IN ('73371', '75413') AND a.supplierId=4576) OR (a.articleSearch='62000012' AND a.supplierId=257) OR ( a.articleSearch IN ('ASBTINPLS', 'ASBTPLSF', 'SK1414', 'VW6CB', 'VWDL6RF', 'VWDR6RF', 'VWIU5021', 'VWIUPLS', 'VWPLS', 'VWSHPLSR') AND a.supplierId=4631) OR ( a.articleSearch IN ('820034', '820178', '820246', '820619', '821597', '830603') AND a.supplierId=300) OR ( a.articleSearch IN ('110080610', '110080710') AND a.supplierId=323) OR ( a.articleSearch IN ('G300104', 'G400049', 'G400367', 'G450011', 'G450019') AND a.supplierId=4464) OR (a.articleSearch='0025010742' AND a.supplierId=4995) OR ( a.articleSearch IN ('CV0103A', 'CV0158A', 'CV7902A') AND a.supplierId=478) OR (a.articleSearch='6Q0498099EMACH' AND a.supplierId=6366) OR ( a.articleSearch IN ('50876', 'BSP24540') AND a.supplierId=157) OR ( a.articleSearch IN ('GSK4530K', 'GVW5200K') AND a.supplierId=243) OR ( a.articleSearch IN ('758636', '760241', '760244') AND a.supplierId=405) OR (a.articleSearch='011' AND a.supplierId=318) OR ( a.articleSearch IN ('5316', '6252N3') AND a.supplierId=393) OR ( a.articleSearch IN ('ECV050', 'ECV098', 'ECV167', 'ECV271') AND a.supplierId=421) OR ( a.articleSearch IN ('C120181', 'C120232') AND a.supplierId=186) OR (a.articleSearch='1050020187' AND a.supplierId=4345) OR ( a.articleSearch IN ('DP2110101117', 'DP2110101424') AND a.supplierId=4948) OR ( a.articleSearch IN ('DCV603003', 'DCV603005', 'DCV603006', 'DCV603011') AND a.supplierId=4881) OR ( a.articleSearch IN ('77SO1003', '77VW1055') AND a.supplierId=4135) OR ( a.articleSearch IN ('CV23009K', 'CV24004K', 'T78396') AND a.supplierId=391) OR (a.articleSearch='DA60382R' AND a.supplierId=224) OR (a.articleSearch='6Q0498099EEURO' AND a.supplierId=6367) OR ( a.articleSearch IN ('771034930', '771035130') AND a.supplierId=192) OR ( a.articleSearch IN ('134900', '134939', '135086', '240257', '240258') AND a.supplierId=90) OR (a.articleSearch='109401' AND a.supplierId=101) OR (a.articleSearch='CV17048' AND a.supplierId=271) OR ( a.articleSearch IN ('11398034S', '29390011S', '29390016S', '29398028S') AND a.supplierId=4727) OR ( a.articleSearch IN ('FDS1572', 'FVJ0044') AND a.supplierId=87) OR ( a.articleSearch IN ('AU1120', 'AU1120K', 'SE1040', 'SK1006', 'SK1006K', 'WW1129', 'WW1129K') AND a.supplierId=316) OR ( a.articleSearch IN ('254018', '261096', '603011', '661039', '803024', '803041', '853002', '854006', '201586', '201594', '261199', '261280') AND a.supplierId=373) OR ( a.articleSearch IN ('CV10026', 'CV10993', 'CV20026', 'CV20027') AND a.supplierId=4756) OR ( a.articleSearch IN ('312648', '312649', '313005') AND a.supplierId=262) OR (a.articleSearch='GI0012' AND a.supplierId=156) OR (a.articleSearch='620012' AND a.supplierId=481) OR ( a.articleSearch IN ('1143107780', '1143302310', '1143302410', '1143400200', '1143500450') AND a.supplierId=268) OR ( a.articleSearch IN ('5011001', '5012001', '6001', '7084', '7086', '8001', '8096') AND a.supplierId=185) OR ( a.articleSearch IN ('KSK453', 'KVW520') AND a.supplierId=283) OR ( a.articleSearch IN ('CD1026', 'CD1027', 'CD1131', 'CI3761', 'CI8008', 'CI8013', 'CI8015', 'CI8016', 'CO3909', 'CI8014') AND a.supplierId=4600) OR ( a.articleSearch IN ('302004190283', '302009100010', '302009100053', '302015100029', '302015100255') AND a.supplierId=4723) OR ( a.articleSearch IN ('16831', '16839', '16854') AND a.supplierId=133) OR ( a.articleSearch IN ('302261SETMS', '302262SETMS', '303557SETMS', '304436SETMS') AND a.supplierId=358) OR ( a.articleSearch IN ('490230', '490250', '490333', '490868', '493196') AND a.supplierId=403) OR ( a.articleSearch IN ('12017', '12025', '39439') AND a.supplierId=4664) OR ( a.articleSearch IN ('7110107', '7110145', '7110150') AND a.supplierId=94) OR ( a.articleSearch IN ('1004980118', '1004980119') AND a.supplierId=144) OR ( a.articleSearch IN ('GA10004', 'GA10007', 'GA11005', 'GA11032', 'GA20776', 'GC02002') AND a.supplierId=6495) OR ( a.articleSearch IN ('12211444', '12211691', '12211981', '18215180') AND a.supplierId=4653) OR ( a.articleSearch IN ('NPWVW002', 'NPZSK005', 'NPZVW036') AND a.supplierId=6355) OR ( a.articleSearch IN ('CVJ543410', 'CVJ543510', 'CVJ575310', 'CVJ583110') AND a.supplierId=378) OR ( a.articleSearch IN ('CT1010', 'CT1056', 'CW2509', 'CW2732', 'DS3631') AND a.supplierId=129) OR (a.articleSearch='08961' AND a.supplierId=4683) OR ( a.articleSearch IN ('G1S005PC', 'G1W036PC', 'G7W002PC') AND a.supplierId=4690) OR ( a.articleSearch IN ('PCV1414', 'PCV1638', 'PCV1787', 'PCV2068') AND a.supplierId=4558) OR (a.articleSearch='JAPGI0012' AND a.supplierId=4652) OR (a.articleSearch='PNG72824' AND a.supplierId=6381) OR (a.articleSearch='27101414' AND a.supplierId=4686) OR ( a.articleSearch IN ('PRJ268', 'PRJ325', 'PRJ516', 'PRJ533') AND a.supplierId=4520) OR (a.articleSearch='QF21C00066' AND a.supplierId=4339) OR ( a.articleSearch IN ('AA439AN', 'AV08', 'SE01') AND a.supplierId=492) OR ( a.articleSearch IN ('5J0075', '5J0190') AND a.supplierId=6358) OR ( a.articleSearch IN ('75431', '75431S', '75432', '75432S') AND a.supplierId=23) OR ( a.articleSearch IN ('29K453', '36K520') AND a.supplierId=343) OR ( a.articleSearch IN ('121164', '221164') AND a.supplierId=431) OR ( a.articleSearch IN ('CV366N', 'PJ18N', 'PJ19N', 'PJ90N', 'VW249R', 'PJ22N', 'PJ44N', 'VW361R') AND a.supplierId=4607) OR ( a.articleSearch IN ('VKJA5265', 'VKJA5266', 'VKJC5079') AND a.supplierId=50) OR (a.articleSearch='SKJK0200093' AND a.supplierId=6357) OR ( a.articleSearch IN ('T412017', 'T412025', 'T439439') AND a.supplierId=4667) OR ( a.articleSearch IN ('1501414SX', '1501415SX', '1501532SX', '1581666SX', '1581711SX', '1581774SX', '1601004SX', '1601010SX', '1601015SX', '1601093SX', '1601199SX', '1771100SX', '1771104SX') AND a.supplierId=4595) OR (a.articleSearch='30109401' AND a.supplierId=151) OR ( a.articleSearch IN ('77SO1003', '77VW1055') AND a.supplierId=4758) OR ( a.articleSearch IN ('110807', '111722', '115566') AND a.supplierId=301) OR ( a.articleSearch IN ('300104', '400049', '400367', '450011', '450098') AND a.supplierId=4472) OR ( a.articleSearch IN ('854029144', '854029146', '854029180', '854029187') AND a.supplierId=108) OR ( a.articleSearch IN ('V102175', 'V107275', 'V107427') AND a.supplierId=183) OR ( a.articleSearch IN ('WG2029992', 'WG2031049') AND a.supplierId=4832) OR (a.articleSearch='363929' AND a.supplierId=6347) OR ( a.articleSearch IN ('AW4833', 'AW5596', 'GS3147', 'GS3170', 'GS3175', 'GS3788', 'GS4954') AND a.supplierId=4894) OR (a.articleSearch='ZV6R0407764F' AND a.supplierId=6274)An internal server error occurred.