Untitled query #63531

SQL

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 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") -- 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...
