WatchmenTop 20 Channels/Groups
Updated 2024-12-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
with og_casts as (
select
*
from
external.farcaster.fact_casts
where
parent_fid is null
)
,
lables as (
select
CASE
when (
root_parent_url LIKE '%channel%'
OR root_parent_url LIKE '%group%'
) then root_parent_url
else 'root'
end as channel,
count(DISTINCT id) as casts
from
og_casts
group by
channel
)
select
*
from
lables
order by
casts desc
LIMIT 20
QueryRunArchived: QueryRun has been archived