#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTE2MzB8fG1kZl9pZD09MF4xMDY4Nnx8c3BhcmVfaWQ9PTEwMDE4MQ%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 = "10686"
AND (
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6504-03-9557592P"
AND av.ProductID IN (901))
OR
(av.SupplierID = 4555
AND av.DataSupplierArticleNumber = "6504-03-9557591P"
AND av.ProductID IN (901))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1180650570"
AND av.ProductID IN (901))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1180650580"
AND av.ProductID IN (901))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1180450770"
AND av.ProductID IN (901))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1180450780"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557002"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557602"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557595"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557562"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557531"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557596"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557593"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557532"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557001"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557601"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557594"
AND av.ProductID IN (901))
OR
(av.SupplierID = 78
AND av.DataSupplierArticleNumber = "9557561"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870147"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870144"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870141"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870148"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870145"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870142"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870133"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870146"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870143"
AND av.ProductID IN (901))
OR
(av.SupplierID = 36
AND av.DataSupplierArticleNumber = "5870134"
AND av.ProductID IN (901))
)
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 = 4555
AND aa.DataSupplierArticleNumber = "6504-03-9557592P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-9557591P")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1180650570")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1180650580")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1180450770")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1180450780")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557002")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557602")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557595")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557562")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557531")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557596")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557593")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557532")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557001")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557601")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557594")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557561")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870147")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870144")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870141")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870148")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870145")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870142")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870133")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870146")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870143")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870134")
)
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 = 4555
AND aa.DataSupplierArticleNumber = "6504-03-9557592P")
OR
(aa.SupplierID = 4555
AND aa.DataSupplierArticleNumber = "6504-03-9557591P")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1180650570")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1180650580")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1180450770")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1180450780")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557002")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557602")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557595")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557562")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557531")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557596")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557593")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557532")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557001")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557601")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557594")
OR
(aa.SupplierID = 78
AND aa.DataSupplierArticleNumber = "9557561")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870147")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870144")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870141")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870148")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870145")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870142")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870133")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870146")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870143")
OR
(aa.SupplierID = 36
AND aa.DataSupplierArticleNumber = "5870134")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Боковина для автомобилей