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/queue.module | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'modules/queue.module')

diff --git a/modules/queue.module b/modules/queue.module
index ec333594e..6617cbb18 100644
--- a/modules/queue.module
+++ b/modules/queue.module
@@ -88,7 +88,7 @@ function queue_vote($node, $vote) {
 function queue_overview() {
   global $user;
 
-  $result = db_query("SELECT n.*, u.name, u.uid FROM {node} n LEFT JOIN {users} u ON n.uid = u.uid WHERE n.moderate = 1");
+  $result = db_query("SELECT n.*, u.name, u.uid FROM {node} n INNER JOIN {users} u ON n.uid = u.uid WHERE n.moderate = 1");
 
   $output .= "<table border=\"0\" cellspacing=\"4\" cellpadding=\"4\">";
   $output .= " <tr><th>". t("Subject") ."</th><th>". t("Author") ."</th><th>". t("Type") ."</th><th>". t("Score") ."</th></tr>";
-- 
cgit v1.2.3