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 ('SAK227', 'SA1227') AND a.supplierId=225) OR ( a.articleSearch IN ('ADU172511', 'ADU172522') AND a.supplierId=350) OR ( a.articleSearch IN ('1987432213', '1987432513', '1987435094') AND a.supplierId=30) OR (a.articleSearch='BSG60145001' AND a.supplierId=4455) OR ( a.articleSearch IN ('CCF0180', 'CCF0180C') AND a.supplierId=43) OR ( a.articleSearch IN ('NC2345', 'NC2345CA') AND a.supplierId=163) OR ( a.articleSearch IN ('80000616', '80001728', '80000614') AND a.supplierId=140) OR ( a.articleSearch IN ('DCF079P', 'DCF081K', 'DCF511P') AND a.supplierId=4760) OR ( a.articleSearch IN ('1640600180', '1640606880') AND a.supplierId=4391) OR ( a.articleSearch IN ('FCC190', 'FCS190') AND a.supplierId=271) OR ( a.articleSearch IN ('K1288', 'K1288A') AND a.supplierId=256) OR ( a.articleSearch IN ('CF10436', 'CFA10436', 'CF11768', 'CFP10436') AND a.supplierId=6356) OR ( a.articleSearch IN ('AG643CF', 'AG644CFC') AND a.supplierId=4663) OR ( a.articleSearch IN ('E2916LC', 'E2916LI', 'E2916LB') AND a.supplierId=81) OR ( a.articleSearch IN ('AC0149', 'AC0149C') AND a.supplierId=4378) OR ( a.articleSearch IN ('LA307', 'LAK307', 'LAO307') AND a.supplierId=287) OR ( a.articleSearch IN ('50014228', '50014229') AND a.supplierId=432) OR ( a.articleSearch IN ('LAC1236', 'LAC1236C') AND a.supplierId=4600) OR ( a.articleSearch IN ('CU260310', 'CU3569', 'CUK3569', 'FP3569', 'CU2603') AND a.supplierId=4) OR (a.articleSearch='17411' AND a.supplierId=244) OR ( a.articleSearch IN ('EKR7228', 'ELR7228', 'ELR7310') AND a.supplierId=218) OR ( a.articleSearch IN ('0123190038', '0123190043', '0123200038', '0123260038PD') AND a.supplierId=144) OR ( a.articleSearch IN ('K986', 'K986C') AND a.supplierId=462) OR ( a.articleSearch IN ('AFC1272', 'AFW1272') AND a.supplierId=6495) OR ( a.articleSearch IN ('PF2307', 'PF2346') AND a.supplierId=4558) OR ( a.articleSearch IN ('AH268', 'AHC268', 'AH420', 'AHA268') AND a.supplierId=38) OR ( a.articleSearch IN ('CA26080', 'CAC26080') AND a.supplierId=6405) OR ( a.articleSearch IN ('0259084', '0259082') AND a.supplierId=209) OR ( a.articleSearch IN ('5313700', '5416100', '5332200') AND a.supplierId=137) OR ( a.articleSearch IN ('18190187001', '18190188401') AND a.supplierId=4346) OR ( a.articleSearch IN ('IF3147', 'IF3147K', 'IF3147P') AND a.supplierId=4894) OR (a.articleSearch='K30264' AND a.supplierId=4814) OR ( a.articleSearch IN ('1654', '654') AND a.supplierId=228) OR ( a.articleSearch IN ('1531811', '1531812') AND a.supplierId=317) OR ( a.articleSearch IN ('MS6330', 'MS6330C') AND a.supplierId=180) OR (a.articleSearch='X10760' AND a.supplierId=4975) OR ( a.articleSearch IN ('71698', '71699') AND a.supplierId=4576) OR ( a.articleSearch IN ('PAL24018', 'PAL24056') AND a.supplierId=442) OR ( a.articleSearch IN ('104043', '66627') AND a.supplierId=4495) OR ( a.articleSearch IN ('180049610', '180053110') AND a.supplierId=323) OR ( a.articleSearch IN ('LATR145', 'LATR163') AND a.supplierId=4337) OR (a.articleSearch='HB822' AND a.supplierId=4280) OR ( a.articleSearch IN ('0011016685', '0012003274', '0012003354') AND a.supplierId=4995) OR (a.articleSearch='BFC1061' AND a.supplierId=475) OR ( a.articleSearch IN ('EKF175', 'EKF175A') AND a.supplierId=421) OR ( a.articleSearch IN ('28000210812', '28000211082', '28000212312') AND a.supplierId=6513) OR ( a.articleSearch IN ('PC8199', 'PC8389', 'PCA8199', 'PCK8199') AND a.supplierId=437) OR ( a.articleSearch IN ('TSP0325259', 'TSP0325259C') AND a.supplierId=89) OR ( a.articleSearch IN ('M110087', 'M110711K', 'M110943') AND a.supplierId=186) OR ( a.articleSearch IN ('DP4031', 'DP4072') AND a.supplierId=4396) OR ( a.articleSearch IN ('DCI0151', 'DCI0251M', 'DCI1151') AND a.supplierId=253) OR (a.articleSearch='1110050005' AND a.supplierId=4345) OR ( a.articleSearch IN ('P616898', 'P787452') AND a.supplierId=6723) OR (a.articleSearch='DP1110120059' AND a.supplierId=4948) OR ( a.articleSearch IN ('465823', '465824', '467908') AND a.supplierId=355) OR ( a.articleSearch IN ('DCF307', 'DCFK307') AND a.supplierId=4881) OR (a.articleSearch='FT37419' AND a.supplierId=4938) OR ( a.articleSearch IN ('30640', '30641', '39608') AND a.supplierId=101) OR ( a.articleSearch IN ('CF159', 'CF159C') AND a.supplierId=4838) OR ( a.articleSearch IN ('HC7135', 'HCK7135') AND a.supplierId=4659) OR ( a.articleSearch IN ('177', '677', 'BL677') AND a.supplierId=441) OR ( a.articleSearch IN ('AF26462', 'AF55735', 'AF55769') AND a.supplierId=4581) OR (a.articleSearch='792209001' AND a.supplierId=6484) OR (a.articleSearch='13065320' AND a.supplierId=313) OR ( a.articleSearch IN ('SC5102', 'SC5102CA') AND a.supplierId=6309) OR (a.articleSearch='17411' AND a.supplierId=341) OR ( a.articleSearch IN ('B4M026CPR', 'B4M026PR') AND a.supplierId=4689) OR ( a.articleSearch IN ('1128100400', '1128104200') AND a.supplierId=268) OR ( a.articleSearch IN ('6080063', 'F414801', 'F509001') AND a.supplierId=185) OR ( a.articleSearch IN ('FC084Z', 'FC188Z') AND a.supplierId=387) OR ( a.articleSearch IN ('1731120', '1731125') AND a.supplierId=4546) OR ( a.articleSearch IN ('LFCP179', 'LFCP275') AND a.supplierId=4973) OR (a.articleSearch='350203062280' AND a.supplierId=4723) OR ( a.articleSearch IN ('MMF025059', 'MMF025151', 'MMF025193') AND a.supplierId=4570) OR ( a.articleSearch IN ('65231', '67231') AND a.supplierId=133) OR ( a.articleSearch IN ('35691IFPCSMS', '3569IFBPCSMS', '3569IFPCSMS', '450001933') AND a.supplierId=358) OR ( a.articleSearch IN ('260514', '260848', '261838', '261956') AND a.supplierId=403) OR ( a.articleSearch IN ('HB197', 'HB197C', 'HB335') AND a.supplierId=4470) OR ( a.articleSearch IN ('AVF1215', 'AVF1215C') AND a.supplierId=6483) OR ( a.articleSearch IN ('LVCF559', 'VCF410') AND a.supplierId=4564) OR (a.articleSearch='FK264' AND a.supplierId=490) OR (a.articleSearch='DCF079P' AND a.supplierId=440) OR (a.articleSearch='2135514' AND a.supplierId=4380) OR ( a.articleSearch IN ('CAF212001', 'CAF212011', 'CAF234801') AND a.supplierId=378) OR (a.articleSearch='FC01826' AND a.supplierId=129) OR ( a.articleSearch IN ('01065300A', '01069300A') AND a.supplierId=63) OR ( a.articleSearch IN ('15212216', '15212271') AND a.supplierId=4686) OR (a.articleSearch='PURPC3032' AND a.supplierId=6891) OR ( a.articleSearch IN ('QFC0105', 'QFC0185', 'QFC0425', 'QFC0533AB') AND a.supplierId=57) OR ( a.articleSearch IN ('424I0106', '424I0238', '424I0384') AND a.supplierId=6358) OR ( a.articleSearch IN ('0101349', '202231') AND a.supplierId=4623) OR ( a.articleSearch IN ('CK0149', 'CK0149K') AND a.supplierId=4263) OR ( a.articleSearch IN ('H3760', 'V3760') AND a.supplierId=6644) OR ( a.articleSearch IN ('177', '677', 'BL677') AND a.supplierId=27) OR ( a.articleSearch IN ('G760', 'P760') AND a.supplierId=4768) OR ( a.articleSearch IN ('S3137C', 'S3322C', 'S4161CA') AND a.supplierId=142) OR ( a.articleSearch IN ('PC9819', 'PC9838', 'PCK9819') AND a.supplierId=92) OR ( a.articleSearch IN ('SMCFJ110', 'SMCFJ110E') AND a.supplierId=4348) OR ( a.articleSearch IN ('SKIF0170105', 'SKIF0170241') AND a.supplierId=6357) OR ( a.articleSearch IN ('7110204SX', '7110210SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('10930640', '10930641') AND a.supplierId=151) OR (a.articleSearch='777320' AND a.supplierId=6312) OR ( a.articleSearch IN ('CK10436', 'CK10436C', 'CK1043610', 'CK1043610C') AND a.supplierId=4011) OR ( a.articleSearch IN ('E470', 'E712', 'EA470', 'EC470') AND a.supplierId=91) OR ( a.articleSearch IN ('111659', '111660') AND a.supplierId=301) OR ( a.articleSearch IN ('V30311053', 'V30301053', 'V303010611') AND a.supplierId=183) OR ( a.articleSearch IN ('715601', '715602') AND a.supplierId=21) OR (a.articleSearch='17411' AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1019072', 'WG1019073', 'WG1215345', 'WG1215635', 'WG1233555', 'WG1233557', 'WG1234162', 'WG1427210', 'WG1427211', 'WG1735355', 'WG1747213', 'WG1774696', 'WG1774697', 'WG1788841', 'WG1793696', 'WG1793697', 'WG1917021') AND a.supplierId=4832) OR ( a.articleSearch IN ('WP9330', 'WP9331') AND a.supplierId=324) OR ( a.articleSearch IN ('110439', '111501', '111655', '112037', '112045', '112047') AND a.supplierId=6347) OR ( a.articleSearch IN ('Z050', 'Z053', 'ZF050', 'ZF053') AND a.supplierId=499)An internal server error occurred.