Untitled query #317

SQL

use fiwiki_p; 
select page_id from (select page_id, fp_page_id,r1.rev_id,page.page_title,r1.rev_user, sum(abs(cast(r1.rev_len as int) - cast(r2.rev_len as int))) as diff_len, page_len, page.page_is_redirect, ugs.ug_user, min(r1.rev_parent_id) as parent_id from page left join flaggedpages on fp_page_id=page.page_id, revision as r1 LEFT JOIN (SELECT ug_user FROM user_groups WHERE ug_group IN ('editor', 'autoreview', 'admin','bot')) as ugs ON r1.rev_user=ug_user, revision as r2 where fp_page_id IS NULL AND r1.rev_page=page.page_id AND r1.rev_parent_id=r2.rev_id and ugs.ug_user IS NULL AND page_namespace = 0 and page_is_redirect = 0 AND page_len > 100 group by page_id ) as n WHERE diff_len < 600;
SQL

Checking query status...
