User:Faebot/thanks
Scope
editThis 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
editWiki | 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 | |
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
editPages with the prefix 'Faebot/thanks' in the 'User ' and 'User talk' namespaces:
User :
User talk:
Query source code
editTo 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- https://github.com/happy5214/pwb-thanks-reports - Pywikibot script which produces the same reports.