<div dir="ltr"><div>:) ¡Gracias, Platonides! </div><div><br></div><div>Ya yo estaba pensando que no era posible, pero esa idea tuya es buena para lo que busco:</div><div><br></div><div>El período que quisiera revisar es del 1ero de abril al 31 de mayo de 2014</div>
<div><br></div><div>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.</div><div><br></div><div>La segunda pregunta es para sacar eso mismo que tienes en ese link. ¡Está perfecto!</div>
<div><br></div><div>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.</div>
<div><br></div><div>¡Muchas gracias!</div><div><br></div><div>Fhaidel.-</div><div><br></div><div><br></div><div>-------- English for the community --------</div><div><br></div><div>Thanks Platonides,</div><div><br></div><div>
I already was thinking it wasn't possible but your idea is good for what I'm looking for: </div><div><br></div><div>I know the time frame I would like to check: Apr 1st - May 31st 2014</div><div><br></div><div>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.</div>
<div><br></div><div>My second question was looking for what you exactly got in your link. That's great! </div><div><br></div><div>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. </div>
<div><br></div><div>Thank you so much!</div><div><br></div><div>Fhaidel.-</div><div><br></div><div><span style="font-family:arial,sans-serif;font-size:13px"><br></span></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2014-05-11 22:07 GMT+02:00 Platonides <span dir="ltr"><<a href="mailto:platonides@gmail.com" target="_blank">platonides@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">On 06/05/14 12:40, Fhaidel Domínguez wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi everybody,<br>
<br>
Does anybody know any tool to get a list of deleted images under a<br>
category in commons,<br>
</blockquote>
<br></div>
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.<div class="">
<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
and any other tool to get a list of a category<br>
users details such as user name and registration date?<br>
<br>
I'm appointing to get some management tasks and internal metrics for<br>
"Wikiviajes por Venezuela 2014" a photo contest run by Wikimedia<br>
Venezuela currently.<br>
<br>
This is the category:<br>
<a href="https://commons.wikimedia.org/wiki/Category:Wikiviajes_por_Venezuela_2014" target="_blank">https://commons.wikimedia.org/<u></u>wiki/Category:Wikiviajes_por_<u></u>Venezuela_2014</a><br>
</blockquote>
<br></div>
Assuming you want the user that uploaded the first version of each of the images on that category, what you want is:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
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_<u></u>2014';<br>
</blockquote>
<br>
I've left the list of 398 users at <a href="http://toolserver.org/~platonides/sandbox/Usuarios-Wikiviajes_por_Venezuela_2014-20140511200000.txt" target="_blank">http://toolserver.org/~<u></u>platonides/sandbox/Usuarios-<u></u>Wikiviajes_por_Venezuela_2014-<u></u>20140511200000.txt</a><br>
<br>
As expected, most are new users:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
2014 370 92.9648% (1 in March, 187 in April, 182 in May)<br>
2013 6 1.50754%<br>
2012 6 1.50754%<br>
2011 3 0.753769%<br>
2010 6 1.50754%<br>
2009 2 0.502513%<br>
2008 2 0.502513%<br>
2007 1 0.251256%<br>
2006 2 0.502513%<br>
</blockquote>
<br>
<br>
Fun fact: you are the second oldest participant. ☺<div class=""><br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Any help is appreciated,<br>
<br>
Thanks,<br>
</blockquote>
<br></div>
You're welcome<div class="HOEnZb"><div class="h5"><br>
<br>
______________________________<u></u>_________________<br>
Wiki Loves Monuments mailing list<br>
<a href="mailto:WikiLovesMonuments@lists.wikimedia.org" target="_blank">WikiLovesMonuments@lists.<u></u>wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments" target="_blank">https://lists.wikimedia.org/<u></u>mailman/listinfo/<u></u>wikilovesmonuments</a><br>
<a href="http://www.wikilovesmonuments.org" target="_blank">http://www.wikilovesmonuments.<u></u>org</a></div></div></blockquote></div><br>
</div></div>