The most popular photos of June 2007
- The Lady’s Red Boots was unsurprisingly the most popular of the photos I posted in June. I guess the combination of red boots and grey and dull background grabbed a lot of attention!
- Orange stripes and white clouds. I love leading lines, I love clouds. It was a beautiful day at the Conor Pass in Co. Kerry when I took this!
- Children at play was one shot I really enjoyed working on. Bright blue sky, vibrant colours. Yummy!
Most prolific commentators
- Josef who was using WordPress, but switched to Pixelpost recently. I won’t hold that against him as he has some nice photos!
- Gamma Goblin left a few comments on my blog this month. He bought some external drives just like I did!
- White intermezzo left a few comments on my flickr stream. Go take a look at her gorgeous photos of Singapore. Beautiful stuff!
Posts with most Comments this month
- Love Messages.
- Children at play.
- The Thieving Duck tied with Orange stripes and white clouds for 3rd place.
If you’re interested, the following SQL will give you the top commenters on your own WordPress blog:
SELECT comment_author, comment_author_url, count( * ) AS c FROM wp_comments WHERE comment_date > date_sub( NOW( ) , INTERVAL 1 MONTH ) GROUP BY comment_author ORDER BY c DESC
And this chunk of code will give you the posts with the most comments made in the past month:
Tags: blogstats, irishblogs, Photography, Photos of the month, SQL, wordpress, Words
SELECT comment_post_ID , post_name, count( * ) as c FROM wp_comments, wp_posts WHERE wp_comments.comment_post_ID = wp_posts.ID AND comment_date > date_sub( NOW( ) , INTERVAL 1 MONTH ) GROUP BY comment_post_ID ORDER BY `c` DESC