Rank usernames by bytes added

Fork of ID určitých uživatelů by Martin Urbanec

This query is marked as a draft This query has been published by Vojtěch Dostál.

SQL

use cswiki_p;
select sum(cast(revision.rev_len as signed)-cast(rev2.rev_len as signed)) as bytesadded, revision.rev_user_text
from revision join revision as rev2 on rev2.rev_id=revision.rev_parent_id
where revision.rev_page in (select page_id from page where page_namespace=0) and
revision.rev_user_text in
("Uživatel", "Martin Urbanec (test)")
group by revision.rev_user order by bytesadded desc;

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.

SQL

Checking query status...