Untitled query #20091

SQL

SELECT * FROM 
(
  SELECT 
     page_title, 
     rev_timestamp, 
     rev_user_text, 
     COUNT(DISTINCT(rev_id)) AS ec, 
     COUNT(DISTINCT(REPLACE(SUBSTR(REGEXP_SUBSTR(LOWER(rev_comment),'/(.*?)[|]'),2),"|", ""))) AS uc, 
     COUNT(DISTINCT(ts_rev_id)) AS rc, 
     COUNT(DISTINCT(afl_id)) AS ac, 
     COUNT(DISTINCT(afl_var_dump)) AS ac2, 
     COUNT(DISTINCT(floor(afl_timestamp/1000000))) AS ac3, 
     COUNT(DISTINCT(afl_user_text)) AS ac4, 
     ROUND(COUNT(DISTINCT(ts_rev_id))  / COUNT(DISTINCT(rev_id)),3) AS r_ratio
  FROM 
     abuse_filter_log, 
     revision
     LEFT JOIN tag_summary ON 
        ts_rev_id = rev_id 
        AND ts_tags LIKE "%rv%", page 
     WHERE 
        rev_page=page_id 
        AND page_namespace=0 
        AND rev_timestamp> 20170007104342 
        AND datediff(now(), str_to_date(rev_timestamp, "%Y%m%d%H%i%s")) <365 
        AND (ts_rev_id IS NULL OR rev_comment NOT LIKE concat("%/", rev_user_text,"%")) 
        AND afl_title=page_title 
        AND page_namespace=afl_namespace 
        AND  datediff(now(), str_to_date(afl_timestamp, "%Y%m%d%H%i%s")) <365 
     GROUP BY page_id 
) AS t
WHERE 
   ac>15 
   AND r_ratio > 0.2 
   AND rc > 7 
ORDER BY ac4 DESC 
LIMIT 100;
SQL

Checking query status...
