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='CBVW8' AND a.supplierId=4553) OR (a.articleSearch='825036510' AND a.supplierId=192) OR (a.articleSearch='MSA025281' AND a.supplierId=4570) OR ( a.articleSearch IN ('1160100000', '1160500263HD') AND a.supplierId=144) OR ( a.articleSearch IN ('AUBJ15364', 'AUBJ13260') AND a.supplierId=134) OR (a.articleSearch='5044761' AND a.supplierId=127) OR ( a.articleSearch IN ('16232', '35644') AND a.supplierId=4683) OR ( a.articleSearch IN ('7576082', '7576068') AND a.supplierId=260) OR (a.articleSearch='37083' AND a.supplierId=135) OR (a.articleSearch='0731313' AND a.supplierId=209) OR (a.articleSearch='JBJ341' AND a.supplierId=4501) OR (a.articleSearch='220561' AND a.supplierId=206) OR ( a.articleSearch IN ('21737AP', '28166AP') AND a.supplierId=6400) OR (a.articleSearch='76913' AND a.supplierId=4576) OR (a.articleSearch='10AU2501' AND a.supplierId=4829) OR (a.articleSearch='290RT00722' AND a.supplierId=6271) OR (a.articleSearch='045645B' AND a.supplierId=49) OR (a.articleSearch='SJ0106' AND a.supplierId=478) OR ( a.articleSearch IN ('CX0165', 'CX9257') AND a.supplierId=208) OR (a.articleSearch='BBJ5648' AND a.supplierId=475) OR (a.articleSearch='BSG90310134' AND a.supplierId=4455) OR (a.articleSearch='49395958' AND a.supplierId=140) OR ( a.articleSearch IN ('505357', '505358') AND a.supplierId=6263) OR (a.articleSearch='CBJ19012' AND a.supplierId=4880) OR (a.articleSearch='TC2684' AND a.supplierId=89) OR ( a.articleSearch IN ('2722915', '2725368') AND a.supplierId=4135) OR (a.articleSearch='02BJ483' AND a.supplierId=4003) OR ( a.articleSearch IN ('SS9177', 'SS9822') AND a.supplierId=267) OR (a.articleSearch='2320Q5LOWF' AND a.supplierId=4674) OR ( a.articleSearch IN ('108900', '40930') AND a.supplierId=101) OR (a.articleSearch='FBJ5648' AND a.supplierId=407) OR (a.articleSearch='FL10674D' AND a.supplierId=236) OR ( a.articleSearch IN ('1103002', '1103003') AND a.supplierId=4727) OR ( a.articleSearch IN ('F4598', 'F5103') AND a.supplierId=486) OR ( a.articleSearch IN ('6624A', '6624AK') AND a.supplierId=6101) OR (a.articleSearch='S080987' AND a.supplierId=373) OR (a.articleSearch='1140304100' AND a.supplierId=268) OR (a.articleSearch='9040036' AND a.supplierId=185) OR ( a.articleSearch IN ('8500295018', '8500295135') AND a.supplierId=286) OR (a.articleSearch='4292201' AND a.supplierId=35) OR (a.articleSearch='301191617830' AND a.supplierId=4723) OR (a.articleSearch='54740' AND a.supplierId=133) OR ( a.articleSearch IN ('370041KITMS', '37004KITMS', '37089KITMS', '40930BPCSMS') AND a.supplierId=358) OR (a.articleSearch='723497' AND a.supplierId=403) OR (a.articleSearch='57029908' AND a.supplierId=94) OR (a.articleSearch='DB35236' AND a.supplierId=6495) OR (a.articleSearch='L29B35' AND a.supplierId=4752) OR (a.articleSearch='LVSJ1247' AND a.supplierId=4564) OR (a.articleSearch='0408083' AND a.supplierId=198) OR ( a.articleSearch IN ('7331', '7346', 'G307331', 'G307346') AND a.supplierId=6522) OR ( a.articleSearch IN ('G31039', 'G32015') AND a.supplierId=129) OR (a.articleSearch='PS3257' AND a.supplierId=4558) OR (a.articleSearch='QSJ3740S' AND a.supplierId=57) OR (a.articleSearch='RH030039' AND a.supplierId=6892) OR (a.articleSearch='2462S0351' AND a.supplierId=6358) OR (a.articleSearch='BJA674' AND a.supplierId=6698) OR (a.articleSearch='9395952' AND a.supplierId=430) OR (a.articleSearch='925700' AND a.supplierId=23) OR (a.articleSearch='VKDS311027' AND a.supplierId=50) OR (a.articleSearch='51290' AND a.supplierId=6363) OR (a.articleSearch='5200278SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('30108900', '30940930') AND a.supplierId=151) OR ( a.articleSearch IN ('4706080', '4710719') AND a.supplierId=4758) OR (a.articleSearch='A674' AND a.supplierId=4414) OR (a.articleSearch='114357' AND a.supplierId=301) OR ( a.articleSearch IN ('8500295018', '8500295135') AND a.supplierId=108) OR (a.articleSearch='V105338' AND a.supplierId=183) OR (a.articleSearch='27551' AND a.supplierId=4425) OR ( a.articleSearch IN ('WG2029980', 'WG2031482') AND a.supplierId=4832) OR (a.articleSearch='TG5414' AND a.supplierId=4894)An internal server error occurred.