#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTMxfHxtZGZfaWQ9PTBeMTE0MHx8c3BhcmVfaWQ9PTEwMjQwNg%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 = "1140" AND ( (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "9895500910" AND av.ProductID IN (3174)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "9895501010" AND av.ProductID IN (3174)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160381" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160352" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00090567A1" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00170391" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160382" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160361" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00090610" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00090555" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00170392" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00170361A1" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160362" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00160351" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00090560" AND av.ProductID IN (62)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "00170362A1" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0154014" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0134004" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0154113" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0134139" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0154114" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0154013" AND av.ProductID IN (62)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "AD0134003" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0320902" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5812914" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0322904" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0320903" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0322905" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0320904" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0320901" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0322906" AND av.ProductID IN (62)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "0322903" AND av.ProductID IN (62)) ) 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 = 268 AND aa.DataSupplierArticleNumber = "9895500910") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "9895501010") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160381") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160352") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090567A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170391") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160382") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160361") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090610") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090555") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170392") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170361A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160362") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160351") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090560") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170362A1") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154014") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134004") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154113") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134139") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154114") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154013") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134003") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320902") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5812914") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322904") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320903") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322905") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320904") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320901") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322906") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322903") ) 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 = 268 AND aa.DataSupplierArticleNumber = "9895500910") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "9895501010") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160381") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160352") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090567A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170391") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160382") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160361") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090610") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090555") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170392") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170361A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160362") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00160351") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00090560") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "00170362A1") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154014") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134004") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154113") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134139") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154114") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0154013") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "AD0134003") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320902") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5812914") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322904") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320903") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322905") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320904") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0320901") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322906") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "0322903") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||