NPP reviews accounting for moved pages

SQL

select log_id as logid, page_title as title, log_timestamp as timestamp, page_is_redirect as redirect, rev_timestamp as last_edited
from logging_userindex, page, revision where log_namespace = 0 and page_namespace = 0 and log_page = page_id and log_actor = 6483
and log_type = 'pagetriage-curation' and log_action = 'reviewed' and log_timestamp >= 20221001000000 and rev_id = page_latest
order by page_is_redirect desc, log_id asc limit 1000;
select count(*) from logging_userindex where log_actor = 6483 and log_type = 'pagetriage-curation' and log_action = 'reviewed'
and log_timestamp >= 2022100100000

SQL

Checking query status...