diff options
author | CiaranG <ciaran@ciarang.com> | 2009-03-04 15:32:26 +0000 |
---|---|---|
committer | CiaranG <ciaran@ciarang.com> | 2009-03-04 15:32:26 +0000 |
commit | 115519a5e7e84e57656c653918efb39ab4107fe9 (patch) | |
tree | 2c66758d4df65f8d9b76cc17a6893c662debdf16 /lib/groupsbypostssection.php | |
parent | c02a2f189139bd3588b04e557239e243805aaeac (diff) |
PostgreSQL - made all 'weight' calculating SQL expressions compatible with both databases, and made some GROUP BY queries more explicit about the fields they are selecting, for the same reason.
Diffstat (limited to 'lib/groupsbypostssection.php')
-rw-r--r-- | lib/groupsbypostssection.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/groupsbypostssection.php b/lib/groupsbypostssection.php index a5e33a93d..1a60ddb4f 100644 --- a/lib/groupsbypostssection.php +++ b/lib/groupsbypostssection.php @@ -45,7 +45,7 @@ class GroupsByPostsSection extends GroupSection { function getGroups() { - $qry = 'SELECT user_group.*, count(*) as value ' . + $qry = 'SELECT user_group.id, count(*) as value ' . 'FROM user_group JOIN group_inbox '. 'ON user_group.id = group_inbox.group_id ' . 'GROUP BY user_group.id ' . |