diff options
author | CiaranG <ciaran@ciarang.com> | 2009-03-09 20:24:56 +0000 |
---|---|---|
committer | CiaranG <ciaran@ciarang.com> | 2009-03-09 20:24:56 +0000 |
commit | 945bbf00dc9ee106359e9387956c72c1290d12fc (patch) | |
tree | 6a681fb49c888e6f5b2071efbe315d8810a52d09 /lib | |
parent | 8d3d16f2f8fbbffc6824efcee4bd0ce25b314e14 (diff) |
PostgreSQL - a couple more GROUP BY queries that needed to be explicit
Diffstat (limited to 'lib')
-rw-r--r-- | lib/topposterssection.php | 2 |
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; |