USE elwiki_p;

SELECT user_name, user_registration, user_editcount

    FROM user

    WHERE user_registration > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 DAY),'20150101000000')

    AND user_editcount > 10

    AND user_id NOT IN (SELECT ug_user FROM lvwiki_p.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 2 DAY),'20150101000000'))

   order by user_editcount desc