select userid, groupname, ispublic from tusers where type =1 and ispublic=0 and userid in (select groupid from tpermissions where contentid='00000000000000000000000000000000000' and siteid='#application.settingsManager.getSite(arguments.siteid).getPrivateUserPoolID()#') order by groupname select * from tusers where ispublic=1 and type=1 and siteid='#application.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#' order by groupname select * from tmailinglist where ispurge=0 and siteid= order by name select temails.emailid, subject, status, createddate, deliverydate, lastupdatebyid, numbersent from temails where siteid= and (or grouplist like ) and 0=1 and temails.status = and temails.subject like and isDeleted = 0 ORDER BY #session.emaillist.orderBy# #session.emaillist.direction# select count(#arguments.type#) as stat from temailstats where emailid = and #arguments.type# = 1 select distinct(url)from temailreturnstats where emailid = select count(emailID) as stat from temailreturnstats where emailid = SELECT count(email) as bounceCount, email from temailstats where emailid = and bounce = 1 group by email order by bounceCount desc SELECT count(email) as bounceCount, email from temails inner join temailstats on temails.emailid = temailstats.emailid where temails.siteid = and temailstats.bounce = 1 group by email having (bounceCount >= #int(arguments.data.bounceFilter)#) order by bounceCount desc SELECT count(url) as returnCount, url from temailreturnstats where emailid = group by url order by returnCount desc SELECT distinct(email) from temailreturnstats where emailid = SELECT COUNT(temails.EmailID) AS emailCount FROM temails INNER JOIN temailstats ON temails.EmailID = temailstats.EmailID WHERE (temails.siteid = '#arguments.siteid#') and temailstats.created <= #createODBCDateTime(createDateTime(year(arguments.stopDate),month(arguments.stopDate),day(arguments.stopDate),23,59,0))# and temailstats.created >= #createODBCDateTime(createDateTime(year(arguments.startDate),month(arguments.startDate),day(arguments.startDate),0,0,0))# DELETE FROM tmailinglistmembers WHERE email IN () select * from ( select Top #arguments.limit# temails.emailid, subject, status, createddate, deliverydate, lastupdatebyid, numbersent from temails where siteid= and isDeleted=0 and deliveryDate >= #createodbcdatetime(createdatetime(year(start),month(start),day(start),0,0,0))# and deliveryDate >= #createodbcdatetime(createdatetime(year(arguments.startDate),month(arguments.startDate),day(arguments.startDate),0,0,0))# and deliveryDate <= #createodbcdatetime(createdatetime(year(stop),month(stop),day(stop),23,59,0))# and deliveryDate <= #createodbcdatetime(createdatetime(year(arguments.stopDate),month(arguments.stopDate),day(arguments.stopDate),23,59,0))# order by deliveryDate desc limit #arguments.limit# ) where ROWNUM <=#arguments.limit#