Index: /elgg/branches/elgg1.5-sql-fixes/engine/lib/relationships.php
===================================================================
--- /elgg/branches/elgg1.5-sql-fixes/engine/lib/relationships.php (revision 364)
+++ /elgg/branches/elgg1.5-sql-fixes/engine/lib/relationships.php (revision 380)
@@ -662,5 +662,5 @@
 		if (!$count) {
 			$query .= " group by e.guid,e.type,e.subtype,e.owner_guid,e.site_guid,e.container_guid,e.access_id,e.time_created,e.time_updated,e.enabled ";//postgres requires all fields being selected to be listed in the group by clause.  
-            $query .= " order by total desc limit {$limit} offset {$offset}"; // Add order and limit
+            $query .= " order by count(distinct e.guid) desc limit {$limit} offset {$offset}"; // Add order and limit
 			return get_data($query, "entity_row_to_elggstar");
 		} else {