diff options
Diffstat (limited to 'include/functions_tag.inc.php')
-rw-r--r-- | include/functions_tag.inc.php | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/include/functions_tag.inc.php b/include/functions_tag.inc.php index c6dc01db6..281517779 100644 --- a/include/functions_tag.inc.php +++ b/include/functions_tag.inc.php @@ -53,8 +53,12 @@ SELECT id, name, url_name, count(*) counter 'visible_categories' => 'category_id', 'visible_images' => 'image_id' ), - 'WHERE' - ); + ' + WHERE' + ).' + GROUP BY tag_id + ORDER BY NULL'; + $tag_counters = simple_hash_from_query($query, 'tag_id', 'counter'); if (!empty($where_tag_img)) { @@ -261,6 +265,11 @@ SELECT id, name, url_name, count(*) counter ORDER BY counter DESC LIMIT 0,'.$max_tags; } + else + { + $query .= ' + ORDER BY NULL'; + } $result = pwg_query($query); $tags = array(); |