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

SQL

select distinct user_name from user,actor
where 
/* actor_user=user_id
/*and actor_name not like "%Bot%"
and actor_name not like "%bot%"
and actor_name not like "%Awb%"
and actor_name not like "%AWB%"
and 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) >= "202306"
group by rev_actor
--                       having count(rev_actor)>0
                      )*/
actor_user=user_id 
-- and rev_actor=actor_id
and actor_id not in (select rev_actor from revision where rev_timestamp >="20240000000000")
and user_editcount>=500
order by user_name

SQL

Checking query status...