This query is marked as a draft This query has been published by Cryptic.

SQL

​x
 
SET @oneyear = DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -365 DAY), '%Y%m%d%H%i%s');
​
SELECT actor_name
FROM user_groups
JOIN actor_user ON actor_user = ug_user
WHERE ug_group = 'autoreviewer'
  AND NOT EXISTS
    (SELECT 1
     FROM revision_userindex
     WHERE rev_actor = actor_id
       AND rev_timestamp >= @oneyear
     LIMIT 1)
  AND NOT EXISTS
    (SELECT 1
     FROM archive_userindex
     WHERE ar_actor = actor_id
       AND ar_timestamp >= @oneyear
     LIMIT 1)
ORDER BY actor_name ASC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...