#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0OHx8bW9kZWxfaWQ9PTM2MjE2fHxtZGZfaWQ9PTBeMTE4NTkzfHxzcGFyZV9pZD09MTAwNTc3&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 = "118593"
AND (
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BDL7505"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "SS7485"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 4674
AND av.DataSupplierArticleNumber = "1223-IX35R"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 271
AND av.DataSupplierArticleNumber = "LS11011"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 271
AND av.DataSupplierArticleNumber = "LS11010"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FDL7505"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 55
AND av.DataSupplierArticleNumber = "J4890536"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "87165"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "81360"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "81361"
AND av.ProductID IN (3229))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "87164"
AND av.ProductID IN (3229))
)
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 = 475
AND aa.DataSupplierArticleNumber = "BDL7505")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS7485")
OR
(aa.SupplierID = 4674
AND aa.DataSupplierArticleNumber = "1223-IX35R")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "LS11011")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "LS11010")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FDL7505")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J4890536")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "87165")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "81360")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "81361")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "87164")
)
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 = 475
AND aa.DataSupplierArticleNumber = "BDL7505")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS7485")
OR
(aa.SupplierID = 4674
AND aa.DataSupplierArticleNumber = "1223-IX35R")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "LS11011")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "LS11010")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FDL7505")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J4890536")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "87165")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "81360")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "81361")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "87164")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Соединительная тяга для автомобилей