Skip to content

Instantly share code, notes, and snippets.

@mattm

mattm/recent-blog-posts.sql Secret

Last active May 11, 2018
Embed
What would you like to do?
Recent Help Scout blog posts
SELECT
current_url,
MIN(TIMESTAMP_TRUNC(time, DAY)) AS published_at
FROM mp.event
WHERE
current_url like "https://www.helpscout.net/blog/%"
GROUP BY 1
HAVING
COUNT(*) > 200 AND
MIN(time) >= "2018-04-04"
ORDER BY 2 DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment