summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorCiaranG <ciaran@ciarang.com>2009-03-09 20:24:56 +0000
committerCiaranG <ciaran@ciarang.com>2009-03-09 20:24:56 +0000
commit945bbf00dc9ee106359e9387956c72c1290d12fc (patch)
tree6a681fb49c888e6f5b2071efbe315d8810a52d09 /lib
parent8d3d16f2f8fbbffc6824efcee4bd0ce25b314e14 (diff)
PostgreSQL - a couple more GROUP BY queries that needed to be explicit
Diffstat (limited to 'lib')
-rw-r--r--lib/topposterssection.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/topposterssection.php b/lib/topposterssection.php
index 4bd59ac79..1a2ce0014 100644
--- a/lib/topposterssection.php
+++ b/lib/topposterssection.php
@@ -51,7 +51,7 @@ class TopPostersSection extends ProfileSection
$qry = 'SELECT profile.*, count(*) as value ' .
'FROM profile JOIN notice ON profile.id = notice.profile_id ' .
(common_config('public', 'localonly') ? 'WHERE is_local = 1 ' : '') .
- 'GROUP BY profile.id ' .
+ 'GROUP BY profile.id,nickname,fullname,profileurl,homepage,bio,location,profile.created,profile.modified,textsearch ' .
'ORDER BY value DESC ';
$limit = PROFILES_PER_SECTION;