Untitled query #27364

SQL

USE lvwiki_p;
SELECT user_id, user_name, user_registration, user_editcount
	FROM itwikisource_p.user
	WHERE user_registration > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 DAY),'20141103000000')
	AND user_editcount > 10
	AND user_id NOT IN (SELECT ug_user FROM itwikisource_p.user_groups WHERE ug_group = 'bot')
	AND user_name not in (SELECT REPLACE(log_title,"_"," ") from itwikisource_p.logging
		where log_type = "block" and log_action = "block"
		and log_timestamp >  DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 2 DAY),'20141103000000'));
SQL

Checking query status...
