All female editors on German Wikipedia by registration date, 50+ edits 2020-11-01+

SQL

USE dewiki_p;
SELECT 
 user.user_name,
 user.user_editcount,
 user.user_registration,
 edits_before,
 edits_after
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 > "20201101000000"
            GROUP BY edit_username
           ) AS last_edits
           ON user.user_name = edit_username
INNER JOIN (SELECT
             rev_user_text AS edit_username2,
             COUNT(rev_id) AS edits_before
            FROM revision_compat
            WHERE rev_timestamp > "20010101000000"
            AND rev_timestamp < "20040101000000"
            GROUP BY edit_username2
           ) AS before_edits
           ON user_name = edit_username2
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 edits_before >= "1"
AND edits_after >= "50"
ORDER BY edits_after
LIMIT 100000;
SQL

Checking query status...
