#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTUwODJ8fG1kZl9pZD09MV45MTc1fHxzcGFyZV9pZD09MjAwODM4&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 = "9175" AND ( (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9479274" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9471274" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9426272" AND av.ProductID IN (847)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9472274" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "7461274" AND av.ProductID IN (1915)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "9478274" AND av.ProductID IN (1299)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "7462274" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49929" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49921" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49930" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49923" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "101382" AND av.ProductID IN (4210)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100023" AND av.ProductID IN (4209)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100115" AND av.ProductID IN (1299)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49924" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "38148" AND av.ProductID IN (848)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100020" AND av.ProductID IN (1915)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "100116" AND av.ProductID IN (1299)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8SB 507 050-001" AND av.ProductID IN (4209)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9MX 564 234-001" AND av.ProductID IN (1915)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8SB 507 049-001" AND av.ProductID IN (847)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9MX 564 246-001" AND av.ProductID IN (4210)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9MX 564 234-011" AND av.ProductID IN (1915)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "T02-03-004" AND av.ProductID IN (1299)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "T02-03-015" AND av.ProductID IN (1299)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "T02-03-003" AND av.ProductID IN (1299)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "MER-MR-026" AND av.ProductID IN (848)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "MER-MR-027" AND av.ProductID IN (848)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "MER-MR-052" AND av.ProductID IN (1915)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.158-00A" AND av.ProductID IN (4210)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.119-00A" AND av.ProductID IN (848)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.092-00A" AND av.ProductID IN (1915)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.134-00A" AND av.ProductID IN (847)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.097-10A" AND av.ProductID IN (1299)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.761-00A" AND av.ProductID IN (848)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.092-10A" AND av.ProductID IN (1915)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.118-00A" AND av.ProductID IN (848)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.095-00A" AND av.ProductID IN (847)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "018.097-00A" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61690" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "914839" AND av.ProductID IN (1915)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61681" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "914840" AND av.ProductID IN (1915)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61682" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61549" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61687" AND av.ProductID IN (1299)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "19051" AND av.ProductID IN (1915)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "61569" AND av.ProductID IN (1299)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-41522-SX" AND av.ProductID IN (848)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-29055-SX" AND av.ProductID IN (1299)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-30208-SX" AND av.ProductID IN (1915)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-29071-SX" AND av.ProductID IN (1299)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-29045-SX" AND av.ProductID IN (1299)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-30230-SX" AND av.ProductID IN (1915)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-29046-SX" AND av.ProductID IN (1299)) ) 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 = 362 AND aa.DataSupplierArticleNumber = "9479274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9471274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9426272") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9472274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7461274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9478274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7462274") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49929") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49921") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49930") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49923") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "101382") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100023") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100115") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49924") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38148") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100020") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100116") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8SB 507 050-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 234-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8SB 507 049-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 246-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 234-011") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-004") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-015") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-003") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-026") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-027") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-052") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.158-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.119-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.092-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.134-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.097-10A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.761-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.092-10A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.118-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.095-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.097-00A") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61690") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "914839") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61681") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "914840") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61682") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61549") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61687") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "19051") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61569") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-41522-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29055-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-30208-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29071-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29045-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-30230-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29046-SX") ) 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 = 362 AND aa.DataSupplierArticleNumber = "9479274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9471274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9426272") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9472274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7461274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "9478274") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "7462274") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49929") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49921") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49930") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49923") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "101382") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100023") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100115") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "49924") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "38148") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100020") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "100116") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8SB 507 050-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 234-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8SB 507 049-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 246-001") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9MX 564 234-011") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-004") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-015") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "T02-03-003") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-026") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-027") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "MER-MR-052") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.158-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.119-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.092-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.134-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.097-10A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.761-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.092-10A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.118-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.095-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "018.097-00A") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61690") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "914839") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61681") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "914840") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61682") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61549") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61687") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "19051") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "61569") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-41522-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29055-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-30208-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29071-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29045-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-30230-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-29046-SX") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||