#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1Mnx8bW9kZWxfaWQ9PTY0MzV8fG1kZl9pZD09MF45Mzg5fHxzcGFyZV9pZD09MTAwODM0&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 = "9389" AND ( (av.SupplierID = 4911 AND av.DataSupplierArticleNumber = "590914" AND av.ProductID IN (2232)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "565003" AND av.ProductID IN (2232)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70699443" AND av.ProductID IN (2232)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "70699434" AND av.ProductID IN (2232)) OR (av.SupplierID = 4662 AND av.DataSupplierArticleNumber = "73.903.421" AND av.ProductID IN (2232)) OR (av.SupplierID = 4662 AND av.DataSupplierArticleNumber = "43.573.000" AND av.ProductID IN (2232)) OR (av.SupplierID = 4662 AND av.DataSupplierArticleNumber = "43.577.000" AND av.ProductID IN (2232)) OR (av.SupplierID = 4662 AND av.DataSupplierArticleNumber = "43.048.000" AND av.ProductID IN (2232)) OR (av.SupplierID = 4662 AND av.DataSupplierArticleNumber = "73.903.420" AND av.ProductID IN (2232)) OR (av.SupplierID = 4662 AND av.DataSupplierArticleNumber = "43.050.000" AND av.ProductID IN (2232)) OR (av.SupplierID = 4705 AND av.DataSupplierArticleNumber = "TX-S034" AND av.ProductID IN (2232)) OR (av.SupplierID = 4705 AND av.DataSupplierArticleNumber = "TX-P002" AND av.ProductID IN (2232)) OR (av.SupplierID = 4705 AND av.DataSupplierArticleNumber = "TX-P004" AND av.ProductID IN (2232)) OR (av.SupplierID = 4946 AND av.DataSupplierArticleNumber = "2200" AND av.ProductID IN (2232)) OR (av.SupplierID = 4946 AND av.DataSupplierArticleNumber = "2210" AND av.ProductID IN (2232)) OR (av.SupplierID = 4946 AND av.DataSupplierArticleNumber = "4028" AND av.ProductID IN (2232)) OR (av.SupplierID = 4946 AND av.DataSupplierArticleNumber = "1210" AND av.ProductID IN (2232)) OR (av.SupplierID = 83 AND av.DataSupplierArticleNumber = "A2C59507828" AND av.ProductID IN (3711)) OR (av.SupplierID = 83 AND av.DataSupplierArticleNumber = "S180052054Z" AND av.ProductID IN (2232)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-72-4024" AND av.ProductID IN (2232)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1309163" AND av.ProductID IN (2232)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1500991" AND av.ProductID IN (3711)) ) 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 = 4911 AND aa.DataSupplierArticleNumber = "590914") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "565003") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70699443") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70699434") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "73.903.421") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "43.573.000") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "43.577.000") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "43.048.000") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "73.903.420") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "43.050.000") OR (aa.SupplierID = 4705 AND aa.DataSupplierArticleNumber = "TX-S034") OR (aa.SupplierID = 4705 AND aa.DataSupplierArticleNumber = "TX-P002") OR (aa.SupplierID = 4705 AND aa.DataSupplierArticleNumber = "TX-P004") OR (aa.SupplierID = 4946 AND aa.DataSupplierArticleNumber = "2200") OR (aa.SupplierID = 4946 AND aa.DataSupplierArticleNumber = "2210") OR (aa.SupplierID = 4946 AND aa.DataSupplierArticleNumber = "4028") OR (aa.SupplierID = 4946 AND aa.DataSupplierArticleNumber = "1210") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "A2C59507828") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "S180052054Z") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-72-4024") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1309163") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1500991") ) 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 = 4911 AND aa.DataSupplierArticleNumber = "590914") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "565003") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70699443") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "70699434") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "73.903.421") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "43.573.000") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "43.577.000") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "43.048.000") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "73.903.420") OR (aa.SupplierID = 4662 AND aa.DataSupplierArticleNumber = "43.050.000") OR (aa.SupplierID = 4705 AND aa.DataSupplierArticleNumber = "TX-S034") OR (aa.SupplierID = 4705 AND aa.DataSupplierArticleNumber = "TX-P002") OR (aa.SupplierID = 4705 AND aa.DataSupplierArticleNumber = "TX-P004") OR (aa.SupplierID = 4946 AND aa.DataSupplierArticleNumber = "2200") OR (aa.SupplierID = 4946 AND aa.DataSupplierArticleNumber = "2210") OR (aa.SupplierID = 4946 AND aa.DataSupplierArticleNumber = "4028") OR (aa.SupplierID = 4946 AND aa.DataSupplierArticleNumber = "1210") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "A2C59507828") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "S180052054Z") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-72-4024") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1309163") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1500991") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||