#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTQ3NTR8fG1kZl9pZD09MF4xODcxOXx8c3BhcmVfaWQ9PTEwMDExMw%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 = "18719"
AND (
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "9983150"
AND av.ProductID IN (188))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "9983405"
AND av.ProductID IN (188))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "99962200"
AND av.ProductID IN (189))
OR
(av.SupplierID = 112
AND av.DataSupplierArticleNumber = "R10004"
AND av.ProductID IN (188))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "37404"
AND av.ProductID IN (188))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1352202109"
AND av.ProductID IN (188))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1352203209"
AND av.ProductID IN (188))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "71792"
AND av.ProductID IN (188))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "71792/2"
AND av.ProductID IN (189))
OR
(av.SupplierID = 4764
AND av.DataSupplierArticleNumber = "10112200"
AND av.ProductID IN (189))
OR
(av.SupplierID = 4764
AND av.DataSupplierArticleNumber = "MC3150"
AND av.ProductID IN (188))
OR
(av.SupplierID = 4764
AND av.DataSupplierArticleNumber = "MC3405"
AND av.ProductID IN (188))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "2240595"
AND av.ProductID IN (188))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "2241072"
AND av.ProductID IN (188))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 639 0006"
AND av.ProductID IN (188))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 739 0003"
AND av.ProductID IN (188))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 032 0450"
AND av.ProductID IN (188))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 032 0483"
AND av.ProductID IN (188))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "SP3316"
AND av.ProductID IN (188))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "SP3314"
AND av.ProductID IN (188))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "AF-2801"
AND av.ProductID IN (188))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "AF-2931"
AND av.ProductID IN (188))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QCS6943"
AND av.ProductID IN (188))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QCS5437"
AND av.ProductID IN (188))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QCS5833"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 641"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "996 611"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "994 077"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 651"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 648"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 645"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 642"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "996 612"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "994 078"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 652"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "993 292"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 649"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 646"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 643"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "996 916"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "996 537"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "994 076"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 650"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 647"
AND av.ProductID IN (188))
OR
(av.SupplierID = 32
AND av.DataSupplierArticleNumber = "998 644"
AND av.ProductID IN (188))
OR
(av.SupplierID = 1
AND av.DataSupplierArticleNumber = "86836"
AND av.ProductID IN (188))
OR
(av.SupplierID = 1
AND av.DataSupplierArticleNumber = "55742"
AND av.ProductID IN (188))
OR
(av.SupplierID = 1
AND av.DataSupplierArticleNumber = "85202"
AND av.ProductID IN (188))
OR
(av.SupplierID = 390
AND av.DataSupplierArticleNumber = "19399"
AND av.ProductID IN (188))
OR
(av.SupplierID = 390
AND av.DataSupplierArticleNumber = "19175"
AND av.ProductID IN (188))
OR
(av.SupplierID = 390
AND av.DataSupplierArticleNumber = "19359"
AND av.ProductID IN (188))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 93 7404"
AND av.ProductID IN (188))
OR
(av.SupplierID = 4896
AND av.DataSupplierArticleNumber = "TS5013"
AND av.ProductID IN (188))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "JCS266"
AND av.ProductID IN (188))
)
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 = 253
AND aa.DataSupplierArticleNumber = "9983150")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9983405")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "99962200")
OR
(aa.SupplierID = 112
AND aa.DataSupplierArticleNumber = "R10004")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "37404")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1352202109")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1352203209")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "71792")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "71792/2")
OR
(aa.SupplierID = 4764
AND aa.DataSupplierArticleNumber = "10112200")
OR
(aa.SupplierID = 4764
AND aa.DataSupplierArticleNumber = "MC3150")
OR
(aa.SupplierID = 4764
AND aa.DataSupplierArticleNumber = "MC3405")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "2240595")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "2241072")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 639 0006")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 739 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 032 0450")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 032 0483")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "SP3316")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "SP3314")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "AF-2801")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "AF-2931")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QCS6943")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QCS5437")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QCS5833")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 641")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "996 611")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "994 077")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 651")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 648")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 645")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 642")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "996 612")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "994 078")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 652")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "993 292")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 649")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 646")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 643")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "996 916")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "996 537")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "994 076")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 650")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 647")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 644")
OR
(aa.SupplierID = 1
AND aa.DataSupplierArticleNumber = "86836")
OR
(aa.SupplierID = 1
AND aa.DataSupplierArticleNumber = "55742")
OR
(aa.SupplierID = 1
AND aa.DataSupplierArticleNumber = "85202")
OR
(aa.SupplierID = 390
AND aa.DataSupplierArticleNumber = "19399")
OR
(aa.SupplierID = 390
AND aa.DataSupplierArticleNumber = "19175")
OR
(aa.SupplierID = 390
AND aa.DataSupplierArticleNumber = "19359")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 7404")
OR
(aa.SupplierID = 4896
AND aa.DataSupplierArticleNumber = "TS5013")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JCS266")
)
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 = 253
AND aa.DataSupplierArticleNumber = "9983150")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9983405")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "99962200")
OR
(aa.SupplierID = 112
AND aa.DataSupplierArticleNumber = "R10004")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "37404")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1352202109")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1352203209")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "71792")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "71792/2")
OR
(aa.SupplierID = 4764
AND aa.DataSupplierArticleNumber = "10112200")
OR
(aa.SupplierID = 4764
AND aa.DataSupplierArticleNumber = "MC3150")
OR
(aa.SupplierID = 4764
AND aa.DataSupplierArticleNumber = "MC3405")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "2240595")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "2241072")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 639 0006")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 739 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 032 0450")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 032 0483")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "SP3316")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "SP3314")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "AF-2801")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "AF-2931")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QCS6943")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QCS5437")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QCS5833")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 641")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "996 611")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "994 077")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 651")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 648")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 645")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 642")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "996 612")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "994 078")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 652")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "993 292")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 649")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 646")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 643")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "996 916")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "996 537")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "994 076")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 650")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 647")
OR
(aa.SupplierID = 32
AND aa.DataSupplierArticleNumber = "998 644")
OR
(aa.SupplierID = 1
AND aa.DataSupplierArticleNumber = "86836")
OR
(aa.SupplierID = 1
AND aa.DataSupplierArticleNumber = "55742")
OR
(aa.SupplierID = 1
AND aa.DataSupplierArticleNumber = "85202")
OR
(aa.SupplierID = 390
AND aa.DataSupplierArticleNumber = "19399")
OR
(aa.SupplierID = 390
AND aa.DataSupplierArticleNumber = "19175")
OR
(aa.SupplierID = 390
AND aa.DataSupplierArticleNumber = "19359")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 7404")
OR
(aa.SupplierID = 4896
AND aa.DataSupplierArticleNumber = "TS5013")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JCS266")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Подвеска для автомобилей