A Big Issue seller sits on a plastic chair outside a shopping centre in Maidenhead, in the UK.
Aperture | ƒ/3.5 |
Camera | Canon EOS 40D |
Focal length | 10mm |
ISO | 400 |
Shutter speed | 1/250s |
I was there too
A Big Issue seller sits on a plastic chair outside a shopping centre in Maidenhead, in the UK.
Aperture | ƒ/3.5 |
Camera | Canon EOS 40D |
Focal length | 10mm |
ISO | 400 |
Shutter speed | 1/250s |
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