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:
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
5 replies on “Most popular photos of June 2007”
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
Josef – you should include your email address when commenting so I don’t have to moderate your comment each time!
Do I detect elements of Lorelle creeping in here 😉
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!
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 🙂