Add a NOT IN condition and a nested query to your views WHERE condition
PROBLEM:
I needed to add a NOT IN condition with a nested query for the WHERE condition. The usual method wont work
$view->query->where[1]['conditions'][] = array(
['field'] => 'groups_group_membership.type'
['value'] => array
(
[0] => 'SELECT_QUERY_HERE'
)['operator'] => IN
);
SOLUTION :
The way that works