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

Brent W

Well-known member
Hi,

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?
 
The following should work:
Code:
select distinct content_id
from xf_permission_entry_content
where xf_permission_entry_content.permission_value = 'reset' and content_type = 'node'
 
Back
Top Bottom