Fetching nodes with eZContentObjectTreeNode::subTreeByNodeID on a site with a policy with *Group (self )* takes a long time to execute when there is a large number of users within the user's group.

The query resulting from createPermissionCheckingSQL could be enhanced to perform better in this scenario.

Steps to reproduce

• Create a large number of users within group //Members//
• Create a policy that includes a test for *Group ( self )*
• Create a view that executes eZContentObjectTreeNode::subTreeByNodeID so that you can call it from the admin interface logged in as a member
• Check how much it takes for the fetch function to produce results.