Untitled query #37917

SQL

use fawiki_p;

select page_title, sum(rv_count)
from (
    select 
        page_id, page_title, count(rev_sha1) as rv_count, fp_page_id, fp_stable
    from 
        revision 
        join page on page_id = rev_page
        join page_restrictions on page_id = pr_page
        left join flaggedpages on fp_page_id
    where 
        rev_timestamp > date_format(date_sub(now(), interval 1 day), '%Y%m%d') 
        and page_namespace = 0
        and not exists (
            select *
            from page_restrictions
            where pr_type = 'edit' and pr_page = page_id)
    group by 
        rev_sha1 ,page_id
) as rv_table
group by page_id
order by sum(rv_count) desc 
limit 30
;
SQL

Checking query status...
