SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, 
                
                (SELECT ps_sub.id 
         FROM products.products_suppliers ps_sub 
         WHERE ps_sub.product_id = p.id 
           AND ps_sub.supplier_id IN (224,226,223,225,227) 
         LIMIT 1) AS 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            
              WHERE (a.articleSearch='CCF0040' AND a.supplierId=43) OR (a.articleSearch='ELR7094' AND a.supplierId=218) OR (a.articleSearch='C30158' AND a.supplierId=4814) OR (a.articleSearch='1635' AND a.supplierId=228) OR (a.articleSearch='1530711' AND a.supplierId=317) OR (a.articleSearch='MS6256' AND a.supplierId=180) OR (a.articleSearch='X10628' AND a.supplierId=4975) OR (a.articleSearch='55736' AND a.supplierId=4576) OR (a.articleSearch='180045410' AND a.supplierId=323) OR (a.articleSearch='LATR102' AND a.supplierId=4337) OR (a.articleSearch='HB800' AND a.supplierId=4280) OR ( a.articleSearch IN ('0082003193', '0082003386') AND a.supplierId=4995) OR (a.articleSearch='ADF122519' AND a.supplierId=350) OR (a.articleSearch='BFC1091' AND a.supplierId=475) OR (a.articleSearch='1987432192' AND a.supplierId=30) OR (a.articleSearch='BSG30145007' AND a.supplierId=4455) OR (a.articleSearch='NC2100' AND a.supplierId=163) OR ( a.articleSearch IN ('EAF160', 'EKF141') AND a.supplierId=421) OR (a.articleSearch='28000211872' AND a.supplierId=6513) OR (a.articleSearch='PC8098' AND a.supplierId=437) OR ( a.articleSearch IN ('21652360', '80000751') AND a.supplierId=140) OR (a.articleSearch='TSP0325140' AND a.supplierId=89) OR (a.articleSearch='M110133' AND a.supplierId=186) OR (a.articleSearch='DCF308P' AND a.supplierId=4760) OR (a.articleSearch='DP4161' AND a.supplierId=4396) OR (a.articleSearch='DCI0059' AND a.supplierId=253) OR (a.articleSearch='DP1110120159' AND a.supplierId=4948) OR (a.articleSearch='1372050' AND a.supplierId=355) OR (a.articleSearch='DCF118' AND a.supplierId=4881) OR (a.articleSearch='E146212' AND a.supplierId=4391) OR (a.articleSearch='FT37332' AND a.supplierId=4938) OR ( a.articleSearch IN ('19438', '48481') AND a.supplierId=101) OR (a.articleSearch='CF63' AND a.supplierId=4838) OR (a.articleSearch='HC7097' AND a.supplierId=4659) OR (a.articleSearch='K1113' AND a.supplierId=256) OR (a.articleSearch='101' AND a.supplierId=441) OR (a.articleSearch='AF26423' AND a.supplierId=4581) OR (a.articleSearch='CF9485' AND a.supplierId=6356) OR (a.articleSearch='14052041' AND a.supplierId=313) OR (a.articleSearch='E1901LI' AND a.supplierId=81) OR (a.articleSearch='SC5079' AND a.supplierId=6309) OR (a.articleSearch='17160' AND a.supplierId=341) OR (a.articleSearch='B4G015PR' AND a.supplierId=4689) OR (a.articleSearch='1528101200' AND a.supplierId=268) OR (a.articleSearch='AC0083' AND a.supplierId=4378) OR (a.articleSearch='F408801' AND a.supplierId=185) OR (a.articleSearch='LA118' AND a.supplierId=287) OR ( a.articleSearch IN ('50013892', '50013925') AND a.supplierId=432) OR (a.articleSearch='1732200' AND a.supplierId=4546) OR (a.articleSearch='LFCP299' AND a.supplierId=4973) OR (a.articleSearch='LAC1405C' AND a.supplierId=4600) OR (a.articleSearch='350203061720' AND a.supplierId=4723) OR (a.articleSearch='MMF025029' AND a.supplierId=4570) OR (a.articleSearch='CU3649' AND a.supplierId=4) OR (a.articleSearch='65606' AND a.supplierId=133) OR (a.articleSearch='3649IFPCSMS' AND a.supplierId=358) OR (a.articleSearch='260532' AND a.supplierId=403) OR (a.articleSearch='17160' AND a.supplierId=244) OR (a.articleSearch='7123190007' AND a.supplierId=144) OR (a.articleSearch='K9072' AND a.supplierId=462) OR (a.articleSearch='HB369' AND a.supplierId=4470) OR ( a.articleSearch IN ('AVF0907', 'AVF0907C') AND a.supplierId=6483) OR (a.articleSearch='VCF190' AND a.supplierId=4564) OR (a.articleSearch='FC158' AND a.supplierId=490) OR (a.articleSearch='DCF099P' AND a.supplierId=440) OR (a.articleSearch='CAF202401' AND a.supplierId=378) OR (a.articleSearch='FC01649' AND a.supplierId=129) OR (a.articleSearch='PF2121' AND a.supplierId=4558) OR (a.articleSearch='15202206' AND a.supplierId=4686) OR (a.articleSearch='AH224' AND a.supplierId=38) OR (a.articleSearch='PURPC4005' AND a.supplierId=6891) OR (a.articleSearch='QFC0081' AND a.supplierId=57) OR (a.articleSearch='424I0174' AND a.supplierId=6358) OR (a.articleSearch='CK0062' AND a.supplierId=4263) OR (a.articleSearch='SA1290' AND a.supplierId=225) OR (a.articleSearch='H3628' AND a.supplierId=6644) OR (a.articleSearch='101' AND a.supplierId=27) OR (a.articleSearch='P628' AND a.supplierId=4768) OR (a.articleSearch='S3058C' AND a.supplierId=142) OR (a.articleSearch='PC8809' AND a.supplierId=92) OR (a.articleSearch='SKIF0170174' AND a.supplierId=6357) OR (a.articleSearch='7110297SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('50919438', '50948481') AND a.supplierId=151) OR (a.articleSearch='CK9485' AND a.supplierId=4011) OR (a.articleSearch='E431' AND a.supplierId=91) OR (a.articleSearch='302360' AND a.supplierId=301) OR (a.articleSearch='5305800' AND a.supplierId=137) OR ( a.articleSearch IN ('698762', '716027') AND a.supplierId=21) OR (a.articleSearch='V253010011' AND a.supplierId=183) OR (a.articleSearch='17160' AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1215247', 'WG1226862', 'WG1233647', 'WG1430247', 'WG1747045', 'WG1774567', 'WG1793461', 'WG1795767') AND a.supplierId=4832) OR (a.articleSearch='WP9096' AND a.supplierId=324) OR ( a.articleSearch IN ('Z465', 'ZF465') AND a.supplierId=499) OR ( a.articleSearch IN ('IF3269', 'IF3269K') AND a.supplierId=4894)An internal server error occurred.