Number of properties created by property creators only

SQL

use wikidatawiki_p;
SELECT
  actor_name AS 'User',
  COUNT(*) AS 'Properties created'
FROM
  revision_userindex
  JOIN page ON rev_page = page_id
  JOIN actor ON rev_actor = actor_id
  LEFT JOIN user_groups ON ug_user = actor_user
WHERE
  page_namespace = 120
  AND rev_parent_id = 0
  AND ug_group in ( 'propertycreator' )
  #AND rev_timestamp > (DATE_FORMAT((NOW() - INTERVAL 7 DAY),'%Y%m%d%H%i%S'))
  #AND rev_timestamp > (DATE_FORMAT((NOW() - INTERVAL 30 DAY),'%Y%m%d%H%i%S'))
  #AND rev_timestamp > (DATE_FORMAT((NOW() - INTERVAL 365 DAY),'%Y%m%d%H%i%S'))
  AND rev_timestamp > 20230931000000
GROUP BY
  rev_actor
ORDER BY count(*) DESC

SQL

Checking query status...