1000 maiores editores da ptwiki por número de edição e gênero

SQL

SELECT 
	`user`.`user_name` AS `Nome`, 
    `user`.`user_registration` AS `Registro`, 
    `user`.`user_editcount` AS `Nº edições`, 
    `revs`.`last_edit` AS `Última ed.`
FROM `user` 
LEFT JOIN `user_properties` ON `user`.`user_id` = `user_properties`.`up_user` and up_property = "gender"
LEFT JOIN `actor` ON `user`.`user_id` = `actor`.`actor_user`
LEFT JOIN (
  SELECT rev_actor, MAX(rev_timestamp) AS last_edit 
  FROM revision 
  GROUP BY rev_actor
) AS `revs` ON `revs`.`rev_actor` = `actor`.`actor_id`
 WHERE ug_group is null AND rev_timestamp BETWEEN 20230101000000 AND 20230301000000
ORDER BY `user`.`user_editcount` DESC;

SQL

Checking query status...