#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTQ4MDR8fG1kZl9pZD09MF4xODYwNXx8c3BhcmVfaWQ9PTEwMDQwNA%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 = "18605"
AND (
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 949 538"
AND av.ProductID IN (306))
OR
(av.SupplierID = 31
AND av.DataSupplierArticleNumber = "CT1028"
AND av.ProductID IN (306))
OR
(av.SupplierID = 42
AND av.DataSupplierArticleNumber = "94885"
AND av.ProductID IN (306))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TB6215"
AND av.ProductID IN (306))
OR
(av.SupplierID = 154
AND av.DataSupplierArticleNumber = "05KD020"
AND av.ProductID IN (306))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "70120"
AND av.ProductID IN (306))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "19540"
AND av.ProductID IN (306))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "4458V"
AND av.ProductID IN (306))
OR
(av.SupplierID = 33
AND av.DataSupplierArticleNumber = "5569XS"
AND av.ProductID IN (306))
OR
(av.SupplierID = 368
AND av.DataSupplierArticleNumber = "COKD020"
AND av.ProductID IN (306))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "120 HTDP 30"
AND av.ProductID IN (306))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1112101909"
AND av.ProductID IN (306))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "340018181107"
AND av.ProductID IN (306))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "94885"
AND av.ProductID IN (306))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VTB819"
AND av.ProductID IN (306))
OR
(av.SupplierID = 64
AND av.DataSupplierArticleNumber = "ZRK 1338"
AND av.ProductID IN (306))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QTB631"
AND av.ProductID IN (306))
OR
(av.SupplierID = 100
AND av.DataSupplierArticleNumber = "RR1107"
AND av.ProductID IN (306))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "1766010"
AND av.ProductID IN (306))
OR
(av.SupplierID = 50
AND av.DataSupplierArticleNumber = "VKMT 01142"
AND av.ProductID IN (306))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "30 91 9540"
AND av.ProductID IN (306))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "109 353"
AND av.ProductID IN (306))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8645 5569xs"
AND av.ProductID IN (306))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "07.12.098"
AND av.ProductID IN (306))
OR
(av.SupplierID = 179
AND av.DataSupplierArticleNumber = "G1543H"
AND av.ProductID IN (306))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1151136"
AND av.ProductID IN (306))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1428458"
AND av.ProductID IN (306))
)
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 = 30
AND aa.DataSupplierArticleNumber = "1 987 949 538")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "CT1028")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "94885")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TB6215")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "05KD020")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "70120")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "19540")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "4458V")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "5569XS")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "COKD020")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "120 HTDP 30")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1112101909")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "340018181107")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "94885")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VTB819")
OR
(aa.SupplierID = 64
AND aa.DataSupplierArticleNumber = "ZRK 1338")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QTB631")
OR
(aa.SupplierID = 100
AND aa.DataSupplierArticleNumber = "RR1107")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1766010")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMT 01142")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "30 91 9540")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "109 353")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8645 5569xs")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "07.12.098")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "G1543H")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1151136")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1428458")
)
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 = 30
AND aa.DataSupplierArticleNumber = "1 987 949 538")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "CT1028")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "94885")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TB6215")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "05KD020")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "70120")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "19540")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "4458V")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "5569XS")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "COKD020")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "120 HTDP 30")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1112101909")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "340018181107")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "94885")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VTB819")
OR
(aa.SupplierID = 64
AND aa.DataSupplierArticleNumber = "ZRK 1338")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QTB631")
OR
(aa.SupplierID = 100
AND aa.DataSupplierArticleNumber = "RR1107")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1766010")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMT 01142")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "30 91 9540")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "109 353")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8645 5569xs")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "07.12.098")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "G1543H")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1151136")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1428458")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Ремень ГРМ для автомобилей - Catcar.info