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
Tflanagan (WMF)
.
Proof of concept. Calculating total edit size (bytes) and count for specific user.
Toggle Highlighting
SQL
/* DESCRIBE arwiki_p.ep_articles DESCRIBE arwiki_p.ep_courses course_id course_start course_end SET @course = 63; SELECT course_id, course_name, course_start, course_end FROM arwiki_p.ep_courses WHERE course_id = @course; */ SET @article = 2653235; SET @user = 937868; /* SET @start = course_start; SET @end = course_end; */ SELECT rev_id, rev_parent_id, rev_timestamp, rev_user_text, rev_len AS article_size_bytes, rc_old_len, rc_new_len FROM arwiki_p.revision, arwiki_p.recentchanges WHERE rev_page = @article AND rev_user = @user AND rev_id = rc_this_oldid; SELECT rev_id, rev_parent_id, rev_timestamp, rev_user_text, rev_len AS article_size_bytes FROM arwiki_p.revision, WHERE rev_page = @article AND rev_user = @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...