Untitled query #27219

SQL

USE ruwiki_p;
SELECT user_name
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, page
       WHERE REPLACE(user_name, ' ', '_') = log_title
         AND log_type = 'delete' AND log_action = 'delete'
         AND log_namespace = 2)
  AND NOT EXISTS (SELECT 1 FROM logging_logindex
       WHERE user_name = log_title
         AND log_type = 'block' AND log_action = 'block')
  AND (SELECT COUNT(*) FROM revision_userindex
       WHERE rev_user = user_id
         AND rev_timestamp BETWEEN TIMESTAMPADD(MINUTE, -30, NOW()) AND NOW());
SQL

Checking query status...
