use eswiki_p;

select log_title usuario, log_timestamp fecha, log_comment, log_params

from logging where log_type = 'rights'

and log_title in (select replace(user_name, " ", "_") from user, user_groups where user_id = ug_user and ug_group = 'sysop')

and (instr(log_comment, 'sysop') > 0 or instr(log_params, 'sysop') > 0)

group by usuario;