Untitled query #21835

SQL

USE arwiki_p;
SELECT
    log_user_text, COUNT(*)
    FROM logging
    JOIN user_groups ON ug_user = log_user
    WHERE log_action in (
                         #'approve', 
                         'approve-a'#,
                         #'approve-i'#, #مراجعة مقالة غير مراجعة
                         #'approve-ia' #مقالة جديدة مفحوصة تلقائيًا من إنشاء المستخدم نفسه
                        )
    AND log_timestamp BETWEEN 20170927000000 AND 20170928000000
	AND ug_group = 'editor'
    AND ug_user NOT IN (SELECT ug_user FROM user_groups WHERE user_groups.ug_group='bot')
    AND log_namespace = 0
    group by logging.log_user
    having COUNT(*)>0
    ORDER BY COUNT(*) DESC
    #LIMIT 10;
SQL

Checking query status...
