#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNHx8bW9kZWxfaWQ9PTcxfHxtZGZfaWQ9PTBeMjYzNHx8c3BhcmVfaWQ9PTEwMDI2MQ%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 = "2634"
AND (
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "P10007"
AND av.ProductID IN (9))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "FF-009"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "E01"
AND av.ProductID IN (9))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFF8014"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CFF100104"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "L104/606"
AND av.ProductID IN (9))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EFF012"
AND av.ProductID IN (9))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A130007"
AND av.ProductID IN (9))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A130008"
AND av.ProductID IN (9))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A130003"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1110.13.0001"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DFFL13"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "ZP 8014 FP"
AND av.ProductID IN (9))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "PS822"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H101WK"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4020/1"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4510"
AND av.ProductID IN (9))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "F300901"
AND av.ProductID IN (9))
OR
(av.SupplierID = 387
AND av.DataSupplierArticleNumber = "FE002z"
AND av.ProductID IN (9))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "KL 13 OF"
AND av.ProductID IN (9))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50013074"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFPF001"
AND av.ProductID IN (9))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "213908006800"
AND av.ProductID IN (9))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "KL 13 OF"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "WK 31/2"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4773
AND av.DataSupplierArticleNumber = "MFF-3000"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4020/1"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4510"
AND av.ProductID IN (9))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELE1990"
AND av.ProductID IN (9))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "BF 01"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "E001"
AND av.ProductID IN (9))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FB007"
AND av.ProductID IN (9))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "FF-01482"
AND av.ProductID IN (9))
OR
(av.SupplierID = 5
AND av.DataSupplierArticleNumber = "4.00030.80.0"
AND av.ProductID IN (9))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QFF0111"
AND av.ProductID IN (9))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ST 337"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "21-00589-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "BN500"
AND av.ProductID IN (9))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "587000"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1025410"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1214882"
AND av.ProductID IN (9))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WF8127"
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 = 4814
AND aa.DataSupplierArticleNumber = "P10007")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "FF-009")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "E01")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFF8014")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100104")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L104/606")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EFF012")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A130007")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A130008")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A130003")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.13.0001")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DFFL13")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 8014 FP")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PS822")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H101WK")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4020/1")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4510")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F300901")
OR
(aa.SupplierID = 387
AND aa.DataSupplierArticleNumber = "FE002z")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KL 13 OF")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013074")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFPF001")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "213908006800")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KL 13 OF")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 31/2")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MFF-3000")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4020/1")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4510")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELE1990")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "BF 01")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "E001")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FB007")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FF-01482")
OR
(aa.SupplierID = 5
AND aa.DataSupplierArticleNumber = "4.00030.80.0")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFF0111")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 337")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00589-SX")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "BN500")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "587000")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1025410")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214882")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8127")
)
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 = 4814
AND aa.DataSupplierArticleNumber = "P10007")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "FF-009")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "E01")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFF8014")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100104")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L104/606")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EFF012")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A130007")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A130008")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A130003")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.13.0001")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DFFL13")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 8014 FP")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PS822")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H101WK")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4020/1")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4510")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F300901")
OR
(aa.SupplierID = 387
AND aa.DataSupplierArticleNumber = "FE002z")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KL 13 OF")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013074")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFPF001")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "213908006800")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KL 13 OF")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 31/2")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MFF-3000")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4020/1")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4510")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELE1990")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "BF 01")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "E001")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FB007")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FF-01482")
OR
(aa.SupplierID = 5
AND aa.DataSupplierArticleNumber = "4.00030.80.0")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFF0111")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 337")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00589-SX")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "BN500")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "587000")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1025410")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214882")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8127")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Топливный фильтр для автомобилей