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='1025770SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('0160170043', '0160170067', '0160170069', '0370170071') AND a.supplierId=4657) OR ( a.articleSearch IN ('109206', '109206A', '109207', '109207A', '109416', '109416A', '109416O') AND a.supplierId=422) OR (a.articleSearch='150071N' AND a.supplierId=80) OR ( a.articleSearch IN ('32614', '32858') AND a.supplierId=4576) OR (a.articleSearch='D42575C' AND a.supplierId=351) OR ( a.articleSearch IN ('103986', '103987', '105120', '105604', '107005') AND a.supplierId=4688) OR ( a.articleSearch IN ('PRD0836', 'PRD1591') AND a.supplierId=4337) OR ( a.articleSearch IN ('FT2311', 'FT2312', 'FT2449', 'FTA2311', 'FTA2312', 'FTA2449', 'OL2423', 'OLA2423') AND a.supplierId=247) OR (a.articleSearch='0011025336' AND a.supplierId=4995) OR (a.articleSearch='BSG65520053' AND a.supplierId=4455) OR (a.articleSearch='CRV9045' AND a.supplierId=4334) OR ( a.articleSearch IN ('8181404', '8181411', '8181412', '8181413', '8345604', '8348610', 'DCM1980', 'DCM1981', 'DCM2012', 'DCM2672', '8345605') AND a.supplierId=253) OR ( a.articleSearch IN ('RAD001N', 'RAD026N', 'RAD027N', 'RAD077DNSN') AND a.supplierId=4882) OR (a.articleSearch='402580' AND a.supplierId=4512) OR ( a.articleSearch IN ('FT55008', 'FT55268', 'FT55549') AND a.supplierId=4938) OR (a.articleSearch='RC00163' AND a.supplierId=271) OR ( a.articleSearch IN ('01043128', '01043129', '01049128', '01049129', '01043179') AND a.supplierId=313) OR ( a.articleSearch IN ('8MK376754451', '8MK376754454', '8MK376754461', '8MK376754464', '8MK376788781', '8MK376788784', '8MK376900201', '8MK376900204') AND a.supplierId=4734) OR ( a.articleSearch IN ('RA0111150', 'RA0111320', 'RA0200930', 'RA0200931') AND a.supplierId=296) OR ( a.articleSearch IN ('347325', '368600') AND a.supplierId=6207) OR (a.articleSearch='80175B' AND a.supplierId=387) OR ( a.articleSearch IN ('5024302311', '5024302312') AND a.supplierId=78) OR ( a.articleSearch IN ('1553440', '1553445', '1553450') AND a.supplierId=4546) OR (a.articleSearch='LRC2140' AND a.supplierId=4707) OR ( a.articleSearch IN ('350213124900', '350213151200', '350213163100', '350213184300', '350213385000', '350213385003', '350213386000') AND a.supplierId=4723) OR ( a.articleSearch IN ('CR1111000P', 'CR1111000S', 'CR1112000P', 'CR1112000S', 'CR1794000P', 'CR1794000S', 'CR2003000P', 'CR2003000S') AND a.supplierId=287) OR ( a.articleSearch IN ('AC267401', 'AC594855') AND a.supplierId=403) OR (a.articleSearch='MRP2B03' AND a.supplierId=4773) OR ( a.articleSearch IN ('ACRB376', 'ACRM376') AND a.supplierId=6495) OR ( a.articleSearch IN ('617854', '61915', '61916', '61919') AND a.supplierId=123) OR ( a.articleSearch IN ('DRM09110', 'DRM09111', 'DRM09112', 'DRM09113') AND a.supplierId=440) OR ( a.articleSearch IN ('53454', '53455', '53935', '54752', '54752A', '550005') AND a.supplierId=205) OR (a.articleSearch='37684' AND a.supplierId=4683) OR ( a.articleSearch IN ('AA210R006', 'FT2311', 'FT2312', 'FT2449', 'FT342R001', 'FT910R004', 'FTA2311', 'FTA2312', 'FTA2449', 'OL2423', 'OLA2423', 'OP034R003') AND a.supplierId=340) OR (a.articleSearch='17400379' AND a.supplierId=4686) OR ( a.articleSearch IN ('470R0156', '470R0290', '470R0611') AND a.supplierId=6358) OR ( a.articleSearch IN ('31511007', '33511016') AND a.supplierId=6405) OR ( a.articleSearch IN ('SKRD0120183', 'SKRD0120318') AND a.supplierId=6357) OR ( a.articleSearch IN ('D7F033TT', 'D7X075TT') AND a.supplierId=4466) OR (a.articleSearch='7250042R' AND a.supplierId=61) OR ( a.articleSearch IN ('701655', '735040', '735041', '235041') AND a.supplierId=21) OR ( a.articleSearch IN ('17002312', '37002423') AND a.supplierId=36) OR ( a.articleSearch IN ('WG1919005', 'WG1919006', 'WG1919007', 'WG1919008') AND a.supplierId=4832) OR (a.articleSearch='G03403' AND a.supplierId=6347) OR (a.articleSearch='MK1196' AND a.supplierId=4894)An internal server error occurred.