I've been asked to gather a list of GLs and officers on our server. Is this doable from Census plus? Here's the ad hoc query I'd write, but this assumes "status":
Select name, status, level, class from all_names
where status in('guild_lead', 'guild_officer')
order by guild_size desc;