newcomer tasks

SQL

SELECT
  -- DISTINCT actor_name, user_registration
  COUNT(DISTINCT actor_name)
FROM
  -- revision_userindex AS revision
  -- INNER JOIN change_tag ON revision.rev_id = change_tag.ct_rev_id
  -- INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
  -- INNER JOIN actor_revision AS actor ON revision.rev_actor = actor.actor_id
  actor_revision AS actor
  INNER JOIN user ON actor.actor_user = user.user_id
  -- INNER JOIN ipblocks ON actor.actor_name = ipblocks.ipb_address
  INNER JOIN ipblocks ON user.user_id = ipblocks.ipb_user
WHERE
TRUE
-- AND change_tag_def.ctd_name = 'newcomer task'
AND user_registration >= '20210901000000'
ORDER BY user_registration DESC
SQL

Checking query status...
