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

    rc_timestamp >= 20220528000000 and rc_patrolled = 0 and rc_new = 0;

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

    rc_timestamp >= 20220528000000 and rc_patrolled = 1 and rc_new = 0;

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

    rc_timestamp >= 20220528000000 and rc_patrolled = 2 and rc_new = 0;