most active new users

This query is marked as a draft This query has been published by Ranjithsiji.

SQL

USE enwiki_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 enwiki_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

SQL

Checking query status...