15.42 ms
(87.06%)
|
1 |
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.seriesTag = ? AND s0_.status = ? ORDER BY s0_.startDate DESC LIMIT 8
Parameters: [
"mistral-meetup"
"publish"
]
SELECT
s0_.id AS id_0,
s0_.eventbriteId AS eventbriteId_1,
s0_.googleCalendarEventId AS googleCalendarEventId_2,
s0_.wpPostId AS wpPostId_3,
s0_.title AS title_4,
s0_.title_en AS title_en_5,
s0_.slug AS slug_6,
s0_.lang AS lang_7,
s0_.imagelink AS imagelink_8,
s0_.videolink AS videolink_9,
s0_.bgImagelink AS bgImagelink_10,
s0_.tagline AS tagline_11,
s0_.headerTextColor AS headerTextColor_12,
s0_.spResponsiblePerson AS spResponsiblePerson_13,
s0_.organization AS organization_14,
s0_.organizerName AS organizerName_15,
s0_.organizerEmail AS organizerEmail_16,
s0_.venueName AS venueName_17,
s0_.venueAddress AS venueAddress_18,
s0_.showFullVenue AS showFullVenue_19,
s0_.ticketing AS ticketing_20,
s0_.applicationUrl AS applicationUrl_21,
s0_.alert AS alert_22,
s0_.trainer AS trainer_23,
s0_.speakers AS speakers_24,
s0_.teaser AS teaser_25,
s0_.navbar AS navbar_26,
s0_.stripePriceId AS stripePriceId_27,
s0_.stripeProductId AS stripeProductId_28,
s0_.stripeAccount AS stripeAccount_29,
s0_.priceInEuroCent AS priceInEuroCent_30,
s0_.isTaxIncluded AS isTaxIncluded_31,
s0_.isFreeForKiCampus AS isFreeForKiCampus_32,
s0_.isFreeForCommunity AS isFreeForCommunity_33,
s0_.isSinglePage AS isSinglePage_34,
s0_.isFormalLanguage AS isFormalLanguage_35,
s0_.isMultiBatchEvent AS isMultiBatchEvent_36,
s0_.isFeatured AS isFeatured_37,
s0_.isFlagship AS isFlagship_38,
s0_.capacity AS capacity_39,
s0_.targetCapacity AS targetCapacity_40,
s0_.twigFile AS twigFile_41,
s0_.additionalCss AS additionalCss_42,
s0_.content AS content_43,
s0_.contentTwig AS contentTwig_44,
s0_.content_blocks AS content_blocks_45,
s0_.content_blocks_en AS content_blocks_en_46,
s0_.ctaContent AS ctaContent_47,
s0_.postCtaContent AS postCtaContent_48,
s0_.tags AS tags_49,
s0_.seriesTag AS seriesTag_50,
s0_.feedbackFormId AS feedbackFormId_51,
s0_.type AS type_52,
s0_.location AS location_53,
s0_.startDate AS startDate_54,
s0_.endDate AS endDate_55,
s0_.duration AS duration_56,
s0_.status AS status_57,
s0_.publishedAt AS publishedAt_58,
s0_.publishedBy AS publishedBy_59,
s0_.settings AS settings_60,
s0_.displayStartDate AS displayStartDate_61,
s0_.seoTitle AS seoTitle_62,
s0_.seoKeyword AS seoKeyword_63,
s0_.seoDescription AS seoDescription_64,
s0_.navbar_en AS navbar_en_65,
s0_.teaser_en AS teaser_en_66,
s0_.content_en AS content_en_67,
s0_.content_twig_en AS content_twig_en_68,
s0_.post_cta_content_en AS post_cta_content_en_69,
s0_.seo_title_en AS seo_title_en_70,
s0_.seo_description_en AS seo_description_en_71,
s0_.seo_keyword_en AS seo_keyword_en_72,
s0_.has_english_version AS has_english_version_73,
s0_.additional_js AS additional_js_74,
s0_.metaPixelId AS metaPixelId_75,
s0_.createDate AS createDate_76,
s0_.lastChangeDate AS lastChangeDate_77,
s0_.lastChangeUser AS lastChangeUser_78,
s0_.publicId AS publicId_79,
s0_.isExternalSubmission AS isExternalSubmission_80,
s0_.createdBy AS createdBy_81,
s0_.lastModified AS lastModified_82,
s0_.createdAt AS createdAt_83,
s0_.orgaNote AS orgaNote_84,
s0_.calendarSyncedAt AS calendarSyncedAt_85,
s0_.logisticsRoom AS logisticsRoom_86,
s0_.logisticsCatering AS logisticsCatering_87,
s0_.logisticsEquipment AS logisticsEquipment_88,
s0_.logisticsHelpers AS logisticsHelpers_89,
s0_.history AS history_90,
s0_.todoHistory AS todoHistory_91
FROM
sp_event_events s0_
WHERE
s0_.seriesTag = ?
AND s0_.status = ?
ORDER BY
s0_.startDate DESC
LIMIT
8
SELECT s0_.id AS id_0, s0_.eventbriteId AS eventbriteId_1, s0_.googleCalendarEventId AS googleCalendarEventId_2, s0_.wpPostId AS wpPostId_3, s0_.title AS title_4, s0_.title_en AS title_en_5, s0_.slug AS slug_6, s0_.lang AS lang_7, s0_.imagelink AS imagelink_8, s0_.videolink AS videolink_9, s0_.bgImagelink AS bgImagelink_10, s0_.tagline AS tagline_11, s0_.headerTextColor AS headerTextColor_12, s0_.spResponsiblePerson AS spResponsiblePerson_13, s0_.organization AS organization_14, s0_.organizerName AS organizerName_15, s0_.organizerEmail AS organizerEmail_16, s0_.venueName AS venueName_17, s0_.venueAddress AS venueAddress_18, s0_.showFullVenue AS showFullVenue_19, s0_.ticketing AS ticketing_20, s0_.applicationUrl AS applicationUrl_21, s0_.alert AS alert_22, s0_.trainer AS trainer_23, s0_.speakers AS speakers_24, s0_.teaser AS teaser_25, s0_.navbar AS navbar_26, s0_.stripePriceId AS stripePriceId_27, s0_.stripeProductId AS stripeProductId_28, s0_.stripeAccount AS stripeAccount_29, s0_.priceInEuroCent AS priceInEuroCent_30, s0_.isTaxIncluded AS isTaxIncluded_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isSinglePage AS isSinglePage_34, s0_.isFormalLanguage AS isFormalLanguage_35, s0_.isMultiBatchEvent AS isMultiBatchEvent_36, s0_.isFeatured AS isFeatured_37, s0_.isFlagship AS isFlagship_38, s0_.capacity AS capacity_39, s0_.targetCapacity AS targetCapacity_40, s0_.twigFile AS twigFile_41, s0_.additionalCss AS additionalCss_42, s0_.content AS content_43, s0_.contentTwig AS contentTwig_44, s0_.content_blocks AS content_blocks_45, s0_.content_blocks_en AS content_blocks_en_46, s0_.ctaContent AS ctaContent_47, s0_.postCtaContent AS postCtaContent_48, s0_.tags AS tags_49, s0_.seriesTag AS seriesTag_50, s0_.feedbackFormId AS feedbackFormId_51, s0_.type AS type_52, s0_.location AS location_53, s0_.startDate AS startDate_54, s0_.endDate AS endDate_55, s0_.duration AS duration_56, s0_.status AS status_57, s0_.publishedAt AS publishedAt_58, s0_.publishedBy AS publishedBy_59, s0_.settings AS settings_60, s0_.displayStartDate AS displayStartDate_61, s0_.seoTitle AS seoTitle_62, s0_.seoKeyword AS seoKeyword_63, s0_.seoDescription AS seoDescription_64, s0_.navbar_en AS navbar_en_65, s0_.teaser_en AS teaser_en_66, s0_.content_en AS content_en_67, s0_.content_twig_en AS content_twig_en_68, s0_.post_cta_content_en AS post_cta_content_en_69, s0_.seo_title_en AS seo_title_en_70, s0_.seo_description_en AS seo_description_en_71, s0_.seo_keyword_en AS seo_keyword_en_72, s0_.has_english_version AS has_english_version_73, s0_.additional_js AS additional_js_74, s0_.metaPixelId AS metaPixelId_75, s0_.createDate AS createDate_76, s0_.lastChangeDate AS lastChangeDate_77, s0_.lastChangeUser AS lastChangeUser_78, s0_.publicId AS publicId_79, s0_.isExternalSubmission AS isExternalSubmission_80, s0_.createdBy AS createdBy_81, s0_.lastModified AS lastModified_82, s0_.createdAt AS createdAt_83, s0_.orgaNote AS orgaNote_84, s0_.calendarSyncedAt AS calendarSyncedAt_85, s0_.logisticsRoom AS logisticsRoom_86, s0_.logisticsCatering AS logisticsCatering_87, s0_.logisticsEquipment AS logisticsEquipment_88, s0_.logisticsHelpers AS logisticsHelpers_89, s0_.history AS history_90, s0_.todoHistory AS todoHistory_91 FROM sp_event_events s0_ WHERE s0_.seriesTag = 'mistral-meetup' AND s0_.status = 'publish' ORDER BY s0_.startDate DESC LIMIT 8;
|
0.86 ms
(4.84%)
|
1 |
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? ORDER BY s0_.startDate ASC
SELECT
s0_.id AS id_0,
s0_.eventId AS eventId_1,
s0_.productId AS productId_2,
s0_.eventDateNumber AS eventDateNumber_3,
s0_.name AS name_4,
s0_.slug AS slug_5,
s0_.url AS url_6,
s0_.status AS status_7,
s0_.visibility AS visibility_8,
s0_.access AS access_9,
s0_.tags AS tags_10,
s0_.lang AS lang_11,
s0_.template AS template_12,
s0_.pageTemplate AS pageTemplate_13,
s0_.priceInEuroCent AS priceInEuroCent_14,
s0_.start AS start_15,
s0_.end AS end_16,
s0_.startDate AS startDate_17,
s0_.endDate AS endDate_18,
s0_.createdAt AS createdAt_19,
s0_.lastModified AS lastModified_20,
s0_.lastChangeUser AS lastChangeUser_21,
s0_.askForTeam AS askForTeam_22,
s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23,
s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24,
s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25,
s0_.hasIncludePhone AS hasIncludePhone_26,
s0_.hasRequirePhone AS hasRequirePhone_27,
s0_.hasFollowUp AS hasFollowUp_28,
s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29,
s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30,
s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31,
s0_.isFreeForKiCampus AS isFreeForKiCampus_32,
s0_.isFreeForCommunity AS isFreeForCommunity_33,
s0_.isTaxIncluded AS isTaxIncluded_34,
s0_.bgImageUrl AS bgImageUrl_35,
s0_.typeformLink AS typeformLink_36,
s0_.zoomLink AS zoomLink_37,
s0_.goToPage AS goToPage_38,
s0_.city AS city_39,
s0_.mailDesignTemplate AS mailDesignTemplate_40,
s0_.senderMail AS senderMail_41,
s0_.fromName AS fromName_42,
s0_.recipientMonitoringMail AS recipientMonitoringMail_43,
s0_.confirmationMailSubject AS confirmationMailSubject_44,
s0_.confirmationMailContent AS confirmationMailContent_45,
s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46,
s0_.adminNotificationMailContent AS adminNotificationMailContent_47,
s0_.reminderSenderEmail AS reminderSenderEmail_48,
s0_.reminderMailSendDate AS reminderMailSendDate_49,
s0_.reminderMailSubject AS reminderMailSubject_50,
s0_.reminderMailContent AS reminderMailContent_51,
s0_.reminderMailStatus AS reminderMailStatus_52,
s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53,
s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54,
s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55,
s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56,
s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57,
s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58,
s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59,
s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60,
s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61,
s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62,
s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63,
s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64,
s0_.surveyId AS surveyId_65,
s0_.surveyMailTemplateId AS surveyMailTemplateId_66,
s0_.surveyBulkMailId AS surveyBulkMailId_67,
s0_.applicationsCount AS applicationsCount_68,
s0_.startedCount AS startedCount_69,
s0_.appliedCount AS appliedCount_70,
s0_.approvedCount AS approvedCount_71,
s0_.rejectedCount AS rejectedCount_72,
s0_.stripeAccount AS stripeAccount_73,
s0_.stripePriceId AS stripePriceId_74,
s0_.stripeProductId AS stripeProductId_75,
s0_.stripePriceIdLive AS stripePriceIdLive_76,
s0_.stripePriceIdTest AS stripePriceIdTest_77,
s0_.stripeProductIdLive AS stripeProductIdLive_78,
s0_.stripeProductIdTest AS stripeProductIdTest_79,
s0_.taxBehavior AS taxBehavior_80,
s0_.paymentProvider AS paymentProvider_81,
s0_.registrationMode AS registrationMode_82,
s0_.externalRegistrationUrl AS externalRegistrationUrl_83,
s0_.externalPlatform AS externalPlatform_84,
s0_.lumaEventApiId AS lumaEventApiId_85,
s0_.meetupEventId AS meetupEventId_86,
s0_.meetupEventUrl AS meetupEventUrl_87,
s0_.registrationHeadline AS registrationHeadline_88,
s0_.registrationSubtitle AS registrationSubtitle_89,
s0_.registrationButtonText AS registrationButtonText_90,
s0_.registrationPriceHtml AS registrationPriceHtml_91,
s0_.registrationRedirectUrl AS registrationRedirectUrl_92,
s0_.registrationTone AS registrationTone_93,
s0_.remoteSessionText AS remoteSessionText_94,
s0_.autoApprovalTag AS autoApprovalTag_95,
s0_.programBudgetMinutes AS programBudgetMinutes_96,
s0_.callForTalksEnabled AS callForTalksEnabled_97,
s0_.googleCalendarEventId AS googleCalendarEventId_98,
s0_.capacity AS capacity_99,
s0_.targetCapacity AS targetCapacity_100,
s0_.title AS title_101,
s0_.teaser AS teaser_102,
s0_.navbar AS navbar_103,
s0_.content AS content_104,
s0_.contentTwig AS contentTwig_105,
s0_.content_blocks AS content_blocks_106,
s0_.content_blocks_en AS content_blocks_en_107,
s0_.ctaContent AS ctaContent_108,
s0_.postCtaContent AS postCtaContent_109,
s0_.tagline AS tagline_110,
s0_.seoTitle AS seoTitle_111,
s0_.seoDescription AS seoDescription_112,
s0_.seoKeyword AS seoKeyword_113,
s0_.imagelink AS imagelink_114,
s0_.bgImagelink AS bgImagelink_115,
s0_.videolink AS videolink_116,
s0_.additionalCss AS additionalCss_117,
s0_.additionalJs AS additionalJs_118,
s0_.trainer AS trainer_119,
s0_.venueName AS venueName_120,
s0_.venueAddress AS venueAddress_121,
s0_.whereOverride AS whereOverride_122,
s0_.showFullVenue AS showFullVenue_123,
s0_.navbarEn AS navbarEn_124,
s0_.teaserEn AS teaserEn_125,
s0_.contentEn AS contentEn_126,
s0_.contentTwigEn AS contentTwigEn_127,
s0_.postCtaContentEn AS postCtaContentEn_128,
s0_.seoTitleEn AS seoTitleEn_129,
s0_.seoDescriptionEn AS seoDescriptionEn_130,
s0_.seoKeywordEn AS seoKeywordEn_131,
s0_.email AS email_132,
s0_.landingPageContent AS landingPageContent_133,
s0_.landingPageDescription AS landingPageDescription_134,
s0_.landingPageCss AS landingPageCss_135,
s0_.landingPageJs AS landingPageJs_136,
s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137,
s0_.landingPageTitle AS landingPageTitle_138,
s0_.followUpDescription AS followUpDescription_139,
s0_.followUpVideoLink AS followUpVideoLink_140,
s0_.followUpPresentation AS followUpPresentation_141,
s0_.followUpPageContent AS followUpPageContent_142,
s0_.followUpPageCss AS followUpPageCss_143,
s0_.followUpPageTitle AS followUpPageTitle_144,
s0_.followUpSkoolUrl AS followUpSkoolUrl_145,
s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146,
s0_.followUpCtaText AS followUpCtaText_147,
s0_.followUpCtaUrl AS followUpCtaUrl_148,
s0_.followUpDocuments AS followUpDocuments_149,
s0_.followUpPhotos AS followUpPhotos_150,
s0_.followUpExtraLinks AS followUpExtraLinks_151,
s0_.history AS history_152,
s0_.settings AS settings_153,
s0_.skoolWebhook AS skoolWebhook_154,
s0_.zapierWebhook AS zapierWebhook_155,
s0_.metaLeadFormId AS metaLeadFormId_156,
s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157,
s0_.cancellationType AS cancellationType_158,
s0_.successorEventDateId AS successorEventDateId_159,
s0_.cancellationMailSentAt AS cancellationMailSentAt_160
FROM
sp_event_dates s0_
WHERE
s0_.eventId = ?
ORDER BY
s0_.startDate ASC
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = 6887 ORDER BY s0_.startDate ASC;
|
0.75 ms
(4.23%)
|
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 = ? LIMIT 1
Parameters: [
"mistral-meetup-nrw-duesseldorf"
]
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 = 'mistral-meetup-nrw-duesseldorf' LIMIT 1;
|
0.68 ms
(3.87%)
|
1 |
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = ? AND (s0_.startDate IS NOT NULL AND s0_.startDate BETWEEN ? AND ?) AND s0_.status IN (?, ?) LIMIT 1
Parameters: [
6887
"2026-07-27 00:00:00"
"2026-07-27 23:59:59"
"active"
"completed"
]
SELECT
s0_.id AS id_0,
s0_.eventId AS eventId_1,
s0_.productId AS productId_2,
s0_.eventDateNumber AS eventDateNumber_3,
s0_.name AS name_4,
s0_.slug AS slug_5,
s0_.url AS url_6,
s0_.status AS status_7,
s0_.visibility AS visibility_8,
s0_.access AS access_9,
s0_.tags AS tags_10,
s0_.lang AS lang_11,
s0_.template AS template_12,
s0_.pageTemplate AS pageTemplate_13,
s0_.priceInEuroCent AS priceInEuroCent_14,
s0_.start AS start_15,
s0_.end AS end_16,
s0_.startDate AS startDate_17,
s0_.endDate AS endDate_18,
s0_.createdAt AS createdAt_19,
s0_.lastModified AS lastModified_20,
s0_.lastChangeUser AS lastChangeUser_21,
s0_.askForTeam AS askForTeam_22,
s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23,
s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24,
s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25,
s0_.hasIncludePhone AS hasIncludePhone_26,
s0_.hasRequirePhone AS hasRequirePhone_27,
s0_.hasFollowUp AS hasFollowUp_28,
s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29,
s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30,
s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31,
s0_.isFreeForKiCampus AS isFreeForKiCampus_32,
s0_.isFreeForCommunity AS isFreeForCommunity_33,
s0_.isTaxIncluded AS isTaxIncluded_34,
s0_.bgImageUrl AS bgImageUrl_35,
s0_.typeformLink AS typeformLink_36,
s0_.zoomLink AS zoomLink_37,
s0_.goToPage AS goToPage_38,
s0_.city AS city_39,
s0_.mailDesignTemplate AS mailDesignTemplate_40,
s0_.senderMail AS senderMail_41,
s0_.fromName AS fromName_42,
s0_.recipientMonitoringMail AS recipientMonitoringMail_43,
s0_.confirmationMailSubject AS confirmationMailSubject_44,
s0_.confirmationMailContent AS confirmationMailContent_45,
s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46,
s0_.adminNotificationMailContent AS adminNotificationMailContent_47,
s0_.reminderSenderEmail AS reminderSenderEmail_48,
s0_.reminderMailSendDate AS reminderMailSendDate_49,
s0_.reminderMailSubject AS reminderMailSubject_50,
s0_.reminderMailContent AS reminderMailContent_51,
s0_.reminderMailStatus AS reminderMailStatus_52,
s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53,
s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54,
s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55,
s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56,
s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57,
s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58,
s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59,
s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60,
s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61,
s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62,
s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63,
s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64,
s0_.surveyId AS surveyId_65,
s0_.surveyMailTemplateId AS surveyMailTemplateId_66,
s0_.surveyBulkMailId AS surveyBulkMailId_67,
s0_.applicationsCount AS applicationsCount_68,
s0_.startedCount AS startedCount_69,
s0_.appliedCount AS appliedCount_70,
s0_.approvedCount AS approvedCount_71,
s0_.rejectedCount AS rejectedCount_72,
s0_.stripeAccount AS stripeAccount_73,
s0_.stripePriceId AS stripePriceId_74,
s0_.stripeProductId AS stripeProductId_75,
s0_.stripePriceIdLive AS stripePriceIdLive_76,
s0_.stripePriceIdTest AS stripePriceIdTest_77,
s0_.stripeProductIdLive AS stripeProductIdLive_78,
s0_.stripeProductIdTest AS stripeProductIdTest_79,
s0_.taxBehavior AS taxBehavior_80,
s0_.paymentProvider AS paymentProvider_81,
s0_.registrationMode AS registrationMode_82,
s0_.externalRegistrationUrl AS externalRegistrationUrl_83,
s0_.externalPlatform AS externalPlatform_84,
s0_.lumaEventApiId AS lumaEventApiId_85,
s0_.meetupEventId AS meetupEventId_86,
s0_.meetupEventUrl AS meetupEventUrl_87,
s0_.registrationHeadline AS registrationHeadline_88,
s0_.registrationSubtitle AS registrationSubtitle_89,
s0_.registrationButtonText AS registrationButtonText_90,
s0_.registrationPriceHtml AS registrationPriceHtml_91,
s0_.registrationRedirectUrl AS registrationRedirectUrl_92,
s0_.registrationTone AS registrationTone_93,
s0_.remoteSessionText AS remoteSessionText_94,
s0_.autoApprovalTag AS autoApprovalTag_95,
s0_.programBudgetMinutes AS programBudgetMinutes_96,
s0_.callForTalksEnabled AS callForTalksEnabled_97,
s0_.googleCalendarEventId AS googleCalendarEventId_98,
s0_.capacity AS capacity_99,
s0_.targetCapacity AS targetCapacity_100,
s0_.title AS title_101,
s0_.teaser AS teaser_102,
s0_.navbar AS navbar_103,
s0_.content AS content_104,
s0_.contentTwig AS contentTwig_105,
s0_.content_blocks AS content_blocks_106,
s0_.content_blocks_en AS content_blocks_en_107,
s0_.ctaContent AS ctaContent_108,
s0_.postCtaContent AS postCtaContent_109,
s0_.tagline AS tagline_110,
s0_.seoTitle AS seoTitle_111,
s0_.seoDescription AS seoDescription_112,
s0_.seoKeyword AS seoKeyword_113,
s0_.imagelink AS imagelink_114,
s0_.bgImagelink AS bgImagelink_115,
s0_.videolink AS videolink_116,
s0_.additionalCss AS additionalCss_117,
s0_.additionalJs AS additionalJs_118,
s0_.trainer AS trainer_119,
s0_.venueName AS venueName_120,
s0_.venueAddress AS venueAddress_121,
s0_.whereOverride AS whereOverride_122,
s0_.showFullVenue AS showFullVenue_123,
s0_.navbarEn AS navbarEn_124,
s0_.teaserEn AS teaserEn_125,
s0_.contentEn AS contentEn_126,
s0_.contentTwigEn AS contentTwigEn_127,
s0_.postCtaContentEn AS postCtaContentEn_128,
s0_.seoTitleEn AS seoTitleEn_129,
s0_.seoDescriptionEn AS seoDescriptionEn_130,
s0_.seoKeywordEn AS seoKeywordEn_131,
s0_.email AS email_132,
s0_.landingPageContent AS landingPageContent_133,
s0_.landingPageDescription AS landingPageDescription_134,
s0_.landingPageCss AS landingPageCss_135,
s0_.landingPageJs AS landingPageJs_136,
s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137,
s0_.landingPageTitle AS landingPageTitle_138,
s0_.followUpDescription AS followUpDescription_139,
s0_.followUpVideoLink AS followUpVideoLink_140,
s0_.followUpPresentation AS followUpPresentation_141,
s0_.followUpPageContent AS followUpPageContent_142,
s0_.followUpPageCss AS followUpPageCss_143,
s0_.followUpPageTitle AS followUpPageTitle_144,
s0_.followUpSkoolUrl AS followUpSkoolUrl_145,
s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146,
s0_.followUpCtaText AS followUpCtaText_147,
s0_.followUpCtaUrl AS followUpCtaUrl_148,
s0_.followUpDocuments AS followUpDocuments_149,
s0_.followUpPhotos AS followUpPhotos_150,
s0_.followUpExtraLinks AS followUpExtraLinks_151,
s0_.history AS history_152,
s0_.settings AS settings_153,
s0_.skoolWebhook AS skoolWebhook_154,
s0_.zapierWebhook AS zapierWebhook_155,
s0_.metaLeadFormId AS metaLeadFormId_156,
s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157,
s0_.cancellationType AS cancellationType_158,
s0_.successorEventDateId AS successorEventDateId_159,
s0_.cancellationMailSentAt AS cancellationMailSentAt_160
FROM
sp_event_dates s0_
WHERE
s0_.eventId = ?
AND (
s0_.startDate IS NOT NULL
AND s0_.startDate BETWEEN ?
AND ?
)
AND s0_.status IN (?, ?)
LIMIT
1
SELECT s0_.id AS id_0, s0_.eventId AS eventId_1, s0_.productId AS productId_2, s0_.eventDateNumber AS eventDateNumber_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.url AS url_6, s0_.status AS status_7, s0_.visibility AS visibility_8, s0_.access AS access_9, s0_.tags AS tags_10, s0_.lang AS lang_11, s0_.template AS template_12, s0_.pageTemplate AS pageTemplate_13, s0_.priceInEuroCent AS priceInEuroCent_14, s0_.start AS start_15, s0_.end AS end_16, s0_.startDate AS startDate_17, s0_.endDate AS endDate_18, s0_.createdAt AS createdAt_19, s0_.lastModified AS lastModified_20, s0_.lastChangeUser AS lastChangeUser_21, s0_.askForTeam AS askForTeam_22, s0_.hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_23, s0_.hasIncludeTermsConsent AS hasIncludeTermsConsent_24, s0_.hasIncludeLinkedIn AS hasIncludeLinkedIn_25, s0_.hasIncludePhone AS hasIncludePhone_26, s0_.hasRequirePhone AS hasRequirePhone_27, s0_.hasFollowUp AS hasFollowUp_28, s0_.autoFeedbackSurveyEnabled AS autoFeedbackSurveyEnabled_29, s0_.autoFeedbackSurveyDelayMinutes AS autoFeedbackSurveyDelayMinutes_30, s0_.autoFeedbackSurveyCreatedAt AS autoFeedbackSurveyCreatedAt_31, s0_.isFreeForKiCampus AS isFreeForKiCampus_32, s0_.isFreeForCommunity AS isFreeForCommunity_33, s0_.isTaxIncluded AS isTaxIncluded_34, s0_.bgImageUrl AS bgImageUrl_35, s0_.typeformLink AS typeformLink_36, s0_.zoomLink AS zoomLink_37, s0_.goToPage AS goToPage_38, s0_.city AS city_39, s0_.mailDesignTemplate AS mailDesignTemplate_40, s0_.senderMail AS senderMail_41, s0_.fromName AS fromName_42, s0_.recipientMonitoringMail AS recipientMonitoringMail_43, s0_.confirmationMailSubject AS confirmationMailSubject_44, s0_.confirmationMailContent AS confirmationMailContent_45, s0_.adminNotificationMailSubject AS adminNotificationMailSubject_46, s0_.adminNotificationMailContent AS adminNotificationMailContent_47, s0_.reminderSenderEmail AS reminderSenderEmail_48, s0_.reminderMailSendDate AS reminderMailSendDate_49, s0_.reminderMailSubject AS reminderMailSubject_50, s0_.reminderMailContent AS reminderMailContent_51, s0_.reminderMailStatus AS reminderMailStatus_52, s0_.approvalReceivedMailSubject AS approvalReceivedMailSubject_53, s0_.approvalReceivedMailContent AS approvalReceivedMailContent_54, s0_.approvalReceivedMailSubjectEn AS approvalReceivedMailSubjectEn_55, s0_.approvalReceivedMailContentEn AS approvalReceivedMailContentEn_56, s0_.approvalApprovedMailSubject AS approvalApprovedMailSubject_57, s0_.approvalApprovedMailContent AS approvalApprovedMailContent_58, s0_.approvalApprovedMailSubjectEn AS approvalApprovedMailSubjectEn_59, s0_.approvalApprovedMailContentEn AS approvalApprovedMailContentEn_60, s0_.approvalRejectedMailSubject AS approvalRejectedMailSubject_61, s0_.approvalRejectedMailContent AS approvalRejectedMailContent_62, s0_.approvalRejectedMailSubjectEn AS approvalRejectedMailSubjectEn_63, s0_.approvalRejectedMailContentEn AS approvalRejectedMailContentEn_64, s0_.surveyId AS surveyId_65, s0_.surveyMailTemplateId AS surveyMailTemplateId_66, s0_.surveyBulkMailId AS surveyBulkMailId_67, s0_.applicationsCount AS applicationsCount_68, s0_.startedCount AS startedCount_69, s0_.appliedCount AS appliedCount_70, s0_.approvedCount AS approvedCount_71, s0_.rejectedCount AS rejectedCount_72, s0_.stripeAccount AS stripeAccount_73, s0_.stripePriceId AS stripePriceId_74, s0_.stripeProductId AS stripeProductId_75, s0_.stripePriceIdLive AS stripePriceIdLive_76, s0_.stripePriceIdTest AS stripePriceIdTest_77, s0_.stripeProductIdLive AS stripeProductIdLive_78, s0_.stripeProductIdTest AS stripeProductIdTest_79, s0_.taxBehavior AS taxBehavior_80, s0_.paymentProvider AS paymentProvider_81, s0_.registrationMode AS registrationMode_82, s0_.externalRegistrationUrl AS externalRegistrationUrl_83, s0_.externalPlatform AS externalPlatform_84, s0_.lumaEventApiId AS lumaEventApiId_85, s0_.meetupEventId AS meetupEventId_86, s0_.meetupEventUrl AS meetupEventUrl_87, s0_.registrationHeadline AS registrationHeadline_88, s0_.registrationSubtitle AS registrationSubtitle_89, s0_.registrationButtonText AS registrationButtonText_90, s0_.registrationPriceHtml AS registrationPriceHtml_91, s0_.registrationRedirectUrl AS registrationRedirectUrl_92, s0_.registrationTone AS registrationTone_93, s0_.remoteSessionText AS remoteSessionText_94, s0_.autoApprovalTag AS autoApprovalTag_95, s0_.programBudgetMinutes AS programBudgetMinutes_96, s0_.callForTalksEnabled AS callForTalksEnabled_97, s0_.googleCalendarEventId AS googleCalendarEventId_98, s0_.capacity AS capacity_99, s0_.targetCapacity AS targetCapacity_100, s0_.title AS title_101, s0_.teaser AS teaser_102, s0_.navbar AS navbar_103, s0_.content AS content_104, s0_.contentTwig AS contentTwig_105, s0_.content_blocks AS content_blocks_106, s0_.content_blocks_en AS content_blocks_en_107, s0_.ctaContent AS ctaContent_108, s0_.postCtaContent AS postCtaContent_109, s0_.tagline AS tagline_110, s0_.seoTitle AS seoTitle_111, s0_.seoDescription AS seoDescription_112, s0_.seoKeyword AS seoKeyword_113, s0_.imagelink AS imagelink_114, s0_.bgImagelink AS bgImagelink_115, s0_.videolink AS videolink_116, s0_.additionalCss AS additionalCss_117, s0_.additionalJs AS additionalJs_118, s0_.trainer AS trainer_119, s0_.venueName AS venueName_120, s0_.venueAddress AS venueAddress_121, s0_.whereOverride AS whereOverride_122, s0_.showFullVenue AS showFullVenue_123, s0_.navbarEn AS navbarEn_124, s0_.teaserEn AS teaserEn_125, s0_.contentEn AS contentEn_126, s0_.contentTwigEn AS contentTwigEn_127, s0_.postCtaContentEn AS postCtaContentEn_128, s0_.seoTitleEn AS seoTitleEn_129, s0_.seoDescriptionEn AS seoDescriptionEn_130, s0_.seoKeywordEn AS seoKeywordEn_131, s0_.email AS email_132, s0_.landingPageContent AS landingPageContent_133, s0_.landingPageDescription AS landingPageDescription_134, s0_.landingPageCss AS landingPageCss_135, s0_.landingPageJs AS landingPageJs_136, s0_.landingPageFooterTemplate AS landingPageFooterTemplate_137, s0_.landingPageTitle AS landingPageTitle_138, s0_.followUpDescription AS followUpDescription_139, s0_.followUpVideoLink AS followUpVideoLink_140, s0_.followUpPresentation AS followUpPresentation_141, s0_.followUpPageContent AS followUpPageContent_142, s0_.followUpPageCss AS followUpPageCss_143, s0_.followUpPageTitle AS followUpPageTitle_144, s0_.followUpSkoolUrl AS followUpSkoolUrl_145, s0_.followUpWhatsAppUrl AS followUpWhatsAppUrl_146, s0_.followUpCtaText AS followUpCtaText_147, s0_.followUpCtaUrl AS followUpCtaUrl_148, s0_.followUpDocuments AS followUpDocuments_149, s0_.followUpPhotos AS followUpPhotos_150, s0_.followUpExtraLinks AS followUpExtraLinks_151, s0_.history AS history_152, s0_.settings AS settings_153, s0_.skoolWebhook AS skoolWebhook_154, s0_.zapierWebhook AS zapierWebhook_155, s0_.metaLeadFormId AS metaLeadFormId_156, s0_.metaLeadAutoNewsletter AS metaLeadAutoNewsletter_157, s0_.cancellationType AS cancellationType_158, s0_.successorEventDateId AS successorEventDateId_159, s0_.cancellationMailSentAt AS cancellationMailSentAt_160 FROM sp_event_dates s0_ WHERE s0_.eventId = 6887 AND (s0_.startDate IS NOT NULL AND s0_.startDate BETWEEN '2026-07-27 00:00:00' AND '2026-07-27 23:59:59') AND s0_.status IN ('active', 'completed') LIMIT 1;
|