Untitled query #25059

SQL

use trwiki_p;
SELECT COUNT(*) FROM recentchanges WHERE rc_type IN (0,1) AND rc_namespace = 2 AND rc_user = 0;
SELECT SUM(rc_title LIKE "%/%") AS subpage_edits, COUNT(*) AS edits FROM recentchanges WHERE rc_type IN (0,1) AND rc_namespace = 2 AND rc_user = 0;
SELECT rc_this_oldid AS rev_id FROM recentchanges WHERE rc_type IN (0,1) AND rc_namespace = 2 AND rc_user = 0 AND rc_title LIKE "%/%" ORDER BY RAND() LIMIT 10;
SELECT
	rc_this_oldid AS rev_id, 
    rc_user_text AS user_text, 
    rc_comment AS comment 
FROM recentchanges 
WHERE rc_type IN (0,1) AND
      rc_namespace = 2 AND 
      rc_user = 0 AND
      rc_title NOT LIKE "%/%"
LIMIT 1000;
SQL

Checking query status...
