commons double extension

SQL

set @by_date = "20231101010101";
select page_title, user_name from pagetriage_page  join page on page_id=ptrp_page_id join user on user_id=ptrp_last_reviewed_by
where ptrp_reviewed=3 and page_namespace=0 and page_is_redirect=0
and not exists (select 1 from user_groups where ug_user=user_id and (ug_group="autoreviewer" or ug_group="bot"))
order by ptrp_last_reviewed_by desc;
/* Not at all related to global rights, but a paranoia check in a query I run sporadically */
select page_title, user_name from pagetriage_page  join page on page_id=ptrp_page_id join user on user_id=ptrp_last_reviewed_by
where ptrp_last_reviewed_by=(select user_id from user where user_name="KHarlan (WMF)");
/* Also not at all related to global rights, but fits in with the autopatrolled misuse check above */
select * from logging_userindex join page on page_namespace=log_namespace and page_title=log_title
where log_actor=(select actor_id from actor_logging where actor_name="'zinbot")
and page_is_redirect=0
and log_timestamp > @by_date
and not exists (select 1 from templatelinks join linktarget on lt_id=tl_target_id where 
                tl_from=page_id and ((lt_namespace=828 and lt_title="RfD") 
                or (lt_namespace=10 and lt_title in ( "Disambiguation", "Set_index_article","Surname") -- Technical a protocol violation,
                    -- but these are common enough and need no action
                   )))
and not exists (select 1 from logging_logindex  where logging_logindex.log_type="pagetriage-curation" 
                and logging_logindex.log_namespace=logging_userindex.log_namespace
                and logging_logindex.log_title = logging_userindex.log_title
                and logging_logindex.log_timestamp > logging_userindex.log_timestamp)
order by log_timestamp desc limit 10000;
SQL

Checking query status...
