#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTM0MjF8fG1kZl9pZD09MV4yNDA2fHxzcGFyZV9pZD09MjAwNDY0&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 = "2406" AND ( (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BCA32415" AND av.ProductID IN (273)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BBJ32325K" AND av.ProductID IN (2473)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BSK32324" AND av.ProductID IN (2473)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BCA32377" AND av.ProductID IN (273)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "NR1000" AND av.ProductID IN (273)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "NS1001" AND av.ProductID IN (273)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39391" AND av.ProductID IN (273)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "11732 02" AND av.ProductID IN (273)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "23049 01" AND av.ProductID IN (273)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "DF-RK-8503" AND av.ProductID IN (2473)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "IV-DL-8613" AND av.ProductID IN (273)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "IV-VB-8146" AND av.ProductID IN (273)) OR (av.SupplierID = 4609 AND av.DataSupplierArticleNumber = "2016079" AND av.ProductID IN (273)) OR (av.SupplierID = 4609 AND av.DataSupplierArticleNumber = "2018485" AND av.ProductID IN (273)) OR (av.SupplierID = 4609 AND av.DataSupplierArticleNumber = "2016075" AND av.ProductID IN (273)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "10795" AND av.ProductID IN (273)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-11713-SX" AND av.ProductID IN (273)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-08135-SX" AND av.ProductID IN (251)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "84-12074-SX" AND av.ProductID IN (2473)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRR0119" AND av.ProductID IN (273)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRK0027" AND av.ProductID IN (2473)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JVL0104" AND av.ProductID IN (273)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRK0033" AND av.ProductID IN (2473)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JRK0036" AND av.ProductID IN (2473)) ) 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 = 475 AND aa.DataSupplierArticleNumber = "BCA32415") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BBJ32325K") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK32324") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BCA32377") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NR1000") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NS1001") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39391") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "11732 02") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "23049 01") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "DF-RK-8503") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "IV-DL-8613") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "IV-VB-8146") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2016079") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2018485") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2016075") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "10795") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-11713-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-08135-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-12074-SX") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRR0119") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0027") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JVL0104") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0033") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0036") ) 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 = 475 AND aa.DataSupplierArticleNumber = "BCA32415") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BBJ32325K") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BSK32324") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BCA32377") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NR1000") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "NS1001") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39391") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "11732 02") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "23049 01") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "DF-RK-8503") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "IV-DL-8613") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "IV-VB-8146") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2016079") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2018485") OR (aa.SupplierID = 4609 AND aa.DataSupplierArticleNumber = "2016075") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "10795") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-11713-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-08135-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "84-12074-SX") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRR0119") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0027") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JVL0104") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0033") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JRK0036") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||