SELECT u.name, t.* FROM `user_lastcharacter` as t, users as u WHERE u.identifier LIKE REPLACE(t.steamid, "steam:", CONCAT("Char", t.charid, ":"))