[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.logo AS logo_2, t0_.slogan AS slogan_3, t0_.vendee AS vendee_4, t0_.created_at AS created_at_5, t0_.interview_published_at AS interview_published_at_6, t0_.interview_enabled AS interview_enabled_7, t0_.interview_enabled_at AS interview_enabled_at_8, c1_.id AS id_9, c1_.nom AS nom_10, c1_.drapeau AS drapeau_11, c1_.groupe AS groupe_12, t2_.id AS id_13, t2_.nickname AS nickname_14, t2_.joined_at AS joined_at_15, u3_.id AS id_16, u3_.email AS email_17, u3_.roles AS roles_18, u3_.password AS password_19, u3_.avatar AS avatar_20, u3_.cotisation_payee AS cotisation_payee_21, u3_.notification_preferences AS notification_preferences_22, u3_.forum_last_read_at AS forum_last_read_at_23, t0_.favorite_country_id AS favorite_country_id_24, t0_.interview_published_by_id AS interview_published_by_id_25, t2_.team_id AS team_id_26, t2_.player_id AS player_id_27, u3_.buteur_choisi_id AS buteur_choisi_id_28 FROM team t0_ LEFT JOIN country c1_ ON t0_.favorite_country_id = c1_.id LEFT JOIN team_member t2_ ON t0_.id = t2_.team_id LEFT JOIN `user` u3_ ON t2_.player_id = u3_.id WHERE t0_.interview_published_at IS NOT NULL ORDER BY t0_.interview_published_at DESC, t0_.name ASC, t0_.id ASC, t2_.joined_at ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 't' => 'App\\Entity\\Team', 'fc' => 'App\\Entity\\Country', 'm' => 'App\\Entity\\TeamMember', 'p' => 'App\\Entity\\User', ], ], 'relationMap' => [ 2 => [ 'fc' => 'favoriteCountry', 'm' => 'members', 'p' => 'player', ], ], 'parentAliasMap' => [ 2 => [ 'fc' => 't', 'm' => 't', 'p' => 'm', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'name_1' => 'name', 'logo_2' => 'logo', 'slogan_3' => 'slogan', 'vendee_4' => 'vendee', 'created_at_5' => 'createdAt', 'interview_published_at_6' => 'interviewPublishedAt', 'interview_enabled_7' => 'interviewEnabled', 'interview_enabled_at_8' => 'interviewEnabledAt', 'id_9' => 'id', 'nom_10' => 'nom', 'drapeau_11' => 'drapeau', 'groupe_12' => 'groupe', 'id_13' => 'id', 'nickname_14' => 'nickname', 'joined_at_15' => 'joinedAt', 'id_16' => 'id', 'email_17' => 'email', 'roles_18' => 'roles', 'password_19' => 'password', 'avatar_20' => 'avatar', 'cotisation_payee_21' => 'cotisationPayee', 'notification_preferences_22' => 'notificationPreferences', 'forum_last_read_at_23' => 'forumLastReadAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Team' => [ 't' => [ 'id' => 'id_0', 'name' => 'name_1', 'logo' => 'logo_2', 'slogan' => 'slogan_3', 'vendee' => 'vendee_4', 'createdAt' => 'created_at_5', 'interviewPublishedAt' => 'interview_published_at_6', 'interviewEnabled' => 'interview_enabled_7', 'interviewEnabledAt' => 'interview_enabled_at_8', ], ], 'App\\Entity\\Country' => [ 'fc' => [ 'id' => 'id_9', 'nom' => 'nom_10', 'drapeau' => 'drapeau_11', 'groupe' => 'groupe_12', ], ], 'App\\Entity\\TeamMember' => [ 'm' => [ 'id' => 'id_13', 'nickname' => 'nickname_14', 'joinedAt' => 'joined_at_15', ], ], 'App\\Entity\\User' => [ 'p' => [ 'id' => 'id_16', 'email' => 'email_17', 'roles' => 'roles_18', 'password' => 'password_19', 'avatar' => 'avatar_20', 'cotisationPayee' => 'cotisation_payee_21', 'notificationPreferences' => 'notification_preferences_22', 'forumLastReadAt' => 'forum_last_read_at_23', ], ], ], ], 'typeMappings' => [ 2 => [ 'favorite_country_id_24' => 'integer', 'interview_published_by_id_25' => 'integer', 'team_id_26' => 'integer', 'player_id_27' => 'integer', 'buteur_choisi_id_28' => 'integer', ], ], 'entityMappings' => [ 2 => [ 't' => null, ], ], 'metaMappings' => [ 2 => [ 'favorite_country_id_24' => 'favorite_country_id', 'interview_published_by_id_25' => 'interview_published_by_id', 'team_id_26' => 'team_id', 'player_id_27' => 'player_id', 'buteur_choisi_id_28' => 'buteur_choisi_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 't', 'name_1' => 't', 'logo_2' => 't', 'slogan_3' => 't', 'vendee_4' => 't', 'created_at_5' => 't', 'interview_published_at_6' => 't', 'interview_enabled_7' => 't', 'interview_enabled_at_8' => 't', 'id_9' => 'fc', 'nom_10' => 'fc', 'drapeau_11' => 'fc', 'groupe_12' => 'fc', 'id_13' => 'm', 'nickname_14' => 'm', 'joined_at_15' => 'm', 'id_16' => 'p', 'email_17' => 'p', 'roles_18' => 'p', 'password_19' => 'p', 'avatar_20' => 'p', 'cotisation_payee_21' => 'p', 'notification_preferences_22' => 'p', 'forum_last_read_at_23' => 'p', 'favorite_country_id_24' => 't', 'interview_published_by_id_25' => 't', 'team_id_26' => 'm', 'player_id_27' => 'm', 'buteur_choisi_id_28' => 'p', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Team', 'name_1' => 'App\\Entity\\Team', 'logo_2' => 'App\\Entity\\Team', 'slogan_3' => 'App\\Entity\\Team', 'vendee_4' => 'App\\Entity\\Team', 'created_at_5' => 'App\\Entity\\Team', 'interview_published_at_6' => 'App\\Entity\\Team', 'interview_enabled_7' => 'App\\Entity\\Team', 'interview_enabled_at_8' => 'App\\Entity\\Team', 'id_9' => 'App\\Entity\\Country', 'nom_10' => 'App\\Entity\\Country', 'drapeau_11' => 'App\\Entity\\Country', 'groupe_12' => 'App\\Entity\\Country', 'id_13' => 'App\\Entity\\TeamMember', 'nickname_14' => 'App\\Entity\\TeamMember', 'joined_at_15' => 'App\\Entity\\TeamMember', 'id_16' => 'App\\Entity\\User', 'email_17' => 'App\\Entity\\User', 'roles_18' => 'App\\Entity\\User', 'password_19' => 'App\\Entity\\User', 'avatar_20' => 'App\\Entity\\User', 'cotisation_payee_21' => 'App\\Entity\\User', 'notification_preferences_22' => 'App\\Entity\\User', 'forum_last_read_at_23' => 'App\\Entity\\User', ], ], ], ], $o[0], [] ); } }];