#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzV8fG1kZl9pZD09MV40OTExfHxzcGFyZV9pZD09MjAxNDc1&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 = "4911"
AND (
(av.SupplierID = 141
AND av.DataSupplierArticleNumber = "V91201"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 141
AND av.DataSupplierArticleNumber = "V91202"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 141
AND av.DataSupplierArticleNumber = "V91200"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 141
AND av.DataSupplierArticleNumber = "V34963"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "21965"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 235
AND av.DataSupplierArticleNumber = "R4371/RCR"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 235
AND av.DataSupplierArticleNumber = "R3744/RCR"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 235
AND av.DataSupplierArticleNumber = "R6047/RCR"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "061 VE 30986 000"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "061 VA 30987 000"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "81-24607-SX"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "81-23920-SX"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 347
AND av.DataSupplierArticleNumber = "105-35505"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 347
AND av.DataSupplierArticleNumber = "105-35355"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1173812"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1025314"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1213248"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1093383"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1173813"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1052906"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1157181"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1213251"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1053002"
AND av.ProductID IN (1269))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1173814"
AND av.ProductID IN (1270))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1025340"
AND av.ProductID IN (1270))
)
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 = 141
AND aa.DataSupplierArticleNumber = "V91201")
OR
(aa.SupplierID = 141
AND aa.DataSupplierArticleNumber = "V91202")
OR
(aa.SupplierID = 141
AND aa.DataSupplierArticleNumber = "V91200")
OR
(aa.SupplierID = 141
AND aa.DataSupplierArticleNumber = "V34963")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "21965")
OR
(aa.SupplierID = 235
AND aa.DataSupplierArticleNumber = "R4371/RCR")
OR
(aa.SupplierID = 235
AND aa.DataSupplierArticleNumber = "R3744/RCR")
OR
(aa.SupplierID = 235
AND aa.DataSupplierArticleNumber = "R6047/RCR")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "061 VE 30986 000")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "061 VA 30987 000")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-24607-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-23920-SX")
OR
(aa.SupplierID = 347
AND aa.DataSupplierArticleNumber = "105-35505")
OR
(aa.SupplierID = 347
AND aa.DataSupplierArticleNumber = "105-35355")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1173812")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1025314")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1213248")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1093383")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1173813")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1052906")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1157181")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1213251")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1053002")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1173814")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1025340")
)
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 = 141
AND aa.DataSupplierArticleNumber = "V91201")
OR
(aa.SupplierID = 141
AND aa.DataSupplierArticleNumber = "V91202")
OR
(aa.SupplierID = 141
AND aa.DataSupplierArticleNumber = "V91200")
OR
(aa.SupplierID = 141
AND aa.DataSupplierArticleNumber = "V34963")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "21965")
OR
(aa.SupplierID = 235
AND aa.DataSupplierArticleNumber = "R4371/RCR")
OR
(aa.SupplierID = 235
AND aa.DataSupplierArticleNumber = "R3744/RCR")
OR
(aa.SupplierID = 235
AND aa.DataSupplierArticleNumber = "R6047/RCR")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "061 VE 30986 000")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "061 VA 30987 000")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-24607-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-23920-SX")
OR
(aa.SupplierID = 347
AND aa.DataSupplierArticleNumber = "105-35505")
OR
(aa.SupplierID = 347
AND aa.DataSupplierArticleNumber = "105-35355")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1173812")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1025314")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1213248")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1093383")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1173813")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1052906")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1157181")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1213251")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1053002")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1173814")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1025340")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Клапаны / комплектующие для автомобилей - Catcar.info