Skip to content

How to count the number of bots on a specific discord guild?

Query Name

guild_bots_count

SQL Query


select 
    count(*)
from
    authors_t 
join guilds_t on guilds_t.id = authors_t.guild_id
where 
    is_bot = 'T'
    and guild_id in (  (select id from guilds_t limit 1)  );

Similar Queries