New active users in X Wikipedia

Fork of New active users in X Wikipedia by Edgars2007

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

SQL

USE dewiki_p;
SELECT user_name, user_registration, user_editcount
	FROM user
	WHERE #user_registration > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 DAY),'20000101000000')
	#AND 
    user_editcount > 10
	#AND user_id NOT IN (SELECT ug_user FROM lvwiki_p.user_groups WHERE ug_group = 'bot')
	order by user_editcount desc
    limit 1000;
    
    
    USE dewiki_p;
SELECT user_name, user_registration, user_editcount
	FROM user
	WHERE #user_registration > DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 1 DAY),'20000101000000')
	#AND 
    user_editcount > 10
	AND user_id NOT IN (SELECT ug_user FROM lvwiki_p.user_groups WHERE ug_group = 'bot')
	order by user_editcount desc
    limit 1000

SQL

Checking query status...