#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTgwMjV8fG1kZl9pZD09MF4xMDA3OTZ8fHNwYXJlX2lkPT0xMDAzMzQ%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 = "100796" AND ( (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTS3001" AND av.ProductID IN (830)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BTS3002" AND av.ProductID IN (830)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B18252" AND av.ProductID IN (830)) OR (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B13129" AND av.ProductID IN (1103)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "TS2671" AND av.ProductID IN (1103)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "WS3070" AND av.ProductID IN (830)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "TS2783" AND av.ProductID IN (1103)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.850.690" AND av.ProductID IN (1103)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.830.355" AND av.ProductID IN (830)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.850.262" AND av.ProductID IN (1103)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.3355" AND av.ProductID IN (830)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.5262" AND av.ProductID IN (1103)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "7.5690" AND av.ProductID IN (1103)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "36563" AND av.ProductID IN (1103)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FTS3001" AND av.ProductID IN (830)) OR (av.SupplierID = 407 AND av.DataSupplierArticleNumber = "FTS3002" AND av.ProductID IN (830)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "82.400" AND av.ProductID IN (1103)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6ZT 007 800-111" AND av.ProductID IN (1103)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7472701" AND av.ProductID IN (1103)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1193102700" AND av.ProductID IN (830)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "530 355" AND av.ProductID IN (830)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "550 262" AND av.ProductID IN (1103)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "550 690" AND av.ProductID IN (1103)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "82701" AND av.ProductID IN (1103)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0905436" AND av.ProductID IN (830)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "82.400" AND av.ProductID IN (1103)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 6563" AND av.ProductID IN (1103)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 879" AND av.ProductID IN (830)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8625 137095" AND av.ProductID IN (1103)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8625 120097" AND av.ProductID IN (1103)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-72-1361" AND av.ProductID IN (830)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99590082401" AND av.ProductID IN (1103)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99191539701" AND av.ProductID IN (830)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1499648" AND av.ProductID IN (1103)) ) 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 = 475 AND aa.DataSupplierArticleNumber = "BTS3001") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTS3002") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18252") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B13129") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "TS2671") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "WS3070") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "TS2783") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.850.690") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.355") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.850.262") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3355") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.5262") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.5690") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36563") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTS3001") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTS3002") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "82.400") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZT 007 800-111") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7472701") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193102700") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 355") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "550 262") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "550 690") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "82701") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0905436") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "82.400") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6563") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 879") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8625 137095") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8625 120097") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-72-1361") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99590082401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99191539701") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1499648") ) 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 = 475 AND aa.DataSupplierArticleNumber = "BTS3001") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BTS3002") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B18252") OR (aa.SupplierID = 4815 AND aa.DataSupplierArticleNumber = "B13129") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "TS2671") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "WS3070") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "TS2783") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.850.690") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.830.355") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.850.262") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.3355") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.5262") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "7.5690") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "36563") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTS3001") OR (aa.SupplierID = 407 AND aa.DataSupplierArticleNumber = "FTS3002") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "82.400") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6ZT 007 800-111") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7472701") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1193102700") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "530 355") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "550 262") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "550 690") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "82701") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0905436") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "82.400") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 6563") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 879") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8625 137095") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8625 120097") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-72-1361") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99590082401") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99191539701") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1499648") ) AND aa.Language = "ru"
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||