select notification.notificationid, notify_workorder.workorderid, notification.notificationtitle, notificationtodescription.notificationdescription from notification left join notificationtodescription on notification.notificationid = notificationtodescription.notificationid left join notify_workorder on notificationtodescription.notificationid=notify_workorder.notificationid


select conversation.conversationid, conversation.workorderid, conversation.title, conversationdescription.description from conversation left join conversationdescription on conversation.conversationid=conversationdescription.conversationid