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='125907' AND a.supplierId=367) OR (a.articleSearch='72405' AND a.supplierId=4598) OR ( a.articleSearch IN ('CSC210', 'CSC48') AND a.supplierId=6362) OR (a.articleSearch='140025210' AND a.supplierId=323) OR (a.articleSearch='251860' AND a.supplierId=41) OR (a.articleSearch='752396' AND a.supplierId=405) OR (a.articleSearch='499118' AND a.supplierId=29) OR (a.articleSearch='1607361680' AND a.supplierId=4391) OR (a.articleSearch='2620' AND a.supplierId=4834) OR (a.articleSearch='AA98006' AND a.supplierId=4328) OR (a.articleSearch='X80118' AND a.supplierId=415) OR (a.articleSearch='83141660' AND a.supplierId=118) OR (a.articleSearch='096002' AND a.supplierId=191) OR (a.articleSearch='251860' AND a.supplierId=78) OR (a.articleSearch='0591550' AND a.supplierId=4546) OR (a.articleSearch='02620' AND a.supplierId=4664) OR (a.articleSearch='T402620' AND a.supplierId=4667) OR (a.articleSearch='0710562SX' AND a.supplierId=4595) OR (a.articleSearch='201737' AND a.supplierId=301) OR (a.articleSearch='AA98006' AND a.supplierId=357)
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск
