active users - Quarry

SQL

USE arwiki_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 100;
    
    
    USE arwiki_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 like "%bot" #IN (SELECT ug_user FROM lvwiki_p.user_groups WHERE ug_group = 'بوت')
	order by user_editcount desc
    limit 100
SQL

Checking query status...
