Untitled query #72057

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` 
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 `user_properties`.`up_value` = NOT 'female'+'male' 
ORDER BY `user`.`user_editcount` DESC;
SQL

Checking query status...
