Page graylist for stabilization

SQL

USE fiwiki_p;
SELECT
  page_title,
  rc,
  ac,
  ec,
  "" as empty,
  rd_c,
  ad_c,
  ed_c,
  "" as empty2,
  round(rc/ec,3) as r_ratio,
  round(ac/ec,3) as a_ratio,
  "" as empty3,
  round(rd_c/ed_c,3) as rd_ratio,
  round(ad_c/ed_c,3) as ad_ratio 
FROM
(
  SELECT 
    page_title,
    sum(1) as ec,
    count(distinct(floor(rev_timestamp/1000000))) as ed_c 
  FROM
    page,
    revision_userindex
  WHERE 
    rev_page=page_id
    AND page_namespace=0 
    AND rev_user=0
    AND datediff(now(), str_to_date(rev_timestamp, "%Y%m%d%H%i%s")) <365
  GROUP BY page_id
) as edits,
  (
  SELECT 
    sum(1) as rc,
    count(distinct(floor(rev_timestamp/1000000))) as rd_c, 
    page_title as revert_title
    FROM 
       page, 
       revision_userindex, 
       tag_summary 
    WHERE 
       rev_page=page_id 
       AND page_namespace=0 
       AND datediff(now(), str_to_date(rev_timestamp, "%Y%m%d%H%i%s")) <365 
       AND ts_rev_id=rev_id 
       AND ts_tags LIKE "%rv%" 
    GROUP BY page_id
  ) as reverts,
  (
  SELECT
    sum(1) as ac,
    count(distinct(floor(afl_timestamp/1000000))) as ad_c,
    afl_title 
  FROM
    abuse_filter_log 
  WHERE
     datediff(now(), str_to_date(afl_timestamp, "%Y%m%d%H%i%s")) <365
     AND afl_namespace=0
  GROUP BY afl_title
  ) AS abusefilter
WHERE
  page_title=revert_title
  AND afl_title=page_title
  AND rd_c > 3
  AND (rc/ec) > 0.3
  AND (rd_c/ed_c) > 0.3
  AND (ad_c/ed_c) > 0.2
GROUP BY page_title
ORDER BY rd_c
SQL

Checking query status...
