Replicas browser and optimizer
This query is marked as a draft
This query has been published
Out of 16473 users with at least one contribution on trwiki that have indicated their gender, only 1552 (9.4%) are 'female' (for enwiki 14.8%). Among the ones registered in the last 100 days, the numbers are 214 and 27, so only 12.6% (for enwiki 22.7%). The percentages are worse for the total number of contributions; only 2.2% for all time and only 4.8% for the last 100 days (for enwiki 7.9% all-time and 20.3% last 100 days).
USE trwiki_p; SET @kacgun = -100; SELECT up_value, COUNT(*), SUM(user_editcount), SUM(user_editcount)/COUNT(*) as ort_edit #SELECT up_value, user_name, user_editcount FROM user JOIN user_properties ON up_user = user_id WHERE up_property ='gender' AND user_editcount > 0 AND user_name NOT LIKE '%Bot' # AND user_registration > date_add(now(), INTERVAL @kacgun DAY) GROUP BY up_value ; # ORDER BY up_value ASC, user_editcount DESC;
By running queries you agree to the
and you irrevocably agree to release your SQL under
All SQL code is licensed under
Checking query status...
Report a bug!
Wikimedia Cloud VPS
, written in