• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 Select all node ids where the registered usergroup permission is set to revoke

Brent W

Well-known member

Can someone scrounge up a query for me that will let me select the node id of all forum nodes where the permission for the usergroup Registered is set to revoke for View Node?


Well-known member
The following should work:
select distinct content_id
from xf_permission_entry_content
where xf_permission_entry_content.permission_value = 'reset' and content_type = 'node'