Changeset 1544 for trunk/gregarius/util.php

Timestamp:

08/24/06 01:14:02 (4 years ago)

Author:

cfriesen

Message:

Feel free to scream if this breaks something...

Files:

• trunk/gregarius/util.php (modified) (1 diff)

trunk/gregarius/util.php

@@ -883 +883 @@
     }
 
-    $sql = "select count(*) from "
-           .getTable("item")    ."i, ".getTable('channels')."c "
+    $sql = "select count(*) from " . getTable("item") ."i "
+           ."inner join " . getTable('channels')." c on c.id = i.cid "
            ." where i.unread & ".RSS_MODE_UNREAD_STATE. " and not(i.unread & " .
-           RSS_MODE_DELETED_STATE .") and i.cid=c.id "
+           RSS_MODE_DELETED_STATE .") "
            ." and not(c.mode & ".RSS_MODE_DELETED_STATE.") ";