1
0.51 ms
SELECT t0 . id AS id_1 , t0 . eventbriteId AS eventbriteId_2 , t0 . wpPostId AS wpPostId_3 , t0 . title AS title_4 , t0 . slug AS slug_5 , t0 . lang AS lang_6 , t0 . imagelink AS imagelink_7 , t0 . videolink AS videolink_8 , t0 . bgImagelink AS bgImagelink_9 , t0 . tagline AS tagline_10 , t0 . headerTextColor AS headerTextColor_11 , t0 . spResponsiblePerson AS spResponsiblePerson_12 , t0 . organization AS organization_13 , t0 . organizerName AS organizerName_14 , t0 . organizerEmail AS organizerEmail_15 , t0 . venueName AS venueName_16 , t0 . venueAddress AS venueAddress_17 , t0 . ticketing AS ticketing_18 , t0 . applicationUrl AS applicationUrl_19 , t0 . alert AS alert_20 , t0 . trainer AS trainer_21 , t0 . speakers AS speakers_22 , t0 . teaser AS teaser_23 , t0 . navbar AS navbar_24 , t0 . stripePriceId AS stripePriceId_25 , t0 . stripeProductId AS stripeProductId_26 , t0 . stripeAccount AS stripeAccount_27 , t0 . priceInEuroCent AS priceInEuroCent_28 , t0 . isTaxIncluded AS isTaxIncluded_29 , t0 . isFreeForKiCampus AS isFreeForKiCampus_30 , t0 . isFreeForCommunity AS isFreeForCommunity_31 , t0 . isSinglePage AS isSinglePage_32 , t0 . isFormalLanguage AS isFormalLanguage_33 , t0 . isMultiBatchEvent AS isMultiBatchEvent_34 , t0 . twigFile AS twigFile_35 , t0 . additionalCss AS additionalCss_36 , t0 . content AS content_37 , t0 . contentTwig AS contentTwig_38 , t0 . ctaContent AS ctaContent_39 , t0 . postCtaContent AS postCtaContent_40 , t0 . tags AS tags_41 , t0 . seriesTag AS seriesTag_42 , t0 . type AS type_43 , t0 . location AS location_44 , t0 . startDate AS startDate_45 , t0 . endDate AS endDate_46 , t0 . duration AS duration_47 , t0 . status AS status_48 , t0 . settings AS settings_49 , t0 . displayStartDate AS displayStartDate_50 , t0 . seoTitle AS seoTitle_51 , t0 . seoKeyword AS seoKeyword_52 , t0 . seoDescription AS seoDescription_53 , t0 . navbar_en AS navbar_en_54 , t0 . teaser_en AS teaser_en_55 , t0 . content_en AS content_en_56 , t0 . content_twig_en AS content_twig_en_57 , t0 . post_cta_content_en AS post_cta_content_en_58 , t0 . seo_title_en AS seo_title_en_59 , t0 . seo_description_en AS seo_description_en_60 , t0 . seo_keyword_en AS seo_keyword_en_61 , t0 . has_english_version AS has_english_version_62 , t0 . additional_js AS additional_js_63 , t0 . metaPixelId AS metaPixelId_64 , t0 . createDate AS createDate_65 , t0 . lastChangeDate AS lastChangeDate_66 , t0 . lastChangeUser AS lastChangeUser_67 , t0 . publicId AS publicId_68 , t0 . isExternalSubmission AS isExternalSubmission_69 , t0 . createdBy AS createdBy_70 , t0 . lastModified AS lastModified_71 , t0 . createdAt AS createdAt_72 , t0 . orgaNote AS orgaNote_73 , t0 . history AS history_74 , t0 . todoHistory AS todoHistory_75 FROM sp_event_events t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"speed-networking "
]
SELECT
t0 . id AS id_1 ,
t0 . eventbriteId AS eventbriteId_2 ,
t0 . wpPostId AS wpPostId_3 ,
t0 . title AS title_4 ,
t0 . slug AS slug_5 ,
t0 . lang AS lang_6 ,
t0 . imagelink AS imagelink_7 ,
t0 . videolink AS videolink_8 ,
t0 . bgImagelink AS bgImagelink_9 ,
t0 . tagline AS tagline_10 ,
t0 . headerTextColor AS headerTextColor_11 ,
t0 . spResponsiblePerson AS spResponsiblePerson_12 ,
t0 . organization AS organization_13 ,
t0 . organizerName AS organizerName_14 ,
t0 . organizerEmail AS organizerEmail_15 ,
t0 . venueName AS venueName_16 ,
t0 . venueAddress AS venueAddress_17 ,
t0 . ticketing AS ticketing_18 ,
t0 . applicationUrl AS applicationUrl_19 ,
t0 . alert AS alert_20 ,
t0 . trainer AS trainer_21 ,
t0 . speakers AS speakers_22 ,
t0 . teaser AS teaser_23 ,
t0 . navbar AS navbar_24 ,
t0 . stripePriceId AS stripePriceId_25 ,
t0 . stripeProductId AS stripeProductId_26 ,
t0 . stripeAccount AS stripeAccount_27 ,
t0 . priceInEuroCent AS priceInEuroCent_28 ,
t0 . isTaxIncluded AS isTaxIncluded_29 ,
t0 . isFreeForKiCampus AS isFreeForKiCampus_30 ,
t0 . isFreeForCommunity AS isFreeForCommunity_31 ,
t0 . isSinglePage AS isSinglePage_32 ,
t0 . isFormalLanguage AS isFormalLanguage_33 ,
t0 . isMultiBatchEvent AS isMultiBatchEvent_34 ,
t0 . twigFile AS twigFile_35 ,
t0 . additionalCss AS additionalCss_36 ,
t0 . content AS content_37 ,
t0 . contentTwig AS contentTwig_38 ,
t0 . ctaContent AS ctaContent_39 ,
t0 . postCtaContent AS postCtaContent_40 ,
t0 . tags AS tags_41 ,
t0 . seriesTag AS seriesTag_42 ,
t0 . type AS type_43 ,
t0 . location AS location_44 ,
t0 . startDate AS startDate_45 ,
t0 . endDate AS endDate_46 ,
t0 . duration AS duration_47 ,
t0 . status AS status_48 ,
t0 . settings AS settings_49 ,
t0 . displayStartDate AS displayStartDate_50 ,
t0 . seoTitle AS seoTitle_51 ,
t0 . seoKeyword AS seoKeyword_52 ,
t0 . seoDescription AS seoDescription_53 ,
t0 . navbar_en AS navbar_en_54 ,
t0 . teaser_en AS teaser_en_55 ,
t0 . content_en AS content_en_56 ,
t0 . content_twig_en AS content_twig_en_57 ,
t0 . post_cta_content_en AS post_cta_content_en_58 ,
t0 . seo_title_en AS seo_title_en_59 ,
t0 . seo_description_en AS seo_description_en_60 ,
t0 . seo_keyword_en AS seo_keyword_en_61 ,
t0 . has_english_version AS has_english_version_62 ,
t0 . additional_js AS additional_js_63 ,
t0 . metaPixelId AS metaPixelId_64 ,
t0 . createDate AS createDate_65 ,
t0 . lastChangeDate AS lastChangeDate_66 ,
t0 . lastChangeUser AS lastChangeUser_67 ,
t0 . publicId AS publicId_68 ,
t0 . isExternalSubmission AS isExternalSubmission_69 ,
t0 . createdBy AS createdBy_70 ,
t0 . lastModified AS lastModified_71 ,
t0 . createdAt AS createdAt_72 ,
t0 . orgaNote AS orgaNote_73 ,
t0 . history AS history_74 ,
t0 . todoHistory AS todoHistory_75
FROM
sp_event_events t0
WHERE
t0 . slug = ?
LIMIT
1 Copy
SELECT t0 . id AS id_1 , t0 . eventbriteId AS eventbriteId_2 , t0 . wpPostId AS wpPostId_3 , t0 . title AS title_4 , t0 . slug AS slug_5 , t0 . lang AS lang_6 , t0 . imagelink AS imagelink_7 , t0 . videolink AS videolink_8 , t0 . bgImagelink AS bgImagelink_9 , t0 . tagline AS tagline_10 , t0 . headerTextColor AS headerTextColor_11 , t0 . spResponsiblePerson AS spResponsiblePerson_12 , t0 . organization AS organization_13 , t0 . organizerName AS organizerName_14 , t0 . organizerEmail AS organizerEmail_15 , t0 . venueName AS venueName_16 , t0 . venueAddress AS venueAddress_17 , t0 . ticketing AS ticketing_18 , t0 . applicationUrl AS applicationUrl_19 , t0 . alert AS alert_20 , t0 . trainer AS trainer_21 , t0 . speakers AS speakers_22 , t0 . teaser AS teaser_23 , t0 . navbar AS navbar_24 , t0 . stripePriceId AS stripePriceId_25 , t0 . stripeProductId AS stripeProductId_26 , t0 . stripeAccount AS stripeAccount_27 , t0 . priceInEuroCent AS priceInEuroCent_28 , t0 . isTaxIncluded AS isTaxIncluded_29 , t0 . isFreeForKiCampus AS isFreeForKiCampus_30 , t0 . isFreeForCommunity AS isFreeForCommunity_31 , t0 . isSinglePage AS isSinglePage_32 , t0 . isFormalLanguage AS isFormalLanguage_33 , t0 . isMultiBatchEvent AS isMultiBatchEvent_34 , t0 . twigFile AS twigFile_35 , t0 . additionalCss AS additionalCss_36 , t0 . content AS content_37 , t0 . contentTwig AS contentTwig_38 , t0 . ctaContent AS ctaContent_39 , t0 . postCtaContent AS postCtaContent_40 , t0 . tags AS tags_41 , t0 . seriesTag AS seriesTag_42 , t0 . type AS type_43 , t0 . location AS location_44 , t0 . startDate AS startDate_45 , t0 . endDate AS endDate_46 , t0 . duration AS duration_47 , t0 . status AS status_48 , t0 . settings AS settings_49 , t0 . displayStartDate AS displayStartDate_50 , t0 . seoTitle AS seoTitle_51 , t0 . seoKeyword AS seoKeyword_52 , t0 . seoDescription AS seoDescription_53 , t0 . navbar_en AS navbar_en_54 , t0 . teaser_en AS teaser_en_55 , t0 . content_en AS content_en_56 , t0 . content_twig_en AS content_twig_en_57 , t0 . post_cta_content_en AS post_cta_content_en_58 , t0 . seo_title_en AS seo_title_en_59 , t0 . seo_description_en AS seo_description_en_60 , t0 . seo_keyword_en AS seo_keyword_en_61 , t0 . has_english_version AS has_english_version_62 , t0 . additional_js AS additional_js_63 , t0 . metaPixelId AS metaPixelId_64 , t0 . createDate AS createDate_65 , t0 . lastChangeDate AS lastChangeDate_66 , t0 . lastChangeUser AS lastChangeUser_67 , t0 . publicId AS publicId_68 , t0 . isExternalSubmission AS isExternalSubmission_69 , t0 . createdBy AS createdBy_70 , t0 . lastModified AS lastModified_71 , t0 . createdAt AS createdAt_72 , t0 . orgaNote AS orgaNote_73 , t0 . history AS history_74 , t0 . todoHistory AS todoHistory_75 FROM sp_event_events t0 WHERE t0 . slug = 'speed-networking' LIMIT 1 ; Copy
2
2.78 ms
SELECT s0_ . id AS id_0 , s0_ . programId AS programId_1 , s0_ . eventId AS eventId_2 , s0_ . productId AS productId_3 , s0_ . batchNumber AS batchNumber_4 , s0_ . url AS url_5 , s0_ . name AS name_6 , s0_ . slug AS slug_7 , s0_ . alias AS alias_8 , s0_ . status AS status_9 , s0_ . focusStatus AS focusStatus_10 , s0_ . lang AS lang_11 , s0_ . priceInEuroCent AS priceInEuroCent_12 , s0_ . isTaxIncluded AS isTaxIncluded_13 , s0_ . discount100MemberTags AS discount100MemberTags_14 , s0_ . discount50MemberTags AS discount50MemberTags_15 , s0_ . discount20MemberTags AS discount20MemberTags_16 , s0_ . askForTeam AS askForTeam_17 , s0_ . hasEvent AS hasEvent_18 , s0_ . hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19 , s0_ . hasIncludeTermsConsent AS hasIncludeTermsConsent_20 , s0_ . hasIncludeLinkedIn AS hasIncludeLinkedIn_21 , s0_ . hasIncludePhone AS hasIncludePhone_22 , s0_ . hasFollowUp AS hasFollowUp_23 , s0_ . isNetworking AS isNetworking_24 , s0_ . networkingRounds AS networkingRounds_25 , s0_ . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26 , s0_ . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27 , s0_ . isFutureEvent AS isFutureEvent_28 , s0_ . visibility AS visibility_29 , s0_ . access AS access_30 , s0_ . tags AS tags_31 , s0_ . typeformLink AS typeformLink_32 , s0_ . zoomLink AS zoomLink_33 , s0_ . bgImageUrl AS bgImageUrl_34 , s0_ . startDate AS startDate_35 , s0_ . endDate AS endDate_36 , s0_ . stripePriceId AS stripePriceId_37 , s0_ . stripeProductId AS stripeProductId_38 , s0_ . stripeAccount AS stripeAccount_39 , s0_ . isFreeForKiCampus AS isFreeForKiCampus_40 , s0_ . isFreeForCommunity AS isFreeForCommunity_41 , s0_ . mailDesignTemplate AS mailDesignTemplate_42 , s0_ . senderMail AS senderMail_43 , s0_ . fromName AS fromName_44 , s0_ . recipientMonitoringMail AS recipientMonitoringMail_45 , s0_ . confirmationMailSubject AS confirmationMailSubject_46 , s0_ . confirmationMailContent AS confirmationMailContent_47 , s0_ . adminNotificationMailSubject AS adminNotificationMailSubject_48 , s0_ . adminNotificationMailContent AS adminNotificationMailContent_49 , s0_ . reminderMailTemplateId AS reminderMailTemplateId_50 , s0_ . reminderSenderEmail AS reminderSenderEmail_51 , s0_ . reminderBulkMailId AS reminderBulkMailId_52 , s0_ . reminderMailSendDate AS reminderMailSendDate_53 , s0_ . reminderMailSubject AS reminderMailSubject_54 , s0_ . reminderMailContent AS reminderMailContent_55 , s0_ . $reminderMailStatus AS reminderMailStatus_56 , s0_ . surveyId AS surveyId_57 , s0_ . surveyMailTemplateId AS surveyMailTemplateId_58 , s0_ . surveyBulkMailId AS surveyBulkMailId_59 , s0_ . template AS template_60 , s0_ . pageTemplate AS pageTemplate_61 , s0_ . footerTemplate AS footerTemplate_62 , s0_ . email AS email_63 , s0_ . emailSubject AS emailSubject_64 , s0_ . emailContent AS emailContent_65 , s0_ . landingPageContent AS landingPageContent_66 , s0_ . landingPageDescription AS landingPageDescription_67 , s0_ . landingPageCss AS landingPageCss_68 , s0_ . landingPageJs AS landingPageJs_69 , s0_ . landingPageFooterTemplate AS landingPageFooterTemplate_70 , s0_ . landingPageSocialImage AS landingPageSocialImage_71 , s0_ . landingPageTitle AS landingPageTitle_72 , s0_ . landingPageTwig AS landingPageTwig_73 , s0_ . goToPage AS goToPage_74 , s0_ . phrasesDe AS phrasesDe_75 , s0_ . phrasesEn AS phrasesEn_76 , s0_ . settings AS settings_77 , s0_ . asssesmentDimensions AS asssesmentDimensions_78 , s0_ . start AS start_79 , s0_ . end AS end_80 , s0_ . pitchTopic AS pitchTopic_81 , s0_ . pitchImageLink AS pitchImageLink_82 , s0_ . pitchVideoLink AS pitchVideoLink_83 , s0_ . pitchPartner AS pitchPartner_84 , s0_ . pitchPartnerId AS pitchPartnerId_85 , s0_ . pitchDescription AS pitchDescription_86 , s0_ . followUpPageContent AS followUpPageContent_87 , s0_ . followUpPageDescription AS followUpPageDescription_88 , s0_ . followUpPageCss AS followUpPageCss_89 , s0_ . followUpPageJs AS followUpPageJs_90 , s0_ . followUpPageFooterTemplate AS followUpPageFooterTemplate_91 , s0_ . followUpPageTitle AS followUpPageTitle_92 , s0_ . followUpPageSocialImage AS followUpPageSocialImage_93 , s0_ . followUpDescription AS followUpDescription_94 , s0_ . followUpVideoLink AS followUpVideoLink_95 , s0_ . followUpPresentation AS followUpPresentation_96 , s0_ . pitchDate AS pitchDate_97 , s0_ . pitchTime AS pitchTime_98 , s0_ . prepitchDate AS prepitchDate_99 , s0_ . city AS city_100 , s0_ . applicationsCount AS applicationsCount_101 , s0_ . startedCount AS startedCount_102 , s0_ . appliedCount AS appliedCount_103 , s0_ . approvedCount AS approvedCount_104 , s0_ . rejectedCount AS rejectedCount_105 , s0_ . $skoolWebhook AS skoolWebhook_106 , s0_ . zapierWebhook AS zapierWebhook_107 , s0_ . history AS history_108 , s0_ . createdAt AS createdAt_109 , s0_ . lastModified AS lastModified_110 , s0_ . lastChangeUser AS lastChangeUser_111 , s0_ . program_id AS program_id_112 , s0_ . assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_ . eventId = ? 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 = ?
ORDER BY
s0_ . startDate ASC ,
s0_ . pitchDate ASC Copy
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 = 5644 ORDER BY s0_ . startDate ASC , s0_ . pitchDate ASC ; Copy
3
8.09 ms
SELECT s0_ . id AS id_0 , s0_ . programId AS programId_1 , s0_ . eventId AS eventId_2 , s0_ . productId AS productId_3 , s0_ . batchNumber AS batchNumber_4 , s0_ . url AS url_5 , s0_ . name AS name_6 , s0_ . slug AS slug_7 , s0_ . alias AS alias_8 , s0_ . status AS status_9 , s0_ . focusStatus AS focusStatus_10 , s0_ . lang AS lang_11 , s0_ . priceInEuroCent AS priceInEuroCent_12 , s0_ . isTaxIncluded AS isTaxIncluded_13 , s0_ . discount100MemberTags AS discount100MemberTags_14 , s0_ . discount50MemberTags AS discount50MemberTags_15 , s0_ . discount20MemberTags AS discount20MemberTags_16 , s0_ . askForTeam AS askForTeam_17 , s0_ . hasEvent AS hasEvent_18 , s0_ . hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_19 , s0_ . hasIncludeTermsConsent AS hasIncludeTermsConsent_20 , s0_ . hasIncludeLinkedIn AS hasIncludeLinkedIn_21 , s0_ . hasIncludePhone AS hasIncludePhone_22 , s0_ . hasFollowUp AS hasFollowUp_23 , s0_ . isNetworking AS isNetworking_24 , s0_ . networkingRounds AS networkingRounds_25 , s0_ . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26 , s0_ . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27 , s0_ . isFutureEvent AS isFutureEvent_28 , s0_ . visibility AS visibility_29 , s0_ . access AS access_30 , s0_ . tags AS tags_31 , s0_ . typeformLink AS typeformLink_32 , s0_ . zoomLink AS zoomLink_33 , s0_ . bgImageUrl AS bgImageUrl_34 , s0_ . startDate AS startDate_35 , s0_ . endDate AS endDate_36 , s0_ . stripePriceId AS stripePriceId_37 , s0_ . stripeProductId AS stripeProductId_38 , s0_ . stripeAccount AS stripeAccount_39 , s0_ . isFreeForKiCampus AS isFreeForKiCampus_40 , s0_ . isFreeForCommunity AS isFreeForCommunity_41 , s0_ . mailDesignTemplate AS mailDesignTemplate_42 , s0_ . senderMail AS senderMail_43 , s0_ . fromName AS fromName_44 , s0_ . recipientMonitoringMail AS recipientMonitoringMail_45 , s0_ . confirmationMailSubject AS confirmationMailSubject_46 , s0_ . confirmationMailContent AS confirmationMailContent_47 , s0_ . adminNotificationMailSubject AS adminNotificationMailSubject_48 , s0_ . adminNotificationMailContent AS adminNotificationMailContent_49 , s0_ . reminderMailTemplateId AS reminderMailTemplateId_50 , s0_ . reminderSenderEmail AS reminderSenderEmail_51 , s0_ . reminderBulkMailId AS reminderBulkMailId_52 , s0_ . reminderMailSendDate AS reminderMailSendDate_53 , s0_ . reminderMailSubject AS reminderMailSubject_54 , s0_ . reminderMailContent AS reminderMailContent_55 , s0_ . $reminderMailStatus AS reminderMailStatus_56 , s0_ . surveyId AS surveyId_57 , s0_ . surveyMailTemplateId AS surveyMailTemplateId_58 , s0_ . surveyBulkMailId AS surveyBulkMailId_59 , s0_ . template AS template_60 , s0_ . pageTemplate AS pageTemplate_61 , s0_ . footerTemplate AS footerTemplate_62 , s0_ . email AS email_63 , s0_ . emailSubject AS emailSubject_64 , s0_ . emailContent AS emailContent_65 , s0_ . landingPageContent AS landingPageContent_66 , s0_ . landingPageDescription AS landingPageDescription_67 , s0_ . landingPageCss AS landingPageCss_68 , s0_ . landingPageJs AS landingPageJs_69 , s0_ . landingPageFooterTemplate AS landingPageFooterTemplate_70 , s0_ . landingPageSocialImage AS landingPageSocialImage_71 , s0_ . landingPageTitle AS landingPageTitle_72 , s0_ . landingPageTwig AS landingPageTwig_73 , s0_ . goToPage AS goToPage_74 , s0_ . phrasesDe AS phrasesDe_75 , s0_ . phrasesEn AS phrasesEn_76 , s0_ . settings AS settings_77 , s0_ . asssesmentDimensions AS asssesmentDimensions_78 , s0_ . start AS start_79 , s0_ . end AS end_80 , s0_ . pitchTopic AS pitchTopic_81 , s0_ . pitchImageLink AS pitchImageLink_82 , s0_ . pitchVideoLink AS pitchVideoLink_83 , s0_ . pitchPartner AS pitchPartner_84 , s0_ . pitchPartnerId AS pitchPartnerId_85 , s0_ . pitchDescription AS pitchDescription_86 , s0_ . followUpPageContent AS followUpPageContent_87 , s0_ . followUpPageDescription AS followUpPageDescription_88 , s0_ . followUpPageCss AS followUpPageCss_89 , s0_ . followUpPageJs AS followUpPageJs_90 , s0_ . followUpPageFooterTemplate AS followUpPageFooterTemplate_91 , s0_ . followUpPageTitle AS followUpPageTitle_92 , s0_ . followUpPageSocialImage AS followUpPageSocialImage_93 , s0_ . followUpDescription AS followUpDescription_94 , s0_ . followUpVideoLink AS followUpVideoLink_95 , s0_ . followUpPresentation AS followUpPresentation_96 , s0_ . pitchDate AS pitchDate_97 , s0_ . pitchTime AS pitchTime_98 , s0_ . prepitchDate AS prepitchDate_99 , s0_ . city AS city_100 , s0_ . applicationsCount AS applicationsCount_101 , s0_ . startedCount AS startedCount_102 , s0_ . appliedCount AS appliedCount_103 , s0_ . approvedCount AS approvedCount_104 , s0_ . rejectedCount AS rejectedCount_105 , s0_ . $skoolWebhook AS skoolWebhook_106 , s0_ . zapierWebhook AS zapierWebhook_107 , s0_ . history AS history_108 , s0_ . createdAt AS createdAt_109 , s0_ . lastModified AS lastModified_110 , s0_ . lastChangeUser AS lastChangeUser_111 , s0_ . program_id AS program_id_112 , s0_ . assessmentTeamId AS assessmentTeamId_113 FROM sp_batches s0_ WHERE s0_ . eventId = ? AND (((s0_ . startDate IS NOT NULL AND s0_ . startDate BETWEEN ? AND ? ) OR (s0_ . startDate IS NULL AND s0_ . pitchDate BETWEEN ? AND ? ))) LIMIT 1
Parameters :
[
5644
"2026-02-27 00:00:00 "
"2026-02-27 23:59:59 "
"2026-02-27 00:00:00 "
"2026-02-27 23:59:59 "
]
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 Copy
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 = 5644 AND (((s0_ . startDate IS NOT NULL AND s0_ . startDate BETWEEN '2026-02-27 00:00:00' AND '2026-02-27 23:59:59' ) OR (s0_ . startDate IS NULL AND s0_ . pitchDate BETWEEN '2026-02-27 00:00:00' AND '2026-02-27 23:59:59' ))) LIMIT 1 ; Copy