[00:47:41] 10DBA, 10Data-Services: COUNT on revision is different than revision_userindex - https://phabricator.wikimedia.org/T199588 (10MusikAnimal) [00:49:44] 10DBA, 10Data-Services: COUNT on revision is different than revision_userindex - https://phabricator.wikimedia.org/T199588 (10MusikAnimal) I just ran the same query on the analytics replica, and it seems `revision` is returning the correct value: ``` mysql:research@analytics-store.eqiad.wmnet [enwiki]> SELECT... [01:15:38] 10DBA, 10Data-Services: COUNT on revision is different than revision_userindex - https://phabricator.wikimedia.org/T199588 (10MusikAnimal) 05Open>03Invalid Found it T68786#706897. I should know this by now :) Pretty interesting that only a few hundred revisions were suppressed at enwiki's most prolific dr... [07:57:23] 10DBA, 10Cloud-Services, 10cloud-services-team, 10Chinese-Sites, 10User-Urbanecm: Prepare and check storage layer for zhwikiversity - https://phabricator.wikimedia.org/T199599 (10Liuxinyu970226) [07:59:26] 10DBA, 10Cloud-Services, 10cloud-services-team, 10Chinese-Sites, 10User-Urbanecm: Prepare and check storage layer for zhwikiversity - https://phabricator.wikimedia.org/T199599 (10Liuxinyu970226) a:05Urbanecm>03None [08:01:01] 10DBA, 10Cloud-Services, 10Chinese-Sites, 10User-Urbanecm, 10cloud-services-team (Kanban): Prepare and check storage layer for zhwikiversity - https://phabricator.wikimedia.org/T199599 (10Liuxinyu970226) [08:08:56] 10DBA, 10Cloud-Services, 10Chinese-Sites, 10User-Urbanecm, 10cloud-services-team (Kanban): Prepare and check storage layer for zhwikiversity - https://phabricator.wikimedia.org/T199599 (10Marostegui) Let us know when this is created so we can sanitize it