Changeset 379

Show
Ignore:
Timestamp:
07/02/09 09:27:31 (5 months ago)
Author:
bettse
Message:

correction to having and group by clauses in tags.php

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

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

    r268 r379  
    137137                $query .= ' and ' . get_access_sql_suffix("e"); // Add access controls 
    138138                 
    139                 $query .= " group by msvalue.string having total > {$threshold} order by total desc limit {$limit} "; 
     139                $query .= " group by msvalue.string having count(msvalue.id) > {$threshold} order by count(msvalue.id) desc limit {$limit} "; 
    140140 
    141141                return get_data($query);