(SELECT meetings.id , meetings.name , meetings.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod ,
meetings.date_start as date_start , meetings.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner ,
'Users' assigned_user_name_mod, ' ' filename , meetings.assigned_user_id , 'meetings' panel_name
FROM meetings
LEFT JOIN users jt1 ON jt1.id= meetings.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0
INNER JOIN meetings_contacts ON (meetings.id=meetings_contacts.meeting_id
AND meetings_contacts.contact_id= 'dfee0e7e-c044-d67d-e018-464c630c23f7')
where ( meetings_contacts.deleted=0 AND meetings.deleted=0 AND (meetings.status='Held' OR meetings.status='Not Held'))
AND meetings.deleted=0)
UNION ALL
( SELECT tasks.id , tasks.name , tasks.status , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) contact_name ,
tasks.contact_id , contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, tasks.date_due as date_start ,
tasks.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner ,
'Users' assigned_user_name_mod, ' ' filename , tasks.assigned_user_id , 'tasks' panel_name
FROM tasks
LEFT JOIN contacts contacts ON contacts.id= tasks.contact_id AND contacts.deleted=0 AND contacts.deleted=0
LEFT JOIN users jt1 ON jt1.id= tasks.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0
where ( tasks.contact_id= 'dfee0e7e-c044-d67d-e018-464c630c23f7'
AND tasks.deleted=0 AND (tasks.status='Completed' OR tasks.status='Deferred')) AND tasks.deleted=0 )
UNION ALL
( SELECT calls.id , calls.name , calls.status , ' ' contact_name ,
' ' contact_id , ' ' contact_name_owner , ' ' contact_name_mod , calls.date_start as date_start ,
calls.date_modified , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner ,
'Users' assigned_user_name_mod, ' ' filename , calls.assigned_user_id , 'calls' panel_name
FROM calls LEFT JOIN users jt1 ON jt1.id= calls.assigned_user_id AND jt1.deleted=0 AND jt1.deleted=0
INNER JOIN calls_contacts ON (calls.id=calls_contacts.call_id AND calls_contacts.contact_id= 'dfee0e7e-c044-d67d-e018-464c630c23f7')
where ( calls_contacts.deleted=0 AND calls.deleted=0 AND (calls.status='Held' OR calls.status='Not Held')) AND calls.deleted=0 )
UNION ALL
( SELECT notes.id , notes.name , ' ' status , contacts.last_name contact_name , notes.contact_id ,
contacts.assigned_user_id contact_name_owner , 'Contacts' contact_name_mod, notes.date_entered as additional_date ,
notes.date_modified , ' ' assigned_user_name , ' ' assigned_user_owner , ' ' assigned_user_mod , notes.filename , notes.created_by ,
'notes' panel_name
FROM notes LEFT JOIN contacts contacts ON contacts.id= notes.contact_id AND contacts.deleted=0 AND contacts.deleted=0
where ( notes.contact_id= 'dfee0e7e-c044-d67d-e018-464c630c23f7' AND notes.deleted=0) AND notes.deleted=0 )
UNION ALL
( SELECT emails.id , emails.name , emails.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner ,
' ' contact_name_mod , emails.date_modified , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner ,
'Users' assigned_user_name_mod, ' ' filename , emails.assigned_user_id , 'emails' panel_name
FROM emails LEFT JOIN users jt0 ON jt0.id= emails.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0
INNER JOIN emails_beans ON (emails.id=emails_beans.email_id AND emails_beans.bean_id= 'dfee0e7e-c044-d67d-e018-464c630c23f7'
AND bean_module='Contacts') where ( emails_beans.deleted=0 AND emails.deleted=0) AND emails.deleted=0 )
UNION ALL
( SELECT emails.id , emails.name , emails.status , ' ' contact_name , ' ' contact_id , ' ' contact_name_owner ,
' ' contact_name_mod , emails.date_modified , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner ,
'Users' assigned_user_name_mod, ' ' filename , emails.assigned_user_id , 'linkedemails' panel_name
FROM emails LEFT JOIN users jt0 ON jt0.id= emails.assigned_user_id AND jt0.deleted=0 AND jt0.deleted=0
JOIN (select distinct email_id from emails_email_addr_rel eear
join email_addr_bean_rel eabr on eabr.bean_id ='dfee0e7e-c044-d67d-e018-464c630c23f7' and eabr.bean_module = 'Contacts'
and eabr.email_address_id = eear.email_address_id and eabr.deleted=0 where eear.deleted=0
and eear.email_id not in (select eb.email_id from emails_beans eb where eb.bean_module ='Contacts'
and eb.bean_id = 'dfee0e7e-c044-d67d-e018-464c630c23f7' and eb.deleted=0) ) derivedemails on derivedemails.email_id = emails.id
where emails.deleted=0 )
ORDER BY date_modified desc LIMIT 25,25
Bookmarks