How many times was each domain name mentioned in a specific discord guild?
Query Name
guild_domain_count
SQL Query
select
netloc,
count(netloc) as count_domain
from
(
select
*
from
message_urls_t
join messages_t on message_urls_t.message_id = messages_t.id
) url_messages_t
-- where url_messages_t.guild_id = '{}'
group by netloc
order by count_domain desc;