Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.eventbriteId AS eventbriteId_1,
  a0_.wpPostId AS wpPostId_2,
  a0_.title AS title_3,
  a0_.slug AS slug_4,
  a0_.lang AS lang_5,
  a0_.imagelink AS imagelink_6,
  a0_.videolink AS videolink_7,
  a0_.bgImagelink AS bgImagelink_8,
  a0_.tagline AS tagline_9,
  a0_.headerTextColor AS headerTextColor_10,
  a0_.spResponsiblePerson AS spResponsiblePerson_11,
  a0_.organization AS organization_12,
  a0_.organizerName AS organizerName_13,
  a0_.organizerEmail AS organizerEmail_14,
  a0_.venueName AS venueName_15,
  a0_.venueAddress AS venueAddress_16,
  a0_.ticketing AS ticketing_17,
  a0_.applicationUrl AS applicationUrl_18,
  a0_.alert AS alert_19,
  a0_.trainer AS trainer_20,
  a0_.speakers AS speakers_21,
  a0_.teaser AS teaser_22,
  a0_.navbar AS navbar_23,
  a0_.stripePriceId AS stripePriceId_24,
  a0_.stripeProductId AS stripeProductId_25,
  a0_.stripeAccount AS stripeAccount_26,
  a0_.priceInEuroCent AS priceInEuroCent_27,
  a0_.isTaxIncluded AS isTaxIncluded_28,
  a0_.isFreeForKiCampus AS isFreeForKiCampus_29,
  a0_.isFreeForCommunity AS isFreeForCommunity_30,
  a0_.isSinglePage AS isSinglePage_31,
  a0_.isFormalLanguage AS isFormalLanguage_32,
  a0_.isMultiBatchEvent AS isMultiBatchEvent_33,
  a0_.twigFile AS twigFile_34,
  a0_.additionalCss AS additionalCss_35,
  a0_.content AS content_36,
  a0_.contentTwig AS contentTwig_37,
  a0_.ctaContent AS ctaContent_38,
  a0_.postCtaContent AS postCtaContent_39,
  a0_.tags AS tags_40,
  a0_.seriesTag AS seriesTag_41,
  a0_.type AS type_42,
  a0_.location AS location_43,
  a0_.startDate AS startDate_44,
  a0_.endDate AS endDate_45,
  a0_.duration AS duration_46,
  a0_.status AS status_47,
  a0_.settings AS settings_48,
  a0_.displayStartDate AS displayStartDate_49,
  a0_.seoTitle AS seoTitle_50,
  a0_.seoKeyword AS seoKeyword_51,
  a0_.seoDescription AS seoDescription_52,
  a0_.navbar_en AS navbar_en_53,
  a0_.teaser_en AS teaser_en_54,
  a0_.content_en AS content_en_55,
  a0_.content_twig_en AS content_twig_en_56,
  a0_.post_cta_content_en AS post_cta_content_en_57,
  a0_.seo_title_en AS seo_title_en_58,
  a0_.seo_description_en AS seo_description_en_59,
  a0_.seo_keyword_en AS seo_keyword_en_60,
  a0_.has_english_version AS has_english_version_61,
  a0_.additional_js AS additional_js_62,
  a0_.metaPixelId AS metaPixelId_63,
  a0_.createDate AS createDate_64,
  a0_.lastChangeDate AS lastChangeDate_65,
  a0_.lastChangeUser AS lastChangeUser_66,
  a0_.publicId AS publicId_67,
  a0_.isExternalSubmission AS isExternalSubmission_68,
  a0_.createdBy AS createdBy_69,
  a0_.lastModified AS lastModified_70,
  a0_.createdAt AS createdAt_71,
  a0_.orgaNote AS orgaNote_72,
  a0_.history AS history_73,
  a0_.todoHistory AS todoHistory_74
FROM
  asp_events a0_
WHERE
  a0_.seriesTag LIKE ?
ORDER BY
  a0_.startDate DESC

SELECT a0_.id AS id_0, a0_.eventbriteId AS eventbriteId_1, a0_.wpPostId AS wpPostId_2, a0_.title AS title_3, a0_.slug AS slug_4, a0_.lang AS lang_5, a0_.imagelink AS imagelink_6, a0_.videolink AS videolink_7, a0_.bgImagelink AS bgImagelink_8, a0_.tagline AS tagline_9, a0_.headerTextColor AS headerTextColor_10, a0_.spResponsiblePerson AS spResponsiblePerson_11, a0_.organization AS organization_12, a0_.organizerName AS organizerName_13, a0_.organizerEmail AS organizerEmail_14, a0_.venueName AS venueName_15, a0_.venueAddress AS venueAddress_16, a0_.ticketing AS ticketing_17, a0_.applicationUrl AS applicationUrl_18, a0_.alert AS alert_19, a0_.trainer AS trainer_20, a0_.speakers AS speakers_21, a0_.teaser AS teaser_22, a0_.navbar AS navbar_23, a0_.stripePriceId AS stripePriceId_24, a0_.stripeProductId AS stripeProductId_25, a0_.stripeAccount AS stripeAccount_26, a0_.priceInEuroCent AS priceInEuroCent_27, a0_.isTaxIncluded AS isTaxIncluded_28, a0_.isFreeForKiCampus AS isFreeForKiCampus_29, a0_.isFreeForCommunity AS isFreeForCommunity_30, a0_.isSinglePage AS isSinglePage_31, a0_.isFormalLanguage AS isFormalLanguage_32, a0_.isMultiBatchEvent AS isMultiBatchEvent_33, a0_.twigFile AS twigFile_34, a0_.additionalCss AS additionalCss_35, a0_.content AS content_36, a0_.contentTwig AS contentTwig_37, a0_.ctaContent AS ctaContent_38, a0_.postCtaContent AS postCtaContent_39, a0_.tags AS tags_40, a0_.seriesTag AS seriesTag_41, a0_.type AS type_42, a0_.location AS location_43, a0_.startDate AS startDate_44, a0_.endDate AS endDate_45, a0_.duration AS duration_46, a0_.status AS status_47, a0_.settings AS settings_48, a0_.displayStartDate AS displayStartDate_49, a0_.seoTitle AS seoTitle_50, a0_.seoKeyword AS seoKeyword_51, a0_.seoDescription AS seoDescription_52, a0_.navbar_en AS navbar_en_53, a0_.teaser_en AS teaser_en_54, a0_.content_en AS content_en_55, a0_.content_twig_en AS content_twig_en_56, a0_.post_cta_content_en AS post_cta_content_en_57, a0_.seo_title_en AS seo_title_en_58, a0_.seo_description_en AS seo_description_en_59, a0_.seo_keyword_en AS seo_keyword_en_60, a0_.has_english_version AS has_english_version_61, a0_.additional_js AS additional_js_62, a0_.metaPixelId AS metaPixelId_63, a0_.createDate AS createDate_64, a0_.lastChangeDate AS lastChangeDate_65, a0_.lastChangeUser AS lastChangeUser_66, a0_.publicId AS publicId_67, a0_.isExternalSubmission AS isExternalSubmission_68, a0_.createdBy AS createdBy_69, a0_.lastModified AS lastModified_70, a0_.createdAt AS createdAt_71, a0_.orgaNote AS orgaNote_72, a0_.history AS history_73, a0_.todoHistory AS todoHistory_74 FROM asp_events a0_ WHERE a0_.seriesTag LIKE '%ki-einstieg-fuer-alle-und-effektives-prompting%' ORDER BY a0_.startDate DESC;

SELECT
  a0_.id AS id_0,
  a0_.programId AS programId_1,
  a0_.eventId AS eventId_2,
  a0_.productId AS productId_3,
  a0_.batchNumber AS batchNumber_4,
  a0_.url AS url_5,
  a0_.name AS name_6,
  a0_.slug AS slug_7,
  a0_.alias AS alias_8,
  a0_.status AS status_9,
  a0_.focusStatus AS focusStatus_10,
  a0_.lang AS lang_11,
  a0_.priceInEuroCent AS priceInEuroCent_12,
  a0_.isTaxIncluded AS isTaxIncluded_13,
  a0_.discount100MemberTags AS discount100MemberTags_14,
  a0_.discount50MemberTags AS discount50MemberTags_15,
  a0_.discount20MemberTags AS discount20MemberTags_16,
  a0_.askForTeam AS askForTeam_17,
  a0_.hasEvent AS hasEvent_18,
  a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19,
  a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20,
  a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21,
  a0_.hasIncludePhone AS hasIncludePhone_22,
  a0_.hasFollowUp AS hasFollowUp_23,
  a0_.isNetworking AS isNetworking_24,
  a0_.networkingRounds AS networkingRounds_25,
  a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26,
  a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27,
  a0_.isFutureEvent AS isFutureEvent_28,
  a0_.visibility AS visibility_29,
  a0_.access AS access_30,
  a0_.tags AS tags_31,
  a0_.typeformLink AS typeformLink_32,
  a0_.zoomLink AS zoomLink_33,
  a0_.bgImageUrl AS bgImageUrl_34,
  a0_.startDate AS startDate_35,
  a0_.endDate AS endDate_36,
  a0_.stripePriceId AS stripePriceId_37,
  a0_.stripeProductId AS stripeProductId_38,
  a0_.stripeAccount AS stripeAccount_39,
  a0_.isFreeForKiCampus AS isFreeForKiCampus_40,
  a0_.isFreeForCommunity AS isFreeForCommunity_41,
  a0_.mailDesignTemplate AS mailDesignTemplate_42,
  a0_.senderMail AS senderMail_43,
  a0_.fromName AS fromName_44,
  a0_.recipientMonitoringMail AS recipientMonitoringMail_45,
  a0_.confirmationMailSubject AS confirmationMailSubject_46,
  a0_.confirmationMailContent AS confirmationMailContent_47,
  a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48,
  a0_.adminNotificationMailContent AS adminNotificationMailContent_49,
  a0_.reminderMailTemplateId AS reminderMailTemplateId_50,
  a0_.reminderSenderEmail AS reminderSenderEmail_51,
  a0_.reminderBulkMailId AS reminderBulkMailId_52,
  a0_.reminderMailSendDate AS reminderMailSendDate_53,
  a0_.reminderMailSubject AS reminderMailSubject_54,
  a0_.reminderMailContent AS reminderMailContent_55,
  a0_.$reminderMailStatus AS reminderMailStatus_56,
  a0_.surveyId AS surveyId_57,
  a0_.surveyMailTemplateId AS surveyMailTemplateId_58,
  a0_.surveyBulkMailId AS surveyBulkMailId_59,
  a0_.template AS template_60,
  a0_.pageTemplate AS pageTemplate_61,
  a0_.footerTemplate AS footerTemplate_62,
  a0_.email AS email_63,
  a0_.emailSubject AS emailSubject_64,
  a0_.emailContent AS emailContent_65,
  a0_.landingPageContent AS landingPageContent_66,
  a0_.landingPageDescription AS landingPageDescription_67,
  a0_.landingPageCss AS landingPageCss_68,
  a0_.landingPageJs AS landingPageJs_69,
  a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70,
  a0_.landingPageSocialImage AS landingPageSocialImage_71,
  a0_.landingPageTitle AS landingPageTitle_72,
  a0_.landingPageTwig AS landingPageTwig_73,
  a0_.goToPage AS goToPage_74,
  a0_.phrasesDe AS phrasesDe_75,
  a0_.phrasesEn AS phrasesEn_76,
  a0_.settings AS settings_77,
  a0_.asssesmentDimensions AS asssesmentDimensions_78,
  a0_.start AS start_79,
  a0_.end AS end_80,
  a0_.pitchTopic AS pitchTopic_81,
  a0_.pitchImageLink AS pitchImageLink_82,
  a0_.pitchVideoLink AS pitchVideoLink_83,
  a0_.pitchPartner AS pitchPartner_84,
  a0_.pitchPartnerId AS pitchPartnerId_85,
  a0_.pitchDescription AS pitchDescription_86,
  a0_.followUpPageContent AS followUpPageContent_87,
  a0_.followUpPageDescription AS followUpPageDescription_88,
  a0_.followUpPageCss AS followUpPageCss_89,
  a0_.followUpPageJs AS followUpPageJs_90,
  a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91,
  a0_.followUpPageTitle AS followUpPageTitle_92,
  a0_.followUpPageSocialImage AS followUpPageSocialImage_93,
  a0_.followUpDescription AS followUpDescription_94,
  a0_.followUpVideoLink AS followUpVideoLink_95,
  a0_.followUpPresentation AS followUpPresentation_96,
  a0_.pitchDate AS pitchDate_97,
  a0_.pitchTime AS pitchTime_98,
  a0_.city AS city_99,
  a0_.applicationsCount AS applicationsCount_100,
  a0_.startedCount AS startedCount_101,
  a0_.appliedCount AS appliedCount_102,
  a0_.approvedCount AS approvedCount_103,
  a0_.rejectedCount AS rejectedCount_104,
  a0_.$skoolWebhook AS skoolWebhook_105,
  a0_.zapierWebhook AS zapierWebhook_106,
  a0_.history AS history_107,
  a0_.createdAt AS createdAt_108,
  a0_.lastModified AS lastModified_109,
  a0_.lastChangeUser AS lastChangeUser_110,
  a0_.program_id AS program_id_111,
  a0_.assessmentTeamId AS assessmentTeamId_112
FROM
  aab_batches a0_
WHERE
  a0_.eventId = ?
  AND (
    (
      (
        a0_.startDate IS NOT NULL
        AND a0_.startDate BETWEEN ?
        AND ?
      )
      OR (
        a0_.startDate IS NULL
        AND a0_.pitchDate BETWEEN ?
        AND ?
      )
    )
  )
LIMIT
  1

SELECT a0_.id AS id_0, a0_.programId AS programId_1, a0_.eventId AS eventId_2, a0_.productId AS productId_3, a0_.batchNumber AS batchNumber_4, a0_.url AS url_5, a0_.name AS name_6, a0_.slug AS slug_7, a0_.alias AS alias_8, a0_.status AS status_9, a0_.focusStatus AS focusStatus_10, a0_.lang AS lang_11, a0_.priceInEuroCent AS priceInEuroCent_12, a0_.isTaxIncluded AS isTaxIncluded_13, a0_.discount100MemberTags AS discount100MemberTags_14, a0_.discount50MemberTags AS discount50MemberTags_15, a0_.discount20MemberTags AS discount20MemberTags_16, a0_.askForTeam AS askForTeam_17, a0_.hasEvent AS hasEvent_18, a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, a0_.hasIncludePhone AS hasIncludePhone_22, a0_.hasFollowUp AS hasFollowUp_23, a0_.isNetworking AS isNetworking_24, a0_.networkingRounds AS networkingRounds_25, a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, a0_.isFutureEvent AS isFutureEvent_28, a0_.visibility AS visibility_29, a0_.access AS access_30, a0_.tags AS tags_31, a0_.typeformLink AS typeformLink_32, a0_.zoomLink AS zoomLink_33, a0_.bgImageUrl AS bgImageUrl_34, a0_.startDate AS startDate_35, a0_.endDate AS endDate_36, a0_.stripePriceId AS stripePriceId_37, a0_.stripeProductId AS stripeProductId_38, a0_.stripeAccount AS stripeAccount_39, a0_.isFreeForKiCampus AS isFreeForKiCampus_40, a0_.isFreeForCommunity AS isFreeForCommunity_41, a0_.mailDesignTemplate AS mailDesignTemplate_42, a0_.senderMail AS senderMail_43, a0_.fromName AS fromName_44, a0_.recipientMonitoringMail AS recipientMonitoringMail_45, a0_.confirmationMailSubject AS confirmationMailSubject_46, a0_.confirmationMailContent AS confirmationMailContent_47, a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, a0_.adminNotificationMailContent AS adminNotificationMailContent_49, a0_.reminderMailTemplateId AS reminderMailTemplateId_50, a0_.reminderSenderEmail AS reminderSenderEmail_51, a0_.reminderBulkMailId AS reminderBulkMailId_52, a0_.reminderMailSendDate AS reminderMailSendDate_53, a0_.reminderMailSubject AS reminderMailSubject_54, a0_.reminderMailContent AS reminderMailContent_55, a0_.$reminderMailStatus AS reminderMailStatus_56, a0_.surveyId AS surveyId_57, a0_.surveyMailTemplateId AS surveyMailTemplateId_58, a0_.surveyBulkMailId AS surveyBulkMailId_59, a0_.template AS template_60, a0_.pageTemplate AS pageTemplate_61, a0_.footerTemplate AS footerTemplate_62, a0_.email AS email_63, a0_.emailSubject AS emailSubject_64, a0_.emailContent AS emailContent_65, a0_.landingPageContent AS landingPageContent_66, a0_.landingPageDescription AS landingPageDescription_67, a0_.landingPageCss AS landingPageCss_68, a0_.landingPageJs AS landingPageJs_69, a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, a0_.landingPageSocialImage AS landingPageSocialImage_71, a0_.landingPageTitle AS landingPageTitle_72, a0_.landingPageTwig AS landingPageTwig_73, a0_.goToPage AS goToPage_74, a0_.phrasesDe AS phrasesDe_75, a0_.phrasesEn AS phrasesEn_76, a0_.settings AS settings_77, a0_.asssesmentDimensions AS asssesmentDimensions_78, a0_.start AS start_79, a0_.end AS end_80, a0_.pitchTopic AS pitchTopic_81, a0_.pitchImageLink AS pitchImageLink_82, a0_.pitchVideoLink AS pitchVideoLink_83, a0_.pitchPartner AS pitchPartner_84, a0_.pitchPartnerId AS pitchPartnerId_85, a0_.pitchDescription AS pitchDescription_86, a0_.followUpPageContent AS followUpPageContent_87, a0_.followUpPageDescription AS followUpPageDescription_88, a0_.followUpPageCss AS followUpPageCss_89, a0_.followUpPageJs AS followUpPageJs_90, a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, a0_.followUpPageTitle AS followUpPageTitle_92, a0_.followUpPageSocialImage AS followUpPageSocialImage_93, a0_.followUpDescription AS followUpDescription_94, a0_.followUpVideoLink AS followUpVideoLink_95, a0_.followUpPresentation AS followUpPresentation_96, a0_.pitchDate AS pitchDate_97, a0_.pitchTime AS pitchTime_98, a0_.city AS city_99, a0_.applicationsCount AS applicationsCount_100, a0_.startedCount AS startedCount_101, a0_.appliedCount AS appliedCount_102, a0_.approvedCount AS approvedCount_103, a0_.rejectedCount AS rejectedCount_104, a0_.$skoolWebhook AS skoolWebhook_105, a0_.zapierWebhook AS zapierWebhook_106, a0_.history AS history_107, a0_.createdAt AS createdAt_108, a0_.lastModified AS lastModified_109, a0_.lastChangeUser AS lastChangeUser_110, a0_.program_id AS program_id_111, a0_.assessmentTeamId AS assessmentTeamId_112 FROM aab_batches a0_ WHERE a0_.eventId = 6423 AND (((a0_.startDate IS NOT NULL AND a0_.startDate BETWEEN '2025-08-10 00:00:00' AND '2025-08-10 23:59:59') OR (a0_.startDate IS NULL AND a0_.pitchDate BETWEEN '2025-08-10 00:00:00' AND '2025-08-10 23:59:59'))) LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.programId AS programId_1,
  a0_.eventId AS eventId_2,
  a0_.productId AS productId_3,
  a0_.batchNumber AS batchNumber_4,
  a0_.url AS url_5,
  a0_.name AS name_6,
  a0_.slug AS slug_7,
  a0_.alias AS alias_8,
  a0_.status AS status_9,
  a0_.focusStatus AS focusStatus_10,
  a0_.lang AS lang_11,
  a0_.priceInEuroCent AS priceInEuroCent_12,
  a0_.isTaxIncluded AS isTaxIncluded_13,
  a0_.discount100MemberTags AS discount100MemberTags_14,
  a0_.discount50MemberTags AS discount50MemberTags_15,
  a0_.discount20MemberTags AS discount20MemberTags_16,
  a0_.askForTeam AS askForTeam_17,
  a0_.hasEvent AS hasEvent_18,
  a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19,
  a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20,
  a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21,
  a0_.hasIncludePhone AS hasIncludePhone_22,
  a0_.hasFollowUp AS hasFollowUp_23,
  a0_.isNetworking AS isNetworking_24,
  a0_.networkingRounds AS networkingRounds_25,
  a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26,
  a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27,
  a0_.isFutureEvent AS isFutureEvent_28,
  a0_.visibility AS visibility_29,
  a0_.access AS access_30,
  a0_.tags AS tags_31,
  a0_.typeformLink AS typeformLink_32,
  a0_.zoomLink AS zoomLink_33,
  a0_.bgImageUrl AS bgImageUrl_34,
  a0_.startDate AS startDate_35,
  a0_.endDate AS endDate_36,
  a0_.stripePriceId AS stripePriceId_37,
  a0_.stripeProductId AS stripeProductId_38,
  a0_.stripeAccount AS stripeAccount_39,
  a0_.isFreeForKiCampus AS isFreeForKiCampus_40,
  a0_.isFreeForCommunity AS isFreeForCommunity_41,
  a0_.mailDesignTemplate AS mailDesignTemplate_42,
  a0_.senderMail AS senderMail_43,
  a0_.fromName AS fromName_44,
  a0_.recipientMonitoringMail AS recipientMonitoringMail_45,
  a0_.confirmationMailSubject AS confirmationMailSubject_46,
  a0_.confirmationMailContent AS confirmationMailContent_47,
  a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48,
  a0_.adminNotificationMailContent AS adminNotificationMailContent_49,
  a0_.reminderMailTemplateId AS reminderMailTemplateId_50,
  a0_.reminderSenderEmail AS reminderSenderEmail_51,
  a0_.reminderBulkMailId AS reminderBulkMailId_52,
  a0_.reminderMailSendDate AS reminderMailSendDate_53,
  a0_.reminderMailSubject AS reminderMailSubject_54,
  a0_.reminderMailContent AS reminderMailContent_55,
  a0_.$reminderMailStatus AS reminderMailStatus_56,
  a0_.surveyId AS surveyId_57,
  a0_.surveyMailTemplateId AS surveyMailTemplateId_58,
  a0_.surveyBulkMailId AS surveyBulkMailId_59,
  a0_.template AS template_60,
  a0_.pageTemplate AS pageTemplate_61,
  a0_.footerTemplate AS footerTemplate_62,
  a0_.email AS email_63,
  a0_.emailSubject AS emailSubject_64,
  a0_.emailContent AS emailContent_65,
  a0_.landingPageContent AS landingPageContent_66,
  a0_.landingPageDescription AS landingPageDescription_67,
  a0_.landingPageCss AS landingPageCss_68,
  a0_.landingPageJs AS landingPageJs_69,
  a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70,
  a0_.landingPageSocialImage AS landingPageSocialImage_71,
  a0_.landingPageTitle AS landingPageTitle_72,
  a0_.landingPageTwig AS landingPageTwig_73,
  a0_.goToPage AS goToPage_74,
  a0_.phrasesDe AS phrasesDe_75,
  a0_.phrasesEn AS phrasesEn_76,
  a0_.settings AS settings_77,
  a0_.asssesmentDimensions AS asssesmentDimensions_78,
  a0_.start AS start_79,
  a0_.end AS end_80,
  a0_.pitchTopic AS pitchTopic_81,
  a0_.pitchImageLink AS pitchImageLink_82,
  a0_.pitchVideoLink AS pitchVideoLink_83,
  a0_.pitchPartner AS pitchPartner_84,
  a0_.pitchPartnerId AS pitchPartnerId_85,
  a0_.pitchDescription AS pitchDescription_86,
  a0_.followUpPageContent AS followUpPageContent_87,
  a0_.followUpPageDescription AS followUpPageDescription_88,
  a0_.followUpPageCss AS followUpPageCss_89,
  a0_.followUpPageJs AS followUpPageJs_90,
  a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91,
  a0_.followUpPageTitle AS followUpPageTitle_92,
  a0_.followUpPageSocialImage AS followUpPageSocialImage_93,
  a0_.followUpDescription AS followUpDescription_94,
  a0_.followUpVideoLink AS followUpVideoLink_95,
  a0_.followUpPresentation AS followUpPresentation_96,
  a0_.pitchDate AS pitchDate_97,
  a0_.pitchTime AS pitchTime_98,
  a0_.city AS city_99,
  a0_.applicationsCount AS applicationsCount_100,
  a0_.startedCount AS startedCount_101,
  a0_.appliedCount AS appliedCount_102,
  a0_.approvedCount AS approvedCount_103,
  a0_.rejectedCount AS rejectedCount_104,
  a0_.$skoolWebhook AS skoolWebhook_105,
  a0_.zapierWebhook AS zapierWebhook_106,
  a0_.history AS history_107,
  a0_.createdAt AS createdAt_108,
  a0_.lastModified AS lastModified_109,
  a0_.lastChangeUser AS lastChangeUser_110,
  a0_.program_id AS program_id_111,
  a0_.assessmentTeamId AS assessmentTeamId_112
FROM
  aab_batches a0_
WHERE
  a0_.eventId = ?
ORDER BY
  a0_.startDate ASC,
  a0_.pitchDate ASC

SELECT a0_.id AS id_0, a0_.programId AS programId_1, a0_.eventId AS eventId_2, a0_.productId AS productId_3, a0_.batchNumber AS batchNumber_4, a0_.url AS url_5, a0_.name AS name_6, a0_.slug AS slug_7, a0_.alias AS alias_8, a0_.status AS status_9, a0_.focusStatus AS focusStatus_10, a0_.lang AS lang_11, a0_.priceInEuroCent AS priceInEuroCent_12, a0_.isTaxIncluded AS isTaxIncluded_13, a0_.discount100MemberTags AS discount100MemberTags_14, a0_.discount50MemberTags AS discount50MemberTags_15, a0_.discount20MemberTags AS discount20MemberTags_16, a0_.askForTeam AS askForTeam_17, a0_.hasEvent AS hasEvent_18, a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, a0_.hasIncludePhone AS hasIncludePhone_22, a0_.hasFollowUp AS hasFollowUp_23, a0_.isNetworking AS isNetworking_24, a0_.networkingRounds AS networkingRounds_25, a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, a0_.isFutureEvent AS isFutureEvent_28, a0_.visibility AS visibility_29, a0_.access AS access_30, a0_.tags AS tags_31, a0_.typeformLink AS typeformLink_32, a0_.zoomLink AS zoomLink_33, a0_.bgImageUrl AS bgImageUrl_34, a0_.startDate AS startDate_35, a0_.endDate AS endDate_36, a0_.stripePriceId AS stripePriceId_37, a0_.stripeProductId AS stripeProductId_38, a0_.stripeAccount AS stripeAccount_39, a0_.isFreeForKiCampus AS isFreeForKiCampus_40, a0_.isFreeForCommunity AS isFreeForCommunity_41, a0_.mailDesignTemplate AS mailDesignTemplate_42, a0_.senderMail AS senderMail_43, a0_.fromName AS fromName_44, a0_.recipientMonitoringMail AS recipientMonitoringMail_45, a0_.confirmationMailSubject AS confirmationMailSubject_46, a0_.confirmationMailContent AS confirmationMailContent_47, a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, a0_.adminNotificationMailContent AS adminNotificationMailContent_49, a0_.reminderMailTemplateId AS reminderMailTemplateId_50, a0_.reminderSenderEmail AS reminderSenderEmail_51, a0_.reminderBulkMailId AS reminderBulkMailId_52, a0_.reminderMailSendDate AS reminderMailSendDate_53, a0_.reminderMailSubject AS reminderMailSubject_54, a0_.reminderMailContent AS reminderMailContent_55, a0_.$reminderMailStatus AS reminderMailStatus_56, a0_.surveyId AS surveyId_57, a0_.surveyMailTemplateId AS surveyMailTemplateId_58, a0_.surveyBulkMailId AS surveyBulkMailId_59, a0_.template AS template_60, a0_.pageTemplate AS pageTemplate_61, a0_.footerTemplate AS footerTemplate_62, a0_.email AS email_63, a0_.emailSubject AS emailSubject_64, a0_.emailContent AS emailContent_65, a0_.landingPageContent AS landingPageContent_66, a0_.landingPageDescription AS landingPageDescription_67, a0_.landingPageCss AS landingPageCss_68, a0_.landingPageJs AS landingPageJs_69, a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, a0_.landingPageSocialImage AS landingPageSocialImage_71, a0_.landingPageTitle AS landingPageTitle_72, a0_.landingPageTwig AS landingPageTwig_73, a0_.goToPage AS goToPage_74, a0_.phrasesDe AS phrasesDe_75, a0_.phrasesEn AS phrasesEn_76, a0_.settings AS settings_77, a0_.asssesmentDimensions AS asssesmentDimensions_78, a0_.start AS start_79, a0_.end AS end_80, a0_.pitchTopic AS pitchTopic_81, a0_.pitchImageLink AS pitchImageLink_82, a0_.pitchVideoLink AS pitchVideoLink_83, a0_.pitchPartner AS pitchPartner_84, a0_.pitchPartnerId AS pitchPartnerId_85, a0_.pitchDescription AS pitchDescription_86, a0_.followUpPageContent AS followUpPageContent_87, a0_.followUpPageDescription AS followUpPageDescription_88, a0_.followUpPageCss AS followUpPageCss_89, a0_.followUpPageJs AS followUpPageJs_90, a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, a0_.followUpPageTitle AS followUpPageTitle_92, a0_.followUpPageSocialImage AS followUpPageSocialImage_93, a0_.followUpDescription AS followUpDescription_94, a0_.followUpVideoLink AS followUpVideoLink_95, a0_.followUpPresentation AS followUpPresentation_96, a0_.pitchDate AS pitchDate_97, a0_.pitchTime AS pitchTime_98, a0_.city AS city_99, a0_.applicationsCount AS applicationsCount_100, a0_.startedCount AS startedCount_101, a0_.appliedCount AS appliedCount_102, a0_.approvedCount AS approvedCount_103, a0_.rejectedCount AS rejectedCount_104, a0_.$skoolWebhook AS skoolWebhook_105, a0_.zapierWebhook AS zapierWebhook_106, a0_.history AS history_107, a0_.createdAt AS createdAt_108, a0_.lastModified AS lastModified_109, a0_.lastChangeUser AS lastChangeUser_110, a0_.program_id AS program_id_111, a0_.assessmentTeamId AS assessmentTeamId_112 FROM aab_batches a0_ WHERE a0_.eventId = 6423 ORDER BY a0_.startDate ASC, a0_.pitchDate ASC;

SELECT
  a0_.id AS id_0,
  a0_.programId AS programId_1,
  a0_.eventId AS eventId_2,
  a0_.productId AS productId_3,
  a0_.batchNumber AS batchNumber_4,
  a0_.url AS url_5,
  a0_.name AS name_6,
  a0_.slug AS slug_7,
  a0_.alias AS alias_8,
  a0_.status AS status_9,
  a0_.focusStatus AS focusStatus_10,
  a0_.lang AS lang_11,
  a0_.priceInEuroCent AS priceInEuroCent_12,
  a0_.isTaxIncluded AS isTaxIncluded_13,
  a0_.discount100MemberTags AS discount100MemberTags_14,
  a0_.discount50MemberTags AS discount50MemberTags_15,
  a0_.discount20MemberTags AS discount20MemberTags_16,
  a0_.askForTeam AS askForTeam_17,
  a0_.hasEvent AS hasEvent_18,
  a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19,
  a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20,
  a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21,
  a0_.hasIncludePhone AS hasIncludePhone_22,
  a0_.hasFollowUp AS hasFollowUp_23,
  a0_.isNetworking AS isNetworking_24,
  a0_.networkingRounds AS networkingRounds_25,
  a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26,
  a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27,
  a0_.isFutureEvent AS isFutureEvent_28,
  a0_.visibility AS visibility_29,
  a0_.access AS access_30,
  a0_.tags AS tags_31,
  a0_.typeformLink AS typeformLink_32,
  a0_.zoomLink AS zoomLink_33,
  a0_.bgImageUrl AS bgImageUrl_34,
  a0_.startDate AS startDate_35,
  a0_.endDate AS endDate_36,
  a0_.stripePriceId AS stripePriceId_37,
  a0_.stripeProductId AS stripeProductId_38,
  a0_.stripeAccount AS stripeAccount_39,
  a0_.isFreeForKiCampus AS isFreeForKiCampus_40,
  a0_.isFreeForCommunity AS isFreeForCommunity_41,
  a0_.mailDesignTemplate AS mailDesignTemplate_42,
  a0_.senderMail AS senderMail_43,
  a0_.fromName AS fromName_44,
  a0_.recipientMonitoringMail AS recipientMonitoringMail_45,
  a0_.confirmationMailSubject AS confirmationMailSubject_46,
  a0_.confirmationMailContent AS confirmationMailContent_47,
  a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48,
  a0_.adminNotificationMailContent AS adminNotificationMailContent_49,
  a0_.reminderMailTemplateId AS reminderMailTemplateId_50,
  a0_.reminderSenderEmail AS reminderSenderEmail_51,
  a0_.reminderBulkMailId AS reminderBulkMailId_52,
  a0_.reminderMailSendDate AS reminderMailSendDate_53,
  a0_.reminderMailSubject AS reminderMailSubject_54,
  a0_.reminderMailContent AS reminderMailContent_55,
  a0_.$reminderMailStatus AS reminderMailStatus_56,
  a0_.surveyId AS surveyId_57,
  a0_.surveyMailTemplateId AS surveyMailTemplateId_58,
  a0_.surveyBulkMailId AS surveyBulkMailId_59,
  a0_.template AS template_60,
  a0_.pageTemplate AS pageTemplate_61,
  a0_.footerTemplate AS footerTemplate_62,
  a0_.email AS email_63,
  a0_.emailSubject AS emailSubject_64,
  a0_.emailContent AS emailContent_65,
  a0_.landingPageContent AS landingPageContent_66,
  a0_.landingPageDescription AS landingPageDescription_67,
  a0_.landingPageCss AS landingPageCss_68,
  a0_.landingPageJs AS landingPageJs_69,
  a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70,
  a0_.landingPageSocialImage AS landingPageSocialImage_71,
  a0_.landingPageTitle AS landingPageTitle_72,
  a0_.landingPageTwig AS landingPageTwig_73,
  a0_.goToPage AS goToPage_74,
  a0_.phrasesDe AS phrasesDe_75,
  a0_.phrasesEn AS phrasesEn_76,
  a0_.settings AS settings_77,
  a0_.asssesmentDimensions AS asssesmentDimensions_78,
  a0_.start AS start_79,
  a0_.end AS end_80,
  a0_.pitchTopic AS pitchTopic_81,
  a0_.pitchImageLink AS pitchImageLink_82,
  a0_.pitchVideoLink AS pitchVideoLink_83,
  a0_.pitchPartner AS pitchPartner_84,
  a0_.pitchPartnerId AS pitchPartnerId_85,
  a0_.pitchDescription AS pitchDescription_86,
  a0_.followUpPageContent AS followUpPageContent_87,
  a0_.followUpPageDescription AS followUpPageDescription_88,
  a0_.followUpPageCss AS followUpPageCss_89,
  a0_.followUpPageJs AS followUpPageJs_90,
  a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91,
  a0_.followUpPageTitle AS followUpPageTitle_92,
  a0_.followUpPageSocialImage AS followUpPageSocialImage_93,
  a0_.followUpDescription AS followUpDescription_94,
  a0_.followUpVideoLink AS followUpVideoLink_95,
  a0_.followUpPresentation AS followUpPresentation_96,
  a0_.pitchDate AS pitchDate_97,
  a0_.pitchTime AS pitchTime_98,
  a0_.city AS city_99,
  a0_.applicationsCount AS applicationsCount_100,
  a0_.startedCount AS startedCount_101,
  a0_.appliedCount AS appliedCount_102,
  a0_.approvedCount AS approvedCount_103,
  a0_.rejectedCount AS rejectedCount_104,
  a0_.$skoolWebhook AS skoolWebhook_105,
  a0_.zapierWebhook AS zapierWebhook_106,
  a0_.history AS history_107,
  a0_.createdAt AS createdAt_108,
  a0_.lastModified AS lastModified_109,
  a0_.lastChangeUser AS lastChangeUser_110,
  a0_.program_id AS program_id_111,
  a0_.assessmentTeamId AS assessmentTeamId_112
FROM
  aab_batches a0_
WHERE
  a0_.eventId = ?
  AND a0_.status = ?
  AND (
    (
      (
        a0_.startDate IS NOT NULL
        AND a0_.startDate > ?
      )
      OR (
        a0_.startDate IS NULL
        AND a0_.pitchDate > ?
      )
    )
  )
ORDER BY
  a0_.startDate ASC,
  a0_.pitchDate ASC
LIMIT
  10

SELECT a0_.id AS id_0, a0_.programId AS programId_1, a0_.eventId AS eventId_2, a0_.productId AS productId_3, a0_.batchNumber AS batchNumber_4, a0_.url AS url_5, a0_.name AS name_6, a0_.slug AS slug_7, a0_.alias AS alias_8, a0_.status AS status_9, a0_.focusStatus AS focusStatus_10, a0_.lang AS lang_11, a0_.priceInEuroCent AS priceInEuroCent_12, a0_.isTaxIncluded AS isTaxIncluded_13, a0_.discount100MemberTags AS discount100MemberTags_14, a0_.discount50MemberTags AS discount50MemberTags_15, a0_.discount20MemberTags AS discount20MemberTags_16, a0_.askForTeam AS askForTeam_17, a0_.hasEvent AS hasEvent_18, a0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19, a0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_20, a0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_21, a0_.hasIncludePhone AS hasIncludePhone_22, a0_.hasFollowUp AS hasFollowUp_23, a0_.isNetworking AS isNetworking_24, a0_.networkingRounds AS networkingRounds_25, a0_.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, a0_.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, a0_.isFutureEvent AS isFutureEvent_28, a0_.visibility AS visibility_29, a0_.access AS access_30, a0_.tags AS tags_31, a0_.typeformLink AS typeformLink_32, a0_.zoomLink AS zoomLink_33, a0_.bgImageUrl AS bgImageUrl_34, a0_.startDate AS startDate_35, a0_.endDate AS endDate_36, a0_.stripePriceId AS stripePriceId_37, a0_.stripeProductId AS stripeProductId_38, a0_.stripeAccount AS stripeAccount_39, a0_.isFreeForKiCampus AS isFreeForKiCampus_40, a0_.isFreeForCommunity AS isFreeForCommunity_41, a0_.mailDesignTemplate AS mailDesignTemplate_42, a0_.senderMail AS senderMail_43, a0_.fromName AS fromName_44, a0_.recipientMonitoringMail AS recipientMonitoringMail_45, a0_.confirmationMailSubject AS confirmationMailSubject_46, a0_.confirmationMailContent AS confirmationMailContent_47, a0_.adminNotificationMailSubject AS adminNotificationMailSubject_48, a0_.adminNotificationMailContent AS adminNotificationMailContent_49, a0_.reminderMailTemplateId AS reminderMailTemplateId_50, a0_.reminderSenderEmail AS reminderSenderEmail_51, a0_.reminderBulkMailId AS reminderBulkMailId_52, a0_.reminderMailSendDate AS reminderMailSendDate_53, a0_.reminderMailSubject AS reminderMailSubject_54, a0_.reminderMailContent AS reminderMailContent_55, a0_.$reminderMailStatus AS reminderMailStatus_56, a0_.surveyId AS surveyId_57, a0_.surveyMailTemplateId AS surveyMailTemplateId_58, a0_.surveyBulkMailId AS surveyBulkMailId_59, a0_.template AS template_60, a0_.pageTemplate AS pageTemplate_61, a0_.footerTemplate AS footerTemplate_62, a0_.email AS email_63, a0_.emailSubject AS emailSubject_64, a0_.emailContent AS emailContent_65, a0_.landingPageContent AS landingPageContent_66, a0_.landingPageDescription AS landingPageDescription_67, a0_.landingPageCss AS landingPageCss_68, a0_.landingPageJs AS landingPageJs_69, a0_.landingPageFooterTemplate AS landingPageFooterTemplate_70, a0_.landingPageSocialImage AS landingPageSocialImage_71, a0_.landingPageTitle AS landingPageTitle_72, a0_.landingPageTwig AS landingPageTwig_73, a0_.goToPage AS goToPage_74, a0_.phrasesDe AS phrasesDe_75, a0_.phrasesEn AS phrasesEn_76, a0_.settings AS settings_77, a0_.asssesmentDimensions AS asssesmentDimensions_78, a0_.start AS start_79, a0_.end AS end_80, a0_.pitchTopic AS pitchTopic_81, a0_.pitchImageLink AS pitchImageLink_82, a0_.pitchVideoLink AS pitchVideoLink_83, a0_.pitchPartner AS pitchPartner_84, a0_.pitchPartnerId AS pitchPartnerId_85, a0_.pitchDescription AS pitchDescription_86, a0_.followUpPageContent AS followUpPageContent_87, a0_.followUpPageDescription AS followUpPageDescription_88, a0_.followUpPageCss AS followUpPageCss_89, a0_.followUpPageJs AS followUpPageJs_90, a0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_91, a0_.followUpPageTitle AS followUpPageTitle_92, a0_.followUpPageSocialImage AS followUpPageSocialImage_93, a0_.followUpDescription AS followUpDescription_94, a0_.followUpVideoLink AS followUpVideoLink_95, a0_.followUpPresentation AS followUpPresentation_96, a0_.pitchDate AS pitchDate_97, a0_.pitchTime AS pitchTime_98, a0_.city AS city_99, a0_.applicationsCount AS applicationsCount_100, a0_.startedCount AS startedCount_101, a0_.appliedCount AS appliedCount_102, a0_.approvedCount AS approvedCount_103, a0_.rejectedCount AS rejectedCount_104, a0_.$skoolWebhook AS skoolWebhook_105, a0_.zapierWebhook AS zapierWebhook_106, a0_.history AS history_107, a0_.createdAt AS createdAt_108, a0_.lastModified AS lastModified_109, a0_.lastChangeUser AS lastChangeUser_110, a0_.program_id AS program_id_111, a0_.assessmentTeamId AS assessmentTeamId_112 FROM aab_batches a0_ WHERE a0_.eventId = 6423 AND a0_.status = 'active' AND (((a0_.startDate IS NOT NULL AND a0_.startDate > '2025-12-29 02:52:03') OR (a0_.startDate IS NULL AND a0_.pitchDate > '2025-12-29 02:52:03'))) ORDER BY a0_.startDate ASC, a0_.pitchDate ASC LIMIT 10;