select user_name, count(*) as cnt from revision inner join user on(revision.rev_user=user.user_id) where rev_timestamp > 'timestamp_1_months_ago' and user_registration <= '20160626000000' and user_editcount >= 500 group by rev_user having cnt > 10;