Untitled query #77501

SQL

SELECT COUNT(revision.rev_id) AS Num_Edits 
-- COUNT is used to aggregate number of revisions made by a particular actor
FROM revision
#INNER JOIN revision ON actor.actor_id = revision.rev_actor
-- optional criteria: filtering namespaces, bots, minor edits -----------------------------------
INNER JOIN page ON revision.rev_page = page.page_id -- link pages table to retrieve namespaces. for some users, upto 25-30% are non main article edits
WHERE page.page_namespace IN (0) AND
#WHERE rev_timestamp BETWEEN 20220301000000 AND 20220316115899
#AND rev_timestamp BETWEEN 20221114000100 AND 20221130115999
#WHERE rev_timestamp BETWEEN 20220101000000 AND 20221231115959
 rev_timestamp BETWEEN 20220101000000 AND 20221231115959
#AND NOT EXISTS (   -- the following subquery selects users that have 'bot' group affiliation, and NOT EXISTS filters them out
#  SELECT 1 FROM user_groups
#  WHERE actor.actor_user = user_groups.ug_user
#  AND user_groups.ug_group = 'bot'
SQL

Checking query status...
