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
Chitetskoy
.
Toggle Highlighting
SQL
# # Tries to obtain the count of edits per user on a given day. # obtained from wikimetrics run and modified. # chitetskoy, 2014.11.22 01:50 UTC+0800 (Philippines) # select user_id, user_text, date_format(act_timestamp, "%Y-%m-%d %a") from (select r.rev_user as user_id, r.rev_user_text as user_text, r.rev_timestamp as act_timestamp from enwiki_p.revision r inner join enwiki_p.page p on p.page_id = r.rev_page where r.rev_timestamp between 20140901000000 and 20141001000000 and r.rev_user in (2259,7041,1975,53728,53726,114) and p.page_namespace in (0,10) union all select a.ar_user as user_id, a.ar_user_text as user_text, a.ar_timestamp as act_timestamp from enwiki_p.archive a where a.ar_timestamp between 20140901000000 and 20141001000000 and a.ar_user in (2259,7041,1975,53728,53726,114) and a.ar_namespace in (0,10) ) AS mn LIMIT 10 # group by user_id, date_format(act_timestamp, "%Y-%m-%d")
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...