SELECT  

 actor_name,  

 user.user_editcount,  

 MAX(rev_timestamp) AS last_edit_date

 FROM  actor  

 JOIN user ON actor.actor_user = user.user_id  

 LEFT JOIN revision_userindex ON rev_actor = actor.actor_id

 WHERE  user.user_editcount > 5000  AND actor_name NOT REGEXP '(?i)bot'  

 AND NOT EXISTS (    

   SELECT 1    

   FROM revision_userindex    

   WHERE rev_actor = actor.actor_id      

   AND rev_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 5 YEAR), '%Y%m%d%H%i%s')  

 )

   GROUP BY  actor.actor_user, actor_name, user.user_editcount

   ORDER BY  last_edit_date DESC;