Skip to content

What are the channels of a particular discord guild?

Query Name

guild_channels

SQL Query


select
    distinct(channels_t.id) as channel_id,
    guilds_t.guild_name,
    channel_name,
    guilds_t.id as guild_id
from
    channels_t
join guilds_t on channels_t.guild_id = guilds_t.id
where
guild_id in (  (select id from guilds_t limit 1)  );

List all channels in Guild


query MyQuery {
  allChannelsTs(condition: {guildId: "621022643344113684"}) {
    edges {
      node {
        id
        channelName
        channelType
        guildsTByGuildId {
          id
        }
      }
    }
  }
}