Hi this is the blogpost based on Sylvain's:
Ce matin, après 13 jours de concours, la 100 000ème photo vient d’être déposée. L’an dernier il avait fallu attendre le 25ème jour pour que ce chiffre soit atteinthttp://commons.wikimedia.org/wiki/File:Igreja_de_Santa_Clara_001.jpg .
Cette 100 000ème photo représente l’immeuble n°9 de la rue Kostyolnaya à Kiev (Ukraine) où a vécu Sergueï Korolevhttp://fr.wikipedia.org/wiki/Sergue%C3%AF_Korolev
Yesterday, after only 13 days of competition the 100.000thhttp://commons.wikimedia.org/wiki/File:Костёльная_9_Киев_2012_01.jpgphoto was uploaded. Last year it took us almost double the amount of time to reach that numberhttp://commons.wikimedia.org/wiki/File:Igreja_de_Santa_Clara_001.jpg. This photo represents the former home of Sergueï Korolevhttp://fr.wikipedia.org/wiki/Sergue%C3%AF_Korolev in Kiev (Ukraine) in the Kostyolnaya street n° 9. There image was taken by user AMY.
@lodewijk
could you use that for a blogpost?
thanks bfisch Barbara Fischer Kuratorin für Kulturpartnerschaften
Wikimedia Deutschland e.V. | NEU: Obentrautstr. 72 | 10963 Berlin Tel. (030) 219 158 26-0
Wikimedia Deutschland - Gesellschaft zur Förderung Freien Wissens e.V. Eingetragen im Vereinsregister des Amtsgerichts Berlin-Charlottenburg unter der Nummer 23855 B. Als gemeinnützig anerkannt durch das Finanzamt für Körperschaften I Berlin, Steuernummer 27/681/51985.
2012/9/13 Sylvain Machefert smachefert@gmail.com
Hi, we had just published a blog post ( http://wikilovesmonuments.fr/2012/09/13/100-000/ ) about the 100000th using the one that had been extracted from emijrp's logs of this morning, don't you mind if we stay on this first file so that everybody has got the same 100000th picture ? :)
Sylvain
2012/9/13 Platonides platonides@gmail.com
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
Wiki Loves Monuments mailing list WikiLovesMonuments@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments http://www.wikilovesmonuments.org