Hello Commoners, Happy New Year!
Guess what? Over 500 images became Featured Pictures in 2007! In 2006 there were only about 330 IIRC so that is really impressive growth.
I put them all on one page here: http://commons.wikimedia.org/wiki/User:Pfctdayelise/POTY07_categories/2007_list
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.)
These images will make up the entries to the Picture of the Year competition which starts soon, so it would be awful if any slipped through the cracks. http://commons.wikimedia.org/wiki/COM:POTY/2007
Congratulations and thanks to all the people who take part in FP, photographers, illustrators, commenters and constructive-criticisers. :)
cheers Brianna user:pfctdayelise
On Jan 2, 2008 7:22 PM, Brianna Laugher brianna.laugher@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...
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.
On 02/01/2008, Stephen Bain stephen.bain@gmail.com wrote:
On Jan 2, 2008 7:22 PM, Brianna Laugher brianna.laugher@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...
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.
Thanks, got it.
cheers Brianna
Update: The final number for 2007 is... 515.
There were 507 from the manual list, two had since been deleted, and I found 10 from the API that missed getting added to the manual list.
They are now all at http://commons.wikimedia.org/wiki/User:Pfctdayelise/POTY07_categories/2007_list sorted alphabetically.
cheers Brianna
On 02/01/2008, Brianna Laugher brianna.laugher@gmail.com wrote: