Select GroupID from tpermissions where ContentID= and type= and siteid= and groupid='#arguments.groupid#' Select GroupName, isPublic from tusers where userid in (Select GroupID from tpermissions where ContentID= and type= and siteid=) select tusers.groupname,isPublic from tusers INNER JOIN tpermissions ON (tusers.userid = tpermissions.groupid) where tpermissions.contentid= and tpermissions.siteid= select groupid from tpermissions where contentid='00000000000000000000000000000000000' and siteid= select UserID from tusers where type =1 Delete From tpermissions where contentid= and siteid= Insert Into tpermissions (ContentID,GroupID,Type,siteid) values( , , , ) select contentID from tcontent where siteid='#arguments.data.siteid#' group by contentid Delete From tpermissions where groupid= and siteid= Insert Into tpermissions (ContentID,GroupID,Type,siteid) values( , , , ) SELECT * FROM tcontent WHERE ContentID= and siteid= and active=1 select userid, groupname from tusers where type=1 and groupname <>'Admin' and isPublic=0 and siteid='#application.settingsManager.getSite(arguments.data.siteid).getPrivateUserPoolID()#' order by groupname select userid, groupname from tusers where type=1 and isPublic=1 and siteid='#application.settingsManager.getSite(arguments.data.siteid).getPublicUserPoolID()#' order by groupname select * from tpermissions where contentid= and siteid= and type='module' SELECT tcontent.*, tfiles.fileEXT FROM tcontent LEFT Join tfiles ON (tcontent.fileID=tfiles.fileID) WHERE tcontent.ContentID= and tcontent.active=1 and tcontent.siteid= Delete From tpermissions where contentid= and siteid= Insert Into tpermissions (ContentID,GroupID,Type,siteid) values( , , 'module', )