[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'grupo' => [ 0, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT c0_.id AS id_0, c0_.fecha_agregado AS fecha_agregado_1, u1_.id AS id_2, u1_.nombre AS nombre_3, u1_.email AS email_4, u1_.password AS password_5, u1_.usuario_bgg AS usuario_bgg_6, u1_.avatar AS avatar_7, u1_.fecha_registro AS fecha_registro_8, u1_.activo AS activo_9, u1_.roles AS roles_10, u1_.username_tag AS username_tag_11, u1_.banned_at AS banned_at_12, u1_.ban_reason AS ban_reason_13, u1_.totp_secret AS totp_secret_14, j2_.id AS id_15, j2_.bgg_id AS bgg_id_16, j2_.nombre AS nombre_17, j2_.imagen_url AS imagen_url_18, j2_.min_jugadores AS min_jugadores_19, j2_.max_jugadores AS max_jugadores_20, j2_.puntuacion_bgg AS puntuacion_bgg_21, j2_.ano_publicacion AS ano_publicacion_22, j2_.playing_time AS playing_time_23, j2_.min_age AS min_age_24, j2_.avg_weight AS avg_weight_25, j2_.designers AS designers_26, j2_.is_expansion AS is_expansion_27, j2_.bgg_cache_json AS bgg_cache_json_28, j2_.bgg_cache_updated_at AS bgg_cache_updated_at_29, j2_.ultima_actualizacion AS ultima_actualizacion_30, c0_.usuario_id AS usuario_id_31, c0_.juego_id AS juego_id_32 FROM colecciones c0_ INNER JOIN usuarios u1_ ON c0_.usuario_id = u1_.id INNER JOIN juegos j2_ ON c0_.juego_id = j2_.id INNER JOIN grupo_miembros g3_ ON u1_.id = g3_.usuario_id WHERE g3_.grupo_id = ? ORDER BY j2_.nombre ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'c' => 'App\\Entity\\Coleccion', 'u' => 'App\\Entity\\Usuario', 'j' => 'App\\Entity\\Juego', ], ], 'relationMap' => [ 2 => [ 'u' => 'usuario', 'j' => 'juego', ], ], 'parentAliasMap' => [ 2 => [ 'u' => 'c', 'j' => 'c', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'fecha_agregado_1' => 'fechaAgregado', 'id_2' => 'id', 'nombre_3' => 'nombre', 'email_4' => 'email', 'password_5' => 'password', 'usuario_bgg_6' => 'usuarioBgg', 'avatar_7' => 'avatar', 'fecha_registro_8' => 'fechaRegistro', 'activo_9' => 'activo', 'roles_10' => 'roles', 'username_tag_11' => 'usernameTag', 'banned_at_12' => 'bannedAt', 'ban_reason_13' => 'banReason', 'totp_secret_14' => 'totpSecret', 'id_15' => 'id', 'bgg_id_16' => 'bggId', 'nombre_17' => 'nombre', 'imagen_url_18' => 'imagenUrl', 'min_jugadores_19' => 'minJugadores', 'max_jugadores_20' => 'maxJugadores', 'puntuacion_bgg_21' => 'puntuacionBgg', 'ano_publicacion_22' => 'anoPublicacion', 'playing_time_23' => 'playingTime', 'min_age_24' => 'minAge', 'avg_weight_25' => 'avgWeight', 'designers_26' => 'designers', 'is_expansion_27' => 'isExpansion', 'bgg_cache_json_28' => 'bggCacheJson', 'bgg_cache_updated_at_29' => 'bggCacheUpdatedAt', 'ultima_actualizacion_30' => 'ultimaActualizacion', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Coleccion' => [ 'c' => [ 'id' => 'id_0', 'fechaAgregado' => 'fecha_agregado_1', ], ], 'App\\Entity\\Usuario' => [ 'u' => [ 'id' => 'id_2', 'nombre' => 'nombre_3', 'email' => 'email_4', 'password' => 'password_5', 'usuarioBgg' => 'usuario_bgg_6', 'avatar' => 'avatar_7', 'fechaRegistro' => 'fecha_registro_8', 'activo' => 'activo_9', 'roles' => 'roles_10', 'usernameTag' => 'username_tag_11', 'bannedAt' => 'banned_at_12', 'banReason' => 'ban_reason_13', 'totpSecret' => 'totp_secret_14', ], ], 'App\\Entity\\Juego' => [ 'j' => [ 'id' => 'id_15', 'bggId' => 'bgg_id_16', 'nombre' => 'nombre_17', 'imagenUrl' => 'imagen_url_18', 'minJugadores' => 'min_jugadores_19', 'maxJugadores' => 'max_jugadores_20', 'puntuacionBgg' => 'puntuacion_bgg_21', 'anoPublicacion' => 'ano_publicacion_22', 'playingTime' => 'playing_time_23', 'minAge' => 'min_age_24', 'avgWeight' => 'avg_weight_25', 'designers' => 'designers_26', 'isExpansion' => 'is_expansion_27', 'bggCacheJson' => 'bgg_cache_json_28', 'bggCacheUpdatedAt' => 'bgg_cache_updated_at_29', 'ultimaActualizacion' => 'ultima_actualizacion_30', ], ], ], ], 'typeMappings' => [ 2 => [ 'usuario_id_31' => 'integer', 'juego_id_32' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'c' => null, ], ], 'metaMappings' => [ 2 => [ 'usuario_id_31' => 'usuario_id', 'juego_id_32' => 'juego_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'c', 'fecha_agregado_1' => 'c', 'id_2' => 'u', 'nombre_3' => 'u', 'email_4' => 'u', 'password_5' => 'u', 'usuario_bgg_6' => 'u', 'avatar_7' => 'u', 'fecha_registro_8' => 'u', 'activo_9' => 'u', 'roles_10' => 'u', 'username_tag_11' => 'u', 'banned_at_12' => 'u', 'ban_reason_13' => 'u', 'totp_secret_14' => 'u', 'id_15' => 'j', 'bgg_id_16' => 'j', 'nombre_17' => 'j', 'imagen_url_18' => 'j', 'min_jugadores_19' => 'j', 'max_jugadores_20' => 'j', 'puntuacion_bgg_21' => 'j', 'ano_publicacion_22' => 'j', 'playing_time_23' => 'j', 'min_age_24' => 'j', 'avg_weight_25' => 'j', 'designers_26' => 'j', 'is_expansion_27' => 'j', 'bgg_cache_json_28' => 'j', 'bgg_cache_updated_at_29' => 'j', 'ultima_actualizacion_30' => 'j', 'usuario_id_31' => 'c', 'juego_id_32' => 'c', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Coleccion', 'fecha_agregado_1' => 'App\\Entity\\Coleccion', 'id_2' => 'App\\Entity\\Usuario', 'nombre_3' => 'App\\Entity\\Usuario', 'email_4' => 'App\\Entity\\Usuario', 'password_5' => 'App\\Entity\\Usuario', 'usuario_bgg_6' => 'App\\Entity\\Usuario', 'avatar_7' => 'App\\Entity\\Usuario', 'fecha_registro_8' => 'App\\Entity\\Usuario', 'activo_9' => 'App\\Entity\\Usuario', 'roles_10' => 'App\\Entity\\Usuario', 'username_tag_11' => 'App\\Entity\\Usuario', 'banned_at_12' => 'App\\Entity\\Usuario', 'ban_reason_13' => 'App\\Entity\\Usuario', 'totp_secret_14' => 'App\\Entity\\Usuario', 'id_15' => 'App\\Entity\\Juego', 'bgg_id_16' => 'App\\Entity\\Juego', 'nombre_17' => 'App\\Entity\\Juego', 'imagen_url_18' => 'App\\Entity\\Juego', 'min_jugadores_19' => 'App\\Entity\\Juego', 'max_jugadores_20' => 'App\\Entity\\Juego', 'puntuacion_bgg_21' => 'App\\Entity\\Juego', 'ano_publicacion_22' => 'App\\Entity\\Juego', 'playing_time_23' => 'App\\Entity\\Juego', 'min_age_24' => 'App\\Entity\\Juego', 'avg_weight_25' => 'App\\Entity\\Juego', 'designers_26' => 'App\\Entity\\Juego', 'is_expansion_27' => 'App\\Entity\\Juego', 'bgg_cache_json_28' => 'App\\Entity\\Juego', 'bgg_cache_updated_at_29' => 'App\\Entity\\Juego', 'ultima_actualizacion_30' => 'App\\Entity\\Juego', ], ], ], ], $o[0], [] ); } }];