Most used templates on plwiki

SQL

use fiwiki_p; 
select page_title, 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
 group by page_id ) as n WHERE diff_len < 600;
SQL

Checking query status...
