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 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`,
SUM(IF(logtemp.page_is_redirect = 1, 0.1, 1)) as `Weighted Total`,
SUM(IF(logtemp.page_is_redirect = 1, 0.2, 1)) as `Drive 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 in ('reviewed', 'reviewed-article', 'reviewed-redirect')))
AND log_namespace = 0
) logtemp
JOIN actor ON actor_id = log_actor;
SELECT 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`,
SUM(IF(logtemp.page_is_redirect = 1, 0.1, 1)) as `Weighted Total`,
SUM(IF(logtemp.page_is_redirect = 1, 0.2, 1)) as `Drive 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
year(log_timestamp)=2024 and month(log_timestamp)=9
and log_actor=210623181
AND
((log_type = 'patrol' AND log_action = 'patrol') OR
(log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-article', 'reviewed-redirect')))
AND log_namespace = 0
) logtemp
JOIN actor ON actor_id = log_actor;
SELECT 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`,
SUM(IF(logtemp.page_is_redirect = 1, 0.1, 1)) as `Weighted 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
year(log_timestamp)=2024
and log_actor=210623181
AND
((log_type = 'patrol' AND log_action = 'patrol') OR
(log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-article', 'reviewed-redirect')))
AND log_namespace = 0
) logtemp
JOIN actor ON actor_id = log_actor;
SELECT 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`,
SUM(IF(logtemp.page_is_redirect = 1, 0.1, 1)) as `Weighted 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_actor=210623181
AND
((log_type = 'patrol' AND log_action = 'patrol') OR
(log_type = 'pagetriage-curation' AND log_action in ('reviewed', 'reviewed-article', 'reviewed-redirect')))
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.