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

SQL

​x
 
SELECT
    ug_user,
    CONCAT('[[User:', user_name, '|', user_name, ']]') AS 'Username'
FROM
(
    SELECT ug_user, ug_group
    FROM user_groups
    WHERE ug_group = 'patroller'
) ug
LEFT JOIN
(
    SELECT DISTINCT log_user
    FROM logging_userindex
    WHERE
        log_type='pagetriage-curation'
        AND log_deleted = 0
        AND log_timestamp >= 20161101000000
) l ON l.log_user = ug_user
LEFT JOIN `user` on ug_user = user_id
WHERE l.log_user IS NULL;
​
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...