// order by is handled in group_concat
$fieldCriteria->
resetSorting();
$query->
select([ 'LOWER(HEX(' .
$root . '.' .
$localColumn . ')) as `key`',
'GROUP_CONCAT(LOWER(HEX(' .
$root . '.' .
$referenceColumn . ')) ' .
$orderBy . ') as `value`',
]);
$query->
addGroupBy($root . '.' .
$localColumn);
if ($fieldCriteria->
getLimit() !== null
) { $limitQuery =
$this->
buildManyToManyLimitQuery($association);
$params =
[ '#source_column#' => EntityDefinitionQueryHelper::
escape($association->
getMappingLocalColumn()),
'#reference_column#' => EntityDefinitionQueryHelper::
escape($association->
getMappingReferenceColumn()),
'#table#' =>
$root,
];
$query->
innerJoin( $root,
'(' .
$limitQuery . ')',
'counter_table',
str_replace(