Contas na Wikipédia em português com gênero definido como "female"

SQL

SELECT `user`.`user_name`, `user`.`user_registration`, `user`.`user_editcount`, `revs`.`last_edit`
FROM `user` 
LEFT JOIN `user_properties` ON `user`.`user_id` = `user_properties`.`up_user` 
LEFT JOIN `actor` ON `user`.`user_id` = `actor`.`actor_user`
LEFT JOIN (
  SELECT rev_actor, MAX(rev_timestamp) AS last_edit 
  FROM revision 
  WHERE rev_timestamp <> '' 
  GROUP BY rev_actor
) AS `revs` ON `revs`.`rev_actor` = `actor`.`actor_user`
WHERE `user_properties`.`up_value` = 'female' 
ORDER BY `user`.`user_editcount` DESC;

SQL

Checking query status...