Most popular photos of June 2007

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


You might also like

If you like this post then please subscribe to my full RSS feed. You can also click here to subscribe by email. There are also my fabulous photos to explore too!

Tags: , , , , , ,

Comments

  • josef July 1, 2007 Reply

    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

  • Donncha O Caoimh July 1, 2007 Reply

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

  • James Farmer July 2, 2007 Reply

    Do I detect elements of Lorelle creeping in here ;)

  • Donncha O Caoimh July 2, 2007 Reply

    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!

  • Andrew Ferguson July 3, 2007 Reply

    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 :)

Leave a Reply

Loading Facebook Comments ...
%d bloggers like this: