From 75751e197b41670b5223a28c0022d4f0cd4f815a Mon Sep 17 00:00:00 2001 From: ben Date: Wed, 28 May 2008 15:58:51 +0000 Subject: Query fixes for previous. git-svn-id: https://code.elgg.org/elgg/trunk@748 36083f99-b078-4883-b0ff-0f9b5a30f544 --- engine/lib/tags.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'engine') diff --git a/engine/lib/tags.php b/engine/lib/tags.php index 5ec06105c..8648fb3f8 100644 --- a/engine/lib/tags.php +++ b/engine/lib/tags.php @@ -101,7 +101,7 @@ $access = get_access_list(); - $query = "SELECT {$CONFIG->dbprefix}msvalue.string as tag, count(msvalue.id) as total "; + $query = "SELECT msvalue.string as tag, count(msvalue.id) as total "; $query .= "FROM {$CONFIG->dbprefix}entities e join {$CONFIG->dbprefix}metadata md on md.entity_guid = e.guid "; $query .= " join {$CONFIG->dbprefix}entity_subtypes subtype on subtype.id = e.subtype "; $query .= " join {$CONFIG->dbprefix}metastrings msvalue on msvalue.id = md.value_id "; -- cgit v1.2.3