In Photos dot org

The most popular photos of June 2007

1. 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!
2. 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!
3. Children at play was one shot I really enjoyed working on. Bright blue sky, vibrant colours. Yummy!

Most prolific commentators

1. Josef who was using WordPress, but switched to Pixelpost recently. I won’t hold that against him as he has some nice photos!
2. Gamma Goblin left a few comments on my blog this month. He bought some external drives just like I did!
3. 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

1. Love Messages.
2. Children at play.
3. 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:

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

Continue Reading »