From f8b945c9856ae93508172f8b024ae26d94667899 Mon Sep 17 00:00:00 2001
From: "terry%mozilla.org" <>
Date: Fri, 7 Jan 2000 05:32:59 +0000
Subject: Whoops; SQL doesn't seem to want me to mention a table in a SELECT
 statement if I'm not going to use it.

---
 buglist.cgi | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/buglist.cgi b/buglist.cgi
index 211259dca..7ae3f066c 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -235,8 +235,7 @@ from   bugs,
        profiles assign,
        profiles report
        left join profiles qacont on bugs.qa_contact = qacont.userid,
-       versions projector,
-       keywords
+       versions projector
 
 where  bugs.assigned_to = assign.userid 
 and    bugs.reporter = report.userid
@@ -309,6 +308,7 @@ if ($::FORM{'keywords'}) {
         }
     }
     if (@list) {
+        $query =~ s/bugs,/bugs, keywords,/;
         $query .= "and keywords.bug_id = bugs.bug_id and (" .
             join(" $::FORM{'keywords_type'} ", @list) . ")\n";
     }
-- 
cgit v1.2.3-24-g4f1b