User:Faebot/thanks

From Meta, a Wikimedia project coordination wiki
Jump to: navigation, search

Top ten thanks reports[edit]

Thank You.JPG

Scope[edit]

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 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[edit]

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
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[edit]

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

User talk:


Query source code[edit]

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[edit]