Top 25 posts

 

I was asked “How did you get a list of your top 25 posts?” the answer is that I wrote a query to determine this. Then I formatted the results in Excel and added the URLs for each post.

 

Here is the query that I used for my post/blog:

 

select top 25

totalviews + Aggviews as ‘Total’ ,

Subject as ‘Title’,

totalviews as ‘Web views’,

Aggviews as ‘RSS Views’

–,postauthor as ‘Author’

–,SEC.name as ‘Blog Name’

from cs_Posts cs_Posts, cs_Sections SEC

where cs_Posts.SectionID = Sec.SectionID

and Groupid = 07

and postauthor = ‘Garth’ and cs_Posts.SectionID = 20

Order by ‘Total’ DESC

 

And here is the query that I used for the site’s top 25 posts/blogs.

 

select top 25

totalviews + Aggviews as ‘Total’ ,

Subject as ‘Title’,

totalviews as ‘Web views’,

Aggviews as ‘RSS Views’

,postauthor as ‘Author’

,SEC.name as ‘Blog Name’

from cs_Posts cs_Posts, cs_Sections SEC

where cs_Posts.SectionID = Sec.SectionID

and Groupid = 3

–and postauthor = ‘Garth’ and cs_Posts.SectionID = 20

Order by ‘Total’ DESC