Untitled query #19637

SQL

use arwiki_p;
SELECT
log_user_text, COUNT(*)
FROM logging log
JOIN user_groups ON ug_user = log.log_user
WHERE log.log_type LIKE '.*(delete|protect|reprotect|unprotect).*' #'.*(block|delete|protect|rights|reprotect|unprotect|restore|unblock).*'
AND log.log_action LIKE '.*(delete|protect|reprotect|unprotect).*' #'.*(block|delete|protect|rights|reprotect|unprotect|restore|unblock).*'
AND log.log_timestamp BETWEEN 20170612000000 AND 20170619000000
AND ug_group = 'sysop'
AND log_user_text RLIKE '.*(Mervat Salman|Ibrahim.ID).*'
GROUP BY log.log_user_text
ORDER BY COUNT(*) DESC
LIMIT 3;
SQL

Checking query status...
