Index: src/routes/posts.js
===================================================================
--- src/routes/posts.js	(revision 52ea6df4abea1a346a912f9f11d8e52a474df932)
+++ src/routes/posts.js	(revision 82079add2859eb42986c97e651ed5be8d0bec7d1)
@@ -661,5 +661,6 @@
   const commentRows = db.prepare(`
     SELECT c.id, c.parent_comment_id, c.content, c.status, c.created_at,
-           c.author_id, u.username AS author_username, u.avatar_url AS author_avatar
+           c.author_id, u.username AS author_username,
+           COALESCE(u.avatar_url, (SELECT profile_photo FROM sites WHERE owner_id = u.id AND profile_photo IS NOT NULL ORDER BY is_primary DESC, created_at ASC LIMIT 1)) AS author_avatar
     FROM comments c JOIN users u ON u.id = c.author_id
     WHERE c.post_id = ? AND c.status = 'approved'