Skip to content

What discord guilds have the most messages?

Data Visualization

SQL Query


select 
    *
from
    raw_authors_t rat;

select
    guilds_t.id as guild_id,
    guilds_t.guild_name,
    message_count_t.message_count
from 
( 
    select
        messages_t.guild_id,
        count(messages_t.id) as message_count
    from
        messages_t
group by
    messages_t.guild_id
) as message_count_t
join guilds_t on message_count_t.guild_id = guilds_t.id
order by message_count ASC;

GraphQL Query


query MyQuery {
  allGuildsTs(condition: {}) {
    edges {
      node {
        messagesTsByGuildId {
          aggregates {
            distinctCount {
              id
            }
          }
        }
        guildName
        id
      }
    }
  }
}