This query is marked as a draft This query has been published by Michael Schönitzer (WMDE).

SQL

AخA
 
USE dewiki_p;
SELECT user_name as 'Accountname', user_registration as 'Datum der Registrierung', user_editcount as 'Editcounter'
From user_properties
inner join user
    on user_properties.up_user = user.user_id
    and user_properties.up_property = "gender"
    and user_properties.up_value = "female"
    and user_editcount > 1
Order by user_editcount desc
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query
All SQL code is licensed under CC0 License.

Checking query status...