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 ('2114', '2115', '2337', '2338', '2132') AND a.supplierId=206) OR ( a.articleSearch IN ('D3102', 'D3101', 'D3144') AND a.supplierId=351) OR ( a.articleSearch IN ('F026002176', '0204116098', '0204116117', '0204116126', '0204116127', '0204116176', '0204116177', '0986475233', '0986475234', 'F026002163', 'F026002177', '0204116390', '0204116163') AND a.supplierId=30) OR ( a.articleSearch IN ('101477', '101158', '101159', '101360', '101476', '101685') AND a.supplierId=311) OR ( a.articleSearch IN ('K2236', 'K2237', 'K2249', 'K2250', 'K2299') AND a.supplierId=271) OR ( a.articleSearch IN ('4535', '4537', '1129', '4064', '4521', '4523', '4540', '4549') AND a.supplierId=283) OR ( a.articleSearch IN ('C5R008ABE', 'C5R009ABE', 'C5R012ABE') AND a.supplierId=4426) OR ( a.articleSearch IN ('89618', '89619', '89657', '89658') AND a.supplierId=317) OR ( a.articleSearch IN ('BCY1001', 'BCY1076', 'BCY1087', 'BCY1117', 'BCY1316', 'MCY229') AND a.supplierId=4537) OR ( a.articleSearch IN ('24322211073', '24322211183', '24322217093', '24322217103', '24322215013', '24322211043') AND a.supplierId=3) OR ( a.articleSearch IN ('CPDREN401', 'CPDREN402', 'CPDREN403', 'CPDREN404') AND a.supplierId=6531) OR ( a.articleSearch IN ('290CL00051', '290CL00052') AND a.supplierId=6271) OR (a.articleSearch='BBW1301' AND a.supplierId=475) OR ( a.articleSearch IN ('AJ2042', 'AJ2043') AND a.supplierId=4993) OR ( a.articleSearch IN ('A12060', 'A12061', 'A12070', 'A12071', 'A12101', 'A12141', 'A12161', 'M68033') AND a.supplierId=65) OR ( a.articleSearch IN ('53467', '54231') AND a.supplierId=4805) OR ( a.articleSearch IN ('3630', '3631', '3757', '3758', '3776') AND a.supplierId=243) OR ( a.articleSearch IN ('7440247', '7440248') AND a.supplierId=6411) OR ( a.articleSearch IN ('LM23474', 'LW21756', 'LW21833', 'LW22135', 'LW22136', 'LW30262', 'LW30263') AND a.supplierId=89) OR ( a.articleSearch IN ('N03020', 'N03021', 'N03039', 'N03044', 'N03045', 'N03095', 'N03107', 'N04022') AND a.supplierId=4396) OR ( a.articleSearch IN ('300212', '300233', '300517') AND a.supplierId=4512) OR ( a.articleSearch IN ('FHW116', 'FHW117', 'FHW131', 'FHW133', 'FHW134', 'FHW4501', 'FHW4609') AND a.supplierId=62) OR ( a.articleSearch IN ('322011', '322012', '322018') AND a.supplierId=380) OR ( a.articleSearch IN ('CF012', 'CF013', 'CF016', 'CF017', 'CF098', 'CF125') AND a.supplierId=295) OR ( a.articleSearch IN ('R22081B1', 'R22083A1', 'R22084A1') AND a.supplierId=54) OR ( a.articleSearch IN ('5006112', '5006134', '5006135', '5006168', '5006173', '5006174', '5006342') AND a.supplierId=279) OR ( a.articleSearch IN ('8AW355530641', '8AW355531071', '8AW355531081', '8AW355533081') AND a.supplierId=4734) OR ( a.articleSearch IN ('211773J', '211774J', '212304J', '212305J') AND a.supplierId=49) OR ( a.articleSearch IN ('WC30426', 'WC30427') AND a.supplierId=6911) OR ( a.articleSearch IN ('B1129', 'W4064', 'W4521', 'W4523', 'W4535', 'W4537', 'W4540', 'W4549') AND a.supplierId=286) OR ( a.articleSearch IN ('6035070', '6035581', '6035582', '6035600', '6035610') AND a.supplierId=4546) OR ( a.articleSearch IN ('360219230169', '360219230174', '360219230175', '360219230183', '360219230185') AND a.supplierId=4723) OR ( a.articleSearch IN ('040158', '040159', '040360', '040476', '040477', '040685') AND a.supplierId=121) OR (a.articleSearch='101476' AND a.supplierId=94) OR (a.articleSearch='VWC277' AND a.supplierId=4564) OR ( a.articleSearch IN ('803917', '809932', '809933', '809941', '809942', '823913') AND a.supplierId=127) OR (a.articleSearch='N421N125' AND a.supplierId=440) OR ( a.articleSearch IN ('FWC316400', 'FWC316500', 'FWC317500', 'FWC322200', 'FWC322300') AND a.supplierId=378) OR (a.articleSearch='RZ9024' AND a.supplierId=129) OR ( a.articleSearch IN ('PRH2395', 'PRH2396', 'PRH2470', 'PRH2471', 'PRH2480') AND a.supplierId=4520) OR ( a.articleSearch IN ('BWC3157', 'BWC3158', 'BWC3168', 'BWC3170', 'BWC3173', 'BWC3508') AND a.supplierId=57) OR ( a.articleSearch IN ('C06168', 'C06169', 'C11300', 'C11301', 'C12340', 'C12344', 'C30028', 'P12591') AND a.supplierId=343) OR ( a.articleSearch IN ('4024474', '4024484') AND a.supplierId=260) OR ( a.articleSearch IN ('813025011', '813025012', '813025019', '813025020') AND a.supplierId=108) OR ( a.articleSearch IN ('CF012', 'CF013', 'CF016', 'CF017', 'CF098', 'CF125') AND a.supplierId=199) OR ( a.articleSearch IN ('BWH112', 'BWH134', 'BWH135', 'BWH168', 'BWH173', 'BWH174', 'BWH342') AND a.supplierId=4501) OR ( a.articleSearch IN ('350458', '350496', '350497', '350556', '350557') AND a.supplierId=21)