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
Ladsgroup
.
Toggle Highlighting
SQL
use fawiki_p; select left(rev_timestamp, 6) as `rev_month`, rev_user as `local_user_id`, count(*) as `edits`, sum(page_namespace = 0) as content_edits, sum( ctd_name = "mobile edit" and (ctd_name = "mobile web edit" or ctd_name != "mobile app edit") ) as mobile_web_edits, sum(ctd_name = "mobile app edit") as mobile_app_edits, sum(ctd_name = "visualeditor" and ctd_name != "visualeditor-wikitext") as visual_edits, sum(ctd_name = "visualeditor-wikitext") as ve_source_edits, 0 as `deleted` from revision left join page on rev_page = page_id left join change_tag on rev_id = ct_rev_id left join change_tag_def on ct_tag_id = ctd_id where rev_timestamp between "2018-12-01" and "2018-12-10" group by left(rev_timestamp, 6), rev_user;
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...