select count(*) as count0 from recentchanges where -- unpatrolled

    rc_timestamp > 20220530000000 and rc_timestamp < 20220606000000 and rc_patrolled = 0 and rc_type = 0;

select count(*) as count1 from recentchanges where -- manually

    rc_timestamp > 20220530000000 and rc_timestamp < 20220606000000 and rc_patrolled = 1 and rc_type = 0;

select count(*) as count2 from recentchanges where -- automatically

    rc_timestamp > 20220530000000 and rc_timestamp < 20220606000000 and rc_patrolled = 2 and rc_type = 0;