Untitled query #63805

SQL

WITH

cat_filter AS (
  SELECT rev_timestamp, rev_id 
  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 user_name, user_registration
  FROM cat_filter
  INNER JOIN actor ON actor_user = user_id AND user_id != 0
  INNER JOIN revision ON rev_actor = actor_id AND rev_actor != 0
  WHERE user_registration BETWEEN "20180901000000" and "20180930235959" AND user_name NOT LIKE '%Bot%'),
  
SELECT rev_id, user_name, COUNT(DISTINCT timestamp) AS numRows
FROM newuser_filter
GROUP BY rev_id, user_name;
SQL

Checking query status...
