Untitled query #80606

SQL

select * /* DATE_FORMAT(rc_uc.rc_timestamp, '%Y-%m-%d %H:%i:%s') as timestamp, rc_uc.rc_title */
from recentchanges_userindex
inner join actor_recentchanges on rc_actor = actor_id
inner join user on actor_user = user_id
where rc_type = 3
and rc_log_type = 'newusers'
and rc_timestamp >= '20240101010101'
and 3 in (
  select ct_tag_id
  from change_tag
  where rc_logid = ct_log_id
)
/*and rc_actor in (
  select distinct rev_actor
  from revision
  where rev_timestamp >= rc_timestamp
  and rev_page in (7754377)
)*/
and user_editcount > 0
/*and rc_title regexp '^[A-Z0-9]*$'*/
order by rc_timestamp desc;
SQL

Checking query status...
