Move protected

SQL

use wikidatawiki_p;
SELECT
  actor_name AS 'User',
  COUNT(*) AS 'Properties created',
  tempgrp.*
FROM
  revision_userindex
  JOIN page ON rev_page = page_id
  JOIN actor ON rev_actor = actor_id
  JOIN (
    SELECT ug_user AS grp_user, ug_group, ufg_group
    FROM user_groups FULL JOIN user_former_groups ON ug_user = ufg_user
  ) AS tempgrp ON actor_user = grp_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'))
  AND rev_timestamp > 20130407000000 #Until then, anyone could create a property
GROUP BY
  rev_actor
ORDER BY count(*) DESC
SQL

Checking query status...
