Index: src/routes/posts.js
===================================================================
--- src/routes/posts.js	(revision bddbfe06df7504ffcb60b3afc363f30f43c7f7af)
+++ src/routes/posts.js	(revision 2eca08338db9aa5243d74819007e9f383e619562)
@@ -946,5 +946,5 @@
   const candidates = isHub
     ? db.prepare(`
-        SELECT p.id, p.slug, p.title, p.cover_image_url, p.published_at, p.tags, s.slug AS site_slug
+        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
         FROM posts p JOIN sites s ON s.id = p.site_id
         WHERE p.status = 'published' AND p.id != ?
@@ -952,5 +952,5 @@
       `).all(post.id)
     : db.prepare(`
-        SELECT id, slug, title, cover_image_url, published_at, tags
+        SELECT id, slug, title, cover_image_url, published_at, tags, nsfw, content_warning
         FROM posts
         WHERE site_id = ? AND status = 'published' AND id != ?