All female editors on German Wikipedia with Wikimail set, sorted by user_id

SQL

USE arwiki_p;
SELECT 
 up_user,
 user.user_editcount,
 user.user_name
FROM user_properties
JOIN user ON user.user_id = user_properties.up_user
INNER JOIN (SELECT
             rev_user_text AS edit_username,
             COUNT(rev_id) AS edits_after
            FROM revision_compat
            WHERE rev_timestamp > "20200000000000"
            GROUP BY edit_username
           ) AS last_edits
           ON user.user_name = edit_username
WHERE (NOT EXISTS ( SELECT * FROM user_properties WHERE user_properties.up_user = user.user_id AND user_properties.up_property = "disablemail" ) )
AND up_value = "female"
AND user.user_editcount > 1000
AND edits_after >= "50"
ORDER BY up_user
LIMIT 100000;

SQL

Checking query status...