Skip to content

Instantly share code, notes, and snippets.

@mattm

mattm/recent-blog-posts.sql Secret

Last active May 11, 2018 17:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mattm/d33b9e9e6780c5b4a82a14adc7b2eef7 to your computer and use it in GitHub Desktop.
Save mattm/d33b9e9e6780c5b4a82a14adc7b2eef7 to your computer and use it in GitHub Desktop.
Download ZIP
Recent Help Scout blog posts
Raw
recent-blog-posts.sql
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