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

SQL

USE dewiki_p;
SELECT COUNT(user_name)
FROM user
JOIN user_properties 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
WHERE (NOT EXISTS ( SELECT * FROM user_properties WHERE user_properties.up_user = user.user_id AND user_properties.up_property = "disablemail" ) )
AND user_properties.up_value = "female"
AND user.user_registration > 20210101000000
AND user.user_registration < 20220101000000
AND edits_after >= "1"

SQL

Checking query status...