SQL
x
use tewiki_p;
select
rev_actor,
actor_name,
count(rev_id) as edit_count
from
revision,
actor
where
rev_timestamp < 20190100000000 and
rev_actor = actor_id and
rev_actor in (select rev_actor from revision where rev_timestamp > 20190100000000 group by rev_actor having count(rev_actor) < 10)
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.
Query status: complete
Executed in 12.51 seconds as of Sat, 26 Mar 2022 04:52:49 UTC.