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_.registrationPriceHtmlASregistrationPriceHtml_54,s0_.registrationRedirectUrlASregistrationRedirectUrl_55,s0_.lumaEventApiIdASlumaEventApiId_56,s0_.meetupEventIdASmeetupEventId_57,s0_.meetupEventUrlASmeetupEventUrl_58,s0_.mailDesignTemplateASmailDesignTemplate_59,s0_.senderMailASsenderMail_60,s0_.fromNameASfromName_61,s0_.recipientMonitoringMailASrecipientMonitoringMail_62,s0_.confirmationMailSubjectASconfirmationMailSubject_63,s0_.confirmationMailContentASconfirmationMailContent_64,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_65,s0_.adminNotificationMailContentASadminNotificationMailContent_66,s0_.reminderMailTemplateIdASreminderMailTemplateId_67,s0_.reminderSenderEmailASreminderSenderEmail_68,s0_.reminderBulkMailIdASreminderBulkMailId_69,s0_.reminderMailSendDateASreminderMailSendDate_70,s0_.reminderMailSubjectASreminderMailSubject_71,s0_.reminderMailContentASreminderMailContent_72,s0_.$reminderMailStatusASreminderMailStatus_73,s0_.surveyIdASsurveyId_74,s0_.surveyMailTemplateIdASsurveyMailTemplateId_75,s0_.surveyBulkMailIdASsurveyBulkMailId_76,s0_.templateAStemplate_77,s0_.pageTemplateASpageTemplate_78,s0_.footerTemplateASfooterTemplate_79,s0_.emailASemail_80,s0_.emailSubjectASemailSubject_81,s0_.emailContentASemailContent_82,s0_.landingPageContentASlandingPageContent_83,s0_.landingPageDescriptionASlandingPageDescription_84,s0_.landingPageCssASlandingPageCss_85,s0_.landingPageJsASlandingPageJs_86,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_87,s0_.landingPageSocialImageASlandingPageSocialImage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.titleAStitle_91,s0_.teaserASteaser_92,s0_.navbarASnavbar_93,s0_.contentAScontent_94,s0_.contentTwigAScontentTwig_95,s0_.ctaContentASctaContent_96,s0_.postCtaContentASpostCtaContent_97,s0_.taglineAStagline_98,s0_.seoTitleASseoTitle_99,s0_.seoDescriptionASseoDescription_100,s0_.seoKeywordASseoKeyword_101,s0_.imagelinkASimagelink_102,s0_.bgImagelinkASbgImagelink_103,s0_.additionalCssASadditionalCss_104,s0_.additionalJsASadditionalJs_105,s0_.navbarEnASnavbarEn_106,s0_.teaserEnASteaserEn_107,s0_.contentEnAScontentEn_108,s0_.contentTwigEnAScontentTwigEn_109,s0_.postCtaContentEnASpostCtaContentEn_110,s0_.seoTitleEnASseoTitleEn_111,s0_.seoDescriptionEnASseoDescriptionEn_112,s0_.seoKeywordEnASseoKeywordEn_113,s0_.trainerAStrainer_114,s0_.videolinkASvideolink_115,s0_.goToPageASgoToPage_116,s0_.phrasesDeASphrasesDe_117,s0_.phrasesEnASphrasesEn_118,s0_.settingsASsettings_119,s0_.capacityAScapacity_120,s0_.asssesmentDimensionsASasssesmentDimensions_121,s0_.startASstart_122,s0_.endASend_123,s0_.pitchTopicASpitchTopic_124,s0_.pitchImageLinkASpitchImageLink_125,s0_.pitchVideoLinkASpitchVideoLink_126,s0_.pitchPartnerASpitchPartner_127,s0_.pitchPartnerIdASpitchPartnerId_128,s0_.pitchDescriptionASpitchDescription_129,s0_.followUpPageContentASfollowUpPageContent_130,s0_.followUpPageDescriptionASfollowUpPageDescription_131,s0_.followUpPageCssASfollowUpPageCss_132,s0_.followUpPageJsASfollowUpPageJs_133,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_134,s0_.followUpPageTitleASfollowUpPageTitle_135,s0_.followUpPageSocialImageASfollowUpPageSocialImage_136,s0_.followUpDescriptionASfollowUpDescription_137,s0_.followUpVideoLinkASfollowUpVideoLink_138,s0_.followUpPresentationASfollowUpPresentation_139,s0_.followUpSkoolUrlASfollowUpSkoolUrl_140,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_141,s0_.followUpCtaTextASfollowUpCtaText_142,s0_.followUpCtaUrlASfollowUpCtaUrl_143,s0_.followUpDocumentsASfollowUpDocuments_144,s0_.followUpPhotosASfollowUpPhotos_145,s0_.followUpExtraLinksASfollowUpExtraLinks_146,s0_.followUpChecklistASfollowUpChecklist_147,s0_.pitchDateASpitchDate_148,s0_.pitchTimeASpitchTime_149,s0_.prepitchDateASprepitchDate_150,s0_.cityAScity_151,s0_.applicationsCountASapplicationsCount_152,s0_.startedCountASstartedCount_153,s0_.appliedCountASappliedCount_154,s0_.approvedCountASapprovedCount_155,s0_.rejectedCountASrejectedCount_156,s0_.$skoolWebhookASskoolWebhook_157,s0_.zapierWebhookASzapierWebhook_158,s0_.historyAShistory_159,s0_.createdAtAScreatedAt_160,s0_.lastModifiedASlastModified_161,s0_.lastChangeUserASlastChangeUser_162,s0_.program_idASprogram_id_163,s0_.assessmentTeamIdASassessmentTeamId_164FROMsp_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_.registrationPriceHtmlASregistrationPriceHtml_54,s0_.registrationRedirectUrlASregistrationRedirectUrl_55,s0_.lumaEventApiIdASlumaEventApiId_56,s0_.meetupEventIdASmeetupEventId_57,s0_.meetupEventUrlASmeetupEventUrl_58,s0_.mailDesignTemplateASmailDesignTemplate_59,s0_.senderMailASsenderMail_60,s0_.fromNameASfromName_61,s0_.recipientMonitoringMailASrecipientMonitoringMail_62,s0_.confirmationMailSubjectASconfirmationMailSubject_63,s0_.confirmationMailContentASconfirmationMailContent_64,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_65,s0_.adminNotificationMailContentASadminNotificationMailContent_66,s0_.reminderMailTemplateIdASreminderMailTemplateId_67,s0_.reminderSenderEmailASreminderSenderEmail_68,s0_.reminderBulkMailIdASreminderBulkMailId_69,s0_.reminderMailSendDateASreminderMailSendDate_70,s0_.reminderMailSubjectASreminderMailSubject_71,s0_.reminderMailContentASreminderMailContent_72,s0_.$reminderMailStatusASreminderMailStatus_73,s0_.surveyIdASsurveyId_74,s0_.surveyMailTemplateIdASsurveyMailTemplateId_75,s0_.surveyBulkMailIdASsurveyBulkMailId_76,s0_.templateAStemplate_77,s0_.pageTemplateASpageTemplate_78,s0_.footerTemplateASfooterTemplate_79,s0_.emailASemail_80,s0_.emailSubjectASemailSubject_81,s0_.emailContentASemailContent_82,s0_.landingPageContentASlandingPageContent_83,s0_.landingPageDescriptionASlandingPageDescription_84,s0_.landingPageCssASlandingPageCss_85,s0_.landingPageJsASlandingPageJs_86,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_87,s0_.landingPageSocialImageASlandingPageSocialImage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.titleAStitle_91,s0_.teaserASteaser_92,s0_.navbarASnavbar_93,s0_.contentAScontent_94,s0_.contentTwigAScontentTwig_95,s0_.ctaContentASctaContent_96,s0_.postCtaContentASpostCtaContent_97,s0_.taglineAStagline_98,s0_.seoTitleASseoTitle_99,s0_.seoDescriptionASseoDescription_100,s0_.seoKeywordASseoKeyword_101,s0_.imagelinkASimagelink_102,s0_.bgImagelinkASbgImagelink_103,s0_.additionalCssASadditionalCss_104,s0_.additionalJsASadditionalJs_105,s0_.navbarEnASnavbarEn_106,s0_.teaserEnASteaserEn_107,s0_.contentEnAScontentEn_108,s0_.contentTwigEnAScontentTwigEn_109,s0_.postCtaContentEnASpostCtaContentEn_110,s0_.seoTitleEnASseoTitleEn_111,s0_.seoDescriptionEnASseoDescriptionEn_112,s0_.seoKeywordEnASseoKeywordEn_113,s0_.trainerAStrainer_114,s0_.videolinkASvideolink_115,s0_.goToPageASgoToPage_116,s0_.phrasesDeASphrasesDe_117,s0_.phrasesEnASphrasesEn_118,s0_.settingsASsettings_119,s0_.capacityAScapacity_120,s0_.asssesmentDimensionsASasssesmentDimensions_121,s0_.startASstart_122,s0_.endASend_123,s0_.pitchTopicASpitchTopic_124,s0_.pitchImageLinkASpitchImageLink_125,s0_.pitchVideoLinkASpitchVideoLink_126,s0_.pitchPartnerASpitchPartner_127,s0_.pitchPartnerIdASpitchPartnerId_128,s0_.pitchDescriptionASpitchDescription_129,s0_.followUpPageContentASfollowUpPageContent_130,s0_.followUpPageDescriptionASfollowUpPageDescription_131,s0_.followUpPageCssASfollowUpPageCss_132,s0_.followUpPageJsASfollowUpPageJs_133,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_134,s0_.followUpPageTitleASfollowUpPageTitle_135,s0_.followUpPageSocialImageASfollowUpPageSocialImage_136,s0_.followUpDescriptionASfollowUpDescription_137,s0_.followUpVideoLinkASfollowUpVideoLink_138,s0_.followUpPresentationASfollowUpPresentation_139,s0_.followUpSkoolUrlASfollowUpSkoolUrl_140,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_141,s0_.followUpCtaTextASfollowUpCtaText_142,s0_.followUpCtaUrlASfollowUpCtaUrl_143,s0_.followUpDocumentsASfollowUpDocuments_144,s0_.followUpPhotosASfollowUpPhotos_145,s0_.followUpExtraLinksASfollowUpExtraLinks_146,s0_.followUpChecklistASfollowUpChecklist_147,s0_.pitchDateASpitchDate_148,s0_.pitchTimeASpitchTime_149,s0_.prepitchDateASprepitchDate_150,s0_.cityAScity_151,s0_.applicationsCountASapplicationsCount_152,s0_.startedCountASstartedCount_153,s0_.appliedCountASappliedCount_154,s0_.approvedCountASapprovedCount_155,s0_.rejectedCountASrejectedCount_156,s0_.$skoolWebhookASskoolWebhook_157,s0_.zapierWebhookASzapierWebhook_158,s0_.historyAShistory_159,s0_.createdAtAScreatedAt_160,s0_.lastModifiedASlastModified_161,s0_.lastChangeUserASlastChangeUser_162,s0_.program_idASprogram_id_163,s0_.assessmentTeamIdASassessmentTeamId_164FROMsp_batchess0_WHEREs0_.eventId=6990AND (((s0_.startDateISNOTNULLANDs0_.startDateBETWEEN'2026-04-21 00:00:00'AND'2026-04-21 23:59:59') OR (s0_.startDateISNULLANDs0_.pitchDateBETWEEN'2026-04-21 00:00:00'AND'2026-04-21 23:59:59'))) LIMIT1;
0.49 ms (6.68%)
1
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_.registrationPriceHtmlASregistrationPriceHtml_54,s0_.registrationRedirectUrlASregistrationRedirectUrl_55,s0_.lumaEventApiIdASlumaEventApiId_56,s0_.meetupEventIdASmeetupEventId_57,s0_.meetupEventUrlASmeetupEventUrl_58,s0_.mailDesignTemplateASmailDesignTemplate_59,s0_.senderMailASsenderMail_60,s0_.fromNameASfromName_61,s0_.recipientMonitoringMailASrecipientMonitoringMail_62,s0_.confirmationMailSubjectASconfirmationMailSubject_63,s0_.confirmationMailContentASconfirmationMailContent_64,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_65,s0_.adminNotificationMailContentASadminNotificationMailContent_66,s0_.reminderMailTemplateIdASreminderMailTemplateId_67,s0_.reminderSenderEmailASreminderSenderEmail_68,s0_.reminderBulkMailIdASreminderBulkMailId_69,s0_.reminderMailSendDateASreminderMailSendDate_70,s0_.reminderMailSubjectASreminderMailSubject_71,s0_.reminderMailContentASreminderMailContent_72,s0_.$reminderMailStatusASreminderMailStatus_73,s0_.surveyIdASsurveyId_74,s0_.surveyMailTemplateIdASsurveyMailTemplateId_75,s0_.surveyBulkMailIdASsurveyBulkMailId_76,s0_.templateAStemplate_77,s0_.pageTemplateASpageTemplate_78,s0_.footerTemplateASfooterTemplate_79,s0_.emailASemail_80,s0_.emailSubjectASemailSubject_81,s0_.emailContentASemailContent_82,s0_.landingPageContentASlandingPageContent_83,s0_.landingPageDescriptionASlandingPageDescription_84,s0_.landingPageCssASlandingPageCss_85,s0_.landingPageJsASlandingPageJs_86,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_87,s0_.landingPageSocialImageASlandingPageSocialImage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.titleAStitle_91,s0_.teaserASteaser_92,s0_.navbarASnavbar_93,s0_.contentAScontent_94,s0_.contentTwigAScontentTwig_95,s0_.ctaContentASctaContent_96,s0_.postCtaContentASpostCtaContent_97,s0_.taglineAStagline_98,s0_.seoTitleASseoTitle_99,s0_.seoDescriptionASseoDescription_100,s0_.seoKeywordASseoKeyword_101,s0_.imagelinkASimagelink_102,s0_.bgImagelinkASbgImagelink_103,s0_.additionalCssASadditionalCss_104,s0_.additionalJsASadditionalJs_105,s0_.navbarEnASnavbarEn_106,s0_.teaserEnASteaserEn_107,s0_.contentEnAScontentEn_108,s0_.contentTwigEnAScontentTwigEn_109,s0_.postCtaContentEnASpostCtaContentEn_110,s0_.seoTitleEnASseoTitleEn_111,s0_.seoDescriptionEnASseoDescriptionEn_112,s0_.seoKeywordEnASseoKeywordEn_113,s0_.trainerAStrainer_114,s0_.videolinkASvideolink_115,s0_.goToPageASgoToPage_116,s0_.phrasesDeASphrasesDe_117,s0_.phrasesEnASphrasesEn_118,s0_.settingsASsettings_119,s0_.capacityAScapacity_120,s0_.asssesmentDimensionsASasssesmentDimensions_121,s0_.startASstart_122,s0_.endASend_123,s0_.pitchTopicASpitchTopic_124,s0_.pitchImageLinkASpitchImageLink_125,s0_.pitchVideoLinkASpitchVideoLink_126,s0_.pitchPartnerASpitchPartner_127,s0_.pitchPartnerIdASpitchPartnerId_128,s0_.pitchDescriptionASpitchDescription_129,s0_.followUpPageContentASfollowUpPageContent_130,s0_.followUpPageDescriptionASfollowUpPageDescription_131,s0_.followUpPageCssASfollowUpPageCss_132,s0_.followUpPageJsASfollowUpPageJs_133,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_134,s0_.followUpPageTitleASfollowUpPageTitle_135,s0_.followUpPageSocialImageASfollowUpPageSocialImage_136,s0_.followUpDescriptionASfollowUpDescription_137,s0_.followUpVideoLinkASfollowUpVideoLink_138,s0_.followUpPresentationASfollowUpPresentation_139,s0_.followUpSkoolUrlASfollowUpSkoolUrl_140,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_141,s0_.followUpCtaTextASfollowUpCtaText_142,s0_.followUpCtaUrlASfollowUpCtaUrl_143,s0_.followUpDocumentsASfollowUpDocuments_144,s0_.followUpPhotosASfollowUpPhotos_145,s0_.followUpExtraLinksASfollowUpExtraLinks_146,s0_.followUpChecklistASfollowUpChecklist_147,s0_.pitchDateASpitchDate_148,s0_.pitchTimeASpitchTime_149,s0_.prepitchDateASprepitchDate_150,s0_.cityAScity_151,s0_.applicationsCountASapplicationsCount_152,s0_.startedCountASstartedCount_153,s0_.appliedCountASappliedCount_154,s0_.approvedCountASapprovedCount_155,s0_.rejectedCountASrejectedCount_156,s0_.$skoolWebhookASskoolWebhook_157,s0_.zapierWebhookASzapierWebhook_158,s0_.historyAShistory_159,s0_.createdAtAScreatedAt_160,s0_.lastModifiedASlastModified_161,s0_.lastChangeUserASlastChangeUser_162,s0_.program_idASprogram_id_163,s0_.assessmentTeamIdASassessmentTeamId_164FROMsp_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_.registrationPriceHtmlASregistrationPriceHtml_54,s0_.registrationRedirectUrlASregistrationRedirectUrl_55,s0_.lumaEventApiIdASlumaEventApiId_56,s0_.meetupEventIdASmeetupEventId_57,s0_.meetupEventUrlASmeetupEventUrl_58,s0_.mailDesignTemplateASmailDesignTemplate_59,s0_.senderMailASsenderMail_60,s0_.fromNameASfromName_61,s0_.recipientMonitoringMailASrecipientMonitoringMail_62,s0_.confirmationMailSubjectASconfirmationMailSubject_63,s0_.confirmationMailContentASconfirmationMailContent_64,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_65,s0_.adminNotificationMailContentASadminNotificationMailContent_66,s0_.reminderMailTemplateIdASreminderMailTemplateId_67,s0_.reminderSenderEmailASreminderSenderEmail_68,s0_.reminderBulkMailIdASreminderBulkMailId_69,s0_.reminderMailSendDateASreminderMailSendDate_70,s0_.reminderMailSubjectASreminderMailSubject_71,s0_.reminderMailContentASreminderMailContent_72,s0_.$reminderMailStatusASreminderMailStatus_73,s0_.surveyIdASsurveyId_74,s0_.surveyMailTemplateIdASsurveyMailTemplateId_75,s0_.surveyBulkMailIdASsurveyBulkMailId_76,s0_.templateAStemplate_77,s0_.pageTemplateASpageTemplate_78,s0_.footerTemplateASfooterTemplate_79,s0_.emailASemail_80,s0_.emailSubjectASemailSubject_81,s0_.emailContentASemailContent_82,s0_.landingPageContentASlandingPageContent_83,s0_.landingPageDescriptionASlandingPageDescription_84,s0_.landingPageCssASlandingPageCss_85,s0_.landingPageJsASlandingPageJs_86,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_87,s0_.landingPageSocialImageASlandingPageSocialImage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.titleAStitle_91,s0_.teaserASteaser_92,s0_.navbarASnavbar_93,s0_.contentAScontent_94,s0_.contentTwigAScontentTwig_95,s0_.ctaContentASctaContent_96,s0_.postCtaContentASpostCtaContent_97,s0_.taglineAStagline_98,s0_.seoTitleASseoTitle_99,s0_.seoDescriptionASseoDescription_100,s0_.seoKeywordASseoKeyword_101,s0_.imagelinkASimagelink_102,s0_.bgImagelinkASbgImagelink_103,s0_.additionalCssASadditionalCss_104,s0_.additionalJsASadditionalJs_105,s0_.navbarEnASnavbarEn_106,s0_.teaserEnASteaserEn_107,s0_.contentEnAScontentEn_108,s0_.contentTwigEnAScontentTwigEn_109,s0_.postCtaContentEnASpostCtaContentEn_110,s0_.seoTitleEnASseoTitleEn_111,s0_.seoDescriptionEnASseoDescriptionEn_112,s0_.seoKeywordEnASseoKeywordEn_113,s0_.trainerAStrainer_114,s0_.videolinkASvideolink_115,s0_.goToPageASgoToPage_116,s0_.phrasesDeASphrasesDe_117,s0_.phrasesEnASphrasesEn_118,s0_.settingsASsettings_119,s0_.capacityAScapacity_120,s0_.asssesmentDimensionsASasssesmentDimensions_121,s0_.startASstart_122,s0_.endASend_123,s0_.pitchTopicASpitchTopic_124,s0_.pitchImageLinkASpitchImageLink_125,s0_.pitchVideoLinkASpitchVideoLink_126,s0_.pitchPartnerASpitchPartner_127,s0_.pitchPartnerIdASpitchPartnerId_128,s0_.pitchDescriptionASpitchDescription_129,s0_.followUpPageContentASfollowUpPageContent_130,s0_.followUpPageDescriptionASfollowUpPageDescription_131,s0_.followUpPageCssASfollowUpPageCss_132,s0_.followUpPageJsASfollowUpPageJs_133,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_134,s0_.followUpPageTitleASfollowUpPageTitle_135,s0_.followUpPageSocialImageASfollowUpPageSocialImage_136,s0_.followUpDescriptionASfollowUpDescription_137,s0_.followUpVideoLinkASfollowUpVideoLink_138,s0_.followUpPresentationASfollowUpPresentation_139,s0_.followUpSkoolUrlASfollowUpSkoolUrl_140,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_141,s0_.followUpCtaTextASfollowUpCtaText_142,s0_.followUpCtaUrlASfollowUpCtaUrl_143,s0_.followUpDocumentsASfollowUpDocuments_144,s0_.followUpPhotosASfollowUpPhotos_145,s0_.followUpExtraLinksASfollowUpExtraLinks_146,s0_.followUpChecklistASfollowUpChecklist_147,s0_.pitchDateASpitchDate_148,s0_.pitchTimeASpitchTime_149,s0_.prepitchDateASprepitchDate_150,s0_.cityAScity_151,s0_.applicationsCountASapplicationsCount_152,s0_.startedCountASstartedCount_153,s0_.appliedCountASappliedCount_154,s0_.approvedCountASapprovedCount_155,s0_.rejectedCountASrejectedCount_156,s0_.$skoolWebhookASskoolWebhook_157,s0_.zapierWebhookASzapierWebhook_158,s0_.historyAShistory_159,s0_.createdAtAScreatedAt_160,s0_.lastModifiedASlastModified_161,s0_.lastChangeUserASlastChangeUser_162,s0_.program_idASprogram_id_163,s0_.assessmentTeamIdASassessmentTeamId_164FROMsp_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_.registrationPriceHtmlASregistrationPriceHtml_54,s0_.registrationRedirectUrlASregistrationRedirectUrl_55,s0_.lumaEventApiIdASlumaEventApiId_56,s0_.meetupEventIdASmeetupEventId_57,s0_.meetupEventUrlASmeetupEventUrl_58,s0_.mailDesignTemplateASmailDesignTemplate_59,s0_.senderMailASsenderMail_60,s0_.fromNameASfromName_61,s0_.recipientMonitoringMailASrecipientMonitoringMail_62,s0_.confirmationMailSubjectASconfirmationMailSubject_63,s0_.confirmationMailContentASconfirmationMailContent_64,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_65,s0_.adminNotificationMailContentASadminNotificationMailContent_66,s0_.reminderMailTemplateIdASreminderMailTemplateId_67,s0_.reminderSenderEmailASreminderSenderEmail_68,s0_.reminderBulkMailIdASreminderBulkMailId_69,s0_.reminderMailSendDateASreminderMailSendDate_70,s0_.reminderMailSubjectASreminderMailSubject_71,s0_.reminderMailContentASreminderMailContent_72,s0_.$reminderMailStatusASreminderMailStatus_73,s0_.surveyIdASsurveyId_74,s0_.surveyMailTemplateIdASsurveyMailTemplateId_75,s0_.surveyBulkMailIdASsurveyBulkMailId_76,s0_.templateAStemplate_77,s0_.pageTemplateASpageTemplate_78,s0_.footerTemplateASfooterTemplate_79,s0_.emailASemail_80,s0_.emailSubjectASemailSubject_81,s0_.emailContentASemailContent_82,s0_.landingPageContentASlandingPageContent_83,s0_.landingPageDescriptionASlandingPageDescription_84,s0_.landingPageCssASlandingPageCss_85,s0_.landingPageJsASlandingPageJs_86,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_87,s0_.landingPageSocialImageASlandingPageSocialImage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.titleAStitle_91,s0_.teaserASteaser_92,s0_.navbarASnavbar_93,s0_.contentAScontent_94,s0_.contentTwigAScontentTwig_95,s0_.ctaContentASctaContent_96,s0_.postCtaContentASpostCtaContent_97,s0_.taglineAStagline_98,s0_.seoTitleASseoTitle_99,s0_.seoDescriptionASseoDescription_100,s0_.seoKeywordASseoKeyword_101,s0_.imagelinkASimagelink_102,s0_.bgImagelinkASbgImagelink_103,s0_.additionalCssASadditionalCss_104,s0_.additionalJsASadditionalJs_105,s0_.navbarEnASnavbarEn_106,s0_.teaserEnASteaserEn_107,s0_.contentEnAScontentEn_108,s0_.contentTwigEnAScontentTwigEn_109,s0_.postCtaContentEnASpostCtaContentEn_110,s0_.seoTitleEnASseoTitleEn_111,s0_.seoDescriptionEnASseoDescriptionEn_112,s0_.seoKeywordEnASseoKeywordEn_113,s0_.trainerAStrainer_114,s0_.videolinkASvideolink_115,s0_.goToPageASgoToPage_116,s0_.phrasesDeASphrasesDe_117,s0_.phrasesEnASphrasesEn_118,s0_.settingsASsettings_119,s0_.capacityAScapacity_120,s0_.asssesmentDimensionsASasssesmentDimensions_121,s0_.startASstart_122,s0_.endASend_123,s0_.pitchTopicASpitchTopic_124,s0_.pitchImageLinkASpitchImageLink_125,s0_.pitchVideoLinkASpitchVideoLink_126,s0_.pitchPartnerASpitchPartner_127,s0_.pitchPartnerIdASpitchPartnerId_128,s0_.pitchDescriptionASpitchDescription_129,s0_.followUpPageContentASfollowUpPageContent_130,s0_.followUpPageDescriptionASfollowUpPageDescription_131,s0_.followUpPageCssASfollowUpPageCss_132,s0_.followUpPageJsASfollowUpPageJs_133,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_134,s0_.followUpPageTitleASfollowUpPageTitle_135,s0_.followUpPageSocialImageASfollowUpPageSocialImage_136,s0_.followUpDescriptionASfollowUpDescription_137,s0_.followUpVideoLinkASfollowUpVideoLink_138,s0_.followUpPresentationASfollowUpPresentation_139,s0_.followUpSkoolUrlASfollowUpSkoolUrl_140,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_141,s0_.followUpCtaTextASfollowUpCtaText_142,s0_.followUpCtaUrlASfollowUpCtaUrl_143,s0_.followUpDocumentsASfollowUpDocuments_144,s0_.followUpPhotosASfollowUpPhotos_145,s0_.followUpExtraLinksASfollowUpExtraLinks_146,s0_.followUpChecklistASfollowUpChecklist_147,s0_.pitchDateASpitchDate_148,s0_.pitchTimeASpitchTime_149,s0_.prepitchDateASprepitchDate_150,s0_.cityAScity_151,s0_.applicationsCountASapplicationsCount_152,s0_.startedCountASstartedCount_153,s0_.appliedCountASappliedCount_154,s0_.approvedCountASapprovedCount_155,s0_.rejectedCountASrejectedCount_156,s0_.$skoolWebhookASskoolWebhook_157,s0_.zapierWebhookASzapierWebhook_158,s0_.historyAShistory_159,s0_.createdAtAScreatedAt_160,s0_.lastModifiedASlastModified_161,s0_.lastChangeUserASlastChangeUser_162,s0_.program_idASprogram_id_163,s0_.assessmentTeamIdASassessmentTeamId_164FROMsp_batchess0_WHEREs0_.eventId=6990AND (((s0_.startDateISNOTNULLANDs0_.startDate<'2026-04-22 02:21:21') OR (s0_.startDateISNULLANDs0_.pitchDate<'2026-04-22 02:21:21'))) ORDER BYs0_.startDateDESC,s0_.pitchDateDESCLIMIT10;
0.49 ms (6.66%)
1
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_.registrationPriceHtmlASregistrationPriceHtml_54,s0_.registrationRedirectUrlASregistrationRedirectUrl_55,s0_.lumaEventApiIdASlumaEventApiId_56,s0_.meetupEventIdASmeetupEventId_57,s0_.meetupEventUrlASmeetupEventUrl_58,s0_.mailDesignTemplateASmailDesignTemplate_59,s0_.senderMailASsenderMail_60,s0_.fromNameASfromName_61,s0_.recipientMonitoringMailASrecipientMonitoringMail_62,s0_.confirmationMailSubjectASconfirmationMailSubject_63,s0_.confirmationMailContentASconfirmationMailContent_64,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_65,s0_.adminNotificationMailContentASadminNotificationMailContent_66,s0_.reminderMailTemplateIdASreminderMailTemplateId_67,s0_.reminderSenderEmailASreminderSenderEmail_68,s0_.reminderBulkMailIdASreminderBulkMailId_69,s0_.reminderMailSendDateASreminderMailSendDate_70,s0_.reminderMailSubjectASreminderMailSubject_71,s0_.reminderMailContentASreminderMailContent_72,s0_.$reminderMailStatusASreminderMailStatus_73,s0_.surveyIdASsurveyId_74,s0_.surveyMailTemplateIdASsurveyMailTemplateId_75,s0_.surveyBulkMailIdASsurveyBulkMailId_76,s0_.templateAStemplate_77,s0_.pageTemplateASpageTemplate_78,s0_.footerTemplateASfooterTemplate_79,s0_.emailASemail_80,s0_.emailSubjectASemailSubject_81,s0_.emailContentASemailContent_82,s0_.landingPageContentASlandingPageContent_83,s0_.landingPageDescriptionASlandingPageDescription_84,s0_.landingPageCssASlandingPageCss_85,s0_.landingPageJsASlandingPageJs_86,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_87,s0_.landingPageSocialImageASlandingPageSocialImage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.titleAStitle_91,s0_.teaserASteaser_92,s0_.navbarASnavbar_93,s0_.contentAScontent_94,s0_.contentTwigAScontentTwig_95,s0_.ctaContentASctaContent_96,s0_.postCtaContentASpostCtaContent_97,s0_.taglineAStagline_98,s0_.seoTitleASseoTitle_99,s0_.seoDescriptionASseoDescription_100,s0_.seoKeywordASseoKeyword_101,s0_.imagelinkASimagelink_102,s0_.bgImagelinkASbgImagelink_103,s0_.additionalCssASadditionalCss_104,s0_.additionalJsASadditionalJs_105,s0_.navbarEnASnavbarEn_106,s0_.teaserEnASteaserEn_107,s0_.contentEnAScontentEn_108,s0_.contentTwigEnAScontentTwigEn_109,s0_.postCtaContentEnASpostCtaContentEn_110,s0_.seoTitleEnASseoTitleEn_111,s0_.seoDescriptionEnASseoDescriptionEn_112,s0_.seoKeywordEnASseoKeywordEn_113,s0_.trainerAStrainer_114,s0_.videolinkASvideolink_115,s0_.goToPageASgoToPage_116,s0_.phrasesDeASphrasesDe_117,s0_.phrasesEnASphrasesEn_118,s0_.settingsASsettings_119,s0_.capacityAScapacity_120,s0_.asssesmentDimensionsASasssesmentDimensions_121,s0_.startASstart_122,s0_.endASend_123,s0_.pitchTopicASpitchTopic_124,s0_.pitchImageLinkASpitchImageLink_125,s0_.pitchVideoLinkASpitchVideoLink_126,s0_.pitchPartnerASpitchPartner_127,s0_.pitchPartnerIdASpitchPartnerId_128,s0_.pitchDescriptionASpitchDescription_129,s0_.followUpPageContentASfollowUpPageContent_130,s0_.followUpPageDescriptionASfollowUpPageDescription_131,s0_.followUpPageCssASfollowUpPageCss_132,s0_.followUpPageJsASfollowUpPageJs_133,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_134,s0_.followUpPageTitleASfollowUpPageTitle_135,s0_.followUpPageSocialImageASfollowUpPageSocialImage_136,s0_.followUpDescriptionASfollowUpDescription_137,s0_.followUpVideoLinkASfollowUpVideoLink_138,s0_.followUpPresentationASfollowUpPresentation_139,s0_.followUpSkoolUrlASfollowUpSkoolUrl_140,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_141,s0_.followUpCtaTextASfollowUpCtaText_142,s0_.followUpCtaUrlASfollowUpCtaUrl_143,s0_.followUpDocumentsASfollowUpDocuments_144,s0_.followUpPhotosASfollowUpPhotos_145,s0_.followUpExtraLinksASfollowUpExtraLinks_146,s0_.followUpChecklistASfollowUpChecklist_147,s0_.pitchDateASpitchDate_148,s0_.pitchTimeASpitchTime_149,s0_.prepitchDateASprepitchDate_150,s0_.cityAScity_151,s0_.applicationsCountASapplicationsCount_152,s0_.startedCountASstartedCount_153,s0_.appliedCountASappliedCount_154,s0_.approvedCountASapprovedCount_155,s0_.rejectedCountASrejectedCount_156,s0_.$skoolWebhookASskoolWebhook_157,s0_.zapierWebhookASzapierWebhook_158,s0_.historyAShistory_159,s0_.createdAtAScreatedAt_160,s0_.lastModifiedASlastModified_161,s0_.lastChangeUserASlastChangeUser_162,s0_.program_idASprogram_id_163,s0_.assessmentTeamIdASassessmentTeamId_164FROMsp_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_.registrationPriceHtmlASregistrationPriceHtml_54,s0_.registrationRedirectUrlASregistrationRedirectUrl_55,s0_.lumaEventApiIdASlumaEventApiId_56,s0_.meetupEventIdASmeetupEventId_57,s0_.meetupEventUrlASmeetupEventUrl_58,s0_.mailDesignTemplateASmailDesignTemplate_59,s0_.senderMailASsenderMail_60,s0_.fromNameASfromName_61,s0_.recipientMonitoringMailASrecipientMonitoringMail_62,s0_.confirmationMailSubjectASconfirmationMailSubject_63,s0_.confirmationMailContentASconfirmationMailContent_64,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_65,s0_.adminNotificationMailContentASadminNotificationMailContent_66,s0_.reminderMailTemplateIdASreminderMailTemplateId_67,s0_.reminderSenderEmailASreminderSenderEmail_68,s0_.reminderBulkMailIdASreminderBulkMailId_69,s0_.reminderMailSendDateASreminderMailSendDate_70,s0_.reminderMailSubjectASreminderMailSubject_71,s0_.reminderMailContentASreminderMailContent_72,s0_.$reminderMailStatusASreminderMailStatus_73,s0_.surveyIdASsurveyId_74,s0_.surveyMailTemplateIdASsurveyMailTemplateId_75,s0_.surveyBulkMailIdASsurveyBulkMailId_76,s0_.templateAStemplate_77,s0_.pageTemplateASpageTemplate_78,s0_.footerTemplateASfooterTemplate_79,s0_.emailASemail_80,s0_.emailSubjectASemailSubject_81,s0_.emailContentASemailContent_82,s0_.landingPageContentASlandingPageContent_83,s0_.landingPageDescriptionASlandingPageDescription_84,s0_.landingPageCssASlandingPageCss_85,s0_.landingPageJsASlandingPageJs_86,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_87,s0_.landingPageSocialImageASlandingPageSocialImage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.titleAStitle_91,s0_.teaserASteaser_92,s0_.navbarASnavbar_93,s0_.contentAScontent_94,s0_.contentTwigAScontentTwig_95,s0_.ctaContentASctaContent_96,s0_.postCtaContentASpostCtaContent_97,s0_.taglineAStagline_98,s0_.seoTitleASseoTitle_99,s0_.seoDescriptionASseoDescription_100,s0_.seoKeywordASseoKeyword_101,s0_.imagelinkASimagelink_102,s0_.bgImagelinkASbgImagelink_103,s0_.additionalCssASadditionalCss_104,s0_.additionalJsASadditionalJs_105,s0_.navbarEnASnavbarEn_106,s0_.teaserEnASteaserEn_107,s0_.contentEnAScontentEn_108,s0_.contentTwigEnAScontentTwigEn_109,s0_.postCtaContentEnASpostCtaContentEn_110,s0_.seoTitleEnASseoTitleEn_111,s0_.seoDescriptionEnASseoDescriptionEn_112,s0_.seoKeywordEnASseoKeywordEn_113,s0_.trainerAStrainer_114,s0_.videolinkASvideolink_115,s0_.goToPageASgoToPage_116,s0_.phrasesDeASphrasesDe_117,s0_.phrasesEnASphrasesEn_118,s0_.settingsASsettings_119,s0_.capacityAScapacity_120,s0_.asssesmentDimensionsASasssesmentDimensions_121,s0_.startASstart_122,s0_.endASend_123,s0_.pitchTopicASpitchTopic_124,s0_.pitchImageLinkASpitchImageLink_125,s0_.pitchVideoLinkASpitchVideoLink_126,s0_.pitchPartnerASpitchPartner_127,s0_.pitchPartnerIdASpitchPartnerId_128,s0_.pitchDescriptionASpitchDescription_129,s0_.followUpPageContentASfollowUpPageContent_130,s0_.followUpPageDescriptionASfollowUpPageDescription_131,s0_.followUpPageCssASfollowUpPageCss_132,s0_.followUpPageJsASfollowUpPageJs_133,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_134,s0_.followUpPageTitleASfollowUpPageTitle_135,s0_.followUpPageSocialImageASfollowUpPageSocialImage_136,s0_.followUpDescriptionASfollowUpDescription_137,s0_.followUpVideoLinkASfollowUpVideoLink_138,s0_.followUpPresentationASfollowUpPresentation_139,s0_.followUpSkoolUrlASfollowUpSkoolUrl_140,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_141,s0_.followUpCtaTextASfollowUpCtaText_142,s0_.followUpCtaUrlASfollowUpCtaUrl_143,s0_.followUpDocumentsASfollowUpDocuments_144,s0_.followUpPhotosASfollowUpPhotos_145,s0_.followUpExtraLinksASfollowUpExtraLinks_146,s0_.followUpChecklistASfollowUpChecklist_147,s0_.pitchDateASpitchDate_148,s0_.pitchTimeASpitchTime_149,s0_.prepitchDateASprepitchDate_150,s0_.cityAScity_151,s0_.applicationsCountASapplicationsCount_152,s0_.startedCountASstartedCount_153,s0_.appliedCountASappliedCount_154,s0_.approvedCountASapprovedCount_155,s0_.rejectedCountASrejectedCount_156,s0_.$skoolWebhookASskoolWebhook_157,s0_.zapierWebhookASzapierWebhook_158,s0_.historyAShistory_159,s0_.createdAtAScreatedAt_160,s0_.lastModifiedASlastModified_161,s0_.lastChangeUserASlastChangeUser_162,s0_.program_idASprogram_id_163,s0_.assessmentTeamIdASassessmentTeamId_164FROMsp_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_.registrationPriceHtmlASregistrationPriceHtml_54,s0_.registrationRedirectUrlASregistrationRedirectUrl_55,s0_.lumaEventApiIdASlumaEventApiId_56,s0_.meetupEventIdASmeetupEventId_57,s0_.meetupEventUrlASmeetupEventUrl_58,s0_.mailDesignTemplateASmailDesignTemplate_59,s0_.senderMailASsenderMail_60,s0_.fromNameASfromName_61,s0_.recipientMonitoringMailASrecipientMonitoringMail_62,s0_.confirmationMailSubjectASconfirmationMailSubject_63,s0_.confirmationMailContentASconfirmationMailContent_64,s0_.adminNotificationMailSubjectASadminNotificationMailSubject_65,s0_.adminNotificationMailContentASadminNotificationMailContent_66,s0_.reminderMailTemplateIdASreminderMailTemplateId_67,s0_.reminderSenderEmailASreminderSenderEmail_68,s0_.reminderBulkMailIdASreminderBulkMailId_69,s0_.reminderMailSendDateASreminderMailSendDate_70,s0_.reminderMailSubjectASreminderMailSubject_71,s0_.reminderMailContentASreminderMailContent_72,s0_.$reminderMailStatusASreminderMailStatus_73,s0_.surveyIdASsurveyId_74,s0_.surveyMailTemplateIdASsurveyMailTemplateId_75,s0_.surveyBulkMailIdASsurveyBulkMailId_76,s0_.templateAStemplate_77,s0_.pageTemplateASpageTemplate_78,s0_.footerTemplateASfooterTemplate_79,s0_.emailASemail_80,s0_.emailSubjectASemailSubject_81,s0_.emailContentASemailContent_82,s0_.landingPageContentASlandingPageContent_83,s0_.landingPageDescriptionASlandingPageDescription_84,s0_.landingPageCssASlandingPageCss_85,s0_.landingPageJsASlandingPageJs_86,s0_.landingPageFooterTemplateASlandingPageFooterTemplate_87,s0_.landingPageSocialImageASlandingPageSocialImage_88,s0_.landingPageTitleASlandingPageTitle_89,s0_.landingPageTwigASlandingPageTwig_90,s0_.titleAStitle_91,s0_.teaserASteaser_92,s0_.navbarASnavbar_93,s0_.contentAScontent_94,s0_.contentTwigAScontentTwig_95,s0_.ctaContentASctaContent_96,s0_.postCtaContentASpostCtaContent_97,s0_.taglineAStagline_98,s0_.seoTitleASseoTitle_99,s0_.seoDescriptionASseoDescription_100,s0_.seoKeywordASseoKeyword_101,s0_.imagelinkASimagelink_102,s0_.bgImagelinkASbgImagelink_103,s0_.additionalCssASadditionalCss_104,s0_.additionalJsASadditionalJs_105,s0_.navbarEnASnavbarEn_106,s0_.teaserEnASteaserEn_107,s0_.contentEnAScontentEn_108,s0_.contentTwigEnAScontentTwigEn_109,s0_.postCtaContentEnASpostCtaContentEn_110,s0_.seoTitleEnASseoTitleEn_111,s0_.seoDescriptionEnASseoDescriptionEn_112,s0_.seoKeywordEnASseoKeywordEn_113,s0_.trainerAStrainer_114,s0_.videolinkASvideolink_115,s0_.goToPageASgoToPage_116,s0_.phrasesDeASphrasesDe_117,s0_.phrasesEnASphrasesEn_118,s0_.settingsASsettings_119,s0_.capacityAScapacity_120,s0_.asssesmentDimensionsASasssesmentDimensions_121,s0_.startASstart_122,s0_.endASend_123,s0_.pitchTopicASpitchTopic_124,s0_.pitchImageLinkASpitchImageLink_125,s0_.pitchVideoLinkASpitchVideoLink_126,s0_.pitchPartnerASpitchPartner_127,s0_.pitchPartnerIdASpitchPartnerId_128,s0_.pitchDescriptionASpitchDescription_129,s0_.followUpPageContentASfollowUpPageContent_130,s0_.followUpPageDescriptionASfollowUpPageDescription_131,s0_.followUpPageCssASfollowUpPageCss_132,s0_.followUpPageJsASfollowUpPageJs_133,s0_.followUpPageFooterTemplateASfollowUpPageFooterTemplate_134,s0_.followUpPageTitleASfollowUpPageTitle_135,s0_.followUpPageSocialImageASfollowUpPageSocialImage_136,s0_.followUpDescriptionASfollowUpDescription_137,s0_.followUpVideoLinkASfollowUpVideoLink_138,s0_.followUpPresentationASfollowUpPresentation_139,s0_.followUpSkoolUrlASfollowUpSkoolUrl_140,s0_.followUpWhatsAppUrlASfollowUpWhatsAppUrl_141,s0_.followUpCtaTextASfollowUpCtaText_142,s0_.followUpCtaUrlASfollowUpCtaUrl_143,s0_.followUpDocumentsASfollowUpDocuments_144,s0_.followUpPhotosASfollowUpPhotos_145,s0_.followUpExtraLinksASfollowUpExtraLinks_146,s0_.followUpChecklistASfollowUpChecklist_147,s0_.pitchDateASpitchDate_148,s0_.pitchTimeASpitchTime_149,s0_.prepitchDateASprepitchDate_150,s0_.cityAScity_151,s0_.applicationsCountASapplicationsCount_152,s0_.startedCountASstartedCount_153,s0_.appliedCountASappliedCount_154,s0_.approvedCountASapprovedCount_155,s0_.rejectedCountASrejectedCount_156,s0_.$skoolWebhookASskoolWebhook_157,s0_.zapierWebhookASzapierWebhook_158,s0_.historyAShistory_159,s0_.createdAtAScreatedAt_160,s0_.lastModifiedASlastModified_161,s0_.lastChangeUserASlastChangeUser_162,s0_.program_idASprogram_id_163,s0_.assessmentTeamIdASassessmentTeamId_164FROMsp_batchess0_WHEREs0_.eventId=6990ANDs0_.status='active'AND (((s0_.startDateISNOTNULLANDs0_.startDate>='2026-04-22 00:00:00') OR (s0_.startDateISNULLANDs0_.pitchDate>='2026-04-22 00:00:00'))) ORDER BYs0_.startDateASC,s0_.pitchDateASCLIMIT10;
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.