select s.submissionId, s.submissionTime, s.emailId, s.submissionStatus, s.workflowRequestId, s.linkId, s.linkType, m.fspro_userid, m.lastName, m.firstName, m.email, m.ownerId userOwnerId, m.fsl_tablecode userOwnerType from tbl_WRK_FormSubmissions s with (nolock) left outer join tbl_Fspro_members m with (nolock) on m.fspro_userid = s.submitUserId where s.ownerId = and s.ownerType = and s.formId = and s.linkId = and s.linkType = and s.submitUserId > 0 and s.submissionId = select fspro_userId from tbl_EML_CampaignRecipients with (nolock) where recipientId = select recipientId, campaignId, token from tbl_EML_CampaignRecipients with (nolock) where recipientId = select top 1 hyperlink from tbl_EML_CampaignHyperlinks with (nolock) where campaignId = and formId = insert into tbl_EML_RecipientClicks ( recipientId, token, clickDestination, dateTimeClicked, userAgent, ipAddress, ignoreClick, referer ) values ( , , , , , , 'N', ) select stpVersion from fsenablers..tbl_STP_Boot where recordId = 1 #_javascriptHTML#

#_formHTML#