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 ('CV9530A', 'CV9509A', 'CV9548B', 'MT8547') AND a.supplierId=478) OR ( a.articleSearch IN ('BSG65340006', 'BSG65340007', 'BSG65340022', 'BSG65340025', 'BSG65340029', 'BSG65340076', 'BSG65340077', 'BSG65350044') AND a.supplierId=4455) OR ( a.articleSearch IN ('1050020071', '1050020072') AND a.supplierId=4345) OR ( a.articleSearch IN ('1810Z18', '1810ZAF', '1811Z16RH', '1811Z19DRH', '1811ZAF', '1815ASH') AND a.supplierId=4674) OR a.articleSearch='CV16151' AND a.supplierId=271) OR ( a.articleSearch IN ('KOP684', 'KOP685') AND a.supplierId=283) OR ( a.articleSearch IN ('CO5904', 'CO5900', 'CO5932') AND a.supplierId=4600) OR ( a.articleSearch IN ('151504', '151505') AND a.supplierId=121) OR ( a.articleSearch IN ('513636', '513638') AND a.supplierId=127) OR ( a.articleSearch IN ('PCV1058', 'PCV1504', 'PCV1505') AND a.supplierId=4558) OR a.articleSearch='73387' AND a.supplierId=4576) OR ( a.articleSearch IN ('OP504', 'OPAJ', 'OPIRAH13', 'OPIRZ19', 'OPIUAJ16MT', 'OPZAFC') AND a.supplierId=4631) OR ( a.articleSearch IN ('821327', '821734', '822104', '832396') AND a.supplierId=300) OR ( a.articleSearch IN ('G400323', 'G400324', 'G450042') AND a.supplierId=4464) OR ( a.articleSearch IN ('GOP6840K', 'GOP6850K') AND a.supplierId=243) OR a.articleSearch='3204' AND a.supplierId=318) OR ( a.articleSearch IN ('6634', '7710') AND a.supplierId=393) OR ( a.articleSearch IN ('607504', '607505') AND a.supplierId=311) OR ( a.articleSearch IN ('ECV232', 'ECV233') AND a.supplierId=421) OR ( a.articleSearch IN ('C120092', 'C120099') AND a.supplierId=186) OR ( a.articleSearch IN ('DP2110101380', 'DP2110101381', 'DP2110101646') AND a.supplierId=4948) OR ( a.articleSearch IN ('DCV621014', 'DCV844003', 'DCV844028') AND a.supplierId=4881) OR a.articleSearch='77OP1051' AND a.supplierId=4135) OR ( a.articleSearch IN ('CV22453K', 'CV22469K') AND a.supplierId=391) OR a.articleSearch='DA508722' AND a.supplierId=224) OR ( a.articleSearch IN ('771041430', '771041530') AND a.supplierId=192) OR ( a.articleSearch IN ('140074', '140085', '240361', '240365') AND a.supplierId=90) OR a.articleSearch='40014' AND a.supplierId=101) OR a.articleSearch='460570' AND a.supplierId=441) OR ( a.articleSearch IN ('20398012S', '20398021S', '20398034S', '20398044S') AND a.supplierId=4727) OR ( a.articleSearch IN ('FDS2687', 'FVJ0196') AND a.supplierId=87) OR ( a.articleSearch IN ('244065', '644005', '644016', '844003', '844028') AND a.supplierId=373) OR ( a.articleSearch IN ('312738', '312739') AND a.supplierId=262) OR a.articleSearch='1243302010' AND a.supplierId=268) OR ( a.articleSearch IN ('5011013', '6013') AND a.supplierId=185) OR ( a.articleSearch IN ('304384', '304386', '305789', '305859', '306676', '23985', '23987', '25596', '25665', '36497') AND a.supplierId=6363) OR ( a.articleSearch IN ('302009100031', '302015100214', '302015100227') AND a.supplierId=4723) OR ( a.articleSearch IN ('16721', '16722') AND a.supplierId=133) OR ( a.articleSearch IN ('304384SETMS', '304386SETMS') AND a.supplierId=358) OR ( a.articleSearch IN ('490279', '490280', '491835', '492852') AND a.supplierId=403) OR a.articleSearch='MRP2B03' AND a.supplierId=4773) OR ( a.articleSearch IN ('7110130', '7110131') AND a.supplierId=94) OR ( a.articleSearch IN ('6144980023', '6144980028') AND a.supplierId=144) OR ( a.articleSearch IN ('GA10021', 'GA10024', 'GA20345', 'GA20353', 'GA20619') AND a.supplierId=6495) OR ( a.articleSearch IN ('603100481', '603100491') AND a.supplierId=6376) OR ( a.articleSearch IN ('12231320', '12231392', '14236040', '18232320') AND a.supplierId=4653) OR ( a.articleSearch IN ('NPWPL005', 'NPWPL006', 'NPWPL025', 'NPWPL026', 'NPWPL105', 'NPZPL025', 'NPZPL026', 'NWPPL003') AND a.supplierId=6355) OR ( a.articleSearch IN ('CVJ559810', 'CVJ560210') AND a.supplierId=378) OR ( a.articleSearch IN ('CW2625', 'CW2666') AND a.supplierId=129) OR ( a.articleSearch IN ('22260', '24771') AND a.supplierId=4683) OR ( a.articleSearch IN ('G1X024PC', 'G1X025PC', 'G1X042PC', 'G7X026PC') AND a.supplierId=4690) OR a.articleSearch='27101504' AND a.supplierId=4686) OR ( a.articleSearch IN ('PRJ287', 'PRJ409') AND a.supplierId=4520) OR ( a.articleSearch IN ('OA87A', 'OA88') AND a.supplierId=492) OR a.articleSearch='5J0181' AND a.supplierId=6358) OR ( a.articleSearch IN ('75325', '75325S', '75326', '75326S') AND a.supplierId=23) OR ( a.articleSearch IN ('24K684', '24K685') AND a.supplierId=343) OR ( a.articleSearch IN ('CV1027N', 'CV1155N', 'VA238R', 'CV1851N') AND a.supplierId=4607) OR a.articleSearch='460570' AND a.supplierId=27) OR ( a.articleSearch IN ('VKJA3126', 'VKJA3127', 'VKJC5907') AND a.supplierId=50) OR a.articleSearch='SKJK0200157' AND a.supplierId=6357) OR ( a.articleSearch IN ('1501504SX', '1501505SX', '1501710SX', '1601008SX', '1601037SX') AND a.supplierId=4595) OR a.articleSearch='62940014' AND a.supplierId=151) OR a.articleSearch='77OP1051' AND a.supplierId=4758) OR a.articleSearch='CVN2079' AND a.supplierId=6480) OR a.articleSearch='207491' AND a.supplierId=301) OR ( a.articleSearch IN ('400323', '400324', '450042') AND a.supplierId=4472) OR ( a.articleSearch IN ('854024126', '854024127', '854024210') AND a.supplierId=108) OR ( a.articleSearch IN ('V400804', 'V400809') AND a.supplierId=183) OR ( a.articleSearch IN ('GS3136', 'GS3983', 'GS3984', 'GS4859') AND a.supplierId=4894)An internal server error occurred.