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 > 20240712000000

GROUP BY

  rev_actor

ORDER BY count(*) DESC