Changeset 1278

Timestamp:

05/14/2004 04:20:38 PM (21 years ago)

Author:

michelvaldrighi

Message:

fix for the bug that made list_cats show empty categories, thanks to brux

File:

• trunk/wp-includes/template-functions-category.php (modified) (1 diff)

trunk/wp-includes/template-functions-category.php

@@ -298 +298 @@
         COUNT($tablepost2cat.post_id) AS cat_count
         FROM $tablecategories 
-    LEFT JOIN $tablepost2cat ON (cat_ID = category_id)
-        LEFT JOIN $tableposts ON (ID = post_id)
+    INNER JOIN $tablepost2cat ON (cat_ID = category_id)
+        INNER JOIN $tableposts ON (ID = post_id)
     WHERE 1 = 1 $exclusions
         GROUP BY category_id");