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='SB2274' AND a.supplierId=225) OR ( a.articleSearch IN ('00561000', '01202200') AND a.supplierId=139) OR ( a.articleSearch IN ('70286', '32863', '32875') AND a.supplierId=4576) OR (a.articleSearch='180034410' AND a.supplierId=323) OR ( a.articleSearch IN ('F026400059', 'F026400370') AND a.supplierId=30) OR ( a.articleSearch IN ('BSG25135001', 'BSG70135003', 'BSG25535006') AND a.supplierId=4455) OR ( a.articleSearch IN ('CAF100449C', 'V449606') AND a.supplierId=43) OR ( a.articleSearch IN ('MA1397', 'MA1367') AND a.supplierId=163) OR ( a.articleSearch IN ('346270', '419150') AND a.supplierId=10) OR ( a.articleSearch IN ('1611158280', '1616267180') AND a.supplierId=4391) OR ( a.articleSearch IN ('FT37116', 'FT55516', 'FT37703', 'FT61783', 'FT61788', 'FT61789', 'FT38076', 'FT55524', 'FT61786') AND a.supplierId=4938) OR (a.articleSearch='FAI201' AND a.supplierId=271) OR ( a.articleSearch IN ('AR3161', 'AR3162') AND a.supplierId=256) OR (a.articleSearch='AF948' AND a.supplierId=4741) OR ( a.articleSearch IN ('CA10414', 'CA10415') AND a.supplierId=6356) OR (a.articleSearch='AG280' AND a.supplierId=4663) OR ( a.articleSearch IN ('E1260L', 'E839L') AND a.supplierId=81) OR (a.articleSearch='FA0222JM' AND a.supplierId=156) OR (a.articleSearch='A0471' AND a.supplierId=4378) OR (a.articleSearch='343210' AND a.supplierId=6207) OR ( a.articleSearch IN ('LX2059', 'CI158000P', 'LX3353', 'CI148000P', 'CI217000P') AND a.supplierId=287) OR ( a.articleSearch IN ('50014154', '50014725') AND a.supplierId=432) OR (a.articleSearch='LA1926' AND a.supplierId=4600) OR ( a.articleSearch IN ('351319204230', '153071760187', '153071760193', '351319203993') AND a.supplierId=4723) OR (a.articleSearch='MMF015075' AND a.supplierId=4570) OR ( a.articleSearch IN ('C17237', 'C172371', 'LC9005') AND a.supplierId=4) OR (a.articleSearch='60927' AND a.supplierId=133) OR ( a.articleSearch IN ('EL9160', 'EL9222') AND a.supplierId=218) OR ( a.articleSearch IN ('2123210020', '2123210021') AND a.supplierId=144) OR ( a.articleSearch IN ('A843', 'A8431') AND a.supplierId=462) OR ( a.articleSearch IN ('961479', '96623') AND a.supplierId=123) OR ( a.articleSearch IN ('30798', '309033', '309034') AND a.supplierId=205) OR (a.articleSearch='A22340' AND a.supplierId=6405) OR ( a.articleSearch IN ('7101061SX', '1040174SX', '7101976SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('2762800', '2768900', '27A6900') AND a.supplierId=137) OR (a.articleSearch='LF1244' AND a.supplierId=4894) OR ( a.articleSearch IN ('A63190', 'A63206') AND a.supplierId=4814) OR (a.articleSearch='0160180003' AND a.supplierId=4657) OR ( a.articleSearch IN ('706044', '709044', '709069') AND a.supplierId=422) OR (a.articleSearch='56706' AND a.supplierId=6558) OR ( a.articleSearch IN ('1500009', '1500605', '153171A', '15322SIL', '15323') AND a.supplierId=317) OR (a.articleSearch='MD5274' AND a.supplierId=180) OR (a.articleSearch='X1522449' AND a.supplierId=4975) OR (a.articleSearch='FA0222JM' AND a.supplierId=257) OR (a.articleSearch='PAL22020' AND a.supplierId=442) OR ( a.articleSearch IN ('101575', '91219') AND a.supplierId=4495) OR (a.articleSearch='105141' AND a.supplierId=4688) OR ( a.articleSearch IN ('SC03', 'TBG555') AND a.supplierId=6362) OR (a.articleSearch='LAT289' AND a.supplierId=4337) OR ( a.articleSearch IN ('FT4360', 'FT4482', 'FTA4360') AND a.supplierId=247) OR ( a.articleSearch IN ('LA077', 'R628') AND a.supplierId=4280) OR (a.articleSearch='0011023651' AND a.supplierId=4995) OR ( a.articleSearch IN ('700511', '700718') AND a.supplierId=128) OR (a.articleSearch='AG0455' AND a.supplierId=478) OR ( a.articleSearch IN ('ADBP220056', 'ADL142213', 'ADP152233') AND a.supplierId=350) OR ( a.articleSearch IN ('BFA2058', 'BFA2466') AND a.supplierId=475) OR (a.articleSearch='118530' AND a.supplierId=6444) OR (a.articleSearch='BS01288' AND a.supplierId=4702) OR ( a.articleSearch IN ('L980223', 'L980228') AND a.supplierId=177) OR ( a.articleSearch IN ('81692', '82108', '82109', '82110', '82151') AND a.supplierId=157) OR ( a.articleSearch IN ('EAF646', 'EAF718') AND a.supplierId=421) OR ( a.articleSearch IN ('28000200062', '28000204662') AND a.supplierId=6513) OR ( a.articleSearch IN ('FL9132', 'FL9133') AND a.supplierId=437) OR ( a.articleSearch IN ('423376H', '450362P') AND a.supplierId=140) OR (a.articleSearch='DFA0605' AND a.supplierId=6479) OR ( a.articleSearch IN ('A141206', 'A141704') AND a.supplierId=186) OR ( a.articleSearch IN ('DA2052', 'DA2955') AND a.supplierId=4396) OR ( a.articleSearch IN ('8348409', '8348412', 'DCA1041', 'DCA1138') AND a.supplierId=253) OR (a.articleSearch='KLR007HELN' AND a.supplierId=4882) OR (a.articleSearch='1110010078' AND a.supplierId=4345) OR ( a.articleSearch IN ('DP1110100028', 'DP1110100747') AND a.supplierId=4948) OR ( a.articleSearch IN ('1222000', '1222001', '1279504', '717021', '753608', '753614') AND a.supplierId=355) OR ( a.articleSearch IN ('DAF2059', 'DAF3353') AND a.supplierId=4881) OR ( a.articleSearch IN ('24SKV976', '24SKV977', '24SKV981', '43SKV182') AND a.supplierId=4969) OR ( a.articleSearch IN ('421505', '454501', '475505') AND a.supplierId=367) OR ( a.articleSearch IN ('15961', '15962', '15963', '15973') AND a.supplierId=4834) OR ( a.articleSearch IN ('170201', '175200', '40208') AND a.supplierId=101) OR (a.articleSearch='FA2080' AND a.supplierId=4838) OR (a.articleSearch='HPU4422' AND a.supplierId=4659) OR (a.articleSearch='AR04112' AND a.supplierId=313) OR ( a.articleSearch IN ('090490', '090491') AND a.supplierId=6665) OR ( a.articleSearch IN ('8ML376733521', '8ML376746021', '8ML376747381') AND a.supplierId=4734) OR ( a.articleSearch IN ('5115895N', '5115895R', '5116102N', '5116102R') AND a.supplierId=6349) OR (a.articleSearch='J1320836' AND a.supplierId=72) OR ( a.articleSearch IN ('SA7077', 'SA7081', 'SAO7084') AND a.supplierId=6309) OR ( a.articleSearch IN ('18525', 'FKFIA164', 'FKFIA165', 'FKFIA166', 'FKFIA167', 'FKFIA168', 'FKFIA169', 'FKFIA170', 'FKFIA171', 'FKFIA172', 'FKFIA173', 'FKFIA174', 'FKPSA002') AND a.supplierId=341) OR (a.articleSearch='FA0222JM' AND a.supplierId=481) OR (a.articleSearch='B2F070PR' AND a.supplierId=4689) OR ( a.articleSearch IN ('811M21A', 'M811121A', 'M811150A') AND a.supplierId=296) OR ( a.articleSearch IN ('F236301', 'F252301') AND a.supplierId=185) OR ( a.articleSearch IN ('FA180Z', 'FA358Z') AND a.supplierId=387) OR (a.articleSearch='2097304360' AND a.supplierId=78) OR ( a.articleSearch IN ('1559826', '1716080', '1716150') AND a.supplierId=4546) OR (a.articleSearch='LFAF289' AND a.supplierId=4973) OR (a.articleSearch='LRIC1680' AND a.supplierId=4707) OR (a.articleSearch='17237LFPCSMS' AND a.supplierId=358) OR ( a.articleSearch IN ('260194', '261415', '680214', 'AC659843') AND a.supplierId=403) OR ( a.articleSearch IN ('18525', 'FKFIA164', 'FKFIA165', 'FKFIA166', 'FKFIA167', 'FKFIA168', 'FKFIA169', 'FKFIA170', 'FKFIA171', 'FKFIA172', 'FKFIA173', 'FKFIA174', 'FKPSA002') AND a.supplierId=244) OR (a.articleSearch='AFAU048' AND a.supplierId=6495) OR ( a.articleSearch IN ('R449', 'R449A') AND a.supplierId=4470) OR (a.articleSearch='801003830' AND a.supplierId=6376) OR (a.articleSearch='VFA1154' AND a.supplierId=4564) OR ( a.articleSearch IN ('PA3190', 'PA3206') AND a.supplierId=490) OR (a.articleSearch='EPCVFT000' AND a.supplierId=6355) OR ( a.articleSearch IN ('2133047', '2133049') AND a.supplierId=4380) OR ( a.articleSearch IN ('EAF305720', 'EAF368220') AND a.supplierId=378) OR (a.articleSearch='FA01136' AND a.supplierId=129) OR ( a.articleSearch IN ('16247', '18328', '19229', '225449', '225450', '225451') AND a.supplierId=331) OR ( a.articleSearch IN ('PF1283', 'PF1334') AND a.supplierId=4558) OR ( a.articleSearch IN ('CI954N001', 'FT4360', 'FT4482', 'FTA4360') AND a.supplierId=340) OR (a.articleSearch='15122660' AND a.supplierId=4686) OR ( a.articleSearch IN ('A1276', 'A1277') AND a.supplierId=38) OR (a.articleSearch='PURHA0151' AND a.supplierId=6891) OR (a.articleSearch='QF36A00138' AND a.supplierId=4339) OR ( a.articleSearch IN ('QFA0254', 'QFA1113') AND a.supplierId=57) OR ( a.articleSearch IN ('R11660', 'R11665', 'R11666') AND a.supplierId=4303) OR (a.articleSearch='8A0099' AND a.supplierId=6358) OR ( a.articleSearch IN ('062459', '065049') AND a.supplierId=4623) OR (a.articleSearch='CH0115' AND a.supplierId=4263) OR ( a.articleSearch IN ('3330057', '3330058', '3336354') AND a.supplierId=260) OR ( a.articleSearch IN ('981744', '981745', '981766') AND a.supplierId=263) OR (a.articleSearch='1M119' AND a.supplierId=6644) OR (a.articleSearch='S10119' AND a.supplierId=4768) OR ( a.articleSearch IN ('S7628A', 'S7689A', 'S7A69A') AND a.supplierId=142) OR (a.articleSearch='FL3913' AND a.supplierId=92) OR (a.articleSearch='SKAF0060099' AND a.supplierId=6357) OR (a.articleSearch='18300' AND a.supplierId=6691) OR (a.articleSearch='70940208' AND a.supplierId=151) OR ( a.articleSearch IN ('776015', '776118') AND a.supplierId=6312) OR ( a.articleSearch IN ('AR13490I', 'AR13490S', 'OL3006E') AND a.supplierId=4011) OR ( a.articleSearch IN ('A2241', 'A2242') AND a.supplierId=91) OR ( a.articleSearch IN ('DAC007TT', 'DAF007TT', 'DCC039TT', 'DCF074TT', 'DCF088TT', 'DCF089TT') AND a.supplierId=4466) OR (a.articleSearch='720967' AND a.supplierId=301) OR (a.articleSearch='521067' AND a.supplierId=4970) OR ( a.articleSearch IN ('35811', '35812', '35813') AND a.supplierId=6311) OR ( a.articleSearch IN ('S3396', 'S3398', 'S3399') AND a.supplierId=4730) OR ( a.articleSearch IN ('V220367', 'V240031', 'V240740', 'V241173', 'V24600055') AND a.supplierId=183) OR ( a.articleSearch IN ('585694', '585695', '818569') AND a.supplierId=21) OR ( a.articleSearch IN ('18525', 'FKFIA164', 'FKFIA165', 'FKFIA166', 'FKFIA167', 'FKFIA168', 'FKFIA169', 'FKFIA170', 'FKFIA171', 'FKFIA172', 'FKFIA173', 'FKFIA174', 'FKPSA002') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1019000', 'WG1216181', 'WG1230092', 'WG1380166', 'WG1426390', 'WG1431715', 'WG1448734', 'WG1726421', 'WG1747552', 'WG1792505', 'WG1792506', 'WG1906564', 'WG1906565', 'WG1906566', 'WG1906567', 'WG1906568', 'WG1906569', 'WG1906570', 'WG1906571', 'WG1906572', 'WG1906573', 'WG1965617', 'WG1966282') AND a.supplierId=4832) OR ( a.articleSearch IN ('WA9523', 'WA9741') AND a.supplierId=324)An internal server error occurred.