SELECT DISTINCT
m.manufacturerName AS cross_brand,
ao.manufacturerId,
ao.oemSearch,
ao.oemnumber,
ps.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 ('0709Q', '0710Q') AND a.supplierId=206) OR (a.articleSearch='03013791672' AND a.supplierId=3) OR ( a.articleSearch IN ('D3894A', 'D3898A') AND a.supplierId=351) OR ( a.articleSearch IN ('1987475122', '1987475135') AND a.supplierId=30) OR ( a.articleSearch IN ('LY1133', 'LY1134') AND a.supplierId=89) OR ( a.articleSearch IN ('310009', '310013') AND a.supplierId=4512) OR ( a.articleSearch IN ('950709', '950710') AND a.supplierId=380) OR ( a.articleSearch IN ('1264001210', '1264001110') AND a.supplierId=268) OR ( a.articleSearch IN ('9166', '9167') AND a.supplierId=133) OR ( a.articleSearch IN ('7936709', '7936710', '7936717', '7936734', '7936745') AND a.supplierId=127) OR ( a.articleSearch IN ('PSRK0032', 'PSRK0044') AND a.supplierId=4558) OR (a.articleSearch='10253004' AND a.supplierId=6304) OR ( a.articleSearch IN ('97008200', '97008300') AND a.supplierId=39) OR ( a.articleSearch IN ('SFK224', 'SFK225', 'SFK283') AND a.supplierId=4501) OR (a.articleSearch='BR1502' AND a.supplierId=4894) OR ( a.articleSearch IN ('53673', '53674') AND a.supplierId=6558) OR ( a.articleSearch IN ('SK0709', 'SK0710') AND a.supplierId=4872) OR ( a.articleSearch IN ('9051', '9052') AND a.supplierId=311) OR ( a.articleSearch IN ('B160031', 'B160077') AND a.supplierId=186) OR ( a.articleSearch IN ('9051', '9052') AND a.supplierId=295) OR ( a.articleSearch IN ('8DZ355200241', '8DZ355200251') AND a.supplierId=4734) OR ( a.articleSearch IN ('1070011', '1070012') AND a.supplierId=185) OR (a.articleSearch='03013791672SETMS' AND a.supplierId=358) OR ( a.articleSearch IN ('270369', '270370') AND a.supplierId=403) OR ( a.articleSearch IN ('9051', '9052') AND a.supplierId=121) OR ( a.articleSearch IN ('1050709', '1050710') AND a.supplierId=94) OR ( a.articleSearch IN ('MBA709', 'MBA710') AND a.supplierId=73) OR ( a.articleSearch IN ('18773', '18774') AND a.supplierId=4683) OR (a.articleSearch='1502A0011' AND a.supplierId=6358) OR ( a.articleSearch IN ('SK0709', 'SK0710') AND a.supplierId=6331) OR (a.articleSearch='SKAKB1580010' AND a.supplierId=6357) OR ( a.articleSearch IN ('0001500SX', '0001514SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('TX4004', 'TX4005') AND a.supplierId=4377) OR ( a.articleSearch IN ('9051', '9052') AND a.supplierId=199)
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск
