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 ('74117', '30472') AND a.supplierId=4576) OR ( a.articleSearch IN ('0986221023', '0986221001', '098622A000') AND a.supplierId=30) OR ( a.articleSearch IN ('2011340', '20117', '20111', '20322') AND a.supplierId=47) OR ( a.articleSearch IN ('BSG90835002') AND a.supplierId=4455) OR ( a.articleSearch IN ('CE2003012B1', 'GN10245', 'GN1024512B1', 'GN1033712B1', 'GN1024511B1') AND a.supplierId=89) OR ( a.articleSearch IN ('880006', '880006A', '880009', '880009A', '880124', '880124A') AND a.supplierId=234) OR ( a.articleSearch IN ('22038', '106148') AND a.supplierId=101) OR ( a.articleSearch IN ('IC16027', 'IC16034') AND a.supplierId=271) OR ( a.articleSearch IN ('150509', '150505', '150613') AND a.supplierId=4819) OR ( a.articleSearch IN ('5DA193175501', '5DA193175681', '5DA230035601', '5DA358000411', '5DA749475781') AND a.supplierId=4734) OR ( a.articleSearch IN ('2503807', '133807', '133860', '2503860') AND a.supplierId=449) OR ( a.articleSearch IN ('060717062012', '060717035012', '060717220012', '060801016010', '060810070010', '060810189010', '060810253010') AND a.supplierId=4723) OR ( a.articleSearch IN ('MMI030008', 'MMI030022', 'MMI030188', 'MMI030238') AND a.supplierId=4570) OR ( a.articleSearch IN ('10478', '10478E', '10300', '10300E', '10329', '10423', '10487', '10487E', '10519') AND a.supplierId=244) OR ( a.articleSearch IN ('1008850040', '36148850005') AND a.supplierId=144) OR ( a.articleSearch IN ('AL08021', 'AL08031') AND a.supplierId=6495) OR ( a.articleSearch IN ('48003', '48002', '48139') AND a.supplierId=15) OR ( a.articleSearch IN ('00408', '08066') AND a.supplierId=4683) OR ( a.articleSearch IN ('18109015', '18109009') AND a.supplierId=4686) OR ( a.articleSearch IN ('SC1814', 'SC1415', 'STC0902') AND a.supplierId=4771) OR ( a.articleSearch IN ('245141', '245250') AND a.supplierId=21) OR ( a.articleSearch IN ('99050038401', '99051785801') AND a.supplierId=4346) OR ( a.articleSearch IN ('IGC207A') AND a.supplierId=6354) OR ( a.articleSearch IN ('ZSE030', 'ZS052', 'ZS552', 'ZSE081') AND a.supplierId=6444) OR ( a.articleSearch IN ('12201001', '12201057', '12201075') AND a.supplierId=4657) OR ( a.articleSearch IN ('19374104', '19375338') AND a.supplierId=6307) OR ( a.articleSearch IN ('51198') AND a.supplierId=6558) OR ( a.articleSearch IN ('XE9009', 'XE9009B', 'XE9015A', 'XE9120B1') AND a.supplierId=4975) OR ( a.articleSearch IN ('7801100', '7801109') AND a.supplierId=257) OR ( a.articleSearch IN ('PAL150001') AND a.supplierId=442) OR ( a.articleSearch IN ('150031210') AND a.supplierId=323) OR ( a.articleSearch IN ('0011025488') AND a.supplierId=4995) OR ( a.articleSearch IN ('IC03101', 'IC15100', 'IC16112') AND a.supplierId=194) OR ( a.articleSearch IN ('ADN11480', 'ADV181401C') AND a.supplierId=350) OR ( a.articleSearch IN ('B18973') AND a.supplierId=4815) OR ( a.articleSearch IN ('111003', '111003E', '114010', '114010E', '126008', '126008E') AND a.supplierId=452) OR ( a.articleSearch IN ('224486N015') AND a.supplierId=6366) OR ( a.articleSearch IN ('BAE408AE245', 'BAE409A245', 'BAEA081E') AND a.supplierId=43) OR ( a.articleSearch IN ('2910000408000', 'A2C59506746') AND a.supplierId=6513) OR ( a.articleSearch IN ('CBE5058', 'CBE5058C', 'CBE5088', 'CBE5164', 'CBE5165', 'CBE5188', 'CBE5214') AND a.supplierId=4334) OR ( a.articleSearch IN ('E100001', 'E100004', 'E100046') AND a.supplierId=186) OR ( a.articleSearch IN ('DG2070', 'DG2092', 'DG2094') AND a.supplierId=4396) OR ( a.articleSearch IN ('BBA010DLPN', 'BBA080DLPN', 'BBA080MRLN') AND a.supplierId=4882) OR ( a.articleSearch IN ('DIC022', 'DIC107') AND a.supplierId=4881) OR ( a.articleSearch IN ('155092', '156200', '156200P', '157400', '157400P') AND a.supplierId=211) OR ( a.articleSearch IN ('EE5000', 'EE5002', 'EE5058', 'QL1000', 'QL1001', 'QL1043', 'XIG5001', 'XIG5002', 'XIG5040') AND a.supplierId=4344) OR ( a.articleSearch IN ('1970474', '1970557', '96374', '96457') AND a.supplierId=4005) OR ( a.articleSearch IN ('03SKV025', '03SKV129') AND a.supplierId=4969) OR ( a.articleSearch IN ('DC1044', 'DC1075', 'DC1155') AND a.supplierId=411) OR ( a.articleSearch IN ('80201', '80203', '80370') AND a.supplierId=240) OR ( a.articleSearch IN ('NCP006') AND a.supplierId=4674) OR ( a.articleSearch IN ('8530164', '8530164A2', '8530165', '8530165A2', '8530214', '8530214A2') AND a.supplierId=441) OR ( a.articleSearch IN ('GC4131', 'GC4132', 'GC4715') AND a.supplierId=4933) OR ( a.articleSearch IN ('945081', '945089', '945161', '945681') AND a.supplierId=4379) OR ( a.articleSearch IN ('100000004', '100000017') AND a.supplierId=4524) OR ( a.articleSearch IN ('19050004', 'J5371003') AND a.supplierId=72) OR ( a.articleSearch IN ('8010300', '8010300E', '8010329', '8010478', '8010478E', '8010487', '8010487E', '8010519') AND a.supplierId=341) OR ( a.articleSearch IN ('12727', '12798') AND a.supplierId=269) OR ( a.articleSearch IN ('BOUF351', 'BOUF691') AND a.supplierId=6387) OR ( a.articleSearch IN ('JM5008', 'JM5011', 'JM5048', 'JM5445') AND a.supplierId=397) OR ( a.articleSearch IN ('BO100', 'BO109') AND a.supplierId=156) OR ( a.articleSearch IN ('78100', '78109') AND a.supplierId=481) OR ( a.articleSearch IN ('1191600100', '1291601000', '4091600100', '4091600300') AND a.supplierId=268) OR ( a.articleSearch IN ('ICC6502', 'ICC6503', 'ICC6508') AND a.supplierId=201) OR ( a.articleSearch IN ('45003Z', '45026Z') AND a.supplierId=387) OR ( a.articleSearch IN ('9040070', '9044022') AND a.supplierId=4546) OR ( a.articleSearch IN ('470474', '470557') AND a.supplierId=4006) OR ( a.articleSearch IN ('CP003', 'CP300') AND a.supplierId=6518) OR ( a.articleSearch IN ('BOBEN001') AND a.supplierId=292) OR ( a.articleSearch IN ('DMB807', 'DMB919') AND a.supplierId=4501) OR ( a.articleSearch IN ('SPL1002', 'SPL1038') AND a.supplierId=4600) OR ( a.articleSearch IN ('80405', '80532', '80886') AND a.supplierId=133) OR ( a.articleSearch IN ('MIC0003', 'MIC209') AND a.supplierId=6270) OR ( a.articleSearch IN ('130063', '130207') AND a.supplierId=403) OR ( a.articleSearch IN ('EPS1970474', 'EPS1970557', 'MCI9109') AND a.supplierId=4773) OR ( a.articleSearch IN ('0880097', '0880101', '0880200') AND a.supplierId=94) OR ( a.articleSearch IN ('CE235', 'CE28', 'CE51', 'CN14') AND a.supplierId=4705) OR ( a.articleSearch IN ('LVCL802', 'VCL870') AND a.supplierId=4564) OR ( a.articleSearch IN ('1IC174', '1IC817') AND a.supplierId=388) OR ( a.articleSearch IN ('N5361014', 'N5361025') AND a.supplierId=248) OR ( a.articleSearch IN ('N536N07', 'N536N17') AND a.supplierId=440) OR ( a.articleSearch IN ('ECZNS010', 'ECZRE005', 'ECZRE005A', 'ECZVW000') AND a.supplierId=6355) OR ( a.articleSearch IN ('PCI1001', 'PCI1001KOR', 'PCI1019', 'PCI1019KOR', 'PCI1046', 'PCI1046KOR') AND a.supplierId=4558) OR ( a.articleSearch IN ('QF09A00006', 'QF09A00073', 'QF09A00078') AND a.supplierId=4339) OR ( a.articleSearch IN ('XIC8200', 'XIC8250') AND a.supplierId=57) OR ( a.articleSearch IN ('689C0002', '689C0003', '689C0062') AND a.supplierId=6358) OR ( a.articleSearch IN ('9204017', '9206005', '9206050') AND a.supplierId=260) OR ( a.articleSearch IN ('E701133') AND a.supplierId=6377) OR ( a.articleSearch IN ('8530164', '8530164A2', '8530165', '8530165A2', '8530214', '8530214A2') AND a.supplierId=27) OR ( a.articleSearch IN ('SKCO0070001', 'SKCO0070002', 'SKCO0070062') AND a.supplierId=6357) OR ( a.articleSearch IN ('6100001SX', '6100003SX', '6100145SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('880006') AND a.supplierId=6691) OR ( a.articleSearch IN ('30922038', '82106148') AND a.supplierId=151) OR ( a.articleSearch IN ('CL003', 'CL100', 'CL511', 'CP049') AND a.supplierId=356) OR ( a.articleSearch IN ('109039', '207022') AND a.supplierId=301) OR ( a.articleSearch IN ('886014010', '886025004', '886029024') AND a.supplierId=108) OR ( a.articleSearch IN ('0717020') AND a.supplierId=209) OR ( a.articleSearch IN ('021905106', '058905105') AND a.supplierId=4999) OR ( a.articleSearch IN ('V10700012', 'V38700007', 'V46700001') AND a.supplierId=183) OR ( a.articleSearch IN ('CUF042A', 'CUF351', 'CUF042OE') AND a.supplierId=4627) OR ( a.articleSearch IN ('9212049', '9212114') AND a.supplierId=303) OR ( a.articleSearch IN ('220830001', '220830159', '220830221', '220830235', '220830544', '220830635', '220830636', '220830716') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1012132', 'WG1012305', 'WG1012314', 'WG1032010', 'WG1054499', 'WG1094201', 'WG1142988', 'WG1443910', 'WG1446141', 'WG1487292', 'WG1487525', 'WG1487541', 'WG1487580', 'WG1496464', 'WG1496467', 'WG1496632', 'WG1496633', 'WG1498173', 'WG1498875', 'WG1899334', 'WG1899336', 'WG1945870', 'WG1965337', 'WG2017357', 'WG2152368') AND a.supplierId=4832) OR ( a.articleSearch IN ('30129', '30374', '350431', '350733') AND a.supplierId=6347)An internal server error occurred.