USE frwiki_p;

SELECT rev_actor, actor_name, MAX(rev_timestamp) AS last_edit

FROM revision 

JOIN actor ON revision.rev_actor=actor.actor_id 

WHERE actor_user IS NOT NULL # Only registered users

GROUP BY rev_actor HAVING last_edit < 20190101000000 LIMIT 6;