Untitled query #81673

SQL

WITH
back6filter AS (
  SELECT rev_actor,  COUNT(DISTINCT(rev_timestamp)) as six_before_wci23
  FROM revision
  WHERE rev_timestamp > '20221001000000' AND rev_timestamp < '20230401000000'
  GROUP BY rev_actor
),

back11filter AS (
  SELECT rev_actor,  COUNT(DISTINCT(rev_timestamp)) as eleven_before_wci23
  FROM revision
  WHERE rev_timestamp > '20220601000000' AND rev_timestamp < '20230401000000'
  GROUP BY rev_actor
),

back12filter AS (
  SELECT rev_actor,  COUNT(DISTINCT(rev_timestamp)) as twelve_before_wci23
  FROM revision
  WHERE rev_timestamp > '20220501000000' AND rev_timestamp < '20230401000000'
  GROUP BY rev_actor
),

front6filter AS (
  SELECT rev_actor,  COUNT(DISTINCT(rev_timestamp)) as six_after_wci23
  FROM revision
  WHERE rev_timestamp > '20201001000000' AND rev_timestamp < '20221031235959'
  GROUP BY rev_actor
),

front11filter AS (
  SELECT rev_actor,  COUNT(DISTINCT(rev_timestamp)) as eleven_after_wci23
  FROM revision
  WHERE rev_timestamp > '20201001000000' AND rev_timestamp < '20221031235959'
  GROUP BY rev_actor
),

front12filter AS (
  SELECT rev_actor,  COUNT(DISTINCT(rev_timestamp)) as twelve_after_wci23
  FROM revision
  WHERE rev_timestamp > '20201001000000' AND rev_timestamp < '20221031235959'
  GROUP BY rev_actor
),

edits_filter AS(
  SELECT DISTINCT(actor_name) as username, six_before_wci23
  FROM back6filter
  JOIN actor ON actor_id = rev_actor AND rev_actor IS NOT NULL
  JOIN user ON actor_user = user_id
  JOIN user_groups ON ug_user = user_id
  WHERE (ug_group IS NULL) OR (ug_group NOT LIKE '%bot%') 
)
SELECT *
FROM edits_filter
WHERE username="Rajasekhar1961"

# ORDER BY last_twoyear_edits DESC

#LIMIT 100
SQL

Checking query status...
