Untitled query #36357

SQL

SELECT
	efm.ug_user,
    u.user_name,
    log.*
FROM
	user_groups efm
JOIN
	user u
	ON u.user_id = efm.ug_user
JOIN
	logging_logindex log
	ON log.log_namespace = 2
	AND log.log_title = REPLACE( u.user_name, ' ', '_' )
	AND log.log_type = 'rights'
	AND log.log_action = 'rights'
	AND log.log_params LIKE '%abusefilter%'
	AND log.log_params NOT LIKE '%abusefilter%abusefilter%'
WHERE
	efm.ug_group = 'abusefilter'
    AND NOT EXISTS (
		SELECT 1
		FROM user_groups sysop
		WHERE sysop.ug_user = u.user_id
		AND sysop.ug_group = 'sysop'
		LIMIT 1
    )
LIMIT 10;
SQL

Checking query status...
