Skip to content

Instantly share code, notes, and snippets.

@quanganhdo

quanganhdo/castro-history.sql

Created August 5, 2019 18:45
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save quanganhdo/c719d7e92497642234eebe75926d6f9b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save quanganhdo/c719d7e92497642234eebe75926d6f9b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
castro-history.sql
SELECT title, name, starred, lastPlayed, 'https://castro.fm/episode/' || e.shortId url
FROM supepisode e, suppodcast p
WHERE e.podcastId = p.id AND (lastplayed > 0 OR starred = 1) AND e.shortId != ''
ORDER BY lastPlayed DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment