select count(*) as cnt from revision_actor_temp

inner join revision on(revision_actor_temp.revactor_rev=revision.rev_id)

inner join actor on(revision_actor_temp.revactor_actor=actor.actor_id)

inner join user on(actor.actor_user=user.user_id)

where revision.rev_timestamp > '20200126000000'

and user.user_registration <= '20190826000000'

and user.user_editcount >= 500

group by revision_actor_temp.revactor_rev having cnt > 10;