Запчасти для Корейских, Японских и Европейских Автомобилией

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='150096910' AND a.supplierId=323) OR (a.articleSearch='940038526010' AND a.supplierId=4723) OR ( a.articleSearch IN ('PCI1326', 'P180002') AND a.supplierId=4558) OR ( a.articleSearch IN ('202026', '202012') AND a.supplierId=301) OR (a.articleSearch='ZM016' AND a.supplierId=6444) OR (a.articleSearch='CIM60103AS' AND a.supplierId=484) OR (a.articleSearch='CME5836' AND a.supplierId=4334) OR (a.articleSearch='160912' AND a.supplierId=211) OR ( a.articleSearch IN ('1965025', '94025') AND a.supplierId=4005) OR (a.articleSearch='885014' AND a.supplierId=234) OR (a.articleSearch='03SKV907' AND a.supplierId=4969) OR (a.articleSearch='30836' AND a.supplierId=441) OR (a.articleSearch='940191' AND a.supplierId=4379) OR (a.articleSearch='5DA006623581' AND a.supplierId=4734) OR (a.articleSearch='8010015' AND a.supplierId=341) OR (a.articleSearch='15230' AND a.supplierId=269) OR (a.articleSearch='1292100300' AND a.supplierId=268) OR (a.articleSearch='465025' AND a.supplierId=4006) OR (a.articleSearch='LGK018068103' AND a.supplierId=6012) OR (a.articleSearch='DAB703' AND a.supplierId=4501) OR (a.articleSearch='80610' AND a.supplierId=133) OR (a.articleSearch='130066' AND a.supplierId=403) OR (a.articleSearch='EPS1965025' AND a.supplierId=4773) OR (a.articleSearch='10015' AND a.supplierId=244) OR (a.articleSearch='IGD1961HV' AND a.supplierId=4705) OR ( a.articleSearch IN ('01399', '08051', '08052') AND a.supplierId=4683) OR (a.articleSearch='XEI38' AND a.supplierId=57) OR (a.articleSearch='30109301BN' AND a.supplierId=6335) OR (a.articleSearch='SIM601030' AND a.supplierId=4592) OR (a.articleSearch='30836' AND a.supplierId=27) OR ( a.articleSearch IN ('0670607SX', '1125435SX') AND a.supplierId=4595) OR (a.articleSearch='V40700079' AND a.supplierId=183) OR ( a.articleSearch IN ('DM1961', 'ICM316') AND a.supplierId=4627) OR (a.articleSearch='220820012' AND a.supplierId=4275) OR (a.articleSearch='WG1014739' AND a.supplierId=4832) OR (a.articleSearch='560619' AND a.supplierId=6347) Запчасти для Корейских, Японских и Европейских Автомобилией