Untitled query #56363

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 = 883274
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 3000;
select count(*) from logging_userindex where log_actor = 883274 and log_type = 'pagetriage-curation' and log_action = 'reviewed'
and log_timestamp >= 20221001000000;
select * from actor where actor_user = 2087512
SQL

Checking query status...
