Patrollers w/no patrols in a year

SQL

SELECT * FROM
(
SELECT user_name,
       (SELECT log_timestamp
        FROM logging_userindex
        WHERE log_actor = actor_id
          AND log_type = 'pagetriage-curation'
        ORDER BY log_timestamp DESC
        LIMIT 1) AS last_curation
FROM user_groups
JOIN user ON user_id = ug_user
LEFT JOIN actor_revision ON actor_user = user_id
WHERE ug_group = 'patroller'
) sq
WHERE COALESCE(last_curation, 0) <= '20210825';

​x
 
SELECT * FROM(SELECT user_name,       (SELECT log_timestamp        FROM logging_userindex        WHERE log_actor = actor_id          AND log_type = 'pagetriage-curation'        ORDER BY log_timestamp DESC        LIMIT 1) AS last_curationFROM user_groupsJOIN user ON user_id = ug_userLEFT JOIN actor_revision ON actor_user = user_idWHERE ug_group = 'patroller') sqWHERE COALESCE(last_curation, 0) <= '20210825';​

SQL

Checking query status...