| 1 |
1.04 ms |
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.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"elevatehe-x-startplatz-the-next-move-summer-edition"
]
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.title_en AS title_en_6,
t0.slug AS slug_7,
t0.lang AS lang_8,
t0.imagelink AS imagelink_9,
t0.videolink AS videolink_10,
t0.bgImagelink AS bgImagelink_11,
t0.tagline AS tagline_12,
t0.headerTextColor AS headerTextColor_13,
t0.spResponsiblePerson AS spResponsiblePerson_14,
t0.organization AS organization_15,
t0.organizerName AS organizerName_16,
t0.organizerEmail AS organizerEmail_17,
t0.venueName AS venueName_18,
t0.venueAddress AS venueAddress_19,
t0.showFullVenue AS showFullVenue_20,
t0.ticketing AS ticketing_21,
t0.applicationUrl AS applicationUrl_22,
t0.alert AS alert_23,
t0.trainer AS trainer_24,
t0.speakers AS speakers_25,
t0.teaser AS teaser_26,
t0.navbar AS navbar_27,
t0.stripePriceId AS stripePriceId_28,
t0.stripeProductId AS stripeProductId_29,
t0.stripeAccount AS stripeAccount_30,
t0.priceInEuroCent AS priceInEuroCent_31,
t0.isTaxIncluded AS isTaxIncluded_32,
t0.isFreeForKiCampus AS isFreeForKiCampus_33,
t0.isFreeForCommunity AS isFreeForCommunity_34,
t0.isSinglePage AS isSinglePage_35,
t0.isFormalLanguage AS isFormalLanguage_36,
t0.isMultiBatchEvent AS isMultiBatchEvent_37,
t0.isFeatured AS isFeatured_38,
t0.isFlagship AS isFlagship_39,
t0.capacity AS capacity_40,
t0.targetCapacity AS targetCapacity_41,
t0.twigFile AS twigFile_42,
t0.additionalCss AS additionalCss_43,
t0.content AS content_44,
t0.contentTwig AS contentTwig_45,
t0.content_blocks AS content_blocks_46,
t0.content_blocks_en AS content_blocks_en_47,
t0.ctaContent AS ctaContent_48,
t0.postCtaContent AS postCtaContent_49,
t0.tags AS tags_50,
t0.seriesTag AS seriesTag_51,
t0.feedbackFormId AS feedbackFormId_52,
t0.type AS type_53,
t0.location AS location_54,
t0.startDate AS startDate_55,
t0.endDate AS endDate_56,
t0.duration AS duration_57,
t0.status AS status_58,
t0.publishedAt AS publishedAt_59,
t0.publishedBy AS publishedBy_60,
t0.settings AS settings_61,
t0.displayStartDate AS displayStartDate_62,
t0.seoTitle AS seoTitle_63,
t0.seoKeyword AS seoKeyword_64,
t0.seoDescription AS seoDescription_65,
t0.navbar_en AS navbar_en_66,
t0.teaser_en AS teaser_en_67,
t0.content_en AS content_en_68,
t0.content_twig_en AS content_twig_en_69,
t0.post_cta_content_en AS post_cta_content_en_70,
t0.seo_title_en AS seo_title_en_71,
t0.seo_description_en AS seo_description_en_72,
t0.seo_keyword_en AS seo_keyword_en_73,
t0.has_english_version AS has_english_version_74,
t0.additional_js AS additional_js_75,
t0.metaPixelId AS metaPixelId_76,
t0.createDate AS createDate_77,
t0.lastChangeDate AS lastChangeDate_78,
t0.lastChangeUser AS lastChangeUser_79,
t0.publicId AS publicId_80,
t0.isExternalSubmission AS isExternalSubmission_81,
t0.createdBy AS createdBy_82,
t0.lastModified AS lastModified_83,
t0.createdAt AS createdAt_84,
t0.orgaNote AS orgaNote_85,
t0.calendarSyncedAt AS calendarSyncedAt_86,
t0.logisticsRoom AS logisticsRoom_87,
t0.logisticsCatering AS logisticsCatering_88,
t0.logisticsEquipment AS logisticsEquipment_89,
t0.logisticsHelpers AS logisticsHelpers_90,
t0.history AS history_91,
t0.todoHistory AS todoHistory_92
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.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.slug = 'elevatehe-x-startplatz-the-next-move-summer-edition' LIMIT 1;
|
| 2 |
1.34 ms |
SELECT t0.id AS id_1, t0.eventId AS eventId_2, t0.productId AS productId_3, t0.eventDateNumber AS eventDateNumber_4, t0.name AS name_5, t0.slug AS slug_6, t0.url AS url_7, t0.status AS status_8, t0.visibility AS visibility_9, t0.access AS access_10, t0.tags AS tags_11, t0.lang AS lang_12, t0.template AS template_13, t0.pageTemplate AS pageTemplate_14, t0.priceInEuroCent AS priceInEuroCent_15, t0.start AS start_16, t0.end AS end_17, t0.startDate AS startDate_18, t0.endDate AS endDate_19, t0.createdAt AS createdAt_20, t0.lastModified AS lastModified_21, t0.lastChangeUser AS lastChangeUser_22, t0.askForTeam AS askForTeam_23, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_24, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_25, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_26, t0.hasIncludePhone AS hasIncludePhone_27, t0.hasRequirePhone AS hasRequirePhone_28, t0.hasFollowUp AS hasFollowUp_29, t0.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_30, t0.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_31, t0.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isTaxIncluded AS isTaxIncluded_35, t0.bgImageUrl AS bgImageUrl_36, t0.typeformLink AS typeformLink_37, t0.zoomLink AS zoomLink_38, t0.goToPage AS goToPage_39, t0.city AS city_40, t0.mailDesignTemplate AS mailDesignTemplate_41, t0.senderMail AS senderMail_42, t0.fromName AS fromName_43, t0.recipientMonitoringMail AS recipientMonitoringMail_44, t0.confirmationMailSubject AS confirmationMailSubject_45, t0.confirmationMailContent AS confirmationMailContent_46, t0.adminNotificationMailSubject AS adminNotificationMailSubject_47, t0.adminNotificationMailContent AS adminNotificationMailContent_48, t0.reminderSenderEmail AS reminderSenderEmail_49, t0.reminderMailSendDate AS reminderMailSendDate_50, t0.reminderMailSubject AS reminderMailSubject_51, t0.reminderMailContent AS reminderMailContent_52, t0.reminderMailStatus AS reminderMailStatus_53, t0.approvalReceivedMailSubject AS approvalReceivedMailSubject_54, t0.approvalReceivedMailContent AS approvalReceivedMailContent_55, t0.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_56, t0.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_57, t0.approvalApprovedMailSubject AS approvalApprovedMailSubject_58, t0.approvalApprovedMailContent AS approvalApprovedMailContent_59, t0.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_60, t0.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_61, t0.approvalRejectedMailSubject AS approvalRejectedMailSubject_62, t0.approvalRejectedMailContent AS approvalRejectedMailContent_63, t0.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_64, t0.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.applicationsCount AS applicationsCount_69, t0.startedCount AS startedCount_70, t0.appliedCount AS appliedCount_71, t0.approvedCount AS approvedCount_72, t0.rejectedCount AS rejectedCount_73, t0.stripeAccount AS stripeAccount_74, t0.stripePriceId AS stripePriceId_75, t0.stripeProductId AS stripeProductId_76, t0.stripePriceIdLive AS stripePriceIdLive_77, t0.stripePriceIdTest AS stripePriceIdTest_78, t0.stripeProductIdLive AS stripeProductIdLive_79, t0.stripeProductIdTest AS stripeProductIdTest_80, t0.taxBehavior AS taxBehavior_81, t0.paymentProvider AS paymentProvider_82, t0.registrationMode AS registrationMode_83, t0.externalRegistrationUrl AS externalRegistrationUrl_84, t0.externalPlatform AS externalPlatform_85, t0.lumaEventApiId AS lumaEventApiId_86, t0.meetupEventId AS meetupEventId_87, t0.meetupEventUrl AS meetupEventUrl_88, t0.registrationHeadline AS registrationHeadline_89, t0.registrationSubtitle AS registrationSubtitle_90, t0.registrationButtonText AS registrationButtonText_91, t0.registrationPriceHtml AS registrationPriceHtml_92, t0.registrationRedirectUrl AS registrationRedirectUrl_93, t0.registrationTone AS registrationTone_94, t0.remoteSessionText AS remoteSessionText_95, t0.autoApprovalTag AS autoApprovalTag_96, t0.programBudgetMinutes AS programBudgetMinutes_97, t0.callForTalksEnabled AS callForTalksEnabled_98, t0.googleCalendarEventId AS googleCalendarEventId_99, t0.capacity AS capacity_100, t0.targetCapacity AS targetCapacity_101, t0.title AS title_102, t0.teaser AS teaser_103, t0.navbar AS navbar_104, t0.content AS content_105, t0.contentTwig AS contentTwig_106, t0.content_blocks AS content_blocks_107, t0.content_blocks_en AS content_blocks_en_108, t0.ctaContent AS ctaContent_109, t0.postCtaContent AS postCtaContent_110, t0.tagline AS tagline_111, t0.seoTitle AS seoTitle_112, t0.seoDescription AS seoDescription_113, t0.seoKeyword AS seoKeyword_114, t0.imagelink AS imagelink_115, t0.bgImagelink AS bgImagelink_116, t0.videolink AS videolink_117, t0.additionalCss AS additionalCss_118, t0.additionalJs AS additionalJs_119, t0.trainer AS trainer_120, t0.venueName AS venueName_121, t0.venueAddress AS venueAddress_122, t0.whereOverride AS whereOverride_123, t0.showFullVenue AS showFullVenue_124, t0.navbarEn AS navbarEn_125, t0.teaserEn AS teaserEn_126, t0.contentEn AS contentEn_127, t0.contentTwigEn AS contentTwigEn_128, t0.postCtaContentEn AS postCtaContentEn_129, t0.seoTitleEn AS seoTitleEn_130, t0.seoDescriptionEn AS seoDescriptionEn_131, t0.seoKeywordEn AS seoKeywordEn_132, t0.email AS email_133, t0.landingPageContent AS landingPageContent_134, t0.landingPageDescription AS landingPageDescription_135, t0.landingPageCss AS landingPageCss_136, t0.landingPageJs AS landingPageJs_137, t0.landingPageFooterTemplate AS landingPageFooterTemplate_138, t0.landingPageTitle AS landingPageTitle_139, t0.followUpDescription AS followUpDescription_140, t0.followUpVideoLink AS followUpVideoLink_141, t0.followUpPresentation AS followUpPresentation_142, t0.followUpPageContent AS followUpPageContent_143, t0.followUpPageCss AS followUpPageCss_144, t0.followUpPageTitle AS followUpPageTitle_145, t0.followUpSkoolUrl AS followUpSkoolUrl_146, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_147, t0.followUpCtaText AS followUpCtaText_148, t0.followUpCtaUrl AS followUpCtaUrl_149, t0.followUpDocuments AS followUpDocuments_150, t0.followUpPhotos AS followUpPhotos_151, t0.followUpExtraLinks AS followUpExtraLinks_152, t0.history AS history_153, t0.settings AS settings_154, t0.skoolWebhook AS skoolWebhook_155, t0.zapierWebhook AS zapierWebhook_156, t0.metaLeadFormId AS metaLeadFormId_157, t0.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_158, t0.cancellationType AS cancellationType_159, t0.successorEventDateId AS successorEventDateId_160, t0.cancellationMailSentAt AS cancellationMailSentAt_161 FROM sp_event_dates t0 WHERE t0.eventId = ? AND t0.status = ? AND t0.access = ? LIMIT 1
Parameters: [
7095
"active"
"anonymous"
]
SELECT
t0.id AS id_1,
t0.eventId AS eventId_2,
t0.productId AS productId_3,
t0.eventDateNumber AS eventDateNumber_4,
t0.name AS name_5,
t0.slug AS slug_6,
t0.url AS url_7,
t0.status AS status_8,
t0.visibility AS visibility_9,
t0.access AS access_10,
t0.tags AS tags_11,
t0.lang AS lang_12,
t0.template AS template_13,
t0.pageTemplate AS pageTemplate_14,
t0.priceInEuroCent AS priceInEuroCent_15,
t0.start AS start_16,
t0.end AS end_17,
t0.startDate AS startDate_18,
t0.endDate AS endDate_19,
t0.createdAt AS createdAt_20,
t0.lastModified AS lastModified_21,
t0.lastChangeUser AS lastChangeUser_22,
t0.askForTeam AS askForTeam_23,
t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_24,
t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_25,
t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_26,
t0.hasIncludePhone AS hasIncludePhone_27,
t0.hasRequirePhone AS hasRequirePhone_28,
t0.hasFollowUp AS hasFollowUp_29,
t0.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_30,
t0.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_31,
t0.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_32,
t0.isFreeForKiCampus AS isFreeForKiCampus_33,
t0.isFreeForCommunity AS isFreeForCommunity_34,
t0.isTaxIncluded AS isTaxIncluded_35,
t0.bgImageUrl AS bgImageUrl_36,
t0.typeformLink AS typeformLink_37,
t0.zoomLink AS zoomLink_38,
t0.goToPage AS goToPage_39,
t0.city AS city_40,
t0.mailDesignTemplate AS mailDesignTemplate_41,
t0.senderMail AS senderMail_42,
t0.fromName AS fromName_43,
t0.recipientMonitoringMail AS recipientMonitoringMail_44,
t0.confirmationMailSubject AS confirmationMailSubject_45,
t0.confirmationMailContent AS confirmationMailContent_46,
t0.adminNotificationMailSubject AS adminNotificationMailSubject_47,
t0.adminNotificationMailContent AS adminNotificationMailContent_48,
t0.reminderSenderEmail AS reminderSenderEmail_49,
t0.reminderMailSendDate AS reminderMailSendDate_50,
t0.reminderMailSubject AS reminderMailSubject_51,
t0.reminderMailContent AS reminderMailContent_52,
t0.reminderMailStatus AS reminderMailStatus_53,
t0.approvalReceivedMailSubject AS approvalReceivedMailSubject_54,
t0.approvalReceivedMailContent AS approvalReceivedMailContent_55,
t0.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_56,
t0.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_57,
t0.approvalApprovedMailSubject AS approvalApprovedMailSubject_58,
t0.approvalApprovedMailContent AS approvalApprovedMailContent_59,
t0.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_60,
t0.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_61,
t0.approvalRejectedMailSubject AS approvalRejectedMailSubject_62,
t0.approvalRejectedMailContent AS approvalRejectedMailContent_63,
t0.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_64,
t0.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_65,
t0.surveyId AS surveyId_66,
t0.surveyMailTemplateId AS surveyMailTemplateId_67,
t0.surveyBulkMailId AS surveyBulkMailId_68,
t0.applicationsCount AS applicationsCount_69,
t0.startedCount AS startedCount_70,
t0.appliedCount AS appliedCount_71,
t0.approvedCount AS approvedCount_72,
t0.rejectedCount AS rejectedCount_73,
t0.stripeAccount AS stripeAccount_74,
t0.stripePriceId AS stripePriceId_75,
t0.stripeProductId AS stripeProductId_76,
t0.stripePriceIdLive AS stripePriceIdLive_77,
t0.stripePriceIdTest AS stripePriceIdTest_78,
t0.stripeProductIdLive AS stripeProductIdLive_79,
t0.stripeProductIdTest AS stripeProductIdTest_80,
t0.taxBehavior AS taxBehavior_81,
t0.paymentProvider AS paymentProvider_82,
t0.registrationMode AS registrationMode_83,
t0.externalRegistrationUrl AS externalRegistrationUrl_84,
t0.externalPlatform AS externalPlatform_85,
t0.lumaEventApiId AS lumaEventApiId_86,
t0.meetupEventId AS meetupEventId_87,
t0.meetupEventUrl AS meetupEventUrl_88,
t0.registrationHeadline AS registrationHeadline_89,
t0.registrationSubtitle AS registrationSubtitle_90,
t0.registrationButtonText AS registrationButtonText_91,
t0.registrationPriceHtml AS registrationPriceHtml_92,
t0.registrationRedirectUrl AS registrationRedirectUrl_93,
t0.registrationTone AS registrationTone_94,
t0.remoteSessionText AS remoteSessionText_95,
t0.autoApprovalTag AS autoApprovalTag_96,
t0.programBudgetMinutes AS programBudgetMinutes_97,
t0.callForTalksEnabled AS callForTalksEnabled_98,
t0.googleCalendarEventId AS googleCalendarEventId_99,
t0.capacity AS capacity_100,
t0.targetCapacity AS targetCapacity_101,
t0.title AS title_102,
t0.teaser AS teaser_103,
t0.navbar AS navbar_104,
t0.content AS content_105,
t0.contentTwig AS contentTwig_106,
t0.content_blocks AS content_blocks_107,
t0.content_blocks_en AS content_blocks_en_108,
t0.ctaContent AS ctaContent_109,
t0.postCtaContent AS postCtaContent_110,
t0.tagline AS tagline_111,
t0.seoTitle AS seoTitle_112,
t0.seoDescription AS seoDescription_113,
t0.seoKeyword AS seoKeyword_114,
t0.imagelink AS imagelink_115,
t0.bgImagelink AS bgImagelink_116,
t0.videolink AS videolink_117,
t0.additionalCss AS additionalCss_118,
t0.additionalJs AS additionalJs_119,
t0.trainer AS trainer_120,
t0.venueName AS venueName_121,
t0.venueAddress AS venueAddress_122,
t0.whereOverride AS whereOverride_123,
t0.showFullVenue AS showFullVenue_124,
t0.navbarEn AS navbarEn_125,
t0.teaserEn AS teaserEn_126,
t0.contentEn AS contentEn_127,
t0.contentTwigEn AS contentTwigEn_128,
t0.postCtaContentEn AS postCtaContentEn_129,
t0.seoTitleEn AS seoTitleEn_130,
t0.seoDescriptionEn AS seoDescriptionEn_131,
t0.seoKeywordEn AS seoKeywordEn_132,
t0.email AS email_133,
t0.landingPageContent AS landingPageContent_134,
t0.landingPageDescription AS landingPageDescription_135,
t0.landingPageCss AS landingPageCss_136,
t0.landingPageJs AS landingPageJs_137,
t0.landingPageFooterTemplate AS landingPageFooterTemplate_138,
t0.landingPageTitle AS landingPageTitle_139,
t0.followUpDescription AS followUpDescription_140,
t0.followUpVideoLink AS followUpVideoLink_141,
t0.followUpPresentation AS followUpPresentation_142,
t0.followUpPageContent AS followUpPageContent_143,
t0.followUpPageCss AS followUpPageCss_144,
t0.followUpPageTitle AS followUpPageTitle_145,
t0.followUpSkoolUrl AS followUpSkoolUrl_146,
t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_147,
t0.followUpCtaText AS followUpCtaText_148,
t0.followUpCtaUrl AS followUpCtaUrl_149,
t0.followUpDocuments AS followUpDocuments_150,
t0.followUpPhotos AS followUpPhotos_151,
t0.followUpExtraLinks AS followUpExtraLinks_152,
t0.history AS history_153,
t0.settings AS settings_154,
t0.skoolWebhook AS skoolWebhook_155,
t0.zapierWebhook AS zapierWebhook_156,
t0.metaLeadFormId AS metaLeadFormId_157,
t0.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_158,
t0.cancellationType AS cancellationType_159,
t0.successorEventDateId AS successorEventDateId_160,
t0.cancellationMailSentAt AS cancellationMailSentAt_161
FROM
sp_event_dates t0
WHERE
t0.eventId = ?
AND t0.status = ?
AND t0.access = ?
LIMIT
1
SELECT t0.id AS id_1, t0.eventId AS eventId_2, t0.productId AS productId_3, t0.eventDateNumber AS eventDateNumber_4, t0.name AS name_5, t0.slug AS slug_6, t0.url AS url_7, t0.status AS status_8, t0.visibility AS visibility_9, t0.access AS access_10, t0.tags AS tags_11, t0.lang AS lang_12, t0.template AS template_13, t0.pageTemplate AS pageTemplate_14, t0.priceInEuroCent AS priceInEuroCent_15, t0.start AS start_16, t0.end AS end_17, t0.startDate AS startDate_18, t0.endDate AS endDate_19, t0.createdAt AS createdAt_20, t0.lastModified AS lastModified_21, t0.lastChangeUser AS lastChangeUser_22, t0.askForTeam AS askForTeam_23, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_24, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_25, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_26, t0.hasIncludePhone AS hasIncludePhone_27, t0.hasRequirePhone AS hasRequirePhone_28, t0.hasFollowUp AS hasFollowUp_29, t0.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_30, t0.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_31, t0.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isTaxIncluded AS isTaxIncluded_35, t0.bgImageUrl AS bgImageUrl_36, t0.typeformLink AS typeformLink_37, t0.zoomLink AS zoomLink_38, t0.goToPage AS goToPage_39, t0.city AS city_40, t0.mailDesignTemplate AS mailDesignTemplate_41, t0.senderMail AS senderMail_42, t0.fromName AS fromName_43, t0.recipientMonitoringMail AS recipientMonitoringMail_44, t0.confirmationMailSubject AS confirmationMailSubject_45, t0.confirmationMailContent AS confirmationMailContent_46, t0.adminNotificationMailSubject AS adminNotificationMailSubject_47, t0.adminNotificationMailContent AS adminNotificationMailContent_48, t0.reminderSenderEmail AS reminderSenderEmail_49, t0.reminderMailSendDate AS reminderMailSendDate_50, t0.reminderMailSubject AS reminderMailSubject_51, t0.reminderMailContent AS reminderMailContent_52, t0.reminderMailStatus AS reminderMailStatus_53, t0.approvalReceivedMailSubject AS approvalReceivedMailSubject_54, t0.approvalReceivedMailContent AS approvalReceivedMailContent_55, t0.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_56, t0.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_57, t0.approvalApprovedMailSubject AS approvalApprovedMailSubject_58, t0.approvalApprovedMailContent AS approvalApprovedMailContent_59, t0.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_60, t0.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_61, t0.approvalRejectedMailSubject AS approvalRejectedMailSubject_62, t0.approvalRejectedMailContent AS approvalRejectedMailContent_63, t0.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_64, t0.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.applicationsCount AS applicationsCount_69, t0.startedCount AS startedCount_70, t0.appliedCount AS appliedCount_71, t0.approvedCount AS approvedCount_72, t0.rejectedCount AS rejectedCount_73, t0.stripeAccount AS stripeAccount_74, t0.stripePriceId AS stripePriceId_75, t0.stripeProductId AS stripeProductId_76, t0.stripePriceIdLive AS stripePriceIdLive_77, t0.stripePriceIdTest AS stripePriceIdTest_78, t0.stripeProductIdLive AS stripeProductIdLive_79, t0.stripeProductIdTest AS stripeProductIdTest_80, t0.taxBehavior AS taxBehavior_81, t0.paymentProvider AS paymentProvider_82, t0.registrationMode AS registrationMode_83, t0.externalRegistrationUrl AS externalRegistrationUrl_84, t0.externalPlatform AS externalPlatform_85, t0.lumaEventApiId AS lumaEventApiId_86, t0.meetupEventId AS meetupEventId_87, t0.meetupEventUrl AS meetupEventUrl_88, t0.registrationHeadline AS registrationHeadline_89, t0.registrationSubtitle AS registrationSubtitle_90, t0.registrationButtonText AS registrationButtonText_91, t0.registrationPriceHtml AS registrationPriceHtml_92, t0.registrationRedirectUrl AS registrationRedirectUrl_93, t0.registrationTone AS registrationTone_94, t0.remoteSessionText AS remoteSessionText_95, t0.autoApprovalTag AS autoApprovalTag_96, t0.programBudgetMinutes AS programBudgetMinutes_97, t0.callForTalksEnabled AS callForTalksEnabled_98, t0.googleCalendarEventId AS googleCalendarEventId_99, t0.capacity AS capacity_100, t0.targetCapacity AS targetCapacity_101, t0.title AS title_102, t0.teaser AS teaser_103, t0.navbar AS navbar_104, t0.content AS content_105, t0.contentTwig AS contentTwig_106, t0.content_blocks AS content_blocks_107, t0.content_blocks_en AS content_blocks_en_108, t0.ctaContent AS ctaContent_109, t0.postCtaContent AS postCtaContent_110, t0.tagline AS tagline_111, t0.seoTitle AS seoTitle_112, t0.seoDescription AS seoDescription_113, t0.seoKeyword AS seoKeyword_114, t0.imagelink AS imagelink_115, t0.bgImagelink AS bgImagelink_116, t0.videolink AS videolink_117, t0.additionalCss AS additionalCss_118, t0.additionalJs AS additionalJs_119, t0.trainer AS trainer_120, t0.venueName AS venueName_121, t0.venueAddress AS venueAddress_122, t0.whereOverride AS whereOverride_123, t0.showFullVenue AS showFullVenue_124, t0.navbarEn AS navbarEn_125, t0.teaserEn AS teaserEn_126, t0.contentEn AS contentEn_127, t0.contentTwigEn AS contentTwigEn_128, t0.postCtaContentEn AS postCtaContentEn_129, t0.seoTitleEn AS seoTitleEn_130, t0.seoDescriptionEn AS seoDescriptionEn_131, t0.seoKeywordEn AS seoKeywordEn_132, t0.email AS email_133, t0.landingPageContent AS landingPageContent_134, t0.landingPageDescription AS landingPageDescription_135, t0.landingPageCss AS landingPageCss_136, t0.landingPageJs AS landingPageJs_137, t0.landingPageFooterTemplate AS landingPageFooterTemplate_138, t0.landingPageTitle AS landingPageTitle_139, t0.followUpDescription AS followUpDescription_140, t0.followUpVideoLink AS followUpVideoLink_141, t0.followUpPresentation AS followUpPresentation_142, t0.followUpPageContent AS followUpPageContent_143, t0.followUpPageCss AS followUpPageCss_144, t0.followUpPageTitle AS followUpPageTitle_145, t0.followUpSkoolUrl AS followUpSkoolUrl_146, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_147, t0.followUpCtaText AS followUpCtaText_148, t0.followUpCtaUrl AS followUpCtaUrl_149, t0.followUpDocuments AS followUpDocuments_150, t0.followUpPhotos AS followUpPhotos_151, t0.followUpExtraLinks AS followUpExtraLinks_152, t0.history AS history_153, t0.settings AS settings_154, t0.skoolWebhook AS skoolWebhook_155, t0.zapierWebhook AS zapierWebhook_156, t0.metaLeadFormId AS metaLeadFormId_157, t0.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_158, t0.cancellationType AS cancellationType_159, t0.successorEventDateId AS successorEventDateId_160, t0.cancellationMailSentAt AS cancellationMailSentAt_161 FROM sp_event_dates t0 WHERE t0.eventId = 7095 AND t0.status = 'active' AND t0.access = 'anonymous' LIMIT 1;
|
| 3 |
1.47 ms |
SELECT t0.id AS id_1, t0.eventId AS eventId_2, t0.productId AS productId_3, t0.eventDateNumber AS eventDateNumber_4, t0.name AS name_5, t0.slug AS slug_6, t0.url AS url_7, t0.status AS status_8, t0.visibility AS visibility_9, t0.access AS access_10, t0.tags AS tags_11, t0.lang AS lang_12, t0.template AS template_13, t0.pageTemplate AS pageTemplate_14, t0.priceInEuroCent AS priceInEuroCent_15, t0.start AS start_16, t0.end AS end_17, t0.startDate AS startDate_18, t0.endDate AS endDate_19, t0.createdAt AS createdAt_20, t0.lastModified AS lastModified_21, t0.lastChangeUser AS lastChangeUser_22, t0.askForTeam AS askForTeam_23, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_24, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_25, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_26, t0.hasIncludePhone AS hasIncludePhone_27, t0.hasRequirePhone AS hasRequirePhone_28, t0.hasFollowUp AS hasFollowUp_29, t0.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_30, t0.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_31, t0.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isTaxIncluded AS isTaxIncluded_35, t0.bgImageUrl AS bgImageUrl_36, t0.typeformLink AS typeformLink_37, t0.zoomLink AS zoomLink_38, t0.goToPage AS goToPage_39, t0.city AS city_40, t0.mailDesignTemplate AS mailDesignTemplate_41, t0.senderMail AS senderMail_42, t0.fromName AS fromName_43, t0.recipientMonitoringMail AS recipientMonitoringMail_44, t0.confirmationMailSubject AS confirmationMailSubject_45, t0.confirmationMailContent AS confirmationMailContent_46, t0.adminNotificationMailSubject AS adminNotificationMailSubject_47, t0.adminNotificationMailContent AS adminNotificationMailContent_48, t0.reminderSenderEmail AS reminderSenderEmail_49, t0.reminderMailSendDate AS reminderMailSendDate_50, t0.reminderMailSubject AS reminderMailSubject_51, t0.reminderMailContent AS reminderMailContent_52, t0.reminderMailStatus AS reminderMailStatus_53, t0.approvalReceivedMailSubject AS approvalReceivedMailSubject_54, t0.approvalReceivedMailContent AS approvalReceivedMailContent_55, t0.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_56, t0.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_57, t0.approvalApprovedMailSubject AS approvalApprovedMailSubject_58, t0.approvalApprovedMailContent AS approvalApprovedMailContent_59, t0.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_60, t0.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_61, t0.approvalRejectedMailSubject AS approvalRejectedMailSubject_62, t0.approvalRejectedMailContent AS approvalRejectedMailContent_63, t0.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_64, t0.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.applicationsCount AS applicationsCount_69, t0.startedCount AS startedCount_70, t0.appliedCount AS appliedCount_71, t0.approvedCount AS approvedCount_72, t0.rejectedCount AS rejectedCount_73, t0.stripeAccount AS stripeAccount_74, t0.stripePriceId AS stripePriceId_75, t0.stripeProductId AS stripeProductId_76, t0.stripePriceIdLive AS stripePriceIdLive_77, t0.stripePriceIdTest AS stripePriceIdTest_78, t0.stripeProductIdLive AS stripeProductIdLive_79, t0.stripeProductIdTest AS stripeProductIdTest_80, t0.taxBehavior AS taxBehavior_81, t0.paymentProvider AS paymentProvider_82, t0.registrationMode AS registrationMode_83, t0.externalRegistrationUrl AS externalRegistrationUrl_84, t0.externalPlatform AS externalPlatform_85, t0.lumaEventApiId AS lumaEventApiId_86, t0.meetupEventId AS meetupEventId_87, t0.meetupEventUrl AS meetupEventUrl_88, t0.registrationHeadline AS registrationHeadline_89, t0.registrationSubtitle AS registrationSubtitle_90, t0.registrationButtonText AS registrationButtonText_91, t0.registrationPriceHtml AS registrationPriceHtml_92, t0.registrationRedirectUrl AS registrationRedirectUrl_93, t0.registrationTone AS registrationTone_94, t0.remoteSessionText AS remoteSessionText_95, t0.autoApprovalTag AS autoApprovalTag_96, t0.programBudgetMinutes AS programBudgetMinutes_97, t0.callForTalksEnabled AS callForTalksEnabled_98, t0.googleCalendarEventId AS googleCalendarEventId_99, t0.capacity AS capacity_100, t0.targetCapacity AS targetCapacity_101, t0.title AS title_102, t0.teaser AS teaser_103, t0.navbar AS navbar_104, t0.content AS content_105, t0.contentTwig AS contentTwig_106, t0.content_blocks AS content_blocks_107, t0.content_blocks_en AS content_blocks_en_108, t0.ctaContent AS ctaContent_109, t0.postCtaContent AS postCtaContent_110, t0.tagline AS tagline_111, t0.seoTitle AS seoTitle_112, t0.seoDescription AS seoDescription_113, t0.seoKeyword AS seoKeyword_114, t0.imagelink AS imagelink_115, t0.bgImagelink AS bgImagelink_116, t0.videolink AS videolink_117, t0.additionalCss AS additionalCss_118, t0.additionalJs AS additionalJs_119, t0.trainer AS trainer_120, t0.venueName AS venueName_121, t0.venueAddress AS venueAddress_122, t0.whereOverride AS whereOverride_123, t0.showFullVenue AS showFullVenue_124, t0.navbarEn AS navbarEn_125, t0.teaserEn AS teaserEn_126, t0.contentEn AS contentEn_127, t0.contentTwigEn AS contentTwigEn_128, t0.postCtaContentEn AS postCtaContentEn_129, t0.seoTitleEn AS seoTitleEn_130, t0.seoDescriptionEn AS seoDescriptionEn_131, t0.seoKeywordEn AS seoKeywordEn_132, t0.email AS email_133, t0.landingPageContent AS landingPageContent_134, t0.landingPageDescription AS landingPageDescription_135, t0.landingPageCss AS landingPageCss_136, t0.landingPageJs AS landingPageJs_137, t0.landingPageFooterTemplate AS landingPageFooterTemplate_138, t0.landingPageTitle AS landingPageTitle_139, t0.followUpDescription AS followUpDescription_140, t0.followUpVideoLink AS followUpVideoLink_141, t0.followUpPresentation AS followUpPresentation_142, t0.followUpPageContent AS followUpPageContent_143, t0.followUpPageCss AS followUpPageCss_144, t0.followUpPageTitle AS followUpPageTitle_145, t0.followUpSkoolUrl AS followUpSkoolUrl_146, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_147, t0.followUpCtaText AS followUpCtaText_148, t0.followUpCtaUrl AS followUpCtaUrl_149, t0.followUpDocuments AS followUpDocuments_150, t0.followUpPhotos AS followUpPhotos_151, t0.followUpExtraLinks AS followUpExtraLinks_152, t0.history AS history_153, t0.settings AS settings_154, t0.skoolWebhook AS skoolWebhook_155, t0.zapierWebhook AS zapierWebhook_156, t0.metaLeadFormId AS metaLeadFormId_157, t0.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_158, t0.cancellationType AS cancellationType_159, t0.successorEventDateId AS successorEventDateId_160, t0.cancellationMailSentAt AS cancellationMailSentAt_161 FROM sp_event_dates t0 WHERE t0.eventId = ? AND t0.status = ? AND t0.access = ? LIMIT 1
Parameters: [
7095
"completed"
"anonymous"
]
SELECT
t0.id AS id_1,
t0.eventId AS eventId_2,
t0.productId AS productId_3,
t0.eventDateNumber AS eventDateNumber_4,
t0.name AS name_5,
t0.slug AS slug_6,
t0.url AS url_7,
t0.status AS status_8,
t0.visibility AS visibility_9,
t0.access AS access_10,
t0.tags AS tags_11,
t0.lang AS lang_12,
t0.template AS template_13,
t0.pageTemplate AS pageTemplate_14,
t0.priceInEuroCent AS priceInEuroCent_15,
t0.start AS start_16,
t0.end AS end_17,
t0.startDate AS startDate_18,
t0.endDate AS endDate_19,
t0.createdAt AS createdAt_20,
t0.lastModified AS lastModified_21,
t0.lastChangeUser AS lastChangeUser_22,
t0.askForTeam AS askForTeam_23,
t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_24,
t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_25,
t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_26,
t0.hasIncludePhone AS hasIncludePhone_27,
t0.hasRequirePhone AS hasRequirePhone_28,
t0.hasFollowUp AS hasFollowUp_29,
t0.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_30,
t0.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_31,
t0.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_32,
t0.isFreeForKiCampus AS isFreeForKiCampus_33,
t0.isFreeForCommunity AS isFreeForCommunity_34,
t0.isTaxIncluded AS isTaxIncluded_35,
t0.bgImageUrl AS bgImageUrl_36,
t0.typeformLink AS typeformLink_37,
t0.zoomLink AS zoomLink_38,
t0.goToPage AS goToPage_39,
t0.city AS city_40,
t0.mailDesignTemplate AS mailDesignTemplate_41,
t0.senderMail AS senderMail_42,
t0.fromName AS fromName_43,
t0.recipientMonitoringMail AS recipientMonitoringMail_44,
t0.confirmationMailSubject AS confirmationMailSubject_45,
t0.confirmationMailContent AS confirmationMailContent_46,
t0.adminNotificationMailSubject AS adminNotificationMailSubject_47,
t0.adminNotificationMailContent AS adminNotificationMailContent_48,
t0.reminderSenderEmail AS reminderSenderEmail_49,
t0.reminderMailSendDate AS reminderMailSendDate_50,
t0.reminderMailSubject AS reminderMailSubject_51,
t0.reminderMailContent AS reminderMailContent_52,
t0.reminderMailStatus AS reminderMailStatus_53,
t0.approvalReceivedMailSubject AS approvalReceivedMailSubject_54,
t0.approvalReceivedMailContent AS approvalReceivedMailContent_55,
t0.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_56,
t0.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_57,
t0.approvalApprovedMailSubject AS approvalApprovedMailSubject_58,
t0.approvalApprovedMailContent AS approvalApprovedMailContent_59,
t0.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_60,
t0.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_61,
t0.approvalRejectedMailSubject AS approvalRejectedMailSubject_62,
t0.approvalRejectedMailContent AS approvalRejectedMailContent_63,
t0.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_64,
t0.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_65,
t0.surveyId AS surveyId_66,
t0.surveyMailTemplateId AS surveyMailTemplateId_67,
t0.surveyBulkMailId AS surveyBulkMailId_68,
t0.applicationsCount AS applicationsCount_69,
t0.startedCount AS startedCount_70,
t0.appliedCount AS appliedCount_71,
t0.approvedCount AS approvedCount_72,
t0.rejectedCount AS rejectedCount_73,
t0.stripeAccount AS stripeAccount_74,
t0.stripePriceId AS stripePriceId_75,
t0.stripeProductId AS stripeProductId_76,
t0.stripePriceIdLive AS stripePriceIdLive_77,
t0.stripePriceIdTest AS stripePriceIdTest_78,
t0.stripeProductIdLive AS stripeProductIdLive_79,
t0.stripeProductIdTest AS stripeProductIdTest_80,
t0.taxBehavior AS taxBehavior_81,
t0.paymentProvider AS paymentProvider_82,
t0.registrationMode AS registrationMode_83,
t0.externalRegistrationUrl AS externalRegistrationUrl_84,
t0.externalPlatform AS externalPlatform_85,
t0.lumaEventApiId AS lumaEventApiId_86,
t0.meetupEventId AS meetupEventId_87,
t0.meetupEventUrl AS meetupEventUrl_88,
t0.registrationHeadline AS registrationHeadline_89,
t0.registrationSubtitle AS registrationSubtitle_90,
t0.registrationButtonText AS registrationButtonText_91,
t0.registrationPriceHtml AS registrationPriceHtml_92,
t0.registrationRedirectUrl AS registrationRedirectUrl_93,
t0.registrationTone AS registrationTone_94,
t0.remoteSessionText AS remoteSessionText_95,
t0.autoApprovalTag AS autoApprovalTag_96,
t0.programBudgetMinutes AS programBudgetMinutes_97,
t0.callForTalksEnabled AS callForTalksEnabled_98,
t0.googleCalendarEventId AS googleCalendarEventId_99,
t0.capacity AS capacity_100,
t0.targetCapacity AS targetCapacity_101,
t0.title AS title_102,
t0.teaser AS teaser_103,
t0.navbar AS navbar_104,
t0.content AS content_105,
t0.contentTwig AS contentTwig_106,
t0.content_blocks AS content_blocks_107,
t0.content_blocks_en AS content_blocks_en_108,
t0.ctaContent AS ctaContent_109,
t0.postCtaContent AS postCtaContent_110,
t0.tagline AS tagline_111,
t0.seoTitle AS seoTitle_112,
t0.seoDescription AS seoDescription_113,
t0.seoKeyword AS seoKeyword_114,
t0.imagelink AS imagelink_115,
t0.bgImagelink AS bgImagelink_116,
t0.videolink AS videolink_117,
t0.additionalCss AS additionalCss_118,
t0.additionalJs AS additionalJs_119,
t0.trainer AS trainer_120,
t0.venueName AS venueName_121,
t0.venueAddress AS venueAddress_122,
t0.whereOverride AS whereOverride_123,
t0.showFullVenue AS showFullVenue_124,
t0.navbarEn AS navbarEn_125,
t0.teaserEn AS teaserEn_126,
t0.contentEn AS contentEn_127,
t0.contentTwigEn AS contentTwigEn_128,
t0.postCtaContentEn AS postCtaContentEn_129,
t0.seoTitleEn AS seoTitleEn_130,
t0.seoDescriptionEn AS seoDescriptionEn_131,
t0.seoKeywordEn AS seoKeywordEn_132,
t0.email AS email_133,
t0.landingPageContent AS landingPageContent_134,
t0.landingPageDescription AS landingPageDescription_135,
t0.landingPageCss AS landingPageCss_136,
t0.landingPageJs AS landingPageJs_137,
t0.landingPageFooterTemplate AS landingPageFooterTemplate_138,
t0.landingPageTitle AS landingPageTitle_139,
t0.followUpDescription AS followUpDescription_140,
t0.followUpVideoLink AS followUpVideoLink_141,
t0.followUpPresentation AS followUpPresentation_142,
t0.followUpPageContent AS followUpPageContent_143,
t0.followUpPageCss AS followUpPageCss_144,
t0.followUpPageTitle AS followUpPageTitle_145,
t0.followUpSkoolUrl AS followUpSkoolUrl_146,
t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_147,
t0.followUpCtaText AS followUpCtaText_148,
t0.followUpCtaUrl AS followUpCtaUrl_149,
t0.followUpDocuments AS followUpDocuments_150,
t0.followUpPhotos AS followUpPhotos_151,
t0.followUpExtraLinks AS followUpExtraLinks_152,
t0.history AS history_153,
t0.settings AS settings_154,
t0.skoolWebhook AS skoolWebhook_155,
t0.zapierWebhook AS zapierWebhook_156,
t0.metaLeadFormId AS metaLeadFormId_157,
t0.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_158,
t0.cancellationType AS cancellationType_159,
t0.successorEventDateId AS successorEventDateId_160,
t0.cancellationMailSentAt AS cancellationMailSentAt_161
FROM
sp_event_dates t0
WHERE
t0.eventId = ?
AND t0.status = ?
AND t0.access = ?
LIMIT
1
SELECT t0.id AS id_1, t0.eventId AS eventId_2, t0.productId AS productId_3, t0.eventDateNumber AS eventDateNumber_4, t0.name AS name_5, t0.slug AS slug_6, t0.url AS url_7, t0.status AS status_8, t0.visibility AS visibility_9, t0.access AS access_10, t0.tags AS tags_11, t0.lang AS lang_12, t0.template AS template_13, t0.pageTemplate AS pageTemplate_14, t0.priceInEuroCent AS priceInEuroCent_15, t0.start AS start_16, t0.end AS end_17, t0.startDate AS startDate_18, t0.endDate AS endDate_19, t0.createdAt AS createdAt_20, t0.lastModified AS lastModified_21, t0.lastChangeUser AS lastChangeUser_22, t0.askForTeam AS askForTeam_23, t0.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_24, t0.hasIncludeTermsConsent AS hasIncludeTermsConsent_25, t0.hasIncludeLinkedIn AS hasIncludeLinkedIn_26, t0.hasIncludePhone AS hasIncludePhone_27, t0.hasRequirePhone AS hasRequirePhone_28, t0.hasFollowUp AS hasFollowUp_29, t0.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_30, t0.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_31, t0.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isTaxIncluded AS isTaxIncluded_35, t0.bgImageUrl AS bgImageUrl_36, t0.typeformLink AS typeformLink_37, t0.zoomLink AS zoomLink_38, t0.goToPage AS goToPage_39, t0.city AS city_40, t0.mailDesignTemplate AS mailDesignTemplate_41, t0.senderMail AS senderMail_42, t0.fromName AS fromName_43, t0.recipientMonitoringMail AS recipientMonitoringMail_44, t0.confirmationMailSubject AS confirmationMailSubject_45, t0.confirmationMailContent AS confirmationMailContent_46, t0.adminNotificationMailSubject AS adminNotificationMailSubject_47, t0.adminNotificationMailContent AS adminNotificationMailContent_48, t0.reminderSenderEmail AS reminderSenderEmail_49, t0.reminderMailSendDate AS reminderMailSendDate_50, t0.reminderMailSubject AS reminderMailSubject_51, t0.reminderMailContent AS reminderMailContent_52, t0.reminderMailStatus AS reminderMailStatus_53, t0.approvalReceivedMailSubject AS approvalReceivedMailSubject_54, t0.approvalReceivedMailContent AS approvalReceivedMailContent_55, t0.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_56, t0.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_57, t0.approvalApprovedMailSubject AS approvalApprovedMailSubject_58, t0.approvalApprovedMailContent AS approvalApprovedMailContent_59, t0.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_60, t0.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_61, t0.approvalRejectedMailSubject AS approvalRejectedMailSubject_62, t0.approvalRejectedMailContent AS approvalRejectedMailContent_63, t0.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_64, t0.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.applicationsCount AS applicationsCount_69, t0.startedCount AS startedCount_70, t0.appliedCount AS appliedCount_71, t0.approvedCount AS approvedCount_72, t0.rejectedCount AS rejectedCount_73, t0.stripeAccount AS stripeAccount_74, t0.stripePriceId AS stripePriceId_75, t0.stripeProductId AS stripeProductId_76, t0.stripePriceIdLive AS stripePriceIdLive_77, t0.stripePriceIdTest AS stripePriceIdTest_78, t0.stripeProductIdLive AS stripeProductIdLive_79, t0.stripeProductIdTest AS stripeProductIdTest_80, t0.taxBehavior AS taxBehavior_81, t0.paymentProvider AS paymentProvider_82, t0.registrationMode AS registrationMode_83, t0.externalRegistrationUrl AS externalRegistrationUrl_84, t0.externalPlatform AS externalPlatform_85, t0.lumaEventApiId AS lumaEventApiId_86, t0.meetupEventId AS meetupEventId_87, t0.meetupEventUrl AS meetupEventUrl_88, t0.registrationHeadline AS registrationHeadline_89, t0.registrationSubtitle AS registrationSubtitle_90, t0.registrationButtonText AS registrationButtonText_91, t0.registrationPriceHtml AS registrationPriceHtml_92, t0.registrationRedirectUrl AS registrationRedirectUrl_93, t0.registrationTone AS registrationTone_94, t0.remoteSessionText AS remoteSessionText_95, t0.autoApprovalTag AS autoApprovalTag_96, t0.programBudgetMinutes AS programBudgetMinutes_97, t0.callForTalksEnabled AS callForTalksEnabled_98, t0.googleCalendarEventId AS googleCalendarEventId_99, t0.capacity AS capacity_100, t0.targetCapacity AS targetCapacity_101, t0.title AS title_102, t0.teaser AS teaser_103, t0.navbar AS navbar_104, t0.content AS content_105, t0.contentTwig AS contentTwig_106, t0.content_blocks AS content_blocks_107, t0.content_blocks_en AS content_blocks_en_108, t0.ctaContent AS ctaContent_109, t0.postCtaContent AS postCtaContent_110, t0.tagline AS tagline_111, t0.seoTitle AS seoTitle_112, t0.seoDescription AS seoDescription_113, t0.seoKeyword AS seoKeyword_114, t0.imagelink AS imagelink_115, t0.bgImagelink AS bgImagelink_116, t0.videolink AS videolink_117, t0.additionalCss AS additionalCss_118, t0.additionalJs AS additionalJs_119, t0.trainer AS trainer_120, t0.venueName AS venueName_121, t0.venueAddress AS venueAddress_122, t0.whereOverride AS whereOverride_123, t0.showFullVenue AS showFullVenue_124, t0.navbarEn AS navbarEn_125, t0.teaserEn AS teaserEn_126, t0.contentEn AS contentEn_127, t0.contentTwigEn AS contentTwigEn_128, t0.postCtaContentEn AS postCtaContentEn_129, t0.seoTitleEn AS seoTitleEn_130, t0.seoDescriptionEn AS seoDescriptionEn_131, t0.seoKeywordEn AS seoKeywordEn_132, t0.email AS email_133, t0.landingPageContent AS landingPageContent_134, t0.landingPageDescription AS landingPageDescription_135, t0.landingPageCss AS landingPageCss_136, t0.landingPageJs AS landingPageJs_137, t0.landingPageFooterTemplate AS landingPageFooterTemplate_138, t0.landingPageTitle AS landingPageTitle_139, t0.followUpDescription AS followUpDescription_140, t0.followUpVideoLink AS followUpVideoLink_141, t0.followUpPresentation AS followUpPresentation_142, t0.followUpPageContent AS followUpPageContent_143, t0.followUpPageCss AS followUpPageCss_144, t0.followUpPageTitle AS followUpPageTitle_145, t0.followUpSkoolUrl AS followUpSkoolUrl_146, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_147, t0.followUpCtaText AS followUpCtaText_148, t0.followUpCtaUrl AS followUpCtaUrl_149, t0.followUpDocuments AS followUpDocuments_150, t0.followUpPhotos AS followUpPhotos_151, t0.followUpExtraLinks AS followUpExtraLinks_152, t0.history AS history_153, t0.settings AS settings_154, t0.skoolWebhook AS skoolWebhook_155, t0.zapierWebhook AS zapierWebhook_156, t0.metaLeadFormId AS metaLeadFormId_157, t0.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_158, t0.cancellationType AS cancellationType_159, t0.successorEventDateId AS successorEventDateId_160, t0.cancellationMailSentAt AS cancellationMailSentAt_161 FROM sp_event_dates t0 WHERE t0.eventId = 7095 AND t0.status = 'completed' AND t0.access = 'anonymous' LIMIT 1;
|
| 4 |
0.73 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_20, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_21, t0.eventId AS eventId_22, t0.zoomLink AS zoomLink_23, t0.typeformLink AS typeformLink_24, t0.mailTemplate AS mailTemplate_25, t0.mailSubject AS mailSubject_26, t0.reminderMailTemplateId AS reminderMailTemplateId_27, t0.reminderSenderEmail AS reminderSenderEmail_28, t0.phrasesDe AS phrasesDe_29, t0.phrasesEn AS phrasesEn_30, t0.settings AS settings_31, t0.createdAt AS createdAt_32, t0.lastModified AS lastModified_33, t0.lastChangeUser AS lastChangeUser_34 FROM sp_programs t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_20, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_21, t0.eventId AS eventId_22, t0.zoomLink AS zoomLink_23, t0.typeformLink AS typeformLink_24, t0.mailTemplate AS mailTemplate_25, t0.mailSubject AS mailSubject_26, t0.reminderMailTemplateId AS reminderMailTemplateId_27, t0.reminderSenderEmail AS reminderSenderEmail_28, t0.phrasesDe AS phrasesDe_29, t0.phrasesEn AS phrasesEn_30, t0.settings AS settings_31, t0.createdAt AS createdAt_32, t0.lastModified AS lastModified_33, t0.lastChangeUser AS lastChangeUser_34 FROM sp_programs t0 WHERE t0.id = 27;
|
| 5 |
0.84 ms |
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.eventDateId AS eventDateId_2, s0_.mentorId AS mentorId_3, s0_.position AS position_4, s0_.durationMinutes AS durationMinutes_5, s0_.role AS role_6, s0_.status AS status_7, s0_.source AS source_8, s0_.talkTitle AS talkTitle_9, s0_.description AS description_10, s0_.contactName AS contactName_11, s0_.contactEmail AS contactEmail_12, s0_.contactCompany AS contactCompany_13, s0_.contactLinkedin AS contactLinkedin_14, s0_.publicVisible AS publicVisible_15, s0_.adminNote AS adminNote_16, s0_.respondedAt AS respondedAt_17, s0_.createdAt AS createdAt_18, s0_.updatedAt AS updatedAt_19 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (?) AND s0_.publicVisible = 1 AND s0_.status = ? ORDER BY s0_.position ASC, s0_.id ASC
Parameters: [
7095
"confirmed"
]
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.eventDateId AS eventDateId_2, s0_.mentorId AS mentorId_3, s0_.position AS position_4, s0_.durationMinutes AS durationMinutes_5, s0_.role AS role_6, s0_.status AS status_7, s0_.source AS source_8, s0_.talkTitle AS talkTitle_9, s0_.description AS description_10, s0_.contactName AS contactName_11, s0_.contactEmail AS contactEmail_12, s0_.contactCompany AS contactCompany_13, s0_.contactLinkedin AS contactLinkedin_14, s0_.publicVisible AS publicVisible_15, s0_.adminNote AS adminNote_16, s0_.respondedAt AS respondedAt_17, s0_.createdAt AS createdAt_18, s0_.updatedAt AS updatedAt_19 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (7095) AND s0_.publicVisible = 1 AND s0_.status = 'confirmed' ORDER BY s0_.position ASC, s0_.id ASC;
|
| 6 |
0.67 ms |
SELECT s0_.eventId AS eventId_0, s0_.eventDateId AS eventDateId_1, COUNT(s0_.id) AS sclr_2 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (?) AND s0_.status = ? GROUP BY s0_.eventId, s0_.eventDateId
Parameters: [
7095
"requested"
]
SELECT s0_.eventId AS eventId_0, s0_.eventDateId AS eventDateId_1, COUNT(s0_.id) AS sclr_2 FROM sp_event_program_slots s0_ WHERE s0_.eventId IN (7095) AND s0_.status = 'requested' GROUP BY s0_.eventId, s0_.eventDateId;
|
| 7 |
0.55 ms |
SELECT t0.id AS id_1, t0.metaname AS metaname_2, t0.label AS label_3, t0.metavalue AS metavalue_4, t0.lastModified AS lastModified_5 FROM sp_member_options t0 WHERE t0.metaname = ? LIMIT 1
Parameters: [
"sp.phrases.application.de"
]
SELECT t0.id AS id_1, t0.metaname AS metaname_2, t0.label AS label_3, t0.metavalue AS metavalue_4, t0.lastModified AS lastModified_5 FROM sp_member_options t0 WHERE t0.metaname = 'sp.phrases.application.de' LIMIT 1;
|