[Wiki Loves Monuments] 100 000 ?
Paul Selitskas
p.selitskas at gmail.com
Thu Sep 13 19:54:19 UTC 2012
Just for the record:
It would be trickier and more interesting to have the current 100000
photos list, wait for Israel to gain a considerable number of photos,
then shift Israel's upload time to the point where the whole WLM
started, then merge the two lists that we have, then find out the most
honest 100000th photo. :)
On Thu, Sep 13, 2012 at 10:46 PM, Sylvain Machefert
<smachefert at gmail.com> wrote:
> 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 at 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 at lists.wikimedia.org
>> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
>> http://www.wikilovesmonuments.org
>
>
>
> _______________________________________________
> Wiki Loves Monuments mailing list
> WikiLovesMonuments at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
> http://www.wikilovesmonuments.org
--
З павагай,
Павел Селіцкас/Paul Selitskas
Wizardist @ Wikimedia projects
p.selitskas at gmail.com, +375257408304
Skype: p.selitskas
More information about the WikiLovesMonuments
mailing list