aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--phpBB/functions/functions.php8
1 files changed, 3 insertions, 5 deletions
diff --git a/phpBB/functions/functions.php b/phpBB/functions/functions.php
index b988b4a9cd..cc387ecde0 100644
--- a/phpBB/functions/functions.php
+++ b/phpBB/functions/functions.php
@@ -87,11 +87,9 @@ function make_jumpbox($db)
$limit_forums = "";
- $sql = "SELECT f.*, u.username, u.user_id, p.post_time
- FROM ".FORUMS_TABLE." f
- LEFT JOIN ".POSTS_TABLE." p ON p.post_id = f.forum_last_post_id
- LEFT JOIN ".USERS_TABLE." u ON u.user_id = p.poster_id
- ORDER BY f.cat_id, f.forum_order";
+ $sql = "SELECT *
+ FROM ".FORUMS_TABLE."
+ ORDER BY cat_id, forum_order";
if(!$q_forums = $db->sql_query($sql))
{
error_die($db, QUERY_ERROR);