diff options
| -rw-r--r-- | modules/statistics/statistics.admin.inc | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/modules/statistics/statistics.admin.inc b/modules/statistics/statistics.admin.inc index 72485ab88..303eafa44 100644 --- a/modules/statistics/statistics.admin.inc +++ b/modules/statistics/statistics.admin.inc @@ -118,8 +118,10 @@ function statistics_top_visitors() { ->limit(30) ->orderByHeader($header); - $count_query = db_select('accesslog'); - $count_query->addExpression('COUNT(DISTINCT CONCAT(CAST(uid AS char), hostname))'); + $uniques_query = db_select('accesslog')->distinct(); + $uniques_query->fields('accesslog', array('uid', 'hostname')); + $count_query = db_select($uniques_query); + $count_query->addExpression('COUNT(*)'); $query->setCountQuery($count_query); $result = $query->execute(); |