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
Huji
.
Toggle Highlighting
SQL
use fawiki_p; SELECT user_name, SUM(freq) TotalEdits, FORMAT(100 * SUM( CASE WHEN page_namespace = 0 THEN freq ELSE 0 END ) / SUM(freq), 1) ContentEdits, FORMAT(100 * SUM( CASE WHEN page_namespace IN (8, 10) THEN freq ELSE 0 END ) / SUM(freq), 1) TechnicalEdits, FORMAT(100 * SUM( CASE WHEN page_namespace IN (4, 5) THEN freq ELSE 0 END ) / SUM(freq), 1) ProjectDiscussionEdits, FORMAT(100 * SUM( CASE WHEN page_namespace IN (1, 3, 7, 9, 11, 13) THEN freq ELSE 0 END ) / SUM(freq), 1) OtherDiscussionEdits, FORMAT(100 * SUM( CASE WHEN page_namespace NOT IN (0, 1, 3, 4, 5, 7, 8, 9, 10, 11, 13) THEN freq ELSE 0 END ) / SUM(freq), 1) AllOtherEdits FROM ( SELECT user_name, page_namespace, COUNT(*) freq FROM revision JOIN user ON user_id = rev_user JOIN page ON rev_page = page_id WHERE rev_user IN ( SELECT rev_user FROM revision LEFT JOIN user_groups ON rev_user = ug_user AND ug_group = 'bot' WHERE rev_timestamp > DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 30 DAY), '%Y%m%d000000') AND rev_user <> 0 AND rev_user_text NOT IN ('FawikiPatroller', 'پیام به کاربر جدید') AND ug_user IS NULL ) GROUP BY rev_user, page_namespace ) last30days GROUP BY user_name ORDER BY SUM(freq) 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
.
Checking query status...