#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTkxNTR8fG1kZl9pZD09MF4yNTY5MHx8c3BhcmVfaWQ9PTEwMTY2Nw%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 = "25690" AND ( (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBXD3S" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB715" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLD3S" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "84491" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "35752" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98717" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "19686" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98264" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "12904" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93768" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012861" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "90902" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "74154" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "19759" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98282" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17123" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "95397" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93013272" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012270" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "79299" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "35017" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98715" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17463" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "97131" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93013293" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012303" AND av.ProductID IN (106)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GJ 168 119-001" AND av.ProductID IN (106)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "89901313" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64176" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64176CBI" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403WHV2S1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "0815" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403WHV2C1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403XV2S2" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403VIS1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403XV2S1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403VIC1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403XV2C1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12580C1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12410C1" AND av.ProductID IN (106,106,106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "60167" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0027" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0028" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0029" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0026" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0030" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1047" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1019" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1039" AND av.ProductID IN (106)) ) 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 = 4344 AND aa.DataSupplierArticleNumber = "ELBXD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB715") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD3S") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "84491") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35752") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98717") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19686") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98264") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "12904") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93768") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012861") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "90902") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "74154") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19759") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98282") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17123") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "95397") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013272") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012270") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "79299") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35017") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98715") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17463") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "97131") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013293") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012303") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GJ 168 119-001") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901313") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64176") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64176CBI") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403WHV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "0815") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403WHV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIS1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12580C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12410C1") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "60167") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0027") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0028") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0029") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0026") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0030") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1019") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1039") ) 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 = 4344 AND aa.DataSupplierArticleNumber = "ELBXD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB715") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD3S") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "84491") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35752") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98717") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19686") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98264") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "12904") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93768") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012861") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "90902") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "74154") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19759") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98282") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17123") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "95397") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013272") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012270") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "79299") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35017") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98715") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17463") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "97131") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013293") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012303") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GJ 168 119-001") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901313") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64176") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64176CBI") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403WHV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "0815") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403WHV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIS1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12580C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12410C1") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "60167") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0027") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0028") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0029") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0026") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0030") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1019") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1039") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||