:) ¡Gracias, Platonides!

Ya yo estaba pensando que no era posible, pero esa idea tuya es buena para lo que busco:

El período que quisiera revisar es del 1ero de abril al 31 de mayo de 2014

Ahora, si sé eso... ¿cómo puedo sacar ese volcado de las imágenes que estuvieron en esa categoría? Con CatScan podría comparar después y sacar el número así como tú dices.

La segunda pregunta es para sacar eso mismo que tienes en ese link. ¡Está perfecto!

Y bueno, así son las cosas :) Pero para que conste en los registros, yo no participo. Solo contribuyo como usuario. Lamentablemente, según las bases, yo no puedo participar. :( Pero hay algo más interesante: el usuario más antiguo ha sido de hecho el primer participante.

¡Muchas gracias!

Fhaidel.-

-------- English for the community --------

Thanks Platonides,

I already was thinking it wasn't possible but your idea is good for what I'm looking for:

I know the time frame I would like to check: Apr 1st - May 31st 2014

Now, if I know it... how can I get an old dump for images that were in that category? Then, using CatScan I can compare and get the number in the way you comment.

My second question was looking for what you exactly got in your link. That's great!

And well... facts are facts :) Just for the records, I'm not a participant but a contributor user. Sadly I'm not a participant according to the contest rules. :( But there's something more interesting: the oldest user is in fact the first participant.

Thank you so much!

Fhaidel.-

2014-05-11 22:07 GMT+02:00 Platonides <platonides@gmail.com>:

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
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org