From a693c9bbeb444ee96bf933187c0ef795e3c7251a Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Wed, 19 Jan 2011 00:10:27 +0100 Subject: [PATCH] Remove unnecessary DISTINCTs. --- framework/Share/lib/Horde/Share/Sqlng.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/framework/Share/lib/Horde/Share/Sqlng.php b/framework/Share/lib/Horde/Share/Sqlng.php index e729fd56e..3924e5685 100644 --- a/framework/Share/lib/Horde/Share/Sqlng.php +++ b/framework/Share/lib/Horde/Share/Sqlng.php @@ -93,7 +93,7 @@ class Horde_Share_Sqlng extends Horde_Share_Sql $sortfield = 'attribute_' . $params['sort_by']; } - $query = 'SELECT DISTINCT * FROM ' . $this->_table . ' WHERE ' + $query = 'SELECT * FROM ' . $this->_table . ' WHERE ' . $this->_getShareCriteria($userid, $perms, $params['attributes'], $shareids) . ' ORDER BY ' . $sortfield . (($params['direction'] == 0) ? ' ASC' : ' DESC'); @@ -159,7 +159,7 @@ class Horde_Share_Sqlng extends Horde_Share_Sql list(, , $shareids) = $this->_getUserAndGroupShares($userid, $perms); } - $query = 'SELECT COUNT(DISTINCT share_id) FROM ' + $query = 'SELECT COUNT(share_id) FROM ' . $this->_table . ' WHERE ' . $this->_getShareCriteria($userid, $perms, $attributes, $shareids); -- 2.11.0