#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1NDF8fG1kZl9pZD09MV41NjE2fHxzcGFyZV9pZD09MjAwMTI3&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 = "5616" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "10139100" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "451.690" AND av.ProductID IN (318)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "752.037" AND av.ProductID IN (318)) OR (av.SupplierID = 4514 AND av.DataSupplierArticleNumber = "TH0018" AND av.ProductID IN (318)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "19317" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "H40623-00" AND av.ProductID IN (318)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "H50012-00" AND av.ProductID IN (318)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "30-026235-30" AND av.ProductID IN (318)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "12-34 001 0012" AND av.ProductID IN (318)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "72032" AND av.ProductID IN (318)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "BG850" AND av.ProductID IN (318)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "022.241" AND av.ProductID IN (318)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "81-10602-SX" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-25275-20" AND av.ProductID IN (318)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "61-25275-00" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1244213" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1178249" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1449279" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1194785" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1003500" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1244212" AND av.ProductID IN (318)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086023" AND av.ProductID IN (318)) ) 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 = "10139100") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "451.690") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "752.037") OR (aa.SupplierID = 4514 AND aa.DataSupplierArticleNumber = "TH0018") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "19317") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H40623-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H50012-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-026235-30") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-34 001 0012") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "72032") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "BG850") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.241") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-10602-SX") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-25275-20") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-25275-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244213") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1178249") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1449279") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1194785") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003500") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244212") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086023") ) 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 = "10139100") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "451.690") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "752.037") OR (aa.SupplierID = 4514 AND aa.DataSupplierArticleNumber = "TH0018") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "19317") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H40623-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "H50012-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "30-026235-30") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "12-34 001 0012") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "72032") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "BG850") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.241") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "81-10602-SX") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-25275-20") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "61-25275-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244213") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1178249") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1449279") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1194785") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1003500") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1244212") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086023") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||