Index: src/routes/posts.js
===================================================================
--- src/routes/posts.js	(revision abdcf3302cfa9320f287ba1d993dece88a8ef830)
+++ src/routes/posts.js	(revision 0596945917047f2e8963b16e2ef73366d22a62e4)
@@ -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 != ?