#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTM3M3x8bWRmX2lkPT0wXjcyNnx8c3BhcmVfaWQ9PTEwMDI2MQ%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 = "726"
AND (
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "P10189"
AND av.ProductID IN (9))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "SP-2004"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "E14"
AND av.ProductID IN (9))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFF8085"
AND av.ProductID IN (9))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 450 905 200"
AND av.ProductID IN (9))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 450 905 964"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "L204/606"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CFF100204"
AND av.ProductID IN (9))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "MBNA 953"
AND av.ProductID IN (9))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EFF015"
AND av.ProductID IN (9))
OR
(av.SupplierID = 437
AND av.DataSupplierArticleNumber = "FT5201"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DFFL30"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "ZP 8035 FM"
AND av.ProductID IN (9))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "PP825"
AND av.ProductID IN (9))
OR
(av.SupplierID = 441
AND av.DataSupplierArticleNumber = "8.580064"
AND av.ProductID IN (9))
OR
(av.SupplierID = 59
AND av.DataSupplierArticleNumber = "G3744"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H84WK01"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4022"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4022/1"
AND av.ProductID IN (9))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "KL 30"
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 = "LFPF014"
AND av.ProductID IN (9))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "213908201100"
AND av.ProductID IN (9))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "152071760846"
AND av.ProductID IN (9))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "KL 30"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "WK 853"
AND av.ProductID IN (9))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "62604"
AND av.ProductID IN (9))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "853-PCS-MS"
AND av.ProductID IN (9))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0413"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4022/1"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4022"
AND av.ProductID IN (9))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELE3569"
AND av.ProductID IN (9))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "514 323 0003"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "E502"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VFF143"
AND av.ProductID IN (9))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FB189"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PF3112"
AND av.ProductID IN (9))
OR
(av.SupplierID = 38
AND av.DataSupplierArticleNumber = "EP153"
AND av.ProductID IN (9))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ST 305"
AND av.ProductID IN (9))
OR
(av.SupplierID = 27
AND av.DataSupplierArticleNumber = "8.580064"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "21-00645-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V25-0107"
AND av.ProductID IN (9))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "587202"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1214969"
AND av.ProductID IN (9))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WF8027"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "KF-5042"
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 = "P10189")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "SP-2004")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "E14")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFF8085")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 450 905 200")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 450 905 964")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L204/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100204")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MBNA 953")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EFF015")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FT5201")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DFFL30")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 8035 FM")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PP825")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "8.580064")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "G3744")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H84WK01")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4022")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4022/1")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KL 30")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013074")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFPF014")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "213908201100")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "152071760846")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KL 30")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 853")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "62604")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "853-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0413")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4022/1")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4022")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELE3569")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "514 323 0003")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "E502")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFF143")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FB189")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF3112")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "EP153")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 305")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "8.580064")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00645-SX")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V25-0107")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "587202")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214969")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8027")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "KF-5042")
)
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 = "P10189")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "SP-2004")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "E14")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFF8085")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 450 905 200")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 450 905 964")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L204/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100204")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MBNA 953")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EFF015")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FT5201")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DFFL30")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 8035 FM")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PP825")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "8.580064")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "G3744")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H84WK01")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4022")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4022/1")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KL 30")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013074")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFPF014")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "213908201100")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "152071760846")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KL 30")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 853")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "62604")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "853-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0413")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4022/1")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4022")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELE3569")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "514 323 0003")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "E502")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFF143")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FB189")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF3112")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "EP153")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 305")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "8.580064")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00645-SX")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V25-0107")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "587202")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214969")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8027")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "KF-5042")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Топливный фильтр для автомобилей