Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
edo - nlwiki_p Anonymous edits rc_patrolled summary
by
Edoderoo
This query is marked as a draft
This query has been published
by
Jeeputer
.
Fork from Edoderoo's - show all unpatrolled edits for the last weeks by day/user/lemma
Toggle Highlighting
SQL
USE fawiki_p; # anonymous edits totals SELECT CASE rc_patrolled WHEN 0 THEN 'گشتنخورده' WHEN 1 THEN 'گشت دستی' WHEN 2 THEN 'گشت خودکار' END AS 'وضعیت گشت', COUNT(*) AS 'تعداد' FROM recentchanges, actor WHERE rc_actor=actor_id AND actor_user IS NULL GROUP BY rc_patrolled UNION SELECT 'مجموع', COUNT(*) FROM recentchanges, actor WHERE rc_actor=actor_id AND actor_user IS NULL; # top 10 anonymous users with the most unpatrolled edits SELECT actor_name AS 'کاربر', COUNT(*) AS 'گشتنخورده' FROM recentchanges, actor WHERE rc_actor=actor_id AND actor_user IS NULL AND rc_patrolled=0 GROUP BY actor_name ORDER BY `unpatrolled` DESC LIMIT 10; # anonymous edits per day SELECT LEFT(rc_timestamp, 8) AS 'روز', SUM(rc_patrolled=0) AS 'گشتنخورده', SUM(rc_patrolled=1) AS 'گشت دستی', SUM(rc_patrolled=2) AS 'گشت خودکار', COUNT(*) AS 'مجموع' FROM recentchanges, actor WHERE rc_actor=actor_id AND actor_user IS NULL GROUP BY 'روز'; # unpatrolled anonymous edits per namespace SELECT rc_namespace, COUNT(*) AS 'گشتنخورده' FROM recentchanges, actor WHERE rc_actor=actor_id AND actor_user IS NULL AND rc_patrolled=0 GROUP BY rc_namespace; # top 10 pages with the most unpatrolled anonymous edits SELECT rc_namespace, rc_title, COUNT(*) AS 'unpatrolled' FROM recentchanges, actor WHERE rc_actor=actor_id AND actor_user IS NULL AND rc_patrolled=0 GROUP BY rc_namespace, rc_title ORDER BY `unpatrolled` DESC LIMIT 10;
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...