#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2OXx8bW9kZWxfaWQ9PTU0MTJ8fG1kZl9pZD09MF4xODU2N3x8c3BhcmVfaWQ9PTEwMDgyNg%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 = "18567" AND ( (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2020253" AND av.ProductID IN (514)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2034953" AND av.ProductID IN (219)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "2002203" AND av.ProductID IN (514)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "29257" AND av.ProductID IN (514)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "29258" AND av.ProductID IN (219)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "65 14 95-95" AND av.ProductID IN (219)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "65 14 03-91" AND av.ProductID IN (514)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "354005" AND av.ProductID IN (514)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "454030" AND av.ProductID IN (219)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "65222802" AND av.ProductID IN (514)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "65227120" AND av.ProductID IN (219)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8177822" AND av.ProductID IN (219)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8077805" AND av.ProductID IN (514)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "101-00-283" AND av.ProductID IN (514)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719094100" AND av.ProductID IN (514)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719092300" AND av.ProductID IN (219)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "430719085500" AND av.ProductID IN (514)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "127484" AND av.ProductID IN (219)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "91935" AND av.ProductID IN (219)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "91931" AND av.ProductID IN (514)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2110495" AND av.ProductID IN (514)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5852" AND av.ProductID IN (219)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "ML5790" AND av.ProductID IN (514)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "RSA001" AND av.ProductID IN (219)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS1173" AND av.ProductID IN (219)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS0836" AND av.ProductID IN (514)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "015356" AND av.ProductID IN (219)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "712224" AND av.ProductID IN (514)) OR (av.SupplierID = 126 AND av.DataSupplierArticleNumber = "013177" AND av.ProductID IN (514)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "57 92 9257" AND av.ProductID IN (514)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "57 92 9258" AND av.ProductID IN (219)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 65104" AND av.ProductID IN (514)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8710 65210" AND av.ProductID IN (219)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V50-0038" AND av.ProductID IN (514)) OR (av.SupplierID = 4425 AND av.DataSupplierArticleNumber = "51386" AND av.ProductID IN (219,219)) ) 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 = 4585 AND aa.DataSupplierArticleNumber = "2020253") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2034953") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2002203") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29257") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29258") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "65 14 95-95") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "65 14 03-91") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "354005") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "454030") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "65222802") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "65227120") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8177822") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8077805") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "101-00-283") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719094100") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719092300") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719085500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127484") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "91935") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "91931") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2110495") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5852") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5790") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RSA001") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS1173") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0836") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "015356") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "712224") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "013177") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "57 92 9257") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "57 92 9258") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 65104") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 65210") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V50-0038") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "51386") ) 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 = 4585 AND aa.DataSupplierArticleNumber = "2020253") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2034953") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "2002203") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29257") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "29258") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "65 14 95-95") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "65 14 03-91") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "354005") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "454030") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "65222802") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "65227120") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8177822") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8077805") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "101-00-283") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719094100") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719092300") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "430719085500") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "127484") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "91935") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "91931") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2110495") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5852") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "ML5790") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RSA001") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS1173") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS0836") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "015356") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "712224") OR (aa.SupplierID = 126 AND aa.DataSupplierArticleNumber = "013177") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "57 92 9257") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "57 92 9258") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 65104") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8710 65210") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V50-0038") OR (aa.SupplierID = 4425 AND aa.DataSupplierArticleNumber = "51386") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||