#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTE0NTd8fG1kZl9pZD09MF41MTQ0fHxzcGFyZV9pZD09MTAwNDA1&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 = "5144"
AND (
(av.SupplierID = 220
AND av.DataSupplierArticleNumber = "WPK-136102"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 300
AND av.DataSupplierArticleNumber = "702146"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4651
AND av.DataSupplierArticleNumber = "04.5211"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "KATW1087B"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "KAT1087"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "KATW1087"
AND av.ProductID IN (307))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 946 409"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 946 357"
AND av.ProductID IN (307))
OR
(av.SupplierID = 195
AND av.DataSupplierArticleNumber = "KPA0103A"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 195
AND av.DataSupplierArticleNumber = "KCD0103"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4463
AND av.DataSupplierArticleNumber = "0014KFWB"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4463
AND av.DataSupplierArticleNumber = "0014KF"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4463
AND av.DataSupplierArticleNumber = "0014KFW"
AND av.ProductID IN (307))
OR
(av.SupplierID = 243
AND av.DataSupplierArticleNumber = "DKS04.5211"
AND av.ProductID IN (307))
OR
(av.SupplierID = 243
AND av.DataSupplierArticleNumber = "KPA36034A"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 31
AND av.DataSupplierArticleNumber = "CT754K1"
AND av.ProductID IN (307))
OR
(av.SupplierID = 42
AND av.DataSupplierArticleNumber = "KTB114"
AND av.ProductID IN (307))
OR
(av.SupplierID = 42
AND av.DataSupplierArticleNumber = "KTBWP1140"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "KWP1601114"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "KDB114"
AND av.ProductID IN (307))
OR
(av.SupplierID = 154
AND av.DataSupplierArticleNumber = "KD028"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "TBK10"
AND av.ProductID IN (307))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "F914104V"
AND av.ProductID IN (307))
OR
(av.SupplierID = 33
AND av.DataSupplierArticleNumber = "KP25215XS-1"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 33
AND av.DataSupplierArticleNumber = "K025215XS"
AND av.ProductID IN (307))
OR
(av.SupplierID = 368
AND av.DataSupplierArticleNumber = "KPA20028"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 181
AND av.DataSupplierArticleNumber = "K986836D"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 178
AND av.DataSupplierArticleNumber = "20-1141"
AND av.ProductID IN (307))
OR
(av.SupplierID = 178
AND av.DataSupplierArticleNumber = "PK08363"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "KH 25"
AND av.ProductID IN (307))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "KH 25WP12"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 204
AND av.DataSupplierArticleNumber = "530 0258 10"
AND av.ProductID IN (307))
OR
(av.SupplierID = 204
AND av.DataSupplierArticleNumber = "530 0258 31"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 262
AND av.DataSupplierArticleNumber = "20-1141"
AND av.ProductID IN (307))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "4112101419"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4462
AND av.DataSupplierArticleNumber = "WKFI014B"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4462
AND av.DataSupplierArticleNumber = "KFI014"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4462
AND av.DataSupplierArticleNumber = "WKFI014"
AND av.ProductID IN (307))
OR
(av.SupplierID = 424
AND av.DataSupplierArticleNumber = "LDK0225"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "PK-1108"
AND av.ProductID IN (307))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "341301890000"
AND av.ProductID IN (307))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "341310291202"
AND av.ProductID IN (307))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "23414"
AND av.ProductID IN (307))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "41414/1"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "WM-Z 900"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVTT287"
AND av.ProductID IN (307))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "10119010"
AND av.ProductID IN (307))
OR
(av.SupplierID = 64
AND av.DataSupplierArticleNumber = "KT 1068"
AND av.ProductID IN (307))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "SK-1019"
AND av.ProductID IN (307))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QBK120"
AND av.ProductID IN (307))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "MBK120"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4330
AND av.DataSupplierArticleNumber = "RKTK1022"
AND av.ProductID IN (307))
OR
(av.SupplierID = 100
AND av.DataSupplierArticleNumber = "RR1029K2"
AND av.ProductID IN (307))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "56620702"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "5662070"
AND av.ProductID IN (307))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "1750024"
AND av.ProductID IN (307))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "3900024"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 50
AND av.DataSupplierArticleNumber = "VKMA 03201"
AND av.ProductID IN (307))
OR
(av.SupplierID = 110
AND av.DataSupplierArticleNumber = "KDP459.081"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 110
AND av.DataSupplierArticleNumber = "KD459.08"
AND av.ProductID IN (307))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "720 143"
AND av.ProductID IN (307))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8647 10006"
AND av.ProductID IN (307))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V42-4173"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "65013640"
AND av.ProductID IN (307,307))
OR
(av.SupplierID = 179
AND av.DataSupplierArticleNumber = "K2G1133H"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1238376"
AND av.ProductID IN (3096))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1142011"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1251520"
AND av.ProductID IN (307))
)
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 = 220
AND aa.DataSupplierArticleNumber = "WPK-136102")
OR
(aa.SupplierID = 300
AND aa.DataSupplierArticleNumber = "702146")
OR
(aa.SupplierID = 4651
AND aa.DataSupplierArticleNumber = "04.5211")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KATW1087B")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KAT1087")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KATW1087")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 946 409")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 946 357")
OR
(aa.SupplierID = 195
AND aa.DataSupplierArticleNumber = "KPA0103A")
OR
(aa.SupplierID = 195
AND aa.DataSupplierArticleNumber = "KCD0103")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0014KFWB")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0014KF")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0014KFW")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "DKS04.5211")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "KPA36034A")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "CT754K1")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "KTB114")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "KTBWP1140")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "KWP1601114")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "KDB114")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "KD028")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "TBK10")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "F914104V")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "KP25215XS-1")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "K025215XS")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "KPA20028")
OR
(aa.SupplierID = 181
AND aa.DataSupplierArticleNumber = "K986836D")
OR
(aa.SupplierID = 178
AND aa.DataSupplierArticleNumber = "20-1141")
OR
(aa.SupplierID = 178
AND aa.DataSupplierArticleNumber = "PK08363")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "KH 25")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "KH 25WP12")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "530 0258 10")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "530 0258 31")
OR
(aa.SupplierID = 262
AND aa.DataSupplierArticleNumber = "20-1141")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "4112101419")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "WKFI014B")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "KFI014")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "WKFI014")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LDK0225")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "PK-1108")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "341301890000")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "341310291202")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "23414")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "41414/1")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "WM-Z 900")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVTT287")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "10119010")
OR
(aa.SupplierID = 64
AND aa.DataSupplierArticleNumber = "KT 1068")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "SK-1019")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBK120")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "MBK120")
OR
(aa.SupplierID = 4330
AND aa.DataSupplierArticleNumber = "RKTK1022")
OR
(aa.SupplierID = 100
AND aa.DataSupplierArticleNumber = "RR1029K2")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "56620702")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "5662070")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1750024")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "3900024")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMA 03201")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "KDP459.081")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "KD459.08")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "720 143")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8647 10006")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V42-4173")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "65013640")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "K2G1133H")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1238376")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1142011")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1251520")
)
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 = 220
AND aa.DataSupplierArticleNumber = "WPK-136102")
OR
(aa.SupplierID = 300
AND aa.DataSupplierArticleNumber = "702146")
OR
(aa.SupplierID = 4651
AND aa.DataSupplierArticleNumber = "04.5211")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KATW1087B")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KAT1087")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KATW1087")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 946 409")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 946 357")
OR
(aa.SupplierID = 195
AND aa.DataSupplierArticleNumber = "KPA0103A")
OR
(aa.SupplierID = 195
AND aa.DataSupplierArticleNumber = "KCD0103")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0014KFWB")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0014KF")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0014KFW")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "DKS04.5211")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "KPA36034A")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "CT754K1")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "KTB114")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "KTBWP1140")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "KWP1601114")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "KDB114")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "KD028")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "TBK10")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "F914104V")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "KP25215XS-1")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "K025215XS")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "KPA20028")
OR
(aa.SupplierID = 181
AND aa.DataSupplierArticleNumber = "K986836D")
OR
(aa.SupplierID = 178
AND aa.DataSupplierArticleNumber = "20-1141")
OR
(aa.SupplierID = 178
AND aa.DataSupplierArticleNumber = "PK08363")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "KH 25")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "KH 25WP12")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "530 0258 10")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "530 0258 31")
OR
(aa.SupplierID = 262
AND aa.DataSupplierArticleNumber = "20-1141")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "4112101419")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "WKFI014B")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "KFI014")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "WKFI014")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LDK0225")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "PK-1108")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "341301890000")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "341310291202")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "23414")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "41414/1")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "WM-Z 900")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVTT287")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "10119010")
OR
(aa.SupplierID = 64
AND aa.DataSupplierArticleNumber = "KT 1068")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "SK-1019")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBK120")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "MBK120")
OR
(aa.SupplierID = 4330
AND aa.DataSupplierArticleNumber = "RKTK1022")
OR
(aa.SupplierID = 100
AND aa.DataSupplierArticleNumber = "RR1029K2")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "56620702")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "5662070")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1750024")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "3900024")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMA 03201")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "KDP459.081")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "KD459.08")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "720 143")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8647 10006")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V42-4173")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "65013640")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "K2G1133H")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1238376")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1142011")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1251520")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Комплект ремней ГРМ для автомобилей