[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT f0_.id AS id_0, f0_.content AS content_1, f0_.created_at AS created_at_2, f0_.updated_at AS updated_at_3, f1_.id AS id_4, f1_.content AS content_5, f1_.created_at AS created_at_6, f1_.updated_at AS updated_at_7, u2_.id AS id_8, u2_.email AS email_9, u2_.roles AS roles_10, u2_.password AS password_11, u2_.avatar AS avatar_12, u2_.cotisation_payee AS cotisation_payee_13, u2_.notification_preferences AS notification_preferences_14, u2_.forum_last_read_at AS forum_last_read_at_15, e3_.id AS id_16, e3_.first_name AS first_name_17, e3_.last_name AS last_name_18, e3_.country AS country_19, e3_.avatar AS avatar_20, u4_.id AS id_21, u4_.email AS email_22, u4_.roles AS roles_23, u4_.password AS password_24, u4_.avatar AS avatar_25, u4_.cotisation_payee AS cotisation_payee_26, u4_.notification_preferences AS notification_preferences_27, u4_.forum_last_read_at AS forum_last_read_at_28, e5_.id AS id_29, e5_.first_name AS first_name_30, e5_.last_name AS last_name_31, e5_.country AS country_32, e5_.avatar AS avatar_33, f0_.author_id AS author_id_34, f0_.display_persona_id AS display_persona_id_35, f0_.parent_id AS parent_id_36, f1_.author_id AS author_id_37, f1_.display_persona_id AS display_persona_id_38, f1_.parent_id AS parent_id_39, u2_.buteur_choisi_id AS buteur_choisi_id_40, u4_.buteur_choisi_id AS buteur_choisi_id_41 FROM forum_post f0_ LEFT JOIN forum_post f1_ ON f0_.id = f1_.parent_id LEFT JOIN `user` u2_ ON f0_.author_id = u2_.id LEFT JOIN editorial_author e3_ ON f0_.display_persona_id = e3_.id LEFT JOIN `user` u4_ ON f1_.author_id = u4_.id LEFT JOIN editorial_author e5_ ON f1_.display_persona_id = e5_.id WHERE f0_.parent_id IS NULL ORDER BY f0_.created_at DESC, f1_.created_at ASC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'p' => 'App\\Entity\\ForumPost', 'r' => 'App\\Entity\\ForumPost', 'a' => 'App\\Entity\\User', 'dp' => 'App\\Entity\\EditorialAuthor', 'ra' => 'App\\Entity\\User', 'rdp' => 'App\\Entity\\EditorialAuthor', ], ], 'relationMap' => [ 2 => [ 'r' => 'replies', 'a' => 'author', 'dp' => 'displayPersona', 'ra' => 'author', 'rdp' => 'displayPersona', ], ], 'parentAliasMap' => [ 2 => [ 'r' => 'p', 'a' => 'p', 'dp' => 'p', 'ra' => 'r', 'rdp' => 'r', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'content_1' => 'content', 'created_at_2' => 'createdAt', 'updated_at_3' => 'updatedAt', 'id_4' => 'id', 'content_5' => 'content', 'created_at_6' => 'createdAt', 'updated_at_7' => 'updatedAt', 'id_8' => 'id', 'email_9' => 'email', 'roles_10' => 'roles', 'password_11' => 'password', 'avatar_12' => 'avatar', 'cotisation_payee_13' => 'cotisationPayee', 'notification_preferences_14' => 'notificationPreferences', 'forum_last_read_at_15' => 'forumLastReadAt', 'id_16' => 'id', 'first_name_17' => 'firstName', 'last_name_18' => 'lastName', 'country_19' => 'country', 'avatar_20' => 'avatar', 'id_21' => 'id', 'email_22' => 'email', 'roles_23' => 'roles', 'password_24' => 'password', 'avatar_25' => 'avatar', 'cotisation_payee_26' => 'cotisationPayee', 'notification_preferences_27' => 'notificationPreferences', 'forum_last_read_at_28' => 'forumLastReadAt', 'id_29' => 'id', 'first_name_30' => 'firstName', 'last_name_31' => 'lastName', 'country_32' => 'country', 'avatar_33' => 'avatar', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\ForumPost' => [ 'p' => [ 'id' => 'id_0', 'content' => 'content_1', 'createdAt' => 'created_at_2', 'updatedAt' => 'updated_at_3', ], 'r' => [ 'id' => 'id_4', 'content' => 'content_5', 'createdAt' => 'created_at_6', 'updatedAt' => 'updated_at_7', ], ], 'App\\Entity\\User' => [ 'a' => [ 'id' => 'id_8', 'email' => 'email_9', 'roles' => 'roles_10', 'password' => 'password_11', 'avatar' => 'avatar_12', 'cotisationPayee' => 'cotisation_payee_13', 'notificationPreferences' => 'notification_preferences_14', 'forumLastReadAt' => 'forum_last_read_at_15', ], 'ra' => [ 'id' => 'id_21', 'email' => 'email_22', 'roles' => 'roles_23', 'password' => 'password_24', 'avatar' => 'avatar_25', 'cotisationPayee' => 'cotisation_payee_26', 'notificationPreferences' => 'notification_preferences_27', 'forumLastReadAt' => 'forum_last_read_at_28', ], ], 'App\\Entity\\EditorialAuthor' => [ 'dp' => [ 'id' => 'id_16', 'firstName' => 'first_name_17', 'lastName' => 'last_name_18', 'country' => 'country_19', 'avatar' => 'avatar_20', ], 'rdp' => [ 'id' => 'id_29', 'firstName' => 'first_name_30', 'lastName' => 'last_name_31', 'country' => 'country_32', 'avatar' => 'avatar_33', ], ], ], ], 'typeMappings' => [ 2 => [ 'author_id_34' => 'integer', 'display_persona_id_35' => 'integer', 'parent_id_36' => 'integer', 'author_id_37' => 'integer', 'display_persona_id_38' => 'integer', 'parent_id_39' => 'integer', 'buteur_choisi_id_40' => 'integer', 'buteur_choisi_id_41' => 'integer', ], ], 'entityMappings' => [ 2 => [ 'p' => null, ], ], 'metaMappings' => [ 2 => [ 'author_id_34' => 'author_id', 'display_persona_id_35' => 'display_persona_id', 'parent_id_36' => 'parent_id', 'author_id_37' => 'author_id', 'display_persona_id_38' => 'display_persona_id', 'parent_id_39' => 'parent_id', 'buteur_choisi_id_40' => 'buteur_choisi_id', 'buteur_choisi_id_41' => 'buteur_choisi_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'p', 'content_1' => 'p', 'created_at_2' => 'p', 'updated_at_3' => 'p', 'id_4' => 'r', 'content_5' => 'r', 'created_at_6' => 'r', 'updated_at_7' => 'r', 'id_8' => 'a', 'email_9' => 'a', 'roles_10' => 'a', 'password_11' => 'a', 'avatar_12' => 'a', 'cotisation_payee_13' => 'a', 'notification_preferences_14' => 'a', 'forum_last_read_at_15' => 'a', 'id_16' => 'dp', 'first_name_17' => 'dp', 'last_name_18' => 'dp', 'country_19' => 'dp', 'avatar_20' => 'dp', 'id_21' => 'ra', 'email_22' => 'ra', 'roles_23' => 'ra', 'password_24' => 'ra', 'avatar_25' => 'ra', 'cotisation_payee_26' => 'ra', 'notification_preferences_27' => 'ra', 'forum_last_read_at_28' => 'ra', 'id_29' => 'rdp', 'first_name_30' => 'rdp', 'last_name_31' => 'rdp', 'country_32' => 'rdp', 'avatar_33' => 'rdp', 'author_id_34' => 'p', 'display_persona_id_35' => 'p', 'parent_id_36' => 'p', 'author_id_37' => 'r', 'display_persona_id_38' => 'r', 'parent_id_39' => 'r', 'buteur_choisi_id_40' => 'a', 'buteur_choisi_id_41' => 'ra', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\ForumPost', 'content_1' => 'App\\Entity\\ForumPost', 'created_at_2' => 'App\\Entity\\ForumPost', 'updated_at_3' => 'App\\Entity\\ForumPost', 'id_4' => 'App\\Entity\\ForumPost', 'content_5' => 'App\\Entity\\ForumPost', 'created_at_6' => 'App\\Entity\\ForumPost', 'updated_at_7' => 'App\\Entity\\ForumPost', 'id_8' => 'App\\Entity\\User', 'email_9' => 'App\\Entity\\User', 'roles_10' => 'App\\Entity\\User', 'password_11' => 'App\\Entity\\User', 'avatar_12' => 'App\\Entity\\User', 'cotisation_payee_13' => 'App\\Entity\\User', 'notification_preferences_14' => 'App\\Entity\\User', 'forum_last_read_at_15' => 'App\\Entity\\User', 'id_16' => 'App\\Entity\\EditorialAuthor', 'first_name_17' => 'App\\Entity\\EditorialAuthor', 'last_name_18' => 'App\\Entity\\EditorialAuthor', 'country_19' => 'App\\Entity\\EditorialAuthor', 'avatar_20' => 'App\\Entity\\EditorialAuthor', 'id_21' => 'App\\Entity\\User', 'email_22' => 'App\\Entity\\User', 'roles_23' => 'App\\Entity\\User', 'password_24' => 'App\\Entity\\User', 'avatar_25' => 'App\\Entity\\User', 'cotisation_payee_26' => 'App\\Entity\\User', 'notification_preferences_27' => 'App\\Entity\\User', 'forum_last_read_at_28' => 'App\\Entity\\User', 'id_29' => 'App\\Entity\\EditorialAuthor', 'first_name_30' => 'App\\Entity\\EditorialAuthor', 'last_name_31' => 'App\\Entity\\EditorialAuthor', 'country_32' => 'App\\Entity\\EditorialAuthor', 'avatar_33' => 'App\\Entity\\EditorialAuthor', ], ], ], ], $o[0], [] ); } }];