SQL
AخA
use tewiki_p;
select
rev_actor,
actor_name,
count(rev_id) as edit_count
from
revision,
actor,
user,
user_groups
where
user_id = actor_user and
ug_user = actor_user and
ug_group != 'bot' and
rev_timestamp < 20190100000000 and
rev_actor = actor_id and
rev_actor not in (select rev_actor from revision where rev_timestamp > 20190100000000)
group by
rev_actor
having
count(rev_id) > 500
order by
count(rev_id) desc
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.