| 1 |
1.69 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_.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_.status = 'active' AND (s0_.start < ? AND s0_.end > ?) AND s0_.programId IN (?) AND s0_.visibility = ?
Parameters: [
"2026-04-16 23:34:45"
"2026-04-16 23:34:45"
[
"1"
"3"
"8"
]
"public"
]
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_.status = 'active'
AND (
s0_.start < ?
AND s0_.end > ?
)
AND s0_.programId IN (?)
AND s0_.visibility = ?
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_.status = 'active' AND (s0_.start < '2026-04-16 23:34:45' AND s0_.end > '2026-04-16 23:34:45') AND s0_.programId IN ('1', '3', '8') AND s0_.visibility = 'public';
|