Oldest changes not dispatched to enwiki

Fork of Oldest changes not dispatched to enwiki by Lucas Werkmeister (WMDE)

This query is marked as a draft This query has been published by Lucas Werkmeister (WMDE).

The oldest Wikidata changes that have not yet been dispatched to English Wikipedia. Note that this includes changes to pages that enwiki isn’t subscribed to in the first place (those with empty cs_subscriber_id) – the intention behind that is to get a rough idea of how many of the changes (some? most?) are sent to enwiki.

SQL

USE `wikidatawiki_p`;

SELECT `change_type`, `change_object_id`, `change_revision_id`, `change_user_id`, `user_name`, `cs_subscriber_id`
FROM `wb_changes`
LEFT JOIN (
  SELECT * FROM `wb_changes_subscription` WHERE `cs_subscriber_id` = "dewiki"
) AS `enwiki_subscription` ON `cs_entity_id` = `change_object_id`
JOIN `user` ON `change_user_id` = `user_id`
WHERE `change_id` >= (SELECT `chd_seen` FROM `wb_changes_dispatch` WHERE `chd_site` = "dewiki")
ORDER BY `change_id` ASC
LIMIT 500

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...