#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTczOXx8bW9kZWxfaWQ9PTQ3MDd8fG1kZl9pZD09MV42NTk4fHxzcGFyZV9pZD09MjAwODg2&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 = "6598" AND ( (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12014707B" AND av.ProductID IN (656)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "19016952" AND av.ProductID IN (3361)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12014731B" AND av.ProductID IN (656)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "01016684B" AND av.ProductID IN (656)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12019138B" AND av.ProductID IN (656)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "07016683B" AND av.ProductID IN (656)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20016681B" AND av.ProductID IN (656)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "081.570" AND av.ProductID IN (656)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45374" AND av.ProductID IN (656)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "44456" AND av.ProductID IN (656)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "16-34 753 0001" AND av.ProductID IN (656)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-70408" AND av.ProductID IN (2065)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.322" AND av.ProductID IN (2065)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.318" AND av.ProductID IN (3618)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "075.065" AND av.ProductID IN (2065)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.083" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.080" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "075.544" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.284" AND av.ProductID IN (5114)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.323" AND av.ProductID IN (2065)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.320" AND av.ProductID IN (2065)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "075.066" AND av.ProductID IN (3618)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.084" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.081" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.078" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.321" AND av.ProductID IN (2065)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.316" AND av.ProductID IN (3618)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.221" AND av.ProductID IN (1691)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.085" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.082" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "080.079" AND av.ProductID IN (2990)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "075.532" AND av.ProductID IN (2990)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-01309-SX" AND av.ProductID IN (656)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1223321" AND av.ProductID IN (656)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1220091" AND av.ProductID IN (656)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1226449" AND av.ProductID IN (656)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1222086" AND av.ProductID IN (656)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1223316" AND av.ProductID IN (656)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1190418" AND av.ProductID IN (656)) ) 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 = 140 AND aa.DataSupplierArticleNumber = "12014707B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19016952") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12014731B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01016684B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12019138B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "07016683B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20016681B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "081.570") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45374") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44456") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "16-34 753 0001") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-70408") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.322") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.318") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "075.065") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.083") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.080") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "075.544") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.284") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.323") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.320") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "075.066") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.084") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.081") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.078") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.321") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.316") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.221") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.085") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.082") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.079") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "075.532") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-01309-SX") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223321") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220091") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226449") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1222086") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223316") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190418") ) 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 = 140 AND aa.DataSupplierArticleNumber = "12014707B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19016952") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12014731B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "01016684B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12019138B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "07016683B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20016681B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "081.570") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "45374") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44456") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "16-34 753 0001") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-70408") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.322") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.318") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "075.065") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.083") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.080") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "075.544") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.284") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.323") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.320") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "075.066") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.084") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.081") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.078") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.321") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.316") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.221") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.085") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.082") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "080.079") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "075.532") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-01309-SX") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223321") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1220091") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226449") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1222086") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223316") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190418") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||