https://bugzilla.wikimedia.org/show_bug.cgi?id=45770

--- Comment #6 from Andre Klapper <[email protected]> ---
Re https://gerrit.wikimedia.org/r/#/c/53387/ before I forget: 
Exclude bug reports in group 15 (security group) from the query:

SELECT products.name AS product, components.name AS component, bugs.bug_id AS
bugID, bugs.priority, bugs.delta_ts, profiles.login_name AS assignee,
bugs.short_desc as bugsummary FROM bugs JOIN profiles ON assigned_to =
profiles.userid JOIN products ON bugs.product_id = products.id JOIN components
ON bugs.component_id = components.id LEFT JOIN bug_group_map AS security_map ON
bugs.bug_id = security_map.bug_id WHERE ( security_map.group_id != 15 OR
security_map.group_id IS NULL ) AND ( resolution = "" OR resolution = "FIXED" )
AND ( priority = "Highest" OR priority = "Immediate" ) ORDER BY product,
component, delta_ts LIMIT 200;

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to