New Page Reviewers eligible for barnstars - 2022(articles)

Fork of New Page Reviewers eligible for barnstars - 2022(articles) by MPGuy2824

This query is marked as a draft This query has been published by Dr vulpes.

SQL

SELECT actor_name AS `Reviewer`,
      COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Article Reviews`
      FROM (
        SELECT distinct log_actor, log_page, page_is_redirect
        FROM logging_userindex
		JOIN page ON page_title = log_title AND page_namespace = log_namespace
        WHERE log_timestamp BETWEEN 20200101000000 AND 20240101000000
        AND 
        ((log_type = 'patrol'  AND log_action = 'patrol') OR
         (log_type = 'pagetriage-curation' AND log_action = 'reviewed'))
        AND log_namespace = 0
      ) logtemp
      JOIN actor ON actor_id = log_actor
      JOIN user ON actor_user = user_id
      left JOIN ipblocks ON ipb_user = user_id
      where ipb_sitewide IS NULL
      GROUP BY reviewer
      HAVING `Article Reviews` >= 100
      ORDER BY `Article Reviews` DESC
      limit 100;

SQL

Checking query status...