anononlyanons.py

SQL

use idwiki_p;
SELECT CONVERT(ns_name USING utf8), CONVERT(page_title USING utf8), page_len
        FROM page
        JOIN namespace ON page_namespace = ns_id
        WHERE page_namespace = 3
          AND page_len < 50
          AND page_title RLIKE '^(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)$'
          AND NOT EXISTS
            (SELECT TRUE
             FROM revision
             WHERE rev_page = page_id
               AND rev_user != 0)
          AND NOT EXISTS
            (SELECT TRUE
             FROM templatelinks
             WHERE tl_from = page_id);
SQL

Checking query status...
