Merge pull request #2758 from annando/1609-sql-charset

[friendica.git] / include / group.php

diff --git a/include/group.php b/include/group.php
index 00b66ad58628f0db729447ed57987440b4a19e2f..53c0b78d841b5854f1eb08604a3c69aef0d2aad0 100644 (file)
--- a/include/group.php
+++ b/include/group.php
@@ -366,7 +366,7 @@ function groups_containing($uid,$c) {
 function groups_count_unseen() {
 
        $r = q("SELECT `group`.`id`, `group`.`name`,
-                       (SELECT COUNT(*) FROM `item`
+                       (SELECT COUNT(*) FROM `item` FORCE INDEX (`uid_unseen_contactid`)
                                WHERE `uid` = %d AND `unseen` AND
                                        `contact-id` IN (SELECT `contact-id` FROM `group_member`
                                                                WHERE `group_member`.`gid` = `group`.`id` AND `group_member`.`uid` = %d)) AS `count`