#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3M3x8bW9kZWxfaWQ9PTQ4NzB8fG1kZl9pZD09MF4xOTIxOXx8c3BhcmVfaWQ9PTEwMDc4NQ%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 = "19219" AND ( (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "661065" AND av.ProductID IN (1291)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "96SKV005" AND av.ProductID IN (1111)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "39740" AND av.ProductID IN (1111)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "3.240145" AND av.ProductID IN (1291)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "9 9033 1" AND av.ProductID IN (1291)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "9 9403 1" AND av.ProductID IN (803)) OR (av.SupplierID = 4379 AND av.DataSupplierArticleNumber = "9 9133 1" AND av.ProductID IN (1111)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "4RA 007 507-021" AND av.ProductID IN (1750)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "4RP 008 189-151" AND av.ProductID IN (1111)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "75613186" AND av.ProductID IN (1111)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "75898967" AND av.ProductID IN (1291)) OR (av.SupplierID = 449 AND av.DataSupplierArticleNumber = "132218" AND av.ProductID IN (1291)) OR (av.SupplierID = 449 AND av.DataSupplierArticleNumber = "2502218" AND av.ProductID IN (1291)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "H73240145" AND av.ProductID IN (1291)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1199208200" AND av.ProductID IN (1750)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1199206900" AND av.ProductID IN (1111)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "50-0226" AND av.ProductID IN (1750)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "73240145" AND av.ProductID IN (1291)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVFU102" AND av.ProductID IN (61)) OR (av.SupplierID = 4606 AND av.DataSupplierArticleNumber = "RBC/21-12" AND av.ProductID IN (1111)) OR (av.SupplierID = 4606 AND av.DataSupplierArticleNumber = "RBC/17-12" AND av.ProductID IN (1111)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "P27-0002" AND av.ProductID IN (1750)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "XFL115" AND av.ProductID IN (61)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "3.240145" AND av.ProductID IN (1291)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "58901" AND av.ProductID IN (61,61)) OR (av.SupplierID = 269 AND av.DataSupplierArticleNumber = "FLA003" AND av.ProductID IN (61,61)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 9740" AND av.ProductID IN (1111)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "107 258" AND av.ProductID IN (1750)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.42.053" AND av.ProductID IN (1111)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0005" AND av.ProductID IN (1111)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0019" AND av.ProductID IN (1111)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0035" AND av.ProductID IN (1291)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-71-0004" AND av.ProductID IN (1750)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99110119801" AND av.ProductID IN (1750)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99060093601" AND av.ProductID IN (1111)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99510019401" AND av.ProductID IN (1291)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1795411" AND av.ProductID IN (1111)) ) 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 = 234 AND aa.DataSupplierArticleNumber = "661065") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "96SKV005") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39740") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "3.240145") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9033 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9403 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9133 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "4RA 007 507-021") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "4RP 008 189-151") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75613186") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75898967") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "132218") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "2502218") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "H73240145") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1199208200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1199206900") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "50-0226") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "73240145") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVFU102") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "RBC/21-12") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "RBC/17-12") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P27-0002") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XFL115") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "3.240145") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "58901") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "FLA003") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9740") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 258") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.053") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0005") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0019") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0035") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0004") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99110119801") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99060093601") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99510019401") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795411") ) 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 = 234 AND aa.DataSupplierArticleNumber = "661065") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "96SKV005") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "39740") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "3.240145") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9033 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9403 1") OR (aa.SupplierID = 4379 AND aa.DataSupplierArticleNumber = "9 9133 1") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "4RA 007 507-021") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "4RP 008 189-151") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75613186") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "75898967") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "132218") OR (aa.SupplierID = 449 AND aa.DataSupplierArticleNumber = "2502218") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "H73240145") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1199208200") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1199206900") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "50-0226") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "73240145") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVFU102") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "RBC/21-12") OR (aa.SupplierID = 4606 AND aa.DataSupplierArticleNumber = "RBC/17-12") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "P27-0002") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "XFL115") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "3.240145") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "58901") OR (aa.SupplierID = 269 AND aa.DataSupplierArticleNumber = "FLA003") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 9740") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 258") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.42.053") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0005") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0019") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0035") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-71-0004") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99110119801") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99060093601") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99510019401") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795411") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||