Patrollers w/no patrols in a year

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

Users with the patroller right who have no enwiki patrols since 2021 August 25, and their most recent patrol (if any).

Compare query #9134.

For [[WP:RAQ#For NPP]] circa 20 Aug 2022.

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';

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 Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...