protected static function buildWhereForRelatedAttributeThatIsItselfAHasManyRelation(RedBeanModelAttributeToDataProviderAdapter $modelAttributeToDataProviderAdapter, $joinTablesAdapter, $relationAttributeTableAliasName, $operatorType, $value, &$where, $whereKey)
 {
     assert('$joinTablesAdapter instanceof RedBeanModelJoinTablesQueryAdapter');
     assert('is_string($relationAttributeTableAliasName)');
     assert('is_string($operatorType)');
     assert('is_array($value) && count($value) > 0');
     assert('is_array($where)');
     assert('is_int($whereKey)');
     $relationAttributeName = $modelAttributeToDataProviderAdapter->getRelatedAttribute();
     $relationAttributeModelClassName = $modelAttributeToDataProviderAdapter->getRelatedAttributeRelationModelClassName();
     if ($relationAttributeModelClassName != 'CustomFieldValue') {
         //Until we can add a third parameter to the search adapter metadata, we have to assume we are only doing
         //this for CustomFieldValue searches. Below we have $joinColumnName, since we don't have any other way
         //of ascertaining this information for now.
         throw new NotSupportedException();
     }
     if ($operatorType != 'oneOf') {
         //only support oneOf for the moment.  Once we add allOf, need to have an alternative sub-query
         //below that uses if/else logic to compare count against how many possibles. then return 1 or 0.
     }
     $relationAttributeTableName = RedBeanModel::getTableName($relationAttributeModelClassName);
     $tableAliasName = $relationAttributeTableName;
     $joinColumnName = 'value';
     $relationColumnName = RedBeanModel::getTableName($modelAttributeToDataProviderAdapter->getRelatedAttributeModelClassName()) . "_id";
     $quote = DatabaseCompatibilityUtil::getQuote();
     $where[$whereKey] = "(1 = (select 1 from {$quote}{$relationAttributeTableName}{$quote} {$tableAliasName} " . "where {$quote}{$tableAliasName}{$quote}.{$quote}{$relationColumnName}{$quote} = " . "{$quote}{$relationAttributeTableAliasName}{$quote}.id " . "and {$quote}{$tableAliasName}{$quote}.{$quote}{$joinColumnName}{$quote} " . DatabaseCompatibilityUtil::getOperatorAndValueWherePart($operatorType, $value) . " limit 1))";
 }