SELECT bugs.bug_id, bugs.bug_severity, bugs.priority, bugs.bug_status, bugs.resolution, map_products.name, bugs.bug_severity, bugs.priority, bugs.op_sys, map_products.name, bugs.bug_status, bugs.resolution, bugs.short_desc, map_assigned_to.login_name FROM bugs  INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to = map_assigned_to.userid) INNER JOIN products AS map_products ON (bugs.product_id = map_products.id) LEFT JOIN longdescs AS longdescs_LD0 ON (longdescs_LD0.bug_id = bugs.bug_id AND longdescs_LD0.isprivate < 1 AND longdescs_LD0.who IN (62497)) LEFT JOIN bug_status ON (bug_status.value = bugs.bug_status) LEFT JOIN bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  WHERE ((longdescs_LD0.who IS NOT NULL)) AND bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS NULL)) GROUP BY bugs.bug_id ORDER BY bug_status.sortkey,bug_status.value,bugs.priority,map_assigned_to.login_name,bugs.bug_id