Skip to content

Instantly share code, notes, and snippets.

@unitof

unitof/overcast_export_recommended_episodes.sql

Forked from parkr/overcast_export_recommended_episodes.sql
Last active March 23, 2025 02:15
Show Gist options
  • Save unitof/ea46d1cd36e47dd9a165e729a4832c7d to your computer and use it in GitHub Desktop.
Save unitof/ea46d1cd36e47dd9a165e729a4832c7d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. unitof revised this gist Mar 23, 2025. 1 changed file with 0 additions and 1 deletion.
    1 change: 0 additions & 1 deletion overcast_export_recommended_episodes.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -12,5 +12,4 @@ FROM OCFeedItem AS feed_item
    INNER JOIN OCFeed AS feed ON (feed_item.feedID = feed.id)
    WHERE feed_item.userRecommendedTime IS NOT NULL
    AND feed_item.userRecommendedTime > 0
    AND feed.isPrivate = 0
    ORDER BY feed_item.userRecommendedTime DESC;
  2. unitof revised this gist Mar 23, 2025. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions overcast_export_recommended_episodes.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -6,6 +6,7 @@ SELECT
    STRFTIME('%Y-%m-%d', CAST(feed_item.userRecommendedTime AS float),'unixepoch') AS userRecommendedTimeHuman,
    feed.link as feedLink,
    feed_item.url as episodeURL,
    feed_item.enclosureURL as downloadURL,
    feed.artworkURL as feedArtworkURL
    FROM OCFeedItem AS feed_item
    INNER JOIN OCFeed AS feed ON (feed_item.feedID = feed.id)
  3. @parkr parkr revised this gist Feb 10, 2023. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions overcast_export_recommended_episodes.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -11,4 +11,5 @@ FROM OCFeedItem AS feed_item
    INNER JOIN OCFeed AS feed ON (feed_item.feedID = feed.id)
    WHERE feed_item.userRecommendedTime IS NOT NULL
    AND feed_item.userRecommendedTime > 0
    AND feed.isPrivate = 0
    ORDER BY feed_item.userRecommendedTime DESC;
  4. @parkr parkr created this gist Feb 9, 2023.
    14 changes: 14 additions & 0 deletions overcast_export_recommended_episodes.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    SELECT
    feed_item.feedID,
    feed.title as feedTitle,
    feed_item.title,
    feed_item.userRecommendedTime,
    STRFTIME('%Y-%m-%d', CAST(feed_item.userRecommendedTime AS float),'unixepoch') AS userRecommendedTimeHuman,
    feed.link as feedLink,
    feed_item.url as episodeURL,
    feed.artworkURL as feedArtworkURL
    FROM OCFeedItem AS feed_item
    INNER JOIN OCFeed AS feed ON (feed_item.feedID = feed.id)
    WHERE feed_item.userRecommendedTime IS NOT NULL
    AND feed_item.userRecommendedTime > 0
    ORDER BY feed_item.userRecommendedTime DESC;