#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4Nnx8bW9kZWxfaWQ9PTYzOTB8fG1kZl9pZD09MF4yNzYyNXx8c3BhcmVfaWQ9PTEwMjIwOA%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 = "27625"
AND (
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "5039"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E801410"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "26461"
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 = 222
AND av.DataSupplierArticleNumber = "P000418"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000421"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "BFE1000.10"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "BFE1000.05"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1350601"
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-0243"
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 = 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 = 21
AND av.DataSupplierArticleNumber = "402407"
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 = "402408"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "402403"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1054608"
AND av.ProductID IN (3357))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1306544"
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 = "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 = 189
AND aa.DataSupplierArticleNumber = "5039")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E801410")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26461")
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 = 222
AND aa.DataSupplierArticleNumber = "P000418")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000421")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "BFE1000.10")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "BFE1000.05")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1350601")
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-0243")
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 = 21
AND aa.DataSupplierArticleNumber = "402406")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402401")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402407")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402402")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402408")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402403")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1054608")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1306544")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5015")
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 = 189
AND aa.DataSupplierArticleNumber = "5039")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E801410")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26461")
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 = 222
AND aa.DataSupplierArticleNumber = "P000418")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000421")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "BFE1000.10")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "BFE1000.05")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1350601")
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-0243")
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 = 21
AND aa.DataSupplierArticleNumber = "402406")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402401")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402407")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402402")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402408")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "402403")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1054608")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1306544")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5015")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5039")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Тормозная жидкость для автомобилей