SELECT DISTINCT m.manufacturerName AS cross_brand, ao.manufacturerId, ao.oemSearch, ao.oemnumber, ps.id AS supplier_product_id, ps.supplier_id AS real_supplier_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 IN ('11767AP', '13019AP', '14572AP') AND a.supplierId=6400) OR (a.articleSearch='SLKE050' AND a.supplierId=4010) OR ( a.articleSearch IN ('70622', '32294', '74913', '74974', '76738') AND a.supplierId=4576) OR ( a.articleSearch IN ('110061610', '110061510', '110159310') AND a.supplierId=323) OR ( a.articleSearch IN ('LS9504', 'LS9601', 'LS9605') AND a.supplierId=478) OR ( a.articleSearch IN ('BSG90310042', 'BSG65310016', 'BSG90310062') AND a.supplierId=4455) OR ( a.articleSearch IN ('49398518', '49398949', '49399630') AND a.supplierId=140) OR ( a.articleSearch IN ('TC1081', 'TC1082', 'TC1375') AND a.supplierId=89) OR ( a.articleSearch IN ('818019810', '818019610', '818034410') AND a.supplierId=192) OR ( a.articleSearch IN ('LS12004', 'LS22003') AND a.supplierId=271) OR ( a.articleSearch IN ('2104402', '3199801', '2104401', '3199301', '21044') AND a.supplierId=35) OR ( a.articleSearch IN ('C7042LR', 'C7043LR', 'C7257LR') AND a.supplierId=4600) OR ( a.articleSearch IN ('MSC015562', 'MSC015556', 'MSC015577') AND a.supplierId=4570) OR ( a.articleSearch IN ('49851', '49863', '59794') AND a.supplierId=133) OR ( a.articleSearch IN ('1160600010', '1160600102', '1004110023', '6160600005') AND a.supplierId=144) OR ( a.articleSearch IN ('DB78162', 'DB78197') AND a.supplierId=6495) OR ( a.articleSearch IN ('L29618', 'L24609', 'L29619') AND a.supplierId=4752) OR ( a.articleSearch IN ('VOLS1087', 'OPLS2821', 'VOLS1089') AND a.supplierId=134) OR ( a.articleSearch IN ('5114701', '5114734', '5113612') AND a.supplierId=127) OR ( a.articleSearch IN ('PS4048', 'PS4281') AND a.supplierId=4558) OR ( a.articleSearch IN ('9790956', '9790993', '9700330') AND a.supplierId=430) OR ( a.articleSearch IN ('2306002', '2306051', '2306189') AND a.supplierId=260) OR ( a.articleSearch IN ('63561', '64468', '9063') AND a.supplierId=135) OR ( a.articleSearch IN ('5600656ASX', '5600656SX', '5503461ASX', '5503461SX', '5600568SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('5003803', '5003804', '5006500') AND a.supplierId=4758) OR ( a.articleSearch IN ('JTS288', 'JTS516', 'JTS546') AND a.supplierId=4501) OR ( a.articleSearch IN ('21416', '21712', '21715') AND a.supplierId=4598) OR ( a.articleSearch IN ('OPF48454', 'VVF83797', 'VVF93890') AND a.supplierId=4987) OR ( a.articleSearch IN ('260276', '260277', '260392') AND a.supplierId=206) OR (a.articleSearch='19351110' AND a.supplierId=6307) OR ( a.articleSearch IN ('54455', '55027') AND a.supplierId=6558) OR (a.articleSearch='JRSVG006' AND a.supplierId=4951) OR ( a.articleSearch IN ('23344', '28070') AND a.supplierId=317) OR ( a.articleSearch IN ('10341584', '10341917', '10341924') AND a.supplierId=479) OR (a.articleSearch='PAL52037' AND a.supplierId=442) OR ( a.articleSearch IN ('26VW4000', '26VW4001') AND a.supplierId=4829) OR ( a.articleSearch IN ('FT1178', 'FT1551', 'FT1779') AND a.supplierId=4737) OR ( a.articleSearch IN ('4409064', '4409065') AND a.supplierId=4306) OR ( a.articleSearch IN ('290RT01246', '290RT01502', '290RT01503') AND a.supplierId=6271) OR ( a.articleSearch IN ('0011020654', '0025000169', '0025002913') AND a.supplierId=4995) OR ( a.articleSearch IN ('042448B', '042758B', '042763B') AND a.supplierId=49) OR ( a.articleSearch IN ('BX0032', 'BX5019', 'BX5077') AND a.supplierId=208) OR ( a.articleSearch IN ('BDL6601', 'BDL6602', 'BDL6715') AND a.supplierId=475) OR (a.articleSearch='7D0411049' AND a.supplierId=6366) OR ( a.articleSearch IN ('BAP55121', 'BAP55124') AND a.supplierId=157) OR ( a.articleSearch IN ('460908', '460928', '769644') AND a.supplierId=405) OR ( a.articleSearch IN ('CSL7154', 'CSL7180', 'CSL7195') AND a.supplierId=421) OR ( a.articleSearch IN ('504937', '505270', '505271', '505272') AND a.supplierId=6263) OR ( a.articleSearch IN ('CSL20008', 'CSL20011') AND a.supplierId=4880) OR (a.articleSearch='F250R0019' AND a.supplierId=6476) OR ( a.articleSearch IN ('D140044', 'D140074') AND a.supplierId=186) OR (a.articleSearch='1227006' AND a.supplierId=253) OR ( a.articleSearch IN ('A25388', 'A25873', 'DSR1048', 'DSR1049') AND a.supplierId=471) OR ( a.articleSearch IN ('3075689', '3088932', '3088942') AND a.supplierId=4135) OR ( a.articleSearch IN ('19LB249', '31LB500', '31LB600') AND a.supplierId=4003) OR ( a.articleSearch IN ('1634901580', '1679754180') AND a.supplierId=4391) OR ( a.articleSearch IN ('BLR078', 'SS046', 'SS1224', 'SS4212') AND a.supplierId=267) OR ( a.articleSearch IN ('14433', 'F0017V', 'F0027V') AND a.supplierId=4834) OR ( a.articleSearch IN ('18654', '18984', '30827') AND a.supplierId=101) OR ( a.articleSearch IN ('FDL6601', 'FDL6602', 'FDL6715') AND a.supplierId=407) OR ( a.articleSearch IN ('FL0901H', 'FL486H', 'FL591H') AND a.supplierId=236) OR ( a.articleSearch IN ('2008015', '2908009', '2908017') AND a.supplierId=4727) OR ( a.articleSearch IN ('FZ7188', 'FZ7209') AND a.supplierId=4467) OR ( a.articleSearch IN ('F2762', 'F5242') AND a.supplierId=486) OR ( a.articleSearch IN ('5512', '5512K', '6524', '6525', '6525K') AND a.supplierId=6101) OR (a.articleSearch='RS0112' AND a.supplierId=6443) OR ( a.articleSearch IN ('510286', '520525', 'S050374', 'S050447', 'S050445') AND a.supplierId=373) OR ( a.articleSearch IN ('GSP301088', 'GSP301103', 'GSP301125') AND a.supplierId=6529) OR ( a.articleSearch IN ('1140402600', '1140402700', '1240400900') AND a.supplierId=268) OR ( a.articleSearch IN ('9030277', '9030294', '9030386') AND a.supplierId=185) OR ( a.articleSearch IN ('31998', '850024609', '850029618', '850029619') AND a.supplierId=286) OR (a.articleSearch='KDL6601' AND a.supplierId=4879) OR (a.articleSearch='47556Z' AND a.supplierId=387) OR ( a.articleSearch IN ('4300675', '4300677', '4301567') AND a.supplierId=4546) OR (a.articleSearch='301191624830' AND a.supplierId=4723) OR ( a.articleSearch IN ('21044PCSMS', '21044SETMS', '31993PCSMS', '31998PCSMS', '31998SETMS', '369362KITMS', '370481KITMS') AND a.supplierId=358) OR ( a.articleSearch IN ('721182', '721473', '721548', '721636') AND a.supplierId=403) OR ( a.articleSearch IN ('04314', '04335', '14433') AND a.supplierId=4664) OR ( a.articleSearch IN ('53003618', '53007808', '53007918', '83003618', '83007808') AND a.supplierId=94) OR (a.articleSearch='127103870' AND a.supplierId=6376) OR ( a.articleSearch IN ('VSL775A', 'VSL776A', 'VSL919') AND a.supplierId=4564) OR (a.articleSearch='ZLPPL007' AND a.supplierId=6355) OR ( a.articleSearch IN ('0501443', '0503864', '0504360', '1215671') AND a.supplierId=198) OR ( a.articleSearch IN ('2394543', '2394718', '2394720') AND a.supplierId=4380) OR ( a.articleSearch IN ('SSL106111', 'SSL110111') AND a.supplierId=378) OR ( a.articleSearch IN ('G71012', 'G7597', 'G7602') AND a.supplierId=129) OR ( a.articleSearch IN ('31491', '32429', '37483') AND a.supplierId=331) OR ( a.articleSearch IN ('06402', '08408', '12852') AND a.supplierId=4683) OR ( a.articleSearch IN ('23050267', '23050371') AND a.supplierId=4686) OR ( a.articleSearch IN ('QS3121HQ', 'QS6887HQ', 'QS9402HQ') AND a.supplierId=4821) OR ( a.articleSearch IN ('LS7170', 'LS7726') AND a.supplierId=4368) OR ( a.articleSearch IN ('QLS3269S', 'QLS3270S', 'QLS3400S') AND a.supplierId=57) OR (a.articleSearch='R52525' AND a.supplierId=4303) OR ( a.articleSearch IN ('RH060009', 'RH060012', 'RH065009') AND a.supplierId=6892) OR ( a.articleSearch IN ('3229S0240', '3229S0336') AND a.supplierId=6358) OR ( a.articleSearch IN ('LSO467', 'LSV710', 'LSV720') AND a.supplierId=6698) OR ( a.articleSearch IN ('915399', '925468', '925469') AND a.supplierId=23) OR (a.articleSearch='1864973001' AND a.supplierId=32) OR ( a.articleSearch IN ('VKDS341021', 'VKDS341022', 'VKDS345001') AND a.supplierId=50) OR ( a.articleSearch IN ('57176', '57188', '57262') AND a.supplierId=6363) OR ( a.articleSearch IN ('SKST0230082', 'SKST0230239', 'SKST0230335') AND a.supplierId=6357) OR ( a.articleSearch IN ('T404314', 'T404335', 'T414433') AND a.supplierId=4667) OR ( a.articleSearch IN ('30790034', '30918654', '40930827') AND a.supplierId=151) OR ( a.articleSearch IN ('RS12081', 'RS15980') AND a.supplierId=6312) OR ( a.articleSearch IN ('O467', 'V710', 'V720') AND a.supplierId=4414) OR ( a.articleSearch IN ('108570', '108769', '206848') AND a.supplierId=301) OR ( a.articleSearch IN ('783759', '783760') AND a.supplierId=4970) OR ( a.articleSearch IN ('850024609', '850029618', '850029619') AND a.supplierId=108) OR ( a.articleSearch IN ('12796013', '12796014', '24417251', '33321126476') AND a.supplierId=4999) OR ( a.articleSearch IN ('V103678', 'V107258', 'V107259', 'V400499') AND a.supplierId=183) OR ( a.articleSearch IN ('22674', '23023', '25004') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG1993128', 'WG1993159', 'WG1993163', 'WG2030249', 'WG2030568', 'WG2032816', 'WG2040248', 'WG2040249', 'WG2040346') AND a.supplierId=4832) OR ( a.articleSearch IN ('380419', '380921', '560237') AND a.supplierId=6347) OR ( a.articleSearch IN ('SS1185', 'SS1221', 'SS1315') AND a.supplierId=4894)An internal server error occurred.