Blog Statistic – Part 2

Just after posting the blog stats, I remember that I also want to check out that number of ping backs and comments.

Since April 1 2007 there have been 181 ping backs and 22 comments

select count(*) as ‘# of Comments’ from cs_Posts cs_Posts, cs_Sections SEC where cs_Posts.SectionID = Sec.SectionID and Groupid = 3 and cs_Posts.SectionID = 20 and postdate > ‘2007-04-01’ and posttype = 1 and postlevel > 1

select count(*) as ‘# of ping backs’ from cs_Posts cs_Posts, cs_Sections SEC where cs_Posts.SectionID = Sec.SectionID and Groupid = 3 and cs_Posts.SectionID = 20 and postdate > ‘2007-04-01’ and posttype = 0 and postlevel > 1

Leave a Reply

Your email address will not be published. Required fields are marked *