From cdbfbf1fafefcd5e30915e5b12f8c4ea26f4721a Mon Sep 17 00:00:00 2001
From: "endico%mozilla.org" <>
Date: Sat, 10 Mar 2001 15:08:36 +0000
Subject: backing out the changes to queries on CC since they broke normal cc
 queries in the standard email address box at the top of the page

---
 buglist.cgi | 10 +++-------
 1 file changed, 3 insertions(+), 7 deletions(-)

diff --git a/buglist.cgi b/buglist.cgi
index 45feab9f0..9818bfe78 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -335,13 +335,9 @@ sub GenerateSQL {
          },
 
          "^cc," => sub {
-                my $tablecc = "cc_" . $chartid;
-                my $tableprof = "cc_prof_" . $chartid;
-		push(@supptables, "cc $tablecc, profiles $tableprof");
-		$ff = "$tableprof.login_name ";
-		$ref = $funcsbykey{",$t"};
-		&$ref;
-                push(@wherepart, " $tablecc.bug_id = bugs.bug_id AND $tablecc.who=$tableprof.userid ");
+            push(@supptables,                                                  
+              ("LEFT JOIN cc cc_$chartid ON bugs.bug_id = cc_$chartid.bug_id LEFT JOIN profiles map_cc_$chartid ON cc_$chartid.who = map_cc_$chartid.userid"));
+            $f = "map_cc_$chartid.login_name";  
          },
 
          "^long_?desc,changedby" => sub {
-- 
cgit v1.2.3-24-g4f1b