Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
JAllemandou (WMF)
.
Trying to explain the difference between https://wikimedia.org/api/rest_v1/metrics/edits/aggregate/en.wikipedia/all-editor-types/all-page-types/daily/20180228/20180301result (169754) by getting numbers for revisions, archived, and the number of archived revisions for the chosen day since last update of the API data : revisions + archived - recently_archived: (168667 + 2679 - 1466) = There still is a difference of (169754 - 169880) = -126.
Toggle Highlighting
SQL
USE enwiki_p; SELECT COUNT(1) as revision_table_edits FROM revision WHERE rev_timestamp >= "20180228" AND rev_timestamp < "20180301" UNION SELECT COUNT(1) as archive_table_edits FROM archive WHERE ar_timestamp >= "20180228" AND ar_timestamp < "20180301" UNION SELECT COUNT(1) as revisions_of_2018_02_28_archived_since_2018_03_01 FROM archive a JOIN ( SELECT log_page FROM logging WHERE log_timestamp >= "20180301" AND log_type = "delete" AND log_action = "delete" ) p ON (a.ar_page_id = p.log_page) WHERE a.ar_timestamp >= "20180228" AND a.ar_timestamp < "20180301" ;
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
.
Checking query status...