Changeset 380

Show
Ignore:
Timestamp:
07/02/09 09:28:06 (4 months ago)
Author:
bettse
Message:

correction to order by clause in relationships.php

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • elgg/branches/elgg1.5-sql-fixes/engine/lib/relationships.php

    r364 r380  
    662662                if (!$count) { 
    663663                        $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.   
    664             $query .= " order by total desc limit {$limit} offset {$offset}"; // Add order and limit 
     664            $query .= " order by count(distinct e.guid) desc limit {$limit} offset {$offset}"; // Add order and limit 
    665665                        return get_data($query, "entity_row_to_elggstar"); 
    666666                } else {