Tukang Ronda paling aktif 2017 - hanya artikel

https://github.com/MusikAnimal/MusikBot/blob/master/tasks/top_article_reviewers.rb
Most patrol by user (2017) - only in main namespace

SQL

use idwiki_p;
SELECT logtemp.log_user_text AS `reviewer`,
      COUNT(DISTINCT(logtemp.log_page)) AS `reviews`
      FROM (
        SELECT log_user_text, log_page
        FROM logging_userindex
        WHERE log_timestamp BETWEEN 20171201000000 AND 20171231000000
        AND log_type = 'patrol'
        AND log_action = 'patrol'
        AND log_namespace = 0
        UNION
        SELECT log_user_text, log_page
        FROM logging_userindex
        WHERE log_timestamp BETWEEN 20171201000000 AND 20171231000000
        AND log_type = 'pagetriage-curation'
        AND log_action = 'reviewed'
        AND log_namespace = 0
      ) logtemp
      GROUP BY reviewer
      ORDER BY reviews DESC
      LIMIT 100;

SQL

Checking query status...