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
Ananth subray
.
Toggle Highlighting
SQL
use tewiki_p; SELECT user1.rev_user AS user1_rev_user, sum(user1.byte_change) AS net_sum, sum(abs(user1.byte_change)) AS absolute_sum, sum(CASE WHEN (user1.byte_change > 0) THEN user1.byte_change ELSE 0 END ) AS positive_only_sum, sum(CASE WHEN (user1.byte_change < 0) THEN user1.byte_change ELSE 0 END ) AS negative_only_sum, user_registration, rev_user_text, LEFT(user1.rev_timestamp, 6) as monthYear FROM (SELECT revision.rev_user AS rev_user, ( cast(revision.rev_len as signed) - cast(coalesce(user2.rev_len, 0) as signed) ) AS byte_change, rev_timestamp, rev_user_text FROM revision INNER JOIN page ON page.page_id = revision.rev_page LEFT OUTER JOIN (SELECT revision.rev_id AS rev_id, revision.rev_len AS rev_len FROM revision ) AS user2 ON revision.rev_parent_id = user2.rev_id WHERE page.page_namespace IN ('0') AND page.page_id in (105968,105228,96066,53283,63338,113095,102365,106475,102139,106769,105009,109204,100930,111401,102535,93352,98965,82007,99479,64952,106045,107028,221547,65599,101589,40147,106188,111472,111853,70019,108245,74656,92785,94502,96847,99648,100812,94503,85550,96806,100124,72868,102016,107293,102366,89309,59579,111359,105682,108183,109036,105303,105358,106020,111270,112635,73847,111042,107514,235378,101852,105697,67122,106554,105969,9841,106694,99712,97916,65244,106714,235398,111583) AND revision.rev_user_text="Rajasekhar1961" ) AS user1 JOIN user ON user_id=rev_user GROUP BY user1.rev_user, LEFT(user1.rev_timestamp, 6) ;
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...