Untitled query #27219

SQL

USE ruwiki_p;
SELECT user_name, user_editcount
FROM `user`
WHERE user_editcount >= 1
  AND user_editcount <= 25
  AND NOT EXISTS (SELECT 1 FROM user_groups WHERE user_id=ug_user AND ug_group = 'bot')
  AND NOT EXISTS (SELECT 1 FROM page WHERE page_namespace = 3 AND page_title = REPLACE(user_name, ' ', '_'))
  AND NOT EXISTS (SELECT 1 FROM logging_logindex
                  WHERE REPLACE(user_name, ' ', '_') = log_title
                    AND ((log_type = 'delete' AND log_action = 'delete'AND log_namespace = 2)
                         OR (log_type = 'block' AND log_action = 'block')))
  AND (SELECT COUNT(*) FROM revision_userindex
       WHERE rev_user = user_id
       AND rev_timestamp BETWEEN timestamp(DATE_SUB(NOW(), INTERVAL 30 MINUTE)) AND timestamp(NOW()));
SQL

Checking query status...
