Index: src/routes/posts.js
===================================================================
--- src/routes/posts.js	(revision 857a06fb0ed96db4010411e662b03b4f6fcb6bb0)
+++ src/routes/posts.js	(revision adb6291578046e2adec69d0fd51408d163b671ed)
@@ -998,5 +998,5 @@
   const candidates = isHub
     ? db.prepare(`
-        SELECT p.id, p.slug, p.title, p.cover_image_url, p.published_at, p.tags, p.nsfw, p.content_warning, s.slug AS site_slug
+        SELECT p.id, p.slug, p.title, p.cover_image_url, p.cover_video_url, p.published_at, p.tags, p.nsfw, p.content_warning, s.slug AS site_slug
         FROM posts p JOIN sites s ON s.id = p.site_id
         WHERE p.status = 'published' AND p.id != ?
@@ -1004,5 +1004,5 @@
       `).all(post.id)
     : db.prepare(`
-        SELECT id, slug, title, cover_image_url, published_at, tags, nsfw, content_warning
+        SELECT id, slug, title, cover_image_url, cover_video_url, published_at, tags, nsfw, content_warning
         FROM posts
         WHERE site_id = ? AND status = 'published' AND id != ?
Index: src/routes/tags.js
===================================================================
--- src/routes/tags.js	(revision 857a06fb0ed96db4010411e662b03b4f6fcb6bb0)
+++ src/routes/tags.js	(revision adb6291578046e2adec69d0fd51408d163b671ed)
@@ -22,5 +22,5 @@
   try {
     posts = db.prepare(`
-      SELECT DISTINCT p.id, p.slug, p.title, p.excerpt, p.cover_image_url,
+      SELECT DISTINCT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.cover_video_url,
                       p.published_at, u.username AS author_username
       FROM posts p, json_each(p.tags) j
@@ -35,5 +35,5 @@
     // Fall back to a LIKE match if json_each isn't available for some reason
     posts = db.prepare(`
-      SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url,
+      SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.cover_video_url,
              p.published_at, u.username AS author_username
       FROM posts p JOIN users u ON u.id = p.author_id
Index: src/routes/types.js
===================================================================
--- src/routes/types.js	(revision 857a06fb0ed96db4010411e662b03b4f6fcb6bb0)
+++ src/routes/types.js	(revision adb6291578046e2adec69d0fd51408d163b671ed)
@@ -21,5 +21,5 @@
 
   const posts = db.prepare(`
-    SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url,
+    SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.cover_video_url,
            p.published_at, p.type, u.username AS author_username
     FROM posts p JOIN users u ON u.id = p.author_id
Index: src/routes/users.js
===================================================================
--- src/routes/users.js	(revision 857a06fb0ed96db4010411e662b03b4f6fcb6bb0)
+++ src/routes/users.js	(revision adb6291578046e2adec69d0fd51408d163b671ed)
@@ -27,5 +27,5 @@
 
   const posts = db.prepare(`
-    SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.published_at
+    SELECT p.id, p.slug, p.title, p.excerpt, p.cover_image_url, p.cover_video_url, p.published_at
     FROM posts p
     WHERE p.author_id = ? AND p.site_id = ? AND p.status = 'published'