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_.isFreeForKiCampusASisFreeForKiCampus_40,s0_.isFreeForCommunityASisFreeForCommunity_41,s0_.mailDesignTemplateASmailDesignTemplate_42,s0_.senderMailASsenderMail_43,s0_.fromNameASfromName_44,s0_.recipientMonitoringMailASrecipientMonitoringMail_45,s0_.confirmationMailSubjectASconfirmationMailSubject_46,s0_.confirmationMailContentASconfirmationMailContent_47,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_48,s0_.adminNotificationMailContentASadminNotificationMailContent_49,s0_.reminderMailTemplateIdASreminderMailTemplateId_50,s0_.reminderSenderEmailASreminderSenderEmail_51,s0_.reminderBulkMailIdASreminderBulkMailId_52,s0_.reminderMailSendDateASreminderMailSendDate_53,s0_.reminderMailSubjectASreminderMailSubject_54,s0_.reminderMailContentASreminderMailContent_55,s0_.$reminderMailStatusASreminderMailStatus_56,s0_.surveyIdASsurveyId_57,s0_.surveyMailTemplateIdASsurveyMailTemplateId_58,s0_.surveyBulkMailIdASsurveyBulkMailId_59,s0_.templateAStemplate_60,s0_.pageTemplateASpageTemplate_61,s0_.footerTemplateASfooterTemplate_62,s0_.emailASemail_63,s0_.emailSubjectASemailSubject_64,s0_.emailContentASemailContent_65,s0_.landingPageContentASlandingPageContent_66,s0_.landingPageDescriptionASlandingPageDescription_67,s0_.landingPageCssASlandingPageCss_68,s0_.landingPageJsASlandingPageJs_69,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_70,s0_.landingPageSocialImageASlandingPageSocialImage_71,s0_.landingPageTitleASlandingPageTitle_72,s0_.landingPageTwigASlandingPageTwig_73,s0_.goToPageASgoToPage_74,s0_.phrasesDeASphrasesDe_75,s0_.phrasesEnASphrasesEn_76,s0_.settingsASsettings_77,s0_.asssesmentDimensionsASasssesmentDimensions_78,s0_.startASstart_79,s0_.endASend_80,s0_.pitchTopicASpitchTopic_81,s0_.pitchImageLinkASpitchImageLink_82,s0_.pitchVideoLinkASpitchVideoLink_83,s0_.pitchPartnerASpitchPartner_84,s0_.pitchPartnerIdASpitchPartnerId_85,s0_.pitchDescriptionASpitchDescription_86,s0_.followUpPageContentASfollowUpPageContent_87,s0_.followUpPageDescriptionASfollowUpPageDescription_88,s0_.followUpPageCssASfollowUpPageCss_89,s0_.followUpPageJsASfollowUpPageJs_90,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_91,s0_.followUpPageTitleASfollowUpPageTitle_92,s0_.followUpPageSocialImageASfollowUpPageSocialImage_93,s0_.followUpDescriptionASfollowUpDescription_94,s0_.followUpVideoLinkASfollowUpVideoLink_95,s0_.followUpPresentationASfollowUpPresentation_96,s0_.pitchDateASpitchDate_97,s0_.pitchTimeASpitchTime_98,s0_.prepitchDateASprepitchDate_99,s0_.cityAScity_100,s0_.applicationsCountASapplicationsCount_101,s0_.startedCountASstartedCount_102,s0_.appliedCountASappliedCount_103,s0_.approvedCountASapprovedCount_104,s0_.rejectedCountASrejectedCount_105,s0_.$skoolWebhookASskoolWebhook_106,s0_.zapierWebhookASzapierWebhook_107,s0_.historyAShistory_108,s0_.createdAtAScreatedAt_109,s0_.lastModifiedASlastModified_110,s0_.lastChangeUserASlastChangeUser_111,s0_.program_idASprogram_id_112,s0_.assessmentTeamIdASassessmentTeamId_113FROMsp_batchess0_WHERE (s0_.status='active'ANDs0_.programId=?) AND (s0_.start<?ANDs0_.end>?) ORDER BYs0_.startASCLIMIT1
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_.isFreeForKiCampusASisFreeForKiCampus_40,s0_.isFreeForCommunityASisFreeForCommunity_41,s0_.mailDesignTemplateASmailDesignTemplate_42,s0_.senderMailASsenderMail_43,s0_.fromNameASfromName_44,s0_.recipientMonitoringMailASrecipientMonitoringMail_45,s0_.confirmationMailSubjectASconfirmationMailSubject_46,s0_.confirmationMailContentASconfirmationMailContent_47,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_48,s0_.adminNotificationMailContentASadminNotificationMailContent_49,s0_.reminderMailTemplateIdASreminderMailTemplateId_50,s0_.reminderSenderEmailASreminderSenderEmail_51,s0_.reminderBulkMailIdASreminderBulkMailId_52,s0_.reminderMailSendDateASreminderMailSendDate_53,s0_.reminderMailSubjectASreminderMailSubject_54,s0_.reminderMailContentASreminderMailContent_55,s0_.$reminderMailStatusASreminderMailStatus_56,s0_.surveyIdASsurveyId_57,s0_.surveyMailTemplateIdASsurveyMailTemplateId_58,s0_.surveyBulkMailIdASsurveyBulkMailId_59,s0_.templateAStemplate_60,s0_.pageTemplateASpageTemplate_61,s0_.footerTemplateASfooterTemplate_62,s0_.emailASemail_63,s0_.emailSubjectASemailSubject_64,s0_.emailContentASemailContent_65,s0_.landingPageContentASlandingPageContent_66,s0_.landingPageDescriptionASlandingPageDescription_67,s0_.landingPageCssASlandingPageCss_68,s0_.landingPageJsASlandingPageJs_69,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_70,s0_.landingPageSocialImageASlandingPageSocialImage_71,s0_.landingPageTitleASlandingPageTitle_72,s0_.landingPageTwigASlandingPageTwig_73,s0_.goToPageASgoToPage_74,s0_.phrasesDeASphrasesDe_75,s0_.phrasesEnASphrasesEn_76,s0_.settingsASsettings_77,s0_.asssesmentDimensionsASasssesmentDimensions_78,s0_.startASstart_79,s0_.endASend_80,s0_.pitchTopicASpitchTopic_81,s0_.pitchImageLinkASpitchImageLink_82,s0_.pitchVideoLinkASpitchVideoLink_83,s0_.pitchPartnerASpitchPartner_84,s0_.pitchPartnerIdASpitchPartnerId_85,s0_.pitchDescriptionASpitchDescription_86,s0_.followUpPageContentASfollowUpPageContent_87,s0_.followUpPageDescriptionASfollowUpPageDescription_88,s0_.followUpPageCssASfollowUpPageCss_89,s0_.followUpPageJsASfollowUpPageJs_90,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_91,s0_.followUpPageTitleASfollowUpPageTitle_92,s0_.followUpPageSocialImageASfollowUpPageSocialImage_93,s0_.followUpDescriptionASfollowUpDescription_94,s0_.followUpVideoLinkASfollowUpVideoLink_95,s0_.followUpPresentationASfollowUpPresentation_96,s0_.pitchDateASpitchDate_97,s0_.pitchTimeASpitchTime_98,s0_.prepitchDateASprepitchDate_99,s0_.cityAScity_100,s0_.applicationsCountASapplicationsCount_101,s0_.startedCountASstartedCount_102,s0_.appliedCountASappliedCount_103,s0_.approvedCountASapprovedCount_104,s0_.rejectedCountASrejectedCount_105,s0_.$skoolWebhookASskoolWebhook_106,s0_.zapierWebhookASzapierWebhook_107,s0_.historyAShistory_108,s0_.createdAtAScreatedAt_109,s0_.lastModifiedASlastModified_110,s0_.lastChangeUserASlastChangeUser_111,s0_.program_idASprogram_id_112,s0_.assessmentTeamIdASassessmentTeamId_113FROMsp_batchess0_WHERE
(
s0_.status='active'ANDs0_.programId=?
)
AND (
s0_.start<?ANDs0_.end>?
)
ORDER BYs0_.startASCLIMIT1
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_.isFreeForKiCampusASisFreeForKiCampus_40,s0_.isFreeForCommunityASisFreeForCommunity_41,s0_.mailDesignTemplateASmailDesignTemplate_42,s0_.senderMailASsenderMail_43,s0_.fromNameASfromName_44,s0_.recipientMonitoringMailASrecipientMonitoringMail_45,s0_.confirmationMailSubjectASconfirmationMailSubject_46,s0_.confirmationMailContentASconfirmationMailContent_47,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_48,s0_.adminNotificationMailContentASadminNotificationMailContent_49,s0_.reminderMailTemplateIdASreminderMailTemplateId_50,s0_.reminderSenderEmailASreminderSenderEmail_51,s0_.reminderBulkMailIdASreminderBulkMailId_52,s0_.reminderMailSendDateASreminderMailSendDate_53,s0_.reminderMailSubjectASreminderMailSubject_54,s0_.reminderMailContentASreminderMailContent_55,s0_.$reminderMailStatusASreminderMailStatus_56,s0_.surveyIdASsurveyId_57,s0_.surveyMailTemplateIdASsurveyMailTemplateId_58,s0_.surveyBulkMailIdASsurveyBulkMailId_59,s0_.templateAStemplate_60,s0_.pageTemplateASpageTemplate_61,s0_.footerTemplateASfooterTemplate_62,s0_.emailASemail_63,s0_.emailSubjectASemailSubject_64,s0_.emailContentASemailContent_65,s0_.landingPageContentASlandingPageContent_66,s0_.landingPageDescriptionASlandingPageDescription_67,s0_.landingPageCssASlandingPageCss_68,s0_.landingPageJsASlandingPageJs_69,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_70,s0_.landingPageSocialImageASlandingPageSocialImage_71,s0_.landingPageTitleASlandingPageTitle_72,s0_.landingPageTwigASlandingPageTwig_73,s0_.goToPageASgoToPage_74,s0_.phrasesDeASphrasesDe_75,s0_.phrasesEnASphrasesEn_76,s0_.settingsASsettings_77,s0_.asssesmentDimensionsASasssesmentDimensions_78,s0_.startASstart_79,s0_.endASend_80,s0_.pitchTopicASpitchTopic_81,s0_.pitchImageLinkASpitchImageLink_82,s0_.pitchVideoLinkASpitchVideoLink_83,s0_.pitchPartnerASpitchPartner_84,s0_.pitchPartnerIdASpitchPartnerId_85,s0_.pitchDescriptionASpitchDescription_86,s0_.followUpPageContentASfollowUpPageContent_87,s0_.followUpPageDescriptionASfollowUpPageDescription_88,s0_.followUpPageCssASfollowUpPageCss_89,s0_.followUpPageJsASfollowUpPageJs_90,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_91,s0_.followUpPageTitleASfollowUpPageTitle_92,s0_.followUpPageSocialImageASfollowUpPageSocialImage_93,s0_.followUpDescriptionASfollowUpDescription_94,s0_.followUpVideoLinkASfollowUpVideoLink_95,s0_.followUpPresentationASfollowUpPresentation_96,s0_.pitchDateASpitchDate_97,s0_.pitchTimeASpitchTime_98,s0_.prepitchDateASprepitchDate_99,s0_.cityAScity_100,s0_.applicationsCountASapplicationsCount_101,s0_.startedCountASstartedCount_102,s0_.appliedCountASappliedCount_103,s0_.approvedCountASapprovedCount_104,s0_.rejectedCountASrejectedCount_105,s0_.$skoolWebhookASskoolWebhook_106,s0_.zapierWebhookASzapierWebhook_107,s0_.historyAShistory_108,s0_.createdAtAScreatedAt_109,s0_.lastModifiedASlastModified_110,s0_.lastChangeUserASlastChangeUser_111,s0_.program_idASprogram_id_112,s0_.assessmentTeamIdASassessmentTeamId_113FROMsp_batchess0_WHERE (s0_.status='active'ANDs0_.programId=5) AND (s0_.start<'2026-02-27 05:59:53'ANDs0_.end>'2026-02-27 05:59:53') ORDER BYs0_.startASCLIMIT1;