#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTgyNjB8fG1kZl9pZD09MF4zMzEzNXx8c3BhcmVfaWQ9PTEwMDM3MQ%3D%3D&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 articlepassengercars av
JOIN passengercarlinkageattributes_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 = "33135"
AND (
(av.SupplierID = 4674
AND av.DataSupplierArticleNumber = "KB-SL10F"
AND av.ProductID IN (1626))
OR
(av.SupplierID = 85
AND av.DataSupplierArticleNumber = "SM1005"
AND av.ProductID IN (1632))
OR
(av.SupplierID = 85
AND av.DataSupplierArticleNumber = "SM5850"
AND av.ProductID IN (1180))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "MK408"
AND av.ProductID IN (1180))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "H489I19"
AND av.ProductID IN (1180))
OR
(av.SupplierID = 331
AND av.DataSupplierArticleNumber = "70969/2"
AND av.ProductID IN (1632))
OR
(av.SupplierID = 331
AND av.DataSupplierArticleNumber = "70968"
AND av.ProductID IN (1626))
OR
(av.SupplierID = 331
AND av.DataSupplierArticleNumber = "70969"
AND av.ProductID IN (1632))
OR
(av.SupplierID = 331
AND av.DataSupplierArticleNumber = "70967"
AND av.ProductID IN (1180))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PSE4412"
AND av.ProductID IN (1626))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "EMR4935"
AND av.ProductID IN (1180))
)
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 = 4674
AND aa.DataSupplierArticleNumber = "KB-SL10F")
OR
(aa.SupplierID = 85
AND aa.DataSupplierArticleNumber = "SM1005")
OR
(aa.SupplierID = 85
AND aa.DataSupplierArticleNumber = "SM5850")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "MK408")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "H489I19")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "70969/2")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "70968")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "70969")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "70967")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PSE4412")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "EMR4935")
)
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 = 4674
AND aa.DataSupplierArticleNumber = "KB-SL10F")
OR
(aa.SupplierID = 85
AND aa.DataSupplierArticleNumber = "SM1005")
OR
(aa.SupplierID = 85
AND aa.DataSupplierArticleNumber = "SM5850")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "MK408")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "H489I19")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "70969/2")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "70968")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "70969")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "70967")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PSE4412")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "EMR4935")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Подвеска амортизатора/стойка амортизатора для автомобилей