Skip to content

Instantly share code, notes, and snippets.

@xoelop

xoelop/results_likes_tinybird_node.sql

Last active January 27, 2021 13:35
Show Gist options
  • Save xoelop/d50011af8348c89a7d68e9361ffdf59e to your computer and use it in GitHub Desktop.
Save xoelop/d50011af8348c89a7d68e9361ffdf59e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
results_likes_tinybird_node.sql
SELECT
date,
link,
tweet_text,
ifNull(url, '') url,
ifNull(title, '') title,
ifNull(description, '') description,
media,
format('https://twitter.com/{}', screenname) user_link,
format('{} (@{})', username, screenname) user_name_handle,
user_logo,
bio,
ifNull(location, '') location,
likes,
rts,
num_followers
FROM filter_likes
ORDER BY date desc
LIMIT 1 BY link
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment