[Wiki Loves Monuments] 100 000 ?

Platonides platonides at gmail.com
Thu Sep 13 18:49:47 UTC 2012


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




More information about the WikiLovesMonuments mailing list