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.