SELECTs0_.idASid_0,s0_.programIdASprogramId_1,s0_.eventIdASeventId_2,s0_.productIdASproductId_3,s0_.batchNumberASbatchNumber_4,s0_.urlASurl_5,s0_.nameASname_6,s0_.slugASslug_7,s0_.aliasASalias_8,s0_.statusASstatus_9,s0_.focusStatusASfocusStatus_10,s0_.langASlang_11,s0_.priceInEuroCentASpriceInEuroCent_12,s0_.isTaxIncludedASisTaxIncluded_13,s0_.discount100MemberTagsASdiscount100MemberTags_14,s0_.discount50MemberTagsASdiscount50MemberTags_15,s0_.discount20MemberTagsASdiscount20MemberTags_16,s0_.askForTeamASaskForTeam_17,s0_.hasEventAShasEvent_18,s0_.hasIncludeNewsletterPermissionAShasIncludeNewsletterPermission_19,s0_.hasIncludeTermsConsentAShasIncludeTermsConsent_20,s0_.hasIncludeLinkedInAShasIncludeLinkedIn_21,s0_.hasIncludePhoneAShasIncludePhone_22,s0_.hasFollowUpAShasFollowUp_23,s0_.isNetworkingASisNetworking_24,s0_.networkingRoundsASnetworkingRounds_25,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_26,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_27,s0_.isFutureEventASisFutureEvent_28,s0_.visibilityASvisibility_29,s0_.accessASaccess_30,s0_.tagsAStags_31,s0_.typeformLinkAStypeformLink_32,s0_.zoomLinkASzoomLink_33,s0_.bgImageUrlASbgImageUrl_34,s0_.startDateASstartDate_35,s0_.endDateASendDate_36,s0_.stripePriceIdASstripePriceId_37,s0_.stripeProductIdASstripeProductId_38,s0_.stripeAccountASstripeAccount_39,s0_.stripePriceIdLiveASstripePriceIdLive_40,s0_.stripePriceIdTestASstripePriceIdTest_41,s0_.stripeProductIdLiveASstripeProductIdLive_42,s0_.stripeProductIdTestASstripeProductIdTest_43,s0_.taxBehaviorAStaxBehavior_44,s0_.paymentProviderASpaymentProvider_45,s0_.isFreeForKiCampusASisFreeForKiCampus_46,s0_.isFreeForCommunityASisFreeForCommunity_47,s0_.registrationModeASregistrationMode_48,s0_.externalRegistrationUrlASexternalRegistrationUrl_49,s0_.externalPlatformASexternalPlatform_50,s0_.registrationHeadlineASregistrationHeadline_51,s0_.registrationSubtitleASregistrationSubtitle_52,s0_.registrationButtonTextASregistrationButtonText_53,s0_.registrationRedirectUrlASregistrationRedirectUrl_54,s0_.lumaEventApiIdASlumaEventApiId_55,s0_.meetupEventIdASmeetupEventId_56,s0_.meetupEventUrlASmeetupEventUrl_57,s0_.mailDesignTemplateASmailDesignTemplate_58,s0_.senderMailASsenderMail_59,s0_.fromNameASfromName_60,s0_.recipientMonitoringMailASrecipientMonitoringMail_61,s0_.confirmationMailSubjectASconfirmationMailSubject_62,s0_.confirmationMailContentASconfirmationMailContent_63,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_64,s0_.adminNotificationMailContentASadminNotificationMailContent_65,s0_.reminderMailTemplateIdASreminderMailTemplateId_66,s0_.reminderSenderEmailASreminderSenderEmail_67,s0_.reminderBulkMailIdASreminderBulkMailId_68,s0_.reminderMailSendDateASreminderMailSendDate_69,s0_.reminderMailSubjectASreminderMailSubject_70,s0_.reminderMailContentASreminderMailContent_71,s0_.$reminderMailStatusASreminderMailStatus_72,s0_.surveyIdASsurveyId_73,s0_.surveyMailTemplateIdASsurveyMailTemplateId_74,s0_.surveyBulkMailIdASsurveyBulkMailId_75,s0_.templateAStemplate_76,s0_.pageTemplateASpageTemplate_77,s0_.footerTemplateASfooterTemplate_78,s0_.emailASemail_79,s0_.emailSubjectASemailSubject_80,s0_.emailContentASemailContent_81,s0_.landingPageContentASlandingPageContent_82,s0_.landingPageDescriptionASlandingPageDescription_83,s0_.landingPageCssASlandingPageCss_84,s0_.landingPageJsASlandingPageJs_85,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_86,s0_.landingPageSocialImageASlandingPageSocialImage_87,s0_.hasCustomPageAShasCustomPage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.goToPageASgoToPage_91,s0_.phrasesDeASphrasesDe_92,s0_.phrasesEnASphrasesEn_93,s0_.settingsASsettings_94,s0_.capacityAScapacity_95,s0_.asssesmentDimensionsASasssesmentDimensions_96,s0_.startASstart_97,s0_.endASend_98,s0_.pitchTopicASpitchTopic_99,s0_.pitchImageLinkASpitchImageLink_100,s0_.pitchVideoLinkASpitchVideoLink_101,s0_.pitchPartnerASpitchPartner_102,s0_.pitchPartnerIdASpitchPartnerId_103,s0_.pitchDescriptionASpitchDescription_104,s0_.followUpPageContentASfollowUpPageContent_105,s0_.followUpPageDescriptionASfollowUpPageDescription_106,s0_.followUpPageCssASfollowUpPageCss_107,s0_.followUpPageJsASfollowUpPageJs_108,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_109,s0_.followUpPageTitleASfollowUpPageTitle_110,s0_.followUpPageSocialImageASfollowUpPageSocialImage_111,s0_.followUpDescriptionASfollowUpDescription_112,s0_.followUpVideoLinkASfollowUpVideoLink_113,s0_.followUpPresentationASfollowUpPresentation_114,s0_.followUpSkoolUrlASfollowUpSkoolUrl_115,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_116,s0_.followUpCtaTextASfollowUpCtaText_117,s0_.followUpCtaUrlASfollowUpCtaUrl_118,s0_.followUpDocumentsASfollowUpDocuments_119,s0_.followUpPhotosASfollowUpPhotos_120,s0_.followUpExtraLinksASfollowUpExtraLinks_121,s0_.followUpChecklistASfollowUpChecklist_122,s0_.pitchDateASpitchDate_123,s0_.pitchTimeASpitchTime_124,s0_.prepitchDateASprepitchDate_125,s0_.cityAScity_126,s0_.applicationsCountASapplicationsCount_127,s0_.startedCountASstartedCount_128,s0_.appliedCountASappliedCount_129,s0_.approvedCountASapprovedCount_130,s0_.rejectedCountASrejectedCount_131,s0_.$skoolWebhookASskoolWebhook_132,s0_.zapierWebhookASzapierWebhook_133,s0_.historyAShistory_134,s0_.createdAtAScreatedAt_135,s0_.lastModifiedASlastModified_136,s0_.lastChangeUserASlastChangeUser_137,s0_.program_idASprogram_id_138,s0_.assessmentTeamIdASassessmentTeamId_139FROMsp_batchess0_WHEREs0_.eventId=?AND (((s0_.startDateISNOTNULLANDs0_.startDateBETWEEN?AND?) OR (s0_.startDateISNULLANDs0_.pitchDateBETWEEN?AND?))) LIMIT1
SELECTs0_.idASid_0,s0_.programIdASprogramId_1,s0_.eventIdASeventId_2,s0_.productIdASproductId_3,s0_.batchNumberASbatchNumber_4,s0_.urlASurl_5,s0_.nameASname_6,s0_.slugASslug_7,s0_.aliasASalias_8,s0_.statusASstatus_9,s0_.focusStatusASfocusStatus_10,s0_.langASlang_11,s0_.priceInEuroCentASpriceInEuroCent_12,s0_.isTaxIncludedASisTaxIncluded_13,s0_.discount100MemberTagsASdiscount100MemberTags_14,s0_.discount50MemberTagsASdiscount50MemberTags_15,s0_.discount20MemberTagsASdiscount20MemberTags_16,s0_.askForTeamASaskForTeam_17,s0_.hasEventAShasEvent_18,s0_.hasIncludeNewsletterPermissionAShasIncludeNewsletterPermission_19,s0_.hasIncludeTermsConsentAShasIncludeTermsConsent_20,s0_.hasIncludeLinkedInAShasIncludeLinkedIn_21,s0_.hasIncludePhoneAShasIncludePhone_22,s0_.hasFollowUpAShasFollowUp_23,s0_.isNetworkingASisNetworking_24,s0_.networkingRoundsASnetworkingRounds_25,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_26,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_27,s0_.isFutureEventASisFutureEvent_28,s0_.visibilityASvisibility_29,s0_.accessASaccess_30,s0_.tagsAStags_31,s0_.typeformLinkAStypeformLink_32,s0_.zoomLinkASzoomLink_33,s0_.bgImageUrlASbgImageUrl_34,s0_.startDateASstartDate_35,s0_.endDateASendDate_36,s0_.stripePriceIdASstripePriceId_37,s0_.stripeProductIdASstripeProductId_38,s0_.stripeAccountASstripeAccount_39,s0_.stripePriceIdLiveASstripePriceIdLive_40,s0_.stripePriceIdTestASstripePriceIdTest_41,s0_.stripeProductIdLiveASstripeProductIdLive_42,s0_.stripeProductIdTestASstripeProductIdTest_43,s0_.taxBehaviorAStaxBehavior_44,s0_.paymentProviderASpaymentProvider_45,s0_.isFreeForKiCampusASisFreeForKiCampus_46,s0_.isFreeForCommunityASisFreeForCommunity_47,s0_.registrationModeASregistrationMode_48,s0_.externalRegistrationUrlASexternalRegistrationUrl_49,s0_.externalPlatformASexternalPlatform_50,s0_.registrationHeadlineASregistrationHeadline_51,s0_.registrationSubtitleASregistrationSubtitle_52,s0_.registrationButtonTextASregistrationButtonText_53,s0_.registrationRedirectUrlASregistrationRedirectUrl_54,s0_.lumaEventApiIdASlumaEventApiId_55,s0_.meetupEventIdASmeetupEventId_56,s0_.meetupEventUrlASmeetupEventUrl_57,s0_.mailDesignTemplateASmailDesignTemplate_58,s0_.senderMailASsenderMail_59,s0_.fromNameASfromName_60,s0_.recipientMonitoringMailASrecipientMonitoringMail_61,s0_.confirmationMailSubjectASconfirmationMailSubject_62,s0_.confirmationMailContentASconfirmationMailContent_63,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_64,s0_.adminNotificationMailContentASadminNotificationMailContent_65,s0_.reminderMailTemplateIdASreminderMailTemplateId_66,s0_.reminderSenderEmailASreminderSenderEmail_67,s0_.reminderBulkMailIdASreminderBulkMailId_68,s0_.reminderMailSendDateASreminderMailSendDate_69,s0_.reminderMailSubjectASreminderMailSubject_70,s0_.reminderMailContentASreminderMailContent_71,s0_.$reminderMailStatusASreminderMailStatus_72,s0_.surveyIdASsurveyId_73,s0_.surveyMailTemplateIdASsurveyMailTemplateId_74,s0_.surveyBulkMailIdASsurveyBulkMailId_75,s0_.templateAStemplate_76,s0_.pageTemplateASpageTemplate_77,s0_.footerTemplateASfooterTemplate_78,s0_.emailASemail_79,s0_.emailSubjectASemailSubject_80,s0_.emailContentASemailContent_81,s0_.landingPageContentASlandingPageContent_82,s0_.landingPageDescriptionASlandingPageDescription_83,s0_.landingPageCssASlandingPageCss_84,s0_.landingPageJsASlandingPageJs_85,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_86,s0_.landingPageSocialImageASlandingPageSocialImage_87,s0_.hasCustomPageAShasCustomPage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.goToPageASgoToPage_91,s0_.phrasesDeASphrasesDe_92,s0_.phrasesEnASphrasesEn_93,s0_.settingsASsettings_94,s0_.capacityAScapacity_95,s0_.asssesmentDimensionsASasssesmentDimensions_96,s0_.startASstart_97,s0_.endASend_98,s0_.pitchTopicASpitchTopic_99,s0_.pitchImageLinkASpitchImageLink_100,s0_.pitchVideoLinkASpitchVideoLink_101,s0_.pitchPartnerASpitchPartner_102,s0_.pitchPartnerIdASpitchPartnerId_103,s0_.pitchDescriptionASpitchDescription_104,s0_.followUpPageContentASfollowUpPageContent_105,s0_.followUpPageDescriptionASfollowUpPageDescription_106,s0_.followUpPageCssASfollowUpPageCss_107,s0_.followUpPageJsASfollowUpPageJs_108,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_109,s0_.followUpPageTitleASfollowUpPageTitle_110,s0_.followUpPageSocialImageASfollowUpPageSocialImage_111,s0_.followUpDescriptionASfollowUpDescription_112,s0_.followUpVideoLinkASfollowUpVideoLink_113,s0_.followUpPresentationASfollowUpPresentation_114,s0_.followUpSkoolUrlASfollowUpSkoolUrl_115,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_116,s0_.followUpCtaTextASfollowUpCtaText_117,s0_.followUpCtaUrlASfollowUpCtaUrl_118,s0_.followUpDocumentsASfollowUpDocuments_119,s0_.followUpPhotosASfollowUpPhotos_120,s0_.followUpExtraLinksASfollowUpExtraLinks_121,s0_.followUpChecklistASfollowUpChecklist_122,s0_.pitchDateASpitchDate_123,s0_.pitchTimeASpitchTime_124,s0_.prepitchDateASprepitchDate_125,s0_.cityAScity_126,s0_.applicationsCountASapplicationsCount_127,s0_.startedCountASstartedCount_128,s0_.appliedCountASappliedCount_129,s0_.approvedCountASapprovedCount_130,s0_.rejectedCountASrejectedCount_131,s0_.$skoolWebhookASskoolWebhook_132,s0_.zapierWebhookASzapierWebhook_133,s0_.historyAShistory_134,s0_.createdAtAScreatedAt_135,s0_.lastModifiedASlastModified_136,s0_.lastChangeUserASlastChangeUser_137,s0_.program_idASprogram_id_138,s0_.assessmentTeamIdASassessmentTeamId_139FROMsp_batchess0_WHEREs0_.eventId=6887AND (((s0_.startDateISNOTNULLANDs0_.startDateBETWEEN'2026-03-16 00:00:00'AND'2026-03-16 23:59:59') OR (s0_.startDateISNULLANDs0_.pitchDateBETWEEN'2026-03-16 00:00:00'AND'2026-03-16 23:59:59'))) LIMIT1;
5
0.44 ms
SELECTs0_.idASid_0,s0_.programIdASprogramId_1,s0_.eventIdASeventId_2,s0_.productIdASproductId_3,s0_.batchNumberASbatchNumber_4,s0_.urlASurl_5,s0_.nameASname_6,s0_.slugASslug_7,s0_.aliasASalias_8,s0_.statusASstatus_9,s0_.focusStatusASfocusStatus_10,s0_.langASlang_11,s0_.priceInEuroCentASpriceInEuroCent_12,s0_.isTaxIncludedASisTaxIncluded_13,s0_.discount100MemberTagsASdiscount100MemberTags_14,s0_.discount50MemberTagsASdiscount50MemberTags_15,s0_.discount20MemberTagsASdiscount20MemberTags_16,s0_.askForTeamASaskForTeam_17,s0_.hasEventAShasEvent_18,s0_.hasIncludeNewsletterPermissionAShasIncludeNewsletterPermission_19,s0_.hasIncludeTermsConsentAShasIncludeTermsConsent_20,s0_.hasIncludeLinkedInAShasIncludeLinkedIn_21,s0_.hasIncludePhoneAShasIncludePhone_22,s0_.hasFollowUpAShasFollowUp_23,s0_.isNetworkingASisNetworking_24,s0_.networkingRoundsASnetworkingRounds_25,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_26,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_27,s0_.isFutureEventASisFutureEvent_28,s0_.visibilityASvisibility_29,s0_.accessASaccess_30,s0_.tagsAStags_31,s0_.typeformLinkAStypeformLink_32,s0_.zoomLinkASzoomLink_33,s0_.bgImageUrlASbgImageUrl_34,s0_.startDateASstartDate_35,s0_.endDateASendDate_36,s0_.stripePriceIdASstripePriceId_37,s0_.stripeProductIdASstripeProductId_38,s0_.stripeAccountASstripeAccount_39,s0_.stripePriceIdLiveASstripePriceIdLive_40,s0_.stripePriceIdTestASstripePriceIdTest_41,s0_.stripeProductIdLiveASstripeProductIdLive_42,s0_.stripeProductIdTestASstripeProductIdTest_43,s0_.taxBehaviorAStaxBehavior_44,s0_.paymentProviderASpaymentProvider_45,s0_.isFreeForKiCampusASisFreeForKiCampus_46,s0_.isFreeForCommunityASisFreeForCommunity_47,s0_.registrationModeASregistrationMode_48,s0_.externalRegistrationUrlASexternalRegistrationUrl_49,s0_.externalPlatformASexternalPlatform_50,s0_.registrationHeadlineASregistrationHeadline_51,s0_.registrationSubtitleASregistrationSubtitle_52,s0_.registrationButtonTextASregistrationButtonText_53,s0_.registrationRedirectUrlASregistrationRedirectUrl_54,s0_.lumaEventApiIdASlumaEventApiId_55,s0_.meetupEventIdASmeetupEventId_56,s0_.meetupEventUrlASmeetupEventUrl_57,s0_.mailDesignTemplateASmailDesignTemplate_58,s0_.senderMailASsenderMail_59,s0_.fromNameASfromName_60,s0_.recipientMonitoringMailASrecipientMonitoringMail_61,s0_.confirmationMailSubjectASconfirmationMailSubject_62,s0_.confirmationMailContentASconfirmationMailContent_63,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_64,s0_.adminNotificationMailContentASadminNotificationMailContent_65,s0_.reminderMailTemplateIdASreminderMailTemplateId_66,s0_.reminderSenderEmailASreminderSenderEmail_67,s0_.reminderBulkMailIdASreminderBulkMailId_68,s0_.reminderMailSendDateASreminderMailSendDate_69,s0_.reminderMailSubjectASreminderMailSubject_70,s0_.reminderMailContentASreminderMailContent_71,s0_.$reminderMailStatusASreminderMailStatus_72,s0_.surveyIdASsurveyId_73,s0_.surveyMailTemplateIdASsurveyMailTemplateId_74,s0_.surveyBulkMailIdASsurveyBulkMailId_75,s0_.templateAStemplate_76,s0_.pageTemplateASpageTemplate_77,s0_.footerTemplateASfooterTemplate_78,s0_.emailASemail_79,s0_.emailSubjectASemailSubject_80,s0_.emailContentASemailContent_81,s0_.landingPageContentASlandingPageContent_82,s0_.landingPageDescriptionASlandingPageDescription_83,s0_.landingPageCssASlandingPageCss_84,s0_.landingPageJsASlandingPageJs_85,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_86,s0_.landingPageSocialImageASlandingPageSocialImage_87,s0_.hasCustomPageAShasCustomPage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.goToPageASgoToPage_91,s0_.phrasesDeASphrasesDe_92,s0_.phrasesEnASphrasesEn_93,s0_.settingsASsettings_94,s0_.capacityAScapacity_95,s0_.asssesmentDimensionsASasssesmentDimensions_96,s0_.startASstart_97,s0_.endASend_98,s0_.pitchTopicASpitchTopic_99,s0_.pitchImageLinkASpitchImageLink_100,s0_.pitchVideoLinkASpitchVideoLink_101,s0_.pitchPartnerASpitchPartner_102,s0_.pitchPartnerIdASpitchPartnerId_103,s0_.pitchDescriptionASpitchDescription_104,s0_.followUpPageContentASfollowUpPageContent_105,s0_.followUpPageDescriptionASfollowUpPageDescription_106,s0_.followUpPageCssASfollowUpPageCss_107,s0_.followUpPageJsASfollowUpPageJs_108,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_109,s0_.followUpPageTitleASfollowUpPageTitle_110,s0_.followUpPageSocialImageASfollowUpPageSocialImage_111,s0_.followUpDescriptionASfollowUpDescription_112,s0_.followUpVideoLinkASfollowUpVideoLink_113,s0_.followUpPresentationASfollowUpPresentation_114,s0_.followUpSkoolUrlASfollowUpSkoolUrl_115,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_116,s0_.followUpCtaTextASfollowUpCtaText_117,s0_.followUpCtaUrlASfollowUpCtaUrl_118,s0_.followUpDocumentsASfollowUpDocuments_119,s0_.followUpPhotosASfollowUpPhotos_120,s0_.followUpExtraLinksASfollowUpExtraLinks_121,s0_.followUpChecklistASfollowUpChecklist_122,s0_.pitchDateASpitchDate_123,s0_.pitchTimeASpitchTime_124,s0_.prepitchDateASprepitchDate_125,s0_.cityAScity_126,s0_.applicationsCountASapplicationsCount_127,s0_.startedCountASstartedCount_128,s0_.appliedCountASappliedCount_129,s0_.approvedCountASapprovedCount_130,s0_.rejectedCountASrejectedCount_131,s0_.$skoolWebhookASskoolWebhook_132,s0_.zapierWebhookASzapierWebhook_133,s0_.historyAShistory_134,s0_.createdAtAScreatedAt_135,s0_.lastModifiedASlastModified_136,s0_.lastChangeUserASlastChangeUser_137,s0_.program_idASprogram_id_138,s0_.assessmentTeamIdASassessmentTeamId_139FROMsp_batchess0_WHEREs0_.eventId=?ANDs0_.status=?AND (((s0_.startDateISNOTNULLANDs0_.startDate>=?) OR (s0_.startDateISNULLANDs0_.pitchDate>=?))) ORDER BYs0_.startDateASC,s0_.pitchDateASCLIMIT10
SELECTs0_.idASid_0,s0_.programIdASprogramId_1,s0_.eventIdASeventId_2,s0_.productIdASproductId_3,s0_.batchNumberASbatchNumber_4,s0_.urlASurl_5,s0_.nameASname_6,s0_.slugASslug_7,s0_.aliasASalias_8,s0_.statusASstatus_9,s0_.focusStatusASfocusStatus_10,s0_.langASlang_11,s0_.priceInEuroCentASpriceInEuroCent_12,s0_.isTaxIncludedASisTaxIncluded_13,s0_.discount100MemberTagsASdiscount100MemberTags_14,s0_.discount50MemberTagsASdiscount50MemberTags_15,s0_.discount20MemberTagsASdiscount20MemberTags_16,s0_.askForTeamASaskForTeam_17,s0_.hasEventAShasEvent_18,s0_.hasIncludeNewsletterPermissionAShasIncludeNewsletterPermission_19,s0_.hasIncludeTermsConsentAShasIncludeTermsConsent_20,s0_.hasIncludeLinkedInAShasIncludeLinkedIn_21,s0_.hasIncludePhoneAShasIncludePhone_22,s0_.hasFollowUpAShasFollowUp_23,s0_.isNetworkingASisNetworking_24,s0_.networkingRoundsASnetworkingRounds_25,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_26,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_27,s0_.isFutureEventASisFutureEvent_28,s0_.visibilityASvisibility_29,s0_.accessASaccess_30,s0_.tagsAStags_31,s0_.typeformLinkAStypeformLink_32,s0_.zoomLinkASzoomLink_33,s0_.bgImageUrlASbgImageUrl_34,s0_.startDateASstartDate_35,s0_.endDateASendDate_36,s0_.stripePriceIdASstripePriceId_37,s0_.stripeProductIdASstripeProductId_38,s0_.stripeAccountASstripeAccount_39,s0_.stripePriceIdLiveASstripePriceIdLive_40,s0_.stripePriceIdTestASstripePriceIdTest_41,s0_.stripeProductIdLiveASstripeProductIdLive_42,s0_.stripeProductIdTestASstripeProductIdTest_43,s0_.taxBehaviorAStaxBehavior_44,s0_.paymentProviderASpaymentProvider_45,s0_.isFreeForKiCampusASisFreeForKiCampus_46,s0_.isFreeForCommunityASisFreeForCommunity_47,s0_.registrationModeASregistrationMode_48,s0_.externalRegistrationUrlASexternalRegistrationUrl_49,s0_.externalPlatformASexternalPlatform_50,s0_.registrationHeadlineASregistrationHeadline_51,s0_.registrationSubtitleASregistrationSubtitle_52,s0_.registrationButtonTextASregistrationButtonText_53,s0_.registrationRedirectUrlASregistrationRedirectUrl_54,s0_.lumaEventApiIdASlumaEventApiId_55,s0_.meetupEventIdASmeetupEventId_56,s0_.meetupEventUrlASmeetupEventUrl_57,s0_.mailDesignTemplateASmailDesignTemplate_58,s0_.senderMailASsenderMail_59,s0_.fromNameASfromName_60,s0_.recipientMonitoringMailASrecipientMonitoringMail_61,s0_.confirmationMailSubjectASconfirmationMailSubject_62,s0_.confirmationMailContentASconfirmationMailContent_63,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_64,s0_.adminNotificationMailContentASadminNotificationMailContent_65,s0_.reminderMailTemplateIdASreminderMailTemplateId_66,s0_.reminderSenderEmailASreminderSenderEmail_67,s0_.reminderBulkMailIdASreminderBulkMailId_68,s0_.reminderMailSendDateASreminderMailSendDate_69,s0_.reminderMailSubjectASreminderMailSubject_70,s0_.reminderMailContentASreminderMailContent_71,s0_.$reminderMailStatusASreminderMailStatus_72,s0_.surveyIdASsurveyId_73,s0_.surveyMailTemplateIdASsurveyMailTemplateId_74,s0_.surveyBulkMailIdASsurveyBulkMailId_75,s0_.templateAStemplate_76,s0_.pageTemplateASpageTemplate_77,s0_.footerTemplateASfooterTemplate_78,s0_.emailASemail_79,s0_.emailSubjectASemailSubject_80,s0_.emailContentASemailContent_81,s0_.landingPageContentASlandingPageContent_82,s0_.landingPageDescriptionASlandingPageDescription_83,s0_.landingPageCssASlandingPageCss_84,s0_.landingPageJsASlandingPageJs_85,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_86,s0_.landingPageSocialImageASlandingPageSocialImage_87,s0_.hasCustomPageAShasCustomPage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.goToPageASgoToPage_91,s0_.phrasesDeASphrasesDe_92,s0_.phrasesEnASphrasesEn_93,s0_.settingsASsettings_94,s0_.capacityAScapacity_95,s0_.asssesmentDimensionsASasssesmentDimensions_96,s0_.startASstart_97,s0_.endASend_98,s0_.pitchTopicASpitchTopic_99,s0_.pitchImageLinkASpitchImageLink_100,s0_.pitchVideoLinkASpitchVideoLink_101,s0_.pitchPartnerASpitchPartner_102,s0_.pitchPartnerIdASpitchPartnerId_103,s0_.pitchDescriptionASpitchDescription_104,s0_.followUpPageContentASfollowUpPageContent_105,s0_.followUpPageDescriptionASfollowUpPageDescription_106,s0_.followUpPageCssASfollowUpPageCss_107,s0_.followUpPageJsASfollowUpPageJs_108,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_109,s0_.followUpPageTitleASfollowUpPageTitle_110,s0_.followUpPageSocialImageASfollowUpPageSocialImage_111,s0_.followUpDescriptionASfollowUpDescription_112,s0_.followUpVideoLinkASfollowUpVideoLink_113,s0_.followUpPresentationASfollowUpPresentation_114,s0_.followUpSkoolUrlASfollowUpSkoolUrl_115,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_116,s0_.followUpCtaTextASfollowUpCtaText_117,s0_.followUpCtaUrlASfollowUpCtaUrl_118,s0_.followUpDocumentsASfollowUpDocuments_119,s0_.followUpPhotosASfollowUpPhotos_120,s0_.followUpExtraLinksASfollowUpExtraLinks_121,s0_.followUpChecklistASfollowUpChecklist_122,s0_.pitchDateASpitchDate_123,s0_.pitchTimeASpitchTime_124,s0_.prepitchDateASprepitchDate_125,s0_.cityAScity_126,s0_.applicationsCountASapplicationsCount_127,s0_.startedCountASstartedCount_128,s0_.appliedCountASappliedCount_129,s0_.approvedCountASapprovedCount_130,s0_.rejectedCountASrejectedCount_131,s0_.$skoolWebhookASskoolWebhook_132,s0_.zapierWebhookASzapierWebhook_133,s0_.historyAShistory_134,s0_.createdAtAScreatedAt_135,s0_.lastModifiedASlastModified_136,s0_.lastChangeUserASlastChangeUser_137,s0_.program_idASprogram_id_138,s0_.assessmentTeamIdASassessmentTeamId_139FROMsp_batchess0_WHEREs0_.eventId=?ANDs0_.status=?AND (
(
(
s0_.startDateISNOTNULLANDs0_.startDate>=?
)
OR (
s0_.startDateISNULLANDs0_.pitchDate>=?
)
)
)
ORDER BYs0_.startDateASC,s0_.pitchDateASCLIMIT10
SELECTs0_.idASid_0,s0_.programIdASprogramId_1,s0_.eventIdASeventId_2,s0_.productIdASproductId_3,s0_.batchNumberASbatchNumber_4,s0_.urlASurl_5,s0_.nameASname_6,s0_.slugASslug_7,s0_.aliasASalias_8,s0_.statusASstatus_9,s0_.focusStatusASfocusStatus_10,s0_.langASlang_11,s0_.priceInEuroCentASpriceInEuroCent_12,s0_.isTaxIncludedASisTaxIncluded_13,s0_.discount100MemberTagsASdiscount100MemberTags_14,s0_.discount50MemberTagsASdiscount50MemberTags_15,s0_.discount20MemberTagsASdiscount20MemberTags_16,s0_.askForTeamASaskForTeam_17,s0_.hasEventAShasEvent_18,s0_.hasIncludeNewsletterPermissionAShasIncludeNewsletterPermission_19,s0_.hasIncludeTermsConsentAShasIncludeTermsConsent_20,s0_.hasIncludeLinkedInAShasIncludeLinkedIn_21,s0_.hasIncludePhoneAShasIncludePhone_22,s0_.hasFollowUpAShasFollowUp_23,s0_.isNetworkingASisNetworking_24,s0_.networkingRoundsASnetworkingRounds_25,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_26,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_27,s0_.isFutureEventASisFutureEvent_28,s0_.visibilityASvisibility_29,s0_.accessASaccess_30,s0_.tagsAStags_31,s0_.typeformLinkAStypeformLink_32,s0_.zoomLinkASzoomLink_33,s0_.bgImageUrlASbgImageUrl_34,s0_.startDateASstartDate_35,s0_.endDateASendDate_36,s0_.stripePriceIdASstripePriceId_37,s0_.stripeProductIdASstripeProductId_38,s0_.stripeAccountASstripeAccount_39,s0_.stripePriceIdLiveASstripePriceIdLive_40,s0_.stripePriceIdTestASstripePriceIdTest_41,s0_.stripeProductIdLiveASstripeProductIdLive_42,s0_.stripeProductIdTestASstripeProductIdTest_43,s0_.taxBehaviorAStaxBehavior_44,s0_.paymentProviderASpaymentProvider_45,s0_.isFreeForKiCampusASisFreeForKiCampus_46,s0_.isFreeForCommunityASisFreeForCommunity_47,s0_.registrationModeASregistrationMode_48,s0_.externalRegistrationUrlASexternalRegistrationUrl_49,s0_.externalPlatformASexternalPlatform_50,s0_.registrationHeadlineASregistrationHeadline_51,s0_.registrationSubtitleASregistrationSubtitle_52,s0_.registrationButtonTextASregistrationButtonText_53,s0_.registrationRedirectUrlASregistrationRedirectUrl_54,s0_.lumaEventApiIdASlumaEventApiId_55,s0_.meetupEventIdASmeetupEventId_56,s0_.meetupEventUrlASmeetupEventUrl_57,s0_.mailDesignTemplateASmailDesignTemplate_58,s0_.senderMailASsenderMail_59,s0_.fromNameASfromName_60,s0_.recipientMonitoringMailASrecipientMonitoringMail_61,s0_.confirmationMailSubjectASconfirmationMailSubject_62,s0_.confirmationMailContentASconfirmationMailContent_63,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_64,s0_.adminNotificationMailContentASadminNotificationMailContent_65,s0_.reminderMailTemplateIdASreminderMailTemplateId_66,s0_.reminderSenderEmailASreminderSenderEmail_67,s0_.reminderBulkMailIdASreminderBulkMailId_68,s0_.reminderMailSendDateASreminderMailSendDate_69,s0_.reminderMailSubjectASreminderMailSubject_70,s0_.reminderMailContentASreminderMailContent_71,s0_.$reminderMailStatusASreminderMailStatus_72,s0_.surveyIdASsurveyId_73,s0_.surveyMailTemplateIdASsurveyMailTemplateId_74,s0_.surveyBulkMailIdASsurveyBulkMailId_75,s0_.templateAStemplate_76,s0_.pageTemplateASpageTemplate_77,s0_.footerTemplateASfooterTemplate_78,s0_.emailASemail_79,s0_.emailSubjectASemailSubject_80,s0_.emailContentASemailContent_81,s0_.landingPageContentASlandingPageContent_82,s0_.landingPageDescriptionASlandingPageDescription_83,s0_.landingPageCssASlandingPageCss_84,s0_.landingPageJsASlandingPageJs_85,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_86,s0_.landingPageSocialImageASlandingPageSocialImage_87,s0_.hasCustomPageAShasCustomPage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.goToPageASgoToPage_91,s0_.phrasesDeASphrasesDe_92,s0_.phrasesEnASphrasesEn_93,s0_.settingsASsettings_94,s0_.capacityAScapacity_95,s0_.asssesmentDimensionsASasssesmentDimensions_96,s0_.startASstart_97,s0_.endASend_98,s0_.pitchTopicASpitchTopic_99,s0_.pitchImageLinkASpitchImageLink_100,s0_.pitchVideoLinkASpitchVideoLink_101,s0_.pitchPartnerASpitchPartner_102,s0_.pitchPartnerIdASpitchPartnerId_103,s0_.pitchDescriptionASpitchDescription_104,s0_.followUpPageContentASfollowUpPageContent_105,s0_.followUpPageDescriptionASfollowUpPageDescription_106,s0_.followUpPageCssASfollowUpPageCss_107,s0_.followUpPageJsASfollowUpPageJs_108,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_109,s0_.followUpPageTitleASfollowUpPageTitle_110,s0_.followUpPageSocialImageASfollowUpPageSocialImage_111,s0_.followUpDescriptionASfollowUpDescription_112,s0_.followUpVideoLinkASfollowUpVideoLink_113,s0_.followUpPresentationASfollowUpPresentation_114,s0_.followUpSkoolUrlASfollowUpSkoolUrl_115,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_116,s0_.followUpCtaTextASfollowUpCtaText_117,s0_.followUpCtaUrlASfollowUpCtaUrl_118,s0_.followUpDocumentsASfollowUpDocuments_119,s0_.followUpPhotosASfollowUpPhotos_120,s0_.followUpExtraLinksASfollowUpExtraLinks_121,s0_.followUpChecklistASfollowUpChecklist_122,s0_.pitchDateASpitchDate_123,s0_.pitchTimeASpitchTime_124,s0_.prepitchDateASprepitchDate_125,s0_.cityAScity_126,s0_.applicationsCountASapplicationsCount_127,s0_.startedCountASstartedCount_128,s0_.appliedCountASappliedCount_129,s0_.approvedCountASapprovedCount_130,s0_.rejectedCountASrejectedCount_131,s0_.$skoolWebhookASskoolWebhook_132,s0_.zapierWebhookASzapierWebhook_133,s0_.historyAShistory_134,s0_.createdAtAScreatedAt_135,s0_.lastModifiedASlastModified_136,s0_.lastChangeUserASlastChangeUser_137,s0_.program_idASprogram_id_138,s0_.assessmentTeamIdASassessmentTeamId_139FROMsp_batchess0_WHEREs0_.eventId=6887ANDs0_.status='active'AND (((s0_.startDateISNOTNULLANDs0_.startDate>='2026-04-16 00:00:00') OR (s0_.startDateISNULLANDs0_.pitchDate>='2026-04-16 00:00:00'))) ORDER BYs0_.startDateASC,s0_.pitchDateASCLIMIT10;
6
0.42 ms
SELECTs0_.idASid_0,s0_.programIdASprogramId_1,s0_.eventIdASeventId_2,s0_.productIdASproductId_3,s0_.batchNumberASbatchNumber_4,s0_.urlASurl_5,s0_.nameASname_6,s0_.slugASslug_7,s0_.aliasASalias_8,s0_.statusASstatus_9,s0_.focusStatusASfocusStatus_10,s0_.langASlang_11,s0_.priceInEuroCentASpriceInEuroCent_12,s0_.isTaxIncludedASisTaxIncluded_13,s0_.discount100MemberTagsASdiscount100MemberTags_14,s0_.discount50MemberTagsASdiscount50MemberTags_15,s0_.discount20MemberTagsASdiscount20MemberTags_16,s0_.askForTeamASaskForTeam_17,s0_.hasEventAShasEvent_18,s0_.hasIncludeNewsletterPermissionAShasIncludeNewsletterPermission_19,s0_.hasIncludeTermsConsentAShasIncludeTermsConsent_20,s0_.hasIncludeLinkedInAShasIncludeLinkedIn_21,s0_.hasIncludePhoneAShasIncludePhone_22,s0_.hasFollowUpAShasFollowUp_23,s0_.isNetworkingASisNetworking_24,s0_.networkingRoundsASnetworkingRounds_25,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_26,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_27,s0_.isFutureEventASisFutureEvent_28,s0_.visibilityASvisibility_29,s0_.accessASaccess_30,s0_.tagsAStags_31,s0_.typeformLinkAStypeformLink_32,s0_.zoomLinkASzoomLink_33,s0_.bgImageUrlASbgImageUrl_34,s0_.startDateASstartDate_35,s0_.endDateASendDate_36,s0_.stripePriceIdASstripePriceId_37,s0_.stripeProductIdASstripeProductId_38,s0_.stripeAccountASstripeAccount_39,s0_.stripePriceIdLiveASstripePriceIdLive_40,s0_.stripePriceIdTestASstripePriceIdTest_41,s0_.stripeProductIdLiveASstripeProductIdLive_42,s0_.stripeProductIdTestASstripeProductIdTest_43,s0_.taxBehaviorAStaxBehavior_44,s0_.paymentProviderASpaymentProvider_45,s0_.isFreeForKiCampusASisFreeForKiCampus_46,s0_.isFreeForCommunityASisFreeForCommunity_47,s0_.registrationModeASregistrationMode_48,s0_.externalRegistrationUrlASexternalRegistrationUrl_49,s0_.externalPlatformASexternalPlatform_50,s0_.registrationHeadlineASregistrationHeadline_51,s0_.registrationSubtitleASregistrationSubtitle_52,s0_.registrationButtonTextASregistrationButtonText_53,s0_.registrationRedirectUrlASregistrationRedirectUrl_54,s0_.lumaEventApiIdASlumaEventApiId_55,s0_.meetupEventIdASmeetupEventId_56,s0_.meetupEventUrlASmeetupEventUrl_57,s0_.mailDesignTemplateASmailDesignTemplate_58,s0_.senderMailASsenderMail_59,s0_.fromNameASfromName_60,s0_.recipientMonitoringMailASrecipientMonitoringMail_61,s0_.confirmationMailSubjectASconfirmationMailSubject_62,s0_.confirmationMailContentASconfirmationMailContent_63,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_64,s0_.adminNotificationMailContentASadminNotificationMailContent_65,s0_.reminderMailTemplateIdASreminderMailTemplateId_66,s0_.reminderSenderEmailASreminderSenderEmail_67,s0_.reminderBulkMailIdASreminderBulkMailId_68,s0_.reminderMailSendDateASreminderMailSendDate_69,s0_.reminderMailSubjectASreminderMailSubject_70,s0_.reminderMailContentASreminderMailContent_71,s0_.$reminderMailStatusASreminderMailStatus_72,s0_.surveyIdASsurveyId_73,s0_.surveyMailTemplateIdASsurveyMailTemplateId_74,s0_.surveyBulkMailIdASsurveyBulkMailId_75,s0_.templateAStemplate_76,s0_.pageTemplateASpageTemplate_77,s0_.footerTemplateASfooterTemplate_78,s0_.emailASemail_79,s0_.emailSubjectASemailSubject_80,s0_.emailContentASemailContent_81,s0_.landingPageContentASlandingPageContent_82,s0_.landingPageDescriptionASlandingPageDescription_83,s0_.landingPageCssASlandingPageCss_84,s0_.landingPageJsASlandingPageJs_85,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_86,s0_.landingPageSocialImageASlandingPageSocialImage_87,s0_.hasCustomPageAShasCustomPage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.goToPageASgoToPage_91,s0_.phrasesDeASphrasesDe_92,s0_.phrasesEnASphrasesEn_93,s0_.settingsASsettings_94,s0_.capacityAScapacity_95,s0_.asssesmentDimensionsASasssesmentDimensions_96,s0_.startASstart_97,s0_.endASend_98,s0_.pitchTopicASpitchTopic_99,s0_.pitchImageLinkASpitchImageLink_100,s0_.pitchVideoLinkASpitchVideoLink_101,s0_.pitchPartnerASpitchPartner_102,s0_.pitchPartnerIdASpitchPartnerId_103,s0_.pitchDescriptionASpitchDescription_104,s0_.followUpPageContentASfollowUpPageContent_105,s0_.followUpPageDescriptionASfollowUpPageDescription_106,s0_.followUpPageCssASfollowUpPageCss_107,s0_.followUpPageJsASfollowUpPageJs_108,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_109,s0_.followUpPageTitleASfollowUpPageTitle_110,s0_.followUpPageSocialImageASfollowUpPageSocialImage_111,s0_.followUpDescriptionASfollowUpDescription_112,s0_.followUpVideoLinkASfollowUpVideoLink_113,s0_.followUpPresentationASfollowUpPresentation_114,s0_.followUpSkoolUrlASfollowUpSkoolUrl_115,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_116,s0_.followUpCtaTextASfollowUpCtaText_117,s0_.followUpCtaUrlASfollowUpCtaUrl_118,s0_.followUpDocumentsASfollowUpDocuments_119,s0_.followUpPhotosASfollowUpPhotos_120,s0_.followUpExtraLinksASfollowUpExtraLinks_121,s0_.followUpChecklistASfollowUpChecklist_122,s0_.pitchDateASpitchDate_123,s0_.pitchTimeASpitchTime_124,s0_.prepitchDateASprepitchDate_125,s0_.cityAScity_126,s0_.applicationsCountASapplicationsCount_127,s0_.startedCountASstartedCount_128,s0_.appliedCountASappliedCount_129,s0_.approvedCountASapprovedCount_130,s0_.rejectedCountASrejectedCount_131,s0_.$skoolWebhookASskoolWebhook_132,s0_.zapierWebhookASzapierWebhook_133,s0_.historyAShistory_134,s0_.createdAtAScreatedAt_135,s0_.lastModifiedASlastModified_136,s0_.lastChangeUserASlastChangeUser_137,s0_.program_idASprogram_id_138,s0_.assessmentTeamIdASassessmentTeamId_139FROMsp_batchess0_WHEREs0_.eventId=?AND (((s0_.startDateISNOTNULLANDs0_.startDate<?) OR (s0_.startDateISNULLANDs0_.pitchDate<?))) ORDER BYs0_.startDateDESC,s0_.pitchDateDESCLIMIT10
SELECTs0_.idASid_0,s0_.programIdASprogramId_1,s0_.eventIdASeventId_2,s0_.productIdASproductId_3,s0_.batchNumberASbatchNumber_4,s0_.urlASurl_5,s0_.nameASname_6,s0_.slugASslug_7,s0_.aliasASalias_8,s0_.statusASstatus_9,s0_.focusStatusASfocusStatus_10,s0_.langASlang_11,s0_.priceInEuroCentASpriceInEuroCent_12,s0_.isTaxIncludedASisTaxIncluded_13,s0_.discount100MemberTagsASdiscount100MemberTags_14,s0_.discount50MemberTagsASdiscount50MemberTags_15,s0_.discount20MemberTagsASdiscount20MemberTags_16,s0_.askForTeamASaskForTeam_17,s0_.hasEventAShasEvent_18,s0_.hasIncludeNewsletterPermissionAShasIncludeNewsletterPermission_19,s0_.hasIncludeTermsConsentAShasIncludeTermsConsent_20,s0_.hasIncludeLinkedInAShasIncludeLinkedIn_21,s0_.hasIncludePhoneAShasIncludePhone_22,s0_.hasFollowUpAShasFollowUp_23,s0_.isNetworkingASisNetworking_24,s0_.networkingRoundsASnetworkingRounds_25,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_26,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_27,s0_.isFutureEventASisFutureEvent_28,s0_.visibilityASvisibility_29,s0_.accessASaccess_30,s0_.tagsAStags_31,s0_.typeformLinkAStypeformLink_32,s0_.zoomLinkASzoomLink_33,s0_.bgImageUrlASbgImageUrl_34,s0_.startDateASstartDate_35,s0_.endDateASendDate_36,s0_.stripePriceIdASstripePriceId_37,s0_.stripeProductIdASstripeProductId_38,s0_.stripeAccountASstripeAccount_39,s0_.stripePriceIdLiveASstripePriceIdLive_40,s0_.stripePriceIdTestASstripePriceIdTest_41,s0_.stripeProductIdLiveASstripeProductIdLive_42,s0_.stripeProductIdTestASstripeProductIdTest_43,s0_.taxBehaviorAStaxBehavior_44,s0_.paymentProviderASpaymentProvider_45,s0_.isFreeForKiCampusASisFreeForKiCampus_46,s0_.isFreeForCommunityASisFreeForCommunity_47,s0_.registrationModeASregistrationMode_48,s0_.externalRegistrationUrlASexternalRegistrationUrl_49,s0_.externalPlatformASexternalPlatform_50,s0_.registrationHeadlineASregistrationHeadline_51,s0_.registrationSubtitleASregistrationSubtitle_52,s0_.registrationButtonTextASregistrationButtonText_53,s0_.registrationRedirectUrlASregistrationRedirectUrl_54,s0_.lumaEventApiIdASlumaEventApiId_55,s0_.meetupEventIdASmeetupEventId_56,s0_.meetupEventUrlASmeetupEventUrl_57,s0_.mailDesignTemplateASmailDesignTemplate_58,s0_.senderMailASsenderMail_59,s0_.fromNameASfromName_60,s0_.recipientMonitoringMailASrecipientMonitoringMail_61,s0_.confirmationMailSubjectASconfirmationMailSubject_62,s0_.confirmationMailContentASconfirmationMailContent_63,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_64,s0_.adminNotificationMailContentASadminNotificationMailContent_65,s0_.reminderMailTemplateIdASreminderMailTemplateId_66,s0_.reminderSenderEmailASreminderSenderEmail_67,s0_.reminderBulkMailIdASreminderBulkMailId_68,s0_.reminderMailSendDateASreminderMailSendDate_69,s0_.reminderMailSubjectASreminderMailSubject_70,s0_.reminderMailContentASreminderMailContent_71,s0_.$reminderMailStatusASreminderMailStatus_72,s0_.surveyIdASsurveyId_73,s0_.surveyMailTemplateIdASsurveyMailTemplateId_74,s0_.surveyBulkMailIdASsurveyBulkMailId_75,s0_.templateAStemplate_76,s0_.pageTemplateASpageTemplate_77,s0_.footerTemplateASfooterTemplate_78,s0_.emailASemail_79,s0_.emailSubjectASemailSubject_80,s0_.emailContentASemailContent_81,s0_.landingPageContentASlandingPageContent_82,s0_.landingPageDescriptionASlandingPageDescription_83,s0_.landingPageCssASlandingPageCss_84,s0_.landingPageJsASlandingPageJs_85,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_86,s0_.landingPageSocialImageASlandingPageSocialImage_87,s0_.hasCustomPageAShasCustomPage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.goToPageASgoToPage_91,s0_.phrasesDeASphrasesDe_92,s0_.phrasesEnASphrasesEn_93,s0_.settingsASsettings_94,s0_.capacityAScapacity_95,s0_.asssesmentDimensionsASasssesmentDimensions_96,s0_.startASstart_97,s0_.endASend_98,s0_.pitchTopicASpitchTopic_99,s0_.pitchImageLinkASpitchImageLink_100,s0_.pitchVideoLinkASpitchVideoLink_101,s0_.pitchPartnerASpitchPartner_102,s0_.pitchPartnerIdASpitchPartnerId_103,s0_.pitchDescriptionASpitchDescription_104,s0_.followUpPageContentASfollowUpPageContent_105,s0_.followUpPageDescriptionASfollowUpPageDescription_106,s0_.followUpPageCssASfollowUpPageCss_107,s0_.followUpPageJsASfollowUpPageJs_108,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_109,s0_.followUpPageTitleASfollowUpPageTitle_110,s0_.followUpPageSocialImageASfollowUpPageSocialImage_111,s0_.followUpDescriptionASfollowUpDescription_112,s0_.followUpVideoLinkASfollowUpVideoLink_113,s0_.followUpPresentationASfollowUpPresentation_114,s0_.followUpSkoolUrlASfollowUpSkoolUrl_115,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_116,s0_.followUpCtaTextASfollowUpCtaText_117,s0_.followUpCtaUrlASfollowUpCtaUrl_118,s0_.followUpDocumentsASfollowUpDocuments_119,s0_.followUpPhotosASfollowUpPhotos_120,s0_.followUpExtraLinksASfollowUpExtraLinks_121,s0_.followUpChecklistASfollowUpChecklist_122,s0_.pitchDateASpitchDate_123,s0_.pitchTimeASpitchTime_124,s0_.prepitchDateASprepitchDate_125,s0_.cityAScity_126,s0_.applicationsCountASapplicationsCount_127,s0_.startedCountASstartedCount_128,s0_.appliedCountASappliedCount_129,s0_.approvedCountASapprovedCount_130,s0_.rejectedCountASrejectedCount_131,s0_.$skoolWebhookASskoolWebhook_132,s0_.zapierWebhookASzapierWebhook_133,s0_.historyAShistory_134,s0_.createdAtAScreatedAt_135,s0_.lastModifiedASlastModified_136,s0_.lastChangeUserASlastChangeUser_137,s0_.program_idASprogram_id_138,s0_.assessmentTeamIdASassessmentTeamId_139FROMsp_batchess0_WHEREs0_.eventId=?AND (
(
(
s0_.startDateISNOTNULLANDs0_.startDate<?
)
OR (
s0_.startDateISNULLANDs0_.pitchDate<?
)
)
)
ORDER BYs0_.startDateDESC,s0_.pitchDateDESCLIMIT10
SELECTs0_.idASid_0,s0_.programIdASprogramId_1,s0_.eventIdASeventId_2,s0_.productIdASproductId_3,s0_.batchNumberASbatchNumber_4,s0_.urlASurl_5,s0_.nameASname_6,s0_.slugASslug_7,s0_.aliasASalias_8,s0_.statusASstatus_9,s0_.focusStatusASfocusStatus_10,s0_.langASlang_11,s0_.priceInEuroCentASpriceInEuroCent_12,s0_.isTaxIncludedASisTaxIncluded_13,s0_.discount100MemberTagsASdiscount100MemberTags_14,s0_.discount50MemberTagsASdiscount50MemberTags_15,s0_.discount20MemberTagsASdiscount20MemberTags_16,s0_.askForTeamASaskForTeam_17,s0_.hasEventAShasEvent_18,s0_.hasIncludeNewsletterPermissionAShasIncludeNewsletterPermission_19,s0_.hasIncludeTermsConsentAShasIncludeTermsConsent_20,s0_.hasIncludeLinkedInAShasIncludeLinkedIn_21,s0_.hasIncludePhoneAShasIncludePhone_22,s0_.hasFollowUpAShasFollowUp_23,s0_.isNetworkingASisNetworking_24,s0_.networkingRoundsASnetworkingRounds_25,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_26,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_27,s0_.isFutureEventASisFutureEvent_28,s0_.visibilityASvisibility_29,s0_.accessASaccess_30,s0_.tagsAStags_31,s0_.typeformLinkAStypeformLink_32,s0_.zoomLinkASzoomLink_33,s0_.bgImageUrlASbgImageUrl_34,s0_.startDateASstartDate_35,s0_.endDateASendDate_36,s0_.stripePriceIdASstripePriceId_37,s0_.stripeProductIdASstripeProductId_38,s0_.stripeAccountASstripeAccount_39,s0_.stripePriceIdLiveASstripePriceIdLive_40,s0_.stripePriceIdTestASstripePriceIdTest_41,s0_.stripeProductIdLiveASstripeProductIdLive_42,s0_.stripeProductIdTestASstripeProductIdTest_43,s0_.taxBehaviorAStaxBehavior_44,s0_.paymentProviderASpaymentProvider_45,s0_.isFreeForKiCampusASisFreeForKiCampus_46,s0_.isFreeForCommunityASisFreeForCommunity_47,s0_.registrationModeASregistrationMode_48,s0_.externalRegistrationUrlASexternalRegistrationUrl_49,s0_.externalPlatformASexternalPlatform_50,s0_.registrationHeadlineASregistrationHeadline_51,s0_.registrationSubtitleASregistrationSubtitle_52,s0_.registrationButtonTextASregistrationButtonText_53,s0_.registrationRedirectUrlASregistrationRedirectUrl_54,s0_.lumaEventApiIdASlumaEventApiId_55,s0_.meetupEventIdASmeetupEventId_56,s0_.meetupEventUrlASmeetupEventUrl_57,s0_.mailDesignTemplateASmailDesignTemplate_58,s0_.senderMailASsenderMail_59,s0_.fromNameASfromName_60,s0_.recipientMonitoringMailASrecipientMonitoringMail_61,s0_.confirmationMailSubjectASconfirmationMailSubject_62,s0_.confirmationMailContentASconfirmationMailContent_63,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_64,s0_.adminNotificationMailContentASadminNotificationMailContent_65,s0_.reminderMailTemplateIdASreminderMailTemplateId_66,s0_.reminderSenderEmailASreminderSenderEmail_67,s0_.reminderBulkMailIdASreminderBulkMailId_68,s0_.reminderMailSendDateASreminderMailSendDate_69,s0_.reminderMailSubjectASreminderMailSubject_70,s0_.reminderMailContentASreminderMailContent_71,s0_.$reminderMailStatusASreminderMailStatus_72,s0_.surveyIdASsurveyId_73,s0_.surveyMailTemplateIdASsurveyMailTemplateId_74,s0_.surveyBulkMailIdASsurveyBulkMailId_75,s0_.templateAStemplate_76,s0_.pageTemplateASpageTemplate_77,s0_.footerTemplateASfooterTemplate_78,s0_.emailASemail_79,s0_.emailSubjectASemailSubject_80,s0_.emailContentASemailContent_81,s0_.landingPageContentASlandingPageContent_82,s0_.landingPageDescriptionASlandingPageDescription_83,s0_.landingPageCssASlandingPageCss_84,s0_.landingPageJsASlandingPageJs_85,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_86,s0_.landingPageSocialImageASlandingPageSocialImage_87,s0_.hasCustomPageAShasCustomPage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.goToPageASgoToPage_91,s0_.phrasesDeASphrasesDe_92,s0_.phrasesEnASphrasesEn_93,s0_.settingsASsettings_94,s0_.capacityAScapacity_95,s0_.asssesmentDimensionsASasssesmentDimensions_96,s0_.startASstart_97,s0_.endASend_98,s0_.pitchTopicASpitchTopic_99,s0_.pitchImageLinkASpitchImageLink_100,s0_.pitchVideoLinkASpitchVideoLink_101,s0_.pitchPartnerASpitchPartner_102,s0_.pitchPartnerIdASpitchPartnerId_103,s0_.pitchDescriptionASpitchDescription_104,s0_.followUpPageContentASfollowUpPageContent_105,s0_.followUpPageDescriptionASfollowUpPageDescription_106,s0_.followUpPageCssASfollowUpPageCss_107,s0_.followUpPageJsASfollowUpPageJs_108,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_109,s0_.followUpPageTitleASfollowUpPageTitle_110,s0_.followUpPageSocialImageASfollowUpPageSocialImage_111,s0_.followUpDescriptionASfollowUpDescription_112,s0_.followUpVideoLinkASfollowUpVideoLink_113,s0_.followUpPresentationASfollowUpPresentation_114,s0_.followUpSkoolUrlASfollowUpSkoolUrl_115,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_116,s0_.followUpCtaTextASfollowUpCtaText_117,s0_.followUpCtaUrlASfollowUpCtaUrl_118,s0_.followUpDocumentsASfollowUpDocuments_119,s0_.followUpPhotosASfollowUpPhotos_120,s0_.followUpExtraLinksASfollowUpExtraLinks_121,s0_.followUpChecklistASfollowUpChecklist_122,s0_.pitchDateASpitchDate_123,s0_.pitchTimeASpitchTime_124,s0_.prepitchDateASprepitchDate_125,s0_.cityAScity_126,s0_.applicationsCountASapplicationsCount_127,s0_.startedCountASstartedCount_128,s0_.appliedCountASappliedCount_129,s0_.approvedCountASapprovedCount_130,s0_.rejectedCountASrejectedCount_131,s0_.$skoolWebhookASskoolWebhook_132,s0_.zapierWebhookASzapierWebhook_133,s0_.historyAShistory_134,s0_.createdAtAScreatedAt_135,s0_.lastModifiedASlastModified_136,s0_.lastChangeUserASlastChangeUser_137,s0_.program_idASprogram_id_138,s0_.assessmentTeamIdASassessmentTeamId_139FROMsp_batchess0_WHEREs0_.eventId=6887AND (((s0_.startDateISNOTNULLANDs0_.startDate<'2026-04-16 14:53:32') OR (s0_.startDateISNULLANDs0_.pitchDate<'2026-04-16 14:53:32'))) ORDER BYs0_.startDateDESC,s0_.pitchDateDESCLIMIT10;
The field 'App\StartPlatz\Bundle\StartupBundle\Entity\Application#ratingAverage' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
The field App\StartPlatz\Bundle\StartupBundle\Entity\Application#assessments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\StartPlatz\Bundle\AllmedaBundle\Entity\BatchApplicationAssessment#application does not contain the required 'inversedBy="assessments"' attribute.