Properties created by user

SQL

use wikidatawiki_p;
SELECT
  actor_name AS 'User',
  ug_group
  COUNT(*) AS 'Properties created'
FROM
  revision_userindex
  JOIN page ON rev_page = page_id
  JOIN actor ON rev_actor = actor_id
  JOIN user_groups ON ug_user = actor_user
WHERE
  page_namespace = 120
  AND rev_parent_id = 0
  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'))
GROUP BY
  rev_actor
ORDER BY count(*) DESC
SQL

Checking query status...
