select filename from tcontent where siteid='#arguments.siteid#' and active =1 and ((display=1) or (display=2 and tcontent.DisplayStart <= #createodbcdate(now())# AND tcontent.DisplayStop >= #createodbcdate(now())#)) and contenthistid in (select contenthistid from tcontentobjects where object='mailing_list_master') #mailingListConfirmScript# You've requested to be signed up for the mailing list: #listName# If this is correct, please verify your email address by entering the following url into your browser window: #returnURL# Please contact #contactEmail# if you have any questions or comments on this process. Thank you, The #contactName# staff update tmailinglistmembers set isVerified = 1 where email = '#data.email#' and mlid = '#data.mlid#' and siteid = '#data.siteid#'