#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3NXx8bW9kZWxfaWQ9PTc1ODh8fG1kZl9pZD09MF4yODI4Mnx8c3BhcmVfaWQ9PTEwMDUyMQ%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 = "28282" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "71007300" AND av.ProductID IN (572)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15083100" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OC6326" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS8372" AND av.ProductID IN (572)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP21170" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20026412B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20034934B" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "364.700" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "155.560" AND av.ProductID IN (572)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "8456050" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1323" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1662" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "32471" AND av.ProductID IN (572)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "36383" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P77689-01" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P76096-11" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319430-00" AND av.ProductID IN (572)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1119500200" AND av.ProductID IN (572)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "100 103 1000" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5106" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00007-SX" AND av.ProductID IN (572)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 2471" AND av.ProductID IN (572)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 6383" AND av.ProductID IN (572)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "109 383" AND av.ProductID IN (572)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 29026" AND av.ProductID IN (572)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10050" AND av.ProductID IN (572)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3275" AND av.ProductID IN (572)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-3680" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-34366-00" AND av.ProductID IN (572)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-90052-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1428878" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163600" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086708" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1429026" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177354" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1103936" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1004473" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1192224" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1104000" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1005039" AND av.ProductID IN (572)) ) 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 = 139 AND aa.DataSupplierArticleNumber = "71007300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15083100") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OC6326") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS8372") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP21170") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20026412B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20034934B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "364.700") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "155.560") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8456050") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1323") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1662") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32471") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36383") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77689-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76096-11") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319430-00") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1119500200") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 103 1000") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5106") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00007-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2471") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6383") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 383") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 29026") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10050") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3275") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3680") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-34366-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-90052-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428878") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163600") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086708") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1429026") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177354") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103936") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004473") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192224") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1005039") ) 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 = 139 AND aa.DataSupplierArticleNumber = "71007300") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15083100") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OC6326") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS8372") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP21170") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20026412B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20034934B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "364.700") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "155.560") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8456050") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1323") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1662") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "32471") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36383") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P77689-01") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76096-11") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319430-00") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1119500200") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "100 103 1000") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5106") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00007-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 2471") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6383") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "109 383") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 29026") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10050") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3275") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-3680") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-34366-00") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-90052-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1428878") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163600") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086708") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1429026") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177354") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103936") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004473") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192224") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1104000") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1005039") ) AND aa.Language = "ru"
![]() |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||