Comment by @rickydata • Hey

Thanks for collecting! Yup that's the table used here. Here's the query for the new one I just published with hashtags likes: """ WITH hashtags AS ( SE

Stats

Comments

thanks for sharing. I was looking for the plain number how often "$LENS" appeared in posts so far (and comments step 2) - https://lenster.xyz/posts/0x0f85-0x128b But the result of the query is not what I've expected ... (#50). And the result set doesn't show e.g. the post mentioned above. Do you have an idea what might be the issue? SELECT post_id , profile_id , content FROM lens-public-data.polygon.public_profile_post pp WHERE UPPER(content) LIKE '%$LENS%' ORDER BY block_timestamp DESC