[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'annual' => [ 0, ], 'status' => [ 1, ], 'elevenMonthsAgo' => [ 2, ], ], ], ], 'Doctrine\\ORM\\Query\\Exec\\SingleSelectSqlFinalizer' => [ 'sql' => [ 1 => 'SELECT u0_.id AS id_0, u0_.billing_cycle AS billing_cycle_1, u0_.status AS status_2, u0_.stripe_customer_id AS stripe_customer_id_3, u0_.stripe_subscription_id AS stripe_subscription_id_4, u0_.last_processed_invoice_id AS last_processed_invoice_id_5, u0_.access_until AS access_until_6, u0_.started_at AS started_at_7, u0_.created_at AS created_at_8, u0_.updated_at AS updated_at_9, u1_.id AS id_10, u1_.uuid AS uuid_11, u1_.email AS email_12, u1_.first_name AS first_name_13, u1_.last_name AS last_name_14, u1_.date_of_birth AS date_of_birth_15, u1_.recruited_at AS recruited_at_16, u1_.referral_code AS referral_code_17, u1_.referral_reward_granted_at AS referral_reward_granted_at_18, u1_.referral_source AS referral_source_19, u1_.referral_source_detail AS referral_source_detail_20, u1_.roles AS roles_21, u1_.password AS password_22, u1_.password_reset_token AS password_reset_token_23, u1_.password_reset_requested_at AS password_reset_requested_at_24, u1_.created_at AS created_at_25, u1_.updated_at AS updated_at_26, u1_.status AS status_27, u1_.email_verification_token AS email_verification_token_28, u1_.email_verification_token_sent_at AS email_verification_token_sent_at_29, u1_.email_verified_at AS email_verified_at_30, u1_.cga_accepted_at AS cga_accepted_at_31, u1_.login_streak AS login_streak_32, u1_.pending_email AS pending_email_33, u1_.pending_email_token AS pending_email_token_34, u1_.pending_email_token_sent_at AS pending_email_token_sent_at_35, u1_.google_id AS google_id_36, u0_.user_id AS user_id_37, u0_.plan_id AS plan_id_38, u0_.pending_plan_id AS pending_plan_id_39, u1_.company_id AS company_id_40, u1_.recruited_by_id AS recruited_by_id_41, u1_.recruited_by_user_id AS recruited_by_user_id_42 FROM user_subscription u0_ INNER JOIN `user` u1_ ON u0_.user_id = u1_.id WHERE u0_.billing_cycle = ? AND u0_.status = ? AND u0_.started_at IS NOT NULL AND u0_.started_at <= ?', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 's' => 'App\\Entity\\UserSubscription', 'u' => 'App\\Entity\\User', ], ], 'relationMap' => [ 2 => [ 'u' => 'user', ], ], 'parentAliasMap' => [ 2 => [ 'u' => 's', ], ], 'fieldMappings' => [ 2 => [ 'id_0' => 'id', 'billing_cycle_1' => 'billingCycle', 'status_2' => 'status', 'stripe_customer_id_3' => 'stripeCustomerId', 'stripe_subscription_id_4' => 'stripeSubscriptionId', 'last_processed_invoice_id_5' => 'lastProcessedInvoiceId', 'access_until_6' => 'accessUntil', 'started_at_7' => 'startedAt', 'created_at_8' => 'createdAt', 'updated_at_9' => 'updatedAt', 'id_10' => 'id', 'uuid_11' => 'uuid', 'email_12' => 'email', 'first_name_13' => 'firstName', 'last_name_14' => 'lastName', 'date_of_birth_15' => 'dateOfBirth', 'recruited_at_16' => 'recruitedAt', 'referral_code_17' => 'referralCode', 'referral_reward_granted_at_18' => 'referralRewardGrantedAt', 'referral_source_19' => 'referralSource', 'referral_source_detail_20' => 'referralSourceDetail', 'roles_21' => 'roles', 'password_22' => 'password', 'password_reset_token_23' => 'passwordResetToken', 'password_reset_requested_at_24' => 'passwordResetRequestedAt', 'created_at_25' => 'createdAt', 'updated_at_26' => 'updatedAt', 'status_27' => 'status', 'email_verification_token_28' => 'emailVerificationToken', 'email_verification_token_sent_at_29' => 'emailVerificationTokenSentAt', 'email_verified_at_30' => 'emailVerifiedAt', 'cga_accepted_at_31' => 'cgaAcceptedAt', 'login_streak_32' => 'loginStreak', 'pending_email_33' => 'pendingEmail', 'pending_email_token_34' => 'pendingEmailToken', 'pending_email_token_sent_at_35' => 'pendingEmailTokenSentAt', 'google_id_36' => 'googleId', ], ], 'columnAliasMappings' => [ 2 => [ 'App\\Entity\\UserSubscription' => [ 's' => [ 'id' => 'id_0', 'billingCycle' => 'billing_cycle_1', 'status' => 'status_2', 'stripeCustomerId' => 'stripe_customer_id_3', 'stripeSubscriptionId' => 'stripe_subscription_id_4', 'lastProcessedInvoiceId' => 'last_processed_invoice_id_5', 'accessUntil' => 'access_until_6', 'startedAt' => 'started_at_7', 'createdAt' => 'created_at_8', 'updatedAt' => 'updated_at_9', ], ], 'App\\Entity\\User' => [ 'u' => [ 'id' => 'id_10', 'uuid' => 'uuid_11', 'email' => 'email_12', 'firstName' => 'first_name_13', 'lastName' => 'last_name_14', 'dateOfBirth' => 'date_of_birth_15', 'recruitedAt' => 'recruited_at_16', 'referralCode' => 'referral_code_17', 'referralRewardGrantedAt' => 'referral_reward_granted_at_18', 'referralSource' => 'referral_source_19', 'referralSourceDetail' => 'referral_source_detail_20', 'roles' => 'roles_21', 'password' => 'password_22', 'passwordResetToken' => 'password_reset_token_23', 'passwordResetRequestedAt' => 'password_reset_requested_at_24', 'createdAt' => 'created_at_25', 'updatedAt' => 'updated_at_26', 'status' => 'status_27', 'emailVerificationToken' => 'email_verification_token_28', 'emailVerificationTokenSentAt' => 'email_verification_token_sent_at_29', 'emailVerifiedAt' => 'email_verified_at_30', 'cgaAcceptedAt' => 'cga_accepted_at_31', 'loginStreak' => 'login_streak_32', 'pendingEmail' => 'pending_email_33', 'pendingEmailToken' => 'pending_email_token_34', 'pendingEmailTokenSentAt' => 'pending_email_token_sent_at_35', 'googleId' => 'google_id_36', ], ], ], ], 'typeMappings' => [ 2 => [ 'user_id_37' => 'integer', 'plan_id_38' => 'integer', 'pending_plan_id_39' => 'integer', 'company_id_40' => 'integer', 'recruited_by_id_41' => 'integer', 'recruited_by_user_id_42' => 'integer', ], ], 'entityMappings' => [ 2 => [ 's' => null, ], ], 'metaMappings' => [ 2 => [ 'user_id_37' => 'user_id', 'plan_id_38' => 'plan_id', 'pending_plan_id_39' => 'pending_plan_id', 'company_id_40' => 'company_id', 'recruited_by_id_41' => 'recruited_by_id', 'recruited_by_user_id_42' => 'recruited_by_user_id', ], ], 'columnOwnerMap' => [ 2 => [ 'id_0' => 's', 'billing_cycle_1' => 's', 'status_2' => 's', 'stripe_customer_id_3' => 's', 'stripe_subscription_id_4' => 's', 'last_processed_invoice_id_5' => 's', 'access_until_6' => 's', 'started_at_7' => 's', 'created_at_8' => 's', 'updated_at_9' => 's', 'id_10' => 'u', 'uuid_11' => 'u', 'email_12' => 'u', 'first_name_13' => 'u', 'last_name_14' => 'u', 'date_of_birth_15' => 'u', 'recruited_at_16' => 'u', 'referral_code_17' => 'u', 'referral_reward_granted_at_18' => 'u', 'referral_source_19' => 'u', 'referral_source_detail_20' => 'u', 'roles_21' => 'u', 'password_22' => 'u', 'password_reset_token_23' => 'u', 'password_reset_requested_at_24' => 'u', 'created_at_25' => 'u', 'updated_at_26' => 'u', 'status_27' => 'u', 'email_verification_token_28' => 'u', 'email_verification_token_sent_at_29' => 'u', 'email_verified_at_30' => 'u', 'cga_accepted_at_31' => 'u', 'login_streak_32' => 'u', 'pending_email_33' => 'u', 'pending_email_token_34' => 'u', 'pending_email_token_sent_at_35' => 'u', 'google_id_36' => 'u', 'user_id_37' => 's', 'plan_id_38' => 's', 'pending_plan_id_39' => 's', 'company_id_40' => 'u', 'recruited_by_id_41' => 'u', 'recruited_by_user_id_42' => 'u', ], ], 'declaringClasses' => [ 2 => [ 'id_0' => 'App\\Entity\\UserSubscription', 'billing_cycle_1' => 'App\\Entity\\UserSubscription', 'status_2' => 'App\\Entity\\UserSubscription', 'stripe_customer_id_3' => 'App\\Entity\\UserSubscription', 'stripe_subscription_id_4' => 'App\\Entity\\UserSubscription', 'last_processed_invoice_id_5' => 'App\\Entity\\UserSubscription', 'access_until_6' => 'App\\Entity\\UserSubscription', 'started_at_7' => 'App\\Entity\\UserSubscription', 'created_at_8' => 'App\\Entity\\UserSubscription', 'updated_at_9' => 'App\\Entity\\UserSubscription', 'id_10' => 'App\\Entity\\User', 'uuid_11' => 'App\\Entity\\User', 'email_12' => 'App\\Entity\\User', 'first_name_13' => 'App\\Entity\\User', 'last_name_14' => 'App\\Entity\\User', 'date_of_birth_15' => 'App\\Entity\\User', 'recruited_at_16' => 'App\\Entity\\User', 'referral_code_17' => 'App\\Entity\\User', 'referral_reward_granted_at_18' => 'App\\Entity\\User', 'referral_source_19' => 'App\\Entity\\User', 'referral_source_detail_20' => 'App\\Entity\\User', 'roles_21' => 'App\\Entity\\User', 'password_22' => 'App\\Entity\\User', 'password_reset_token_23' => 'App\\Entity\\User', 'password_reset_requested_at_24' => 'App\\Entity\\User', 'created_at_25' => 'App\\Entity\\User', 'updated_at_26' => 'App\\Entity\\User', 'status_27' => 'App\\Entity\\User', 'email_verification_token_28' => 'App\\Entity\\User', 'email_verification_token_sent_at_29' => 'App\\Entity\\User', 'email_verified_at_30' => 'App\\Entity\\User', 'cga_accepted_at_31' => 'App\\Entity\\User', 'login_streak_32' => 'App\\Entity\\User', 'pending_email_33' => 'App\\Entity\\User', 'pending_email_token_34' => 'App\\Entity\\User', 'pending_email_token_sent_at_35' => 'App\\Entity\\User', 'google_id_36' => 'App\\Entity\\User', ], ], ], ], $o[0], [] ); } }];