Querying for fedora-review BLANK

[Warren Togami]

Hey Dave,

Bugzilla errors out when I try to query for fedora-review flag BLANK. 
Yesterday you suggested querying for a NOT of (fedora-review? AND 
fedora-review- AND fedora-review+).

Any suggestion?

Warren Togami
wtogami at redhat.com

Software error:

DBD::Pg::st execute failed: ERROR:  table name "flags_0" specified more 
than once
  [for Statement "SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, 
bugs.bug_status, bugs.resolution, bugs.alias, bugs.bug_severity, 
bugs.priority, bugs.rep_platform, map_assigned_to.login_name, 
bugs.bug_status, bugs.resolution, bugs.short_desc FROM bugs LEFT JOIN 
bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  LEFT JOIN cc ON 
cc.bug_id = bugs.bug_id AND cc.who = 40567 LEFT JOIN flags AS flags_0 ON 
bugs.bug_id = flags_0.bug_id AND flags_0.is_active = 1 LEFT JOIN 
flagtypes AS flagtypes_0 ON flags_0.type_id = flagtypes_0.id LEFT JOIN 
flags AS flags_0 ON bugs.bug_id = flags_0.bug_id AND flags_0.is_active = 
1 LEFT JOIN flagtypes AS flagtypes_0 ON flags_0.type_id = flagtypes_0.id 
LEFT JOIN flags AS flags_0 ON bugs.bug_id = flags_0.bug_id AND 
flags_0.is_active = 1 LEFT JOIN flagtypes AS flagtypes_0 ON 
flags_0.type_id = flagtypes_0.id , profiles AS map_assigned_to WHERE 
bugs.assigned_to = map_assigned_to.userid AND ((bugs.product_id IN (59)) 
AND (bugs.component_id IN (18187,18186,16465)) AND (bugs.bug_status IN 
('NEW','ASSIGNED','REOPENED'))) AND NOT(((flagtypes_0.name || 
flags_0.status) = 'fedora-review?') AND ((flagtypes_0.name || 
flags_0.status) = 'fedora-review-') AND ((flagtypes_0.name || 
flags_0.status) = 'fedora-review+')) AND ((bug_group_map.group_id IS 
NULL)  OR bug_group_map.group_id IN 
(81,134,106,149,75,68,138,148,140,12,144,79,67,76,41,127,58,122,35,133,7,62,93,126,17,11,50,72,146,71,84,39,10,33,107,22,4,78,123,145,108,139,44,124,150,121,119,85,92,91,15,25,80,21,142,61,155,83,74,5,38,94,147) 
  OR (bugs.reporter_accessible = 1 AND bugs.reporter = 40567)  OR 
(bugs.cclist_accessible = 1 AND cc.who IS NOT NULL)  OR 
(bugs.assigned_to = 40567)  OR (bugs.qa_contact = 40567) ) GROUP BY 
bugs.bug_id, 
bugs.bug_id,bugs.bug_severity,bugs.priority,bugs.bug_status,bugs.resolution,bugs.alias,bugs.bug_severity,bugs.priority,bugs.rep_platform,map_assigned_to.login_name,bugs.bug_status,bugs.resolution,bugs.short_desc 
ORDER BY bugs.bug_id"] at Bugzilla/DB.pm line 71
	Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, 
bugs.priority, bugs.bu...') called at /var/www/html/bugzilla/buglist.cgi 
line 651