Symfony Profiler

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 BETWEEN ?
        AND ?
      )
      OR (
        s0_.startDate IS NULL
        AND s0_.pitchDate BETWEEN ?
        AND ?
      )
    )
  )
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 = 6804 AND (((s0_.startDate IS NOT NULL AND s0_.startDate BETWEEN '2025-12-03 00:00:00' AND '2025-12-03 23:59:59') OR (s0_.startDate IS NULL AND s0_.pitchDate BETWEEN '2025-12-03 00:00:00' AND '2025-12-03 23:59:59'))) 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 LIKE ?
ORDER BY
  s0_.startDate DESC

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 LIKE '%ai-automation-webinar%' ORDER BY s0_.startDate DESC;

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 = ?
ORDER BY
  s0_.startDate ASC,
  s0_.pitchDate ASC

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 = 6804 ORDER BY s0_.startDate ASC, s0_.pitchDate ASC;

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 DESC,
  s0_.pitchDate DESC
LIMIT
  10

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 = 6804 AND (((s0_.startDate IS NOT NULL AND s0_.startDate < '2026-02-27 03:36:54') OR (s0_.startDate IS NULL AND s0_.pitchDate < '2026-02-27 03:36:54'))) ORDER BY s0_.startDate DESC, s0_.pitchDate DESC LIMIT 10;