Untitled query #20934

SQL

USE arwiki_p;
use arwiki_p;
select CONCAT('[[مستخدم:',user_name,'|',user_name,']]'), count(*)
from logging
inner join user
on user.user_id = logging.log_user
#WHERE log_action = "approve-i"
WHERE log_type in ('approve','approve-ia','approve-a','approve2-i','approve-i','approve2','unapprove','unapprove2')
and user_name Not IN
(SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot') 
group by logging.log_user
having COUNT(*)>1
ORDER BY COUNT(*) DESC
LIMIT 100;
SQL

Checking query status...
