« Killarney’s main street
Walking exercise for the kids »

Most popular photos of June 2007

July 1st, 2007 by Donncha

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 , 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 will give you the top commenters on your own 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

Tags: , , , , , ,

Further Reading:

Add This Post To: Del.icio.us |  digg |  Fark |  Slashdot |  StumbleUpon |  TailRank |  Yahoo |  

 This entry was posted on Sunday, July 1st, 2007 at 12:05 pm and is filed under Photography, Photos of the month, Words. 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.


5 Responses to “Most popular photos of June 2007”

  1. josef Says:
    July 1st, 2007 at 1:20 pm

    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

  2. Donncha O Caoimh Says:
    July 1st, 2007 at 2:36 pm

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

  3. James Farmer Says:
    July 2nd, 2007 at 2:09 am

    Do I detect elements of Lorelle creeping in here ;)

  4. Donncha O Caoimh Says:
    July 2nd, 2007 at 1:09 pm

    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!

  5. Andrew Ferguson Says:
    July 3rd, 2007 at 11:44 pm

    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

Please vote for me at photoblogs.org if you like what you see.

Don't like adverts? Leave a comment and they disappear.