#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTQ5Mjd8fG1kZl9pZD09MV44MTY0fHxzcGFyZV9pZD09MjAwMTU3&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 = "8164"
AND (
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "SP-1299"
AND av.ProductID IN (7))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "MD-729"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "H148"
AND av.ProductID IN (7))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "F 026 407 048"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4702
AND av.DataSupplierArticleNumber = "BS03-005"
AND av.ProductID IN (7))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "DO5513"
AND av.ProductID IN (7))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A210120"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4868
AND av.DataSupplierArticleNumber = "P954588"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4868
AND av.DataSupplierArticleNumber = "P550639"
AND av.ProductID IN (7))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "35396"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "ZP 3069 MG"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "ML 1136"
AND av.ProductID IN (7))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "OE693"
AND av.ProductID IN (7))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "OP592/6"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4581
AND av.DataSupplierArticleNumber = "LF3977"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4663
AND av.DataSupplierArticleNumber = "OG 1039"
AND av.ProductID IN (7))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H311W"
AND av.ProductID IN (7))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E311H01 D273"
AND av.ProductID IN (7))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H230W"
AND av.ProductID IN (7))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "OC 474"
AND av.ProductID IN (7))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50013987"
AND av.ProductID IN (7))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50014518"
AND av.ProductID IN (7))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "153071760765"
AND av.ProductID IN (7))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "OC 474"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "W 1170/7"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "W 13 004"
AND av.ProductID IN (7))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "1170/7-OF-PCS-MS"
AND av.ProductID IN (7))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELH4757"
AND av.ProductID IN (7))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "234 322 0001"
AND av.ProductID IN (7))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "TF 6503"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "Z288"
AND av.ProductID IN (7))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SM 5770"
AND av.ProductID IN (7))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 3288 R"
AND av.ProductID IN (7))
OR
(av.SupplierID = 92
AND av.DataSupplierArticleNumber = "FA8401A"
AND av.ProductID IN (7))
OR
(av.SupplierID = 92
AND av.DataSupplierArticleNumber = "FT5657"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "81-00016-SX"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "81-00031-SX"
AND av.ProductID IN (7))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "23.288.00"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1018845"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1019249"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1104021"
AND av.ProductID IN (7))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "92078E"
AND av.ProductID IN (7))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WL10085"
AND av.ProductID IN (7))
)
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 = 180
AND aa.DataSupplierArticleNumber = "SP-1299")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-729")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "H148")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 407 048")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS03-005")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "DO5513")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A210120")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P954588")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P550639")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "35396")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 3069 MG")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ML 1136")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "OE693")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "OP592/6")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "LF3977")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "OG 1039")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H311W")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E311H01 D273")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H230W")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "OC 474")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013987")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014518")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760765")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "OC 474")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "W 1170/7")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "W 13 004")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "1170/7-OF-PCS-MS")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELH4757")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "234 322 0001")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "TF 6503")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "Z288")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SM 5770")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3288 R")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FA8401A")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FT5657")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-00016-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-00031-SX")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "23.288.00")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1018845")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019249")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1104021")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "92078E")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WL10085")
)
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 = 180
AND aa.DataSupplierArticleNumber = "SP-1299")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-729")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "H148")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 407 048")
OR
(aa.SupplierID = 4702
AND aa.DataSupplierArticleNumber = "BS03-005")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "DO5513")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A210120")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P954588")
OR
(aa.SupplierID = 4868
AND aa.DataSupplierArticleNumber = "P550639")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "35396")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 3069 MG")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ML 1136")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "OE693")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "OP592/6")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "LF3977")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "OG 1039")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H311W")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E311H01 D273")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H230W")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "OC 474")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50013987")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014518")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760765")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "OC 474")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "W 1170/7")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "W 13 004")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "1170/7-OF-PCS-MS")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELH4757")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "234 322 0001")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "TF 6503")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "Z288")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SM 5770")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3288 R")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FA8401A")
OR
(aa.SupplierID = 92
AND aa.DataSupplierArticleNumber = "FT5657")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-00016-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "81-00031-SX")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "23.288.00")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1018845")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019249")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1104021")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "92078E")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WL10085")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Масляный фильтр для автомобилей