Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

16 Database Queries

10 Different statements

85.57 ms Query time

1 Invalid entities

Queries

Group similar statements


SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ?
SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.startDate IS NOT NULL AND s0_.startDate > ?) OR (s0_.startDate IS NULL AND s0_.pitchDate > ?)) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1
SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.startDate IS NOT NULL AND s0_.startDate > ?) OR (s0_.startDate IS NULL AND s0_.pitchDate > ?)) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ?
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.startDate IS NOT NULL AND s0_.startDate > ?) OR (s0_.startDate IS NULL AND s0_.pitchDate > ?))
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ?
SELECT COUNT(s0_.id) AS sclr_0 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?))
SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1
SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1
SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1
SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1
SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1
SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND s0_.access = ? AND ((s0_.startDate IS NOT NULL AND s0_.startDate > ?) OR (s0_.startDate IS NULL AND s0_.pitchDate > ?)) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1
SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                COALESCE(b.startDate, b.pitchDate) as batch_date,
                b.endDate as batch_end_date,
                b.status as batch_status,
                e.id as event_id,
                e.title as event_title,
                e.slug as event_slug,
                e.location,
                e.venueName,
                e.trainer,
                e.isMultiBatchEvent
            FROM sp_event_events e
            INNER JOIN sp_batches b ON b.eventId = e.id
            WHERE e.seriesTag = :seriesTag
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND (
                (b.startDate IS NOT NULL AND b.startDate > NOW()) OR 
                (b.startDate IS NULL AND b.pitchDate > NOW())
            )
         ORDER BY COALESCE(b.startDate, b.pitchDate) ASC
SELECT 
                b.id as batch_id,
                b.eventId as event_id,
                b.name as batch_name,
                b.slug as batch_slug,
                COALESCE(b.endDate, b.startDate, b.pitchDate) as batch_date,
                b.endDate as batch_end_date,
                b.status as batch_status,
                e.id as event_id,
                e.title as event_title,
                e.slug as event_slug,
                e.location,
                e.venueName,
                e.trainer,
                e.isMultiBatchEvent
            FROM sp_event_events e
            INNER JOIN sp_batches b ON b.eventId = e.id
            WHERE e.seriesTag = :seriesTag
            AND e.status = 'publish'
            AND b.status = 'active'
            AND e.isMultiBatchEvent = 1
            AND (
                (b.endDate IS NOT NULL AND b.endDate < NOW()) OR
                (b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW()) OR
                (b.startDate IS NULL AND b.pitchDate < NOW())
            )
         ORDER BY COALESCE(b.endDate, b.startDate, b.pitchDate) DESC
SELECT t0.id AS id_1, t0.spMemberId AS spMemberId_2, t0.score AS score_3, t0.completenessScore AS completenessScore_4, t0.status AS status_5, t0.location AS location_6, t0.salutation AS salutation_7, t0.title AS title_8, t0.jobTitle AS jobTitle_9, t0.firstName AS firstName_10, t0.lastName AS lastName_11, t0.name AS name_12, t0.sortName AS sortName_13, t0.email AS email_14, t0.secondaryEmail AS secondaryEmail_15, t0.phone AS phone_16, t0.hasCommunityMembership AS hasCommunityMembership_17, t0.aiMemberValid AS aiMemberValid_18, t0.aiMemberStatus AS aiMemberStatus_19, t0.aiMemberReason AS aiMemberReason_20, t0.aiMemberStart AS aiMemberStart_21, t0.aiMemberEnd AS aiMemberEnd_22, t0.utm_source AS utm_source_23, t0.utm_medium AS utm_medium_24, t0.utm_campaign AS utm_campaign_25, t0.utm_term AS utm_term_26, t0.utm_content AS utm_content_27, t0.birthday AS birthday_28, t0.addressFieldOne AS addressFieldOne_29, t0.addressFieldTwo AS addressFieldTwo_30, t0.addressCountryCode AS addressCountryCode_31, t0.addressPostalCode AS addressPostalCode_32, t0.addressCity AS addressCity_33, t0.teamId AS teamId_34, t0.teamName AS teamName_35, t0.company AS company_36, t0.history AS history_37, t0.tags AS tags_38, t0.annotation AS annotation_39, t0.mentorBuckets AS mentorBuckets_40, t0.areasOfExpertise AS areasOfExpertise_41, t0.mentor_firma AS mentor_firma_42, t0.mentor_firma_url AS mentor_firma_url_43, t0.mentor_locations AS mentor_locations_44, t0.mentor_profile AS mentor_profile_45, t0.mentor_note AS mentor_note_46, t0.mentor_admin_rating AS mentor_admin_rating_47, t0.active AS active_48, t0.tiefgarage AS tiefgarage_49, t0.transponder AS transponder_50, t0.isTransponderAllowed AS isTransponderAllowed_51, t0.imageLink AS imageLink_52, t0.homepage AS homepage_53, t0.xing AS xing_54, t0.pipedriveId AS pipedriveId_55, t0.linkedin AS linkedin_56, t0.facebook AS facebook_57, t0.instagram AS instagram_58, t0.twitter AS twitter_59, t0.skills AS skills_60, t0.description AS description_61, t0.touchpoints AS touchpoints_62, t0.isAddressComplete AS isAddressComplete_63, t0.hasMailchimp AS hasMailchimp_64, t0.hasKiNewsletter AS hasKiNewsletter_65, t0.hubspotSyncPending AS hubspotSyncPending_66, t0.enterDate AS enterDate_67, t0.exitDate AS exitDate_68, t0.physicalMembershipStarted AS physicalMembershipStarted_69, t0.physicalMembershipEnded AS physicalMembershipEnded_70, t0.lastModified AS lastModified_71, t0.lastChangeUser AS lastChangeUser_72, t0.nAiWebinarsAttended AS nAiWebinarsAttended_73, t0.nAiWebinarsApplied AS nAiWebinarsApplied_74, t0.nAiEventsAttended AS nAiEventsAttended_75, t0.nAiEventsApplied AS nAiEventsApplied_76, t0.nPaidAttended AS nPaidAttended_77, t0.nPaidApplied AS nPaidApplied_78, t0.nKiEinstiegAttended AS nKiEinstiegAttended_79, t0.nKiEinstiegApplied AS nKiEinstiegApplied_80, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_81, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_82, t0.nEcodynamicsAttended AS nEcodynamicsAttended_83, t0.nEcodynamicsApplied AS nEcodynamicsApplied_84, t0.nBbqApplied AS nBbqApplied_85, t0.nAiFridayApplied AS nAiFridayApplied_86, t0.nAiGatheringApplied AS nAiGatheringApplied_87, t0.nAiGatheringAttended AS nAiGatheringAttended_88, t0.aiSs24Applied AS aiSs24Applied_89, t0.aiSs24Booked AS aiSs24Booked_90, t0.interestedIn AS interestedIn_91, t0.interests AS interests_92, t0.mentorMetadata AS mentorMetadata_93, t0.eventParticipations AS eventParticipations_94, t0.kiKompetenz AS kiKompetenz_95, t0.mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0.id = ?

#▲	Time	Info
1	25.16 ms	SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? Parameters: [`"ki-einstieg-fuer-alle-und-effektives-prompting" "publish"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = 'ki-einstieg-fuer-alle-und-effektives-prompting' AND s0_.status = 'publish';
2	2.04 ms	SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.startDate IS NOT NULL AND s0_.startDate > ?) OR (s0_.startDate IS NULL AND s0_.pitchDate > ?)) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1 Parameters: [`6745 "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.startDate IS NOT NULL AND s0_.startDate > ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate > ? ) ) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1 SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = 6745 AND ((s0_.startDate IS NOT NULL AND s0_.startDate > '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate > '2026-02-27 02:18:54')) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1;
3	1.33 ms	SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.startDate IS NOT NULL AND s0_.startDate > ?) OR (s0_.startDate IS NULL AND s0_.pitchDate > ?)) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1 Parameters: [`6820 "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.startDate IS NOT NULL AND s0_.startDate > ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate > ? ) ) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1 SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = 6820 AND ((s0_.startDate IS NOT NULL AND s0_.startDate > '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate > '2026-02-27 02:18:54')) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1;
4	21.22 ms	SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? Parameters: [`"ki-einstieg-fuer-alle-und-effektives-prompting" 6745 "publish"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = 'ki-einstieg-fuer-alle-und-effektives-prompting' AND s0_.id <> 6745 AND s0_.status = 'publish';
5	1.98 ms	SELECT COUNT(s0_.id) AS sclr_0 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.startDate IS NOT NULL AND s0_.startDate > ?) OR (s0_.startDate IS NULL AND s0_.pitchDate > ?)) Parameters: [`6820 "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.id) AS sclr_0 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.startDate IS NOT NULL AND s0_.startDate > ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate > ? ) ) SELECT COUNT(s0_.id) AS sclr_0 FROM sp_batches s0_ WHERE s0_.eventId = 6820 AND ((s0_.startDate IS NOT NULL AND s0_.startDate > '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate > '2026-02-27 02:18:54'));
6	18.18 ms	SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? Parameters: [`"ki-einstieg-fuer-alle-und-effektives-prompting" 6745 "publish"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.id <> ? AND s0_.status = ? SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.wpPostId AS wpPostId_2, s0_.title AS title_3, s0_.slug AS slug_4, s0_.lang AS lang_5, s0_.imagelink AS imagelink_6, s0_.videolink AS videolink_7, s0_.bgImagelink AS bgImagelink_8, s0_.tagline AS tagline_9, s0_.headerTextColor AS headerTextColor_10, s0_.spResponsiblePerson AS spResponsiblePerson_11, s0_.organization AS organization_12, s0_.organizerName AS organizerName_13, s0_.organizerEmail AS organizerEmail_14, s0_.venueName AS venueName_15, s0_.venueAddress AS venueAddress_16, s0_.ticketing AS ticketing_17, s0_.applicationUrl AS applicationUrl_18, s0_.alert AS alert_19, s0_.trainer AS trainer_20, s0_.speakers AS speakers_21, s0_.teaser AS teaser_22, s0_.navbar AS navbar_23, s0_.stripePriceId AS stripePriceId_24, s0_.stripeProductId AS stripeProductId_25, s0_.stripeAccount AS stripeAccount_26, s0_.priceInEuroCent AS priceInEuroCent_27, s0_.isTaxIncluded AS isTaxIncluded_28, s0_.isFreeForKiCampus AS isFreeForKiCampus_29, s0_.isFreeForCommunity AS isFreeForCommunity_30, s0_.isSinglePage AS isSinglePage_31, s0_.isFormalLanguage AS isFormalLanguage_32, s0_.isMultiBatchEvent AS isMultiBatchEvent_33, s0_.twigFile AS twigFile_34, s0_.additionalCss AS additionalCss_35, s0_.content AS content_36, s0_.contentTwig AS contentTwig_37, s0_.ctaContent AS ctaContent_38, s0_.postCtaContent AS postCtaContent_39, s0_.tags AS tags_40, s0_.seriesTag AS seriesTag_41, s0_.type AS type_42, s0_.location AS location_43, s0_.startDate AS startDate_44, s0_.endDate AS endDate_45, s0_.duration AS duration_46, s0_.status AS status_47, s0_.settings AS settings_48, s0_.displayStartDate AS displayStartDate_49, s0_.seoTitle AS seoTitle_50, s0_.seoKeyword AS seoKeyword_51, s0_.seoDescription AS seoDescription_52, s0_.navbar_en AS navbar_en_53, s0_.teaser_en AS teaser_en_54, s0_.content_en AS content_en_55, s0_.content_twig_en AS content_twig_en_56, s0_.post_cta_content_en AS post_cta_content_en_57, s0_.seo_title_en AS seo_title_en_58, s0_.seo_description_en AS seo_description_en_59, s0_.seo_keyword_en AS seo_keyword_en_60, s0_.has_english_version AS has_english_version_61, s0_.additional_js AS additional_js_62, s0_.metaPixelId AS metaPixelId_63, s0_.createDate AS createDate_64, s0_.lastChangeDate AS lastChangeDate_65, s0_.lastChangeUser AS lastChangeUser_66, s0_.publicId AS publicId_67, s0_.isExternalSubmission AS isExternalSubmission_68, s0_.createdBy AS createdBy_69, s0_.lastModified AS lastModified_70, s0_.createdAt AS createdAt_71, s0_.orgaNote AS orgaNote_72, s0_.history AS history_73, s0_.todoHistory AS todoHistory_74 FROM sp_event_events s0_ WHERE s0_.seriesTag = 'ki-einstieg-fuer-alle-und-effektives-prompting' AND s0_.id <> 6745 AND s0_.status = 'publish';
7	1.24 ms	SELECT COUNT(s0_.id) AS sclr_0 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) Parameters: [`6820 "2026-02-27 02:18:54" "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT COUNT(s0_.id) AS sclr_0 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.endDate IS NOT NULL AND s0_.endDate < ? ) OR ( s0_.endDate IS NULL AND s0_.startDate < ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate < ? ) ) SELECT COUNT(s0_.id) AS sclr_0 FROM sp_batches s0_ WHERE s0_.eventId = 6820 AND ((s0_.endDate IS NOT NULL AND s0_.endDate < '2026-02-27 02:18:54') OR (s0_.endDate IS NULL AND s0_.startDate < '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate < '2026-02-27 02:18:54'));
8	1.43 ms	SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 Parameters: [`6820 "2026-02-27 02:18:54" "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.endDate IS NOT NULL AND s0_.endDate < ? ) OR ( s0_.endDate IS NULL AND s0_.startDate < ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate < ? ) ) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = 6820 AND ((s0_.endDate IS NOT NULL AND s0_.endDate < '2026-02-27 02:18:54') OR (s0_.endDate IS NULL AND s0_.startDate < '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate < '2026-02-27 02:18:54')) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1;
9	2.02 ms	SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 Parameters: [`6820 "2026-02-27 02:18:54" "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.endDate IS NOT NULL AND s0_.endDate < ? ) OR ( s0_.endDate IS NULL AND s0_.startDate < ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate < ? ) ) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = 6820 AND ((s0_.endDate IS NOT NULL AND s0_.endDate < '2026-02-27 02:18:54') OR (s0_.endDate IS NULL AND s0_.startDate < '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate < '2026-02-27 02:18:54')) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1;
10	1.83 ms	SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 Parameters: [`6820 "2026-02-27 02:18:54" "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.endDate IS NOT NULL AND s0_.endDate < ? ) OR ( s0_.endDate IS NULL AND s0_.startDate < ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate < ? ) ) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = 6820 AND ((s0_.endDate IS NOT NULL AND s0_.endDate < '2026-02-27 02:18:54') OR (s0_.endDate IS NULL AND s0_.startDate < '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate < '2026-02-27 02:18:54')) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1;
11	1.74 ms	SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 Parameters: [`6820 "2026-02-27 02:18:54" "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.endDate IS NOT NULL AND s0_.endDate < ? ) OR ( s0_.endDate IS NULL AND s0_.startDate < ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate < ? ) ) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = 6820 AND ((s0_.endDate IS NOT NULL AND s0_.endDate < '2026-02-27 02:18:54') OR (s0_.endDate IS NULL AND s0_.startDate < '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate < '2026-02-27 02:18:54')) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1;
12	1.71 ms	SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ((s0_.endDate IS NOT NULL AND s0_.endDate < ?) OR (s0_.endDate IS NULL AND s0_.startDate < ?) OR (s0_.startDate IS NULL AND s0_.pitchDate < ?)) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 Parameters: [`6820 "2026-02-27 02:18:54" "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND ( ( s0_.endDate IS NOT NULL AND s0_.endDate < ? ) OR ( s0_.endDate IS NULL AND s0_.startDate < ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate < ? ) ) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1 SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = 6820 AND ((s0_.endDate IS NOT NULL AND s0_.endDate < '2026-02-27 02:18:54') OR (s0_.endDate IS NULL AND s0_.startDate < '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate < '2026-02-27 02:18:54')) ORDER BY s0_.endDate DESC, s0_.startDate DESC, s0_.pitchDate DESC LIMIT 1;
13	1.85 ms	SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND s0_.access = ? AND ((s0_.startDate IS NOT NULL AND s0_.startDate > ?) OR (s0_.startDate IS NULL AND s0_.pitchDate > ?)) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1 Parameters: [`6745 "active" "anonymous" "2026-02-27 02:18:54" "2026-02-27 02:18:54"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = ? AND s0_.status = ? AND s0_.access = ? AND ( ( s0_.startDate IS NOT NULL AND s0_.startDate > ? ) OR ( s0_.startDate IS NULL AND s0_.pitchDate > ? ) ) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1 SELECT s0_.id AS id_0, s0_.programId AS programId_1, s0_.eventId AS eventId_2, s0_.productId AS productId_3, s0_.batchNumber AS batchNumber_4, s0_.url AS url_5, s0_.name AS name_6, s0_.slug AS slug_7, s0_.alias AS alias_8, s0_.status AS status_9, s0_.focusStatus AS focusStatus_10, s0_.lang AS lang_11, s0_.priceInEuroCent AS priceInEuroCent_12, s0_.isTaxIncluded AS isTaxIncluded_13, s0_.discount100MemberTags AS discount100MemberTags_14, s0_.discount50MemberTags AS discount50MemberTags_15, s0_.discount20MemberTags AS discount20MemberTags_16, s0_.askForTeam AS askForTeam_17, s0_.hasEvent AS hasEvent_18, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, s0_.hasIncludePhone AS hasIncludePhone_22, s0_.hasFollowUp AS hasFollowUp_23, s0_.isNetworking AS isNetworking_24, s0_.networkingRounds AS networkingRounds_25, s0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, s0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, s0_.isFutureEvent AS isFutureEvent_28, s0_.visibility AS visibility_29, s0_.access AS access_30, s0_.tags AS tags_31, s0_.typeformLink AS typeformLink_32, s0_.zoomLink AS zoomLink_33, s0_.bgImageUrl AS bgImageUrl_34, s0_.startDate AS startDate_35, s0_.endDate AS endDate_36, s0_.stripePriceId AS stripePriceId_37, s0_.stripeProductId AS stripeProductId_38, s0_.stripeAccount AS stripeAccount_39, s0_.isFreeForKiCampus AS isFreeForKiCampus_40, s0_.isFreeForCommunity AS isFreeForCommunity_41, s0_.mailDesignTemplate AS mailDesignTemplate_42, s0_.senderMail AS senderMail_43, s0_.fromName AS fromName_44, s0_.recipientMonitoringMail AS recipientMonitoringMail_45, s0_.confirmationMailSubject AS confirmationMailSubject_46, s0_.confirmationMailContent AS confirmationMailContent_47, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, s0_.adminNotificationMailContent AS adminNotificationMailContent_49, s0_.reminderMailTemplateId AS reminderMailTemplateId_50, s0_.reminderSenderEmail AS reminderSenderEmail_51, s0_.reminderBulkMailId AS reminderBulkMailId_52, s0_.reminderMailSendDate AS reminderMailSendDate_53, s0_.reminderMailSubject AS reminderMailSubject_54, s0_.reminderMailContent AS reminderMailContent_55, s0_.$reminderMailStatus AS reminderMailStatus_56, s0_.surveyId AS surveyId_57, s0_.surveyMailTemplateId AS surveyMailTemplateId_58, s0_.surveyBulkMailId AS surveyBulkMailId_59, s0_.template AS template_60, s0_.pageTemplate AS pageTemplate_61, s0_.footerTemplate AS footerTemplate_62, s0_.email AS email_63, s0_.emailSubject AS emailSubject_64, s0_.emailContent AS emailContent_65, s0_.landingPageContent AS landingPageContent_66, s0_.landingPageDescription AS landingPageDescription_67, s0_.landingPageCss AS landingPageCss_68, s0_.landingPageJs AS landingPageJs_69, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, s0_.landingPageSocialImage AS landingPageSocialImage_71, s0_.landingPageTitle AS landingPageTitle_72, s0_.landingPageTwig AS landingPageTwig_73, s0_.goToPage AS goToPage_74, s0_.phrasesDe AS phrasesDe_75, s0_.phrasesEn AS phrasesEn_76, s0_.settings AS settings_77, s0_.asssesmentDimensions AS asssesmentDimensions_78, s0_.start AS start_79, s0_.end AS end_80, s0_.pitchTopic AS pitchTopic_81, s0_.pitchImageLink AS pitchImageLink_82, s0_.pitchVideoLink AS pitchVideoLink_83, s0_.pitchPartner AS pitchPartner_84, s0_.pitchPartnerId AS pitchPartnerId_85, s0_.pitchDescription AS pitchDescription_86, s0_.followUpPageContent AS followUpPageContent_87, s0_.followUpPageDescription AS followUpPageDescription_88, s0_.followUpPageCss AS followUpPageCss_89, s0_.followUpPageJs AS followUpPageJs_90, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, s0_.followUpPageTitle AS followUpPageTitle_92, s0_.followUpPageSocialImage AS followUpPageSocialImage_93, s0_.followUpDescription AS followUpDescription_94, s0_.followUpVideoLink AS followUpVideoLink_95, s0_.followUpPresentation AS followUpPresentation_96, s0_.pitchDate AS pitchDate_97, s0_.pitchTime AS pitchTime_98, s0_.prepitchDate AS prepitchDate_99, s0_.city AS city_100, s0_.applicationsCount AS applicationsCount_101, s0_.startedCount AS startedCount_102, s0_.appliedCount AS appliedCount_103, s0_.approvedCount AS approvedCount_104, s0_.rejectedCount AS rejectedCount_105, s0_.$skoolWebhook AS skoolWebhook_106, s0_.zapierWebhook AS zapierWebhook_107, s0_.history AS history_108, s0_.createdAt AS createdAt_109, s0_.lastModified AS lastModified_110, s0_.lastChangeUser AS lastChangeUser_111, s0_.program_id AS program_id_112, s0_.assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_.eventId = 6745 AND s0_.status = 'active' AND s0_.access = 'anonymous' AND ((s0_.startDate IS NOT NULL AND s0_.startDate > '2026-02-27 02:18:54') OR (s0_.startDate IS NULL AND s0_.pitchDate > '2026-02-27 02:18:54')) ORDER BY s0_.startDate ASC, s0_.pitchDate ASC LIMIT 1;
14	1.77 ms	SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = :seriesTag AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( (b.startDate IS NOT NULL AND b.startDate > NOW()) OR (b.startDate IS NULL AND b.pitchDate > NOW()) ) ORDER BY COALESCE(b.startDate, b.pitchDate) ASC Parameters: [`"seriesTag" => "ki-einstieg-fuer-alle-und-effektives-prompting"`] View formatted query View runnable query Explain query SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = :seriesTag AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( ( b.startDate IS NOT NULL AND b.startDate > NOW() ) OR ( b.startDate IS NULL AND b.pitchDate > NOW() ) ) ORDER BY COALESCE(b.startDate, b.pitchDate) ASC SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = 'ki-einstieg-fuer-alle-und-effektives-prompting' AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( (b.startDate IS NOT NULL AND b.startDate > NOW()) OR (b.startDate IS NULL AND b.pitchDate > NOW()) ) ORDER BY COALESCE(b.startDate, b.pitchDate) ASC;
15	1.60 ms	SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.endDate, b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = :seriesTag AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( (b.endDate IS NOT NULL AND b.endDate < NOW()) OR (b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW()) OR (b.startDate IS NULL AND b.pitchDate < NOW()) ) ORDER BY COALESCE(b.endDate, b.startDate, b.pitchDate) DESC Parameters: [`"seriesTag" => "ki-einstieg-fuer-alle-und-effektives-prompting"`] View formatted query View runnable query Explain query SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE( b.endDate, b.startDate, b.pitchDate ) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = :seriesTag AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( ( b.endDate IS NOT NULL AND b.endDate < NOW() ) OR ( b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW() ) OR ( b.startDate IS NULL AND b.pitchDate < NOW() ) ) ORDER BY COALESCE( b.endDate, b.startDate, b.pitchDate ) DESC SELECT b.id as batch_id, b.eventId as event_id, b.name as batch_name, b.slug as batch_slug, COALESCE(b.endDate, b.startDate, b.pitchDate) as batch_date, b.endDate as batch_end_date, b.status as batch_status, e.id as event_id, e.title as event_title, e.slug as event_slug, e.location, e.venueName, e.trainer, e.isMultiBatchEvent FROM sp_event_events e INNER JOIN sp_batches b ON b.eventId = e.id WHERE e.seriesTag = 'ki-einstieg-fuer-alle-und-effektives-prompting' AND e.status = 'publish' AND b.status = 'active' AND e.isMultiBatchEvent = 1 AND ( (b.endDate IS NOT NULL AND b.endDate < NOW()) OR (b.endDate IS NULL AND b.startDate IS NOT NULL AND b.startDate < NOW()) OR (b.startDate IS NULL AND b.pitchDate < NOW()) ) ORDER BY COALESCE(b.endDate, b.startDate, b.pitchDate) DESC;
16	0.47 ms	SELECT t0.id AS id_1, t0.spMemberId AS spMemberId_2, t0.score AS score_3, t0.completenessScore AS completenessScore_4, t0.status AS status_5, t0.location AS location_6, t0.salutation AS salutation_7, t0.title AS title_8, t0.jobTitle AS jobTitle_9, t0.firstName AS firstName_10, t0.lastName AS lastName_11, t0.name AS name_12, t0.sortName AS sortName_13, t0.email AS email_14, t0.secondaryEmail AS secondaryEmail_15, t0.phone AS phone_16, t0.hasCommunityMembership AS hasCommunityMembership_17, t0.aiMemberValid AS aiMemberValid_18, t0.aiMemberStatus AS aiMemberStatus_19, t0.aiMemberReason AS aiMemberReason_20, t0.aiMemberStart AS aiMemberStart_21, t0.aiMemberEnd AS aiMemberEnd_22, t0.utm_source AS utm_source_23, t0.utm_medium AS utm_medium_24, t0.utm_campaign AS utm_campaign_25, t0.utm_term AS utm_term_26, t0.utm_content AS utm_content_27, t0.birthday AS birthday_28, t0.addressFieldOne AS addressFieldOne_29, t0.addressFieldTwo AS addressFieldTwo_30, t0.addressCountryCode AS addressCountryCode_31, t0.addressPostalCode AS addressPostalCode_32, t0.addressCity AS addressCity_33, t0.teamId AS teamId_34, t0.teamName AS teamName_35, t0.company AS company_36, t0.history AS history_37, t0.tags AS tags_38, t0.annotation AS annotation_39, t0.mentorBuckets AS mentorBuckets_40, t0.areasOfExpertise AS areasOfExpertise_41, t0.mentor_firma AS mentor_firma_42, t0.mentor_firma_url AS mentor_firma_url_43, t0.mentor_locations AS mentor_locations_44, t0.mentor_profile AS mentor_profile_45, t0.mentor_note AS mentor_note_46, t0.mentor_admin_rating AS mentor_admin_rating_47, t0.active AS active_48, t0.tiefgarage AS tiefgarage_49, t0.transponder AS transponder_50, t0.isTransponderAllowed AS isTransponderAllowed_51, t0.imageLink AS imageLink_52, t0.homepage AS homepage_53, t0.xing AS xing_54, t0.pipedriveId AS pipedriveId_55, t0.linkedin AS linkedin_56, t0.facebook AS facebook_57, t0.instagram AS instagram_58, t0.twitter AS twitter_59, t0.skills AS skills_60, t0.description AS description_61, t0.touchpoints AS touchpoints_62, t0.isAddressComplete AS isAddressComplete_63, t0.hasMailchimp AS hasMailchimp_64, t0.hasKiNewsletter AS hasKiNewsletter_65, t0.hubspotSyncPending AS hubspotSyncPending_66, t0.enterDate AS enterDate_67, t0.exitDate AS exitDate_68, t0.physicalMembershipStarted AS physicalMembershipStarted_69, t0.physicalMembershipEnded AS physicalMembershipEnded_70, t0.lastModified AS lastModified_71, t0.lastChangeUser AS lastChangeUser_72, t0.nAiWebinarsAttended AS nAiWebinarsAttended_73, t0.nAiWebinarsApplied AS nAiWebinarsApplied_74, t0.nAiEventsAttended AS nAiEventsAttended_75, t0.nAiEventsApplied AS nAiEventsApplied_76, t0.nPaidAttended AS nPaidAttended_77, t0.nPaidApplied AS nPaidApplied_78, t0.nKiEinstiegAttended AS nKiEinstiegAttended_79, t0.nKiEinstiegApplied AS nKiEinstiegApplied_80, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_81, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_82, t0.nEcodynamicsAttended AS nEcodynamicsAttended_83, t0.nEcodynamicsApplied AS nEcodynamicsApplied_84, t0.nBbqApplied AS nBbqApplied_85, t0.nAiFridayApplied AS nAiFridayApplied_86, t0.nAiGatheringApplied AS nAiGatheringApplied_87, t0.nAiGatheringAttended AS nAiGatheringAttended_88, t0.aiSs24Applied AS aiSs24Applied_89, t0.aiSs24Booked AS aiSs24Booked_90, t0.interestedIn AS interestedIn_91, t0.interests AS interests_92, t0.mentorMetadata AS mentorMetadata_93, t0.eventParticipations AS eventParticipations_94, t0.kiKompetenz AS kiKompetenz_95, t0.mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0.id = ? Parameters: [`"91699"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.spMemberId AS spMemberId_2, t0.score AS score_3, t0.completenessScore AS completenessScore_4, t0.status AS status_5, t0.location AS location_6, t0.salutation AS salutation_7, t0.title AS title_8, t0.jobTitle AS jobTitle_9, t0.firstName AS firstName_10, t0.lastName AS lastName_11, t0.name AS name_12, t0.sortName AS sortName_13, t0.email AS email_14, t0.secondaryEmail AS secondaryEmail_15, t0.phone AS phone_16, t0.hasCommunityMembership AS hasCommunityMembership_17, t0.aiMemberValid AS aiMemberValid_18, t0.aiMemberStatus AS aiMemberStatus_19, t0.aiMemberReason AS aiMemberReason_20, t0.aiMemberStart AS aiMemberStart_21, t0.aiMemberEnd AS aiMemberEnd_22, t0.utm_source AS utm_source_23, t0.utm_medium AS utm_medium_24, t0.utm_campaign AS utm_campaign_25, t0.utm_term AS utm_term_26, t0.utm_content AS utm_content_27, t0.birthday AS birthday_28, t0.addressFieldOne AS addressFieldOne_29, t0.addressFieldTwo AS addressFieldTwo_30, t0.addressCountryCode AS addressCountryCode_31, t0.addressPostalCode AS addressPostalCode_32, t0.addressCity AS addressCity_33, t0.teamId AS teamId_34, t0.teamName AS teamName_35, t0.company AS company_36, t0.history AS history_37, t0.tags AS tags_38, t0.annotation AS annotation_39, t0.mentorBuckets AS mentorBuckets_40, t0.areasOfExpertise AS areasOfExpertise_41, t0.mentor_firma AS mentor_firma_42, t0.mentor_firma_url AS mentor_firma_url_43, t0.mentor_locations AS mentor_locations_44, t0.mentor_profile AS mentor_profile_45, t0.mentor_note AS mentor_note_46, t0.mentor_admin_rating AS mentor_admin_rating_47, t0.active AS active_48, t0.tiefgarage AS tiefgarage_49, t0.transponder AS transponder_50, t0.isTransponderAllowed AS isTransponderAllowed_51, t0.imageLink AS imageLink_52, t0.homepage AS homepage_53, t0.xing AS xing_54, t0.pipedriveId AS pipedriveId_55, t0.linkedin AS linkedin_56, t0.facebook AS facebook_57, t0.instagram AS instagram_58, t0.twitter AS twitter_59, t0.skills AS skills_60, t0.description AS description_61, t0.touchpoints AS touchpoints_62, t0.isAddressComplete AS isAddressComplete_63, t0.hasMailchimp AS hasMailchimp_64, t0.hasKiNewsletter AS hasKiNewsletter_65, t0.hubspotSyncPending AS hubspotSyncPending_66, t0.enterDate AS enterDate_67, t0.exitDate AS exitDate_68, t0.physicalMembershipStarted AS physicalMembershipStarted_69, t0.physicalMembershipEnded AS physicalMembershipEnded_70, t0.lastModified AS lastModified_71, t0.lastChangeUser AS lastChangeUser_72, t0.nAiWebinarsAttended AS nAiWebinarsAttended_73, t0.nAiWebinarsApplied AS nAiWebinarsApplied_74, t0.nAiEventsAttended AS nAiEventsAttended_75, t0.nAiEventsApplied AS nAiEventsApplied_76, t0.nPaidAttended AS nPaidAttended_77, t0.nPaidApplied AS nPaidApplied_78, t0.nKiEinstiegAttended AS nKiEinstiegAttended_79, t0.nKiEinstiegApplied AS nKiEinstiegApplied_80, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_81, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_82, t0.nEcodynamicsAttended AS nEcodynamicsAttended_83, t0.nEcodynamicsApplied AS nEcodynamicsApplied_84, t0.nBbqApplied AS nBbqApplied_85, t0.nAiFridayApplied AS nAiFridayApplied_86, t0.nAiGatheringApplied AS nAiGatheringApplied_87, t0.nAiGatheringAttended AS nAiGatheringAttended_88, t0.aiSs24Applied AS aiSs24Applied_89, t0.aiSs24Booked AS aiSs24Booked_90, t0.interestedIn AS interestedIn_91, t0.interests AS interests_92, t0.mentorMetadata AS mentorMetadata_93, t0.eventParticipations AS eventParticipations_94, t0.kiKompetenz AS kiKompetenz_95, t0.mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.spMemberId AS spMemberId_2, t0.score AS score_3, t0.completenessScore AS completenessScore_4, t0.status AS status_5, t0.location AS location_6, t0.salutation AS salutation_7, t0.title AS title_8, t0.jobTitle AS jobTitle_9, t0.firstName AS firstName_10, t0.lastName AS lastName_11, t0.name AS name_12, t0.sortName AS sortName_13, t0.email AS email_14, t0.secondaryEmail AS secondaryEmail_15, t0.phone AS phone_16, t0.hasCommunityMembership AS hasCommunityMembership_17, t0.aiMemberValid AS aiMemberValid_18, t0.aiMemberStatus AS aiMemberStatus_19, t0.aiMemberReason AS aiMemberReason_20, t0.aiMemberStart AS aiMemberStart_21, t0.aiMemberEnd AS aiMemberEnd_22, t0.utm_source AS utm_source_23, t0.utm_medium AS utm_medium_24, t0.utm_campaign AS utm_campaign_25, t0.utm_term AS utm_term_26, t0.utm_content AS utm_content_27, t0.birthday AS birthday_28, t0.addressFieldOne AS addressFieldOne_29, t0.addressFieldTwo AS addressFieldTwo_30, t0.addressCountryCode AS addressCountryCode_31, t0.addressPostalCode AS addressPostalCode_32, t0.addressCity AS addressCity_33, t0.teamId AS teamId_34, t0.teamName AS teamName_35, t0.company AS company_36, t0.history AS history_37, t0.tags AS tags_38, t0.annotation AS annotation_39, t0.mentorBuckets AS mentorBuckets_40, t0.areasOfExpertise AS areasOfExpertise_41, t0.mentor_firma AS mentor_firma_42, t0.mentor_firma_url AS mentor_firma_url_43, t0.mentor_locations AS mentor_locations_44, t0.mentor_profile AS mentor_profile_45, t0.mentor_note AS mentor_note_46, t0.mentor_admin_rating AS mentor_admin_rating_47, t0.active AS active_48, t0.tiefgarage AS tiefgarage_49, t0.transponder AS transponder_50, t0.isTransponderAllowed AS isTransponderAllowed_51, t0.imageLink AS imageLink_52, t0.homepage AS homepage_53, t0.xing AS xing_54, t0.pipedriveId AS pipedriveId_55, t0.linkedin AS linkedin_56, t0.facebook AS facebook_57, t0.instagram AS instagram_58, t0.twitter AS twitter_59, t0.skills AS skills_60, t0.description AS description_61, t0.touchpoints AS touchpoints_62, t0.isAddressComplete AS isAddressComplete_63, t0.hasMailchimp AS hasMailchimp_64, t0.hasKiNewsletter AS hasKiNewsletter_65, t0.hubspotSyncPending AS hubspotSyncPending_66, t0.enterDate AS enterDate_67, t0.exitDate AS exitDate_68, t0.physicalMembershipStarted AS physicalMembershipStarted_69, t0.physicalMembershipEnded AS physicalMembershipEnded_70, t0.lastModified AS lastModified_71, t0.lastChangeUser AS lastChangeUser_72, t0.nAiWebinarsAttended AS nAiWebinarsAttended_73, t0.nAiWebinarsApplied AS nAiWebinarsApplied_74, t0.nAiEventsAttended AS nAiEventsAttended_75, t0.nAiEventsApplied AS nAiEventsApplied_76, t0.nPaidAttended AS nPaidAttended_77, t0.nPaidApplied AS nPaidApplied_78, t0.nKiEinstiegAttended AS nKiEinstiegAttended_79, t0.nKiEinstiegApplied AS nKiEinstiegApplied_80, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_81, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_82, t0.nEcodynamicsAttended AS nEcodynamicsAttended_83, t0.nEcodynamicsApplied AS nEcodynamicsApplied_84, t0.nBbqApplied AS nBbqApplied_85, t0.nAiFridayApplied AS nAiFridayApplied_86, t0.nAiGatheringApplied AS nAiGatheringApplied_87, t0.nAiGatheringAttended AS nAiGatheringAttended_88, t0.aiSs24Applied AS aiSs24Applied_89, t0.aiSs24Booked AS aiSs24Booked_90, t0.interestedIn AS interestedIn_91, t0.interests AS interests_92, t0.mentorMetadata AS mentorMetadata_93, t0.eventParticipations AS eventParticipations_94, t0.kiKompetenz AS kiKompetenz_95, t0.mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0.id = '91699';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\StartPlatz\Bundle\UserBundle\Entity\User	No errors.
App\StartPlatz\Bundle\UserBundle\Entity\LoginToken	No errors.
App\StartPlatz\Bundle\PartnersBundle\Entity\Partner	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Team	No errors.
App\StartPlatz\Ecosystem\Participation\Entity\Participation	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Application	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.
App\StartPlatz\Bundle\EventBundle\Entity\Event	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Batch	No errors.
App\StartPlatz\Bundle\StartupBundle\Entity\Program	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\Member	No errors.
App\StartPlatz\Bundle\MemberBundle\Entity\MemberTeam	No errors.

Symfony Profiler

http://www.staging.startplatz.de/event-series/ki-einstieg-fuer-alle-und-effektives-prompting

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping