#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzM3x8bW9kZWxfaWQ9PTEyNTB8fG1kZl9pZD09MF4xODAxOXx8c3BhcmVfaWQ9PTEwMDYzMA%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 = "18019"
AND (
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "1087Q"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.0460-0308.2"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "A 02 336"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "LX0194"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8DZ 355 204-871"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8DZ 355 204-871"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 55
AND av.DataSupplierArticleNumber = "J3664003"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "792250J"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "109-1087"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 73
AND av.DataSupplierArticleNumber = "MBA1022"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "7926087"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "BFK673"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "BFK768"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "82044800"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8105 401610"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "PFK265"
AND av.ProductID IN (1164))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "PFK333"
AND av.ProductID IN (1164))
)
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 = 206
AND aa.DataSupplierArticleNumber = "1087Q")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0460-0308.2")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "A 02 336")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LX0194")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DZ 355 204-871")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DZ 355 204-871")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J3664003")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "792250J")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "109-1087")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MBA1022")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "7926087")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BFK673")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BFK768")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "82044800")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8105 401610")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "PFK265")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "PFK333")
)
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 = 206
AND aa.DataSupplierArticleNumber = "1087Q")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0460-0308.2")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "A 02 336")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LX0194")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DZ 355 204-871")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DZ 355 204-871")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J3664003")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "792250J")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "109-1087")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MBA1022")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "7926087")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BFK673")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BFK768")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "82044800")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8105 401610")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "PFK265")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "PFK333")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Комплектующие / составляющие для автомобилей