Flagged revs bug T313700 example cases

SQL

select * from (
select 
	page_title, 
    r2.rev_timestamp, 
    r2.rev_user_text, 
    group_concat(ct1.ct_tag_id), 
    group_concat(distinct(ct2.ct_tag_id)), group_concat(ctd_name) as ctd_names 
from 
	page, 
    flaggedrevs as fr1, 
    revision as r1 
    	LEFT JOIN change_tag as ct1 ON r1.rev_id=ct1.ct_rev_id 
        LEFT JOIN change_tag_def as ctd1 ON ct1.ct_tag_id = ctd1.ctd_id, 
    revision_compat as r2 
    	LEFT JOIN flaggedrevs as fr2 ON r2.rev_id=fr2.fr_rev_id 
        LEFT JOIN change_tag as ct2 ON r2.rev_id=ct2.ct_rev_id AND ct2.ct_tag_id=88 
where 
	r1.rev_page=page_id 
    and page_namespace=0 
    and fr1.fr_rev_id> 19457869 
    and fr1.fr_rev_timestamp > 20210019104922 
    and fr1.fr_flags like "%auto%" 
    and fr1.fr_rev_id=r1.rev_id 
    and r2.rev_id=r1.rev_parent_id 
    and r2.rev_user=0 
    and ct2.ct_tag_id IS NULL 
    and fr2.fr_rev_id IS NULL 
group by r2.rev_id 
) as t
order by rev_timestamp;
SQL

Checking query status...
