Select EmailID from temails where deliverydate <=#createodbcdatetime(now())# and status = 0 and deliverydate is not null and isDeleted = 0 update temails set status = 99 where emailid = update temails set status = 99 where emailid = select temails.*, tsettings.* from temails inner join tsettings on (temails.siteid=tsettings.siteid) where emailid= select filename from tcontent where 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') select filename from tcontent where 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='forward_email') ' ]+@[^@%*<>' ]{2,255}\.[^@%*<>' ]{2,5}", trim(rsAddresses.email)) neq 0 and prevEmail neq rsAddresses.email> update temails set status=1, NumberSent=#counter#+numbersent where emailid= update temails set status=1, NumberSent=#counter# where emailid= select temails.*, tsettings.* from temails inner join tsettings on (temails.siteid=tsettings.siteid) where emailid= select filename from tcontent where 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') select filename from tcontent where 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='forward_email') ' ]+@[^@%*<>' ]{2,255}\.[^@%*<>' ]{2,5}", trim(t)) neq 0> update temails set status=1, NumberSent=#listlen(arguments.data.to)#+numbersent where emailid= update temails set status=1, NumberSent=#listlen(arguments.data.to)# where emailid= update temailstats set #arguments.type# = 1 where emailid = and email = insert into temailreturnstats (emailid, email, url, created) VALUES (, , , #createodbcdatetime(now())#) Insert Into temailstats (emailid,email,created,#arguments.type#) values(,,#createodbcdatetime(now())#,1) SELECT DISTINCT tusers.Email, tusers.fname, tusers.lname, tusers.company FROM tusersmemb INNER JOIN tusers ON tusersmemb.UserID = tusers.UserID WHERE tusersmemb.GroupID IN ( , ) AND tusers.InActive = 0 AND tusers.subscribe = 1 Union SELECT DISTINCT tusers.Email, tusers.fname, tusers.lname, tusers.company FROM tusersinterests INNER JOIN tusers ON tusersinterests.UserID = tusers.UserID INNER JOIN tcontentcategories ON (tusersinterests.categoryID=tcontentcategories.categoryID) WHERE ( tcontentcategories.Path like or ) AND tusers.InActive = 0 AND tusers.subscribe = 1 Union SELECT DISTINCT tmailinglistmembers.Email, tmailinglistmembers.fname, tmailinglistmembers.lname, tmailinglistmembers.company FROM tmailinglistmembers INNER JOIN tmailinglist ON(tmailinglistmembers.mlid=tmailinglist.mlid) WHERE tmailinglistmembers.mlid IN ( ,) and tmailinglist.siteid= and tmailinglistmembers.isVerified = 1 select tmailinglistmembers.email from tmailinglistmembers INNER JOIN tmailinglist ON (tmailinglistmembers.mlid=tmailinglist.mlid) WHERE tmailinglist.ispurge=1 and tmailinglist.siteid= union select email from tusers where ( siteid='#variables.instance.settingsManager.getSite(arguments.siteID).getPublicUserPoolID()#' or siteid='#variables.instance.settingsManager.getSite(arguments.siteID).getPrivateUserPoolID()#' ) and subscribe=0 select distinct email, fname, lname, company from rsAddressesPre where email not in ('',) ]*>">