diff options
| -rw-r--r-- | Bugzilla/User.pm | 14 |
1 files changed, 10 insertions, 4 deletions
diff --git a/Bugzilla/User.pm b/Bugzilla/User.pm index f5aae89e1..fa924bf05 100644 --- a/Bugzilla/User.pm +++ b/Bugzilla/User.pm @@ -198,13 +198,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}); |