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_.hasRequirePhoneAShasRequirePhone_23,s0_.hasFollowUpAShasFollowUp_24,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_25,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_26,s0_.isFutureEventASisFutureEvent_27,s0_.visibilityASvisibility_28,s0_.accessASaccess_29,s0_.tagsAStags_30,s0_.typeformLinkAStypeformLink_31,s0_.zoomLinkASzoomLink_32,s0_.bgImageUrlASbgImageUrl_33,s0_.startDateASstartDate_34,s0_.endDateASendDate_35,s0_.taxBehaviorAStaxBehavior_36,s0_.paymentProviderASpaymentProvider_37,s0_.isFreeForKiCampusASisFreeForKiCampus_38,s0_.isFreeForCommunityASisFreeForCommunity_39,s0_.registrationModeASregistrationMode_40,s0_.externalRegistrationUrlASexternalRegistrationUrl_41,s0_.externalPlatformASexternalPlatform_42,s0_.registrationHeadlineASregistrationHeadline_43,s0_.registrationSubtitleASregistrationSubtitle_44,s0_.registrationButtonTextASregistrationButtonText_45,s0_.registrationPriceHtmlASregistrationPriceHtml_46,s0_.registrationRedirectUrlASregistrationRedirectUrl_47,s0_.lumaEventApiIdASlumaEventApiId_48,s0_.meetupEventIdASmeetupEventId_49,s0_.meetupEventUrlASmeetupEventUrl_50,s0_.mailDesignTemplateASmailDesignTemplate_51,s0_.senderMailASsenderMail_52,s0_.fromNameASfromName_53,s0_.recipientMonitoringMailASrecipientMonitoringMail_54,s0_.confirmationMailSubjectASconfirmationMailSubject_55,s0_.confirmationMailContentASconfirmationMailContent_56,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_57,s0_.adminNotificationMailContentASadminNotificationMailContent_58,s0_.reminderMailTemplateIdASreminderMailTemplateId_59,s0_.reminderSenderEmailASreminderSenderEmail_60,s0_.reminderMailSendDateASreminderMailSendDate_61,s0_.reminderMailSubjectASreminderMailSubject_62,s0_.reminderMailContentASreminderMailContent_63,s0_.$reminderMailStatusASreminderMailStatus_64,s0_.surveyIdASsurveyId_65,s0_.surveyMailTemplateIdASsurveyMailTemplateId_66,s0_.surveyBulkMailIdASsurveyBulkMailId_67,s0_.templateAStemplate_68,s0_.pageTemplateASpageTemplate_69,s0_.footerTemplateASfooterTemplate_70,s0_.emailASemail_71,s0_.emailSubjectASemailSubject_72,s0_.emailContentASemailContent_73,s0_.landingPageContentASlandingPageContent_74,s0_.landingPageDescriptionASlandingPageDescription_75,s0_.landingPageCssASlandingPageCss_76,s0_.landingPageJsASlandingPageJs_77,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_78,s0_.landingPageTitleASlandingPageTitle_79,s0_.landingPageTwigASlandingPageTwig_80,s0_.titleAStitle_81,s0_.teaserASteaser_82,s0_.navbarASnavbar_83,s0_.contentAScontent_84,s0_.contentTwigAScontentTwig_85,s0_.content_blocksAScontent_blocks_86,s0_.content_blocks_enAScontent_blocks_en_87,s0_.ctaContentASctaContent_88,s0_.postCtaContentASpostCtaContent_89,s0_.taglineAStagline_90,s0_.seoTitleASseoTitle_91,s0_.seoDescriptionASseoDescription_92,s0_.seoKeywordASseoKeyword_93,s0_.imagelinkASimagelink_94,s0_.bgImagelinkASbgImagelink_95,s0_.additionalCssASadditionalCss_96,s0_.additionalJsASadditionalJs_97,s0_.navbarEnASnavbarEn_98,s0_.teaserEnASteaserEn_99,s0_.contentEnAScontentEn_100,s0_.contentTwigEnAScontentTwigEn_101,s0_.postCtaContentEnASpostCtaContentEn_102,s0_.seoTitleEnASseoTitleEn_103,s0_.seoDescriptionEnASseoDescriptionEn_104,s0_.seoKeywordEnASseoKeywordEn_105,s0_.trainerAStrainer_106,s0_.videolinkASvideolink_107,s0_.goToPageASgoToPage_108,s0_.phrasesDeASphrasesDe_109,s0_.phrasesEnASphrasesEn_110,s0_.settingsASsettings_111,s0_.capacityAScapacity_112,s0_.asssesmentDimensionsASasssesmentDimensions_113,s0_.startASstart_114,s0_.endASend_115,s0_.pitchTopicASpitchTopic_116,s0_.pitchImageLinkASpitchImageLink_117,s0_.pitchVideoLinkASpitchVideoLink_118,s0_.pitchPartnerASpitchPartner_119,s0_.pitchPartnerIdASpitchPartnerId_120,s0_.pitchDescriptionASpitchDescription_121,s0_.followUpPageContentASfollowUpPageContent_122,s0_.followUpPageDescriptionASfollowUpPageDescription_123,s0_.followUpPageCssASfollowUpPageCss_124,s0_.followUpPageJsASfollowUpPageJs_125,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_126,s0_.followUpPageTitleASfollowUpPageTitle_127,s0_.followUpDescriptionASfollowUpDescription_128,s0_.followUpVideoLinkASfollowUpVideoLink_129,s0_.followUpPresentationASfollowUpPresentation_130,s0_.followUpSkoolUrlASfollowUpSkoolUrl_131,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_132,s0_.followUpCtaTextASfollowUpCtaText_133,s0_.followUpCtaUrlASfollowUpCtaUrl_134,s0_.followUpDocumentsASfollowUpDocuments_135,s0_.followUpPhotosASfollowUpPhotos_136,s0_.followUpExtraLinksASfollowUpExtraLinks_137,s0_.followUpChecklistASfollowUpChecklist_138,s0_.pitchDateASpitchDate_139,s0_.pitchTimeASpitchTime_140,s0_.prepitchDateASprepitchDate_141,s0_.scoutingEndDateASscoutingEndDate_142,s0_.applicationStartDateASapplicationStartDate_143,s0_.applicationEndDateASapplicationEndDate_144,s0_.interviewInviteStartDateASinterviewInviteStartDate_145,s0_.interviewInviteEndDateASinterviewInviteEndDate_146,s0_.interviewStartDateASinterviewStartDate_147,s0_.interviewEndDateASinterviewEndDate_148,s0_.decisionDateASdecisionDate_149,s0_.contractDeadlineDateAScontractDeadlineDate_150,s0_.finalReportDateASfinalReportDate_151,s0_.applicationFormStateASapplicationFormState_152,s0_.googleCalendarUrlASgoogleCalendarUrl_153,s0_.cityAScity_154,s0_.applicationsCountASapplicationsCount_155,s0_.startedCountASstartedCount_156,s0_.appliedCountASappliedCount_157,s0_.approvedCountASapprovedCount_158,s0_.rejectedCountASrejectedCount_159,s0_.$skoolWebhookASskoolWebhook_160,s0_.zapierWebhookASzapierWebhook_161,s0_.historyAShistory_162,s0_.createdAtAScreatedAt_163,s0_.lastModifiedASlastModified_164,s0_.lastChangeUserASlastChangeUser_165,s0_.programIdASprogramId_166,s0_.assessmentTeamIdASassessmentTeamId_167FROMsp_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_.hasRequirePhoneAShasRequirePhone_23,s0_.hasFollowUpAShasFollowUp_24,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_25,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_26,s0_.isFutureEventASisFutureEvent_27,s0_.visibilityASvisibility_28,s0_.accessASaccess_29,s0_.tagsAStags_30,s0_.typeformLinkAStypeformLink_31,s0_.zoomLinkASzoomLink_32,s0_.bgImageUrlASbgImageUrl_33,s0_.startDateASstartDate_34,s0_.endDateASendDate_35,s0_.taxBehaviorAStaxBehavior_36,s0_.paymentProviderASpaymentProvider_37,s0_.isFreeForKiCampusASisFreeForKiCampus_38,s0_.isFreeForCommunityASisFreeForCommunity_39,s0_.registrationModeASregistrationMode_40,s0_.externalRegistrationUrlASexternalRegistrationUrl_41,s0_.externalPlatformASexternalPlatform_42,s0_.registrationHeadlineASregistrationHeadline_43,s0_.registrationSubtitleASregistrationSubtitle_44,s0_.registrationButtonTextASregistrationButtonText_45,s0_.registrationPriceHtmlASregistrationPriceHtml_46,s0_.registrationRedirectUrlASregistrationRedirectUrl_47,s0_.lumaEventApiIdASlumaEventApiId_48,s0_.meetupEventIdASmeetupEventId_49,s0_.meetupEventUrlASmeetupEventUrl_50,s0_.mailDesignTemplateASmailDesignTemplate_51,s0_.senderMailASsenderMail_52,s0_.fromNameASfromName_53,s0_.recipientMonitoringMailASrecipientMonitoringMail_54,s0_.confirmationMailSubjectASconfirmationMailSubject_55,s0_.confirmationMailContentASconfirmationMailContent_56,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_57,s0_.adminNotificationMailContentASadminNotificationMailContent_58,s0_.reminderMailTemplateIdASreminderMailTemplateId_59,s0_.reminderSenderEmailASreminderSenderEmail_60,s0_.reminderMailSendDateASreminderMailSendDate_61,s0_.reminderMailSubjectASreminderMailSubject_62,s0_.reminderMailContentASreminderMailContent_63,s0_.$reminderMailStatusASreminderMailStatus_64,s0_.surveyIdASsurveyId_65,s0_.surveyMailTemplateIdASsurveyMailTemplateId_66,s0_.surveyBulkMailIdASsurveyBulkMailId_67,s0_.templateAStemplate_68,s0_.pageTemplateASpageTemplate_69,s0_.footerTemplateASfooterTemplate_70,s0_.emailASemail_71,s0_.emailSubjectASemailSubject_72,s0_.emailContentASemailContent_73,s0_.landingPageContentASlandingPageContent_74,s0_.landingPageDescriptionASlandingPageDescription_75,s0_.landingPageCssASlandingPageCss_76,s0_.landingPageJsASlandingPageJs_77,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_78,s0_.landingPageTitleASlandingPageTitle_79,s0_.landingPageTwigASlandingPageTwig_80,s0_.titleAStitle_81,s0_.teaserASteaser_82,s0_.navbarASnavbar_83,s0_.contentAScontent_84,s0_.contentTwigAScontentTwig_85,s0_.content_blocksAScontent_blocks_86,s0_.content_blocks_enAScontent_blocks_en_87,s0_.ctaContentASctaContent_88,s0_.postCtaContentASpostCtaContent_89,s0_.taglineAStagline_90,s0_.seoTitleASseoTitle_91,s0_.seoDescriptionASseoDescription_92,s0_.seoKeywordASseoKeyword_93,s0_.imagelinkASimagelink_94,s0_.bgImagelinkASbgImagelink_95,s0_.additionalCssASadditionalCss_96,s0_.additionalJsASadditionalJs_97,s0_.navbarEnASnavbarEn_98,s0_.teaserEnASteaserEn_99,s0_.contentEnAScontentEn_100,s0_.contentTwigEnAScontentTwigEn_101,s0_.postCtaContentEnASpostCtaContentEn_102,s0_.seoTitleEnASseoTitleEn_103,s0_.seoDescriptionEnASseoDescriptionEn_104,s0_.seoKeywordEnASseoKeywordEn_105,s0_.trainerAStrainer_106,s0_.videolinkASvideolink_107,s0_.goToPageASgoToPage_108,s0_.phrasesDeASphrasesDe_109,s0_.phrasesEnASphrasesEn_110,s0_.settingsASsettings_111,s0_.capacityAScapacity_112,s0_.asssesmentDimensionsASasssesmentDimensions_113,s0_.startASstart_114,s0_.endASend_115,s0_.pitchTopicASpitchTopic_116,s0_.pitchImageLinkASpitchImageLink_117,s0_.pitchVideoLinkASpitchVideoLink_118,s0_.pitchPartnerASpitchPartner_119,s0_.pitchPartnerIdASpitchPartnerId_120,s0_.pitchDescriptionASpitchDescription_121,s0_.followUpPageContentASfollowUpPageContent_122,s0_.followUpPageDescriptionASfollowUpPageDescription_123,s0_.followUpPageCssASfollowUpPageCss_124,s0_.followUpPageJsASfollowUpPageJs_125,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_126,s0_.followUpPageTitleASfollowUpPageTitle_127,s0_.followUpDescriptionASfollowUpDescription_128,s0_.followUpVideoLinkASfollowUpVideoLink_129,s0_.followUpPresentationASfollowUpPresentation_130,s0_.followUpSkoolUrlASfollowUpSkoolUrl_131,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_132,s0_.followUpCtaTextASfollowUpCtaText_133,s0_.followUpCtaUrlASfollowUpCtaUrl_134,s0_.followUpDocumentsASfollowUpDocuments_135,s0_.followUpPhotosASfollowUpPhotos_136,s0_.followUpExtraLinksASfollowUpExtraLinks_137,s0_.followUpChecklistASfollowUpChecklist_138,s0_.pitchDateASpitchDate_139,s0_.pitchTimeASpitchTime_140,s0_.prepitchDateASprepitchDate_141,s0_.scoutingEndDateASscoutingEndDate_142,s0_.applicationStartDateASapplicationStartDate_143,s0_.applicationEndDateASapplicationEndDate_144,s0_.interviewInviteStartDateASinterviewInviteStartDate_145,s0_.interviewInviteEndDateASinterviewInviteEndDate_146,s0_.interviewStartDateASinterviewStartDate_147,s0_.interviewEndDateASinterviewEndDate_148,s0_.decisionDateASdecisionDate_149,s0_.contractDeadlineDateAScontractDeadlineDate_150,s0_.finalReportDateASfinalReportDate_151,s0_.applicationFormStateASapplicationFormState_152,s0_.googleCalendarUrlASgoogleCalendarUrl_153,s0_.cityAScity_154,s0_.applicationsCountASapplicationsCount_155,s0_.startedCountASstartedCount_156,s0_.appliedCountASappliedCount_157,s0_.approvedCountASapprovedCount_158,s0_.rejectedCountASrejectedCount_159,s0_.$skoolWebhookASskoolWebhook_160,s0_.zapierWebhookASzapierWebhook_161,s0_.historyAShistory_162,s0_.createdAtAScreatedAt_163,s0_.lastModifiedASlastModified_164,s0_.lastChangeUserASlastChangeUser_165,s0_.programIdASprogramId_166,s0_.assessmentTeamIdASassessmentTeamId_167FROMsp_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_.hasRequirePhoneAShasRequirePhone_23,s0_.hasFollowUpAShasFollowUp_24,s0_.isMultipleApplicationsPerMemberASisMultipleApplicationsPerMember_25,s0_.isMultipleApplicationsPerTeamASisMultipleApplicationsPerTeam_26,s0_.isFutureEventASisFutureEvent_27,s0_.visibilityASvisibility_28,s0_.accessASaccess_29,s0_.tagsAStags_30,s0_.typeformLinkAStypeformLink_31,s0_.zoomLinkASzoomLink_32,s0_.bgImageUrlASbgImageUrl_33,s0_.startDateASstartDate_34,s0_.endDateASendDate_35,s0_.taxBehaviorAStaxBehavior_36,s0_.paymentProviderASpaymentProvider_37,s0_.isFreeForKiCampusASisFreeForKiCampus_38,s0_.isFreeForCommunityASisFreeForCommunity_39,s0_.registrationModeASregistrationMode_40,s0_.externalRegistrationUrlASexternalRegistrationUrl_41,s0_.externalPlatformASexternalPlatform_42,s0_.registrationHeadlineASregistrationHeadline_43,s0_.registrationSubtitleASregistrationSubtitle_44,s0_.registrationButtonTextASregistrationButtonText_45,s0_.registrationPriceHtmlASregistrationPriceHtml_46,s0_.registrationRedirectUrlASregistrationRedirectUrl_47,s0_.lumaEventApiIdASlumaEventApiId_48,s0_.meetupEventIdASmeetupEventId_49,s0_.meetupEventUrlASmeetupEventUrl_50,s0_.mailDesignTemplateASmailDesignTemplate_51,s0_.senderMailASsenderMail_52,s0_.fromNameASfromName_53,s0_.recipientMonitoringMailASrecipientMonitoringMail_54,s0_.confirmationMailSubjectASconfirmationMailSubject_55,s0_.confirmationMailContentASconfirmationMailContent_56,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_57,s0_.adminNotificationMailContentASadminNotificationMailContent_58,s0_.reminderMailTemplateIdASreminderMailTemplateId_59,s0_.reminderSenderEmailASreminderSenderEmail_60,s0_.reminderMailSendDateASreminderMailSendDate_61,s0_.reminderMailSubjectASreminderMailSubject_62,s0_.reminderMailContentASreminderMailContent_63,s0_.$reminderMailStatusASreminderMailStatus_64,s0_.surveyIdASsurveyId_65,s0_.surveyMailTemplateIdASsurveyMailTemplateId_66,s0_.surveyBulkMailIdASsurveyBulkMailId_67,s0_.templateAStemplate_68,s0_.pageTemplateASpageTemplate_69,s0_.footerTemplateASfooterTemplate_70,s0_.emailASemail_71,s0_.emailSubjectASemailSubject_72,s0_.emailContentASemailContent_73,s0_.landingPageContentASlandingPageContent_74,s0_.landingPageDescriptionASlandingPageDescription_75,s0_.landingPageCssASlandingPageCss_76,s0_.landingPageJsASlandingPageJs_77,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_78,s0_.landingPageTitleASlandingPageTitle_79,s0_.landingPageTwigASlandingPageTwig_80,s0_.titleAStitle_81,s0_.teaserASteaser_82,s0_.navbarASnavbar_83,s0_.contentAScontent_84,s0_.contentTwigAScontentTwig_85,s0_.content_blocksAScontent_blocks_86,s0_.content_blocks_enAScontent_blocks_en_87,s0_.ctaContentASctaContent_88,s0_.postCtaContentASpostCtaContent_89,s0_.taglineAStagline_90,s0_.seoTitleASseoTitle_91,s0_.seoDescriptionASseoDescription_92,s0_.seoKeywordASseoKeyword_93,s0_.imagelinkASimagelink_94,s0_.bgImagelinkASbgImagelink_95,s0_.additionalCssASadditionalCss_96,s0_.additionalJsASadditionalJs_97,s0_.navbarEnASnavbarEn_98,s0_.teaserEnASteaserEn_99,s0_.contentEnAScontentEn_100,s0_.contentTwigEnAScontentTwigEn_101,s0_.postCtaContentEnASpostCtaContentEn_102,s0_.seoTitleEnASseoTitleEn_103,s0_.seoDescriptionEnASseoDescriptionEn_104,s0_.seoKeywordEnASseoKeywordEn_105,s0_.trainerAStrainer_106,s0_.videolinkASvideolink_107,s0_.goToPageASgoToPage_108,s0_.phrasesDeASphrasesDe_109,s0_.phrasesEnASphrasesEn_110,s0_.settingsASsettings_111,s0_.capacityAScapacity_112,s0_.asssesmentDimensionsASasssesmentDimensions_113,s0_.startASstart_114,s0_.endASend_115,s0_.pitchTopicASpitchTopic_116,s0_.pitchImageLinkASpitchImageLink_117,s0_.pitchVideoLinkASpitchVideoLink_118,s0_.pitchPartnerASpitchPartner_119,s0_.pitchPartnerIdASpitchPartnerId_120,s0_.pitchDescriptionASpitchDescription_121,s0_.followUpPageContentASfollowUpPageContent_122,s0_.followUpPageDescriptionASfollowUpPageDescription_123,s0_.followUpPageCssASfollowUpPageCss_124,s0_.followUpPageJsASfollowUpPageJs_125,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_126,s0_.followUpPageTitleASfollowUpPageTitle_127,s0_.followUpDescriptionASfollowUpDescription_128,s0_.followUpVideoLinkASfollowUpVideoLink_129,s0_.followUpPresentationASfollowUpPresentation_130,s0_.followUpSkoolUrlASfollowUpSkoolUrl_131,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_132,s0_.followUpCtaTextASfollowUpCtaText_133,s0_.followUpCtaUrlASfollowUpCtaUrl_134,s0_.followUpDocumentsASfollowUpDocuments_135,s0_.followUpPhotosASfollowUpPhotos_136,s0_.followUpExtraLinksASfollowUpExtraLinks_137,s0_.followUpChecklistASfollowUpChecklist_138,s0_.pitchDateASpitchDate_139,s0_.pitchTimeASpitchTime_140,s0_.prepitchDateASprepitchDate_141,s0_.scoutingEndDateASscoutingEndDate_142,s0_.applicationStartDateASapplicationStartDate_143,s0_.applicationEndDateASapplicationEndDate_144,s0_.interviewInviteStartDateASinterviewInviteStartDate_145,s0_.interviewInviteEndDateASinterviewInviteEndDate_146,s0_.interviewStartDateASinterviewStartDate_147,s0_.interviewEndDateASinterviewEndDate_148,s0_.decisionDateASdecisionDate_149,s0_.contractDeadlineDateAScontractDeadlineDate_150,s0_.finalReportDateASfinalReportDate_151,s0_.applicationFormStateASapplicationFormState_152,s0_.googleCalendarUrlASgoogleCalendarUrl_153,s0_.cityAScity_154,s0_.applicationsCountASapplicationsCount_155,s0_.startedCountASstartedCount_156,s0_.appliedCountASappliedCount_157,s0_.approvedCountASapprovedCount_158,s0_.rejectedCountASrejectedCount_159,s0_.$skoolWebhookASskoolWebhook_160,s0_.zapierWebhookASzapierWebhook_161,s0_.historyAShistory_162,s0_.createdAtAScreatedAt_163,s0_.lastModifiedASlastModified_164,s0_.lastChangeUserASlastChangeUser_165,s0_.programIdASprogramId_166,s0_.assessmentTeamIdASassessmentTeamId_167FROMsp_batchess0_WHERE (s0_.status='active'ANDs0_.programId=5) AND (s0_.start<'2026-08-07 17:05:36'ANDs0_.end>'2026-08-07 17:05:36') ORDER BYs0_.startASCLIMIT1;