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

SQL

select actor1.actor_name,count(rev1.rev_actor) from revision rev1,actor actor1,page page1
where page1.page_id=rev1.rev_page
and actor1.actor_id=rev1.rev_actor
-- and page_namespace=0
-- and user_id=actor_user
-- and actor_name like "%AWB%"
and count(rev1.rev_actor) >99
/*and actor_name not like "%Bot%"
and actor_name not like "%bot%"
and actor_name not like "%Awb%"
and actor_name not like "%AWB%"*/
group by rev1.rev_actor
having actor1.actor_name in (select actor_name from revision,actor,page
where page_id=rev_page
and actor_id=rev_actor
-- and page_namespace=0
-- and user_id=actor_user
-- and actor_name like "%AWB%"
and substr(rev_timestamp,1,4) in ("2023","2022","2021")
and actor_name not like "%Bot%"
and actor_name not like "%bot%"
and actor_name not like "%Awb%"
and actor_name not like "%AWB%"
                      group by rev_actor)
                      -- having count(rev_actor) >99
order by count(rev1.rev_actor) desc
SQL

Checking query status...
