{"id":3472,"date":"2016-03-17T01:34:40","date_gmt":"2016-03-17T01:34:40","guid":{"rendered":"http:\/\/www.garysieling.com\/blog\/?p=3472"},"modified":"2020-03-31T00:46:31","modified_gmt":"2020-03-31T00:46:31","slug":"find-viewed-posts-stackoverflow","status":"publish","type":"post","link":"https:\/\/www.garysieling.com\/blog\/find-viewed-posts-stackoverflow\/","title":{"rendered":"Find the most viewed posts on Stackoverflow"},"content":{"rendered":"<p>To see the most viewed posts on Stackoverflow, you can query posts based on view count (<a href=\"https:\/\/data.stackexchange.com\/stackoverflow\/query\/new\">query tool link<\/a>).<\/p>\n<p>For example, to see the most popular posts on &#8216;Scala&#8217;, do this:<\/p>\n<pre lang=\"sql\">\nselect *\nfrom Posts p\njoin PostTags pt on p.Id = pt.PostId\njoin Tags t on pt.TagId = t.Id \nwhere TagName = 'scala'\norder by ViewCount desc\n<\/pre>\n<p><img alt='' class='alignnone size-full wp-image-3474' src='http:\/\/172.104.26.128\/wp-content\/uploads\/2016\/03\/img_56ea0994f087b.png' \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To see the most viewed posts on Stackoverflow, you can query posts based on view count (query tool link). For example, to see the most popular posts on &#8216;Scala&#8217;, do this: select * from Posts p join PostTags pt on p.Id = pt.PostId join Tags t on pt.TagId = t.Id where TagName = &#8216;scala&#8217; order &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.garysieling.com\/blog\/find-viewed-posts-stackoverflow\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Find the most viewed posts on Stackoverflow&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4,5,6],"tags":[480,523,529],"aioseo_notices":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/3472"}],"collection":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/comments?post=3472"}],"version-history":[{"count":1,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/3472\/revisions"}],"predecessor-version":[{"id":6492,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/posts\/3472\/revisions\/6492"}],"wp:attachment":[{"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/media?parent=3472"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/categories?post=3472"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.garysieling.com\/blog\/wp-json\/wp\/v2\/tags?post=3472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}