From d03d933b737f66e75c45d6b6b381396c8d4fb837 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 19 Nov 2003 17:54:44 +0000 Subject: - Performance improvement: changed a LEFT JOIN to an INNER JOIN. Patch #157 by Gerhard. --- modules/statistics/statistics.module | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules/statistics/statistics.module') diff --git a/modules/statistics/statistics.module b/modules/statistics/statistics.module index 1be70182b..bbeb72cf6 100644 --- a/modules/statistics/statistics.module +++ b/modules/statistics/statistics.module @@ -359,7 +359,7 @@ function statistics_admin_accesslog_table($type, $id) { } else if ($type == 2) { /* retrieve recent access logs for node $id */ - $sql = "SELECT a.nid, a.url, a.hostname, a.uid, a.timestamp, n.title FROM {accesslog} a LEFT JOIN {node} n ON a.nid = n.nid WHERE a.nid = ". check_query($id); + $sql = "SELECT a.nid, a.url, a.hostname, a.uid, a.timestamp, n.title FROM {accesslog} a INNER JOIN {node} n ON a.nid = n.nid WHERE a.nid = ". check_query($id); } else if ($type == 3) { /* retrieve recent access logs for hostname $id */ -- cgit v1.2.3