#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTE5OTR8fG1kZl9pZD09MF4xMzEwMHx8c3BhcmVfaWQ9PTEwMDYxNw%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 = "13100" AND ( (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B12418" AND av.ProductID IN (864)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-860-035" AND av.ProductID IN (864)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP24791" AND av.ProductID IN (791)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "37644" AND av.ProductID IN (864)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6NW 007 546-071" AND av.ProductID IN (791)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "28-0348" AND av.ProductID IN (791)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2317001" AND av.ProductID IN (791)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2317013" AND av.ProductID IN (791)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0916007" AND av.ProductID IN (864)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2317000" AND av.ProductID IN (791)) OR (av.SupplierID = 4683 AND av.DataSupplierArticleNumber = "13278" AND av.ProductID IN (791)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 7644" AND av.ProductID IN (864)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "112 408" AND av.ProductID IN (864)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 155" AND av.ProductID IN (791)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 117" AND av.ProductID IN (864)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 156" AND av.ProductID IN (791)) OR (av.SupplierID = 83 AND av.DataSupplierArticleNumber = "X10-729-002-009" AND av.ProductID IN (791)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-77-0007" AND av.ProductID IN (791)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-77-1011" AND av.ProductID IN (791)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99591342501" AND av.ProductID IN (791)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99591343401" AND av.ProductID IN (791)) ) 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 = 4815 AND aa.DataSupplierArticleNumber = "B12418") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-860-035") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP24791") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37644") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6NW 007 546-071") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "28-0348") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317001") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317013") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0916007") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317000") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "13278") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7644") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 408") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 155") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 117") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 156") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "X10-729-002-009") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-77-0007") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-77-1011") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99591342501") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99591343401") ) 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 = 4815 AND aa.DataSupplierArticleNumber = "B12418") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-860-035") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP24791") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37644") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6NW 007 546-071") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "28-0348") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317001") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317013") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0916007") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317000") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "13278") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7644") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 408") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 155") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 117") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 156") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "X10-729-002-009") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-77-0007") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-77-1011") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99591342501") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99591343401") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||