Fork of All female editors on German Wikipedia by registration date, 50+ edits 2020-11-01+ by DerHexer
This query is marked as a draft This query has been published by DerHexer.

SQL

AخA
 
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;
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...