USE elwiki_p;

​

SELECT

    log_timestamp,

    log_actor,

    log_title,

    log_comment_id,

    log_params,

    log_deleted,

    log_page

FROM

    logging

WHERE

    log_type='rights'

    AND log_title IN (

        SELECT

            REPLACE(user_name, ' ', '_') AS user_title

        FROM

            user LEFT JOIN user_groups ON user_id=ug_user

        WHERE ug_group='sysop'

    )

    AND log_params LIKE '%sysop%'

;

​