I ran sql commonswiki_p "SELECT page_title, log_timestamp, log_user_text
from logging JOIN categorylinks ON (log_page = cl_from) LEFT JOIN page
ON (log_page = page_id) WHERE log_timestamp >= '20120831160000' AND
log_type='upload' AND log_action='upload' AND cl_to =
'Images_from_Wiki_Loves_Monuments_2012' ORDER BY log_timestamp ASC,
log_id ASC;" > wlm-100000.txt
This doesn't count the 17 files which were restored
http://toolserver.org/~platonides/wlm2012/restored.php but adds a header
line. So we want the line 99984 of the file.
> less -N wlm-100000.txt
j99984
> 99979 Костёльная_7_Киев_2012_01.jpg 20120913084725 AMY 81-412
> 99980 Parc_de_la_Ciutadella,_BCN,_Diada-12.JPG 20120913084741 Deosringas
> 99981 Parc_de_la_Ciutadella,_BCN,_Diada-13.JPG 20120913084835 Deosringas
> 99982 Костёльная_7_Киев_2012_02.jpg 20120913084857 AMY 81-412
> 99983 Украина,_Киев_-_ВДНХ_-_Павильон_10_'Зерновые_культуры'_03.jpg 20120913084908 Alexostrov
> ->99984 Portes_d'accés_al_Parc_de_la_Ciutadella,_BCN,_Diada-1.JPG 20120913084925 Deosringas
> 99985 Härlanda_kyrkoruin_2012-09-13_10-48-52.jpg 20120913084930 SM6XSG
> 99986 Pani_Kotha.JPG 20120913084952 Vijay Bhadani
Or if you prefer a one-liner:
> $ head -99984 wlm-100000.txt | tail -1
> Portes_d'accés_al_Parc_de_la_Ciutadella,_BCN,_Diada-1.JPG 20120913084925 Deosringas
The Zwierzyniecki_(2) file by emijrp is the 100005 in my record (ie. the
100021th upload).
It's odd that the timestamps are a bit different there between us, though.
The file http://toolserver.org/~platonides/sandbox/wlm-100000.txt
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org