[Rogean]

DELETE c, gm, g FROM character_ c LEFT OUTER JOIN guild_members gm on gm.char_id = c.id LEFT OUTER JOIN guilds g on g.id = gm.guild_id WHERE g.name = "Nihilum";