#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUzOXx8bW9kZWxfaWQ9PTM4NzR8fG1kZl9pZD09MV4xMjcxMHx8c3BhcmVfaWQ9PTIwMDAyNQ%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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "12710" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "45146" AND av.ProductID IN (523)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "44591" AND av.ProductID IN (523)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "28001" AND av.ProductID IN (3243)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "35514" AND av.ProductID IN (608)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-90803" AND av.ProductID IN (5050)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "TEQ-03.010" AND av.ProductID IN (608)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-120133" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.515" AND av.ProductID IN (3216)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.291" AND av.ProductID IN (608)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.572" AND av.ProductID IN (4066)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.140" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.033" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.280" AND av.ProductID IN (523)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.516" AND av.ProductID IN (3216)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.574" AND av.ProductID IN (4067)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.248" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.034" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.281" AND av.ProductID IN (523)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.027" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.507" AND av.ProductID IN (3216)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "061.399" AND av.ProductID IN (5050)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.290" AND av.ProductID IN (608)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.039" AND av.ProductID IN (3243)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "060.030" AND av.ProductID IN (3243)) OR (av.SupplierID = 4614 AND av.DataSupplierArticleNumber = "9404" AND av.ProductID IN (608)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0802.500" AND av.ProductID IN (3243,3243)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "09.010.0868.300" AND av.ProductID IN (608,608)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-50632-SX" AND av.ProductID IN (608)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "37 93 5514" AND av.ProductID IN (608)) ) 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 = 101 AND aa.DataSupplierArticleNumber = "45146") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44591") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "28001") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35514") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-90803") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "TEQ-03.010") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-120133") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.515") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.291") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.572") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.140") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.033") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.280") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.516") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.574") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.248") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.034") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.281") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.027") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.507") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "061.399") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.290") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.039") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.030") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "9404") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0802.500") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0868.300") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-50632-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "37 93 5514") ) 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 = 101 AND aa.DataSupplierArticleNumber = "45146") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44591") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "28001") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "35514") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-90803") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "TEQ-03.010") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-120133") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.515") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.291") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.572") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.140") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.033") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.280") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.516") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.574") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.248") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.034") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.281") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.027") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.507") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "061.399") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.290") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.039") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "060.030") OR (aa.SupplierID = 4614 AND aa.DataSupplierArticleNumber = "9404") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0802.500") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "09.010.0868.300") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-50632-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "37 93 5514") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||