From f036e905f28e158ecbf9254d5e112a59c94237c3 Mon Sep 17 00:00:00 2001
From: "lpsolit%gmail.com" <>
Date: Wed, 28 Sep 2005 05:22:20 +0000
Subject: [PATCH] Bug 309896: The "Saved searches" tab in User Prefs can report
 incorrect information - Patch by A. Karl Kornel <karl@kornel.name> r=LpSolit
 a=justdave

---
 Bugzilla/User.pm | 14 ++++++++++----
 1 file changed, 10 insertions(+), 4 deletions(-)

diff --git a/Bugzilla/User.pm b/Bugzilla/User.pm
index cb3ac3dba2..3a3cace197 100644
--- a/Bugzilla/User.pm
+++ b/Bugzilla/User.pm
@@ -218,13 +218,19 @@ sub queries {
     my $dbh = Bugzilla->dbh;
     my $sth = $dbh->prepare(q{ SELECT
                              DISTINCT name, query, linkinfooter,
-                                      CASE WHEN whine_queries.id 
-                                      IS NOT NULL THEN 1 ELSE 0 END,
+                                      CASE WHEN whine_queries.id IS NOT NULL
+                                      THEN 1 ELSE 0 END,
                                       UPPER(name) AS uppername 
                                  FROM namedqueries
+                            LEFT JOIN whine_events
+                                   ON whine_events.owner_userid =
+                                      namedqueries.userid
                             LEFT JOIN whine_queries
-                                   ON whine_queries.query_name = name
-                                WHERE userid=?
+                                   ON whine_queries.query_name =
+                                      namedqueries.name
+                                  AND whine_queries.eventid = 
+                                      whine_events.id
+                                WHERE namedqueries.userid=?
                              ORDER BY uppername});
     $sth->execute($self->{id});
 
-- 
2.47.2