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

[Brent W]

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?

 

[Xon]

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'