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 IN ('030793', '030792') AND a.supplierId=10) OR ( a.articleSearch IN ('KCA015', 'KCA016', 'KCA040') AND a.supplierId=4464) OR (a.articleSearch='BGSILC' AND a.supplierId=478) OR ( a.articleSearch IN ('KCC015', 'KCC016', 'KCC040') AND a.supplierId=4463) OR (a.articleSearch='116290' AND a.supplierId=355) OR (a.articleSearch='RS0069' AND a.supplierId=4514) OR (a.articleSearch='703141410' AND a.supplierId=88) OR (a.articleSearch='3400042000' AND a.supplierId=60) OR ( a.articleSearch IN ('KCD015', 'KCD016', 'KCD040') AND a.supplierId=4462) OR ( a.articleSearch IN ('HR397', 'HR397T') AND a.supplierId=113) OR (a.articleSearch='1129017SX' AND a.supplierId=4595) OR (a.articleSearch='038103085' AND a.supplierId=4999) OR ( a.articleSearch IN ('702843700', '703141410', '703141420') AND a.supplierId=9) OR ( a.articleSearch IN ('11030366501', '11031354201') AND a.supplierId=4346) OR (a.articleSearch='WG2047309' AND a.supplierId=4832)
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск
