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&ol...
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 richard@farmbrough.co.uk wrote:
Who was most thanked?
On 5 February 2015 at 15:47, Fæ faewik@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&oldi...
Fae