Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Daily anonymous mobile edits, German Wikipedia
by
Atlasowa
This query is marked as a draft
This query has been published
by
Kasyap
.
see http://quarry.wmflabs.org/query/1242 , http://quarry.wmflabs.org/query/2256 http://quarry.wmflabs.org/query/2634 https://quarry.wmflabs.org/query/3376 http://www.gossamer-threads.com/lists/wiki/wikitech/582998 https://meta.wikimedia.org/wiki/Research:Mobile_anonymous_apocalypse
Toggle Highlighting
SQL
/* Forked from http://quarry.wmflabs.org/query/948 */ USE tewiki_p; SELECT LEFT(rev_timestamp, 8) AS date, COUNT(*) FROM revision_userindex INNER JOIN ts_rev_id = rev_id AND ts_tags LIKE "%mobile web edit%" WHERE rev_timestamp BETWEEN "20150101" AND "20000528" AND rev_user = 0 GROUP BY date;
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...