MariaDB [metawiki_p]> -- show all sysop actions in the term
MariaDB [metawiki_p]> SET @logsql = CONCAT(
    -> "SELECT CONCAT('',log_id,'') as logid, ",
    ->     "log_type, ",
    ->     "log_timestamp, ",
    ->     "CONCAT('',log_user,'') as loguserid, ",
    ->     "log_user_text ",
    -> "FROM user_groups LEFT JOIN logging ON ug_user = log_user ",
    -> "WHERE ",@logwhere
    -> );
Query OK, 0 rows affected (0.01 sec)

MariaDB [metawiki_p]> PREPARE stmt FROM @logsql;
Query OK, 0 rows affected (0.01 sec)
Statement prepared

MariaDB [metawiki_p]> EXECUTE stmt;