#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTExNjExfHxtZGZfaWQ9PTBeMTA2MjIzfHxzcGFyZV9pZD09MTAxNjY3&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 = "106223" AND ( (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780242" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780230" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721057" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721021" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780232" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721061" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721024" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721012" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780240" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721063" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721055" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721014" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLD3S" AND av.ProductID IN (106)) OR (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 = 2 AND av.DataSupplierArticleNumber = "8GH 008 356-121" 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 = "42403WHV2C1" 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 = "12580C1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403XV2S1" 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 = "42403VIC1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "LED" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "42403VIS1" 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 = 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 = 4894 AND av.DataSupplierArticleNumber = "LP-1039" 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-1110" 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 = 363 AND aa.DataSupplierArticleNumber = "79780242") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780230") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721057") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721021") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780232") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721061") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721024") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721012") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780240") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721063") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721055") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721014") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBXD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB715") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 008 356-121") 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 = "42403WHV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12580C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIS1") 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 = 183 AND aa.DataSupplierArticleNumber = "V99-84-0027") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0028") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1039") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1110") ) 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 = 363 AND aa.DataSupplierArticleNumber = "79780242") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780230") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721057") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721021") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780232") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721061") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721024") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721012") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780240") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721063") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721055") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721014") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBXD3S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB715") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 008 356-121") 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 = "42403WHV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12580C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2S1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403XV2C1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "LED") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "42403VIS1") 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 = 183 AND aa.DataSupplierArticleNumber = "V99-84-0027") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0028") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1039") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1110") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||