recentchanges_test1

SQL

begin;
select count(rc.rc_id) sum_count,min(rc.rc_timestamp) min_tc_time
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.actor_id*/
where rc.rc_type in ('0')   /* and rc.rc_timestamp >=  '20220401000000'  and rc.rc_timestamp <  '20220501000000' */
;
select rc.rc_patrolled,count(rc.rc_id) patrolled_count
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.actor_id*/
where rc.rc_type in ('0')  /* and rc.rc_timestamp >=  '20220401000000'  and rc.rc_timestamp <  '20220501000000' */

/*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'
)*/
group by rc.rc_patrolled;
commit;
SQL

Checking query status...
