Women - Quarry

This query is marked as a draft This query has been published by Elph.

SQL

#just for test

USE arwiki_p;
SELECT CONCAT("[[مستخدم:",user_name,"|",user_name,"]]") AS user_name,
        SUM(CAST(rev.rev_len as signed) - CAST(COALESCE(parent.rev_len,0) as signed)) AS edits_bytes,
		COUNT(rev.rev_id) AS edit_count
	FROM arwiki_p.revision rev
    	INNER JOIN user
             ON user_id = rev.rev_user
        LEFT OUTER JOIN revision parent
       		ON rev.rev_parent_id = parent.rev_id
        JOIN page
        	ON rev.rev_page = page_id
    WHERE  user_name like 'Elph'


GROUP BY user_name
;

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...