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 * as username from user, user_former_groups where ufg_group = 'patroller' and user_id = ufg_user
order by user_name asc limit 10

SQL

Checking query status...