SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, bugs.delta_ts, bugs.bug_severity, bugs.priority, bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status, bugs.resolution, bugs.status_whiteboard, bugs.short_desc FROM bugs, profiles AS map_assigned_to LEFT JOIN bugs_activity act_0 ON (act_0.bug_id = bugs.bug_id AND act_0.fieldid = 30 AND act_0.removed = 'INVALID') AND (act_0.bug_id = bugs.bug_id AND act_0.fieldid = 30 AND act_0.removed = 'WONTFIX') LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN (9,10) LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 103593 WHERE bugs.assigned_to = map_assigned_to.userid AND ((bugs.product_id IN (21))) AND ((((act_0.bug_when IS NOT NULL)) OR ((act_0.bug_when IS NOT NULL)))) AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 103593) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 103593) OR (bugs.qa_contact = 103593) ) GROUP BY bugs.bug_id ORDER BY bugs.bug_id