#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTU0NTR8fG1kZl9pZD09MF4xOTc4Nnx8c3BhcmVfaWQ9PTEwMDc3Mg%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 = "19786" AND ( (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "M590-02" AND av.ProductID IN (249)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "M590-06" AND av.ProductID IN (249)) OR (av.SupplierID = 350 AND av.DataSupplierArticleNumber = "ADM58065" AND av.ProductID IN (249)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 30-700-224" AND av.ProductID IN (249)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "081074" AND av.ProductID IN (249)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "081078" AND av.ProductID IN (249)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "80001355" AND av.ProductID IN (249)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "80004151" AND av.ProductID IN (249)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "29747" AND av.ProductID IN (249)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "44496" AND av.ProductID IN (249)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ90974" AND av.ProductID IN (249)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "514565" AND av.ProductID IN (249)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1532401100" AND av.ProductID IN (249)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1532401200" AND av.ProductID IN (249)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1532450170" AND av.ProductID IN (249)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1492013" AND av.ProductID IN (249)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "35394 01" AND av.ProductID IN (249)) OR (av.SupplierID = 35 AND av.DataSupplierArticleNumber = "30501 01" AND av.ProductID IN (249)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "ME-2487" AND av.ProductID IN (249)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "ME-1285" AND av.ProductID IN (249)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "ME-2077" AND av.ProductID IN (249)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "ME-2079" AND av.ProductID IN (249)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "ME-1274" AND av.ProductID IN (249)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "230911" AND av.ProductID IN (249)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "230901" AND av.ProductID IN (249)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "40-0290" AND av.ProductID IN (249)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "40-0174" AND av.ProductID IN (249)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "40-0175" AND av.ProductID IN (249)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "714 130 0001" AND av.ProductID IN (249)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "714 130 0004" AND av.ProductID IN (249)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "714 130 0010" AND av.ProductID IN (249)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "714 030 0008" AND av.ProductID IN (249)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "36247" AND av.ProductID IN (249)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "37701" AND av.ProductID IN (249)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "35060" AND av.ProductID IN (249)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "35666" AND av.ProductID IN (249)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PSE3082" AND av.ProductID IN (249)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "EM4686" AND av.ProductID IN (249)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "50 92 9747" AND av.ProductID IN (249)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "50 94 4496" AND av.ProductID IN (249)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V25-0174" AND av.ProductID IN (249)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V25-0175" AND av.ProductID IN (249)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V25-0176" AND av.ProductID IN (249)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V25-0172" AND av.ProductID IN (249)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1393029" AND av.ProductID IN (249)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1393074" AND av.ProductID IN (249)) ) 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 = 442 AND aa.DataSupplierArticleNumber = "M590-02") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "M590-06") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADM58065") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 30-700-224") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "081074") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "081078") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80001355") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80004151") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29747") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44496") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90974") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "514565") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1532401100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1532401200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1532450170") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1492013") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "35394 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "30501 01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-2487") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-1285") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-2077") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-2079") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-1274") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "230911") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "230901") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "40-0290") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "40-0174") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "40-0175") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "714 130 0001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "714 130 0004") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "714 130 0010") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "714 030 0008") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "36247") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "37701") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "35060") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "35666") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE3082") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EM4686") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "50 92 9747") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "50 94 4496") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0174") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0175") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0176") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0172") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1393029") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1393074") ) 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 = 442 AND aa.DataSupplierArticleNumber = "M590-02") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "M590-06") OR (aa.SupplierID = 350 AND aa.DataSupplierArticleNumber = "ADM58065") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 30-700-224") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "081074") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "081078") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80001355") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80004151") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29747") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44496") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ90974") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "514565") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1532401100") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1532401200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1532450170") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1492013") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "35394 01") OR (aa.SupplierID = 35 AND aa.DataSupplierArticleNumber = "30501 01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-2487") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-1285") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-2077") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-2079") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "ME-1274") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "230911") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "230901") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "40-0290") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "40-0174") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "40-0175") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "714 130 0001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "714 130 0004") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "714 130 0010") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "714 030 0008") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "36247") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "37701") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "35060") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "35666") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE3082") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "EM4686") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "50 92 9747") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "50 94 4496") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0174") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0175") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0176") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V25-0172") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1393029") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1393074") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||