| SQL |
select r.requestId, r.ownerId, r.ownerType, r.requestKey, r.toUserId, r.toEmail, r.toUserType, r.fromUserId, r.fromEmail, r.requestURL, r.handlerTemplatePath, r.requestTime, r.disposition, r.config, r.requestTitle, r.requestSubject, r.response, r.responseTime, r.requestTrackingCode, r.sendCount, r.requestSent, r.requestHTML, r.responseDueDate, r.sendDispositionNotification, r.ttlDays, rt.userRequestTypeId, rt.requestType, r.requestAnnotation, r.ccEmail
from tbl_WRK_UserRequests r
left outer join tbl_WRK_userRequestTypes rt
on rt.userRequestTypeId = r.userRequestTypeId
where r.ownerId = 4441
and ownerType = 'MFR'
and r.requestKey = 'TUZSNDQ0MV9icmlhbi5tYXp6ZWlAc3Rhcmtpc3QuY29tXzE3NzY0NDkyMzMzNzI=' |