Untitled query #18923

SQL

SELECT user_name, user_editcount, user_registration
FROM `user`
JOIN user_groups ug1
        ON user_id = ug1.ug_user AND ug1.ug_group = 'extendedconfirmed'
LEFT JOIN user_groups ug2
        ON user_id = ug2.ug_user AND ug2.ug_group = 'sysop'
LEFT JOIN user_groups ug3
        ON user_id = ug3.ug_user AND ug3.ug_group = 'bot'
LEFT JOIN ipblocks blk
        ON user_id = ipb_user
WHERE user_editcount >= 10000
        AND user_registration <= 20150527000000
        AND ug2.ug_group IS NULL
        AND ug3.ug_group IS NULL
        AND blk.ipb_id IS NULL
        AND EXISTS (
                SELECT *
                FROM revision
                WHERE revision.rev_user = user.user_id
                        AND revision.rev_timestamp >= 20170000000000
        )
LIMIT 5;
SQL

Checking query status...
