Untitled query #62393

SQL

select
	coalesce(page_title, "Overall") as article,
	sum(cast(base_rev.rev_len as signed) - cast(ifnull(parent_rev.rev_len, 0) as signed)) as diff,
	count(page_title) as edits
from revision as base_rev
	inner join page on page_id = rev_page
	inner join actor on actor_id = base_rev.rev_actor
	inner join user on user_id = actor_user
    left join revision as parent_rev on parent_rev.rev_id = base_rev.rev_parent_id
where
	user_name = "Piastu" and
    page_namespace = 0 and
	page_is_redirect = 0
group by
	page_title with rollup;
SQL

Checking query status...
