diff options
| -rw-r--r-- | engine/lib/metadata.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/engine/lib/metadata.php b/engine/lib/metadata.php index 5ed435a0c..aba7e782d 100644 --- a/engine/lib/metadata.php +++ b/engine/lib/metadata.php @@ -340,7 +340,7 @@ if ($meta_value!="") $where[] = "m.value_id='$meta_v'"; - $query = "SELECT * from {$CONFIG->dbprefix}entities e JOIN {$CONFIG->dbprefix}metadata m on e.guid = m.entity_guid where"; + $query = "SELECT distinct e.* from {$CONFIG->dbprefix}entities e JOIN {$CONFIG->dbprefix}metadata m on e.guid = m.entity_guid where"; foreach ($where as $w) $query .= " $w and "; $query .= " (e.access_id in {$access} or (e.access_id = 0 and e.owner_guid = {$_SESSION['id']}))"; // Add access controls |