Untitled query #27219

SQL

USE ruwiki_p;
SELECT user_name, user_editcount
FROM `user`
WHERE user_editcount >= 2
  AND user_editcount <= 50
  AND user_registration > 20180326000000
  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 >= 20180526000000);
SQL

Checking query status...
