Flagged revision recenct change reviews. Single day

SQL

use dewiki_p;

-- select t.*, fr_timestamp, fr_flags from (select rc_title, rc_this_oldid, min(fr1.fr_rev_id) as min_fr_rev_id, min(fr2.fr_rev_id) as first_fr_rev_id, rc_timestamp, group_concat(distinct(ctd_name)) as ct from recentchanges LEFT JOIN flaggedrevs as fr1 ON rc_cur_id = fr1.fr_page_id and fr1.fr_rev_id >= rc_this_oldid LEFT JOIN change_tag ON rc_id=ct_rc_id LEFT JOIN change_tag_def ON ct_tag_id=ctd_id LEFT JOIN flaggedrevs as fr2 ON fr2.fr_page_id=rc_cur_id WHERE rc_source="mw.edit" and rc_namespace = 0 and rc_bot=0  and datediff(now(), str_to_date(rc_timestamp, "%Y%m%d%H%i%S"))=15 group by rc_this_oldid) as t LEFT JOIN flaggedrevs as fr3 ON min_fr_rev_id=fr_rev_id;
-- select t.*, fr_timestamp, fr_flags from (select rc_title, rc_this_oldid, min(fr1.fr_rev_id) as min_fr_rev_id, fr2.fr_rev_id as first_fr_rev_id, rc_timestamp, group_concat(distinct(ctd_name)) as ct from recentchanges LEFT JOIN flaggedrevs as fr1 ON rc_cur_id = fr1.fr_page_id and fr1.fr_rev_id >= rc_this_oldid LEFT JOIN change_tag ON rc_id=ct_rc_id LEFT JOIN change_tag_def ON ct_tag_id=ctd_id LEFT JOIN flaggedrevs as fr2 ON fr2.fr_page_id=rc_cur_id and fr2.fr_rev_id < rc_this_oldid WHERE rc_source="mw.edit" and rc_namespace = 0 and rc_bot=0  and datediff(now(), str_to_date(rc_timestamp, "%Y%m%d%H%i%S"))=15 group by rc_this_oldid) as t LEFT JOIN flaggedrevs as fr3 ON min_fr_rev_id=fr_rev_id
select t.*, min(fr2.fr_rev_id) as first_fr_rev_id, fr3.fr_timestamp, fr3.fr_flags from (select rc_title, rc_cur_id, rc_this_oldid, min(fr1.fr_rev_id) as min_fr_rev_id, rc_timestamp, group_concat(distinct(ctd_name)) as ct from recentchanges LEFT JOIN flaggedrevs as fr1 ON rc_cur_id = fr1.fr_page_id and fr1.fr_rev_id >= rc_this_oldid LEFT JOIN change_tag ON rc_id=ct_rc_id LEFT JOIN change_tag_def ON ct_tag_id=ctd_id WHERE rc_source="mw.edit" and rc_namespace = 0 and rc_bot=0  and datediff(now(), str_to_date(rc_timestamp, "%Y%m%d%H%i%S"))=15 group by rc_this_oldid) as t LEFT JOIN flaggedrevs as fr2 ON rc_cur_id=fr2.fr_page_id and fr2.fr_rev_id<rc_this_oldid LEFT JOIN flaggedrevs as fr3 ON min_fr_rev_id=fr3.fr_rev_id group by rc_this_oldid;
SQL

Checking query status...
