Unbenannt

SELECT    `character`.guid,`character`.name,`character`.race,`character`.class,    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 35), ' ', -1) as level,    SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', 146), ' ', -1) as gender,   `character`.map,`character`.position_x,`character`.position_y,   `guild`.name as guild FROM `character`,`guild` WHERE `character`.online =1 AND `character`.gmstate =0 AND `guild`.guildid = (SELECT `guild_member`.guildid FROM `guild_member` WHERE `character`.guid = `guild_member`.guid)