use fiwiki_p;

​

SELECT user_name, user_registration FROM 

    (SELECT * FROM (SELECT sum(1) as c, rev_actor FROM revision_userindex WHERE  rev_timestamp>20190221005847 group by rev_actor) as t WHERE c>200) as t1,

    (SELECT actor_id, user_name, user_registration FROM actor_revision, user WHERE actor_user=user_id AND user_editcount>200 and user_registration < 20130004163115) as t2

WHERE 

    t2.actor_id=t1.rev_actor

ORDER BY user_registration;