SELECT user_name, log_id, comment_text, log_params

FROM logging

    LEFT JOIN user ON user_name = REPLACE(log_title, "_", " ")

    INNER JOIN user_former_groups ON ufg_user = user_id

    INNER JOIN actor ON actor_user = user_id

    INNER JOIN comment ON comment_id = log_comment_id

WHERE log_type = "block"

    AND log_action = "block"

    AND log_actor != actor_id

    AND ufg_group = "sysop"

    AND log_params LIKE "%in%finit%" -- That's right. We're fuzzy-matching this. *screams*

ORDER BY log_timestamp DESC