USE dewiki_p;

SELECT distinct 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

inner join actor on actor.actor_user = user.user_id

inner join recentchanges on recentchanges.rc_actor = actor.actor_id

Order by user_editcount desc