Untitled query #39278

SQL

USE fiwiki_p;
SELECT
	rc1.rc_title,
    rc1.rc_timestamp,
    rc1.rc_this_oldid AS r1_rev_id, 
    r2.rev_id AS r2_rev_id, 
    fp_stable, 
    fp_page_id, 
    actor_name, 
    rc_patrolled  
FROM 
	flaggedpages AS fp, 
    recentchanges AS rc1, 
    revision AS r2, 
    flaggedrevs AS fr1,  
    actor AS a1 
    LEFT JOIN (
      SELECT ug_user FROM user_groups 
      WHERE ug_group IN ('reviewer', 'sysop', 'autoreview', 'editor', 'autoreviewer', 'trusted') 
      GROUP BY ug_user
    ) AS ug1 ON ug1.ug_user=a1.actor_user  
WHERE 
	rc_cur_id=fp_page_id 
    AND rc_namespace=0 
    AND fr1.fr_rev_id=r2.rev_id 
    AND r2.rev_id=fp_stable 
    AND r2.rev_id=rc1.rc_last_oldid 
    AND rc1.rc_cur_id=fp.fp_page_id 
    AND fp_pending_since IS NOT NULL 
    AND fp_quality=0 
    AND rc_source="mw.edit" 
    AND rc1.rc_actor=a1.actor_id 
    AND ug_user IS NOT NULL;
SQL

Checking query status...
