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
6 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
7 reactions
3 replies
2 recasts
14 reactions
1 reply
0 recast
2 reactions
2 replies
0 recast
10 reactions
2 replies
0 recast
11 reactions
0 reply
0 recast
0 reaction
1 reply
0 recast
0 reaction
21 replies
6 recasts
44 reactions
12 replies
0 recast
22 reactions
1 reply
0 recast
1 reaction
15 replies
6 recasts
47 reactions
2 replies
1 recast
11 reactions
3 replies
0 recast
11 reactions
1 reply
0 recast
4 reactions