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 ('21653057', '21653058', '80000889', '80000890', '80000891', '80001337', '80001875', '80001891') AND a.supplierId=140) OR ( a.articleSearch IN ('01514', '18856', '18858', '01513', '01908', '01933', '174698', '19385', '37099') AND a.supplierId=101) OR ( a.articleSearch IN ('1117904700', '1117910280', '1117910380', '1117904600', '1132400100', '1132402400', '1132402700', '1132402800', '1132402900') AND a.supplierId=268) OR ( a.articleSearch IN ('2536901', '1022501', '1439901', '1440001', '1766601', '1768002', '2102201', '2263501', '2537001', '2537901', '10225', '14399', '14400', '17666', '17680', '21022', '22635', '25369', '25370', '25379') AND a.supplierId=35) OR ( a.articleSearch IN ('ME1969', 'ME1973', 'ME1975', 'ME1970') AND a.supplierId=4600) OR ( a.articleSearch IN ('04356', '04371', '04750', '04751', '04764', '01031', '04325', '04357', '41611', '49100') AND a.supplierId=4664) OR ( a.articleSearch IN ('1001990074', '1001990111', '1001300005', '1001990075', '1001990110') AND a.supplierId=144) OR ( a.articleSearch IN ('PSE10905', 'PSE30027', 'PSE3073', 'PSE3048', 'PSE3083', 'PSE3087', 'PSE3090', 'PSE3109', 'PSE3245') AND a.supplierId=4558) OR ( a.articleSearch IN ('2706180', '2706185', '2706254', '2706290', '2706445') AND a.supplierId=260) OR ( a.articleSearch IN ('2518093SX', '2519760SX', '7111008SX', '7111051SX', '7111279SX', '7111294SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('30130015', '30130086', '30130087', '30130025', '30130067', '30130070', '30130088', '30937099', '33102344') AND a.supplierId=151) OR ( a.articleSearch IN ('11990249301', '11990253201', '11990253301', '33990032901', '43991019101', '43991698001', '41991161901', '43991697801') AND a.supplierId=4346) OR ( a.articleSearch IN ('50364', '51489', '58390', '58391') AND a.supplierId=6558) OR ( a.articleSearch IN ('17825', '23322', '233221', '23323', '233232', '233233', '23347') AND a.supplierId=317) OR a.articleSearch='99841' AND a.supplierId=4576) OR ( a.articleSearch IN ('110046910', '130027610', '130027710', '130033210', '130063110', '130064410', '130064510') AND a.supplierId=323) OR ( a.articleSearch IN ('0011028263', '0011028438', '0023003934', '0023003989') AND a.supplierId=4995) OR ( a.articleSearch IN ('046278B', '046976B', '047334B', '047335B') AND a.supplierId=49) OR ( a.articleSearch IN ('MT8562', 'MT8563', 'MT9188', 'MT9517', 'MT9541', 'MT9755', 'MT9762') AND a.supplierId=478) OR ( a.articleSearch IN ('50515', '50517', '50518', '51078', '51101', '51293', '52098', '52133', '52596', '5698', '5699') AND a.supplierId=208) OR ( a.articleSearch IN ('87577A', '87751A', '87767A', '88023A', '88036A', '88278A', '88348A') AND a.supplierId=14) OR ( a.articleSearch IN ('701399201AH', '701399207B', '701399207BBUJE', '7D0199132D', '7D0199132E') AND a.supplierId=6366) OR ( a.articleSearch IN ('BSG90700050', 'BSG90700052', 'BSG90700053', 'BSG90700234', 'BSG90700271', 'BSG90700299') AND a.supplierId=4455) OR a.articleSearch='BSP20823' AND a.supplierId=157) OR ( a.articleSearch IN ('460159', '460160', '460630', '461037', '461039', '461149', '461150', '461229', '462622', '767505') AND a.supplierId=405) OR a.articleSearch='503885' AND a.supplierId=6263) OR ( a.articleSearch IN ('7122703', '7122704', '7122705', '7222734', '7222735', '7222741') AND a.supplierId=4135) OR ( a.articleSearch IN ('31ST815', '31ST817', '31TM817') AND a.supplierId=4003) OR ( a.articleSearch IN ('2726', '2755', '2756', '2769', '4777', '4796', '4959') AND a.supplierId=4834) OR ( a.articleSearch IN ('FZ90448', 'FZ90481', 'FZ90482', 'FZ90483', 'FZ90534', 'FZ90777') AND a.supplierId=4467) OR ( a.articleSearch IN ('EM0280', 'EM0609', 'EM0655', 'EM0660', 'GM0029') AND a.supplierId=6443) OR ( a.articleSearch IN ('510323', '512762', '513402', '518944', '530358', '530642') AND a.supplierId=373) OR ( a.articleSearch IN ('594267', '594293', '594674', '594712') AND a.supplierId=239) OR ( a.articleSearch IN ('890005', '890006', '890009', '890115') AND a.supplierId=185) OR ( a.articleSearch IN ('1480010', '1480020', '1490009', '1490010', '1490030', '1490066', '1490068') AND a.supplierId=4546) OR ( a.articleSearch IN ('36859', '36930', '36932', '36960', '37809', '37866', '37867') AND a.supplierId=133) OR ( a.articleSearch IN ('400164', '400237', '400437', '760194', '760212', '760213', '760214', '760215', '760216') AND a.supplierId=403) OR ( a.articleSearch IN ('8050930', '8053693', '8053694') AND a.supplierId=94) OR ( a.articleSearch IN ('1225540', '1225541', '1225542', '1225543', '1225545', '1225546', '1225547') AND a.supplierId=198) OR ( a.articleSearch IN ('F85531', 'F87047', 'F87748', 'F87749') AND a.supplierId=129) OR ( a.articleSearch IN ('32392', '32393', '37263', '37275', '37349', '37564', '37565', '37566', '37567', '37596', '32391') AND a.supplierId=331) OR ( a.articleSearch IN ('04090', '10280', '11224', '13974', '21685', '40192') AND a.supplierId=4683) OR ( a.articleSearch IN ('10150156', '10150166', '10150204', '10150218', '10150219', '10150534') AND a.supplierId=4686) OR ( a.articleSearch IN ('R54170', 'R54213') AND a.supplierId=4303) OR ( a.articleSearch IN ('RH110029', 'RH110042', 'RH110054', 'RH110129', 'RH110132', 'RH120012', 'RH120013', 'RH120014', 'RH120036') AND a.supplierId=6892) OR ( a.articleSearch IN ('BCSC137', 'BCVWEM063', 'BCVWEM064', 'BCVWEM065') AND a.supplierId=6698) OR ( a.articleSearch IN ('325442', '325443', '325477', '325479', '325480', '335404') AND a.supplierId=23) OR ( a.articleSearch IN ('T401031', 'T404325', 'T404356', 'T404357', 'T404371', 'T404750', 'T404751', 'T404764', 'T441611', 'T449100') AND a.supplierId=4667) OR ( a.articleSearch IN ('6105332', '6105333', '6105334', '6205363', '6205364', '6205370') AND a.supplierId=4758) OR ( a.articleSearch IN ('SC137', 'VWEM063', 'VWEM064', 'VWEM065') AND a.supplierId=4414) OR ( a.articleSearch IN ('AWSVW1003', 'AWSVW1004', 'AWSVW1008') AND a.supplierId=4340) OR ( a.articleSearch IN ('104050', '104051', '104052', '107403', '107964', '107976', '110141', '110316', '116617') AND a.supplierId=301) OR ( a.articleSearch IN ('362302', '363866', '363867') AND a.supplierId=4970) OR a.articleSearch='61116' AND a.supplierId=6311) OR ( a.articleSearch IN ('396166', '396167', '396168', '396169', '396170') AND a.supplierId=4730) OR ( a.articleSearch IN ('V100881', 'V101323', 'V101324', 'V101325', 'V101428', 'V101633', 'V108208', 'V108209', 'V108291') AND a.supplierId=183) OR ( a.articleSearch IN ('VE50515', 'VE50517', 'VE50518', 'VE51078', 'VE51293', 'VE52098', 'VE52596', 'VE5698', 'VE5699') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG1227083', 'WG1392253', 'WG1392295', 'WG1392304', 'WG1392305', 'WG1755664') AND a.supplierId=4832) OR ( a.articleSearch IN ('361277', '380435', '380449', '380567', '380605', '380607', '381235') AND a.supplierId=6347) OR ( a.articleSearch IN ('GM3037', 'GM4151') AND a.supplierId=4894)An internal server error occurred.