IP graylist for stabilization

SQL

SELECT
  rev_user_text,
  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 
    rev_user_text,
    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 rev_user_text
) as edits,
  (
  SELECT 
    sum(1) as rc,
    count(distinct(floor(rev_timestamp/1000000))) as rd_c, 
    REPLACE(SUBSTR(REGEXP_SUBSTR(rev_comment,'/(.*?)[|]'),2),"|", "") as reverts_user_text
    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 reverts_user_text
  ) as reverts,
  (
  SELECT
    sum(1) as ac,
    count(distinct(floor(afl_timestamp/1000000))) as ad_c,
    afl_user_text 
  FROM
    abuse_filter_log 
  WHERE
     datediff(now(), str_to_date(afl_timestamp, "%Y%m%d%H%i%s")) <365
     AND afl_user=0
  GROUP BY afl_user_text
  ) AS abusefilter
WHERE
  rev_user_text=reverts_user_text
  AND afl_user_text=rev_user_text
  AND rd_c>2
  AND (rc/ec) > 0.3
  AND (rd_c/ed_c) > 0.3
  AND (ad_c/ed_c) > 0.2
GROUP BY rev_user_text
ORDER BY rd_c
SQL

Checking query status...
