Modules by creation date

SQL

use enwikinews_p;
select actor_name, replace(ug_group,"editor","reviewer") from user_groups join actor_user on actor_user=ug_user
where ((ug_group="sysop" or ug_group="bureaucrat")
and not exists (select 1 from revision_userindex where rev_actor=actor_id and rev_timestamp > "20190412000000"))
or (ug_group="bureaucrat" and not exists (select 1 from logging_userindex where log_actor=actor_id and 
                                          log_type="rights" and log_timestamp > "20190412000000"))
-- logged admin action querying is too complex
or ((ug_group="editor") 
and not exists (select 1 from revision_userindex join change_tag on ct_rev_id=rev_id join change_tag_def on ctd_id=ct_tag_id
                where rev_actor=actor_id and rev_timestamp > "20190412000000" and ctd_name="mw-rollback") -- rollback
and not exists (select 1 from logging_userindex where log_actor=actor_id and log_type="review" and log_timestamp > "20190412000000") -- review
-- and not exists (select 1 from revision_userindex join comment_revision on rev_comment_id=comment_id 
                where rev_actor=actor_id and comment_text like "%easy peer review%")
-- Deliberately excluding rights also held by autoconfirmed
)
SQL

Checking query status...
