#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzR8fG1kZl9pZD09MV45ODcwfHxzcGFyZV9pZD09MjAwMTM1&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 = "9870" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15072300" AND av.ProductID IN (572)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15105800" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "090.510" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "152.320" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "904.820" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "40532" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P93261-01" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77749-01" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77750-01" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319620-00" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5471" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5300" AND av.ProductID IN (572)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "041.147" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-01377-SX" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-10445-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-35996-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-35997-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1379822" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1195673" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250274" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1151028" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250275" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1151030" AND av.ProductID IN (572)) ) 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 = 139 AND aa.DataSupplierArticleNumber = "15072300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15105800") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "090.510") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "152.320") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "904.820") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40532") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P93261-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77749-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77750-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319620-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5471") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5300") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "041.147") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-01377-SX") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-10445-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35996-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35997-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1379822") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1195673") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250274") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151028") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250275") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151030") ) 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 = 139 AND aa.DataSupplierArticleNumber = "15072300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15105800") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "090.510") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "152.320") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "904.820") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "40532") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P93261-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77749-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77750-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319620-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5471") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5300") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "041.147") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-01377-SX") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-10445-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35996-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-35997-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1379822") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1195673") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250274") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151028") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250275") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1151030") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||