#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTQ3MTJ8fG1kZl9pZD09MF4xNjI4Mnx8c3BhcmVfaWQ9PTEwNDMxMw%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 = "16282" AND ( (av.SupplierID = 4997 AND av.DataSupplierArticleNumber = "YP313923" AND av.ProductID IN (540)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "128-0H-H04" AND av.ProductID IN (540)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654572" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81422" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.80235" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.80558" AND av.ProductID IN (540)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "E20500BTA" AND av.ProductID IN (540)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "534 0306 10" AND av.ProductID IN (540)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3567" AND av.ProductID IN (540)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "TS-H04" AND av.ProductID IN (540)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "128H04" AND av.ProductID IN (540)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "3518200309" AND av.ProductID IN (540)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "R0358" AND av.ProductID IN (540)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "R0357" AND av.ProductID IN (540)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MTP-4H04" AND av.ProductID IN (540)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N1815" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3138" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT1951" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2274" AND av.ProductID IN (540)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "58414" AND av.ProductID IN (540)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 433001" AND av.ProductID IN (540)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253480" AND av.ProductID IN (540)) ) 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 = 4997 AND aa.DataSupplierArticleNumber = "YP313923") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "128-0H-H04") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654572") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81422") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80235") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80558") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "E20500BTA") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "534 0306 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3567") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TS-H04") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "128H04") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "3518200309") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0358") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0357") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTP-4H04") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1815") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3138") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1951") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2274") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "58414") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 433001") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253480") ) 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 = 4997 AND aa.DataSupplierArticleNumber = "YP313923") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "128-0H-H04") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654572") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81422") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80235") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80558") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "E20500BTA") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "534 0306 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3567") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TS-H04") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "128H04") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "3518200309") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0358") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0357") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTP-4H04") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1815") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3138") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1951") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2274") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "58414") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 433001") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253480") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||