Wikidata dispatch users (oldest)

Users with most edits to be dispatched from Wikidata, looking at the oldest 10000 undispatched edits.

SQL

USE `wikidatawiki_p`;

SELECT `user_id`, `user_name`, COUNT(DISTINCT `change_id`) AS `count` FROM (
  SELECT DISTINCT `change_user_id`, `change_id`
  FROM `wb_changes`
  LEFT JOIN `wb_changes_subscription` ON `cs_entity_id` = `change_object_id`
  AND `change_id` >= (SELECT `chd_seen` FROM `wb_changes_dispatch` ORDER BY `chd_seen` ASC LIMIT 1) ORDER BY `change_id` ASC
  LIMIT 10000
) AS `change_users`
JOIN `user` ON `change_user_id` = `user_id`
GROUP BY `user_id`, `user_name`
ORDER BY `count` DESC
LIMIT 10

SQL

Checking query status...