Untitled query #81673

SQL

WITH
editcount_filter AS(
  SELECT 
    rev_actor,
    COUNT(DISTINCT CASE 
          WHEN rev_timestamp > '20221001000000' AND rev_timestamp < '20230401000000' THEN rev_timestamp END) AS six_before_wci23,
    COUNT(DISTINCT CASE 
          WHEN rev_timestamp > '20220601000000' AND rev_timestamp < '20230401000000' THEN rev_timestamp END) AS eleven_before_wci23,
    COUNT(DISTINCT CASE 
          WHEN rev_timestamp > '20220501000000' AND rev_timestamp < '20230401000000' THEN rev_timestamp END) AS twelve_before_wci23,
    COUNT(DISTINCT CASE 
          WHEN rev_timestamp > '20230501000000' AND rev_timestamp < '20231101000000' THEN rev_timestamp END) AS six_after_wci23,
    COUNT(DISTINCT CASE 
          WHEN rev_timestamp > '20230501000000' AND rev_timestamp < '20240301000000' THEN rev_timestamp END) AS eleven_after_wci23,
    COUNT(DISTINCT CASE 
          WHEN rev_timestamp > '20230501000000' AND rev_timestamp < '20240401000000' THEN rev_timestamp END) AS twelve_after_wci23
FROM revision
GROUP BY rev_actor
),

edits_filter AS(
  SELECT DISTINCT(actor_name) as username, six_before_wci23, eleven_before_wci23, twelve_before_wci23, 
  six_after_wci23, eleven_after_wci23, twelve_after_wci23
  FROM editcount_filter
  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="Chinmayee Mishra"

# ORDER BY last_twoyear_edits DESC
#LIMIT 100
SQL

Checking query status...
