SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, 
                
                (SELECT ps_sub.id 
         FROM products.products_suppliers ps_sub 
         WHERE ps_sub.product_id = p.id 
           AND ps_sub.supplier_id IN (224,226,223,225,227) 
         LIMIT 1) AS 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            
              WHERE ( a.articleSearch IN ('202068', '202013', '202075', '202792') AND a.supplierId=225) OR ( a.articleSearch IN ('1987301040', '1987302041', '1987302045', '1987302048', '1987302049', '1987302140', '1987302803', '1987302202', '1987302207', '1987302211', '1987302282', '1987302814', '1987302817') AND a.supplierId=30) OR ( a.articleSearch IN ('1616431180', '1616431280', '1616430780', '1616431380') AND a.supplierId=4391) OR (a.articleSearch='86301Z' AND a.supplierId=387) OR ( a.articleSearch IN ('176353000', '480692100', '486772100', '486773000', '488612100', '488613000', '488614000', '488813000', '488814000', '488893000', '171253000', '171254000', '171313000', '171314000', '179163000', '179164000') AND a.supplierId=485) OR ( a.articleSearch IN ('N382', 'N38202B', 'N472', 'N47201B', 'N472B', 'N472BSCB', 'N472EL12SCB', 'N233', 'N239', 'N23902B', 'N380', 'N38002B') AND a.supplierId=4671) OR ( a.articleSearch IN ('64193', '6419301B', '64193ALS', '64193CBI', '64193CBIHCB', '64193CLC', '64193NBS', '64193NBS01B', '64193NBSHCB', '64193NL', '64193NL01B', '64193NLHCB', '64193SUP', '64193ULT', '64193ULTHCB', '7506', '750602B', '7506ULT', '7506ULT02B', '3893', '389302B', '6418', '641802B', '6418ULT', '6418ULT02B', '7528', '752802B', '7528ULT', '7528ULT02B', '64193MC', '64193XR02B', '64193SV2', '64193SV2HCB', '64193NBL', '64193NBU', '64193NBL01B', '64193NBU01B', '64193NBLHCB', '64193NBUHCB', '64193NR102B', '64193L') AND a.supplierId=67) OR ( a.articleSearch IN ('PLH46055', 'PLS2521', 'PL3501', 'PLS25215', 'PLT85124', 'PLC215W') AND a.supplierId=4558) OR ( a.articleSearch IN ('12342LLECOB1', '12342LLECOC1', '12342LLECOS2', '12342PRB1', '12342PRC1', '12342RGTB1', '12342RGTS2', '12342VPB1', '12342VPS2', '12342WVUB1', '12342WVUSM', '12342XVPB1', '12342XVPS2', '12498B2', '12498CP', '12498LLECOB2', '12498LLECOCP', '12498VPB2', '12499B2', '12499CP', '12499LLECOB2', '12499LLECOCP', '12499VPB2', '12844B2', '12844CP', '12929B2', '12929CP', '12342CTVBW', '12342CVPBS2', '12342CVPGS2', '12342CVPPS2', '12342CVPYS2', '12342CVUBW', '12342ELC2', '12342PRBW', '12342PRC2', '12342RVB1', '12342RVS2', '12342VPC2', '12342WHVB1', '12342WHVSM', '12342XVB1', '12342XVBW', '12342XVGB1', '12342XVGS2', '12342XVS2', '12499EDBW', '12594B2', '12594CP', '12844', '12854CP', '55718EBKM') AND a.supplierId=75) OR ( a.articleSearch IN ('032007', '032201', '032509', '032511', '032513', '032515', '032101', '032107', '032207', '032217', '032223') AND a.supplierId=21) OR ( a.articleSearch IN ('LP1064', 'LP1100') AND a.supplierId=4894) OR (a.articleSearch='91351' AND a.supplierId=4495) OR ( a.articleSearch IN ('150111310', '150111410', '150111910', '150112610', '150113110') AND a.supplierId=323) OR ( a.articleSearch IN ('1101', '1321', '1341', '1711') AND a.supplierId=4995) OR ( a.articleSearch IN ('LID10009', 'LID10010', 'LID10011', 'LID10050', 'LID10064', 'LID10067') AND a.supplierId=253) OR ( a.articleSearch IN ('725379', '978104', '978129', '978130') AND a.supplierId=355) OR (a.articleSearch='06583' AND a.supplierId=101) OR ( a.articleSearch IN ('8GA002073121', '8GA002073123', '8GD002078121', '8GD002078123', '8GM002092121', '8GM002092123') AND a.supplierId=4734) OR (a.articleSearch='1195901400' AND a.supplierId=268) OR ( a.articleSearch IN ('L10460', 'L1046001', 'L1046002', 'L10460B', 'L10460B01', 'L10460B02') AND a.supplierId=4600) OR ( a.articleSearch IN ('780033', '780033SET') AND a.supplierId=403) OR ( a.articleSearch IN ('VBU380', 'VBU382', 'VBU472') AND a.supplierId=4564) OR (a.articleSearch='02918' AND a.supplierId=4683) OR ( a.articleSearch IN ('VG9504054', 'VG9504154', 'VW9504054', 'VW9504154') AND a.supplierId=340) OR (a.articleSearch='0961850' AND a.supplierId=4623) OR ( a.articleSearch IN ('2010', '2014', '54182', '54182LL') AND a.supplierId=45) OR ( a.articleSearch IN ('9939029SX', '9939035SX', '9939038SX', '9939040SX', '9939047SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('99906583', '99906962') AND a.supplierId=151) OR ( a.articleSearch IN ('B10401', 'B40401', 'B50401', 'B52101', 'B52201') AND a.supplierId=356) OR ( a.articleSearch IN ('104492', '104493', '104494', '104499') AND a.supplierId=301) OR ( a.articleSearch IN ('8858103', '8858109', '8858110', '8858123') AND a.supplierId=209) OR ( a.articleSearch IN ('V99840003', 'V99840005', 'V99840007', 'V99840008') AND a.supplierId=183)An internal server error occurred.