flaggedrevs_statistics example

SQL

SELECT 
	reviewed_pages_ns0.year,
    total_pages_ns0.frs_stat_val_avg as total_pages_ns0_avg,    
    reviewed_pages_ns0.frs_stat_val_avg as reviewed_pages_ns0_avg,
    synced_pages_ns0.frs_stat_val_avg as synced_pages_ns0_avg,
    reviewed_pages_ns0.frs_stat_val_avg - synced_pages_ns0.frs_stat_val_avg as pending_changes_avg
FROM
	(SELECT
		floor(frs_timestamp/10000000000) as year, 
		floor(avg(frs_stat_val)) as frs_stat_val_avg 
		FROM flaggedrevs_statistics 
		WHERE frs_stat_key="reviewedPages-NS:0" group by year
    ) as reviewed_pages_ns0,
	(SELECT
		floor(frs_timestamp/10000000000) as year, 
		floor(avg(frs_stat_val)) as frs_stat_val_avg 
		FROM flaggedrevs_statistics 
		WHERE frs_stat_key="syncedPages-NS:0" group by year
    ) as synced_pages_ns0,
    (SELECT
		floor(frs_timestamp/10000000000) as year, 
		floor(avg(frs_stat_val)) as frs_stat_val_avg 
		FROM flaggedrevs_statistics 
		WHERE frs_stat_key="totalPages-NS:0" group by year
    ) as total_pages_ns0
WHERE
	reviewed_pages_ns0.year = synced_pages_ns0.year
    AND reviewed_pages_ns0.year = total_pages_ns0.year
ORDER BY year
SQL

Checking query status...
