#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzV8fG1kZl9pZD09MV45OTc1fHxzcGFyZV9pZD09MjAwMDc1&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 = "9975"
AND (
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "MD-805"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "G101"
AND av.ProductID IN (9))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 BF0 244"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4702
AND av.DataSupplierArticleNumber = "BS04-022"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4702
AND av.DataSupplierArticleNumber = "BS04-114"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4702
AND av.DataSupplierArticleNumber = "BS04-115"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4868
AND av.DataSupplierArticleNumber = "P550495"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4868
AND av.DataSupplierArticleNumber = "P551856"
AND av.ProductID IN (9))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "31431"
AND av.ProductID IN (9))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "35368"
AND av.ProductID IN (9))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "39384"
AND av.ProductID IN (9))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "26979"
AND av.ProductID IN (9))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "PE983/1"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4581
AND av.DataSupplierArticleNumber = "FS19527"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4663
AND av.DataSupplierArticleNumber = "FG 1065 ECO"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H17WK04"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H17WK11"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H7090WK30"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4605"
AND av.ProductID IN (9))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "KC 184"
AND av.ProductID IN (9))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "KC 94"
AND av.ProductID IN (9))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "KC 94"
AND av.ProductID IN (9))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "KC 184"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "PU 941/1 x"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4605"
AND av.ProductID IN (9))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELG5519"
AND av.ProductID IN (9))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELG5538"
AND av.ProductID IN (9))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "034 009 0003"
AND av.ProductID IN (9))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "834 009 0007"
AND av.ProductID IN (9))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "834 323 0002"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "M335"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4944
AND av.DataSupplierArticleNumber = "152017"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4944
AND av.DataSupplierArticleNumber = "509002"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4996
AND av.DataSupplierArticleNumber = "690-10M-24"
AND av.ProductID IN (600))
OR
(av.SupplierID = 4996
AND av.DataSupplierArticleNumber = "PFF5605"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4996
AND av.DataSupplierArticleNumber = "KR 27004"
AND av.ProductID IN (600))
OR
(av.SupplierID = 4996
AND av.DataSupplierArticleNumber = "R90P"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "043.125"
AND av.ProductID IN (3362))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "042.322"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "042.313"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "202.426"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "042.314"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "022.382"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "042.155"
AND av.ProductID IN (3362))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "042.321"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4623
AND av.DataSupplierArticleNumber = "042.312"
AND av.ProductID IN (9))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SC 7045 P"
AND av.ProductID IN (9))
OR
(av.SupplierID = 92
AND av.DataSupplierArticleNumber = "FP5836"
AND av.ProductID IN (9))
OR
(av.SupplierID = 92
AND av.DataSupplierArticleNumber = "FT5598"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "82-00411-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "82-00418-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "81-32303-SX"
AND av.ProductID IN (600))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1214766"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1214801"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1214857"
AND av.ProductID IN (9))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "95044E"
AND av.ProductID IN (9))
)
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 = 180
AND aa.DataSupplierArticleNumber = "MD-805")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G101")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 BF0 244")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-022")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-114")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-115")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P550495")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P551856")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "31431")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "35368")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "39384")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26979")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PE983/1")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "FS19527")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "FG 1065 ECO")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H17WK04")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H17WK11")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H7090WK30")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4605")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KC 184")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KC 94")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KC 94")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KC 184")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "PU 941/1 x")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4605")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5519")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5538")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "034 009 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "834 009 0007")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "834 323 0002")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "M335")
OR
(aa.SupplierID = 4944
AND aa.DataSupplierArticleNumber = "152017")
OR
(aa.SupplierID = 4944
AND aa.DataSupplierArticleNumber = "509002")
OR
(aa.SupplierID = 4996
AND aa.DataSupplierArticleNumber = "690-10M-24")
OR
(aa.SupplierID = 4996
AND aa.DataSupplierArticleNumber = "PFF5605")
OR
(aa.SupplierID = 4996
AND aa.DataSupplierArticleNumber = "KR 27004")
OR
(aa.SupplierID = 4996
AND aa.DataSupplierArticleNumber = "R90P")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "043.125")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.322")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.313")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "202.426")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.314")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.382")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.155")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.321")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.312")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SC 7045 P")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FP5836")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FT5598")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "82-00411-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "82-00418-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-32303-SX")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214766")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214801")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214857")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "95044E")
)
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 = 180
AND aa.DataSupplierArticleNumber = "MD-805")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G101")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 BF0 244")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-022")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-114")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS04-115")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P550495")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P551856")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "31431")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "35368")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "39384")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26979")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PE983/1")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "FS19527")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "FG 1065 ECO")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H17WK04")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H17WK11")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H7090WK30")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4605")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KC 184")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KC 94")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KC 94")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KC 184")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "PU 941/1 x")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4605")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5519")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5538")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "034 009 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "834 009 0007")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "834 323 0002")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "M335")
OR
(aa.SupplierID = 4944
AND aa.DataSupplierArticleNumber = "152017")
OR
(aa.SupplierID = 4944
AND aa.DataSupplierArticleNumber = "509002")
OR
(aa.SupplierID = 4996
AND aa.DataSupplierArticleNumber = "690-10M-24")
OR
(aa.SupplierID = 4996
AND aa.DataSupplierArticleNumber = "PFF5605")
OR
(aa.SupplierID = 4996
AND aa.DataSupplierArticleNumber = "KR 27004")
OR
(aa.SupplierID = 4996
AND aa.DataSupplierArticleNumber = "R90P")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "043.125")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.322")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.313")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "202.426")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.314")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "022.382")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.155")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.321")
OR
(aa.SupplierID = 4623
AND aa.DataSupplierArticleNumber = "042.312")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SC 7045 P")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FP5836")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FT5598")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "82-00411-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "82-00418-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-32303-SX")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214766")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214801")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214857")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "95044E")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Топливный фильтр / корпус для автомобилей