On 06/05/14 12:40, Fhaidel Domínguez wrote:
Hi everybody,
Does anybody know any tool to get a list of deleted images under a
category in commons,
You can't. Once a page is deleted, it no longer belongs to any category.
If you know a time frame you could check (categorylinks) on an old dump
for images that were in that category, and then filter out those who
still exist.
and any other tool to get a list of a category
users details such as user name and registration date?
I'm appointing to get some management tasks and internal metrics for
"Wikiviajes por Venezuela 2014" a photo contest run by Wikimedia
Venezuela currently.
This is the category:
https://commons.wikimedia.org/wiki/Category:Wikiviajes_por_Venezuela_2014
Assuming you want the user that uploaded the first version of each of
the images on that category, what you want is:
SELECT DISTINCT user_name, user_registration FROM categorylinks LEFT JOIN
logging ON (log_page = cl_from AND log_type='upload' and log_action='upload')
LEFT JOIN user ON (user_id = log_user) WHERE cl_to
='Wikiviajes_por_Venezuela_2014';
I've left the list of 398 users at
http://toolserver.org/~platonides/sandbox/Usuarios-Wikiviajes_por_Venezuela_2014-20140511200000.txt
As expected, most are new users:
2014 370 92.9648% (1 in March, 187 in April, 182 in May)
2013 6 1.50754%
2012 6 1.50754%
2011 3 0.753769%
2010 6 1.50754%
2009 2 0.502513%
2008 2 0.502513%
2007 1 0.251256%
2006 2 0.502513%
Fun fact: you are the second oldest participant. ☺
Any help is appreciated,
Thanks,
You're welcome
_______________________________________________
Wiki Loves Monuments mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org
