Most popular photos of June 2007

Written July 1, 2007 in Photography, Photos of the month, Words

Jump to comments

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


User tags: "june photos"

5 comments on ' Most popular photos of June 2007 '

  1. What an honor to be mentioned in the most prolific commenters section! :)

    I can only agree to your most popular photos section too.. although I think “Orange stripes and white clouds” should be att the number one spot.

    Keep up the good work

    /J

      Written by josef on July 01, 2007 at 1:20pm

  2. Josef - you should include your email address when commenting so I don’t have to moderate your comment each time!

      Written by Donncha O Caoimh on July 01, 2007 at 2:36pm

  3. Do I detect elements of Lorelle creeping in here ;)

      Written by James Farmer on July 02, 2007 at 2:09am

  4. Hehe. These sort of round up posts are getting more popular on other blogs and I promise I won’t do them more than once a month! They might help new visitors see some of what they missed over the previous four weeks too!

      Written by Donncha O Caoimh on July 02, 2007 at 1:09pm

  5. Oooh, thanks for the SQL chunks to figure that stuff out. I thought about installing a plugin to do it, but I just don’t want to install any more plugins unless I really need them :)

      Written by Andrew Ferguson on July 03, 2007 at 11:44pm

Leave a comment

Name (required):

Email (required):

Website: