1
0.89 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 :
[
"ai-friday-ki-community-meetup-koeln "
]
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
Copy
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 = 'ai-friday-ki-community-meetup-koeln' LIMIT 1 ;
Copy
2
7.75 ms
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 :
[
"ai-friday-koeln "
"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
Copy
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 = 'ai-friday-koeln' AND s0_ . status = 'publish' ORDER BY s0_ . startDate DESC LIMIT 8 ;
Copy
3
1.37 ms
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
Copy
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 = 6737 ORDER BY s0_ . startDate ASC ;
Copy
4
0.98 ms
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 :
[
6737
"2026-09-04 00:00:00 "
"2026-09-04 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
Copy
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 = 6737 AND (s0_ . startDate IS NOT NULL AND s0_ . startDate BETWEEN '2026-09-04 00:00:00' AND '2026-09-04 23:59:59' ) AND s0_ . status IN ('active' , 'completed' ) LIMIT 1 ;
Copy
5
0.92 ms
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_ . status = ? AND (s0_ . startDate IS NOT NULL AND s0_ . startDate > = ? ) ORDER BY s0_ . startDate ASC LIMIT 10
Parameters :
[
6737
"active "
"2026-08-07 00:00:00 "
]
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_ . status = ?
AND (
s0_ . startDate IS NOT NULL
AND s0_ . startDate > = ?
)
ORDER BY
s0_ . startDate ASC
LIMIT
10
Copy
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 = 6737 AND s0_ . status = 'active' AND (s0_ . startDate IS NOT NULL AND s0_ . startDate > = '2026-08-07 00:00:00' ) ORDER BY s0_ . startDate ASC LIMIT 10 ;
Copy
6
1.10 ms
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 < ? ) ORDER BY s0_ . startDate DESC LIMIT 10
Parameters :
[
6737
"2026-08-07 17:09:54 "
]
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 < ?
)
ORDER BY
s0_ . startDate DESC
LIMIT
10
Copy
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 = 6737 AND (s0_ . startDate IS NOT NULL AND s0_ . startDate < '2026-08-07 17:09:54' ) ORDER BY s0_ . startDate DESC LIMIT 10 ;
Copy
7
0.39 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 ;
Copy
8
0.32 ms
SELECT COUNT (s0_ . id ) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_ . eventDateId = ? AND s0_ . applicationStatus = ? AND s0_ . deletedAt IS NULL
Parameters :
[
2317
"started "
]
SELECT COUNT (s0_ . id ) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_ . eventDateId = 2317 AND s0_ . applicationStatus = 'started' AND s0_ . deletedAt IS NULL ;
Copy
9
0.31 ms
SELECT COUNT (s0_ . id ) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_ . eventDateId = ? AND s0_ . applicationStatus = ? AND s0_ . deletedAt IS NULL
Parameters :
[
2317
"applied "
]
SELECT COUNT (s0_ . id ) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_ . eventDateId = 2317 AND s0_ . applicationStatus = 'applied' AND s0_ . deletedAt IS NULL ;
Copy
10
0.29 ms
SELECT COUNT (s0_ . id ) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_ . eventDateId = ? AND s0_ . applicationStatus = ? AND s0_ . deletedAt IS NULL
Parameters :
[
2317
"approved "
]
SELECT COUNT (s0_ . id ) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_ . eventDateId = 2317 AND s0_ . applicationStatus = 'approved' AND s0_ . deletedAt IS NULL ;
Copy
11
0.27 ms
SELECT COUNT (s0_ . id ) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_ . eventDateId = ? AND s0_ . applicationStatus = ? AND s0_ . deletedAt IS NULL
Parameters :
[
2317
"rejected "
]
SELECT COUNT (s0_ . id ) AS sclr_0 FROM sp_event_registrations s0_ WHERE s0_ . eventDateId = 2317 AND s0_ . applicationStatus = 'rejected' AND s0_ . deletedAt IS NULL ;
Copy
12
0.30 ms
SELECT t0 . id AS id_1 , t0 . `key` AS key_2 , t0 . value AS value_3 , t0 . type AS type_4 , t0 . category AS category_5 , t0 . description AS description_6 , t0 . createdAt AS createdAt_7 , t0 . updatedAt AS updatedAt_8 , t0 . updatedBy AS updatedBy_9 FROM sp_system_config t0 WHERE t0 . `key` = ? LIMIT 1
Parameters :
[
"b135.auto_booking.enabled "
]
SELECT t0 . id AS id_1 , t0 . `key` AS key_2 , t0 . value AS value_3 , t0 . type AS type_4 , t0 . category AS category_5 , t0 . description AS description_6 , t0 . createdAt AS createdAt_7 , t0 . updatedAt AS updatedAt_8 , t0 . updatedBy AS updatedBy_9 FROM sp_system_config t0 WHERE t0 . `key` = 'b135.auto_booking.enabled' LIMIT 1 ;
Copy
13
0.12 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
14
0.28 ms
UPDATE sp_event_dates SET applicationsCount = ? , startedCount = ? , appliedCount = ? , approvedCount = ? , rejectedCount = ? , lastModified = ? WHERE id = ?
Parameters :
[
"3 "
"0 "
"3 "
"0 "
"0 "
"2026-08-07 17:09:54 "
2317
]
UPDATE sp_event_dates SET applicationsCount = '3' , startedCount = '0' , appliedCount = '3' , approvedCount = '0' , rejectedCount = '0' , lastModified = '2026-08-07 17:09:54' WHERE id = 2317 ;
Copy
15
0.18 ms
"COMMIT"
16
0.40 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . type AS type_3 , t0 . slug AS slug_4 , t0 . title AS title_5 , t0 . teaser AS teaser_6 , t0 . partnerAdminRating AS partnerAdminRating_7 , t0 . imagelink AS imagelink_8 , t0 . website AS website_9 , t0 . tags AS tags_10 , t0 . feedTags AS feedTags_11 , t0 . logoUrl AS logoUrl_12 , t0 . publicId AS publicId_13 , t0 . description AS description_14 , t0 . relatedInformation AS relatedInformation_15 , t0 . redeemPerk AS redeemPerk_16 , t0 . targetGroup AS targetGroup_17 , t0 . contactPartner AS contactPartner_18 , t0 . contactPartnerMemberId AS contactPartnerMemberId_19 , t0 . isActive AS isActive_20 , t0 . status AS status_21 , t0 . visibility AS visibility_22 , t0 . teamId AS teamId_23 , t0 . teamName AS teamName_24 , t0 . titleEN AS titleEN_25 , t0 . teaserEN AS teaserEN_26 , t0 . descriptionEN AS descriptionEN_27 , t0 . relatedInformationEN AS relatedInformationEN_28 , t0 . redeemPerkEN AS redeemPerkEN_29 , t0 . seoTitle AS seoTitle_30 , t0 . seoKeyword AS seoKeyword_31 , t0 . seoDescription AS seoDescription_32 , t0 . history AS history_33 , t0 . lastModified AS lastModified_34 , t0 . lastChangeUser AS lastChangeUser_35 , t0 . createdAt AS createdAt_36 , t0 . additionalHead AS additionalHead_37 , t0 . publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . type AS type_3 , t0 . slug AS slug_4 , t0 . title AS title_5 , t0 . teaser AS teaser_6 , t0 . partnerAdminRating AS partnerAdminRating_7 , t0 . imagelink AS imagelink_8 , t0 . website AS website_9 , t0 . tags AS tags_10 , t0 . feedTags AS feedTags_11 , t0 . logoUrl AS logoUrl_12 , t0 . publicId AS publicId_13 , t0 . description AS description_14 , t0 . relatedInformation AS relatedInformation_15 , t0 . redeemPerk AS redeemPerk_16 , t0 . targetGroup AS targetGroup_17 , t0 . contactPartner AS contactPartner_18 , t0 . contactPartnerMemberId AS contactPartnerMemberId_19 , t0 . isActive AS isActive_20 , t0 . status AS status_21 , t0 . visibility AS visibility_22 , t0 . teamId AS teamId_23 , t0 . teamName AS teamName_24 , t0 . titleEN AS titleEN_25 , t0 . teaserEN AS teaserEN_26 , t0 . descriptionEN AS descriptionEN_27 , t0 . relatedInformationEN AS relatedInformationEN_28 , t0 . redeemPerkEN AS redeemPerkEN_29 , t0 . seoTitle AS seoTitle_30 , t0 . seoKeyword AS seoKeyword_31 , t0 . seoDescription AS seoDescription_32 , t0 . history AS history_33 , t0 . lastModified AS lastModified_34 , t0 . lastChangeUser AS lastChangeUser_35 , t0 . createdAt AS createdAt_36 , t0 . additionalHead AS additionalHead_37 , t0 . publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0 . id = '1164' ;
Copy
17
0.31 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . type AS type_3 , t0 . slug AS slug_4 , t0 . title AS title_5 , t0 . teaser AS teaser_6 , t0 . partnerAdminRating AS partnerAdminRating_7 , t0 . imagelink AS imagelink_8 , t0 . website AS website_9 , t0 . tags AS tags_10 , t0 . feedTags AS feedTags_11 , t0 . logoUrl AS logoUrl_12 , t0 . publicId AS publicId_13 , t0 . description AS description_14 , t0 . relatedInformation AS relatedInformation_15 , t0 . redeemPerk AS redeemPerk_16 , t0 . targetGroup AS targetGroup_17 , t0 . contactPartner AS contactPartner_18 , t0 . contactPartnerMemberId AS contactPartnerMemberId_19 , t0 . isActive AS isActive_20 , t0 . status AS status_21 , t0 . visibility AS visibility_22 , t0 . teamId AS teamId_23 , t0 . teamName AS teamName_24 , t0 . titleEN AS titleEN_25 , t0 . teaserEN AS teaserEN_26 , t0 . descriptionEN AS descriptionEN_27 , t0 . relatedInformationEN AS relatedInformationEN_28 , t0 . redeemPerkEN AS redeemPerkEN_29 , t0 . seoTitle AS seoTitle_30 , t0 . seoKeyword AS seoKeyword_31 , t0 . seoDescription AS seoDescription_32 , t0 . history AS history_33 , t0 . lastModified AS lastModified_34 , t0 . lastChangeUser AS lastChangeUser_35 , t0 . createdAt AS createdAt_36 , t0 . additionalHead AS additionalHead_37 , t0 . publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . type AS type_3 , t0 . slug AS slug_4 , t0 . title AS title_5 , t0 . teaser AS teaser_6 , t0 . partnerAdminRating AS partnerAdminRating_7 , t0 . imagelink AS imagelink_8 , t0 . website AS website_9 , t0 . tags AS tags_10 , t0 . feedTags AS feedTags_11 , t0 . logoUrl AS logoUrl_12 , t0 . publicId AS publicId_13 , t0 . description AS description_14 , t0 . relatedInformation AS relatedInformation_15 , t0 . redeemPerk AS redeemPerk_16 , t0 . targetGroup AS targetGroup_17 , t0 . contactPartner AS contactPartner_18 , t0 . contactPartnerMemberId AS contactPartnerMemberId_19 , t0 . isActive AS isActive_20 , t0 . status AS status_21 , t0 . visibility AS visibility_22 , t0 . teamId AS teamId_23 , t0 . teamName AS teamName_24 , t0 . titleEN AS titleEN_25 , t0 . teaserEN AS teaserEN_26 , t0 . descriptionEN AS descriptionEN_27 , t0 . relatedInformationEN AS relatedInformationEN_28 , t0 . redeemPerkEN AS redeemPerkEN_29 , t0 . seoTitle AS seoTitle_30 , t0 . seoKeyword AS seoKeyword_31 , t0 . seoDescription AS seoDescription_32 , t0 . history AS history_33 , t0 . lastModified AS lastModified_34 , t0 . lastChangeUser AS lastChangeUser_35 , t0 . createdAt AS createdAt_36 , t0 . additionalHead AS additionalHead_37 , t0 . publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0 . id = '1187' ;
Copy
18
0.31 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . type AS type_3 , t0 . slug AS slug_4 , t0 . title AS title_5 , t0 . teaser AS teaser_6 , t0 . partnerAdminRating AS partnerAdminRating_7 , t0 . imagelink AS imagelink_8 , t0 . website AS website_9 , t0 . tags AS tags_10 , t0 . feedTags AS feedTags_11 , t0 . logoUrl AS logoUrl_12 , t0 . publicId AS publicId_13 , t0 . description AS description_14 , t0 . relatedInformation AS relatedInformation_15 , t0 . redeemPerk AS redeemPerk_16 , t0 . targetGroup AS targetGroup_17 , t0 . contactPartner AS contactPartner_18 , t0 . contactPartnerMemberId AS contactPartnerMemberId_19 , t0 . isActive AS isActive_20 , t0 . status AS status_21 , t0 . visibility AS visibility_22 , t0 . teamId AS teamId_23 , t0 . teamName AS teamName_24 , t0 . titleEN AS titleEN_25 , t0 . teaserEN AS teaserEN_26 , t0 . descriptionEN AS descriptionEN_27 , t0 . relatedInformationEN AS relatedInformationEN_28 , t0 . redeemPerkEN AS redeemPerkEN_29 , t0 . seoTitle AS seoTitle_30 , t0 . seoKeyword AS seoKeyword_31 , t0 . seoDescription AS seoDescription_32 , t0 . history AS history_33 , t0 . lastModified AS lastModified_34 , t0 . lastChangeUser AS lastChangeUser_35 , t0 . createdAt AS createdAt_36 , t0 . additionalHead AS additionalHead_37 , t0 . publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . type AS type_3 , t0 . slug AS slug_4 , t0 . title AS title_5 , t0 . teaser AS teaser_6 , t0 . partnerAdminRating AS partnerAdminRating_7 , t0 . imagelink AS imagelink_8 , t0 . website AS website_9 , t0 . tags AS tags_10 , t0 . feedTags AS feedTags_11 , t0 . logoUrl AS logoUrl_12 , t0 . publicId AS publicId_13 , t0 . description AS description_14 , t0 . relatedInformation AS relatedInformation_15 , t0 . redeemPerk AS redeemPerk_16 , t0 . targetGroup AS targetGroup_17 , t0 . contactPartner AS contactPartner_18 , t0 . contactPartnerMemberId AS contactPartnerMemberId_19 , t0 . isActive AS isActive_20 , t0 . status AS status_21 , t0 . visibility AS visibility_22 , t0 . teamId AS teamId_23 , t0 . teamName AS teamName_24 , t0 . titleEN AS titleEN_25 , t0 . teaserEN AS teaserEN_26 , t0 . descriptionEN AS descriptionEN_27 , t0 . relatedInformationEN AS relatedInformationEN_28 , t0 . redeemPerkEN AS redeemPerkEN_29 , t0 . seoTitle AS seoTitle_30 , t0 . seoKeyword AS seoKeyword_31 , t0 . seoDescription AS seoDescription_32 , t0 . history AS history_33 , t0 . lastModified AS lastModified_34 , t0 . lastChangeUser AS lastChangeUser_35 , t0 . createdAt AS createdAt_36 , t0 . additionalHead AS additionalHead_37 , t0 . publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0 . id = '1098' ;
Copy
19
0.29 ms
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . type AS type_3 , t0 . slug AS slug_4 , t0 . title AS title_5 , t0 . teaser AS teaser_6 , t0 . partnerAdminRating AS partnerAdminRating_7 , t0 . imagelink AS imagelink_8 , t0 . website AS website_9 , t0 . tags AS tags_10 , t0 . feedTags AS feedTags_11 , t0 . logoUrl AS logoUrl_12 , t0 . publicId AS publicId_13 , t0 . description AS description_14 , t0 . relatedInformation AS relatedInformation_15 , t0 . redeemPerk AS redeemPerk_16 , t0 . targetGroup AS targetGroup_17 , t0 . contactPartner AS contactPartner_18 , t0 . contactPartnerMemberId AS contactPartnerMemberId_19 , t0 . isActive AS isActive_20 , t0 . status AS status_21 , t0 . visibility AS visibility_22 , t0 . teamId AS teamId_23 , t0 . teamName AS teamName_24 , t0 . titleEN AS titleEN_25 , t0 . teaserEN AS teaserEN_26 , t0 . descriptionEN AS descriptionEN_27 , t0 . relatedInformationEN AS relatedInformationEN_28 , t0 . redeemPerkEN AS redeemPerkEN_29 , t0 . seoTitle AS seoTitle_30 , t0 . seoKeyword AS seoKeyword_31 , t0 . seoDescription AS seoDescription_32 , t0 . history AS history_33 , t0 . lastModified AS lastModified_34 , t0 . lastChangeUser AS lastChangeUser_35 , t0 . createdAt AS createdAt_36 , t0 . additionalHead AS additionalHead_37 , t0 . publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . category AS category_2 , t0 . type AS type_3 , t0 . slug AS slug_4 , t0 . title AS title_5 , t0 . teaser AS teaser_6 , t0 . partnerAdminRating AS partnerAdminRating_7 , t0 . imagelink AS imagelink_8 , t0 . website AS website_9 , t0 . tags AS tags_10 , t0 . feedTags AS feedTags_11 , t0 . logoUrl AS logoUrl_12 , t0 . publicId AS publicId_13 , t0 . description AS description_14 , t0 . relatedInformation AS relatedInformation_15 , t0 . redeemPerk AS redeemPerk_16 , t0 . targetGroup AS targetGroup_17 , t0 . contactPartner AS contactPartner_18 , t0 . contactPartnerMemberId AS contactPartnerMemberId_19 , t0 . isActive AS isActive_20 , t0 . status AS status_21 , t0 . visibility AS visibility_22 , t0 . teamId AS teamId_23 , t0 . teamName AS teamName_24 , t0 . titleEN AS titleEN_25 , t0 . teaserEN AS teaserEN_26 , t0 . descriptionEN AS descriptionEN_27 , t0 . relatedInformationEN AS relatedInformationEN_28 , t0 . redeemPerkEN AS redeemPerkEN_29 , t0 . seoTitle AS seoTitle_30 , t0 . seoKeyword AS seoKeyword_31 , t0 . seoDescription AS seoDescription_32 , t0 . history AS history_33 , t0 . lastModified AS lastModified_34 , t0 . lastChangeUser AS lastChangeUser_35 , t0 . createdAt AS createdAt_36 , t0 . additionalHead AS additionalHead_37 , t0 . publicCategory AS publicCategory_38 FROM sp_content_pages t0 WHERE t0 . id = '1177' ;
Copy
20
0.51 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . score AS score_2 ,
t0 . completenessScore AS completenessScore_3 ,
t0 . status AS status_4 ,
t0 . location AS location_5 ,
t0 . salutation AS salutation_6 ,
t0 . title AS title_7 ,
t0 . jobTitle AS jobTitle_8 ,
t0 . firstName AS firstName_9 ,
t0 . lastName AS lastName_10 ,
t0 . name AS name_11 ,
t0 . sortName AS sortName_12 ,
t0 . email AS email_13 ,
t0 . secondaryEmail AS secondaryEmail_14 ,
t0 . phone AS phone_15 ,
t0 . hasCommunityMembership AS hasCommunityMembership_16 ,
t0 . utm_source AS utm_source_17 ,
t0 . utm_medium AS utm_medium_18 ,
t0 . utm_campaign AS utm_campaign_19 ,
t0 . utm_term AS utm_term_20 ,
t0 . utm_content AS utm_content_21 ,
t0 . birthday AS birthday_22 ,
t0 . addressFieldOne AS addressFieldOne_23 ,
t0 . addressFieldTwo AS addressFieldTwo_24 ,
t0 . addressCountryCode AS addressCountryCode_25 ,
t0 . addressPostalCode AS addressPostalCode_26 ,
t0 . addressCity AS addressCity_27 ,
t0 . teamId AS teamId_28 ,
t0 . teamName AS teamName_29 ,
t0 . company AS company_30 ,
t0 . history AS history_31 ,
t0 . tags AS tags_32 ,
t0 . annotation AS annotation_33 ,
t0 . mentorBuckets AS mentorBuckets_34 ,
t0 . areasOfExpertise AS areasOfExpertise_35 ,
t0 . mentor_firma AS mentor_firma_36 ,
t0 . mentor_firma_url AS mentor_firma_url_37 ,
t0 . mentor_locations AS mentor_locations_38 ,
t0 . mentor_profile AS mentor_profile_39 ,
t0 . mentor_note AS mentor_note_40 ,
t0 . mentor_admin_rating AS mentor_admin_rating_41 ,
t0 . active AS active_42 ,
t0 . tiefgarage AS tiefgarage_43 ,
t0 . transponder AS transponder_44 ,
t0 . isTransponderAllowed AS isTransponderAllowed_45 ,
t0 . imageLink AS imageLink_46 ,
t0 . homepage AS homepage_47 ,
t0 . xing AS xing_48 ,
t0 . pipedriveId AS pipedriveId_49 ,
t0 . linkedin AS linkedin_50 ,
t0 . facebook AS facebook_51 ,
t0 . instagram AS instagram_52 ,
t0 . tiktok AS tiktok_53 ,
t0 . threads AS threads_54 ,
t0 . youtube AS youtube_55 ,
t0 . twitter AS twitter_56 ,
t0 . github AS github_57 ,
t0 . reachableLocation AS reachableLocation_58 ,
t0 . skills AS skills_59 ,
t0 . description AS description_60 ,
t0 . isVisibleInNetworking AS isVisibleInNetworking_61 ,
t0 . gender AS gender_62 ,
t0 . currentFocus AS currentFocus_63 ,
t0 . networkingConsentAt AS networkingConsentAt_64 ,
t0 . networkingConsentVersion AS networkingConsentVersion_65 ,
t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 ,
t0 . touchpoints AS touchpoints_67 ,
t0 . isAddressComplete AS isAddressComplete_68 ,
t0 . hasMailchimp AS hasMailchimp_69 ,
t0 . hasKiNewsletter AS hasKiNewsletter_70 ,
t0 . hubspotSyncPending AS hubspotSyncPending_71 ,
t0 . enterDate AS enterDate_72 ,
t0 . exitDate AS exitDate_73 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_74 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_75 ,
t0 . lastModified AS lastModified_76 ,
t0 . lastChangeUser AS lastChangeUser_77 ,
t0 . onboardingCompletedAt AS onboardingCompletedAt_78 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 ,
t0 . nAiEventsAttended AS nAiEventsAttended_81 ,
t0 . nAiEventsApplied AS nAiEventsApplied_82 ,
t0 . nPaidAttended AS nPaidAttended_83 ,
t0 . nPaidApplied AS nPaidApplied_84 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 ,
t0 . nBbqApplied AS nBbqApplied_91 ,
t0 . nAiFridayApplied AS nAiFridayApplied_92 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_93 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_94 ,
t0 . aiSs24Applied AS aiSs24Applied_95 ,
t0 . aiSs24Booked AS aiSs24Booked_96 ,
t0 . interestedIn AS interestedIn_97 ,
t0 . interests AS interests_98 ,
t0 . mentorMetadata AS mentorMetadata_99 ,
t0 . eventParticipations AS eventParticipations_100 ,
t0 . kiKompetenz AS kiKompetenz_101 ,
t0 . mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = '80825' ;
Copy
21
0.45 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . score AS score_2 ,
t0 . completenessScore AS completenessScore_3 ,
t0 . status AS status_4 ,
t0 . location AS location_5 ,
t0 . salutation AS salutation_6 ,
t0 . title AS title_7 ,
t0 . jobTitle AS jobTitle_8 ,
t0 . firstName AS firstName_9 ,
t0 . lastName AS lastName_10 ,
t0 . name AS name_11 ,
t0 . sortName AS sortName_12 ,
t0 . email AS email_13 ,
t0 . secondaryEmail AS secondaryEmail_14 ,
t0 . phone AS phone_15 ,
t0 . hasCommunityMembership AS hasCommunityMembership_16 ,
t0 . utm_source AS utm_source_17 ,
t0 . utm_medium AS utm_medium_18 ,
t0 . utm_campaign AS utm_campaign_19 ,
t0 . utm_term AS utm_term_20 ,
t0 . utm_content AS utm_content_21 ,
t0 . birthday AS birthday_22 ,
t0 . addressFieldOne AS addressFieldOne_23 ,
t0 . addressFieldTwo AS addressFieldTwo_24 ,
t0 . addressCountryCode AS addressCountryCode_25 ,
t0 . addressPostalCode AS addressPostalCode_26 ,
t0 . addressCity AS addressCity_27 ,
t0 . teamId AS teamId_28 ,
t0 . teamName AS teamName_29 ,
t0 . company AS company_30 ,
t0 . history AS history_31 ,
t0 . tags AS tags_32 ,
t0 . annotation AS annotation_33 ,
t0 . mentorBuckets AS mentorBuckets_34 ,
t0 . areasOfExpertise AS areasOfExpertise_35 ,
t0 . mentor_firma AS mentor_firma_36 ,
t0 . mentor_firma_url AS mentor_firma_url_37 ,
t0 . mentor_locations AS mentor_locations_38 ,
t0 . mentor_profile AS mentor_profile_39 ,
t0 . mentor_note AS mentor_note_40 ,
t0 . mentor_admin_rating AS mentor_admin_rating_41 ,
t0 . active AS active_42 ,
t0 . tiefgarage AS tiefgarage_43 ,
t0 . transponder AS transponder_44 ,
t0 . isTransponderAllowed AS isTransponderAllowed_45 ,
t0 . imageLink AS imageLink_46 ,
t0 . homepage AS homepage_47 ,
t0 . xing AS xing_48 ,
t0 . pipedriveId AS pipedriveId_49 ,
t0 . linkedin AS linkedin_50 ,
t0 . facebook AS facebook_51 ,
t0 . instagram AS instagram_52 ,
t0 . tiktok AS tiktok_53 ,
t0 . threads AS threads_54 ,
t0 . youtube AS youtube_55 ,
t0 . twitter AS twitter_56 ,
t0 . github AS github_57 ,
t0 . reachableLocation AS reachableLocation_58 ,
t0 . skills AS skills_59 ,
t0 . description AS description_60 ,
t0 . isVisibleInNetworking AS isVisibleInNetworking_61 ,
t0 . gender AS gender_62 ,
t0 . currentFocus AS currentFocus_63 ,
t0 . networkingConsentAt AS networkingConsentAt_64 ,
t0 . networkingConsentVersion AS networkingConsentVersion_65 ,
t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 ,
t0 . touchpoints AS touchpoints_67 ,
t0 . isAddressComplete AS isAddressComplete_68 ,
t0 . hasMailchimp AS hasMailchimp_69 ,
t0 . hasKiNewsletter AS hasKiNewsletter_70 ,
t0 . hubspotSyncPending AS hubspotSyncPending_71 ,
t0 . enterDate AS enterDate_72 ,
t0 . exitDate AS exitDate_73 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_74 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_75 ,
t0 . lastModified AS lastModified_76 ,
t0 . lastChangeUser AS lastChangeUser_77 ,
t0 . onboardingCompletedAt AS onboardingCompletedAt_78 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 ,
t0 . nAiEventsAttended AS nAiEventsAttended_81 ,
t0 . nAiEventsApplied AS nAiEventsApplied_82 ,
t0 . nPaidAttended AS nPaidAttended_83 ,
t0 . nPaidApplied AS nPaidApplied_84 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 ,
t0 . nBbqApplied AS nBbqApplied_91 ,
t0 . nAiFridayApplied AS nAiFridayApplied_92 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_93 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_94 ,
t0 . aiSs24Applied AS aiSs24Applied_95 ,
t0 . aiSs24Booked AS aiSs24Booked_96 ,
t0 . interestedIn AS interestedIn_97 ,
t0 . interests AS interests_98 ,
t0 . mentorMetadata AS mentorMetadata_99 ,
t0 . eventParticipations AS eventParticipations_100 ,
t0 . kiKompetenz AS kiKompetenz_101 ,
t0 . mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = '92289' ;
Copy
22
0.44 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . score AS score_2 ,
t0 . completenessScore AS completenessScore_3 ,
t0 . status AS status_4 ,
t0 . location AS location_5 ,
t0 . salutation AS salutation_6 ,
t0 . title AS title_7 ,
t0 . jobTitle AS jobTitle_8 ,
t0 . firstName AS firstName_9 ,
t0 . lastName AS lastName_10 ,
t0 . name AS name_11 ,
t0 . sortName AS sortName_12 ,
t0 . email AS email_13 ,
t0 . secondaryEmail AS secondaryEmail_14 ,
t0 . phone AS phone_15 ,
t0 . hasCommunityMembership AS hasCommunityMembership_16 ,
t0 . utm_source AS utm_source_17 ,
t0 . utm_medium AS utm_medium_18 ,
t0 . utm_campaign AS utm_campaign_19 ,
t0 . utm_term AS utm_term_20 ,
t0 . utm_content AS utm_content_21 ,
t0 . birthday AS birthday_22 ,
t0 . addressFieldOne AS addressFieldOne_23 ,
t0 . addressFieldTwo AS addressFieldTwo_24 ,
t0 . addressCountryCode AS addressCountryCode_25 ,
t0 . addressPostalCode AS addressPostalCode_26 ,
t0 . addressCity AS addressCity_27 ,
t0 . teamId AS teamId_28 ,
t0 . teamName AS teamName_29 ,
t0 . company AS company_30 ,
t0 . history AS history_31 ,
t0 . tags AS tags_32 ,
t0 . annotation AS annotation_33 ,
t0 . mentorBuckets AS mentorBuckets_34 ,
t0 . areasOfExpertise AS areasOfExpertise_35 ,
t0 . mentor_firma AS mentor_firma_36 ,
t0 . mentor_firma_url AS mentor_firma_url_37 ,
t0 . mentor_locations AS mentor_locations_38 ,
t0 . mentor_profile AS mentor_profile_39 ,
t0 . mentor_note AS mentor_note_40 ,
t0 . mentor_admin_rating AS mentor_admin_rating_41 ,
t0 . active AS active_42 ,
t0 . tiefgarage AS tiefgarage_43 ,
t0 . transponder AS transponder_44 ,
t0 . isTransponderAllowed AS isTransponderAllowed_45 ,
t0 . imageLink AS imageLink_46 ,
t0 . homepage AS homepage_47 ,
t0 . xing AS xing_48 ,
t0 . pipedriveId AS pipedriveId_49 ,
t0 . linkedin AS linkedin_50 ,
t0 . facebook AS facebook_51 ,
t0 . instagram AS instagram_52 ,
t0 . tiktok AS tiktok_53 ,
t0 . threads AS threads_54 ,
t0 . youtube AS youtube_55 ,
t0 . twitter AS twitter_56 ,
t0 . github AS github_57 ,
t0 . reachableLocation AS reachableLocation_58 ,
t0 . skills AS skills_59 ,
t0 . description AS description_60 ,
t0 . isVisibleInNetworking AS isVisibleInNetworking_61 ,
t0 . gender AS gender_62 ,
t0 . currentFocus AS currentFocus_63 ,
t0 . networkingConsentAt AS networkingConsentAt_64 ,
t0 . networkingConsentVersion AS networkingConsentVersion_65 ,
t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 ,
t0 . touchpoints AS touchpoints_67 ,
t0 . isAddressComplete AS isAddressComplete_68 ,
t0 . hasMailchimp AS hasMailchimp_69 ,
t0 . hasKiNewsletter AS hasKiNewsletter_70 ,
t0 . hubspotSyncPending AS hubspotSyncPending_71 ,
t0 . enterDate AS enterDate_72 ,
t0 . exitDate AS exitDate_73 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_74 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_75 ,
t0 . lastModified AS lastModified_76 ,
t0 . lastChangeUser AS lastChangeUser_77 ,
t0 . onboardingCompletedAt AS onboardingCompletedAt_78 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 ,
t0 . nAiEventsAttended AS nAiEventsAttended_81 ,
t0 . nAiEventsApplied AS nAiEventsApplied_82 ,
t0 . nPaidAttended AS nPaidAttended_83 ,
t0 . nPaidApplied AS nPaidApplied_84 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 ,
t0 . nBbqApplied AS nBbqApplied_91 ,
t0 . nAiFridayApplied AS nAiFridayApplied_92 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_93 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_94 ,
t0 . aiSs24Applied AS aiSs24Applied_95 ,
t0 . aiSs24Booked AS aiSs24Booked_96 ,
t0 . interestedIn AS interestedIn_97 ,
t0 . interests AS interests_98 ,
t0 . mentorMetadata AS mentorMetadata_99 ,
t0 . eventParticipations AS eventParticipations_100 ,
t0 . kiKompetenz AS kiKompetenz_101 ,
t0 . mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = '92400' ;
Copy
23
0.42 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . score AS score_2 ,
t0 . completenessScore AS completenessScore_3 ,
t0 . status AS status_4 ,
t0 . location AS location_5 ,
t0 . salutation AS salutation_6 ,
t0 . title AS title_7 ,
t0 . jobTitle AS jobTitle_8 ,
t0 . firstName AS firstName_9 ,
t0 . lastName AS lastName_10 ,
t0 . name AS name_11 ,
t0 . sortName AS sortName_12 ,
t0 . email AS email_13 ,
t0 . secondaryEmail AS secondaryEmail_14 ,
t0 . phone AS phone_15 ,
t0 . hasCommunityMembership AS hasCommunityMembership_16 ,
t0 . utm_source AS utm_source_17 ,
t0 . utm_medium AS utm_medium_18 ,
t0 . utm_campaign AS utm_campaign_19 ,
t0 . utm_term AS utm_term_20 ,
t0 . utm_content AS utm_content_21 ,
t0 . birthday AS birthday_22 ,
t0 . addressFieldOne AS addressFieldOne_23 ,
t0 . addressFieldTwo AS addressFieldTwo_24 ,
t0 . addressCountryCode AS addressCountryCode_25 ,
t0 . addressPostalCode AS addressPostalCode_26 ,
t0 . addressCity AS addressCity_27 ,
t0 . teamId AS teamId_28 ,
t0 . teamName AS teamName_29 ,
t0 . company AS company_30 ,
t0 . history AS history_31 ,
t0 . tags AS tags_32 ,
t0 . annotation AS annotation_33 ,
t0 . mentorBuckets AS mentorBuckets_34 ,
t0 . areasOfExpertise AS areasOfExpertise_35 ,
t0 . mentor_firma AS mentor_firma_36 ,
t0 . mentor_firma_url AS mentor_firma_url_37 ,
t0 . mentor_locations AS mentor_locations_38 ,
t0 . mentor_profile AS mentor_profile_39 ,
t0 . mentor_note AS mentor_note_40 ,
t0 . mentor_admin_rating AS mentor_admin_rating_41 ,
t0 . active AS active_42 ,
t0 . tiefgarage AS tiefgarage_43 ,
t0 . transponder AS transponder_44 ,
t0 . isTransponderAllowed AS isTransponderAllowed_45 ,
t0 . imageLink AS imageLink_46 ,
t0 . homepage AS homepage_47 ,
t0 . xing AS xing_48 ,
t0 . pipedriveId AS pipedriveId_49 ,
t0 . linkedin AS linkedin_50 ,
t0 . facebook AS facebook_51 ,
t0 . instagram AS instagram_52 ,
t0 . tiktok AS tiktok_53 ,
t0 . threads AS threads_54 ,
t0 . youtube AS youtube_55 ,
t0 . twitter AS twitter_56 ,
t0 . github AS github_57 ,
t0 . reachableLocation AS reachableLocation_58 ,
t0 . skills AS skills_59 ,
t0 . description AS description_60 ,
t0 . isVisibleInNetworking AS isVisibleInNetworking_61 ,
t0 . gender AS gender_62 ,
t0 . currentFocus AS currentFocus_63 ,
t0 . networkingConsentAt AS networkingConsentAt_64 ,
t0 . networkingConsentVersion AS networkingConsentVersion_65 ,
t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 ,
t0 . touchpoints AS touchpoints_67 ,
t0 . isAddressComplete AS isAddressComplete_68 ,
t0 . hasMailchimp AS hasMailchimp_69 ,
t0 . hasKiNewsletter AS hasKiNewsletter_70 ,
t0 . hubspotSyncPending AS hubspotSyncPending_71 ,
t0 . enterDate AS enterDate_72 ,
t0 . exitDate AS exitDate_73 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_74 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_75 ,
t0 . lastModified AS lastModified_76 ,
t0 . lastChangeUser AS lastChangeUser_77 ,
t0 . onboardingCompletedAt AS onboardingCompletedAt_78 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 ,
t0 . nAiEventsAttended AS nAiEventsAttended_81 ,
t0 . nAiEventsApplied AS nAiEventsApplied_82 ,
t0 . nPaidAttended AS nPaidAttended_83 ,
t0 . nPaidApplied AS nPaidApplied_84 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 ,
t0 . nBbqApplied AS nBbqApplied_91 ,
t0 . nAiFridayApplied AS nAiFridayApplied_92 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_93 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_94 ,
t0 . aiSs24Applied AS aiSs24Applied_95 ,
t0 . aiSs24Booked AS aiSs24Booked_96 ,
t0 . interestedIn AS interestedIn_97 ,
t0 . interests AS interests_98 ,
t0 . mentorMetadata AS mentorMetadata_99 ,
t0 . eventParticipations AS eventParticipations_100 ,
t0 . kiKompetenz AS kiKompetenz_101 ,
t0 . mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = '91738' ;
Copy
24
0.46 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . score AS score_2 ,
t0 . completenessScore AS completenessScore_3 ,
t0 . status AS status_4 ,
t0 . location AS location_5 ,
t0 . salutation AS salutation_6 ,
t0 . title AS title_7 ,
t0 . jobTitle AS jobTitle_8 ,
t0 . firstName AS firstName_9 ,
t0 . lastName AS lastName_10 ,
t0 . name AS name_11 ,
t0 . sortName AS sortName_12 ,
t0 . email AS email_13 ,
t0 . secondaryEmail AS secondaryEmail_14 ,
t0 . phone AS phone_15 ,
t0 . hasCommunityMembership AS hasCommunityMembership_16 ,
t0 . utm_source AS utm_source_17 ,
t0 . utm_medium AS utm_medium_18 ,
t0 . utm_campaign AS utm_campaign_19 ,
t0 . utm_term AS utm_term_20 ,
t0 . utm_content AS utm_content_21 ,
t0 . birthday AS birthday_22 ,
t0 . addressFieldOne AS addressFieldOne_23 ,
t0 . addressFieldTwo AS addressFieldTwo_24 ,
t0 . addressCountryCode AS addressCountryCode_25 ,
t0 . addressPostalCode AS addressPostalCode_26 ,
t0 . addressCity AS addressCity_27 ,
t0 . teamId AS teamId_28 ,
t0 . teamName AS teamName_29 ,
t0 . company AS company_30 ,
t0 . history AS history_31 ,
t0 . tags AS tags_32 ,
t0 . annotation AS annotation_33 ,
t0 . mentorBuckets AS mentorBuckets_34 ,
t0 . areasOfExpertise AS areasOfExpertise_35 ,
t0 . mentor_firma AS mentor_firma_36 ,
t0 . mentor_firma_url AS mentor_firma_url_37 ,
t0 . mentor_locations AS mentor_locations_38 ,
t0 . mentor_profile AS mentor_profile_39 ,
t0 . mentor_note AS mentor_note_40 ,
t0 . mentor_admin_rating AS mentor_admin_rating_41 ,
t0 . active AS active_42 ,
t0 . tiefgarage AS tiefgarage_43 ,
t0 . transponder AS transponder_44 ,
t0 . isTransponderAllowed AS isTransponderAllowed_45 ,
t0 . imageLink AS imageLink_46 ,
t0 . homepage AS homepage_47 ,
t0 . xing AS xing_48 ,
t0 . pipedriveId AS pipedriveId_49 ,
t0 . linkedin AS linkedin_50 ,
t0 . facebook AS facebook_51 ,
t0 . instagram AS instagram_52 ,
t0 . tiktok AS tiktok_53 ,
t0 . threads AS threads_54 ,
t0 . youtube AS youtube_55 ,
t0 . twitter AS twitter_56 ,
t0 . github AS github_57 ,
t0 . reachableLocation AS reachableLocation_58 ,
t0 . skills AS skills_59 ,
t0 . description AS description_60 ,
t0 . isVisibleInNetworking AS isVisibleInNetworking_61 ,
t0 . gender AS gender_62 ,
t0 . currentFocus AS currentFocus_63 ,
t0 . networkingConsentAt AS networkingConsentAt_64 ,
t0 . networkingConsentVersion AS networkingConsentVersion_65 ,
t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 ,
t0 . touchpoints AS touchpoints_67 ,
t0 . isAddressComplete AS isAddressComplete_68 ,
t0 . hasMailchimp AS hasMailchimp_69 ,
t0 . hasKiNewsletter AS hasKiNewsletter_70 ,
t0 . hubspotSyncPending AS hubspotSyncPending_71 ,
t0 . enterDate AS enterDate_72 ,
t0 . exitDate AS exitDate_73 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_74 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_75 ,
t0 . lastModified AS lastModified_76 ,
t0 . lastChangeUser AS lastChangeUser_77 ,
t0 . onboardingCompletedAt AS onboardingCompletedAt_78 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 ,
t0 . nAiEventsAttended AS nAiEventsAttended_81 ,
t0 . nAiEventsApplied AS nAiEventsApplied_82 ,
t0 . nPaidAttended AS nPaidAttended_83 ,
t0 . nPaidApplied AS nPaidApplied_84 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 ,
t0 . nBbqApplied AS nBbqApplied_91 ,
t0 . nAiFridayApplied AS nAiFridayApplied_92 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_93 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_94 ,
t0 . aiSs24Applied AS aiSs24Applied_95 ,
t0 . aiSs24Booked AS aiSs24Booked_96 ,
t0 . interestedIn AS interestedIn_97 ,
t0 . interests AS interests_98 ,
t0 . mentorMetadata AS mentorMetadata_99 ,
t0 . eventParticipations AS eventParticipations_100 ,
t0 . kiKompetenz AS kiKompetenz_101 ,
t0 . mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = '92035' ;
Copy
25
0.42 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . score AS score_2 ,
t0 . completenessScore AS completenessScore_3 ,
t0 . status AS status_4 ,
t0 . location AS location_5 ,
t0 . salutation AS salutation_6 ,
t0 . title AS title_7 ,
t0 . jobTitle AS jobTitle_8 ,
t0 . firstName AS firstName_9 ,
t0 . lastName AS lastName_10 ,
t0 . name AS name_11 ,
t0 . sortName AS sortName_12 ,
t0 . email AS email_13 ,
t0 . secondaryEmail AS secondaryEmail_14 ,
t0 . phone AS phone_15 ,
t0 . hasCommunityMembership AS hasCommunityMembership_16 ,
t0 . utm_source AS utm_source_17 ,
t0 . utm_medium AS utm_medium_18 ,
t0 . utm_campaign AS utm_campaign_19 ,
t0 . utm_term AS utm_term_20 ,
t0 . utm_content AS utm_content_21 ,
t0 . birthday AS birthday_22 ,
t0 . addressFieldOne AS addressFieldOne_23 ,
t0 . addressFieldTwo AS addressFieldTwo_24 ,
t0 . addressCountryCode AS addressCountryCode_25 ,
t0 . addressPostalCode AS addressPostalCode_26 ,
t0 . addressCity AS addressCity_27 ,
t0 . teamId AS teamId_28 ,
t0 . teamName AS teamName_29 ,
t0 . company AS company_30 ,
t0 . history AS history_31 ,
t0 . tags AS tags_32 ,
t0 . annotation AS annotation_33 ,
t0 . mentorBuckets AS mentorBuckets_34 ,
t0 . areasOfExpertise AS areasOfExpertise_35 ,
t0 . mentor_firma AS mentor_firma_36 ,
t0 . mentor_firma_url AS mentor_firma_url_37 ,
t0 . mentor_locations AS mentor_locations_38 ,
t0 . mentor_profile AS mentor_profile_39 ,
t0 . mentor_note AS mentor_note_40 ,
t0 . mentor_admin_rating AS mentor_admin_rating_41 ,
t0 . active AS active_42 ,
t0 . tiefgarage AS tiefgarage_43 ,
t0 . transponder AS transponder_44 ,
t0 . isTransponderAllowed AS isTransponderAllowed_45 ,
t0 . imageLink AS imageLink_46 ,
t0 . homepage AS homepage_47 ,
t0 . xing AS xing_48 ,
t0 . pipedriveId AS pipedriveId_49 ,
t0 . linkedin AS linkedin_50 ,
t0 . facebook AS facebook_51 ,
t0 . instagram AS instagram_52 ,
t0 . tiktok AS tiktok_53 ,
t0 . threads AS threads_54 ,
t0 . youtube AS youtube_55 ,
t0 . twitter AS twitter_56 ,
t0 . github AS github_57 ,
t0 . reachableLocation AS reachableLocation_58 ,
t0 . skills AS skills_59 ,
t0 . description AS description_60 ,
t0 . isVisibleInNetworking AS isVisibleInNetworking_61 ,
t0 . gender AS gender_62 ,
t0 . currentFocus AS currentFocus_63 ,
t0 . networkingConsentAt AS networkingConsentAt_64 ,
t0 . networkingConsentVersion AS networkingConsentVersion_65 ,
t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 ,
t0 . touchpoints AS touchpoints_67 ,
t0 . isAddressComplete AS isAddressComplete_68 ,
t0 . hasMailchimp AS hasMailchimp_69 ,
t0 . hasKiNewsletter AS hasKiNewsletter_70 ,
t0 . hubspotSyncPending AS hubspotSyncPending_71 ,
t0 . enterDate AS enterDate_72 ,
t0 . exitDate AS exitDate_73 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_74 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_75 ,
t0 . lastModified AS lastModified_76 ,
t0 . lastChangeUser AS lastChangeUser_77 ,
t0 . onboardingCompletedAt AS onboardingCompletedAt_78 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 ,
t0 . nAiEventsAttended AS nAiEventsAttended_81 ,
t0 . nAiEventsApplied AS nAiEventsApplied_82 ,
t0 . nPaidAttended AS nPaidAttended_83 ,
t0 . nPaidApplied AS nPaidApplied_84 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 ,
t0 . nBbqApplied AS nBbqApplied_91 ,
t0 . nAiFridayApplied AS nAiFridayApplied_92 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_93 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_94 ,
t0 . aiSs24Applied AS aiSs24Applied_95 ,
t0 . aiSs24Booked AS aiSs24Booked_96 ,
t0 . interestedIn AS interestedIn_97 ,
t0 . interests AS interests_98 ,
t0 . mentorMetadata AS mentorMetadata_99 ,
t0 . eventParticipations AS eventParticipations_100 ,
t0 . kiKompetenz AS kiKompetenz_101 ,
t0 . mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = '92602' ;
Copy
26
0.42 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . score AS score_2 ,
t0 . completenessScore AS completenessScore_3 ,
t0 . status AS status_4 ,
t0 . location AS location_5 ,
t0 . salutation AS salutation_6 ,
t0 . title AS title_7 ,
t0 . jobTitle AS jobTitle_8 ,
t0 . firstName AS firstName_9 ,
t0 . lastName AS lastName_10 ,
t0 . name AS name_11 ,
t0 . sortName AS sortName_12 ,
t0 . email AS email_13 ,
t0 . secondaryEmail AS secondaryEmail_14 ,
t0 . phone AS phone_15 ,
t0 . hasCommunityMembership AS hasCommunityMembership_16 ,
t0 . utm_source AS utm_source_17 ,
t0 . utm_medium AS utm_medium_18 ,
t0 . utm_campaign AS utm_campaign_19 ,
t0 . utm_term AS utm_term_20 ,
t0 . utm_content AS utm_content_21 ,
t0 . birthday AS birthday_22 ,
t0 . addressFieldOne AS addressFieldOne_23 ,
t0 . addressFieldTwo AS addressFieldTwo_24 ,
t0 . addressCountryCode AS addressCountryCode_25 ,
t0 . addressPostalCode AS addressPostalCode_26 ,
t0 . addressCity AS addressCity_27 ,
t0 . teamId AS teamId_28 ,
t0 . teamName AS teamName_29 ,
t0 . company AS company_30 ,
t0 . history AS history_31 ,
t0 . tags AS tags_32 ,
t0 . annotation AS annotation_33 ,
t0 . mentorBuckets AS mentorBuckets_34 ,
t0 . areasOfExpertise AS areasOfExpertise_35 ,
t0 . mentor_firma AS mentor_firma_36 ,
t0 . mentor_firma_url AS mentor_firma_url_37 ,
t0 . mentor_locations AS mentor_locations_38 ,
t0 . mentor_profile AS mentor_profile_39 ,
t0 . mentor_note AS mentor_note_40 ,
t0 . mentor_admin_rating AS mentor_admin_rating_41 ,
t0 . active AS active_42 ,
t0 . tiefgarage AS tiefgarage_43 ,
t0 . transponder AS transponder_44 ,
t0 . isTransponderAllowed AS isTransponderAllowed_45 ,
t0 . imageLink AS imageLink_46 ,
t0 . homepage AS homepage_47 ,
t0 . xing AS xing_48 ,
t0 . pipedriveId AS pipedriveId_49 ,
t0 . linkedin AS linkedin_50 ,
t0 . facebook AS facebook_51 ,
t0 . instagram AS instagram_52 ,
t0 . tiktok AS tiktok_53 ,
t0 . threads AS threads_54 ,
t0 . youtube AS youtube_55 ,
t0 . twitter AS twitter_56 ,
t0 . github AS github_57 ,
t0 . reachableLocation AS reachableLocation_58 ,
t0 . skills AS skills_59 ,
t0 . description AS description_60 ,
t0 . isVisibleInNetworking AS isVisibleInNetworking_61 ,
t0 . gender AS gender_62 ,
t0 . currentFocus AS currentFocus_63 ,
t0 . networkingConsentAt AS networkingConsentAt_64 ,
t0 . networkingConsentVersion AS networkingConsentVersion_65 ,
t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 ,
t0 . touchpoints AS touchpoints_67 ,
t0 . isAddressComplete AS isAddressComplete_68 ,
t0 . hasMailchimp AS hasMailchimp_69 ,
t0 . hasKiNewsletter AS hasKiNewsletter_70 ,
t0 . hubspotSyncPending AS hubspotSyncPending_71 ,
t0 . enterDate AS enterDate_72 ,
t0 . exitDate AS exitDate_73 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_74 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_75 ,
t0 . lastModified AS lastModified_76 ,
t0 . lastChangeUser AS lastChangeUser_77 ,
t0 . onboardingCompletedAt AS onboardingCompletedAt_78 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 ,
t0 . nAiEventsAttended AS nAiEventsAttended_81 ,
t0 . nAiEventsApplied AS nAiEventsApplied_82 ,
t0 . nPaidAttended AS nPaidAttended_83 ,
t0 . nPaidApplied AS nPaidApplied_84 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 ,
t0 . nBbqApplied AS nBbqApplied_91 ,
t0 . nAiFridayApplied AS nAiFridayApplied_92 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_93 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_94 ,
t0 . aiSs24Applied AS aiSs24Applied_95 ,
t0 . aiSs24Booked AS aiSs24Booked_96 ,
t0 . interestedIn AS interestedIn_97 ,
t0 . interests AS interests_98 ,
t0 . mentorMetadata AS mentorMetadata_99 ,
t0 . eventParticipations AS eventParticipations_100 ,
t0 . kiKompetenz AS kiKompetenz_101 ,
t0 . mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = '91699' ;
Copy
27
0.37 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 :
[
6737
"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 (6737 ) AND s0_ . publicVisible = 1 AND s0_ . status = 'confirmed' ORDER BY s0_ . position ASC , s0_ . id ASC ;
Copy
28
0.33 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 :
[
6737
"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 (6737 ) AND s0_ . status = 'requested' GROUP BY s0_ . eventId , s0_ . eventDateId ;
Copy
29
0.27 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 ;
Copy
30
0.65 ms
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . score AS score_2 ,
t0 . completenessScore AS completenessScore_3 ,
t0 . status AS status_4 ,
t0 . location AS location_5 ,
t0 . salutation AS salutation_6 ,
t0 . title AS title_7 ,
t0 . jobTitle AS jobTitle_8 ,
t0 . firstName AS firstName_9 ,
t0 . lastName AS lastName_10 ,
t0 . name AS name_11 ,
t0 . sortName AS sortName_12 ,
t0 . email AS email_13 ,
t0 . secondaryEmail AS secondaryEmail_14 ,
t0 . phone AS phone_15 ,
t0 . hasCommunityMembership AS hasCommunityMembership_16 ,
t0 . utm_source AS utm_source_17 ,
t0 . utm_medium AS utm_medium_18 ,
t0 . utm_campaign AS utm_campaign_19 ,
t0 . utm_term AS utm_term_20 ,
t0 . utm_content AS utm_content_21 ,
t0 . birthday AS birthday_22 ,
t0 . addressFieldOne AS addressFieldOne_23 ,
t0 . addressFieldTwo AS addressFieldTwo_24 ,
t0 . addressCountryCode AS addressCountryCode_25 ,
t0 . addressPostalCode AS addressPostalCode_26 ,
t0 . addressCity AS addressCity_27 ,
t0 . teamId AS teamId_28 ,
t0 . teamName AS teamName_29 ,
t0 . company AS company_30 ,
t0 . history AS history_31 ,
t0 . tags AS tags_32 ,
t0 . annotation AS annotation_33 ,
t0 . mentorBuckets AS mentorBuckets_34 ,
t0 . areasOfExpertise AS areasOfExpertise_35 ,
t0 . mentor_firma AS mentor_firma_36 ,
t0 . mentor_firma_url AS mentor_firma_url_37 ,
t0 . mentor_locations AS mentor_locations_38 ,
t0 . mentor_profile AS mentor_profile_39 ,
t0 . mentor_note AS mentor_note_40 ,
t0 . mentor_admin_rating AS mentor_admin_rating_41 ,
t0 . active AS active_42 ,
t0 . tiefgarage AS tiefgarage_43 ,
t0 . transponder AS transponder_44 ,
t0 . isTransponderAllowed AS isTransponderAllowed_45 ,
t0 . imageLink AS imageLink_46 ,
t0 . homepage AS homepage_47 ,
t0 . xing AS xing_48 ,
t0 . pipedriveId AS pipedriveId_49 ,
t0 . linkedin AS linkedin_50 ,
t0 . facebook AS facebook_51 ,
t0 . instagram AS instagram_52 ,
t0 . tiktok AS tiktok_53 ,
t0 . threads AS threads_54 ,
t0 . youtube AS youtube_55 ,
t0 . twitter AS twitter_56 ,
t0 . github AS github_57 ,
t0 . reachableLocation AS reachableLocation_58 ,
t0 . skills AS skills_59 ,
t0 . description AS description_60 ,
t0 . isVisibleInNetworking AS isVisibleInNetworking_61 ,
t0 . gender AS gender_62 ,
t0 . currentFocus AS currentFocus_63 ,
t0 . networkingConsentAt AS networkingConsentAt_64 ,
t0 . networkingConsentVersion AS networkingConsentVersion_65 ,
t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 ,
t0 . touchpoints AS touchpoints_67 ,
t0 . isAddressComplete AS isAddressComplete_68 ,
t0 . hasMailchimp AS hasMailchimp_69 ,
t0 . hasKiNewsletter AS hasKiNewsletter_70 ,
t0 . hubspotSyncPending AS hubspotSyncPending_71 ,
t0 . enterDate AS enterDate_72 ,
t0 . exitDate AS exitDate_73 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_74 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_75 ,
t0 . lastModified AS lastModified_76 ,
t0 . lastChangeUser AS lastChangeUser_77 ,
t0 . onboardingCompletedAt AS onboardingCompletedAt_78 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 ,
t0 . nAiEventsAttended AS nAiEventsAttended_81 ,
t0 . nAiEventsApplied AS nAiEventsApplied_82 ,
t0 . nPaidAttended AS nPaidAttended_83 ,
t0 . nPaidApplied AS nPaidApplied_84 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 ,
t0 . nBbqApplied AS nBbqApplied_91 ,
t0 . nAiFridayApplied AS nAiFridayApplied_92 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_93 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_94 ,
t0 . aiSs24Applied AS aiSs24Applied_95 ,
t0 . aiSs24Booked AS aiSs24Booked_96 ,
t0 . interestedIn AS interestedIn_97 ,
t0 . interests AS interests_98 ,
t0 . mentorMetadata AS mentorMetadata_99 ,
t0 . eventParticipations AS eventParticipations_100 ,
t0 . kiKompetenz AS kiKompetenz_101 ,
t0 . mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . score AS score_2 , t0 . completenessScore AS completenessScore_3 , t0 . status AS status_4 , t0 . location AS location_5 , t0 . salutation AS salutation_6 , t0 . title AS title_7 , t0 . jobTitle AS jobTitle_8 , t0 . firstName AS firstName_9 , t0 . lastName AS lastName_10 , t0 . name AS name_11 , t0 . sortName AS sortName_12 , t0 . email AS email_13 , t0 . secondaryEmail AS secondaryEmail_14 , t0 . phone AS phone_15 , t0 . hasCommunityMembership AS hasCommunityMembership_16 , t0 . utm_source AS utm_source_17 , t0 . utm_medium AS utm_medium_18 , t0 . utm_campaign AS utm_campaign_19 , t0 . utm_term AS utm_term_20 , t0 . utm_content AS utm_content_21 , t0 . birthday AS birthday_22 , t0 . addressFieldOne AS addressFieldOne_23 , t0 . addressFieldTwo AS addressFieldTwo_24 , t0 . addressCountryCode AS addressCountryCode_25 , t0 . addressPostalCode AS addressPostalCode_26 , t0 . addressCity AS addressCity_27 , t0 . teamId AS teamId_28 , t0 . teamName AS teamName_29 , t0 . company AS company_30 , t0 . history AS history_31 , t0 . tags AS tags_32 , t0 . annotation AS annotation_33 , t0 . mentorBuckets AS mentorBuckets_34 , t0 . areasOfExpertise AS areasOfExpertise_35 , t0 . mentor_firma AS mentor_firma_36 , t0 . mentor_firma_url AS mentor_firma_url_37 , t0 . mentor_locations AS mentor_locations_38 , t0 . mentor_profile AS mentor_profile_39 , t0 . mentor_note AS mentor_note_40 , t0 . mentor_admin_rating AS mentor_admin_rating_41 , t0 . active AS active_42 , t0 . tiefgarage AS tiefgarage_43 , t0 . transponder AS transponder_44 , t0 . isTransponderAllowed AS isTransponderAllowed_45 , t0 . imageLink AS imageLink_46 , t0 . homepage AS homepage_47 , t0 . xing AS xing_48 , t0 . pipedriveId AS pipedriveId_49 , t0 . linkedin AS linkedin_50 , t0 . facebook AS facebook_51 , t0 . instagram AS instagram_52 , t0 . tiktok AS tiktok_53 , t0 . threads AS threads_54 , t0 . youtube AS youtube_55 , t0 . twitter AS twitter_56 , t0 . github AS github_57 , t0 . reachableLocation AS reachableLocation_58 , t0 . skills AS skills_59 , t0 . description AS description_60 , t0 . isVisibleInNetworking AS isVisibleInNetworking_61 , t0 . gender AS gender_62 , t0 . currentFocus AS currentFocus_63 , t0 . networkingConsentAt AS networkingConsentAt_64 , t0 . networkingConsentVersion AS networkingConsentVersion_65 , t0 . networkingConsentRevokedAt AS networkingConsentRevokedAt_66 , t0 . touchpoints AS touchpoints_67 , t0 . isAddressComplete AS isAddressComplete_68 , t0 . hasMailchimp AS hasMailchimp_69 , t0 . hasKiNewsletter AS hasKiNewsletter_70 , t0 . hubspotSyncPending AS hubspotSyncPending_71 , t0 . enterDate AS enterDate_72 , t0 . exitDate AS exitDate_73 , t0 . physicalMembershipStarted AS physicalMembershipStarted_74 , t0 . physicalMembershipEnded AS physicalMembershipEnded_75 , t0 . lastModified AS lastModified_76 , t0 . lastChangeUser AS lastChangeUser_77 , t0 . onboardingCompletedAt AS onboardingCompletedAt_78 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_79 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_80 , t0 . nAiEventsAttended AS nAiEventsAttended_81 , t0 . nAiEventsApplied AS nAiEventsApplied_82 , t0 . nPaidAttended AS nPaidAttended_83 , t0 . nPaidApplied AS nPaidApplied_84 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_85 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_86 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_87 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_88 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_89 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_90 , t0 . nBbqApplied AS nBbqApplied_91 , t0 . nAiFridayApplied AS nAiFridayApplied_92 , t0 . nAiGatheringApplied AS nAiGatheringApplied_93 , t0 . nAiGatheringAttended AS nAiGatheringAttended_94 , t0 . aiSs24Applied AS aiSs24Applied_95 , t0 . aiSs24Booked AS aiSs24Booked_96 , t0 . interestedIn AS interestedIn_97 , t0 . interests AS interests_98 , t0 . mentorMetadata AS mentorMetadata_99 , t0 . eventParticipations AS eventParticipations_100 , t0 . kiKompetenz AS kiKompetenz_101 , t0 . mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0 . id = 80488 ;
Copy