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 ('921VK023', '1VK023') AND a.supplierId=4871) OR ( a.articleSearch IN ('36348', '22734', '22736', '22884') AND a.supplierId=101) OR ( a.articleSearch IN ('28665', '08067', '09224') AND a.supplierId=4683) OR (a.articleSearch='10553005' AND a.supplierId=6304) OR ( a.articleSearch IN ('30936348', '32922734', '32922736', '32922884') AND a.supplierId=151) OR ( a.articleSearch IN ('66090821101', '66091523801', '88231789301', '66091523901', '66150027901', '76090016501') AND a.supplierId=4346) OR ( a.articleSearch IN ('K13746', 'K18236', 'K18246', 'K18326') AND a.supplierId=206) OR ( a.articleSearch IN ('5502131', '550261') AND a.supplierId=6414) OR (a.articleSearch='54177' AND a.supplierId=6558) OR ( a.articleSearch IN ('26340', '29212') AND a.supplierId=317) OR ( a.articleSearch IN ('CAB1011', 'CAB1404') AND a.supplierId=4537) OR (a.articleSearch='73856' AND a.supplierId=4576) OR ( a.articleSearch IN ('PAL31177', 'PAL31559') AND a.supplierId=442) OR ( a.articleSearch IN ('24372701732', '24372734022') AND a.supplierId=3) OR (a.articleSearch='120019910' AND a.supplierId=323) OR (a.articleSearch='PHC2038' AND a.supplierId=4337) OR ( a.articleSearch IN ('290HC00035', '290HC00073') AND a.supplierId=6271) OR (a.articleSearch='102101053891P' AND a.supplierId=4555) OR ( a.articleSearch IN ('1987477698', '1987477800', '1987477817', '1987482266', '1987482865', '1987477818') AND a.supplierId=30) OR ( a.articleSearch IN ('341035', '341630') AND a.supplierId=4805) OR (a.articleSearch='1J0609721AQ' AND a.supplierId=6366) OR ( a.articleSearch IN ('468057', '762584', '765706') AND a.supplierId=405) OR ( a.articleSearch IN ('VW02187', 'VW02213') AND a.supplierId=325) OR ( a.articleSearch IN ('721VW01', '721VW06') AND a.supplierId=6411) OR (a.articleSearch='25SKV726' AND a.supplierId=4969) OR ( a.articleSearch IN ('1608277780', 'E074218') AND a.supplierId=4391) OR (a.articleSearch='FBK1101' AND a.supplierId=271) OR ( a.articleSearch IN ('FHB432943', 'FHB434487') AND a.supplierId=62) OR ( a.articleSearch IN ('FBS020103', 'FBS02062') AND a.supplierId=54) OR ( a.articleSearch IN ('8AS355669111', '8AS355670241') AND a.supplierId=4734) OR (a.articleSearch='1170301800' AND a.supplierId=268) OR ( a.articleSearch IN ('432943J', '434487J') AND a.supplierId=49) OR ( a.articleSearch IN ('341035', '341630') AND a.supplierId=286) OR ( a.articleSearch IN ('6538', '7825') AND a.supplierId=4572) OR ( a.articleSearch IN ('380113', '380116') AND a.supplierId=4536) OR ( a.articleSearch IN ('C0953B', 'C1626B') AND a.supplierId=283) OR ( a.articleSearch IN ('320072', '320810') AND a.supplierId=403) OR ( a.articleSearch IN ('80046', '83253', '83977') AND a.supplierId=4664) OR ( a.articleSearch IN ('LVVB1581', 'VVB1114') AND a.supplierId=4564) OR ( a.articleSearch IN ('9047141', '9047151', '904794') AND a.supplierId=127) OR (a.articleSearch='PC3142' AND a.supplierId=4558) OR (a.articleSearch='BC3312' AND a.supplierId=57) OR ( a.articleSearch IN ('01020160', '01020242', '01480885') AND a.supplierId=6447) OR (a.articleSearch='124C0005' AND a.supplierId=6358) OR ( a.articleSearch IN ('C0953B', 'C1626B') AND a.supplierId=343) OR ( a.articleSearch IN ('554420', '723362', '805082') AND a.supplierId=263) OR ( a.articleSearch IN ('910579', '911868', '911980') AND a.supplierId=4582) OR (a.articleSearch='SKCPB1050004' AND a.supplierId=6357) OR ( a.articleSearch IN ('T480046', 'T483253', 'T483977') AND a.supplierId=4667) OR (a.articleSearch='2998507SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('109815', '112147', '114842') AND a.supplierId=301) OR ( a.articleSearch IN ('8140291114', '814029188') AND a.supplierId=108) OR (a.articleSearch='V1030021' AND a.supplierId=183) OR (a.articleSearch='340275' AND a.supplierId=6347)An internal server error occurred.