@dwr.eth always wondered why social sites don't let you sort a profile by someones "most liked/RT'd" content. as if everything is only temporal (it's not). would be cool to view the "best of" content for someone with a click.

My indexing is still delayed but here’s a way to dig in: https://sqlcaster.xyz/?sql=select+avatar_url%2C+text+as+cast%2C+num_reply_children%2C+reactions%2C+watches+from+casts+%0A+where+username+%3D+%27scottbelsky%27+and+num_reply_children+is+not+null+%0A+order+by+num_reply_children+desc+%0A+limit+50%3B