Untitled query #64712

SQL

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

newuser_filter AS (
  SELECT DISTINCT T4.actor_user, T4.actor_id
  FROM cat_filter AS T3
  INNER JOIN commonswiki_p.actor AS T4 ON T4.actor_id = T3.rev_actor AND T3.rev_actor != 0
  INNER JOIN commonswiki_p.user AS T5 ON T4.actor_user = T5.user_id AND T5.user_id != 0
  WHERE T5.user_registration BETWEEN "20170901000000" and "20170930235959" AND T5.user_name NOT LIKE '%Bot%'),
  
edit_filter AS (
  SELECT T6.user_name#, user_registration, user_id, rev_timestamp, rev_id
  FROM newuser_filter AS T5
  INNER JOIN user AS T6 ON T5.actor_user = T6.user_id)

SELECT gu_name, gu_home_db, gu_registration
FROM centralauth_p.globaluser AS T7
JOIN edit_filter AS T8 ON T7.gu_name = T8.user_name

LIMIT 10
SQL

Checking query status...
