Index: src/routes/posts.js
===================================================================
--- src/routes/posts.js	(revision 1e2e9e796a68983531a8d24e36c35e9319d25413)
+++ src/routes/posts.js	(revision 8cdb377943308d65de80427694f9692337081aa7)
@@ -401,5 +401,5 @@
   const ordered = isHub
     ? db.prepare(`
-        SELECT p.id, p.slug, p.title, s.slug AS site_slug
+        SELECT p.id, p.slug, p.title, p.pinned, s.slug AS site_slug
         FROM posts p JOIN sites s ON s.id = p.site_id
         WHERE p.status = 'published'
@@ -407,5 +407,5 @@
       `).all()
     : db.prepare(`
-        SELECT id, slug, title FROM posts
+        SELECT id, slug, title, pinned FROM posts
         WHERE site_id = ? AND status = 'published'
         ORDER BY (pinned = 0) ASC, pinned ASC, published_at DESC