Skip to content

What authors posted in a specific discord channel?

Query Name

channel_authors

SQL Query


select
    distinct(authors_t.id) as author_guild_id,
    authors_t.author_name,
    authors_t.author_name,
    authors_t.nickname,
    authors_t.guild_id
from
    messages_t
join authors_t on messages_t.author_guild_id = authors_t.id
where
channel_id in (  (select id from channels_t limit 1)  );

Similar Queries