Luckily we can find out who was thanked too, it takes the same time to
run. Data below and link for updated report (which is on wikitech due
to WMF server outage for main projects at the time of writing).

* 
https://wikitech.wikimedia.org/w/index.php?title=User:F%C3%A6/sandbox&oldid=143073

Extending to other wikis is not a problem, we just use the relevant
wiki-name of the tables, or call on it when we go into MySQL (and then
the script does not need to be edited). It should be possible to do a
nice report that does this for all active wikis; once a month is
enough. I have published the SQL below for those technically minded.
If someone wants to pick this up, that's cool. If left to me it may
take a couple of months to polish off due to my backlog. My other
maintained reports are mostly listed at
https://commons.wikimedia.org/wiki/User:F%C3%A6/reports

Top 10 *most thanked* users in Jan 2015:

English Wikipedia:

351, Ryulong
212, Niceguyedc
151, Ssven2
119, Materialscientist
111, HJ Mitchell
100, Ser Amantio di Nicolao
89, GoingBatty
89, Drmies
87, John of Reading
79, Rocketrod1960

Wikimedia Commons:

47,  Steinsplitter
44,  INeverCry
44,  Thibaut120094
44,  1989
37,  Yann
32,  Medium69
27,  Be..anyone
26,  Brackenheim
22,  ArionEstar
21,  Marcus_Cyron

SQL:
// Top 10 thanks givers in a month
SELECT log_user_text, count(log_action)
FROM logging_userindex
WHERE log_action="thank"
  AND LEFT(log_timestamp,6)="201501"
GROUP BY log_user_text
ORDER BY count(log_action) DESC
LIMIT 10;

// Top 10 thanked people in a month
SELECT log_title, count(log_action)
FROM logging_userindex
WHERE log_action="thank"
  AND LEFT(log_timestamp,6)="201501"
GROUP BY log_title
ORDER BY count(log_action) DESC
LIMIT 10;

P.S. I would be cautious about interpretation. I am tempted to
automate some thanking, just for my name to float in the top 10 and
surprise everyone. ;-)

On 5 February 2015 at 16:18, Richard Farmbrough
<rich...@farmbrough.co.uk> wrote:
> Who was most thanked?
>
> On 5 February 2015 at 15:47, Fæ <fae...@gmail.com> wrote:
>
>> Hi,
>>
>> After reading an interesting related discussion on GenderGap, I have
>> queried the top 10 users of the thanks feature last month, on both the
>> English Wikipedia and Commons. Snapshot image attached and report link
>> below.
>>
>> Perhaps someone might think of a suitable barnstar and award these
>> folks for "being nice"? :-)
>>
>> Link:
>> http://commons.wikimedia.org/w/index.php?title=User:F%C3%A6/sandbox&oldid=149050523

Fae

_______________________________________________
Wikimedia-l mailing list, guidelines at: 
https://meta.wikimedia.org/wiki/Mailing_lists/Guidelines
Wikimedia-l@lists.wikimedia.org
Unsubscribe: https://lists.wikimedia.org/mailman/listinfo/wikimedia-l, 
<mailto:wikimedia-l-requ...@lists.wikimedia.org?subject=unsubscribe>

Reply via email to