recentchanges_test1

SQL

select rc.* 
from recentchanges rc
inner join revision rv on rc.rc_this_oldid = rv.rev_id 
inner join page p on rv.rev_page = p.page_id
left join actor ac on rv.rev_actor = ac.rev_actor
where rc.rc_type='0'  and rc.rc_timestamp <  '20220523000000'
and (
  rc.rc_actor in  (
    select ac.actor_id 
    from actor ac
    where ac.actor_user in (
      select u.user_id 
      from user u 
      where u.user_name='Cwek'
    )
  ) or 
  ac.actor_name = 'Cwek'
)
order by rc.rc_timestamp desc
limit 10;
/* group by t.rc_patrolled */

/*select UNIX_TIMESTAMP('2022-05-24 00:00:00') from dual;*/
SQL

Checking query status...
