Untitled query #36357

SQL

SELECT
  lg.log_id, lg.log_type, lg.log_action, lg.log_actor, lg.log_namespace, lg.log_title, lg.log_page,
  a.*,
  rev.rev_id, rev.rev_parent_id
FROM
  logging lg
  JOIN actor AS a ON lg.log_actor = a.actor_id
  LEFT JOIN revision AS rev ON lg.log_page = rev.rev_page
WHERE
  lg.log_type = 'pagetriage-curation'
  AND lg.log_action <> 'enqueue'
  AND lg.log_timestamp > 20190900000000
  AND lg.log_namespace = 0
  AND rev.rev_parent_id = 0
  AND rev.rev_actor = lg.log_actor
  AND NOT EXISTS (
    SELECT
      1
    FROM
      user_groups ug
    WHERE
      ug_user = a.actor_user
      AND ug_group IN ('sysop', 'autoreviewer')
  )
/*
  AND NOT EXISTS (
    SELECT
      1
    FROM
      logging lg2
    WHERE
      lg2.log_page = lg.log_page
      AND lg2.log_action = 'enqueue'
      AND lg2.log_type = 'pagetriage-curation'
      AND lg2.log_actor = lg.log_actor
  )
*/
LIMIT 100
SQL

Checking query status...
