[ 'sqlFinalizer' => [ $o[1], ], 'resultSetMapping' => [ $o[2], ], 'parameterMappings' => [ [ 'status' => [ 0, ], 'commercial' => [ 1, ], 'oneMonthAgo' => [ 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, u2_.id AS id_37, u2_.token_used AS token_used_38, u2_.token_usable AS token_usable_39, u2_.energy_consumption_wh AS energy_consumption_wh_40, u2_.updated_at AS updated_at_41, u2_.monthly_allocation AS monthly_allocation_42, u2_.bonus_tokens AS bonus_tokens_43, u2_.last_allocation_at AS last_allocation_at_44, u2_.last_claimed_at AS last_claimed_at_45, p3_.id AS id_46, p3_.name AS name_47, p3_.slug AS slug_48, p3_.tagline AS tagline_49, p3_.price_monthly AS price_monthly_50, p3_.price_annual AS price_annual_51, p3_.commitment_label AS commitment_label_52, p3_.monthly_tokens AS monthly_tokens_53, p3_.tokens_label AS tokens_label_54, p3_.cta_label AS cta_label_55, p3_.cta_url AS cta_url_56, p3_.has_sam_access AS has_sam_access_57, p3_.has_priority_support AS has_priority_support_58, p3_.has_multi_account_dashboard AS has_multi_account_dashboard_59, p3_.has_flexible_tokens AS has_flexible_tokens_60, p3_.has_degressive_pricing AS has_degressive_pricing_61, p3_.has_dedicated_training AS has_dedicated_training_62, p3_.token_storage_months AS token_storage_months_63, p3_.stripe_price_id_monthly AS stripe_price_id_monthly_64, p3_.stripe_price_id_annual AS stripe_price_id_annual_65, p3_.gradient_css AS gradient_css_66, p3_.is_recommended AS is_recommended_67, p3_.is_active AS is_active_68, p3_.sort_order AS sort_order_69, u0_.user_id AS user_id_70, u0_.plan_id AS plan_id_71, u0_.pending_plan_id AS pending_plan_id_72, u1_.company_id AS company_id_73, u1_.recruited_by_id AS recruited_by_id_74, u1_.recruited_by_user_id AS recruited_by_user_id_75, u2_.user_id AS user_id_76 FROM user_subscription u0_ INNER JOIN `user` u1_ ON u0_.user_id = u1_.id INNER JOIN user_token u2_ ON u1_.id = u2_.user_id LEFT JOIN plan p3_ ON u0_.plan_id = p3_.id WHERE u0_.status = ? AND u1_.company_id IS NULL AND u1_.roles NOT LIKE ? AND (u2_.last_allocation_at IS NULL OR u2_.last_allocation_at < ?)', ], ], 'stdClass' => [ 'aliasMap' => [ 2 => [ 's' => 'App\\Entity\\UserSubscription', 'u' => 'App\\Entity\\User', 't' => 'App\\Entity\\UserToken', 'p' => 'App\\Entity\\Plan', ], ], 'relationMap' => [ 2 => [ 'u' => 'user', 't' => 'userToken', 'p' => 'plan', ], ], 'parentAliasMap' => [ 2 => [ 'u' => 's', 't' => 'u', 'p' => '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', 'id_37' => 'id', 'token_used_38' => 'tokenUsed', 'token_usable_39' => 'tokenUsable', 'energy_consumption_wh_40' => 'energyConsumptionWh', 'updated_at_41' => 'updatedAt', 'monthly_allocation_42' => 'monthlyAllocation', 'bonus_tokens_43' => 'bonusTokens', 'last_allocation_at_44' => 'lastAllocationAt', 'last_claimed_at_45' => 'lastClaimedAt', 'id_46' => 'id', 'name_47' => 'name', 'slug_48' => 'slug', 'tagline_49' => 'tagline', 'price_monthly_50' => 'priceMonthly', 'price_annual_51' => 'priceAnnual', 'commitment_label_52' => 'commitmentLabel', 'monthly_tokens_53' => 'monthlyTokens', 'tokens_label_54' => 'tokensLabel', 'cta_label_55' => 'ctaLabel', 'cta_url_56' => 'ctaUrl', 'has_sam_access_57' => 'hasSamAccess', 'has_priority_support_58' => 'hasPrioritySupport', 'has_multi_account_dashboard_59' => 'hasMultiAccountDashboard', 'has_flexible_tokens_60' => 'hasFlexibleTokens', 'has_degressive_pricing_61' => 'hasDegressivePricing', 'has_dedicated_training_62' => 'hasDedicatedTraining', 'token_storage_months_63' => 'tokenStorageMonths', 'stripe_price_id_monthly_64' => 'stripePriceIdMonthly', 'stripe_price_id_annual_65' => 'stripePriceIdAnnual', 'gradient_css_66' => 'gradientCss', 'is_recommended_67' => 'isRecommended', 'is_active_68' => 'isActive', 'sort_order_69' => 'sortOrder', ], ], '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', ], ], 'App\\Entity\\UserToken' => [ 't' => [ 'id' => 'id_37', 'tokenUsed' => 'token_used_38', 'tokenUsable' => 'token_usable_39', 'energyConsumptionWh' => 'energy_consumption_wh_40', 'updatedAt' => 'updated_at_41', 'monthlyAllocation' => 'monthly_allocation_42', 'bonusTokens' => 'bonus_tokens_43', 'lastAllocationAt' => 'last_allocation_at_44', 'lastClaimedAt' => 'last_claimed_at_45', ], ], 'App\\Entity\\Plan' => [ 'p' => [ 'id' => 'id_46', 'name' => 'name_47', 'slug' => 'slug_48', 'tagline' => 'tagline_49', 'priceMonthly' => 'price_monthly_50', 'priceAnnual' => 'price_annual_51', 'commitmentLabel' => 'commitment_label_52', 'monthlyTokens' => 'monthly_tokens_53', 'tokensLabel' => 'tokens_label_54', 'ctaLabel' => 'cta_label_55', 'ctaUrl' => 'cta_url_56', 'hasSamAccess' => 'has_sam_access_57', 'hasPrioritySupport' => 'has_priority_support_58', 'hasMultiAccountDashboard' => 'has_multi_account_dashboard_59', 'hasFlexibleTokens' => 'has_flexible_tokens_60', 'hasDegressivePricing' => 'has_degressive_pricing_61', 'hasDedicatedTraining' => 'has_dedicated_training_62', 'tokenStorageMonths' => 'token_storage_months_63', 'stripePriceIdMonthly' => 'stripe_price_id_monthly_64', 'stripePriceIdAnnual' => 'stripe_price_id_annual_65', 'gradientCss' => 'gradient_css_66', 'isRecommended' => 'is_recommended_67', 'isActive' => 'is_active_68', 'sortOrder' => 'sort_order_69', ], ], ], ], 'typeMappings' => [ 2 => [ 'user_id_70' => 'integer', 'plan_id_71' => 'integer', 'pending_plan_id_72' => 'integer', 'company_id_73' => 'integer', 'recruited_by_id_74' => 'integer', 'recruited_by_user_id_75' => 'integer', 'user_id_76' => 'integer', ], ], 'entityMappings' => [ 2 => [ 's' => null, ], ], 'metaMappings' => [ 2 => [ 'user_id_70' => 'user_id', 'plan_id_71' => 'plan_id', 'pending_plan_id_72' => 'pending_plan_id', 'company_id_73' => 'company_id', 'recruited_by_id_74' => 'recruited_by_id', 'recruited_by_user_id_75' => 'recruited_by_user_id', 'user_id_76' => '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', 'id_37' => 't', 'token_used_38' => 't', 'token_usable_39' => 't', 'energy_consumption_wh_40' => 't', 'updated_at_41' => 't', 'monthly_allocation_42' => 't', 'bonus_tokens_43' => 't', 'last_allocation_at_44' => 't', 'last_claimed_at_45' => 't', 'id_46' => 'p', 'name_47' => 'p', 'slug_48' => 'p', 'tagline_49' => 'p', 'price_monthly_50' => 'p', 'price_annual_51' => 'p', 'commitment_label_52' => 'p', 'monthly_tokens_53' => 'p', 'tokens_label_54' => 'p', 'cta_label_55' => 'p', 'cta_url_56' => 'p', 'has_sam_access_57' => 'p', 'has_priority_support_58' => 'p', 'has_multi_account_dashboard_59' => 'p', 'has_flexible_tokens_60' => 'p', 'has_degressive_pricing_61' => 'p', 'has_dedicated_training_62' => 'p', 'token_storage_months_63' => 'p', 'stripe_price_id_monthly_64' => 'p', 'stripe_price_id_annual_65' => 'p', 'gradient_css_66' => 'p', 'is_recommended_67' => 'p', 'is_active_68' => 'p', 'sort_order_69' => 'p', 'user_id_70' => 's', 'plan_id_71' => 's', 'pending_plan_id_72' => 's', 'company_id_73' => 'u', 'recruited_by_id_74' => 'u', 'recruited_by_user_id_75' => 'u', 'user_id_76' => 't', ], ], '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', 'id_37' => 'App\\Entity\\UserToken', 'token_used_38' => 'App\\Entity\\UserToken', 'token_usable_39' => 'App\\Entity\\UserToken', 'energy_consumption_wh_40' => 'App\\Entity\\UserToken', 'updated_at_41' => 'App\\Entity\\UserToken', 'monthly_allocation_42' => 'App\\Entity\\UserToken', 'bonus_tokens_43' => 'App\\Entity\\UserToken', 'last_allocation_at_44' => 'App\\Entity\\UserToken', 'last_claimed_at_45' => 'App\\Entity\\UserToken', 'id_46' => 'App\\Entity\\Plan', 'name_47' => 'App\\Entity\\Plan', 'slug_48' => 'App\\Entity\\Plan', 'tagline_49' => 'App\\Entity\\Plan', 'price_monthly_50' => 'App\\Entity\\Plan', 'price_annual_51' => 'App\\Entity\\Plan', 'commitment_label_52' => 'App\\Entity\\Plan', 'monthly_tokens_53' => 'App\\Entity\\Plan', 'tokens_label_54' => 'App\\Entity\\Plan', 'cta_label_55' => 'App\\Entity\\Plan', 'cta_url_56' => 'App\\Entity\\Plan', 'has_sam_access_57' => 'App\\Entity\\Plan', 'has_priority_support_58' => 'App\\Entity\\Plan', 'has_multi_account_dashboard_59' => 'App\\Entity\\Plan', 'has_flexible_tokens_60' => 'App\\Entity\\Plan', 'has_degressive_pricing_61' => 'App\\Entity\\Plan', 'has_dedicated_training_62' => 'App\\Entity\\Plan', 'token_storage_months_63' => 'App\\Entity\\Plan', 'stripe_price_id_monthly_64' => 'App\\Entity\\Plan', 'stripe_price_id_annual_65' => 'App\\Entity\\Plan', 'gradient_css_66' => 'App\\Entity\\Plan', 'is_recommended_67' => 'App\\Entity\\Plan', 'is_active_68' => 'App\\Entity\\Plan', 'sort_order_69' => 'App\\Entity\\Plan', ], ], ], ], $o[0], [] ); } }];