aboutsummaryrefslogtreecommitdiff
path: root/engine
diff options
context:
space:
mode:
authorben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2009-01-20 12:26:50 +0000
committerben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>2009-01-20 12:26:50 +0000
commit358cf53e56498882a6870e06c58328742c9d8ed9 (patch)
tree7a68d7a2f5c8c1879ed325b0a6f41d875d358646 /engine
parent7fe851390bed54f4f8a0937436d61277c1f0ce7c (diff)
downloadelgg-358cf53e56498882a6870e06c58328742c9d8ed9.tar.gz
elgg-358cf53e56498882a6870e06c58328742c9d8ed9.tar.bz2
Added the missing 'group by' clause to the get annotations by sum SQL query.
git-svn-id: https://code.elgg.org/elgg/trunk@2584 36083f99-b078-4883-b0ff-0f9b5a30f544
Diffstat (limited to 'engine')
-rw-r--r--engine/lib/annotations.php3
1 files changed, 2 insertions, 1 deletions
diff --git a/engine/lib/annotations.php b/engine/lib/annotations.php
index 674af14b1..94e5381ce 100644
--- a/engine/lib/annotations.php
+++ b/engine/lib/annotations.php
@@ -648,7 +648,8 @@
$query .= get_access_sql_suffix("a"); // now add access
$query .= ' and ' . get_access_sql_suffix("e"); // now add access
$query .= ' order by sum ' . $orderdir;
-
+ $query .= ' group by e.guid';
+
return get_data($query, "entity_row_to_elggstar");
}