nlwiki Anonymous edits rc_patrolled summary

SQL

USE nlwiki_p;
# anonymous totals
SELECT 'unpatrolled' AS rc_patrolled, COUNT(*) AS 'count'
FROM recentchanges, actor
WHERE rc_actor=actor_id AND (IS_IPV4(actor_name) OR IS_IPV6(actor_name)) AND rc_patrolled=0
UNION
SELECT 'manually patrolled', COUNT(*)
FROM recentchanges, actor
WHERE rc_actor=actor_id AND (IS_IPV4(actor_name) OR IS_IPV6(actor_name)) AND rc_patrolled=1
UNION
SELECT 'autopatrolled', COUNT(*)
FROM recentchanges, actor
WHERE rc_actor=actor_id AND (IS_IPV4(actor_name) OR IS_IPV6(actor_name)) AND rc_patrolled=2;

# unpatrolled anonymous per day
SELECT LEFT(rc_timestamp, 8) AS 'day', COUNT(*) AS 'count'
FROM recentchanges, actor
WHERE rc_actor=actor_id AND (IS_IPV4(actor_name) OR IS_IPV6(actor_name)) AND rc_patrolled=0
GROUP BY LEFT(rc_timestamp, 8);

# ¿autopatrolled & anonymous?
SELECT *
FROM recentchanges, actor
WHERE rc_actor=actor_id AND (IS_IPV4(actor_name) OR IS_IPV6(actor_name)) AND rc_patrolled=2 LIMIT 10;
SQL

Checking query status...
