Fork of
All female editors on German Wikipedia by registration date, 5+ 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 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"
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.