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_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_.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_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;
4
2.18 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_.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_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_.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_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_.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_WHEREs0_.eventId=6887ANDs0_.status='active'AND (((s0_.startDateISNOTNULLANDs0_.startDate>'2026-02-27 02:13:29') OR (s0_.startDateISNULLANDs0_.pitchDate>'2026-02-27 02:13:29'))) ORDER BYs0_.startDateASC,s0_.pitchDateASCLIMIT10;
5
2.09 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_.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_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_.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_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_.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_WHEREs0_.eventId=6887AND (((s0_.startDateISNOTNULLANDs0_.startDate<'2026-02-27 02:13:29') OR (s0_.startDateISNULLANDs0_.pitchDate<'2026-02-27 02:13:29'))) 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.