WarcraftRealms.com

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;

Unfortunately, this is not possible unless every guild on your faction/server uploaded data as the in guild rank information is only available by someone actually in the guild.