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
)
#  WHERE user_name = "Susu Phisi" )
  #INNER JOIN user ON actor_user = user_id AND user_id != 0)
 #SUM(DATEDIFF(rev_timestamp, user_registration) < 30 AND page_namespace = 0) AS early_main_edits 

SELECT user_name, user_registration, rev_timestamp, rev_id
#IF((DATEDIFF(@Initial, rev_timestamp) BETWEEN 0 AND 30), COUNT(rev_id), 0) AS after_thirty_days
	   #IF((DATEDIFF(@Initial, rev_timestamp) BETWEEN 31 AND 60), COUNT(rev_id), 0) AS after_sixty_days,
       #IF((DATEDIFF(@Initial, rev_timestamp) BETWEEN 61 AND 90), COUNT(rev_id), 0) AS after_ninty_days,
       #IF((DATEDIFF(@Initial, rev_timestamp) BETWEEN 91 AND 120), COUNT(rev_id), 0) AS after_onetwenty_days
       #rev_timestamp, @Initial, rev_timestamp, rev_id
FROM edit_filter
#WHERE user_name IS NOT NULL#and rev_timestamp = "20180930031551"
WHERE user_name = "SergKh78"
#GROUP BY user_name
#ORDER BY user_name #, 
ORDER BY rev_timestamp
#LIMIT 30

# DISTINCT user_name, user_registration, rev_id, rev_timestamp  user_name, user_registration, rev_id, rev_parent_id, rev_timestamp
# (COUNT(rev_id) IF DATEDIFF(rev_timestamp, @Initial) < 30) AS after_thirty_days
# IF(DATEDIFF(rev_timestamp, @Initial) BETWEEN 0 AND 30, COUNT(rev_id), NULL) 
# Check these users Garonzi Stefania, GaddielBohorquez, SergKh78
#Ulaisaeva, Susu Phisi, 	Tatiana Pantylei, Tsyganov Sergey, TP RADHAKRISHNAN, Tag Scientist, TheMajesticPilot, The paavam guy
SQL

Checking query status...
