Untitled query #46122

SQL

use jawiki_p;
/*
SELECT *
FROM change_tag_def;
*/
SELECT A.*, RC.*
FROM `user` as U, `recentchanges` as RC, `logging` as LOG, `user_groups` as UG, `actor` as A
WHERE 1 = 1
and UG.ug_group = 'rollbacker'
and RC.rc_timestamp LIKE '2020062%'
and RC.rc_actor = A.actor_id
;

/*
SELECT U.user_id, U.user_name, U.user_editcount, UG.ug_group, RC.*
FROM `user` as U, `actor` as AC, `user_groups` as UG, `recentchanges` as RC
WHERE 1 = 1
and (UG.ug_group = 'rollbacker' or UG.ug_group = 'sysop')
and U.user_id = UG.ug_user
-- and RC.rc_actor = AC.actor_id
and AC.actor_user = U.user_id
and RC.rc_actor = AC.actor_id;
*/
SQL

Checking query status...
