#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTQ2OTR8fG1kZl9pZD09MF4xNjk0M3x8c3BhcmVfaWQ9PTEwMTQyNw%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 = "16943" AND ( (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB7528" AND av.ProductID IN (112)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB2825" AND av.ProductID IN (112)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB3893" AND av.ProductID IN (112)) OR (av.SupplierID = 4318 AND av.DataSupplierArticleNumber = "DB6411" AND av.ProductID IN (112)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26964" AND av.ProductID IN (112)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GP 002 067-121" AND av.ProductID IN (112)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "89901132" AND av.ProductID IN (112)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "78-0030SET" AND av.ProductID IN (112)) OR (av.SupplierID = 485 AND av.DataSupplierArticleNumber = "17137" AND av.ProductID IN (112)) OR (av.SupplierID = 485 AND av.DataSupplierArticleNumber = "17131" AND av.ProductID IN (112)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N233" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "3893-02B" AND av.ProductID IN (112)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "3893" AND av.ProductID IN (112)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PLT8.5-12/4" AND av.ProductID IN (112)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12929CP" AND av.ProductID IN (112)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12929NBVB2" AND av.ProductID IN (112)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12929B2" AND av.ProductID IN (112)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "2504" AND av.ProductID IN (112)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "BL2504" AND av.ProductID IN (112)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 92 6964" AND av.ProductID IN (112)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032130" AND av.ProductID IN (112)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032132" AND av.ProductID IN (112)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032223" AND av.ProductID IN (112)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032702" AND av.ProductID IN (112)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1058" AND av.ProductID IN (112)) ) 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 = 4318 AND aa.DataSupplierArticleNumber = "DB7528") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2825") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB3893") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB6411") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26964") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GP 002 067-121") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901132") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0030SET") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17137") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17131") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N233") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "3893-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "3893") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PLT8.5-12/4") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12929CP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12929NBVB2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12929B2") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2504") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL2504") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 6964") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032130") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032132") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032223") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032702") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1058") ) 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 = 4318 AND aa.DataSupplierArticleNumber = "DB7528") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB2825") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB3893") OR (aa.SupplierID = 4318 AND aa.DataSupplierArticleNumber = "DB6411") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26964") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GP 002 067-121") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901132") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "78-0030SET") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17137") OR (aa.SupplierID = 485 AND aa.DataSupplierArticleNumber = "17131") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N233") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "3893-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "3893") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PLT8.5-12/4") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12929CP") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12929NBVB2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12929B2") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "2504") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL2504") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 92 6964") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032130") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032132") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032223") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032702") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1058") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||