User:Faebot/thanks

Top ten thanks reports

Scope

This family of reports is a summary of the top ten users of thanks and the most thanked accounts on different Wikimedia projects. The database queries take a fairly long time to run, so this informal report is only updated once a month but retrospectively includes data from the start of 2014.

Please contact Fæ if you would like a project added to this report, or use Special:EmailUser/Faebot in confidence if you would like a courtesy opt-out for your account(s) from the reports.

Projects included

Wiki	Link
Commons	/commons
Meta	/meta
English Wikipedia	/en
French Wikipedia	/fr
Arabic Wikipedia	/ar
Russian Wikipedia	/ru
Norwegian Wikipedia	/no
Spanish Wikipedia	/es
Portuguese Wikipedia	/pt
Ukrainian Wikipedia	/uk
Polish Wikipedia	/pl
Esperanto Wikipedia	/eo
Wikidata	/wikidata
Outreach wiki	/outreach

Links in red have been added to Faebot's programme, but may need to wait for a scheduled run of the report.

Folders automatic list

Pages with the prefix 'Faebot/thanks' in the 'User ' and 'User talk' namespaces:

User :

• Faebot/thanks
• Faebot/thanks/ar
• Faebot/thanks/commons
• Faebot/thanks/de
• Faebot/thanks/en
• Faebot/thanks/eo
• Faebot/thanks/es
• Faebot/thanks/fr
• Faebot/thanks/meta
• Faebot/thanks/no
• Faebot/thanks/outreach
• Faebot/thanks/pl
• Faebot/thanks/pt
• Faebot/thanks/ru
• Faebot/thanks/uk
• Faebot/thanks/wikidata

User talk:

Query source code

To see a running example, refer to http://quarry.wmflabs.org/query/7218. As the log_action table can be extremely large, queries may take hours for some wikis, though others may completed in a minute or two. The variation is probably related to indexing, use of GROUP BY, and the relationship between number of editors and total number of logged actions they make.

The underpinning SQL used looks like:

Variables:
 {0} = wikiname
 {1} = month
 {2} = accounts to skip

SELECT log_user_text,
  COUNT(log_action)
  FROM {0}wiki_p.logging_userindex
WHERE log_action="thank"
  AND LEFT(log_timestamp,6)="{1}"
  AND log_user_text NOT IN {2}
GROUP BY log_user_text
ORDER BY COUNT(log_action) DESC
LIMIT 10;

See also

• https://github.com/happy5214/pwb-thanks-reports - Pywikibot script which produces the same reports.