Create my list of #TopTenPodcasts2021

iCatcher-Top-10-2021.sql

SELECT
  CAST(SUM(ZMEDIADURATION) / 60 / 60 AS INT) AS listened_hours,
  ZPODCAST.ZTITLE as podcast,
  ZURL as url
FROM
  ZPODCAST,
  ZPODCASTEPISODE
WHERE
  ZPODCASTEPISODE.ZPODCASTFOREPISODE == ZPODCAST.Z_PK
  AND 
      datetime(ZPLAYBACKLATEST + strftime('%s', '2001-01-01 00:00:00'), 'unixepoch') 
    > 
      datetime(strftime('%s', '2021-01-01 00:00:00'), 'unixepoch')
GROUP BY
  ZPODCAST.ZTITLE
ORDER BY
  SUM(ZMEDIADURATION) DESC
LIMIT
  10;