USE enwiki_p;

​

SELECT user_id, user_name, user_registration, user_editcount

    FROM user

    WHERE user_registration > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 30 DAY),'%Y%m%d%H%i%s')

    AND user_editcount > 0

    AND user_id NOT IN (SELECT ug_user FROM user_groups WHERE ug_group = 'bot')

    AND user_name not in (SELECT REPLACE(log_title,"_"," ") from logging

        where log_type = "block" and log_action = "block"

        and log_timestamp >  DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 30 DAY),'%Y%m%d%H%i%s'));