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

SQL

AخA
 
SELECT
    user_name,
    user_editcount AS 'Edit count'
FROM `user`
WHERE user_name IN
    (
        SELECT log_user_text AS recent_user_text
        FROM logging_userindex
        WHERE log_type='patrol' AND log_timestamp >= 20150327000000
    ) AND user_editcount <= 1000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...