Flagged revs pending_pages example for phab T177951

SQL

use dewiki_p;

select 
   frs1.d, 
   syncedpagesNS0, 
   reviewedpagesNS0, 
   reviewedPagesNS0 - syncedPagesNS0 as pending_pages 
from 
   (
     select 
        floor(frs_timestamp/1000000) as d, 
        frs_stat_key, 
        round(avg(frs_stat_val)) as syncedPagesNS0 
    from 
       flaggedrevs_statistics 
    where 
       frs_stat_key="syncedPages-NS:0" 
    group by d
 ) as frs1, 
 (
    select 
       floor(frs_timestamp/1000000) as d, 
       frs_stat_key, 
       round(avg(frs_stat_val)) as reviewedPagesNS0 
    from 
      flaggedrevs_statistics 
    where 
      frs_stat_key="reviewedPages-NS:0" 
    group by d
) as frs2 
where 
   frs1.d=frs2.d 
order by frs1.d;

SQL

Checking query status...