/** * @api * * @param \Propel\Runtime\ActiveQuery\ModelCriteria $expandableQuery * @param string $relationTableAlias * @param string $fieldIdentifier * * @return \Propel\Runtime\ActiveQuery\ModelCriteria */ public function joinLocalizedRelatedCategoryQueryWithAttributes(ModelCriteria $expandableQuery, $relationTableAlias, $fieldIdentifier) { $expandableQuery->addJoinObject((new Join($relationTableAlias . '.fk_category', SpyCategoryAttributeTableMap::COL_FK_CATEGORY, Criteria::LEFT_JOIN))->setRightTableAlias($relationTableAlias . 'Attributes'), $relationTableAlias . 'AttributesJoin'); $expandableQuery->addCond($relationTableAlias . 'AttributesJoin', SpyCategoryAttributeTableMap::COL_FK_LOCALE . '=' . SpyLocaleTableMap::COL_ID_LOCALE); $expandableQuery->withColumn('GROUP_CONCAT(' . $relationTableAlias . 'Attributes.name)', 'category_' . $fieldIdentifier . '_names'); return $expandableQuery; }