#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTg3NHx8bW9kZWxfaWQ9PTk2MzB8fG1kZl9pZD09MF4xMDQ4NHx8c3BhcmVfaWQ9PTEwMjIwOA%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 = "10484"
AND (
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "116900"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "5015"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "5038"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "5039"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "21754"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "26746"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "23930"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "26748"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "23932"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "26461"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000419"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000420"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "99 90 0001"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "30 92 6461"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "99 90 0004"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "32 92 3930"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "32 92 3932"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 92 1754"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0236"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0075"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0237"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0111"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0242"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0235"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0074"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0243"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "402402"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "402403"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "402406"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "402401"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 188
AND av.DataSupplierArticleNumber = "5015"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 188
AND av.DataSupplierArticleNumber = "5038"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 188
AND av.DataSupplierArticleNumber = "5039"
AND av.ProductID IN (3357))
)
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 = 4668
AND aa.DataSupplierArticleNumber = "116900")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "5015")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "5038")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "5039")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "21754")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26746")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "23930")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26748")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "23932")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26461")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000419")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000420")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 0001")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "30 92 6461")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 0004")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "32 92 3930")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "32 92 3932")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 1754")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0236")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0075")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0237")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0111")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0242")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0235")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0074")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0243")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402402")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402403")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402406")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402401")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5015")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5038")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5039")
)
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 = 4668
AND aa.DataSupplierArticleNumber = "116900")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "5015")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "5038")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "5039")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "21754")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26746")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "23930")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26748")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "23932")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26461")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000419")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000420")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 0001")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "30 92 6461")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 0004")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "32 92 3930")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "32 92 3932")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 1754")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0236")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0075")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0237")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0111")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0242")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0235")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0074")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0243")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402402")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402403")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402406")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402401")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5015")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5038")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5039")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Тормозная жидкость для автомобилей