X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fgroup.php;h=53c0b78d841b5854f1eb08604a3c69aef0d2aad0;hb=b806f878740299eea54e86603840bbfd596a4bf7;hp=00b66ad58628f0db729447ed57987440b4a19e2f;hpb=bdfd81e7234662004f5ca3de1212b58b6dee161b;p=friendica.git

diff --git a/include/group.php b/include/group.php
index 00b66ad586..53c0b78d84 100644
--- 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`