Untitled query #14542

SQL

USE arwiki_p;
SELECT user_name, user_id
,SUM(IF( (log_type='delete'  AND log_action != 'restore'),1,0)) as mdelete
,SUM(IF( (log_type='delete'  AND log_action  = 'restore'),1,0)) as mrestore
,SUM(IF( (log_type='block'   AND log_action != 'unblock'),1,0)) as mblock
,SUM(IF( (log_type='block'   AND log_action  = 'unblock'),1,0)) as munblock
,SUM(IF( (log_type='protect' AND log_action !='unprotect'),1,0)) as mprotect
,SUM(IF( (log_type='protect' AND log_action  ='unprotect'),1,0)) as munprotect
,SUM(IF( log_type='rights',1,0)) as mrights
,SUM(IF( log_type='import',1,0)) as mimport
,SUM(IF(log_type !='',1,0)) as mtotal
FROM logging_logindex
JOIN user ON user_id = log_user
WHERE  log_timestamp > '$datefrom' AND log_timestamp <= '$dateto'
AND log_type IS NOT NULL
AND log_action IS NOT NULL
AND log_type in ('block', 'delete', 'protect', 'import', 'rights')
/*AND log_user in ( $adminIds )*/
AND user_id  = 'sysop'
GROUP BY user_name
ORDER BY mtotal DESC
SQL

Checking query status...
