stats of pseudo-autoreviewed redirects

SQL

select count(*) as Redirects
		from pagetriage_page 
		join page on ptrp_page_id=page_id and page_namespace=0
        where ptrp_reviewed=1 and page_is_redirect=1 
        and ptrp_last_reviewed_by=36553370 # DannyS712 bot III
		and left(ptrp_reviewed_updated, 8)='20230314';
select left(ptrp_reviewed_updated, 8) as review_date, ptrp_last_reviewed_by, count(*) as c
		from pagetriage_page 
		join page on ptrp_page_id=page_id and page_namespace=0
        where ptrp_reviewed=1 and page_is_redirect=1 
        and ptrp_last_reviewed_by=36553370 # DannyS712 bot III
group by review_date

SQL

Checking query status...