From 22b6d2f30cb1d5a0e7b4f1385ddba79e59dc0b34 Mon Sep 17 00:00:00 2001
From: Dries Buytaert <dries@buytaert.net>
Date: Sat, 12 Jul 2003 22:21:55 +0000
Subject: - Performance improvement: changed a fair amount of "left joins" to
 "inner   joins".  Patch by Gerhard.

---
 modules/page.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/page.module')

diff --git a/modules/page.module b/modules/page.module
index 5f2fa91bf..2dea4392a 100644
--- a/modules/page.module
+++ b/modules/page.module
@@ -75,7 +75,7 @@ function page_link($type) {
   $links = array();
 
   if ($type == "page" && user_access("access content")) {
-    $result = db_query("SELECT n.nid, n.title, p.link, p.description FROM {page} p LEFT JOIN {node} n ON p.nid = n.nid WHERE n.status = '1' AND p.link != '' ORDER BY p.link");
+    $result = db_query("SELECT n.nid, n.title, p.link, p.description FROM {page} p INNER JOIN {node} n ON p.nid = n.nid WHERE n.status = '1' AND p.link != '' ORDER BY p.link");
     while ($page = db_fetch_object($result)) {
       $links[] = l($page->link, "node/view/$page->nid", array("title" => $page->description));
     }
-- 
cgit v1.2.3