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='ZD17212' AND a.supplierId=6412) OR ( a.articleSearch IN ('B14593', 'B11450', 'B11460') AND a.supplierId=4815) OR (a.articleSearch='DEA02004' AND a.supplierId=4760) OR ( a.articleSearch IN ('665012', '663120', '664012', '665143') AND a.supplierId=234) OR ( a.articleSearch IN ('33154', '104638', '30601') AND a.supplierId=101) OR ( a.articleSearch IN ('1196850500', '1126100100', '1196850400', '1199150100') AND a.supplierId=268) OR (a.articleSearch='342670' AND a.supplierId=6207) OR ( a.articleSearch IN ('ABR61000S', 'ABR109000S', 'AB8000P') AND a.supplierId=287) OR ( a.articleSearch IN ('1002360031', '1008800001') AND a.supplierId=144) OR (a.articleSearch='87022' AND a.supplierId=123) OR ( a.articleSearch IN ('34066', '342074', '342075') AND a.supplierId=205) OR ( a.articleSearch IN ('02424', '03063', '08080', '09205', '46923', '48072') AND a.supplierId=4683) OR ( a.articleSearch IN ('P150173', 'P330006') AND a.supplierId=4558) OR ( a.articleSearch IN ('30933154', '30104638', '30930601') AND a.supplierId=151) OR ( a.articleSearch IN ('98190703901', '88190795001') AND a.supplierId=4346) OR (a.articleSearch='0530220004' AND a.supplierId=4657) OR ( a.articleSearch IN ('160203', '160400') AND a.supplierId=4654) OR ( a.articleSearch IN ('402003', '402012') AND a.supplierId=422) OR ( a.articleSearch IN ('50610', '52475', '52552', '53105') AND a.supplierId=6558) OR ( a.articleSearch IN ('700005N', '740297N', '741902N', '730036N') AND a.supplierId=80) OR (a.articleSearch='10565379' AND a.supplierId=479) OR ( a.articleSearch IN ('33812', '77116', '77123') AND a.supplierId=4576) OR ( a.articleSearch IN ('GA15127', 'GA15707', 'GA20335') AND a.supplierId=4688) OR ( a.articleSearch IN ('150026910', '150035810', '150039710', '160061010') AND a.supplierId=323) OR (a.articleSearch='AI8378' AND a.supplierId=247) OR ( a.articleSearch IN ('0024002263', '0024003960', '0026011505', '0026014841') AND a.supplierId=4995) OR (a.articleSearch='1J1819021A' AND a.supplierId=6366) OR ( a.articleSearch IN ('CBW73032AS', 'CBW73032GS', 'CRS73000AS', 'CRS73019AS') AND a.supplierId=484) OR (a.articleSearch='7733001011V' AND a.supplierId=83) OR ( a.articleSearch IN ('CRP0140', 'CRV6027', 'CRV9056', 'CVH2069') AND a.supplierId=4334) OR (a.articleSearch='DY8051' AND a.supplierId=6742) OR (a.articleSearch='DCG1006' AND a.supplierId=253) OR (a.articleSearch='VRA001N' AND a.supplierId=4882) OR ( a.articleSearch IN ('EH1016', 'EH1067', 'XHR0017', 'XHR0068') AND a.supplierId=4344) OR ( a.articleSearch IN ('95SKV004', '95SKV033') AND a.supplierId=4969) OR ( a.articleSearch IN ('106027', '109056', '3240140', '92069') AND a.supplierId=441) OR ( a.articleSearch IN ('05991028', '3510045', '3510077') AND a.supplierId=313) OR (a.articleSearch='993761' AND a.supplierId=4379) OR ( a.articleSearch IN ('RE73102', 'RE73112') AND a.supplierId=6456) OR ( a.articleSearch IN ('347500009', '347500024', '347500025', '347504348') AND a.supplierId=4524) OR ( a.articleSearch IN ('261396', '261400') AND a.supplierId=4819) OR ( a.articleSearch IN ('5HL351321591', '8EW009100301', '9ML351332514') AND a.supplierId=4734) OR ( a.articleSearch IN ('75610065', '75614267', '75614910', '75898972') AND a.supplierId=72) OR ( a.articleSearch IN ('132529', '132562') AND a.supplierId=449) OR ( a.articleSearch IN ('H73240140', 'K106027', 'K109056', 'K92069') AND a.supplierId=341) OR (a.articleSearch='9900011' AND a.supplierId=4546) OR ( a.articleSearch IN ('106027', '109056', '92069') AND a.supplierId=4399) OR ( a.articleSearch IN ('LGK007081032', 'LGK026081000', 'LGK026081019', 'OEM007081032') AND a.supplierId=6012) OR (a.articleSearch='LFH18J0' AND a.supplierId=4707) OR (a.articleSearch='RF1209' AND a.supplierId=4600) OR ( a.articleSearch IN ('210180', '570083', '570087', 'AC155684') AND a.supplierId=403) OR ( a.articleSearch IN ('73240140', 'K106027', 'K109056', 'K92069') AND a.supplierId=244) OR ( a.articleSearch IN ('0917019', '0917032', '0917120', '0917171') AND a.supplierId=94) OR ( a.articleSearch IN ('ERDAU002', 'ERDAU003', 'EWNVW001') AND a.supplierId=6355) OR (a.articleSearch='AI8378' AND a.supplierId=340) OR (a.articleSearch='18600002' AND a.supplierId=4686) OR ( a.articleSearch IN ('QF00Q00045', 'QF10Q00023') AND a.supplierId=4339) OR (a.articleSearch='XRL314' AND a.supplierId=57) OR ( a.articleSearch IN ('40076000BN', '40076910BN', '40176230BN', '40176230OE') AND a.supplierId=6335) OR ( a.articleSearch IN ('1385C0013', '1385C0065', '1385C0120', '2669I0010') AND a.supplierId=6358) OR ( a.articleSearch IN ('SBW730320', 'SBW730321', 'SRS730000', 'SRS730190') AND a.supplierId=4592) OR ( a.articleSearch IN ('106027', '109056', '3240140', '92069') AND a.supplierId=27) OR ( a.articleSearch IN ('SKCU2150012', 'SKCU2150064', 'SKCU2150119', 'SKIB0310009') AND a.supplierId=6357) OR ( a.articleSearch IN ('2999035SX', '7552172SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('DDW004TT', 'DEW002TT', 'DEW008TT') AND a.supplierId=4466) OR ( a.articleSearch IN ('109826', '111035', '111036', '112195') AND a.supplierId=301) OR ( a.articleSearch IN ('0759003', '0759004') AND a.supplierId=209) OR (a.articleSearch='5370001' AND a.supplierId=61) OR ( a.articleSearch IN ('1J1819021C', '8D1907521', '99662410701') AND a.supplierId=4999) OR (a.articleSearch='698262' AND a.supplierId=21) OR (a.articleSearch='0330773' AND a.supplierId=36) OR ( a.articleSearch IN ('V10790006', 'V10790008', 'V15031879', 'V150318791', 'V15710036') AND a.supplierId=183) OR ( a.articleSearch IN ('240670130', 'K106027', 'K109056', 'K92069') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1379849', 'WG1445261', 'WG1500870', 'WG1735614', 'WG1778221', 'WG1897424', 'WG2016524', 'WG2031044', 'WG2160141', 'WG2160322', 'WG2160323') AND a.supplierId=4832) OR ( a.articleSearch IN ('350473', '351293', '352051') AND a.supplierId=6347) OR (a.articleSearch='ZVK162' AND a.supplierId=6274)An internal server error occurred.