TICKET_EDITABLE

Columns

Query:

select u.user_id, ti.msg_id
from ticket_issues_i ti, ticket_domains td, ticket_projects tp, users u
where tp.project_id = ti.project_id
 and td.domain_id = ti.domain_id
 and (exists (select 1
              from user_group_map
              where (group_id = tp.group_id or group_id = ticket_admin_group_id)
                and user_id = u.user_id)
   or exists (select 1
              from user_group_map
              where group_id = td.group_id
                and user_id = u.user_id))