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 > 20191000000000
AND lg.log_namespace = 2
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' )
)
LIMIT 100
SQL

Checking query status...
