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 ('13046026092', '13046027852', '13046027902', '13047027852', '13047027902', '13046072932', '13047072932') AND a.supplierId=3) OR ( a.articleSearch IN ('0986494660', '0986494797', '0986494659', '0986494743', '0986495296', '0986495347') AND a.supplierId=30) OR ( a.articleSearch IN ('P85135', 'P85147', '07B31493', '07B31541', 'P85125', 'P85125N', 'P85125X', 'P85126', 'P85126N', 'P85126X', 'P85131', 'P85131N', 'P85131X', 'P85135N', 'P85140', 'P85140N', 'P85147N') AND a.supplierId=65) OR ( a.articleSearch IN ('LP2698', 'LP2709', 'BG3953C', 'LP2490', 'LP2697', 'LP3389', 'LP3504', 'LP3584', 'BG3953') AND a.supplierId=89) OR ( a.articleSearch IN ('55022247113', '55022247121', '55022247114', '55022247117', '58152047115', '58153147115') AND a.supplierId=4770) OR ( a.articleSearch IN ('1639376780', '1618873780', '1639374980', '1681162380') AND a.supplierId=4391) OR ( a.articleSearch IN ('16912', '16994', '16995') AND a.supplierId=101) OR ( a.articleSearch IN ('FDB4433', 'FDB4485', 'DDF1305', 'DDF1305C', 'FDB4434') AND a.supplierId=62) OR ( a.articleSearch IN ('182111204', '182152', '182018', '182099', '182111') AND a.supplierId=158) OR ( a.articleSearch IN ('MBF015285', 'MBF015281', 'MBF015920', 'MBF016049') AND a.supplierId=4570) OR ( a.articleSearch IN ('2247113', '2247117', '2247121', '2047115', '2247114', '3147115', '2247118') AND a.supplierId=127) OR ( a.articleSearch IN ('2511001', '2568303', '2473801', '2500801', '2511003', '2568301') AND a.supplierId=39) OR ( a.articleSearch IN ('GDB1956', 'GDB2143', 'GDB1956BTE', 'GDB2042', 'GDB2179') AND a.supplierId=4501) OR ( a.articleSearch IN ('C1W071ABE', 'C2W035ABE') AND a.supplierId=4426) OR ( a.articleSearch IN ('35001', '37958', '37964', '35070') AND a.supplierId=206) OR ( a.articleSearch IN ('19374068', '19377454') AND a.supplierId=6307) OR ( a.articleSearch IN ('VBP3924', 'VBP7652') AND a.supplierId=4400) OR ( a.articleSearch IN ('BPVW1028', 'BPVW1029', 'BPVW2018') AND a.supplierId=4951) OR ( a.articleSearch IN ('AN7037K', 'AN938K') AND a.supplierId=4024) OR ( a.articleSearch IN ('1050308', '1051093', '1051124', '1051171', '1110094') AND a.supplierId=317) OR ( a.articleSearch IN ('PAD1902', 'PAD1903', 'PAD1961', 'PD3365', 'PD3366', 'PD3738') AND a.supplierId=4537) OR ( a.articleSearch IN ('X41163', 'X41338') AND a.supplierId=4975) OR ( a.articleSearch IN ('71727', '72631') AND a.supplierId=4576) OR ( a.articleSearch IN ('50000907', '50000942', '51000900') AND a.supplierId=257) OR ( a.articleSearch IN ('P11133', 'P11537', 'P11551', 'P11552') AND a.supplierId=442) OR (a.articleSearch='KD7019' AND a.supplierId=4854) OR ( a.articleSearch IN ('AKD23108', 'AKD23208') AND a.supplierId=4631) OR (a.articleSearch='PBP8526' AND a.supplierId=4337) OR ( a.articleSearch IN ('290BK08248', '290BK08325') AND a.supplierId=6271) OR ( a.articleSearch IN ('511132', '511142', '511182', '511315', '562387J', '562387JC', '562387JC1', '573390J', '573409J', '573603J') AND a.supplierId=49) OR ( a.articleSearch IN ('ADV184233', 'ADV184243', 'ADV184250') AND a.supplierId=350) OR ( a.articleSearch IN ('BBP2381', 'BBP2448', 'BBP2550') AND a.supplierId=475) OR ( a.articleSearch IN ('AA0621', 'AB0313') AND a.supplierId=4993) OR ( a.articleSearch IN ('251100070400', '251100070410', '256830070100') AND a.supplierId=281) OR ( a.articleSearch IN ('BP2806', 'BP3516', 'BP3518', 'BP3623', 'BP3782', 'CD7305V') AND a.supplierId=4872) OR ( a.articleSearch IN ('BSG90200022', 'BSG90200023', 'BSG90202011') AND a.supplierId=4455) OR ( a.articleSearch IN ('562387CH', '573390CH', '573409CH', '573418CH', '573603CH', '573838CH') AND a.supplierId=43) OR ( a.articleSearch IN ('8229500', '8229500K', '8229800') AND a.supplierId=311) OR ( a.articleSearch IN ('ADB02158', 'ADB02220', 'ADB0797', 'ADB12158', 'CBP02158', 'CBP02220', 'CBP0797', 'CBP12158', 'ADB01716', 'CBP01716') AND a.supplierId=421) OR ( a.articleSearch IN ('320222', '323316') AND a.supplierId=6479) OR (a.articleSearch='DBP2698' AND a.supplierId=4587) OR (a.articleSearch='B111306' AND a.supplierId=186) OR ( a.articleSearch IN ('N09598', 'N09716', 'N09717', 'N09857', 'N09925') AND a.supplierId=4396) OR (a.articleSearch='DIP111N' AND a.supplierId=4882) OR ( a.articleSearch IN ('PCP1107', 'PCP1200', 'PCP1281', 'PCP1309', 'PCP1423') AND a.supplierId=278) OR (a.articleSearch='DP1010100934' AND a.supplierId=4948) OR (a.articleSearch='DBP394485' AND a.supplierId=266) OR ( a.articleSearch IN ('DBP4433', 'DBP4485') AND a.supplierId=4881) OR ( a.articleSearch IN ('DP22150', 'DP22201', 'DP32150C', 'DP42150R', 'DP42201R', 'DPX2150', 'DPX2201') AND a.supplierId=6368) OR ( a.articleSearch IN ('RAP1022', 'RAP1034', 'RAP1085', 'RAP1291', 'RAP1330', 'RAP1888') AND a.supplierId=457) OR ( a.articleSearch IN ('121516', '121570') AND a.supplierId=309) OR ( a.articleSearch IN ('FD15301', 'FD15301M', 'FD15307') AND a.supplierId=6543) OR ( a.articleSearch IN ('17018VF', '2601OCTA7R') AND a.supplierId=4674) OR (a.articleSearch='BP43420' AND a.supplierId=271) OR ( a.articleSearch IN ('FBP1678', 'FBP4211', 'FBP4375') AND a.supplierId=4838) OR ( a.articleSearch IN ('FP0158', 'FP1115E') AND a.supplierId=4937) OR ( a.articleSearch IN ('FO251081', 'FO252181') AND a.supplierId=4887) OR ( a.articleSearch IN ('FBP1972', 'FBP1975', 'FBP1976') AND a.supplierId=409) OR (a.articleSearch='PD10519' AND a.supplierId=313) OR ( a.articleSearch IN ('9660', '9660W', '9960') AND a.supplierId=295) OR ( a.articleSearch IN ('BL2090A1', 'BL2090B1', 'BL2788A1') AND a.supplierId=54) OR ( a.articleSearch IN ('B1G12011672', 'B1G12014302', 'B1G12014582', 'B1G12015642') AND a.supplierId=500) OR ( a.articleSearch IN ('6119561', '6120421', '6121431', '6121761', '6121791') AND a.supplierId=279) OR (a.articleSearch='1118F' AND a.supplierId=4663) OR ( a.articleSearch IN ('8DB355015921', '8DB355020191', '8DB355020271', '8DB355021291', '8DB355021911', '8DB355023171') AND a.supplierId=4734) OR (a.articleSearch='J3600822' AND a.supplierId=72) OR ( a.articleSearch IN ('SP1678', 'SP1900') AND a.supplierId=6265) OR ( a.articleSearch IN ('PA0907AF', 'PA0942AF', 'PP0900AF') AND a.supplierId=156) OR ( a.articleSearch IN ('500907', '500942', '510900') AND a.supplierId=481) OR ( a.articleSearch IN ('1163609510', '1163613910', '1163708710') AND a.supplierId=268) OR ( a.articleSearch IN ('JCP4265', 'JCP4485', 'JCP8148') AND a.supplierId=4935) OR ( a.articleSearch IN ('FK20037', 'FK20292', 'FK20303') AND a.supplierId=4461) OR ( a.articleSearch IN ('2473820015', '2511017504', '2568320315') AND a.supplierId=6207) OR ( a.articleSearch IN ('1032610', 'JQ101186', 'JQ101187', 'JQ101359', 'JQ101375') AND a.supplierId=185) OR ( a.articleSearch IN ('151501', '154908') AND a.supplierId=286) OR ( a.articleSearch IN ('KBP2381', 'KBP2448') AND a.supplierId=4879) OR ( a.articleSearch IN ('24079Z', '24080Z', '24259Z', '24411Z') AND a.supplierId=387) OR (a.articleSearch='6000121' AND a.supplierId=4546) OR ( a.articleSearch IN ('05P1734', '05P1834', '05P1835', '05P1986', '05P2067') AND a.supplierId=283) OR ( a.articleSearch IN ('BD8043', 'BD8044') AND a.supplierId=4600) OR ( a.articleSearch IN ('363916060714', '363916060715', '363916060716', '363916060887') AND a.supplierId=4723) OR ( a.articleSearch IN ('6629', '6634', '6634HPS', '6993HPS') AND a.supplierId=133) OR ( a.articleSearch IN ('13046027852NSETMS', '13046027852TSETMS', '13046027902NSETMS', '13046027902TSETMS', '13046072932NSETMS', '13046144342NSETMS', '13046144342TSETMS', '202501451', '202501580', 'AB236027852', 'K6027852', 'K6144342') AND a.supplierId=358) OR (a.articleSearch='MSE0198' AND a.supplierId=6270) OR ( a.articleSearch IN ('192143', '193012', '193058', '193407', '193592') AND a.supplierId=403) OR ( a.articleSearch IN ('2209500', '2209500K', '2209800') AND a.supplierId=121) OR ( a.articleSearch IN ('1170411', '1170792') AND a.supplierId=94) OR ( a.articleSearch IN ('0252500816', '0252500816PD', '0252510917', '0252510917PD', '0252568320', '0252568320PD') AND a.supplierId=144) OR ( a.articleSearch IN ('E100376', 'E400376', 'E500376') AND a.supplierId=6495) OR ( a.articleSearch IN ('MDB3100', 'MDB3173', 'MDB3340', 'MDB3382', 'MDB3778', 'MDB3827') AND a.supplierId=73) OR ( a.articleSearch IN ('D11341H', 'D11342H') AND a.supplierId=6103) OR (a.articleSearch='429103620' AND a.supplierId=6376) OR ( a.articleSearch IN ('LVXL1749', 'LVXL1751', 'LVXL1787', 'LVXL1809') AND a.supplierId=4564) OR ( a.articleSearch IN ('M22223', 'M22226', 'M22227') AND a.supplierId=6533) OR ( a.articleSearch IN ('NP2677', 'NP2886') AND a.supplierId=190) OR (a.articleSearch='NB25086V01' AND a.supplierId=6280) OR ( a.articleSearch IN ('PN0624', 'PN0624S', 'PN33005W', 'PN33005WS') AND a.supplierId=4682) OR ( a.articleSearch IN ('2454059', '2454061') AND a.supplierId=4380) OR ( a.articleSearch IN ('BDA220720', 'BDR220720', 'BPA151501', 'BPA151600', 'BPA151610', 'BPA154908') AND a.supplierId=378) OR ( a.articleSearch IN ('12618', '12677', '12701', 'BP12618', 'BP12677', 'BP12701') AND a.supplierId=129) OR (a.articleSearch='20886' AND a.supplierId=4683) OR (a.articleSearch='PBP1307' AND a.supplierId=4558) OR (a.articleSearch='50004433' AND a.supplierId=4686) OR ( a.articleSearch IN ('PRP1621', 'PRP16213M', 'PRP1751') AND a.supplierId=4520) OR ( a.articleSearch IN ('QP0399', 'QP0399C', 'QP2013', 'QP2013C', 'QP2730', 'QP2730C', 'QP6148', 'QP6148C', 'QP6623', 'QP6623C', 'QP7274', 'QP7274C', 'QP9775', 'QP9775C') AND a.supplierId=4821) OR ( a.articleSearch IN ('QF85816', 'QF85816P') AND a.supplierId=4339) OR ( a.articleSearch IN ('BDC5416', 'BP1820', 'BP1843') AND a.supplierId=57) OR ( a.articleSearch IN ('RA09920', 'RA09930', 'RA09931', 'RA09950', 'RA10380') AND a.supplierId=400) OR ( a.articleSearch IN ('RB2018', 'RB2099', 'RB2111', 'RB2111204', 'RB2152') AND a.supplierId=4955) OR ( a.articleSearch IN ('151501', '154908') AND a.supplierId=153) OR ( a.articleSearch IN ('RAP1022', 'RAP1034', 'RAP1085', 'RAP1291', 'RAP1330', 'RAP1888', 'RAP1248', 'RAP1630') AND a.supplierId=214) OR ( a.articleSearch IN ('402B0587', '402B0914') AND a.supplierId=6358) OR ( a.articleSearch IN ('2151501', '2154908') AND a.supplierId=152) OR ( a.articleSearch IN ('RT20312', 'RT20312GL', 'RT20312GLT3', 'RT20312GLT5', 'RT20312GLT6', 'RT20312HP', 'RT20312HPGL', 'RT20312HPGLT3', 'RT20312HPGLT5', 'RT20312HPGLT6') AND a.supplierId=4676) OR ( a.articleSearch IN ('5SP1734', '5SP1834', '5SP1835', '5SP1986', '5SP2067') AND a.supplierId=343) OR (a.articleSearch='6216075' AND a.supplierId=260) OR ( a.articleSearch IN ('18152047115', '18153147115') AND a.supplierId=297) OR (a.articleSearch='SP715PR' AND a.supplierId=225) OR ( a.articleSearch IN ('DBB305V', 'SPA806', 'SPB516', 'SPB518', 'SPB623', 'SPB782') AND a.supplierId=6331) OR ( a.articleSearch IN ('SKBP0011151', 'SKBP0011508') AND a.supplierId=6357) OR ( a.articleSearch IN ('000420BSX', '000661BSX', '000661SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30916912', '30916994', '30916995') AND a.supplierId=151) OR ( a.articleSearch IN ('01843A', '02292B') AND a.supplierId=6312) OR ( a.articleSearch IN ('TX1697', 'TX1732', 'TX1805') AND a.supplierId=4377) OR ( a.articleSearch IN ('115810', '115815', '116279', '116955') AND a.supplierId=301) OR ( a.articleSearch IN ('PF1487', 'PF1488') AND a.supplierId=4732) OR ( a.articleSearch IN ('811029023', '811029170', '811029176') AND a.supplierId=108) OR ( a.articleSearch IN ('0735257', '0735262') AND a.supplierId=209) OR ( a.articleSearch IN ('9660', '9660W', '9960') AND a.supplierId=199) OR ( a.articleSearch IN ('V101022', 'V109890') AND a.supplierId=183) OR ( a.articleSearch IN ('302145', '302146', '302265', '302271', '601328', '601329', '670059') AND a.supplierId=21) OR ( a.articleSearch IN ('66981408601', '66981690701', '66981693901', '66981694601') AND a.supplierId=4346) OR ( a.articleSearch IN ('WBP25008A', 'WBP80009A', 'WBP80010A', 'WGR13051') AND a.supplierId=4498) OR ( a.articleSearch IN ('1510029', '1510032') AND a.supplierId=482) OR ( a.articleSearch IN ('P1415301', 'P1449308') AND a.supplierId=366) OR (a.articleSearch='341237' AND a.supplierId=6347) OR ( a.articleSearch IN ('BS1047', 'BS1427', 'BS2446') AND a.supplierId=4894) OR ( a.articleSearch IN ('251101751', '256832001', '256832002', '256839002') AND a.supplierId=86)An internal server error occurred.