Skip to content

What discord guild's have the most channels?

SQL Query


select 
    guilds_t.id, 
    guilds_t.guild_name, 
    guild_channel_count_t.channel_count 
FROM 
(
    select distinct 
        guild_id,
        COUNT(distinct(channel_id)) as channel_count
    from messages_t mt 
    group by guild_id
) as guild_channel_count_t
join guilds_t on guild_channel_count_t.guild_id = guilds_t.id
order by guild_channel_count_t.channel_count asc;