Issue 9948: Remove "@" from full text search

[friendica.git] / include / api.php

diff --git a/include/api.php b/include/api.php
index d56599ce66fec60b4755dfe7da36243d1f4bf54b..bd9640fcae6217b37eecc790b2f1c06532850945 100644 (file)
--- a/include/api.php
+++ b/include/api.php
@@ -6007,7 +6007,7 @@ function bindComments(&$data)
        }
 
        $idStr = DBA::escape(implode(', ', $ids));
-       $sql = "SELECT `parent`, COUNT(*) as comments FROM `post-view` WHERE `parent` IN ($idStr) AND `deleted` = ? AND `gravity`= ? GROUP BY `parent`";
+       $sql = "SELECT `parent`, COUNT(*) as comments FROM `post-user-view` WHERE `parent` IN ($idStr) AND `deleted` = ? AND `gravity`= ? GROUP BY `parent`";
        $items = DBA::p($sql, 0, GRAVITY_COMMENT);
        $itemsData = DBA::toArray($items);