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 ('713043720') AND a.supplierId=192) OR ( a.articleSearch IN ('SMB24012') AND a.supplierId=271) OR ( a.articleSearch IN ('3776601', '3755401', '3776701') AND a.supplierId=35) OR ( a.articleSearch IN ('35870', '16030') AND a.supplierId=4683) OR ( a.articleSearch IN ('803052', '801050', '803053') AND a.supplierId=32) OR ( a.articleSearch IN ('803430', '803411') AND a.supplierId=135) OR ( a.articleSearch IN ('19160', '19163', '39008', '39009') AND a.supplierId=317) OR ( a.articleSearch IN ('79823') AND a.supplierId=4576) OR ( a.articleSearch IN ('SMA0138') AND a.supplierId=257) OR ( a.articleSearch IN ('D5151') AND a.supplierId=351) OR ( a.articleSearch IN ('110017110') AND a.supplierId=323) OR ( a.articleSearch IN ('0011019469', '0011025187', '0011025203', '0011029011', '0011029012') AND a.supplierId=4995) OR ( a.articleSearch IN ('047199B', '047200B', '047201B') AND a.supplierId=49) OR ( a.articleSearch IN ('SM2321', 'SM2335', 'SM2348') AND a.supplierId=478) OR ( a.articleSearch IN ('12231614', '12231638') AND a.supplierId=16) OR ( a.articleSearch IN ('50114', '59180', '59226', '59227', '6432') AND a.supplierId=208) OR ( a.articleSearch IN ('84147A', '84147L') AND a.supplierId=14) OR ( a.articleSearch IN ('BSM5381', 'BSM5386', 'BSM5410') AND a.supplierId=475) OR ( a.articleSearch IN ('BSG30700411') AND a.supplierId=4455) OR ( a.articleSearch IN ('081222', '081269', '752009', '752308') AND a.supplierId=405) OR ( a.articleSearch IN ('CTSM9079') AND a.supplierId=421) OR ( a.articleSearch IN ('80005432') AND a.supplierId=140) OR ( a.articleSearch IN ('D600168') AND a.supplierId=186) OR ( a.articleSearch IN ('7324595', '7325069', '7325083') AND a.supplierId=4135) OR ( a.articleSearch IN ('520150') AND a.supplierId=4512) OR ( a.articleSearch IN ('SS7890', 'SS8042') AND a.supplierId=267) OR ( a.articleSearch IN ('14449', '14512') AND a.supplierId=4834) OR ( a.articleSearch IN ('FBCA1', 'FDBCNGF', 'FDSICA2F', 'VLSSV70F') AND a.supplierId=4674) OR ( a.articleSearch IN ('173082', '31448', '38219', '38227', '38777', '38778', '38779', '38780') AND a.supplierId=101) OR ( a.articleSearch IN ('FSM5381', 'FSM5386', 'FSM5410') AND a.supplierId=407) OR ( a.articleSearch IN ('15412003S', '1556246S', '1556251S', '30407157S', '30407159S') AND a.supplierId=4727) OR ( a.articleSearch IN ('SRK0034') AND a.supplierId=6443) OR ( a.articleSearch IN ('518930', '518930K', '518930S', '519002', '532909S', '532301', '533763') AND a.supplierId=373) OR ( a.articleSearch IN ('200074', '590255', '590261', 'KS207', 'KS214') AND a.supplierId=239) OR ( a.articleSearch IN ('SM0138') AND a.supplierId=156) OR ( a.articleSearch IN ('SMJ0138') AND a.supplierId=481) OR ( a.articleSearch IN ('209166', '209199') AND a.supplierId=185) OR ( a.articleSearch IN ('850010943', '850010944', '850016930') AND a.supplierId=286) OR ( a.articleSearch IN ('21640Z') AND a.supplierId=387) OR ( a.articleSearch IN ('910128', '910170', '910171', 'SM1014', 'SM5676') AND a.supplierId=85) OR ( a.articleSearch IN ('MA1202LR', 'MA5027LR', 'PR7034', 'PR7114', 'PR7115') AND a.supplierId=4600) OR ( a.articleSearch IN ('A7G022MT', 'A7G032MT') AND a.supplierId=4427) OR ( a.articleSearch IN ('34655', '36621', '36625') AND a.supplierId=133) OR ( a.articleSearch IN ('722415', '722936', '722955', '723387', '724549', '725652') AND a.supplierId=403) OR ( a.articleSearch IN ('MRP2B03') AND a.supplierId=4773) OR ( a.articleSearch IN ('07018', '07019', '07020', '55458') AND a.supplierId=4664) OR ( a.articleSearch IN ('6490064', '6490080', '6490082') AND a.supplierId=94) OR ( a.articleSearch IN ('7146410009', '7146410009S') AND a.supplierId=144) OR ( a.articleSearch IN ('DB31069', 'DB31070', 'DB47157', 'DB47225') AND a.supplierId=6495) OR ( a.articleSearch IN ('137100201') AND a.supplierId=6376) OR ( a.articleSearch IN ('MK323', 'MK400') AND a.supplierId=4752) OR ( a.articleSearch IN ('FDSB16947', 'FDSB16948', 'FDSB16981') AND a.supplierId=134) OR ( a.articleSearch IN ('LVSM1068') AND a.supplierId=4564) OR ( a.articleSearch IN ('662502', '672525') AND a.supplierId=127) OR ( a.articleSearch IN ('ADFR002', 'ADFR026', 'ADVV001') AND a.supplierId=6355) OR ( a.articleSearch IN ('DCK504704', 'DCK505604', 'DCK505704', 'SMK300900') AND a.supplierId=378) OR ( a.articleSearch IN ('F87606', 'F87607', 'F87608') AND a.supplierId=129) OR ( a.articleSearch IN ('37054', '370542', '37055', '37056', '370562', '32647', '32649', '32648', '32650', '326482', '326502') AND a.supplierId=331) OR ( a.articleSearch IN ('PSE4247', 'PSE4250', 'PSE4480', 'PSE4488') AND a.supplierId=4558) OR ( a.articleSearch IN ('23140510', '23140544') AND a.supplierId=4686) OR ( a.articleSearch IN ('QF00V00006') AND a.supplierId=4339) OR ( a.articleSearch IN ('EMA6151', 'EMA6152', 'EMR6151', 'EMR6152', 'QAM169') AND a.supplierId=57) OR ( a.articleSearch IN ('R54158', 'R54234') AND a.supplierId=4303) OR ( a.articleSearch IN ('1180S0118') AND a.supplierId=6358) OR ( a.articleSearch IN ('VKD35036', 'VKD35036T', 'VKDA35430T') AND a.supplierId=50) OR ( a.articleSearch IN ('KB65230', 'M25214', 'M25212') AND a.supplierId=110) OR ( a.articleSearch IN ('410353', '413386') AND a.supplierId=6363) OR ( a.articleSearch IN ('T407018', 'T407019', 'T407020', 'T455458') AND a.supplierId=4667) OR ( a.articleSearch IN ('1198099SX', '1298140SX', '2617136SX', '5600723SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('33101616', '50931448', '50938219', '50938227', '55938777', '55938778', '55938779', '55938780') AND a.supplierId=151) OR ( a.articleSearch IN ('6302595', '6302612', '6309490') AND a.supplierId=4758) OR ( a.articleSearch IN ('KSU6341') AND a.supplierId=6312) OR ( a.articleSearch IN ('TED99455') AND a.supplierId=4593) OR ( a.articleSearch IN ('ASMVO1006') AND a.supplierId=4340) OR ( a.articleSearch IN ('304429', '304430') AND a.supplierId=301) OR ( a.articleSearch IN ('787115', '787311') AND a.supplierId=4970) OR ( a.articleSearch IN ('850010943', '850010944', '850016930') AND a.supplierId=108) OR ( a.articleSearch IN ('392440', '392440C') AND a.supplierId=4730) OR ( a.articleSearch IN ('V250523', 'V250667', 'V251142', 'V950341') AND a.supplierId=183) OR ( a.articleSearch IN ('44018', '44019', '44059', 'VE50114', 'VE6432') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG1795737') AND a.supplierId=4832) OR ( a.articleSearch IN ('GM2368', 'GM2435', 'SM3031S', 'SM3071S', 'SM3081S') AND a.supplierId=4894)An internal server error occurred.