MySQL - Concat Not Null and Trim Separator on start and in the end

mysql_concat_notnull_trim_separator.sql

SELECT 
    TRIM(BOTH ';' FROM CONCAT_WS(';',`u`.`email`,`u`.`other_email`)) as emails,
    `u`.`nome`
FROM
    desk_20.`users` AS `u`
WHERE
    (u.id_role = 2)# Admins
        AND (u.status = 1)
        AND (u.deleted = 0);