SELECT tasks.id, tasks.name, LTRIM(RTRIM(NVL(jt0.first_name,'')||' '||NVL(jt0.last_name,''))) assigned_user_name, tasks.assigned_user_id, jt0.created_by assigned_user_name_owner, 'Users' assigned_user_name_mod, tasks.date_due AS date_start, tasks.status, LTRIM(RTRIM(NVL(contacts.first_name,'')||' '||NVL(contacts.last_name,''))) contact_name, tasks.contact_id, contacts.assigned_user_id contact_name_owner, 'Contacts' contact_name_mod, tasks.created_by, 'tasks' panel_name, ' ' ccms_level
FROM tasks
LEFT JOIN users jt0 ON tasks.assigned_user_id=jt0.id AND jt0.deleted=0 AND jt0.deleted=0
LEFT JOIN contacts contacts ON tasks.contact_id=contacts.id AND contacts.deleted=0 AND contacts.deleted=0
INNER JOIN contacts tasks_rel ON tasks.contact_id=tasks_rel.id AND tasks_rel.deleted=0
WHERE (tasks.contact_id='be7f843f-f4dd-1107-7a02-4fba1d2d3da2' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0) UNION ALL (
SELECT tasks.id, tasks.name, LTRIM(RTRIM(NVL(jt0.first_name,'')||' '||NVL(jt0.last_name,''))) assigned_user_name, tasks.assigned_user_id, jt0.created_by assigned_user_name_owner, 'Users' assigned_user_name_mod, tasks.date_due AS date_start, tasks.status, LTRIM(RTRIM(NVL(contacts.first_name,'')||' '||NVL(contacts.last_name,''))) contact_name, tasks.contact_id, contacts.assigned_user_id contact_name_owner, 'Contacts' contact_name_mod, tasks.created_by, 'tasks_parent' panel_name, ' ' ccms_level
FROM tasks
LEFT JOIN users jt0 ON tasks.assigned_user_id=jt0.id AND jt0.deleted=0 AND jt0.deleted=0
LEFT JOIN contacts contacts ON tasks.contact_id=contacts.id AND contacts.deleted=0 AND contacts.deleted=0
INNER JOIN contacts tasks_parent_rel ON tasks.parent_id=tasks_parent_rel.id AND tasks_parent_rel.deleted=0 AND tasks.parent_type = 'Contacts'
WHERE (tasks.parent_id='be7f843f-f4dd-1107-7a02-4fba1d2d3da2' AND (tasks.status != 'Completed' AND tasks.status != 'Deferred')) AND tasks.deleted=0) UNION ALL (
SELECT meetings.id, meetings.name, LTRIM(RTRIM(NVL(jt0.first_name,'')||' '||NVL(jt0.last_name,''))) assigned_user_name, meetings.assigned_user_id, jt0.created_by assigned_user_name_owner, 'Users' assigned_user_name_mod, meetings.date_start, meetings.status, ' ' contact_name, ' ' contact_id, ' ' contact_name_owner, ' ' contact_name_mod, meetings.created_by, 'meetings' panel_name, ' ' ccms_level
FROM meetings
LEFT JOIN users jt0 ON meetings.assigned_user_id=jt0.id AND jt0.deleted=0 AND jt0.deleted=0
INNER JOIN meetings_contacts ON meetings.id=meetings_contacts.meeting_id AND meetings_contacts.contact_id='be7f843f-f4dd-1107-7a02-4fba1d2d3da2' AND meetings_contacts.deleted=0
WHERE ((meetings.status !='Held' AND meetings.status !='Not Held')) AND meetings.deleted=0) UNION ALL (
SELECT calls.id, calls.name, LTRIM(RTRIM(NVL(jt0.first_name,'')||' '||NVL(jt0.last_name,''))) assigned_user_name, calls.assigned_user_id, jt0.created_by assigned_user_name_owner, 'Users' assigned_user_name_mod, calls.date_start, calls.status, ' ' contact_name, ' ' contact_id, ' ' contact_name_owner, ' ' contact_name_mod, calls.created_by, 'calls' panel_name, calls.ccms_level
FROM calls
LEFT JOIN users jt0 ON calls.assigned_user_id=jt0.id AND jt0.deleted=0 AND jt0.deleted=0
INNER JOIN calls_contacts ON calls.id=calls_contacts.call_id AND calls_contacts.contact_id='be7f843f-f4dd-1107-7a02-4fba1d2d3da2' AND calls_contacts.deleted=0
WHERE ((calls.status != 'Held' AND calls.status != 'Not Held')) AND calls.deleted=0)
ORDER BY date_start DESC