#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTU2NDZ8fG1kZl9pZD09MV4xMzQzM3x8c3BhcmVfaWQ9PTIwMDMzOA%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 articlecommercialvehicles av
JOIN commercialvehiclelinkageattributes_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 = "13433"
AND (
(av.SupplierID = 283
AND av.DataSupplierArticleNumber = "44118"
AND av.ProductID IN (82))
OR
(av.SupplierID = 283
AND av.DataSupplierArticleNumber = "44122"
AND av.ProductID IN (82))
OR
(av.SupplierID = 264
AND av.DataSupplierArticleNumber = "BCR145A"
AND av.ProductID IN (82))
OR
(av.SupplierID = 264
AND av.DataSupplierArticleNumber = "BCR323A"
AND av.ProductID IN (82))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "09.A741.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "09.B325.30"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4872
AND av.DataSupplierArticleNumber = "DB0323V"
AND av.ProductID IN (82))
OR
(av.SupplierID = 278
AND av.DataSupplierArticleNumber = "CVD670"
AND av.ProductID IN (82))
OR
(av.SupplierID = 278
AND av.DataSupplierArticleNumber = "CVD552"
AND av.ProductID IN (82))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "29167"
AND av.ProductID IN (82))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "22677"
AND av.ProductID IN (82))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "FCR323A"
AND av.ProductID IN (82))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "FCR145A"
AND av.ProductID IN (82))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "567751J"
AND av.ProductID IN (82))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "569160J"
AND av.ProductID IN (82))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "015 521 2043"
AND av.ProductID IN (82))
OR
(av.SupplierID = 63
AND av.DataSupplierArticleNumber = "016.295-00A"
AND av.ProductID IN (82))
OR
(av.SupplierID = 63
AND av.DataSupplierArticleNumber = "016.672-00A"
AND av.ProductID IN (82))
OR
(av.SupplierID = 63
AND av.DataSupplierArticleNumber = "016.677-00A"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "100.431"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "100.462"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4699
AND av.DataSupplierArticleNumber = "02-ME006"
AND av.ProductID IN (82))
OR
(av.SupplierID = 336
AND av.DataSupplierArticleNumber = "03.110.1926.360"
AND av.ProductID IN (82))
OR
(av.SupplierID = 336
AND av.DataSupplierArticleNumber = "03.110.1926.000"
AND av.ProductID IN (82,82))
OR
(av.SupplierID = 336
AND av.DataSupplierArticleNumber = "03.110.1926.190"
AND av.ProductID IN (82,82))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "93087900"
AND av.ProductID IN (82))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "93186700"
AND av.ProductID IN (82))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "DF5025S"
AND av.ProductID IN (82))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "DF5010S"
AND av.ProductID IN (82))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V31-80001"
AND av.ProductID IN (82))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V31-80004"
AND av.ProductID IN (82))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "187051"
AND av.ProductID IN (82))
OR
(av.SupplierID = 456
AND av.DataSupplierArticleNumber = "628.2616"
AND av.ProductID IN (82))
OR
(av.SupplierID = 456
AND av.DataSupplierArticleNumber = "628.2708"
AND av.ProductID IN (82))
OR
(av.SupplierID = 22
AND av.DataSupplierArticleNumber = "12 999 804"
AND av.ProductID IN (82))
)
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 = 283
AND aa.DataSupplierArticleNumber = "44118")
OR
(aa.SupplierID = 283
AND aa.DataSupplierArticleNumber = "44122")
OR
(aa.SupplierID = 264
AND aa.DataSupplierArticleNumber = "BCR145A")
OR
(aa.SupplierID = 264
AND aa.DataSupplierArticleNumber = "BCR323A")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "09.A741.10")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "09.B325.30")
OR
(aa.SupplierID = 4872
AND aa.DataSupplierArticleNumber = "DB0323V")
OR
(aa.SupplierID = 278
AND aa.DataSupplierArticleNumber = "CVD670")
OR
(aa.SupplierID = 278
AND aa.DataSupplierArticleNumber = "CVD552")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "29167")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "22677")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCR323A")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCR145A")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "567751J")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "569160J")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "015 521 2043")
OR
(aa.SupplierID = 63
AND aa.DataSupplierArticleNumber = "016.295-00A")
OR
(aa.SupplierID = 63
AND aa.DataSupplierArticleNumber = "016.672-00A")
OR
(aa.SupplierID = 63
AND aa.DataSupplierArticleNumber = "016.677-00A")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "100.431")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "100.462")
OR
(aa.SupplierID = 4699
AND aa.DataSupplierArticleNumber = "02-ME006")
OR
(aa.SupplierID = 336
AND aa.DataSupplierArticleNumber = "03.110.1926.360")
OR
(aa.SupplierID = 336
AND aa.DataSupplierArticleNumber = "03.110.1926.000")
OR
(aa.SupplierID = 336
AND aa.DataSupplierArticleNumber = "03.110.1926.190")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "93087900")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "93186700")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF5025S")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF5010S")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V31-80001")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V31-80004")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "187051")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.2616")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.2708")
OR
(aa.SupplierID = 22
AND aa.DataSupplierArticleNumber = "12 999 804")
)
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 = 283
AND aa.DataSupplierArticleNumber = "44118")
OR
(aa.SupplierID = 283
AND aa.DataSupplierArticleNumber = "44122")
OR
(aa.SupplierID = 264
AND aa.DataSupplierArticleNumber = "BCR145A")
OR
(aa.SupplierID = 264
AND aa.DataSupplierArticleNumber = "BCR323A")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "09.A741.10")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "09.B325.30")
OR
(aa.SupplierID = 4872
AND aa.DataSupplierArticleNumber = "DB0323V")
OR
(aa.SupplierID = 278
AND aa.DataSupplierArticleNumber = "CVD670")
OR
(aa.SupplierID = 278
AND aa.DataSupplierArticleNumber = "CVD552")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "29167")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "22677")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCR323A")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCR145A")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "567751J")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "569160J")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "015 521 2043")
OR
(aa.SupplierID = 63
AND aa.DataSupplierArticleNumber = "016.295-00A")
OR
(aa.SupplierID = 63
AND aa.DataSupplierArticleNumber = "016.672-00A")
OR
(aa.SupplierID = 63
AND aa.DataSupplierArticleNumber = "016.677-00A")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "100.431")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "100.462")
OR
(aa.SupplierID = 4699
AND aa.DataSupplierArticleNumber = "02-ME006")
OR
(aa.SupplierID = 336
AND aa.DataSupplierArticleNumber = "03.110.1926.360")
OR
(aa.SupplierID = 336
AND aa.DataSupplierArticleNumber = "03.110.1926.000")
OR
(aa.SupplierID = 336
AND aa.DataSupplierArticleNumber = "03.110.1926.190")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "93087900")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "93186700")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF5025S")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF5010S")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V31-80001")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V31-80004")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "187051")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.2616")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.2708")
OR
(aa.SupplierID = 22
AND aa.DataSupplierArticleNumber = "12 999 804")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Тормозные диски для автомобилей