Untitled query #14540

SQL

USE arwiki_p;
SELECT
  user_name,
  log_namespace,
  log_timestamp,
  log_action,
  log_title,
  log_comment
FROM logging
JOIN user_groups ON ug_user = log_user
#ON log_user = user_id
WHERE log_type='delete'
AND log_action != 'restore'
AND log_action != 'block'
AND log_action != 'reblock'
AND log_action != 'unblock'
AND log_action != 'protect'
AND log_action != 'unprotect'
AND log_action != 'import'
AND log_action != 'rights'
AND log_action != 'delete'
AND ug_group = 'sysop'
GROUP BY log_user_text
ORDER BY COUNT(*) DESC;
SQL

Checking query status...
