/**
* Implements hook_views_query_alter().
*/
function MYMODULE_views_query_alter(ViewExecutable $view, QueryPluginBase $query) {
// Do not show rows where CID is unique.
if ($view->id() === 'MYVIEW_default') {
$where_clause = 'cid IN (SELECT cid FRO