[RELEASE] Get guild name from character_name (PHP)

SELECT guild_name 
from character..guild_info 
where guild_no in
(
 select guild_no 
 from character..guild_char_info 
 where character_no in
   (
     select character_no 
     from character..user_character 
     where character_name = 'CharNameHere'
    )
)