From 69038b58a7ea9af845c3503718366a0e66491189 Mon Sep 17 00:00:00 2001
From: cash <cash@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Thu, 7 Apr 2011 02:50:29 +0000
Subject: Fixes #3232 removed unnecessary distinct plus variable in select for
 metastrings calculation

git-svn-id: http://code.elgg.org/elgg/trunk@8951 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/lib/metastrings.php | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'engine/lib')

diff --git a/engine/lib/metastrings.php b/engine/lib/metastrings.php
index 0d472a18b..47712d3fa 100644
--- a/engine/lib/metastrings.php
+++ b/engine/lib/metastrings.php
@@ -409,8 +409,7 @@ function elgg_get_metastring_based_objects($options) {
 		$query = "SELECT DISTINCT n_table.*, n.string as name,
 			v.string as value FROM {$db_prefix}$type n_table";
 	} else {
-		$query = "SELECT DISTINCT v.string as value,
-			{$options['metastring_calculation']}(v.string) as calculation FROM {$db_prefix}$type n_table";
+		$query = "SELECT {$options['metastring_calculation']}(v.string) as calculation FROM {$db_prefix}$type n_table";
 	}
 
 	// add joins
-- 
cgit v1.2.3