Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.eventbriteId AS eventbriteId_2,
  t0.googleCalendarEventId AS googleCalendarEventId_3,
  t0.wpPostId AS wpPostId_4,
  t0.title AS title_5,
  t0.slug AS slug_6,
  t0.lang AS lang_7,
  t0.imagelink AS imagelink_8,
  t0.videolink AS videolink_9,
  t0.bgImagelink AS bgImagelink_10,
  t0.tagline AS tagline_11,
  t0.headerTextColor AS headerTextColor_12,
  t0.spResponsiblePerson AS spResponsiblePerson_13,
  t0.organization AS organization_14,
  t0.organizerName AS organizerName_15,
  t0.organizerEmail AS organizerEmail_16,
  t0.venueName AS venueName_17,
  t0.venueAddress AS venueAddress_18,
  t0.ticketing AS ticketing_19,
  t0.applicationUrl AS applicationUrl_20,
  t0.alert AS alert_21,
  t0.trainer AS trainer_22,
  t0.speakers AS speakers_23,
  t0.teaser AS teaser_24,
  t0.navbar AS navbar_25,
  t0.stripePriceId AS stripePriceId_26,
  t0.stripeProductId AS stripeProductId_27,
  t0.stripeAccount AS stripeAccount_28,
  t0.priceInEuroCent AS priceInEuroCent_29,
  t0.isTaxIncluded AS isTaxIncluded_30,
  t0.isFreeForKiCampus AS isFreeForKiCampus_31,
  t0.isFreeForCommunity AS isFreeForCommunity_32,
  t0.isSinglePage AS isSinglePage_33,
  t0.isFormalLanguage AS isFormalLanguage_34,
  t0.isMultiBatchEvent AS isMultiBatchEvent_35,
  t0.isFeatured AS isFeatured_36,
  t0.capacity AS capacity_37,
  t0.twigFile AS twigFile_38,
  t0.additionalCss AS additionalCss_39,
  t0.content AS content_40,
  t0.contentTwig AS contentTwig_41,
  t0.ctaContent AS ctaContent_42,
  t0.postCtaContent AS postCtaContent_43,
  t0.tags AS tags_44,
  t0.seriesTag AS seriesTag_45,
  t0.type AS type_46,
  t0.location AS location_47,
  t0.startDate AS startDate_48,
  t0.endDate AS endDate_49,
  t0.duration AS duration_50,
  t0.status AS status_51,
  t0.settings AS settings_52,
  t0.displayStartDate AS displayStartDate_53,
  t0.seoTitle AS seoTitle_54,
  t0.seoKeyword AS seoKeyword_55,
  t0.seoDescription AS seoDescription_56,
  t0.navbar_en AS navbar_en_57,
  t0.teaser_en AS teaser_en_58,
  t0.content_en AS content_en_59,
  t0.content_twig_en AS content_twig_en_60,
  t0.post_cta_content_en AS post_cta_content_en_61,
  t0.seo_title_en AS seo_title_en_62,
  t0.seo_description_en AS seo_description_en_63,
  t0.seo_keyword_en AS seo_keyword_en_64,
  t0.has_english_version AS has_english_version_65,
  t0.additional_js AS additional_js_66,
  t0.metaPixelId AS metaPixelId_67,
  t0.createDate AS createDate_68,
  t0.lastChangeDate AS lastChangeDate_69,
  t0.lastChangeUser AS lastChangeUser_70,
  t0.publicId AS publicId_71,
  t0.isExternalSubmission AS isExternalSubmission_72,
  t0.createdBy AS createdBy_73,
  t0.lastModified AS lastModified_74,
  t0.createdAt AS createdAt_75,
  t0.orgaNote AS orgaNote_76,
  t0.history AS history_77,
  t0.todoHistory AS todoHistory_78
FROM
  sp_event_events t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.slug AS slug_6, t0.lang AS lang_7, t0.imagelink AS imagelink_8, t0.videolink AS videolink_9, t0.bgImagelink AS bgImagelink_10, t0.tagline AS tagline_11, t0.headerTextColor AS headerTextColor_12, t0.spResponsiblePerson AS spResponsiblePerson_13, t0.organization AS organization_14, t0.organizerName AS organizerName_15, t0.organizerEmail AS organizerEmail_16, t0.venueName AS venueName_17, t0.venueAddress AS venueAddress_18, t0.ticketing AS ticketing_19, t0.applicationUrl AS applicationUrl_20, t0.alert AS alert_21, t0.trainer AS trainer_22, t0.speakers AS speakers_23, t0.teaser AS teaser_24, t0.navbar AS navbar_25, t0.stripePriceId AS stripePriceId_26, t0.stripeProductId AS stripeProductId_27, t0.stripeAccount AS stripeAccount_28, t0.priceInEuroCent AS priceInEuroCent_29, t0.isTaxIncluded AS isTaxIncluded_30, t0.isFreeForKiCampus AS isFreeForKiCampus_31, t0.isFreeForCommunity AS isFreeForCommunity_32, t0.isSinglePage AS isSinglePage_33, t0.isFormalLanguage AS isFormalLanguage_34, t0.isMultiBatchEvent AS isMultiBatchEvent_35, t0.isFeatured AS isFeatured_36, t0.capacity AS capacity_37, t0.twigFile AS twigFile_38, t0.additionalCss AS additionalCss_39, t0.content AS content_40, t0.contentTwig AS contentTwig_41, t0.ctaContent AS ctaContent_42, t0.postCtaContent AS postCtaContent_43, t0.tags AS tags_44, t0.seriesTag AS seriesTag_45, t0.type AS type_46, t0.location AS location_47, t0.startDate AS startDate_48, t0.endDate AS endDate_49, t0.duration AS duration_50, t0.status AS status_51, t0.settings AS settings_52, t0.displayStartDate AS displayStartDate_53, t0.seoTitle AS seoTitle_54, t0.seoKeyword AS seoKeyword_55, t0.seoDescription AS seoDescription_56, t0.navbar_en AS navbar_en_57, t0.teaser_en AS teaser_en_58, t0.content_en AS content_en_59, t0.content_twig_en AS content_twig_en_60, t0.post_cta_content_en AS post_cta_content_en_61, t0.seo_title_en AS seo_title_en_62, t0.seo_description_en AS seo_description_en_63, t0.seo_keyword_en AS seo_keyword_en_64, t0.has_english_version AS has_english_version_65, t0.additional_js AS additional_js_66, t0.metaPixelId AS metaPixelId_67, t0.createDate AS createDate_68, t0.lastChangeDate AS lastChangeDate_69, t0.lastChangeUser AS lastChangeUser_70, t0.publicId AS publicId_71, t0.isExternalSubmission AS isExternalSubmission_72, t0.createdBy AS createdBy_73, t0.lastModified AS lastModified_74, t0.createdAt AS createdAt_75, t0.orgaNote AS orgaNote_76, t0.history AS history_77, t0.todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0.slug = 'ai-friday-ki-community-meetup-koeln' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.eventbriteId AS eventbriteId_1,
  s0_.googleCalendarEventId AS googleCalendarEventId_2,
  s0_.wpPostId AS wpPostId_3,
  s0_.title AS title_4,
  s0_.slug AS slug_5,
  s0_.lang AS lang_6,
  s0_.imagelink AS imagelink_7,
  s0_.videolink AS videolink_8,
  s0_.bgImagelink AS bgImagelink_9,
  s0_.tagline AS tagline_10,
  s0_.headerTextColor AS headerTextColor_11,
  s0_.spResponsiblePerson AS spResponsiblePerson_12,
  s0_.organization AS organization_13,
  s0_.organizerName AS organizerName_14,
  s0_.organizerEmail AS organizerEmail_15,
  s0_.venueName AS venueName_16,
  s0_.venueAddress AS venueAddress_17,
  s0_.ticketing AS ticketing_18,
  s0_.applicationUrl AS applicationUrl_19,
  s0_.alert AS alert_20,
  s0_.trainer AS trainer_21,
  s0_.speakers AS speakers_22,
  s0_.teaser AS teaser_23,
  s0_.navbar AS navbar_24,
  s0_.stripePriceId AS stripePriceId_25,
  s0_.stripeProductId AS stripeProductId_26,
  s0_.stripeAccount AS stripeAccount_27,
  s0_.priceInEuroCent AS priceInEuroCent_28,
  s0_.isTaxIncluded AS isTaxIncluded_29,
  s0_.isFreeForKiCampus AS isFreeForKiCampus_30,
  s0_.isFreeForCommunity AS isFreeForCommunity_31,
  s0_.isSinglePage AS isSinglePage_32,
  s0_.isFormalLanguage AS isFormalLanguage_33,
  s0_.isMultiBatchEvent AS isMultiBatchEvent_34,
  s0_.isFeatured AS isFeatured_35,
  s0_.capacity AS capacity_36,
  s0_.twigFile AS twigFile_37,
  s0_.additionalCss AS additionalCss_38,
  s0_.content AS content_39,
  s0_.contentTwig AS contentTwig_40,
  s0_.ctaContent AS ctaContent_41,
  s0_.postCtaContent AS postCtaContent_42,
  s0_.tags AS tags_43,
  s0_.seriesTag AS seriesTag_44,
  s0_.type AS type_45,
  s0_.location AS location_46,
  s0_.startDate AS startDate_47,
  s0_.endDate AS endDate_48,
  s0_.duration AS duration_49,
  s0_.status AS status_50,
  s0_.settings AS settings_51,
  s0_.displayStartDate AS displayStartDate_52,
  s0_.seoTitle AS seoTitle_53,
  s0_.seoKeyword AS seoKeyword_54,
  s0_.seoDescription AS seoDescription_55,
  s0_.navbar_en AS navbar_en_56,
  s0_.teaser_en AS teaser_en_57,
  s0_.content_en AS content_en_58,
  s0_.content_twig_en AS content_twig_en_59,
  s0_.post_cta_content_en AS post_cta_content_en_60,
  s0_.seo_title_en AS seo_title_en_61,
  s0_.seo_description_en AS seo_description_en_62,
  s0_.seo_keyword_en AS seo_keyword_en_63,
  s0_.has_english_version AS has_english_version_64,
  s0_.additional_js AS additional_js_65,
  s0_.metaPixelId AS metaPixelId_66,
  s0_.createDate AS createDate_67,
  s0_.lastChangeDate AS lastChangeDate_68,
  s0_.lastChangeUser AS lastChangeUser_69,
  s0_.publicId AS publicId_70,
  s0_.isExternalSubmission AS isExternalSubmission_71,
  s0_.createdBy AS createdBy_72,
  s0_.lastModified AS lastModified_73,
  s0_.createdAt AS createdAt_74,
  s0_.orgaNote AS orgaNote_75,
  s0_.history AS history_76,
  s0_.todoHistory AS todoHistory_77
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_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.slug AS slug_5, s0_.lang AS lang_6, s0_.imagelink AS imagelink_7, s0_.videolink AS videolink_8, s0_.bgImagelink AS bgImagelink_9, s0_.tagline AS tagline_10, s0_.headerTextColor AS headerTextColor_11, s0_.spResponsiblePerson AS spResponsiblePerson_12, s0_.organization AS organization_13, s0_.organizerName AS organizerName_14, s0_.organizerEmail AS organizerEmail_15, s0_.venueName AS venueName_16, s0_.venueAddress AS venueAddress_17, s0_.ticketing AS ticketing_18, s0_.applicationUrl AS applicationUrl_19, s0_.alert AS alert_20, s0_.trainer AS trainer_21, s0_.speakers AS speakers_22, s0_.teaser AS teaser_23, s0_.navbar AS navbar_24, s0_.stripePriceId AS stripePriceId_25, s0_.stripeProductId AS stripeProductId_26, s0_.stripeAccount AS stripeAccount_27, s0_.priceInEuroCent AS priceInEuroCent_28, s0_.isTaxIncluded AS isTaxIncluded_29, s0_.isFreeForKiCampus AS isFreeForKiCampus_30, s0_.isFreeForCommunity AS isFreeForCommunity_31, s0_.isSinglePage AS isSinglePage_32, s0_.isFormalLanguage AS isFormalLanguage_33, s0_.isMultiBatchEvent AS isMultiBatchEvent_34, s0_.isFeatured AS isFeatured_35, s0_.capacity AS capacity_36, s0_.twigFile AS twigFile_37, s0_.additionalCss AS additionalCss_38, s0_.content AS content_39, s0_.contentTwig AS contentTwig_40, s0_.ctaContent AS ctaContent_41, s0_.postCtaContent AS postCtaContent_42, s0_.tags AS tags_43, s0_.seriesTag AS seriesTag_44, s0_.type AS type_45, s0_.location AS location_46, s0_.startDate AS startDate_47, s0_.endDate AS endDate_48, s0_.duration AS duration_49, s0_.status AS status_50, s0_.settings AS settings_51, s0_.displayStartDate AS displayStartDate_52, s0_.seoTitle AS seoTitle_53, s0_.seoKeyword AS seoKeyword_54, s0_.seoDescription AS seoDescription_55, s0_.navbar_en AS navbar_en_56, s0_.teaser_en AS teaser_en_57, s0_.content_en AS content_en_58, s0_.content_twig_en AS content_twig_en_59, s0_.post_cta_content_en AS post_cta_content_en_60, s0_.seo_title_en AS seo_title_en_61, s0_.seo_description_en AS seo_description_en_62, s0_.seo_keyword_en AS seo_keyword_en_63, s0_.has_english_version AS has_english_version_64, s0_.additional_js AS additional_js_65, s0_.metaPixelId AS metaPixelId_66, s0_.createDate AS createDate_67, s0_.lastChangeDate AS lastChangeDate_68, s0_.lastChangeUser AS lastChangeUser_69, s0_.publicId AS publicId_70, s0_.isExternalSubmission AS isExternalSubmission_71, s0_.createdBy AS createdBy_72, s0_.lastModified AS lastModified_73, s0_.createdAt AS createdAt_74, s0_.orgaNote AS orgaNote_75, s0_.history AS history_76, s0_.todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_.seriesTag LIKE '%ai-friday-koeln%' 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_.stripePriceIdLive AS stripePriceIdLive_40,
  s0_.stripePriceIdTest AS stripePriceIdTest_41,
  s0_.stripeProductIdLive AS stripeProductIdLive_42,
  s0_.stripeProductIdTest AS stripeProductIdTest_43,
  s0_.taxBehavior AS taxBehavior_44,
  s0_.paymentProvider AS paymentProvider_45,
  s0_.isFreeForKiCampus AS isFreeForKiCampus_46,
  s0_.isFreeForCommunity AS isFreeForCommunity_47,
  s0_.registrationMode AS registrationMode_48,
  s0_.externalRegistrationUrl AS externalRegistrationUrl_49,
  s0_.externalPlatform AS externalPlatform_50,
  s0_.registrationHeadline AS registrationHeadline_51,
  s0_.registrationSubtitle AS registrationSubtitle_52,
  s0_.registrationButtonText AS registrationButtonText_53,
  s0_.registrationRedirectUrl AS registrationRedirectUrl_54,
  s0_.lumaEventApiId AS lumaEventApiId_55,
  s0_.meetupEventId AS meetupEventId_56,
  s0_.meetupEventUrl AS meetupEventUrl_57,
  s0_.mailDesignTemplate AS mailDesignTemplate_58,
  s0_.senderMail AS senderMail_59,
  s0_.fromName AS fromName_60,
  s0_.recipientMonitoringMail AS recipientMonitoringMail_61,
  s0_.confirmationMailSubject AS confirmationMailSubject_62,
  s0_.confirmationMailContent AS confirmationMailContent_63,
  s0_.adminNotificationMailSubject AS adminNotificationMailSubject_64,
  s0_.adminNotificationMailContent AS adminNotificationMailContent_65,
  s0_.reminderMailTemplateId AS reminderMailTemplateId_66,
  s0_.reminderSenderEmail AS reminderSenderEmail_67,
  s0_.reminderBulkMailId AS reminderBulkMailId_68,
  s0_.reminderMailSendDate AS reminderMailSendDate_69,
  s0_.reminderMailSubject AS reminderMailSubject_70,
  s0_.reminderMailContent AS reminderMailContent_71,
  s0_.$reminderMailStatus AS reminderMailStatus_72,
  s0_.surveyId AS surveyId_73,
  s0_.surveyMailTemplateId AS surveyMailTemplateId_74,
  s0_.surveyBulkMailId AS surveyBulkMailId_75,
  s0_.template AS template_76,
  s0_.pageTemplate AS pageTemplate_77,
  s0_.footerTemplate AS footerTemplate_78,
  s0_.email AS email_79,
  s0_.emailSubject AS emailSubject_80,
  s0_.emailContent AS emailContent_81,
  s0_.landingPageContent AS landingPageContent_82,
  s0_.landingPageDescription AS landingPageDescription_83,
  s0_.landingPageCss AS landingPageCss_84,
  s0_.landingPageJs AS landingPageJs_85,
  s0_.landingPageFooterTemplate AS landingPageFooterTemplate_86,
  s0_.landingPageSocialImage AS landingPageSocialImage_87,
  s0_.hasCustomPage AS hasCustomPage_88,
  s0_.landingPageTitle AS landingPageTitle_89,
  s0_.landingPageTwig AS landingPageTwig_90,
  s0_.goToPage AS goToPage_91,
  s0_.phrasesDe AS phrasesDe_92,
  s0_.phrasesEn AS phrasesEn_93,
  s0_.settings AS settings_94,
  s0_.capacity AS capacity_95,
  s0_.asssesmentDimensions AS asssesmentDimensions_96,
  s0_.start AS start_97,
  s0_.end AS end_98,
  s0_.pitchTopic AS pitchTopic_99,
  s0_.pitchImageLink AS pitchImageLink_100,
  s0_.pitchVideoLink AS pitchVideoLink_101,
  s0_.pitchPartner AS pitchPartner_102,
  s0_.pitchPartnerId AS pitchPartnerId_103,
  s0_.pitchDescription AS pitchDescription_104,
  s0_.followUpPageContent AS followUpPageContent_105,
  s0_.followUpPageDescription AS followUpPageDescription_106,
  s0_.followUpPageCss AS followUpPageCss_107,
  s0_.followUpPageJs AS followUpPageJs_108,
  s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_109,
  s0_.followUpPageTitle AS followUpPageTitle_110,
  s0_.followUpPageSocialImage AS followUpPageSocialImage_111,
  s0_.followUpDescription AS followUpDescription_112,
  s0_.followUpVideoLink AS followUpVideoLink_113,
  s0_.followUpPresentation AS followUpPresentation_114,
  s0_.followUpSkoolUrl AS followUpSkoolUrl_115,
  s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_116,
  s0_.followUpCtaText AS followUpCtaText_117,
  s0_.followUpCtaUrl AS followUpCtaUrl_118,
  s0_.followUpDocuments AS followUpDocuments_119,
  s0_.followUpPhotos AS followUpPhotos_120,
  s0_.followUpExtraLinks AS followUpExtraLinks_121,
  s0_.followUpChecklist AS followUpChecklist_122,
  s0_.pitchDate AS pitchDate_123,
  s0_.pitchTime AS pitchTime_124,
  s0_.prepitchDate AS prepitchDate_125,
  s0_.city AS city_126,
  s0_.applicationsCount AS applicationsCount_127,
  s0_.startedCount AS startedCount_128,
  s0_.appliedCount AS appliedCount_129,
  s0_.approvedCount AS approvedCount_130,
  s0_.rejectedCount AS rejectedCount_131,
  s0_.$skoolWebhook AS skoolWebhook_132,
  s0_.zapierWebhook AS zapierWebhook_133,
  s0_.history AS history_134,
  s0_.createdAt AS createdAt_135,
  s0_.lastModified AS lastModified_136,
  s0_.lastChangeUser AS lastChangeUser_137,
  s0_.program_id AS program_id_138,
  s0_.assessmentTeamId AS assessmentTeamId_139
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_.stripePriceIdLive AS stripePriceIdLive_40, s0_.stripePriceIdTest AS stripePriceIdTest_41, s0_.stripeProductIdLive AS stripeProductIdLive_42, s0_.stripeProductIdTest AS stripeProductIdTest_43, s0_.taxBehavior AS taxBehavior_44, s0_.paymentProvider AS paymentProvider_45, s0_.isFreeForKiCampus AS isFreeForKiCampus_46, s0_.isFreeForCommunity AS isFreeForCommunity_47, s0_.registrationMode AS registrationMode_48, s0_.externalRegistrationUrl AS externalRegistrationUrl_49, s0_.externalPlatform AS externalPlatform_50, s0_.registrationHeadline AS registrationHeadline_51, s0_.registrationSubtitle AS registrationSubtitle_52, s0_.registrationButtonText AS registrationButtonText_53, s0_.registrationRedirectUrl AS registrationRedirectUrl_54, s0_.lumaEventApiId AS lumaEventApiId_55, s0_.meetupEventId AS meetupEventId_56, s0_.meetupEventUrl AS meetupEventUrl_57, s0_.mailDesignTemplate AS mailDesignTemplate_58, s0_.senderMail AS senderMail_59, s0_.fromName AS fromName_60, s0_.recipientMonitoringMail AS recipientMonitoringMail_61, s0_.confirmationMailSubject AS confirmationMailSubject_62, s0_.confirmationMailContent AS confirmationMailContent_63, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_64, s0_.adminNotificationMailContent AS adminNotificationMailContent_65, s0_.reminderMailTemplateId AS reminderMailTemplateId_66, s0_.reminderSenderEmail AS reminderSenderEmail_67, s0_.reminderBulkMailId AS reminderBulkMailId_68, s0_.reminderMailSendDate AS reminderMailSendDate_69, s0_.reminderMailSubject AS reminderMailSubject_70, s0_.reminderMailContent AS reminderMailContent_71, s0_.$reminderMailStatus AS reminderMailStatus_72, s0_.surveyId AS surveyId_73, s0_.surveyMailTemplateId AS surveyMailTemplateId_74, s0_.surveyBulkMailId AS surveyBulkMailId_75, s0_.template AS template_76, s0_.pageTemplate AS pageTemplate_77, s0_.footerTemplate AS footerTemplate_78, s0_.email AS email_79, s0_.emailSubject AS emailSubject_80, s0_.emailContent AS emailContent_81, s0_.landingPageContent AS landingPageContent_82, s0_.landingPageDescription AS landingPageDescription_83, s0_.landingPageCss AS landingPageCss_84, s0_.landingPageJs AS landingPageJs_85, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_86, s0_.landingPageSocialImage AS landingPageSocialImage_87, s0_.hasCustomPage AS hasCustomPage_88, s0_.landingPageTitle AS landingPageTitle_89, s0_.landingPageTwig AS landingPageTwig_90, s0_.goToPage AS goToPage_91, s0_.phrasesDe AS phrasesDe_92, s0_.phrasesEn AS phrasesEn_93, s0_.settings AS settings_94, s0_.capacity AS capacity_95, s0_.asssesmentDimensions AS asssesmentDimensions_96, s0_.start AS start_97, s0_.end AS end_98, s0_.pitchTopic AS pitchTopic_99, s0_.pitchImageLink AS pitchImageLink_100, s0_.pitchVideoLink AS pitchVideoLink_101, s0_.pitchPartner AS pitchPartner_102, s0_.pitchPartnerId AS pitchPartnerId_103, s0_.pitchDescription AS pitchDescription_104, s0_.followUpPageContent AS followUpPageContent_105, s0_.followUpPageDescription AS followUpPageDescription_106, s0_.followUpPageCss AS followUpPageCss_107, s0_.followUpPageJs AS followUpPageJs_108, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_109, s0_.followUpPageTitle AS followUpPageTitle_110, s0_.followUpPageSocialImage AS followUpPageSocialImage_111, s0_.followUpDescription AS followUpDescription_112, s0_.followUpVideoLink AS followUpVideoLink_113, s0_.followUpPresentation AS followUpPresentation_114, s0_.followUpSkoolUrl AS followUpSkoolUrl_115, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_116, s0_.followUpCtaText AS followUpCtaText_117, s0_.followUpCtaUrl AS followUpCtaUrl_118, s0_.followUpDocuments AS followUpDocuments_119, s0_.followUpPhotos AS followUpPhotos_120, s0_.followUpExtraLinks AS followUpExtraLinks_121, s0_.followUpChecklist AS followUpChecklist_122, s0_.pitchDate AS pitchDate_123, s0_.pitchTime AS pitchTime_124, s0_.prepitchDate AS prepitchDate_125, s0_.city AS city_126, s0_.applicationsCount AS applicationsCount_127, s0_.startedCount AS startedCount_128, s0_.appliedCount AS appliedCount_129, s0_.approvedCount AS approvedCount_130, s0_.rejectedCount AS rejectedCount_131, s0_.$skoolWebhook AS skoolWebhook_132, s0_.zapierWebhook AS zapierWebhook_133, s0_.history AS history_134, s0_.createdAt AS createdAt_135, s0_.lastModified AS lastModified_136, s0_.lastChangeUser AS lastChangeUser_137, s0_.program_id AS program_id_138, s0_.assessmentTeamId AS assessmentTeamId_139 FROM sp_batches s0_ WHERE s0_.eventId = 6737 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_.stripePriceIdLive AS stripePriceIdLive_40,
  s0_.stripePriceIdTest AS stripePriceIdTest_41,
  s0_.stripeProductIdLive AS stripeProductIdLive_42,
  s0_.stripeProductIdTest AS stripeProductIdTest_43,
  s0_.taxBehavior AS taxBehavior_44,
  s0_.paymentProvider AS paymentProvider_45,
  s0_.isFreeForKiCampus AS isFreeForKiCampus_46,
  s0_.isFreeForCommunity AS isFreeForCommunity_47,
  s0_.registrationMode AS registrationMode_48,
  s0_.externalRegistrationUrl AS externalRegistrationUrl_49,
  s0_.externalPlatform AS externalPlatform_50,
  s0_.registrationHeadline AS registrationHeadline_51,
  s0_.registrationSubtitle AS registrationSubtitle_52,
  s0_.registrationButtonText AS registrationButtonText_53,
  s0_.registrationRedirectUrl AS registrationRedirectUrl_54,
  s0_.lumaEventApiId AS lumaEventApiId_55,
  s0_.meetupEventId AS meetupEventId_56,
  s0_.meetupEventUrl AS meetupEventUrl_57,
  s0_.mailDesignTemplate AS mailDesignTemplate_58,
  s0_.senderMail AS senderMail_59,
  s0_.fromName AS fromName_60,
  s0_.recipientMonitoringMail AS recipientMonitoringMail_61,
  s0_.confirmationMailSubject AS confirmationMailSubject_62,
  s0_.confirmationMailContent AS confirmationMailContent_63,
  s0_.adminNotificationMailSubject AS adminNotificationMailSubject_64,
  s0_.adminNotificationMailContent AS adminNotificationMailContent_65,
  s0_.reminderMailTemplateId AS reminderMailTemplateId_66,
  s0_.reminderSenderEmail AS reminderSenderEmail_67,
  s0_.reminderBulkMailId AS reminderBulkMailId_68,
  s0_.reminderMailSendDate AS reminderMailSendDate_69,
  s0_.reminderMailSubject AS reminderMailSubject_70,
  s0_.reminderMailContent AS reminderMailContent_71,
  s0_.$reminderMailStatus AS reminderMailStatus_72,
  s0_.surveyId AS surveyId_73,
  s0_.surveyMailTemplateId AS surveyMailTemplateId_74,
  s0_.surveyBulkMailId AS surveyBulkMailId_75,
  s0_.template AS template_76,
  s0_.pageTemplate AS pageTemplate_77,
  s0_.footerTemplate AS footerTemplate_78,
  s0_.email AS email_79,
  s0_.emailSubject AS emailSubject_80,
  s0_.emailContent AS emailContent_81,
  s0_.landingPageContent AS landingPageContent_82,
  s0_.landingPageDescription AS landingPageDescription_83,
  s0_.landingPageCss AS landingPageCss_84,
  s0_.landingPageJs AS landingPageJs_85,
  s0_.landingPageFooterTemplate AS landingPageFooterTemplate_86,
  s0_.landingPageSocialImage AS landingPageSocialImage_87,
  s0_.hasCustomPage AS hasCustomPage_88,
  s0_.landingPageTitle AS landingPageTitle_89,
  s0_.landingPageTwig AS landingPageTwig_90,
  s0_.goToPage AS goToPage_91,
  s0_.phrasesDe AS phrasesDe_92,
  s0_.phrasesEn AS phrasesEn_93,
  s0_.settings AS settings_94,
  s0_.capacity AS capacity_95,
  s0_.asssesmentDimensions AS asssesmentDimensions_96,
  s0_.start AS start_97,
  s0_.end AS end_98,
  s0_.pitchTopic AS pitchTopic_99,
  s0_.pitchImageLink AS pitchImageLink_100,
  s0_.pitchVideoLink AS pitchVideoLink_101,
  s0_.pitchPartner AS pitchPartner_102,
  s0_.pitchPartnerId AS pitchPartnerId_103,
  s0_.pitchDescription AS pitchDescription_104,
  s0_.followUpPageContent AS followUpPageContent_105,
  s0_.followUpPageDescription AS followUpPageDescription_106,
  s0_.followUpPageCss AS followUpPageCss_107,
  s0_.followUpPageJs AS followUpPageJs_108,
  s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_109,
  s0_.followUpPageTitle AS followUpPageTitle_110,
  s0_.followUpPageSocialImage AS followUpPageSocialImage_111,
  s0_.followUpDescription AS followUpDescription_112,
  s0_.followUpVideoLink AS followUpVideoLink_113,
  s0_.followUpPresentation AS followUpPresentation_114,
  s0_.followUpSkoolUrl AS followUpSkoolUrl_115,
  s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_116,
  s0_.followUpCtaText AS followUpCtaText_117,
  s0_.followUpCtaUrl AS followUpCtaUrl_118,
  s0_.followUpDocuments AS followUpDocuments_119,
  s0_.followUpPhotos AS followUpPhotos_120,
  s0_.followUpExtraLinks AS followUpExtraLinks_121,
  s0_.followUpChecklist AS followUpChecklist_122,
  s0_.pitchDate AS pitchDate_123,
  s0_.pitchTime AS pitchTime_124,
  s0_.prepitchDate AS prepitchDate_125,
  s0_.city AS city_126,
  s0_.applicationsCount AS applicationsCount_127,
  s0_.startedCount AS startedCount_128,
  s0_.appliedCount AS appliedCount_129,
  s0_.approvedCount AS approvedCount_130,
  s0_.rejectedCount AS rejectedCount_131,
  s0_.$skoolWebhook AS skoolWebhook_132,
  s0_.zapierWebhook AS zapierWebhook_133,
  s0_.history AS history_134,
  s0_.createdAt AS createdAt_135,
  s0_.lastModified AS lastModified_136,
  s0_.lastChangeUser AS lastChangeUser_137,
  s0_.program_id AS program_id_138,
  s0_.assessmentTeamId AS assessmentTeamId_139
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_.stripePriceIdLive AS stripePriceIdLive_40, s0_.stripePriceIdTest AS stripePriceIdTest_41, s0_.stripeProductIdLive AS stripeProductIdLive_42, s0_.stripeProductIdTest AS stripeProductIdTest_43, s0_.taxBehavior AS taxBehavior_44, s0_.paymentProvider AS paymentProvider_45, s0_.isFreeForKiCampus AS isFreeForKiCampus_46, s0_.isFreeForCommunity AS isFreeForCommunity_47, s0_.registrationMode AS registrationMode_48, s0_.externalRegistrationUrl AS externalRegistrationUrl_49, s0_.externalPlatform AS externalPlatform_50, s0_.registrationHeadline AS registrationHeadline_51, s0_.registrationSubtitle AS registrationSubtitle_52, s0_.registrationButtonText AS registrationButtonText_53, s0_.registrationRedirectUrl AS registrationRedirectUrl_54, s0_.lumaEventApiId AS lumaEventApiId_55, s0_.meetupEventId AS meetupEventId_56, s0_.meetupEventUrl AS meetupEventUrl_57, s0_.mailDesignTemplate AS mailDesignTemplate_58, s0_.senderMail AS senderMail_59, s0_.fromName AS fromName_60, s0_.recipientMonitoringMail AS recipientMonitoringMail_61, s0_.confirmationMailSubject AS confirmationMailSubject_62, s0_.confirmationMailContent AS confirmationMailContent_63, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_64, s0_.adminNotificationMailContent AS adminNotificationMailContent_65, s0_.reminderMailTemplateId AS reminderMailTemplateId_66, s0_.reminderSenderEmail AS reminderSenderEmail_67, s0_.reminderBulkMailId AS reminderBulkMailId_68, s0_.reminderMailSendDate AS reminderMailSendDate_69, s0_.reminderMailSubject AS reminderMailSubject_70, s0_.reminderMailContent AS reminderMailContent_71, s0_.$reminderMailStatus AS reminderMailStatus_72, s0_.surveyId AS surveyId_73, s0_.surveyMailTemplateId AS surveyMailTemplateId_74, s0_.surveyBulkMailId AS surveyBulkMailId_75, s0_.template AS template_76, s0_.pageTemplate AS pageTemplate_77, s0_.footerTemplate AS footerTemplate_78, s0_.email AS email_79, s0_.emailSubject AS emailSubject_80, s0_.emailContent AS emailContent_81, s0_.landingPageContent AS landingPageContent_82, s0_.landingPageDescription AS landingPageDescription_83, s0_.landingPageCss AS landingPageCss_84, s0_.landingPageJs AS landingPageJs_85, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_86, s0_.landingPageSocialImage AS landingPageSocialImage_87, s0_.hasCustomPage AS hasCustomPage_88, s0_.landingPageTitle AS landingPageTitle_89, s0_.landingPageTwig AS landingPageTwig_90, s0_.goToPage AS goToPage_91, s0_.phrasesDe AS phrasesDe_92, s0_.phrasesEn AS phrasesEn_93, s0_.settings AS settings_94, s0_.capacity AS capacity_95, s0_.asssesmentDimensions AS asssesmentDimensions_96, s0_.start AS start_97, s0_.end AS end_98, s0_.pitchTopic AS pitchTopic_99, s0_.pitchImageLink AS pitchImageLink_100, s0_.pitchVideoLink AS pitchVideoLink_101, s0_.pitchPartner AS pitchPartner_102, s0_.pitchPartnerId AS pitchPartnerId_103, s0_.pitchDescription AS pitchDescription_104, s0_.followUpPageContent AS followUpPageContent_105, s0_.followUpPageDescription AS followUpPageDescription_106, s0_.followUpPageCss AS followUpPageCss_107, s0_.followUpPageJs AS followUpPageJs_108, s0_.followUpPageFooterTemplate AS followUpPageFooterTemplate_109, s0_.followUpPageTitle AS followUpPageTitle_110, s0_.followUpPageSocialImage AS followUpPageSocialImage_111, s0_.followUpDescription AS followUpDescription_112, s0_.followUpVideoLink AS followUpVideoLink_113, s0_.followUpPresentation AS followUpPresentation_114, s0_.followUpSkoolUrl AS followUpSkoolUrl_115, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_116, s0_.followUpCtaText AS followUpCtaText_117, s0_.followUpCtaUrl AS followUpCtaUrl_118, s0_.followUpDocuments AS followUpDocuments_119, s0_.followUpPhotos AS followUpPhotos_120, s0_.followUpExtraLinks AS followUpExtraLinks_121, s0_.followUpChecklist AS followUpChecklist_122, s0_.pitchDate AS pitchDate_123, s0_.pitchTime AS pitchTime_124, s0_.prepitchDate AS prepitchDate_125, s0_.city AS city_126, s0_.applicationsCount AS applicationsCount_127, s0_.startedCount AS startedCount_128, s0_.appliedCount AS appliedCount_129, s0_.approvedCount AS approvedCount_130, s0_.rejectedCount AS rejectedCount_131, s0_.$skoolWebhook AS skoolWebhook_132, s0_.zapierWebhook AS zapierWebhook_133, s0_.history AS history_134, s0_.createdAt AS createdAt_135, s0_.lastModified AS lastModified_136, s0_.lastChangeUser AS lastChangeUser_137, s0_.program_id AS program_id_138, s0_.assessmentTeamId AS assessmentTeamId_139 FROM sp_batches s0_ WHERE s0_.eventId = 6737 AND (((s0_.startDate IS NOT NULL AND s0_.startDate BETWEEN '2026-07-03 00:00:00' AND '2026-07-03 23:59:59') OR (s0_.startDate IS NULL AND s0_.pitchDate BETWEEN '2026-07-03 00:00:00' AND '2026-07-03 23:59:59'))) LIMIT 1;