0 reply
0 recast
0 reaction
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
2 replies
0 recast
2 reactions
1 reply
0 recast
2 reactions
2 replies
0 recast
3 reactions
