ALLCAPS (ALLCAPS)

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