select e.emailId, e.emailSubject, e.emailDate from tbl_WRK_Emails e where e.emailTo like and ( ( e.ownerId = and e.ownerType = ) or ( e.ownerType = 'BRO' and exists ( select * from tbl_SMA_BrokerOfficeLink sma where sma.mfr_id = and sma.brokerid = e.ownerId) ) or ( e.ownerType = 'MFR' and exists ( select * from tbl_SMA_BrokerOfficeLink sma where sma.mfr_id = e.ownerId and sma.brokerid = ) ) ) and (( emailSubject like ) or ( emailBody like )) select cast( emailId as bigint ) emailId, emailSubject, emailDate timeSubmitted, 0 campaignId from qmd_workflowEmails union select 0 emailId, emailSubject, timeSubmitted, cast( campaignId as bigint ) campaignId from qmd_getRecd_EmailCampaigns order by timeSubmitted desc

Search Options:

»» Search results for "#htmleditformat( url.kywrd )#".

Subject	Date
#htmleditformat(qmd_getRecd_EmailCampaigns.EmailSubject)#	#dateformat(qmd_getRecd_EmailCampaigns.TimeSubmitted,"mmm dd")#

There are currently no email messages in your archives.