Untitled query #63805

SQL

SET @Initial = "20181001000000";

WITH
cat_filter AS (
  SELECT rev_id, rev_actor
  FROM categorylinks
  INNER JOIN revision ON cl_from = rev_page
  WHERE cl_to = "Images_from_Wiki_Loves_Monuments_2018" AND cl_type = "file" AND rev_parent_id = 0),

newuser_filter AS (
  SELECT DISTINCT actor_user, actor_id
  FROM cat_filter
  INNER JOIN actor ON actor_id = rev_actor AND rev_actor != 0
  INNER JOIN user ON actor_user = user_id AND user_id != 0
  WHERE user_registration BETWEEN "20180901000000" and "20180930235959" AND user_name NOT LIKE '%Bot%'),
  
edit_filter AS (
  SELECT user_name, user_registration, user_id, rev_timestamp, rev_id
  FROM newuser_filter
  INNER JOIN user ON actor_user = user_id
  RIGHT JOIN revision ON actor_id = rev_actor AND rev_actor IS NOT NULL),

editspermonth_filter AS (
  SELECT user_name, user_registration, SUM(DATEDIFF(rev_timestamp, @Initial) BETWEEN 0 AND 30) AS after_thirty_days,
  		 SUM(DATEDIFF(rev_timestamp, @Initial) BETWEEN 31 AND 60) AS after_sixty_days,
  		 SUM(DATEDIFF(rev_timestamp, @Initial) BETWEEN 61 AND 90) AS after_ninty_days,
  		 SUM(DATEDIFF(rev_timestamp, @Initial) BETWEEN 91 AND 120) AS after_onetwenty_days
  FROM edit_filter
  WHERE user_name IS NOT NULL
  GROUP BY user_name)
  
SELECT COUNT(DISTINCT user_name),
	   CASE
       		WHEN after_thirty_days BETWEEN 0 AND 5 THEN 'Less than Five EPM'
            WHEN after_thirty_days >= 5 THEN 'Five EPM'
            WHEN after_thirty_days >= 5 AND after_sixty_days >= 5 THEN 'Five EPM for next sixty days'
            WHEN after_thirty_days >= 5 AND after_sixty_days >= 5 AND after_ninty_days >=5 THEN 'Five EPM for next ninty months'
       END AS EPM
  #IF(after_thirty_days >= 5, COUNT(DISTINCT user_name), 0) AS above_five_per_month
FROM editspermonth_filter
GROUP BY EPM
SQL

Checking query status...
