SELECT tusers.UserID, tusers.Email, tusers.GroupName, tusers.Type, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, Count(tusersmemb.UserID) AS Counter, tusers.Perm, tusers.isPublic FROM tusers LEFT JOIN tusersmemb ON tusers.UserID = tusersmemb.GroupID WHERE tusers.Type=1 and tusers.isPublic= and tusers.siteid = '#variables.instance.settingsManager.getSite(arguments.siteid).getPrivateUserPoolID()#' '#variables.instance.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#' GROUP BY tusers.UserID, tusers.Email, tusers.GroupName, tusers.Type, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.perm, tusers.isPublic,tusers.siteid Order by tusers.perm desc, tusers.GroupName Select * from tusers where type=2 and isPublic = and tusers.siteid = '#variables.instance.settingsManager.getSite(arguments.siteid).getPrivateUserPoolID()#' '#variables.instance.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#' and 0=1 and ( lname like or fname like or company like or username like or email like or jobtitle like ) and s2=0 order by lname Select * from tusers inner join tuseraddresses on (tusers.userID=tuseraddresses.userID) where type=2 and isPublic =#arguments.isPublic# and tusers.siteid = '#variables.instance.settingsManager.getSite(arguments.siteid).getPrivateUserPoolID()#' '#variables.instance.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#' and (#param.getRelationship()# #param.getField()# #param.getCondition()# ) and inactive=#arguments.data.inActive# and s2=0 order by lname SELECT tsettings.Site, tusers.UserID, tusers.GroupName FROM tsettings INNER JOIN tusers ON tsettings.SiteID = tusers.SiteID WHERE tusers.Type=1 AND tusers.isPublic=0 and tusers.siteID = '#variables.instance.settingsManager.getSite(arguments.siteid).getPrivateUserPoolID()#' ORDER BY tsettings.Site, tusers.Perm DESC, tusers.GroupName SELECT tsettings.Site, tusers.UserID, tusers.GroupName FROM tsettings INNER JOIN tusers ON tsettings.SiteID = tusers.SiteID WHERE tusers.Type=1 AND tusers.isPublic=1 and tsettings.PublicUserPoolID = '#variables.instance.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#' ORDER BY tsettings.Site, tusers.Perm DESC, tusers.GroupName SELECT Count(*) as theCount FROM tusers WHERE tusers.Type=2 AND tusers.isPublic=1 and siteID = '#variables.instance.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#' and created <= #createODBCDateTime(createDateTime(year(stop),month(stop),day(stop),23,59,0))# and created >= #createODBCDateTime(createDateTime(year(start),month(start),day(start),0,0,0))# SELECT Count(*) as theCount FROM tusers WHERE tusers.Type=2 AND tusers.isPublic=1 and siteID = '#variables.instance.settingsManager.getSite(arguments.siteid).getPublicUserPoolID()#' and inActive=0 SELECT Count(*) as theCount FROM tusers WHERE tusers.Type=2 AND tusers.isPublic=0 and siteID = '#variables.instance.settingsManager.getSite(arguments.siteid).getPrivateUserPoolID()#' and inActive=0