1 files changed, 1 insertions, 1 deletions
diff --git a/index.php b/index.php
index 8b5c29ec7..2dc1f4025 100644
--- a/index.php
+++ b/index.php
@@ -13,7 +13,7 @@ $number = ($user->stories) ? $user->stories : 10;
 $date = ($date) ? $date : time();
 
 // Perform query:
-$result = db_query("SELECT stories.*, users.userid, COUNT(comments.sid) AS comments FROM stories LEFT JOIN comments ON stories.id = comments.sid LEFT JOIN users ON stories.author = users.id WHERE stories.status = 2 AND stories.timestamp <= $date GROUP BY stories.id ORDER BY stories.timestamp DESC LIMIT $number");
+$result = db_query("SELECT stories.*, users.userid, COUNT(comments.lid) AS comments FROM stories LEFT JOIN comments ON stories.id = comments.lid LEFT JOIN users ON stories.author = users.id WHERE stories.status = 2 AND stories.timestamp <= $date GROUP BY stories.id ORDER BY stories.timestamp DESC LIMIT $number");
 
 // Display stories:
 $theme->header();