Fork of
All New Page Reviewer (including null) activity since July 8th 2018 (excluding admins)
by Insertcleverphrasehere
This query is marked as a draft
This query has been published
by MPGuy2824.
SQL
AخA
SELECT actor_name AS `reviewer`,
COUNT(IF(logtemp.page_is_redirect = 0, 1, NULL)) as `Articles`,
COUNT(IF(logtemp.page_is_redirect = 1, 1, NULL)) as `Redirects`,
COUNT(DISTINCT(logtemp.log_page)) AS `Total`
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 (NOW() - INTERVAL 12 HOUR) AND NOW()
and log_actor=210623181
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.