#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTU3MHx8bWRmX2lkPT0wXjc3M3x8c3BhcmVfaWQ9PTEwMDU3Nw%3D%3D&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 articlepassengercars av JOIN passengercarlinkageattributes_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 = "773" AND ( (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "260093" AND av.ProductID IN (3229)) OR (av.SupplierID = 206 AND av.DataSupplierArticleNumber = "260092" AND av.ProductID IN (3229)) OR (av.SupplierID = 49 AND av.DataSupplierArticleNumber = "042434B" AND av.ProductID IN (3229)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BDL6141" AND av.ProductID IN (3229)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "180918" AND av.ProductID IN (3229)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TC2040" AND av.ProductID IN (3229)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "F0014M" AND av.ProductID IN (3229)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "F0043M" AND av.ProductID IN (3229)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FDL6141" AND av.ProductID IN (3229)) OR (av.SupplierID = 236 AND av.DataSupplierArticleNumber = "FL903-H" AND av.ProductID IN (3229)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ7014" AND av.ProductID IN (3229)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "10901 03" AND av.ProductID IN (3229)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "24371" AND av.ProductID IN (3229)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "016 060 0221" AND av.ProductID IN (3229)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "ME-LS-0221" AND av.ProductID IN (3229)) OR (av.SupplierID = 198 AND av.DataSupplierArticleNumber = "0500716" AND av.ProductID IN (3229)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "G7-014" AND av.ProductID IN (3229)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QLS2509S" AND av.ProductID IN (3229)) OR (av.SupplierID = 4708 AND av.DataSupplierArticleNumber = "ME4003" AND av.ProductID IN (3229)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "97-00847" AND av.ProductID IN (3229)) OR (av.SupplierID = 430 AND av.DataSupplierArticleNumber = "97-00899" AND av.ProductID IN (3229)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "915103" AND av.ProductID IN (3229)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "49091" AND av.ProductID IN (3229)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "56-02045-SX" AND av.ProductID IN (3229)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "56-00659-SX" AND av.ProductID IN (3229)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "56-01202-SX" AND av.ProductID IN (3229)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "50-01990" AND av.ProductID IN (3229)) OR (av.SupplierID = 4758 AND av.DataSupplierArticleNumber = "50-01937" AND av.ProductID IN (3229)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "783766" AND av.ProductID IN (3229)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "783568" AND av.ProductID IN (3229)) OR (av.SupplierID = 161 AND av.DataSupplierArticleNumber = "JTS145" AND av.ProductID IN (3229)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V30-7119" AND av.ProductID IN (3229)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "15075" AND av.ProductID IN (3229,3229)) ) 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 = 206 AND aa.DataSupplierArticleNumber = "260093") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "260092") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "042434B") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BDL6141") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "180918") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TC2040") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "F0014M") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "F0043M") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FDL6141") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL903-H") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ7014") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "10901 03") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "24371") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "016 060 0221") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "ME-LS-0221") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0500716") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G7-014") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QLS2509S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "ME4003") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "97-00847") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "97-00899") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915103") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "49091") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-02045-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-00659-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-01202-SX") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "50-01990") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "50-01937") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783766") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783568") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTS145") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-7119") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "15075") ) 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 = 206 AND aa.DataSupplierArticleNumber = "260093") OR (aa.SupplierID = 206 AND aa.DataSupplierArticleNumber = "260092") OR (aa.SupplierID = 49 AND aa.DataSupplierArticleNumber = "042434B") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BDL6141") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "180918") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TC2040") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "F0014M") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "F0043M") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FDL6141") OR (aa.SupplierID = 236 AND aa.DataSupplierArticleNumber = "FL903-H") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ7014") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "10901 03") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "24371") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "016 060 0221") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "ME-LS-0221") OR (aa.SupplierID = 198 AND aa.DataSupplierArticleNumber = "0500716") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "G7-014") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QLS2509S") OR (aa.SupplierID = 4708 AND aa.DataSupplierArticleNumber = "ME4003") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "97-00847") OR (aa.SupplierID = 430 AND aa.DataSupplierArticleNumber = "97-00899") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "915103") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "49091") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-02045-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-00659-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "56-01202-SX") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "50-01990") OR (aa.SupplierID = 4758 AND aa.DataSupplierArticleNumber = "50-01937") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783766") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "783568") OR (aa.SupplierID = 161 AND aa.DataSupplierArticleNumber = "JTS145") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-7119") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "15075") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||