diff options
Diffstat (limited to 'mostviewedimages.php')
| -rw-r--r-- | mostviewedimages.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mostviewedimages.php b/mostviewedimages.php index 5bbbcf5e7..9d2831bf7 100644 --- a/mostviewedimages.php +++ b/mostviewedimages.php @@ -17,7 +17,7 @@ //$annotations = get_annotations(0, "object", "image", "tp_view", "", "", 5000); $sql = "SELECT ent.guid, count( * ) AS views - FROM `my_elggentities` ent + FROM " . $prefix . "entities ent INNER JOIN " . $prefix . "entity_subtypes sub ON ent.subtype = sub.id AND sub.subtype = 'image' INNER JOIN " . $prefix . "annotations ann1 ON ann1.entity_guid = ent.guid |