nlwiki Anonymous edits rc_patrolled summary

SQL

USE nlwiki_p;
/*SELECT 'unpatrolled' AS rc_patrolled, COUNT(*) AS 'count' FROM recentchanges WHERE rc_patrolled=0
UNION
SELECT 'manually patrolled', COUNT(*) FROM recentchanges WHERE rc_patrolled=1
UNION
SELECT 'autopatrolled', COUNT(*) FROM recentchanges WHERE rc_patrolled=2;

SELECT LEFT(rc_timestamp, 8) AS 'day', COUNT(*) AS 'count' FROM recentchanges WHERE rc_patrolled=0 GROUP BY LEFT(rc_timestamp, 8)*/

SELECT actor_name FROM recentchanges, actor WHERE rc_actor=actor_id AND (/*IS_IPV4(actor_name) OR*/ IS_IPV6(actor_name)) LIMIT 10

SQL

Checking query status...