#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTY0MTd8fG1kZl9pZD09MV45Mjk3fHxzcGFyZV9pZD09MjAwNjQ4&st=50
SELECT
CONCAT(av.SupplierID, "^", av.DataSupplierArticleNumber) AS article_id,
d.`Description` AS crit_designation,
dv.`DisplayValue` AS crit_value,
"" crit_unit,
2 criteria_art,
"articletypes" as source
FROM articlecommercialvehicles av
JOIN commercialvehiclelinkageattributes_ru vla
ON av.Idx = vla.Idx
JOIN linkageattributedescriptions d
ON vla.DescriptionIdx = d.Idx
JOIN linkageattributedisplayvalues dv
ON vla.DisplayValueIdx = dv.Idx
WHERE
av.VehicleID = "9297"
AND (
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9ES 354 984-061"
AND av.ProductID IN (14))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9ES 354 987-091"
AND av.ProductID IN (14))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9ES 354 987-101"
AND av.ProductID IN (14))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9ES 354 984-051"
AND av.ProductID IN (14))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "81658154"
AND av.ProductID IN (14))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "81658155"
AND av.ProductID IN (14))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "81658302"
AND av.ProductID IN (14))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "81658303"
AND av.ProductID IN (14))
OR
(av.SupplierID = 4657
AND av.DataSupplierArticleNumber = "47#449-1101LEND"
AND av.ProductID IN (14))
OR
(av.SupplierID = 4657
AND av.DataSupplierArticleNumber = "47#449-1101REND"
AND av.ProductID IN (14))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "022.350"
AND av.ProductID IN (3499))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "022.043"
AND av.ProductID IN (3499))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "1820 0222"
AND av.ProductID IN (101))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "022.044"
AND av.ProductID IN (3499))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "1820 0206"
AND av.ProductID IN (703))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "022.349"
AND av.ProductID IN (3499))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "1820 0207"
AND av.ProductID IN (703))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "1820 0217"
AND av.ProductID IN (101))
)
UNION ALL
SELECT
CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber)
as article_id,
if (aa.Description = "", aa.DisplayTitle, aa.Description)
as crit_designation,
aa.DisplayValue as crit_value,
"" crit_unit,
1 criteria_art,
"articleattributes" as source
FROM articleattributes aa
WHERE
(
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9ES 354 984-061")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9ES 354 987-091")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9ES 354 987-101")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9ES 354 984-051")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "81658154")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "81658155")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "81658302")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "81658303")
OR
(aa.SupplierID = 4657
AND aa.DataSupplierArticleNumber = "47#449-1101LEND")
OR
(aa.SupplierID = 4657
AND aa.DataSupplierArticleNumber = "47#449-1101REND")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.350")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.043")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "1820 0222")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.044")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "1820 0206")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.349")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "1820 0207")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "1820 0217")
)
AND aa.Language = "ru"
UNION ALL
SELECT
CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber)
as article_id,
if (aa.Description = "", aa.DisplayTitle, aa.Description)
as crit_designation,
aa.DisplayValue as crit_value,
"" crit_unit,
1 criteria_art,
"articleattributes_2018_2" as source
FROM articleattributes_2018_2 aa
WHERE
(
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9ES 354 984-061")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9ES 354 987-091")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9ES 354 987-101")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9ES 354 984-051")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "81658154")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "81658155")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "81658302")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "81658303")
OR
(aa.SupplierID = 4657
AND aa.DataSupplierArticleNumber = "47#449-1101LEND")
OR
(aa.SupplierID = 4657
AND aa.DataSupplierArticleNumber = "47#449-1101REND")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.350")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.043")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "1820 0222")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.044")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "1820 0206")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.349")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "1820 0207")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "1820 0217")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Комплектующие для автомобилей