jonlee.ca

JonLee.ca is now officially 1 year old. In this past year, I feel like the blog has accomplished a lot: gaining readership from all around the world and making a name for itself in the blogging community.

I’m sure most readers were not reading this blog right from the very first post so I’ve compiled a list of the best posts (under several categories). I’ve also included the necessary SQL query if you want to do something similar on your own wordpress blog.

Most Viewed (via Google Analytics)

1. Game Break – Best Tower Defense Games – 162,509 views
2. Clever and Creative Outdoor Ads – 154,408 views
3. Starcraft 2 Game Play Footage – 119,238 views
4. Game Break – Best Defend Your Castle Games – 118,747 views
5. How Dirty is Your Computer – 117,093 views

Most Commented On

SELECT comment_post_ID, COUNT( * ) AS num
FROM `wp_comments`
WHERE `comment_type` = ”
GROUP BY comment_post_ID
ORDER BY num DESC

1. 2P Slim Mouse Giveaway Contest – 117 Comments
2. Hindsight is 20/20 – 63 Comments
3. Clever and Creative Outdoor Ads – 43 Comments
4. Defeating My Google Twin – 42 Comments
5. Giveaway – World’s Smallest MicroSD Card Reader – 41 comments

Most Pingbacks

SELECT comment_post_ID, COUNT( * ) AS num
FROM `wp_comments`
WHERE `comment_type` = ‘pingback’
GROUP BY comment_post_ID
ORDER BY num DESC

1. Jon’s Showoff Rankings – 52 Pingbacks
2. Hindsight is 20/20 – 16 Pingbacks
3. Giveaway – World’s Smallest MicroSD Card Reader – 15 Pingbacks
4. mediatemple Coupon and Referral Program – 13 Pingbacks
5. 2P Slim Mouse Giveaway Contest – 13 Pingbacks

Most Popular “How-To” posts

1. How-to: Free Portable Web Development on a USB Drive
2. How-to: DIY Das Keyboard using a Model M
3. How-to: Secure your Traffic using an SSH Tunnel with PuTTY
4. How-to: Automate your SSH Login with PuTTY
5. How-to: Delete Undeletable Files

Site Launches

• New Site Launch: Sujjest.com – Improved eBay Search
• Surf Handsfree – Lazy Web Surfing
• Showoff Rankings – Not just for WordPress
• My Educational Web Directory Initiative

Personal Picks

• Web Hosting Recommendations
• An Evil Way to Increase RSS Stats
• 7 Tips to Make Reading RSS Not Feel like a Chore
• Would You Turn Down $10,000?
• Good Looking Color Themes to Avoid

Interesting to note that the most popular posts have nothing at all to do with web development! Do you have your own favorite post? Anything you’d like to see more of in the coming year? Leave a comment to let me know!

Popularity: 6% [?]

This entry was posted on Wednesday, January 2nd, 2008 at 5:33 pm and is filed under Personal, Site stuff. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.