Sql rewrite causing Duplicate entitiy entries in views

Problem/Motivation

When an entity is attached to multiple groups with group access limiting the view of that entity any view that displays that entity type will have duplicate rows for that specific entity.

You can see this even in the core drupal admin content page if for example you have two groups that both have the same page attached to them. Make sure that the access to view the page is limited by the group so that the additional sql is added by the group module

Steps to reproduce

Create a group type and make two groups
attach the basic page to the group
Limit view access to pages that are in a group to members of the group
Attach the "same" page to multiple groups
look in the admin content view and that page will show up multiple times

Proposed resolution

The cause is the additional sql queries added to check for view access in the group sql rewrite

Remaining tasks

User interface changes

API changes

Data model changes