#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3NXx8bW9kZWxfaWQ9PTUxMjB8fG1kZl9pZD09MF4yMDAwMXx8c3BhcmVfaWQ9PTEwMDM0Nw%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 = "20001" AND ( (av.SupplierID = 422 AND av.DataSupplierArticleNumber = "93881" AND av.ProductID IN (467)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "049007N" AND av.ProductID IN (467)) OR (av.SupplierID = 4688 AND av.DataSupplierArticleNumber = "103542" AND av.ProductID IN (467)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "ARD3127" AND av.ProductID IN (467)) OR (av.SupplierID = 4337 AND av.DataSupplierArticleNumber = "PRD3127" AND av.ProductID IN (467)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "VW6229" AND av.ProductID IN (467)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "VWA6229" AND av.ProductID IN (467)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8FH 351 315-781" AND av.ProductID IN (467)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DRR32005" AND av.ProductID IN (467)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "DCM1251" AND av.ProductID IN (467)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "37033" AND av.ProductID IN (467)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "0610.2009" AND av.ProductID IN (467)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8FH 351 315-781" AND av.ProductID IN (467)) OR (av.SupplierID = 296 AND av.DataSupplierArticleNumber = "RA2010330" AND av.ProductID IN (467)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1126300200" AND av.ProductID IN (467)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "0026306229" AND av.ProductID IN (467)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "003-015-0008-B" AND av.ProductID IN (467)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "350218279000" AND av.ProductID IN (467)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "AC568498" AND av.ProductID IN (467)) OR (av.SupplierID = 123 AND av.DataSupplierArticleNumber = "70228" AND av.ProductID IN (467)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DRR32005" AND av.ProductID IN (467)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "54271" AND av.ProductID IN (467)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "1760-0002" AND av.ProductID IN (467)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QHR2192" AND av.ProductID IN (467)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "10-35117-SX" AND av.ProductID IN (467)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 7033" AND av.ProductID IN (467)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "D6W010TT" AND av.ProductID IN (467)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "112 416" AND av.ProductID IN (467)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "812254" AND av.ProductID IN (467)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "58006229" AND av.ProductID IN (467)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-61-0010" AND av.ProductID IN (467)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "MK-5054" AND av.ProductID IN (467)) ) 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 = 422 AND aa.DataSupplierArticleNumber = "93881") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "049007N") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "103542") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "ARD3127") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "PRD3127") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "VW6229") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "VWA6229") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8FH 351 315-781") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DRR32005") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCM1251") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37033") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0610.2009") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8FH 351 315-781") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "RA2010330") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1126300200") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "0026306229") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "003-015-0008-B") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350218279000") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "AC568498") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "70228") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DRR32005") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "54271") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "1760-0002") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QHR2192") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "10-35117-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7033") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D6W010TT") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 416") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "812254") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "58006229") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-61-0010") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "MK-5054") ) 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 = 422 AND aa.DataSupplierArticleNumber = "93881") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "049007N") OR (aa.SupplierID = 4688 AND aa.DataSupplierArticleNumber = "103542") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "ARD3127") OR (aa.SupplierID = 4337 AND aa.DataSupplierArticleNumber = "PRD3127") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "VW6229") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "VWA6229") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8FH 351 315-781") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DRR32005") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCM1251") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37033") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "0610.2009") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8FH 351 315-781") OR (aa.SupplierID = 296 AND aa.DataSupplierArticleNumber = "RA2010330") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1126300200") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "0026306229") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "003-015-0008-B") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "350218279000") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "AC568498") OR (aa.SupplierID = 123 AND aa.DataSupplierArticleNumber = "70228") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DRR32005") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "54271") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "1760-0002") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QHR2192") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "10-35117-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7033") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "D6W010TT") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 416") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "812254") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "58006229") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-61-0010") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "MK-5054") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||