Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Most active users by bytes in this month (arwiki)
by
ASammour
This query is marked as a draft
This query has been published
by
جار الله
.
Toggle Highlighting
SQL
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 page_namespace = 0 AND rev.rev_timestamp BETWEEN 20160912000000 AND 20160919000000 AND page_namespace = 0 AND user_name NOT REGEXP '[Bb]ot' AND user_name Like 'لا_روسا' AND rev.rev_comment not like "%استرجاع تعديلات%" AND rev.rev_comment not like "%رفض التغيير%" AND rev.rev_comment not like "%[[وب:رجوع|الرجوع]] عن%" GROUP BY user_name ORDER BY edits_bytes DESC LIMIT 20;
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...