[Commons-l] 507 FPs in 2007

[Stephen Bain]

On Jan 2, 2008 7:22 PM, Brianna Laugher <brianna.laugher at gmail.com> wrote:
>
> Could someone who is more SQL-savvy than me possibly run a query to
> get this same list, so I have something to double-check against? (I'm
> pretty sure this one was hand-compiled.)

You can use the API to do something close to this:

http://commons.wikimedia.org/w/api.php?action=query&list=categorymembers&cmcategory=Featured%20pictures&cmsort=timestamp&cmdir=desc&cmprop=title|timestamp

That query will get you all members of [[Category:Featured pictures]]
sorted by the time they were added to the category. Someone will just
have to get the whole list and filter for dates within 2007.

-- 
Stephen Bain
stephen.bain at gmail.com