Content views give inaccurate results to "regular users"

[rosiel]

Regular users, i.e. non-admin users, may see fewer results in the Content view than there are nodes available. This is likely due to the joins on the node table in the relationships with parents, children, and potentially also media. @aOelschlager found this drupal issue, "node_access filters out accessible nodes when node is left joined", which seems to identify the cause.

In preparation for having a "islandora editor" type role (a "regular user" role), I think it would be prudent to remove the children and parents relationships from the Content table so that it can be relied upon more readily.

p.s. this stinks