[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'work' => [ 0, ], 'me' => [ 1, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT r0_.id AS id_0, r0_.body AS body_1, r0_.contains_spoilers AS contains_spoilers_2, r0_.is_pinned AS is_pinned_3, r0_.likes_count AS likes_count_4, r0_.comments_count AS comments_count_5, r0_.public_id AS public_id_6, r0_.created_at AS created_at_7, r0_.updated_at AS updated_at_8, r1_.id AS id_9, r1_.score AS score_10, r1_.read_at AS read_at_11, r1_.public_id AS public_id_12, r1_.created_at AS created_at_13, r1_.updated_at AS updated_at_14, u2_.id AS id_15, u2_.email AS email_16, u2_.username AS username_17, u2_.password AS password_18, u2_.display_name AS display_name_19, u2_.bio AS bio_20, u2_.pinned_quote AS pinned_quote_21, u2_.avatar_path AS avatar_path_22, u2_.roles AS roles_23, u2_.email_verified_at AS email_verified_at_24, u2_.last_login_at AS last_login_at_25, u2_.is_active AS is_active_26, u2_.locale AS locale_27, u2_.deleted_at AS deleted_at_28, u2_.onboarded_at AS onboarded_at_29, u2_.public_id AS public_id_30, u2_.created_at AS created_at_31, u2_.updated_at AS updated_at_32, r0_.rating_id AS rating_id_33, r1_.user_id AS user_id_34, r1_.work_id AS work_id_35, r1_.edition_id AS edition_id_36 FROM reviews r0_ INNER JOIN ratings r1_ ON r0_.rating_id = r1_.id INNER JOIN users u2_ ON r1_.user_id = u2_.id WHERE r1_.work_id = ? AND r1_.user_id <> ? AND (r0_.body IS NOT NULL AND r0_.body <> \'\') ORDER BY r0_.created_at DESC', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 'r' => 'App\\Entity\\Review', 'rt' => 'App\\Entity\\Rating', 'u' => 'App\\Entity\\User', ], ], 'relationMap' => [ 2 => [ 'rt' => 'rating', 'u' => 'user', ], ], 'parentAliasMap' => [ 2 => [ 'rt' => 'r', 'u' => 'rt', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'body_1' => 'body', 'contains_spoilers_2' => 'containsSpoilers', 'is_pinned_3' => 'isPinned', 'likes_count_4' => 'likesCount', 'comments_count_5' => 'commentsCount', 'public_id_6' => 'publicId', 'created_at_7' => 'createdAt', 'updated_at_8' => 'updatedAt', 'id_9' => 'id', 'score_10' => 'score', 'read_at_11' => 'readAt', 'public_id_12' => 'publicId', 'created_at_13' => 'createdAt', 'updated_at_14' => 'updatedAt', 'id_15' => 'id', 'email_16' => 'email', 'username_17' => 'username', 'password_18' => 'password', 'display_name_19' => 'displayName', 'bio_20' => 'bio', 'pinned_quote_21' => 'pinnedQuote', 'avatar_path_22' => 'avatarPath', 'roles_23' => 'roles', 'email_verified_at_24' => 'emailVerifiedAt', 'last_login_at_25' => 'lastLoginAt', 'is_active_26' => 'isActive', 'locale_27' => 'locale', 'deleted_at_28' => 'deletedAt', 'onboarded_at_29' => 'onboardedAt', 'public_id_30' => 'publicId', 'created_at_31' => 'createdAt', 'updated_at_32' => 'updatedAt', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\Review' => [ 'r' => [ 'id' => 'id_0', 'body' => 'body_1', 'containsSpoilers' => 'contains_spoilers_2', 'isPinned' => 'is_pinned_3', 'likesCount' => 'likes_count_4', 'commentsCount' => 'comments_count_5', 'publicId' => 'public_id_6', 'createdAt' => 'created_at_7', 'updatedAt' => 'updated_at_8', ], ], 'App\\Entity\\Rating' => [ 'rt' => [ 'id' => 'id_9', 'score' => 'score_10', 'readAt' => 'read_at_11', 'publicId' => 'public_id_12', 'createdAt' => 'created_at_13', 'updatedAt' => 'updated_at_14', ], ], 'App\\Entity\\User' => [ 'u' => [ 'id' => 'id_15', 'email' => 'email_16', 'username' => 'username_17', 'password' => 'password_18', 'displayName' => 'display_name_19', 'bio' => 'bio_20', 'pinnedQuote' => 'pinned_quote_21', 'avatarPath' => 'avatar_path_22', 'roles' => 'roles_23', 'emailVerifiedAt' => 'email_verified_at_24', 'lastLoginAt' => 'last_login_at_25', 'isActive' => 'is_active_26', 'locale' => 'locale_27', 'deletedAt' => 'deleted_at_28', 'onboardedAt' => 'onboarded_at_29', 'publicId' => 'public_id_30', 'createdAt' => 'created_at_31', 'updatedAt' => 'updated_at_32', ], ], ], ], 'typeMappings' => [ 2 => [ 'rating_id_33' => 'bigint', 'user_id_34' => 'bigint', 'work_id_35' => 'bigint', 'edition_id_36' => 'bigint', ], ], 'entityMappings' => [ 2 => [ 'r' => null, ], ], 'metaMappings' => [ 2 => [ 'rating_id_33' => 'rating_id', 'user_id_34' => 'user_id', 'work_id_35' => 'work_id', 'edition_id_36' => 'edition_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 'r', 'body_1' => 'r', 'contains_spoilers_2' => 'r', 'is_pinned_3' => 'r', 'likes_count_4' => 'r', 'comments_count_5' => 'r', 'public_id_6' => 'r', 'created_at_7' => 'r', 'updated_at_8' => 'r', 'id_9' => 'rt', 'score_10' => 'rt', 'read_at_11' => 'rt', 'public_id_12' => 'rt', 'created_at_13' => 'rt', 'updated_at_14' => 'rt', 'id_15' => 'u', 'email_16' => 'u', 'username_17' => 'u', 'password_18' => 'u', 'display_name_19' => 'u', 'bio_20' => 'u', 'pinned_quote_21' => 'u', 'avatar_path_22' => 'u', 'roles_23' => 'u', 'email_verified_at_24' => 'u', 'last_login_at_25' => 'u', 'is_active_26' => 'u', 'locale_27' => 'u', 'deleted_at_28' => 'u', 'onboarded_at_29' => 'u', 'public_id_30' => 'u', 'created_at_31' => 'u', 'updated_at_32' => 'u', 'rating_id_33' => 'r', 'user_id_34' => 'rt', 'work_id_35' => 'rt', 'edition_id_36' => 'rt', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\Review', 'body_1' => 'App\\Entity\\Review', 'contains_spoilers_2' => 'App\\Entity\\Review', 'is_pinned_3' => 'App\\Entity\\Review', 'likes_count_4' => 'App\\Entity\\Review', 'comments_count_5' => 'App\\Entity\\Review', 'public_id_6' => 'App\\Entity\\Review', 'created_at_7' => 'App\\Entity\\Review', 'updated_at_8' => 'App\\Entity\\Review', 'id_9' => 'App\\Entity\\Rating', 'score_10' => 'App\\Entity\\Rating', 'read_at_11' => 'App\\Entity\\Rating', 'public_id_12' => 'App\\Entity\\Rating', 'created_at_13' => 'App\\Entity\\Rating', 'updated_at_14' => 'App\\Entity\\Rating', 'id_15' => 'App\\Entity\\User', 'email_16' => 'App\\Entity\\User', 'username_17' => 'App\\Entity\\User', 'password_18' => 'App\\Entity\\User', 'display_name_19' => 'App\\Entity\\User', 'bio_20' => 'App\\Entity\\User', 'pinned_quote_21' => 'App\\Entity\\User', 'avatar_path_22' => 'App\\Entity\\User', 'roles_23' => 'App\\Entity\\User', 'email_verified_at_24' => 'App\\Entity\\User', 'last_login_at_25' => 'App\\Entity\\User', 'is_active_26' => 'App\\Entity\\User', 'locale_27' => 'App\\Entity\\User', 'deleted_at_28' => 'App\\Entity\\User', 'onboarded_at_29' => 'App\\Entity\\User', 'public_id_30' => 'App\\Entity\\User', 'created_at_31' => 'App\\Entity\\User', 'updated_at_32' => 'App\\Entity\\User', ], ], ], ], $o[0], [] ); } }];