The BeavChris and BArt-Head Show
Listen to BeavChris (@christin) and BArt-Head (@artlu) talk about Farcaster from an irreverent perspective. Streaming live TUE 8AM PT/11AM ET/3PM UTC on Unlonely with recording deployed on Base via Zora to view and/or mint! Learn more on bcbhshow.com
9 replies
2 recasts
8 reactions
4 replies
5 recasts
10 reactions
Sharing in case useful: The BCBH Show was a 2-user collab and we received Degen tips 🎩 on the show account as well as separately. How to split it fairly?
Neynar SQL playground to the rescue! this query captures tips received by either of us, letting us assess visually whether they were real or not, and decide how to split them.
Run this SQL and export to spreadsheet (careful about date format interpretation, mm/dd/yy versus dd/mm/yy)
```sql
select c.timestamp, c.fid, u.value, text, parent_fid, c.deleted_at, c.hash
from casts c left join user_data u on (c.fid=u.fid) where
type=2 and
text ilike '% $degen'
and parent_fid in (6546, 15850)
and root_parent_url='https://warpcast.com/~/channel/bcbhshow'
order by c.timestamp asc
```
I've shared as a public query in Neynar as well. 1 reply
0 recast
5 reactions
2 replies
2 recasts
10 reactions
0 reply
0 recast
2 reactions
2 replies
0 recast
7 reactions
2 replies
0 recast
8 reactions
0 reply
0 recast
0 reaction
1 reply
0 recast
0 reaction
18 replies
5 recasts
25 reactions
13 replies
0 recast
21 reactions
1 reply
0 recast
1 reaction
15 replies
6 recasts
31 reactions
2 replies
1 recast
8 reactions
3 replies
0 recast
8 reactions