Tewiki:Users with 499+ edits and active since 1 July 2023

SQL

select actor1.actor_name,count(rev1.rev_actor),user_registration from revision rev1,actor actor1,page page1,user
where page1.page_id=rev1.rev_page
and actor1.actor_id=rev1.rev_actor
and user_id=actor_user
and actor1.actor_name not like "%Bot%"
and actor1.actor_name not like "%bot%"
and actor1.actor_name not like "%Awb%"
and actor1.actor_name not like "%AWB%"
and actor1.actor_name not like "%>%"
and rev1.rev_actor in (select rev_actor from revision,actor
where actor_id=rev_actor
and substr(rev_timestamp,1,6) > "202305"
group by rev_actor
                       having count(rev_actor)>0)
group by rev1.rev_actor
having count(rev1.rev_actor) >499
order by count(rev1.rev_actor) desc

SQL

Checking query status...