SELECT DISTINCT m.manufacturerName AS cross_brand, ao.manufacturerId, ao.oemSearch, ao.oemnumber, ps.id AS supplier_product_id, ps.supplier_id AS real_supplier_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 ('ZD168468', 'ZD168469', 'ZD168674') AND a.supplierId=6412) OR ( a.articleSearch IN ('BSG65510011', 'BSG65510028', 'BSG65511001', 'BSG65511004', 'BSG65922047', 'BSG65510017', 'BSG65510023', 'BSG65510026') AND a.supplierId=4455) OR (a.articleSearch='352066' AND a.supplierId=234) OR ( a.articleSearch IN ('CFF296000S', 'CFF284000P', 'CFF297000S') AND a.supplierId=287) OR ( a.articleSearch IN ('069422733010', '069422330010', '069422332010', '069422343010', '069422422010', '069422433010', '069422747010', '069422758010') AND a.supplierId=4723) OR ( a.articleSearch IN ('85179', '85185', '85186', '85154', '85175', '85176', '85188', '85754', '85755', '85777') AND a.supplierId=123) OR ( a.articleSearch IN ('47010', '47015', '47308', '47310', '47582', '47622', '47623', '47877') AND a.supplierId=205) OR ( a.articleSearch IN ('12393', '29243', '11810', '29244', '29568') AND a.supplierId=4683) OR ( a.articleSearch IN ('2999321SX', '2999014SX', '2999265SX', '2999477SX', '2999480SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('0370140001', '0370140002', '0370140006', '0370140007', '0370140011', '0370140013', '0370140022', '0370140023', '0370140027', '0370140029', '0370140030', '0370140031') AND a.supplierId=4657) OR ( a.articleSearch IN ('330131', '330150', '330151') AND a.supplierId=4654) OR ( a.articleSearch IN ('321015', '321027', '321036', '321038', '321039', '321071', '321081', '321082', '321085', '321099', '321107', '321109', '321111') AND a.supplierId=422) OR ( a.articleSearch IN ('54292', '54293', '58364') AND a.supplierId=6558) OR (a.articleSearch='100895' AND a.supplierId=4381) OR ( a.articleSearch IN ('158017N', '158025N', '158066N', '158074N', '158075N', '158083N', '158084N', '158087N', '158094N', '158137N', '158045N', '158016N', '158033N') AND a.supplierId=80) OR ( a.articleSearch IN ('GA200818', 'GA200825', 'GA200826', 'GA200827', 'GA200828', 'GA200829', 'GA200830', 'GA200839', 'GA200842', 'GA201776', 'GA201830', 'GA201837', 'GA201839', 'GA201840', 'GA201841', 'GA201842', 'GA201843', 'GA201844', 'GA227003', 'GA227004', 'GA227020', 'GA200817') AND a.supplierId=4688) OR ( a.articleSearch IN ('OL7508', 'OL7509', 'OL7524', 'OL7604', 'OL7635', 'OL7670', 'OL7727') AND a.supplierId=247) OR (a.articleSearch='0066001999' AND a.supplierId=4995) OR ( a.articleSearch IN ('LE056', 'LE070', 'LE071', 'LE074', 'LE572', 'LE573', 'LE574', 'LE575', 'LE619', 'LE620', 'LE621', 'LE680') AND a.supplierId=6444) OR ( a.articleSearch IN ('0130303245', '0130303246', '0130303247', '0130303275', '0130303301', '0130303302', '0130303304', '3135103275', 'F006KM0606', '0130303834', '0130303835', '0130303843') AND a.supplierId=30) OR ( a.articleSearch IN ('CEF77020AS', 'CEF77024AS', 'CEF77028AS', 'CEF77029AS', 'CEF77032AS', 'CEF77035AS', 'CEF77303AS', 'CEF77303GS', 'CEF77308AS', 'CEF77308GS', 'CEF77311AS', 'CEF77311GS', 'CEF77316AS', 'CEF77316GS', 'CRS77032AS') AND a.supplierId=484) OR (a.articleSearch='CRV2066' AND a.supplierId=4334) OR (a.articleSearch='DER20013' AND a.supplierId=4760) OR ( a.articleSearch IN ('DY8238', 'DY8239', 'DY8242', 'DY8249', 'DY9010', 'DY9011', 'DY9016', 'DY9035', 'DY9077', 'DY9092') AND a.supplierId=6742) OR ( a.articleSearch IN ('1805001', '1805101', '8180510', '8189108', '8189109', 'DCL1020', 'DCL1145', 'DCL1146', 'DCL1147', 'DCL1286') AND a.supplierId=253) OR ( a.articleSearch IN ('EOP037', 'EOP038', 'EOP039', 'EOP040', 'EOP041', 'EOP042', 'EOP043', 'EOP044', 'EOP045', 'EOP046', 'EOP047', 'EOP052', 'EOP089', 'EOP091', 'EOP098', 'EOP101', 'EOP107', 'EOP108', 'EOP109', 'EOP110') AND a.supplierId=4585) OR ( a.articleSearch IN ('05071776', '05071830', '05071837', '05071840', '05071842', '05072013', '05072014', '05072015', '05072017', '05072018', '05072022') AND a.supplierId=313) OR ( a.articleSearch IN ('8EW351043681', '8EW351044061', '8EW351044071') AND a.supplierId=4734) OR ( a.articleSearch IN ('EV0200770', 'EV0200781', 'EV0200960', 'EV0200980', 'EV0200981', 'EV200770', 'EV200781', 'EV200980', 'EV200981') AND a.supplierId=296) OR ( a.articleSearch IN ('1299101000', '1299101100') AND a.supplierId=268) OR ( a.articleSearch IN ('418200', '418300', '418400', '418500', '418600', '418800') AND a.supplierId=6207) OR ( a.articleSearch IN ('50512602', '50512603', '50522601', '50522602', '50522603') AND a.supplierId=78) OR ( a.articleSearch IN ('9901521', '9901654') AND a.supplierId=4546) OR ( a.articleSearch IN ('LGK014085020', 'LGK014085024', 'LGK014085028', 'LGK014085029', 'LGK014085032', 'LGK014085035', 'LGK014085303', 'LGK014085308', 'LGK014085311', 'LGK014085316', 'OEM014085303', 'OEM014085308', 'OEM014085311', 'OEM014085316') AND a.supplierId=6012) OR (a.articleSearch='LFAC2166' AND a.supplierId=4707) OR ( a.articleSearch IN ('RF1182', 'RF1637') AND a.supplierId=4600) OR ( a.articleSearch IN ('710028', 'AC230104', 'AC230105') AND a.supplierId=403) OR (a.articleSearch='MRP2B03' AND a.supplierId=4773) OR (a.articleSearch='6142360012' AND a.supplierId=144) OR ( a.articleSearch IN ('PFN091', 'PFN124', 'PFN125', 'PFN127', 'PFN147') AND a.supplierId=4558) OR ( a.articleSearch IN ('OL7508', 'OL7509', 'OL7524', 'OL7604', 'OL7635', 'OL7670', 'OP0173310', 'OP0173320', 'OP017F001', 'OP017F003') AND a.supplierId=340) OR (a.articleSearch='18500003' AND a.supplierId=4686) OR ( a.articleSearch IN ('40081230BN', '40281020BN', '40281113BN', '40281113OE', '40281230BN', '40281303BN', '40281303OE', '40281420BN', '40281530BN', '40281613BN', '40281613OE', '40281803BN', '40281803OE', '40281820BN', '40281920BN') AND a.supplierId=6335) OR ( a.articleSearch IN ('508R0092', '508R0103', '508R0107') AND a.supplierId=6358) OR ( a.articleSearch IN ('SEF770200', 'SEF770240', 'SEF770280', 'SEF770290', 'SEF770320', 'SEF770350', 'SEF773030', 'SEF773031', 'SEF773080', 'SEF773081', 'SEF773110', 'SEF773111', 'SEF773160', 'SEF773161', 'SRS770320') AND a.supplierId=4592) OR ( a.articleSearch IN ('SKRF0300092', 'SKRF0300103', 'SKRF0300107') AND a.supplierId=6357) OR ( a.articleSearch IN ('D8X007TT', 'D8X009TT', 'D8X011TT', 'D8X013TT', 'D8X015TT', 'D8X016TT', 'D8X018TT', 'D8X019TT', 'D8X031TT', 'SALED8X015TT') AND a.supplierId=4466) OR ( a.articleSearch IN ('207210', '208167') AND a.supplierId=301) OR ( a.articleSearch IN ('8250011', '8250014', '8250021', '8250023', '8250024', '8250028', '8250033', '8251017') AND a.supplierId=61) OR ( a.articleSearch IN ('696173', '696280', '696355') AND a.supplierId=21) OR ( a.articleSearch IN ('3742744', '3742746', '3742747', '3742751', '3745744', '3745745', '3745746') AND a.supplierId=36) OR ( a.articleSearch IN ('V40011039', 'V40011041', 'V40011044', 'V40011052', 'V40011057', 'V40011058', 'V40011059', 'V40011061', 'V40011087', 'V40011088', 'V40011089') AND a.supplierId=183) OR ( a.articleSearch IN ('WG1720114', 'WG1720119', 'WG1720278', 'WG1720280', 'WG1720533', 'WG1720571', 'WG1720572', 'WG2101742', 'WG2161697') AND a.supplierId=4832) OR ( a.articleSearch IN ('560701', '560711', '560713', '560715') AND a.supplierId=6347)An internal server error occurred.