SELECT $class$ WHERE id = $id$ SELECT lnkInfraTicket WHERE ticket_id = $id$ SELECT lnkRelatedTicket WHERE ticket_id = $id$ SELECT lnkContactTicket WHERE ticket_id = $id$ SELECT EventNotificationEmail AS Ev JOIN TriggerOnObject AS T ON Ev.trigger_id = T.id WHERE T.target_class = 'bizIncidentTicket' AND Ev.object_id = $id$