Unreviewed new redirects (with targets) by a particular user

SQL

#select * from user_groups join user on user_id=ug_user where user_name="MPGuy2824" limit 10;
#select * from logging where log_type="rights" and log_action!="autopromote" and log_timestamp>20220801000000 and log_params like "%newgroups%patroller%"and log_params not like "%oldgroups%patroller%newgroups%" limit 10;

#select * from logging where log_type="rights" and log_action!="autopromote" and log_timestamp>20220801000000 and log_params not like "%newgroups%patroller%"and log_params like "%patroller%newgroups%" limit 10;
select *, user_id, user_name as username from user join user_former_groups on user_id = ufg_user where ufg_group = 'patroller' 
order by user_name asc limit 10

SQL

Checking query status...