SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM article a
              /*LEFT JOIN supplier s ON s.supplierId=a.supplierId*/
              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 p.id=ps.product_id AND ps.supplier_id IN (223)
              WHERE ( a.articleSearch IN ('7111287SX', '7111296SX', '7111299SX') AND a.supplierId=4595) OR a.articleSearch='40758' AND a.supplierId=4598) OR ( a.articleSearch IN ('17732', '177332') AND a.supplierId=317) OR ( a.articleSearch IN ('110047110', '130062910', '130063610') AND a.supplierId=323) OR ( a.articleSearch IN ('0011019301', '0011027317') AND a.supplierId=4995) OR ( a.articleSearch IN ('046313B', '047676B') AND a.supplierId=49) OR ( a.articleSearch IN ('MT9599', 'MT9671') AND a.supplierId=478) OR ( a.articleSearch IN ('50477', '50638', '51021') AND a.supplierId=208) OR ( a.articleSearch IN ('87756A', '88451A', '88509A') AND a.supplierId=14) OR ( a.articleSearch IN ('BEM3176', 'BEM4072') AND a.supplierId=475) OR ( a.articleSearch IN ('BSG90700257', 'BSG90700270') AND a.supplierId=4455) OR ( a.articleSearch IN ('461034', '461147') AND a.supplierId=405) OR ( a.articleSearch IN ('21652660', '80000246') AND a.supplierId=140) OR a.articleSearch='503519' AND a.supplierId=6263) OR a.articleSearch='7222097' AND a.supplierId=4135) OR ( a.articleSearch IN ('2697', '5140') AND a.supplierId=4834) OR ( a.articleSearch IN ('31980', '39587') AND a.supplierId=101) OR ( a.articleSearch IN ('FEM3176', 'FEM4072') AND a.supplierId=407) OR a.articleSearch='FL4464J' AND a.supplierId=236) OR ( a.articleSearch IN ('FZ90489', 'FZ90978') AND a.supplierId=4467) OR a.articleSearch='EM0577' AND a.supplierId=6443) OR ( a.articleSearch IN ('510265', '512763') AND a.supplierId=373) OR a.articleSearch='710001173' AND a.supplierId=4524) OR a.articleSearch='594458' AND a.supplierId=239) OR a.articleSearch='YF33028' AND a.supplierId=6786) OR a.articleSearch='1132408400' AND a.supplierId=268) OR ( a.articleSearch IN ('1480060', '1490670') AND a.supplierId=4546) OR ( a.articleSearch IN ('1770301', '2586502', '2587401', '2998701', '3110501', '17703', '25865', '25874', '29987', '2996501', '2998401', '2998501', '2999001', '31105') AND a.supplierId=35) OR ( a.articleSearch IN ('ME1279', 'ME1894') AND a.supplierId=4600) OR ( a.articleSearch IN ('36879', '38810') AND a.supplierId=133) OR ( a.articleSearch IN ('400170', '400287') AND a.supplierId=403) OR ( a.articleSearch IN ('04303', '05887') AND a.supplierId=4664) OR ( a.articleSearch IN ('1001300011', '1003990028') AND a.supplierId=144) OR a.articleSearch='59747069' AND a.supplierId=127) OR ( a.articleSearch IN ('F85575', 'F87971') AND a.supplierId=129) OR ( a.articleSearch IN ('1725', '35043', '37249', '35160') AND a.supplierId=331) OR ( a.articleSearch IN ('07597', '12075', '34439') AND a.supplierId=4683) OR ( a.articleSearch IN ('PSE3089', 'PSE3909') AND a.supplierId=4558) OR ( a.articleSearch IN ('10150500', '10150575') AND a.supplierId=4686) OR a.articleSearch='EM4604' AND a.supplierId=57) OR ( a.articleSearch IN ('RH120016', 'RH120025') AND a.supplierId=6892) OR ( a.articleSearch IN ('2706124', '9001964') AND a.supplierId=260) OR ( a.articleSearch IN ('T404303', 'T405887') AND a.supplierId=4667) OR ( a.articleSearch IN ('30931980', '30939587') AND a.supplierId=151) OR a.articleSearch='6206599' AND a.supplierId=4758) OR ( a.articleSearch IN ('108906', '111901') AND a.supplierId=301) OR a.articleSearch='783834' AND a.supplierId=4970) OR a.articleSearch='396834' AND a.supplierId=4730) OR ( a.articleSearch IN ('V100269', 'V101564', 'V101628') AND a.supplierId=183) OR ( a.articleSearch IN ('VE50477', 'VE51021') AND a.supplierId=4425) OR ( a.articleSearch IN ('33990030301', '43991698201') AND a.supplierId=4346) OR ( a.articleSearch IN ('WG1392365', 'WG1392582', 'WG1755190', 'WG2031416') AND a.supplierId=4832)An internal server error occurred.