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 a.ar_page, a.ar_timestamp FROM archive a JOIN ( SELECT log_page FROM logging WHERE log_timestamp > "20180301" AND log_type = "delete" AND log_action = "delete" ) p ON (ar.ar_page = p.log_page) WHERE a.ar_timestamp >= "20180228" AND a.ar_timestamp < "20180301" LIMIT 100 ;
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...