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/groupsbymemberssection.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/groupsbymemberssection.php')
-rw-r--r-- | lib/groupsbymemberssection.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/groupsbymemberssection.php b/lib/groupsbymemberssection.php index 4fa07a244..5f26c6626 100644 --- a/lib/groupsbymemberssection.php +++ b/lib/groupsbymemberssection.php @@ -45,7 +45,7 @@ class GroupsByMembersSection extends GroupSection { function getGroups() { - $qry = 'SELECT user_group.*, count(*) as value ' . + $qry = 'SELECT user_group.id, count(*) as value ' . 'FROM user_group JOIN group_member '. 'ON user_group.id = group_member.group_id ' . 'GROUP BY user_group.id ' . |