$query->
leftJoin( 'product',
's_articles_avoid_customergroups',
'avoidCustomerGroup',
'avoidCustomerGroup.articleID = product.id
AND avoidCustomerGroup.customerGroupId IN (' .
$key . ')'
);
$query->
setParameter( $key,
$condition->
getCustomerGroupIds(),
Connection::PARAM_INT_ARRAY
);
$query->
andWhere('avoidCustomerGroup.articleID IS NULL'
);
}}