1
1.43 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 . slug AS slug_6 , t0 . lang AS lang_7 , t0 . imagelink AS imagelink_8 , t0 . videolink AS videolink_9 , t0 . bgImagelink AS bgImagelink_10 , t0 . tagline AS tagline_11 , t0 . headerTextColor AS headerTextColor_12 , t0 . spResponsiblePerson AS spResponsiblePerson_13 , t0 . organization AS organization_14 , t0 . organizerName AS organizerName_15 , t0 . organizerEmail AS organizerEmail_16 , t0 . venueName AS venueName_17 , t0 . venueAddress AS venueAddress_18 , t0 . ticketing AS ticketing_19 , t0 . applicationUrl AS applicationUrl_20 , t0 . alert AS alert_21 , t0 . trainer AS trainer_22 , t0 . speakers AS speakers_23 , t0 . teaser AS teaser_24 , t0 . navbar AS navbar_25 , t0 . stripePriceId AS stripePriceId_26 , t0 . stripeProductId AS stripeProductId_27 , t0 . stripeAccount AS stripeAccount_28 , t0 . priceInEuroCent AS priceInEuroCent_29 , t0 . isTaxIncluded AS isTaxIncluded_30 , t0 . isFreeForKiCampus AS isFreeForKiCampus_31 , t0 . isFreeForCommunity AS isFreeForCommunity_32 , t0 . isSinglePage AS isSinglePage_33 , t0 . isFormalLanguage AS isFormalLanguage_34 , t0 . isMultiBatchEvent AS isMultiBatchEvent_35 , t0 . isFeatured AS isFeatured_36 , t0 . capacity AS capacity_37 , t0 . twigFile AS twigFile_38 , t0 . additionalCss AS additionalCss_39 , t0 . content AS content_40 , t0 . contentTwig AS contentTwig_41 , t0 . ctaContent AS ctaContent_42 , t0 . postCtaContent AS postCtaContent_43 , t0 . tags AS tags_44 , t0 . seriesTag AS seriesTag_45 , t0 . type AS type_46 , t0 . location AS location_47 , t0 . startDate AS startDate_48 , t0 . endDate AS endDate_49 , t0 . duration AS duration_50 , t0 . status AS status_51 , t0 . settings AS settings_52 , t0 . displayStartDate AS displayStartDate_53 , t0 . seoTitle AS seoTitle_54 , t0 . seoKeyword AS seoKeyword_55 , t0 . seoDescription AS seoDescription_56 , t0 . navbar_en AS navbar_en_57 , t0 . teaser_en AS teaser_en_58 , t0 . content_en AS content_en_59 , t0 . content_twig_en AS content_twig_en_60 , t0 . post_cta_content_en AS post_cta_content_en_61 , t0 . seo_title_en AS seo_title_en_62 , t0 . seo_description_en AS seo_description_en_63 , t0 . seo_keyword_en AS seo_keyword_en_64 , t0 . has_english_version AS has_english_version_65 , t0 . additional_js AS additional_js_66 , t0 . metaPixelId AS metaPixelId_67 , t0 . createDate AS createDate_68 , t0 . lastChangeDate AS lastChangeDate_69 , t0 . lastChangeUser AS lastChangeUser_70 , t0 . publicId AS publicId_71 , t0 . isExternalSubmission AS isExternalSubmission_72 , t0 . createdBy AS createdBy_73 , t0 . lastModified AS lastModified_74 , t0 . createdAt AS createdAt_75 , t0 . orgaNote AS orgaNote_76 , t0 . history AS history_77 , t0 . todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"ai-coding-hackathon-spring-2026 "
]
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 . slug AS slug_6 ,
t0 . lang AS lang_7 ,
t0 . imagelink AS imagelink_8 ,
t0 . videolink AS videolink_9 ,
t0 . bgImagelink AS bgImagelink_10 ,
t0 . tagline AS tagline_11 ,
t0 . headerTextColor AS headerTextColor_12 ,
t0 . spResponsiblePerson AS spResponsiblePerson_13 ,
t0 . organization AS organization_14 ,
t0 . organizerName AS organizerName_15 ,
t0 . organizerEmail AS organizerEmail_16 ,
t0 . venueName AS venueName_17 ,
t0 . venueAddress AS venueAddress_18 ,
t0 . ticketing AS ticketing_19 ,
t0 . applicationUrl AS applicationUrl_20 ,
t0 . alert AS alert_21 ,
t0 . trainer AS trainer_22 ,
t0 . speakers AS speakers_23 ,
t0 . teaser AS teaser_24 ,
t0 . navbar AS navbar_25 ,
t0 . stripePriceId AS stripePriceId_26 ,
t0 . stripeProductId AS stripeProductId_27 ,
t0 . stripeAccount AS stripeAccount_28 ,
t0 . priceInEuroCent AS priceInEuroCent_29 ,
t0 . isTaxIncluded AS isTaxIncluded_30 ,
t0 . isFreeForKiCampus AS isFreeForKiCampus_31 ,
t0 . isFreeForCommunity AS isFreeForCommunity_32 ,
t0 . isSinglePage AS isSinglePage_33 ,
t0 . isFormalLanguage AS isFormalLanguage_34 ,
t0 . isMultiBatchEvent AS isMultiBatchEvent_35 ,
t0 . isFeatured AS isFeatured_36 ,
t0 . capacity AS capacity_37 ,
t0 . twigFile AS twigFile_38 ,
t0 . additionalCss AS additionalCss_39 ,
t0 . content AS content_40 ,
t0 . contentTwig AS contentTwig_41 ,
t0 . ctaContent AS ctaContent_42 ,
t0 . postCtaContent AS postCtaContent_43 ,
t0 . tags AS tags_44 ,
t0 . seriesTag AS seriesTag_45 ,
t0 . type AS type_46 ,
t0 . location AS location_47 ,
t0 . startDate AS startDate_48 ,
t0 . endDate AS endDate_49 ,
t0 . duration AS duration_50 ,
t0 . status AS status_51 ,
t0 . settings AS settings_52 ,
t0 . displayStartDate AS displayStartDate_53 ,
t0 . seoTitle AS seoTitle_54 ,
t0 . seoKeyword AS seoKeyword_55 ,
t0 . seoDescription AS seoDescription_56 ,
t0 . navbar_en AS navbar_en_57 ,
t0 . teaser_en AS teaser_en_58 ,
t0 . content_en AS content_en_59 ,
t0 . content_twig_en AS content_twig_en_60 ,
t0 . post_cta_content_en AS post_cta_content_en_61 ,
t0 . seo_title_en AS seo_title_en_62 ,
t0 . seo_description_en AS seo_description_en_63 ,
t0 . seo_keyword_en AS seo_keyword_en_64 ,
t0 . has_english_version AS has_english_version_65 ,
t0 . additional_js AS additional_js_66 ,
t0 . metaPixelId AS metaPixelId_67 ,
t0 . createDate AS createDate_68 ,
t0 . lastChangeDate AS lastChangeDate_69 ,
t0 . lastChangeUser AS lastChangeUser_70 ,
t0 . publicId AS publicId_71 ,
t0 . isExternalSubmission AS isExternalSubmission_72 ,
t0 . createdBy AS createdBy_73 ,
t0 . lastModified AS lastModified_74 ,
t0 . createdAt AS createdAt_75 ,
t0 . orgaNote AS orgaNote_76 ,
t0 . history AS history_77 ,
t0 . todoHistory AS todoHistory_78
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 . slug AS slug_6 , t0 . lang AS lang_7 , t0 . imagelink AS imagelink_8 , t0 . videolink AS videolink_9 , t0 . bgImagelink AS bgImagelink_10 , t0 . tagline AS tagline_11 , t0 . headerTextColor AS headerTextColor_12 , t0 . spResponsiblePerson AS spResponsiblePerson_13 , t0 . organization AS organization_14 , t0 . organizerName AS organizerName_15 , t0 . organizerEmail AS organizerEmail_16 , t0 . venueName AS venueName_17 , t0 . venueAddress AS venueAddress_18 , t0 . ticketing AS ticketing_19 , t0 . applicationUrl AS applicationUrl_20 , t0 . alert AS alert_21 , t0 . trainer AS trainer_22 , t0 . speakers AS speakers_23 , t0 . teaser AS teaser_24 , t0 . navbar AS navbar_25 , t0 . stripePriceId AS stripePriceId_26 , t0 . stripeProductId AS stripeProductId_27 , t0 . stripeAccount AS stripeAccount_28 , t0 . priceInEuroCent AS priceInEuroCent_29 , t0 . isTaxIncluded AS isTaxIncluded_30 , t0 . isFreeForKiCampus AS isFreeForKiCampus_31 , t0 . isFreeForCommunity AS isFreeForCommunity_32 , t0 . isSinglePage AS isSinglePage_33 , t0 . isFormalLanguage AS isFormalLanguage_34 , t0 . isMultiBatchEvent AS isMultiBatchEvent_35 , t0 . isFeatured AS isFeatured_36 , t0 . capacity AS capacity_37 , t0 . twigFile AS twigFile_38 , t0 . additionalCss AS additionalCss_39 , t0 . content AS content_40 , t0 . contentTwig AS contentTwig_41 , t0 . ctaContent AS ctaContent_42 , t0 . postCtaContent AS postCtaContent_43 , t0 . tags AS tags_44 , t0 . seriesTag AS seriesTag_45 , t0 . type AS type_46 , t0 . location AS location_47 , t0 . startDate AS startDate_48 , t0 . endDate AS endDate_49 , t0 . duration AS duration_50 , t0 . status AS status_51 , t0 . settings AS settings_52 , t0 . displayStartDate AS displayStartDate_53 , t0 . seoTitle AS seoTitle_54 , t0 . seoKeyword AS seoKeyword_55 , t0 . seoDescription AS seoDescription_56 , t0 . navbar_en AS navbar_en_57 , t0 . teaser_en AS teaser_en_58 , t0 . content_en AS content_en_59 , t0 . content_twig_en AS content_twig_en_60 , t0 . post_cta_content_en AS post_cta_content_en_61 , t0 . seo_title_en AS seo_title_en_62 , t0 . seo_description_en AS seo_description_en_63 , t0 . seo_keyword_en AS seo_keyword_en_64 , t0 . has_english_version AS has_english_version_65 , t0 . additional_js AS additional_js_66 , t0 . metaPixelId AS metaPixelId_67 , t0 . createDate AS createDate_68 , t0 . lastChangeDate AS lastChangeDate_69 , t0 . lastChangeUser AS lastChangeUser_70 , t0 . publicId AS publicId_71 , t0 . isExternalSubmission AS isExternalSubmission_72 , t0 . createdBy AS createdBy_73 , t0 . lastModified AS lastModified_74 , t0 . createdAt AS createdAt_75 , t0 . orgaNote AS orgaNote_76 , t0 . history AS history_77 , t0 . todoHistory AS todoHistory_78 FROM sp_event_events t0 WHERE t0 . slug = 'ai-coding-hackathon-spring-2026' LIMIT 1 ;
Copy
2
7.90 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_ . slug AS slug_5 , s0_ . lang AS lang_6 , s0_ . imagelink AS imagelink_7 , s0_ . videolink AS videolink_8 , s0_ . bgImagelink AS bgImagelink_9 , s0_ . tagline AS tagline_10 , s0_ . headerTextColor AS headerTextColor_11 , s0_ . spResponsiblePerson AS spResponsiblePerson_12 , s0_ . organization AS organization_13 , s0_ . organizerName AS organizerName_14 , s0_ . organizerEmail AS organizerEmail_15 , s0_ . venueName AS venueName_16 , s0_ . venueAddress AS venueAddress_17 , s0_ . ticketing AS ticketing_18 , s0_ . applicationUrl AS applicationUrl_19 , s0_ . alert AS alert_20 , s0_ . trainer AS trainer_21 , s0_ . speakers AS speakers_22 , s0_ . teaser AS teaser_23 , s0_ . navbar AS navbar_24 , s0_ . stripePriceId AS stripePriceId_25 , s0_ . stripeProductId AS stripeProductId_26 , s0_ . stripeAccount AS stripeAccount_27 , s0_ . priceInEuroCent AS priceInEuroCent_28 , s0_ . isTaxIncluded AS isTaxIncluded_29 , s0_ . isFreeForKiCampus AS isFreeForKiCampus_30 , s0_ . isFreeForCommunity AS isFreeForCommunity_31 , s0_ . isSinglePage AS isSinglePage_32 , s0_ . isFormalLanguage AS isFormalLanguage_33 , s0_ . isMultiBatchEvent AS isMultiBatchEvent_34 , s0_ . isFeatured AS isFeatured_35 , s0_ . capacity AS capacity_36 , s0_ . twigFile AS twigFile_37 , s0_ . additionalCss AS additionalCss_38 , s0_ . content AS content_39 , s0_ . contentTwig AS contentTwig_40 , s0_ . ctaContent AS ctaContent_41 , s0_ . postCtaContent AS postCtaContent_42 , s0_ . tags AS tags_43 , s0_ . seriesTag AS seriesTag_44 , s0_ . type AS type_45 , s0_ . location AS location_46 , s0_ . startDate AS startDate_47 , s0_ . endDate AS endDate_48 , s0_ . duration AS duration_49 , s0_ . status AS status_50 , s0_ . settings AS settings_51 , s0_ . displayStartDate AS displayStartDate_52 , s0_ . seoTitle AS seoTitle_53 , s0_ . seoKeyword AS seoKeyword_54 , s0_ . seoDescription AS seoDescription_55 , s0_ . navbar_en AS navbar_en_56 , s0_ . teaser_en AS teaser_en_57 , s0_ . content_en AS content_en_58 , s0_ . content_twig_en AS content_twig_en_59 , s0_ . post_cta_content_en AS post_cta_content_en_60 , s0_ . seo_title_en AS seo_title_en_61 , s0_ . seo_description_en AS seo_description_en_62 , s0_ . seo_keyword_en AS seo_keyword_en_63 , s0_ . has_english_version AS has_english_version_64 , s0_ . additional_js AS additional_js_65 , s0_ . metaPixelId AS metaPixelId_66 , s0_ . createDate AS createDate_67 , s0_ . lastChangeDate AS lastChangeDate_68 , s0_ . lastChangeUser AS lastChangeUser_69 , s0_ . publicId AS publicId_70 , s0_ . isExternalSubmission AS isExternalSubmission_71 , s0_ . createdBy AS createdBy_72 , s0_ . lastModified AS lastModified_73 , s0_ . createdAt AS createdAt_74 , s0_ . orgaNote AS orgaNote_75 , s0_ . history AS history_76 , s0_ . todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_ . seriesTag LIKE ? ORDER BY s0_ . startDate DESC
Parameters :
[
"%ai-coding-hackathon% "
]
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_ . slug AS slug_5 ,
s0_ . lang AS lang_6 ,
s0_ . imagelink AS imagelink_7 ,
s0_ . videolink AS videolink_8 ,
s0_ . bgImagelink AS bgImagelink_9 ,
s0_ . tagline AS tagline_10 ,
s0_ . headerTextColor AS headerTextColor_11 ,
s0_ . spResponsiblePerson AS spResponsiblePerson_12 ,
s0_ . organization AS organization_13 ,
s0_ . organizerName AS organizerName_14 ,
s0_ . organizerEmail AS organizerEmail_15 ,
s0_ . venueName AS venueName_16 ,
s0_ . venueAddress AS venueAddress_17 ,
s0_ . ticketing AS ticketing_18 ,
s0_ . applicationUrl AS applicationUrl_19 ,
s0_ . alert AS alert_20 ,
s0_ . trainer AS trainer_21 ,
s0_ . speakers AS speakers_22 ,
s0_ . teaser AS teaser_23 ,
s0_ . navbar AS navbar_24 ,
s0_ . stripePriceId AS stripePriceId_25 ,
s0_ . stripeProductId AS stripeProductId_26 ,
s0_ . stripeAccount AS stripeAccount_27 ,
s0_ . priceInEuroCent AS priceInEuroCent_28 ,
s0_ . isTaxIncluded AS isTaxIncluded_29 ,
s0_ . isFreeForKiCampus AS isFreeForKiCampus_30 ,
s0_ . isFreeForCommunity AS isFreeForCommunity_31 ,
s0_ . isSinglePage AS isSinglePage_32 ,
s0_ . isFormalLanguage AS isFormalLanguage_33 ,
s0_ . isMultiBatchEvent AS isMultiBatchEvent_34 ,
s0_ . isFeatured AS isFeatured_35 ,
s0_ . capacity AS capacity_36 ,
s0_ . twigFile AS twigFile_37 ,
s0_ . additionalCss AS additionalCss_38 ,
s0_ . content AS content_39 ,
s0_ . contentTwig AS contentTwig_40 ,
s0_ . ctaContent AS ctaContent_41 ,
s0_ . postCtaContent AS postCtaContent_42 ,
s0_ . tags AS tags_43 ,
s0_ . seriesTag AS seriesTag_44 ,
s0_ . type AS type_45 ,
s0_ . location AS location_46 ,
s0_ . startDate AS startDate_47 ,
s0_ . endDate AS endDate_48 ,
s0_ . duration AS duration_49 ,
s0_ . status AS status_50 ,
s0_ . settings AS settings_51 ,
s0_ . displayStartDate AS displayStartDate_52 ,
s0_ . seoTitle AS seoTitle_53 ,
s0_ . seoKeyword AS seoKeyword_54 ,
s0_ . seoDescription AS seoDescription_55 ,
s0_ . navbar_en AS navbar_en_56 ,
s0_ . teaser_en AS teaser_en_57 ,
s0_ . content_en AS content_en_58 ,
s0_ . content_twig_en AS content_twig_en_59 ,
s0_ . post_cta_content_en AS post_cta_content_en_60 ,
s0_ . seo_title_en AS seo_title_en_61 ,
s0_ . seo_description_en AS seo_description_en_62 ,
s0_ . seo_keyword_en AS seo_keyword_en_63 ,
s0_ . has_english_version AS has_english_version_64 ,
s0_ . additional_js AS additional_js_65 ,
s0_ . metaPixelId AS metaPixelId_66 ,
s0_ . createDate AS createDate_67 ,
s0_ . lastChangeDate AS lastChangeDate_68 ,
s0_ . lastChangeUser AS lastChangeUser_69 ,
s0_ . publicId AS publicId_70 ,
s0_ . isExternalSubmission AS isExternalSubmission_71 ,
s0_ . createdBy AS createdBy_72 ,
s0_ . lastModified AS lastModified_73 ,
s0_ . createdAt AS createdAt_74 ,
s0_ . orgaNote AS orgaNote_75 ,
s0_ . history AS history_76 ,
s0_ . todoHistory AS todoHistory_77
FROM
sp_event_events s0_
WHERE
s0_ . seriesTag LIKE ?
ORDER BY
s0_ . startDate DESC
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_ . slug AS slug_5 , s0_ . lang AS lang_6 , s0_ . imagelink AS imagelink_7 , s0_ . videolink AS videolink_8 , s0_ . bgImagelink AS bgImagelink_9 , s0_ . tagline AS tagline_10 , s0_ . headerTextColor AS headerTextColor_11 , s0_ . spResponsiblePerson AS spResponsiblePerson_12 , s0_ . organization AS organization_13 , s0_ . organizerName AS organizerName_14 , s0_ . organizerEmail AS organizerEmail_15 , s0_ . venueName AS venueName_16 , s0_ . venueAddress AS venueAddress_17 , s0_ . ticketing AS ticketing_18 , s0_ . applicationUrl AS applicationUrl_19 , s0_ . alert AS alert_20 , s0_ . trainer AS trainer_21 , s0_ . speakers AS speakers_22 , s0_ . teaser AS teaser_23 , s0_ . navbar AS navbar_24 , s0_ . stripePriceId AS stripePriceId_25 , s0_ . stripeProductId AS stripeProductId_26 , s0_ . stripeAccount AS stripeAccount_27 , s0_ . priceInEuroCent AS priceInEuroCent_28 , s0_ . isTaxIncluded AS isTaxIncluded_29 , s0_ . isFreeForKiCampus AS isFreeForKiCampus_30 , s0_ . isFreeForCommunity AS isFreeForCommunity_31 , s0_ . isSinglePage AS isSinglePage_32 , s0_ . isFormalLanguage AS isFormalLanguage_33 , s0_ . isMultiBatchEvent AS isMultiBatchEvent_34 , s0_ . isFeatured AS isFeatured_35 , s0_ . capacity AS capacity_36 , s0_ . twigFile AS twigFile_37 , s0_ . additionalCss AS additionalCss_38 , s0_ . content AS content_39 , s0_ . contentTwig AS contentTwig_40 , s0_ . ctaContent AS ctaContent_41 , s0_ . postCtaContent AS postCtaContent_42 , s0_ . tags AS tags_43 , s0_ . seriesTag AS seriesTag_44 , s0_ . type AS type_45 , s0_ . location AS location_46 , s0_ . startDate AS startDate_47 , s0_ . endDate AS endDate_48 , s0_ . duration AS duration_49 , s0_ . status AS status_50 , s0_ . settings AS settings_51 , s0_ . displayStartDate AS displayStartDate_52 , s0_ . seoTitle AS seoTitle_53 , s0_ . seoKeyword AS seoKeyword_54 , s0_ . seoDescription AS seoDescription_55 , s0_ . navbar_en AS navbar_en_56 , s0_ . teaser_en AS teaser_en_57 , s0_ . content_en AS content_en_58 , s0_ . content_twig_en AS content_twig_en_59 , s0_ . post_cta_content_en AS post_cta_content_en_60 , s0_ . seo_title_en AS seo_title_en_61 , s0_ . seo_description_en AS seo_description_en_62 , s0_ . seo_keyword_en AS seo_keyword_en_63 , s0_ . has_english_version AS has_english_version_64 , s0_ . additional_js AS additional_js_65 , s0_ . metaPixelId AS metaPixelId_66 , s0_ . createDate AS createDate_67 , s0_ . lastChangeDate AS lastChangeDate_68 , s0_ . lastChangeUser AS lastChangeUser_69 , s0_ . publicId AS publicId_70 , s0_ . isExternalSubmission AS isExternalSubmission_71 , s0_ . createdBy AS createdBy_72 , s0_ . lastModified AS lastModified_73 , s0_ . createdAt AS createdAt_74 , s0_ . orgaNote AS orgaNote_75 , s0_ . history AS history_76 , s0_ . todoHistory AS todoHistory_77 FROM sp_event_events s0_ WHERE s0_ . seriesTag LIKE '%ai-coding-hackathon%' ORDER BY s0_ . startDate DESC ;
Copy
3
0.75 ms
SELECT t0 . id AS id_1 , t0 . programId AS programId_2 , t0 . eventId AS eventId_3 , t0 . productId AS productId_4 , t0 . batchNumber AS batchNumber_5 , t0 . url AS url_6 , t0 . name AS name_7 , t0 . slug AS slug_8 , t0 . alias AS alias_9 , t0 . status AS status_10 , t0 . focusStatus AS focusStatus_11 , t0 . lang AS lang_12 , t0 . priceInEuroCent AS priceInEuroCent_13 , t0 . isTaxIncluded AS isTaxIncluded_14 , t0 . discount100MemberTags AS discount100MemberTags_15 , t0 . discount50MemberTags AS discount50MemberTags_16 , t0 . discount20MemberTags AS discount20MemberTags_17 , t0 . askForTeam AS askForTeam_18 , t0 . hasEvent AS hasEvent_19 , t0 . hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20 , t0 . hasIncludeTermsConsent AS hasIncludeTermsConsent_21 , t0 . hasIncludeLinkedIn AS hasIncludeLinkedIn_22 , t0 . hasIncludePhone AS hasIncludePhone_23 , t0 . hasFollowUp AS hasFollowUp_24 , t0 . isNetworking AS isNetworking_25 , t0 . networkingRounds AS networkingRounds_26 , t0 . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27 , t0 . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28 , t0 . isFutureEvent AS isFutureEvent_29 , t0 . visibility AS visibility_30 , t0 . access AS access_31 , t0 . tags AS tags_32 , t0 . typeformLink AS typeformLink_33 , t0 . zoomLink AS zoomLink_34 , t0 . bgImageUrl AS bgImageUrl_35 , t0 . startDate AS startDate_36 , t0 . endDate AS endDate_37 , t0 . stripePriceId AS stripePriceId_38 , t0 . stripeProductId AS stripeProductId_39 , t0 . stripeAccount AS stripeAccount_40 , t0 . stripePriceIdLive AS stripePriceIdLive_41 , t0 . stripePriceIdTest AS stripePriceIdTest_42 , t0 . stripeProductIdLive AS stripeProductIdLive_43 , t0 . stripeProductIdTest AS stripeProductIdTest_44 , t0 . taxBehavior AS taxBehavior_45 , t0 . paymentProvider AS paymentProvider_46 , t0 . isFreeForKiCampus AS isFreeForKiCampus_47 , t0 . isFreeForCommunity AS isFreeForCommunity_48 , t0 . registrationMode AS registrationMode_49 , t0 . externalRegistrationUrl AS externalRegistrationUrl_50 , t0 . externalPlatform AS externalPlatform_51 , t0 . registrationHeadline AS registrationHeadline_52 , t0 . registrationSubtitle AS registrationSubtitle_53 , t0 . registrationButtonText AS registrationButtonText_54 , t0 . registrationRedirectUrl AS registrationRedirectUrl_55 , t0 . lumaEventApiId AS lumaEventApiId_56 , t0 . meetupEventId AS meetupEventId_57 , t0 . meetupEventUrl AS meetupEventUrl_58 , t0 . mailDesignTemplate AS mailDesignTemplate_59 , t0 . senderMail AS senderMail_60 , t0 . fromName AS fromName_61 , t0 . recipientMonitoringMail AS recipientMonitoringMail_62 , t0 . confirmationMailSubject AS confirmationMailSubject_63 , t0 . confirmationMailContent AS confirmationMailContent_64 , t0 . adminNotificationMailSubject AS adminNotificationMailSubject_65 , t0 . adminNotificationMailContent AS adminNotificationMailContent_66 , t0 . reminderMailTemplateId AS reminderMailTemplateId_67 , t0 . reminderSenderEmail AS reminderSenderEmail_68 , t0 . reminderBulkMailId AS reminderBulkMailId_69 , t0 . reminderMailSendDate AS reminderMailSendDate_70 , t0 . reminderMailSubject AS reminderMailSubject_71 , t0 . reminderMailContent AS reminderMailContent_72 , t0 . $reminderMailStatus AS reminderMailStatus_73 , t0 . surveyId AS surveyId_74 , t0 . surveyMailTemplateId AS surveyMailTemplateId_75 , t0 . surveyBulkMailId AS surveyBulkMailId_76 , t0 . template AS template_77 , t0 . pageTemplate AS pageTemplate_78 , t0 . footerTemplate AS footerTemplate_79 , t0 . email AS email_80 , t0 . emailSubject AS emailSubject_81 , t0 . emailContent AS emailContent_82 , t0 . landingPageContent AS landingPageContent_83 , t0 . landingPageDescription AS landingPageDescription_84 , t0 . landingPageCss AS landingPageCss_85 , t0 . landingPageJs AS landingPageJs_86 , t0 . landingPageFooterTemplate AS landingPageFooterTemplate_87 , t0 . landingPageSocialImage AS landingPageSocialImage_88 , t0 . hasCustomPage AS hasCustomPage_89 , t0 . landingPageTitle AS landingPageTitle_90 , t0 . landingPageTwig AS landingPageTwig_91 , t0 . goToPage AS goToPage_92 , t0 . phrasesDe AS phrasesDe_93 , t0 . phrasesEn AS phrasesEn_94 , t0 . settings AS settings_95 , t0 . capacity AS capacity_96 , t0 . asssesmentDimensions AS asssesmentDimensions_97 , t0 . start AS start_98 , t0 . end AS end_99 , t0 . pitchTopic AS pitchTopic_100 , t0 . pitchImageLink AS pitchImageLink_101 , t0 . pitchVideoLink AS pitchVideoLink_102 , t0 . pitchPartner AS pitchPartner_103 , t0 . pitchPartnerId AS pitchPartnerId_104 , t0 . pitchDescription AS pitchDescription_105 , t0 . followUpPageContent AS followUpPageContent_106 , t0 . followUpPageDescription AS followUpPageDescription_107 , t0 . followUpPageCss AS followUpPageCss_108 , t0 . followUpPageJs AS followUpPageJs_109 , t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_110 , t0 . followUpPageTitle AS followUpPageTitle_111 , t0 . followUpPageSocialImage AS followUpPageSocialImage_112 , t0 . followUpDescription AS followUpDescription_113 , t0 . followUpVideoLink AS followUpVideoLink_114 , t0 . followUpPresentation AS followUpPresentation_115 , t0 . followUpSkoolUrl AS followUpSkoolUrl_116 , t0 . followUpWhatsAppUrl AS followUpWhatsAppUrl_117 , t0 . followUpCtaText AS followUpCtaText_118 , t0 . followUpCtaUrl AS followUpCtaUrl_119 , t0 . followUpDocuments AS followUpDocuments_120 , t0 . followUpPhotos AS followUpPhotos_121 , t0 . followUpExtraLinks AS followUpExtraLinks_122 , t0 . followUpChecklist AS followUpChecklist_123 , t0 . pitchDate AS pitchDate_124 , t0 . pitchTime AS pitchTime_125 , t0 . prepitchDate AS prepitchDate_126 , t0 . city AS city_127 , t0 . applicationsCount AS applicationsCount_128 , t0 . startedCount AS startedCount_129 , t0 . appliedCount AS appliedCount_130 , t0 . approvedCount AS approvedCount_131 , t0 . rejectedCount AS rejectedCount_132 , t0 . $skoolWebhook AS skoolWebhook_133 , t0 . zapierWebhook AS zapierWebhook_134 , t0 . history AS history_135 , t0 . createdAt AS createdAt_136 , t0 . lastModified AS lastModified_137 , t0 . lastChangeUser AS lastChangeUser_138 , t0 . program_id AS program_id_139 , t0 . assessmentTeamId AS assessmentTeamId_140 FROM sp_batches t0 WHERE t0 . programId = ? AND t0 . eventId = ? AND t0 . status = ? AND t0 . access = ? LIMIT 1
Parameters :
[
27
6839
"active "
"anonymous "
]
SELECT
t0 . id AS id_1 ,
t0 . programId AS programId_2 ,
t0 . eventId AS eventId_3 ,
t0 . productId AS productId_4 ,
t0 . batchNumber AS batchNumber_5 ,
t0 . url AS url_6 ,
t0 . name AS name_7 ,
t0 . slug AS slug_8 ,
t0 . alias AS alias_9 ,
t0 . status AS status_10 ,
t0 . focusStatus AS focusStatus_11 ,
t0 . lang AS lang_12 ,
t0 . priceInEuroCent AS priceInEuroCent_13 ,
t0 . isTaxIncluded AS isTaxIncluded_14 ,
t0 . discount100MemberTags AS discount100MemberTags_15 ,
t0 . discount50MemberTags AS discount50MemberTags_16 ,
t0 . discount20MemberTags AS discount20MemberTags_17 ,
t0 . askForTeam AS askForTeam_18 ,
t0 . hasEvent AS hasEvent_19 ,
t0 . hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20 ,
t0 . hasIncludeTermsConsent AS hasIncludeTermsConsent_21 ,
t0 . hasIncludeLinkedIn AS hasIncludeLinkedIn_22 ,
t0 . hasIncludePhone AS hasIncludePhone_23 ,
t0 . hasFollowUp AS hasFollowUp_24 ,
t0 . isNetworking AS isNetworking_25 ,
t0 . networkingRounds AS networkingRounds_26 ,
t0 . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27 ,
t0 . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28 ,
t0 . isFutureEvent AS isFutureEvent_29 ,
t0 . visibility AS visibility_30 ,
t0 . access AS access_31 ,
t0 . tags AS tags_32 ,
t0 . typeformLink AS typeformLink_33 ,
t0 . zoomLink AS zoomLink_34 ,
t0 . bgImageUrl AS bgImageUrl_35 ,
t0 . startDate AS startDate_36 ,
t0 . endDate AS endDate_37 ,
t0 . stripePriceId AS stripePriceId_38 ,
t0 . stripeProductId AS stripeProductId_39 ,
t0 . stripeAccount AS stripeAccount_40 ,
t0 . stripePriceIdLive AS stripePriceIdLive_41 ,
t0 . stripePriceIdTest AS stripePriceIdTest_42 ,
t0 . stripeProductIdLive AS stripeProductIdLive_43 ,
t0 . stripeProductIdTest AS stripeProductIdTest_44 ,
t0 . taxBehavior AS taxBehavior_45 ,
t0 . paymentProvider AS paymentProvider_46 ,
t0 . isFreeForKiCampus AS isFreeForKiCampus_47 ,
t0 . isFreeForCommunity AS isFreeForCommunity_48 ,
t0 . registrationMode AS registrationMode_49 ,
t0 . externalRegistrationUrl AS externalRegistrationUrl_50 ,
t0 . externalPlatform AS externalPlatform_51 ,
t0 . registrationHeadline AS registrationHeadline_52 ,
t0 . registrationSubtitle AS registrationSubtitle_53 ,
t0 . registrationButtonText AS registrationButtonText_54 ,
t0 . registrationRedirectUrl AS registrationRedirectUrl_55 ,
t0 . lumaEventApiId AS lumaEventApiId_56 ,
t0 . meetupEventId AS meetupEventId_57 ,
t0 . meetupEventUrl AS meetupEventUrl_58 ,
t0 . mailDesignTemplate AS mailDesignTemplate_59 ,
t0 . senderMail AS senderMail_60 ,
t0 . fromName AS fromName_61 ,
t0 . recipientMonitoringMail AS recipientMonitoringMail_62 ,
t0 . confirmationMailSubject AS confirmationMailSubject_63 ,
t0 . confirmationMailContent AS confirmationMailContent_64 ,
t0 . adminNotificationMailSubject AS adminNotificationMailSubject_65 ,
t0 . adminNotificationMailContent AS adminNotificationMailContent_66 ,
t0 . reminderMailTemplateId AS reminderMailTemplateId_67 ,
t0 . reminderSenderEmail AS reminderSenderEmail_68 ,
t0 . reminderBulkMailId AS reminderBulkMailId_69 ,
t0 . reminderMailSendDate AS reminderMailSendDate_70 ,
t0 . reminderMailSubject AS reminderMailSubject_71 ,
t0 . reminderMailContent AS reminderMailContent_72 ,
t0 . $reminderMailStatus AS reminderMailStatus_73 ,
t0 . surveyId AS surveyId_74 ,
t0 . surveyMailTemplateId AS surveyMailTemplateId_75 ,
t0 . surveyBulkMailId AS surveyBulkMailId_76 ,
t0 . template AS template_77 ,
t0 . pageTemplate AS pageTemplate_78 ,
t0 . footerTemplate AS footerTemplate_79 ,
t0 . email AS email_80 ,
t0 . emailSubject AS emailSubject_81 ,
t0 . emailContent AS emailContent_82 ,
t0 . landingPageContent AS landingPageContent_83 ,
t0 . landingPageDescription AS landingPageDescription_84 ,
t0 . landingPageCss AS landingPageCss_85 ,
t0 . landingPageJs AS landingPageJs_86 ,
t0 . landingPageFooterTemplate AS landingPageFooterTemplate_87 ,
t0 . landingPageSocialImage AS landingPageSocialImage_88 ,
t0 . hasCustomPage AS hasCustomPage_89 ,
t0 . landingPageTitle AS landingPageTitle_90 ,
t0 . landingPageTwig AS landingPageTwig_91 ,
t0 . goToPage AS goToPage_92 ,
t0 . phrasesDe AS phrasesDe_93 ,
t0 . phrasesEn AS phrasesEn_94 ,
t0 . settings AS settings_95 ,
t0 . capacity AS capacity_96 ,
t0 . asssesmentDimensions AS asssesmentDimensions_97 ,
t0 . start AS start_98 ,
t0 . end AS end_99 ,
t0 . pitchTopic AS pitchTopic_100 ,
t0 . pitchImageLink AS pitchImageLink_101 ,
t0 . pitchVideoLink AS pitchVideoLink_102 ,
t0 . pitchPartner AS pitchPartner_103 ,
t0 . pitchPartnerId AS pitchPartnerId_104 ,
t0 . pitchDescription AS pitchDescription_105 ,
t0 . followUpPageContent AS followUpPageContent_106 ,
t0 . followUpPageDescription AS followUpPageDescription_107 ,
t0 . followUpPageCss AS followUpPageCss_108 ,
t0 . followUpPageJs AS followUpPageJs_109 ,
t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_110 ,
t0 . followUpPageTitle AS followUpPageTitle_111 ,
t0 . followUpPageSocialImage AS followUpPageSocialImage_112 ,
t0 . followUpDescription AS followUpDescription_113 ,
t0 . followUpVideoLink AS followUpVideoLink_114 ,
t0 . followUpPresentation AS followUpPresentation_115 ,
t0 . followUpSkoolUrl AS followUpSkoolUrl_116 ,
t0 . followUpWhatsAppUrl AS followUpWhatsAppUrl_117 ,
t0 . followUpCtaText AS followUpCtaText_118 ,
t0 . followUpCtaUrl AS followUpCtaUrl_119 ,
t0 . followUpDocuments AS followUpDocuments_120 ,
t0 . followUpPhotos AS followUpPhotos_121 ,
t0 . followUpExtraLinks AS followUpExtraLinks_122 ,
t0 . followUpChecklist AS followUpChecklist_123 ,
t0 . pitchDate AS pitchDate_124 ,
t0 . pitchTime AS pitchTime_125 ,
t0 . prepitchDate AS prepitchDate_126 ,
t0 . city AS city_127 ,
t0 . applicationsCount AS applicationsCount_128 ,
t0 . startedCount AS startedCount_129 ,
t0 . appliedCount AS appliedCount_130 ,
t0 . approvedCount AS approvedCount_131 ,
t0 . rejectedCount AS rejectedCount_132 ,
t0 . $skoolWebhook AS skoolWebhook_133 ,
t0 . zapierWebhook AS zapierWebhook_134 ,
t0 . history AS history_135 ,
t0 . createdAt AS createdAt_136 ,
t0 . lastModified AS lastModified_137 ,
t0 . lastChangeUser AS lastChangeUser_138 ,
t0 . program_id AS program_id_139 ,
t0 . assessmentTeamId AS assessmentTeamId_140
FROM
sp_batches t0
WHERE
t0 . programId = ?
AND t0 . eventId = ?
AND t0 . status = ?
AND t0 . access = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . programId AS programId_2 , t0 . eventId AS eventId_3 , t0 . productId AS productId_4 , t0 . batchNumber AS batchNumber_5 , t0 . url AS url_6 , t0 . name AS name_7 , t0 . slug AS slug_8 , t0 . alias AS alias_9 , t0 . status AS status_10 , t0 . focusStatus AS focusStatus_11 , t0 . lang AS lang_12 , t0 . priceInEuroCent AS priceInEuroCent_13 , t0 . isTaxIncluded AS isTaxIncluded_14 , t0 . discount100MemberTags AS discount100MemberTags_15 , t0 . discount50MemberTags AS discount50MemberTags_16 , t0 . discount20MemberTags AS discount20MemberTags_17 , t0 . askForTeam AS askForTeam_18 , t0 . hasEvent AS hasEvent_19 , t0 . hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20 , t0 . hasIncludeTermsConsent AS hasIncludeTermsConsent_21 , t0 . hasIncludeLinkedIn AS hasIncludeLinkedIn_22 , t0 . hasIncludePhone AS hasIncludePhone_23 , t0 . hasFollowUp AS hasFollowUp_24 , t0 . isNetworking AS isNetworking_25 , t0 . networkingRounds AS networkingRounds_26 , t0 . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27 , t0 . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28 , t0 . isFutureEvent AS isFutureEvent_29 , t0 . visibility AS visibility_30 , t0 . access AS access_31 , t0 . tags AS tags_32 , t0 . typeformLink AS typeformLink_33 , t0 . zoomLink AS zoomLink_34 , t0 . bgImageUrl AS bgImageUrl_35 , t0 . startDate AS startDate_36 , t0 . endDate AS endDate_37 , t0 . stripePriceId AS stripePriceId_38 , t0 . stripeProductId AS stripeProductId_39 , t0 . stripeAccount AS stripeAccount_40 , t0 . stripePriceIdLive AS stripePriceIdLive_41 , t0 . stripePriceIdTest AS stripePriceIdTest_42 , t0 . stripeProductIdLive AS stripeProductIdLive_43 , t0 . stripeProductIdTest AS stripeProductIdTest_44 , t0 . taxBehavior AS taxBehavior_45 , t0 . paymentProvider AS paymentProvider_46 , t0 . isFreeForKiCampus AS isFreeForKiCampus_47 , t0 . isFreeForCommunity AS isFreeForCommunity_48 , t0 . registrationMode AS registrationMode_49 , t0 . externalRegistrationUrl AS externalRegistrationUrl_50 , t0 . externalPlatform AS externalPlatform_51 , t0 . registrationHeadline AS registrationHeadline_52 , t0 . registrationSubtitle AS registrationSubtitle_53 , t0 . registrationButtonText AS registrationButtonText_54 , t0 . registrationRedirectUrl AS registrationRedirectUrl_55 , t0 . lumaEventApiId AS lumaEventApiId_56 , t0 . meetupEventId AS meetupEventId_57 , t0 . meetupEventUrl AS meetupEventUrl_58 , t0 . mailDesignTemplate AS mailDesignTemplate_59 , t0 . senderMail AS senderMail_60 , t0 . fromName AS fromName_61 , t0 . recipientMonitoringMail AS recipientMonitoringMail_62 , t0 . confirmationMailSubject AS confirmationMailSubject_63 , t0 . confirmationMailContent AS confirmationMailContent_64 , t0 . adminNotificationMailSubject AS adminNotificationMailSubject_65 , t0 . adminNotificationMailContent AS adminNotificationMailContent_66 , t0 . reminderMailTemplateId AS reminderMailTemplateId_67 , t0 . reminderSenderEmail AS reminderSenderEmail_68 , t0 . reminderBulkMailId AS reminderBulkMailId_69 , t0 . reminderMailSendDate AS reminderMailSendDate_70 , t0 . reminderMailSubject AS reminderMailSubject_71 , t0 . reminderMailContent AS reminderMailContent_72 , t0 . $reminderMailStatus AS reminderMailStatus_73 , t0 . surveyId AS surveyId_74 , t0 . surveyMailTemplateId AS surveyMailTemplateId_75 , t0 . surveyBulkMailId AS surveyBulkMailId_76 , t0 . template AS template_77 , t0 . pageTemplate AS pageTemplate_78 , t0 . footerTemplate AS footerTemplate_79 , t0 . email AS email_80 , t0 . emailSubject AS emailSubject_81 , t0 . emailContent AS emailContent_82 , t0 . landingPageContent AS landingPageContent_83 , t0 . landingPageDescription AS landingPageDescription_84 , t0 . landingPageCss AS landingPageCss_85 , t0 . landingPageJs AS landingPageJs_86 , t0 . landingPageFooterTemplate AS landingPageFooterTemplate_87 , t0 . landingPageSocialImage AS landingPageSocialImage_88 , t0 . hasCustomPage AS hasCustomPage_89 , t0 . landingPageTitle AS landingPageTitle_90 , t0 . landingPageTwig AS landingPageTwig_91 , t0 . goToPage AS goToPage_92 , t0 . phrasesDe AS phrasesDe_93 , t0 . phrasesEn AS phrasesEn_94 , t0 . settings AS settings_95 , t0 . capacity AS capacity_96 , t0 . asssesmentDimensions AS asssesmentDimensions_97 , t0 . start AS start_98 , t0 . end AS end_99 , t0 . pitchTopic AS pitchTopic_100 , t0 . pitchImageLink AS pitchImageLink_101 , t0 . pitchVideoLink AS pitchVideoLink_102 , t0 . pitchPartner AS pitchPartner_103 , t0 . pitchPartnerId AS pitchPartnerId_104 , t0 . pitchDescription AS pitchDescription_105 , t0 . followUpPageContent AS followUpPageContent_106 , t0 . followUpPageDescription AS followUpPageDescription_107 , t0 . followUpPageCss AS followUpPageCss_108 , t0 . followUpPageJs AS followUpPageJs_109 , t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_110 , t0 . followUpPageTitle AS followUpPageTitle_111 , t0 . followUpPageSocialImage AS followUpPageSocialImage_112 , t0 . followUpDescription AS followUpDescription_113 , t0 . followUpVideoLink AS followUpVideoLink_114 , t0 . followUpPresentation AS followUpPresentation_115 , t0 . followUpSkoolUrl AS followUpSkoolUrl_116 , t0 . followUpWhatsAppUrl AS followUpWhatsAppUrl_117 , t0 . followUpCtaText AS followUpCtaText_118 , t0 . followUpCtaUrl AS followUpCtaUrl_119 , t0 . followUpDocuments AS followUpDocuments_120 , t0 . followUpPhotos AS followUpPhotos_121 , t0 . followUpExtraLinks AS followUpExtraLinks_122 , t0 . followUpChecklist AS followUpChecklist_123 , t0 . pitchDate AS pitchDate_124 , t0 . pitchTime AS pitchTime_125 , t0 . prepitchDate AS prepitchDate_126 , t0 . city AS city_127 , t0 . applicationsCount AS applicationsCount_128 , t0 . startedCount AS startedCount_129 , t0 . appliedCount AS appliedCount_130 , t0 . approvedCount AS approvedCount_131 , t0 . rejectedCount AS rejectedCount_132 , t0 . $skoolWebhook AS skoolWebhook_133 , t0 . zapierWebhook AS zapierWebhook_134 , t0 . history AS history_135 , t0 . createdAt AS createdAt_136 , t0 . lastModified AS lastModified_137 , t0 . lastChangeUser AS lastChangeUser_138 , t0 . program_id AS program_id_139 , t0 . assessmentTeamId AS assessmentTeamId_140 FROM sp_batches t0 WHERE t0 . programId = 27 AND t0 . eventId = 6839 AND t0 . status = 'active' AND t0 . access = 'anonymous' LIMIT 1 ;
Copy
4
0.57 ms
SELECT t0 . id AS id_1 , t0 . programId AS programId_2 , t0 . eventId AS eventId_3 , t0 . productId AS productId_4 , t0 . batchNumber AS batchNumber_5 , t0 . url AS url_6 , t0 . name AS name_7 , t0 . slug AS slug_8 , t0 . alias AS alias_9 , t0 . status AS status_10 , t0 . focusStatus AS focusStatus_11 , t0 . lang AS lang_12 , t0 . priceInEuroCent AS priceInEuroCent_13 , t0 . isTaxIncluded AS isTaxIncluded_14 , t0 . discount100MemberTags AS discount100MemberTags_15 , t0 . discount50MemberTags AS discount50MemberTags_16 , t0 . discount20MemberTags AS discount20MemberTags_17 , t0 . askForTeam AS askForTeam_18 , t0 . hasEvent AS hasEvent_19 , t0 . hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20 , t0 . hasIncludeTermsConsent AS hasIncludeTermsConsent_21 , t0 . hasIncludeLinkedIn AS hasIncludeLinkedIn_22 , t0 . hasIncludePhone AS hasIncludePhone_23 , t0 . hasFollowUp AS hasFollowUp_24 , t0 . isNetworking AS isNetworking_25 , t0 . networkingRounds AS networkingRounds_26 , t0 . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27 , t0 . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28 , t0 . isFutureEvent AS isFutureEvent_29 , t0 . visibility AS visibility_30 , t0 . access AS access_31 , t0 . tags AS tags_32 , t0 . typeformLink AS typeformLink_33 , t0 . zoomLink AS zoomLink_34 , t0 . bgImageUrl AS bgImageUrl_35 , t0 . startDate AS startDate_36 , t0 . endDate AS endDate_37 , t0 . stripePriceId AS stripePriceId_38 , t0 . stripeProductId AS stripeProductId_39 , t0 . stripeAccount AS stripeAccount_40 , t0 . stripePriceIdLive AS stripePriceIdLive_41 , t0 . stripePriceIdTest AS stripePriceIdTest_42 , t0 . stripeProductIdLive AS stripeProductIdLive_43 , t0 . stripeProductIdTest AS stripeProductIdTest_44 , t0 . taxBehavior AS taxBehavior_45 , t0 . paymentProvider AS paymentProvider_46 , t0 . isFreeForKiCampus AS isFreeForKiCampus_47 , t0 . isFreeForCommunity AS isFreeForCommunity_48 , t0 . registrationMode AS registrationMode_49 , t0 . externalRegistrationUrl AS externalRegistrationUrl_50 , t0 . externalPlatform AS externalPlatform_51 , t0 . registrationHeadline AS registrationHeadline_52 , t0 . registrationSubtitle AS registrationSubtitle_53 , t0 . registrationButtonText AS registrationButtonText_54 , t0 . registrationRedirectUrl AS registrationRedirectUrl_55 , t0 . lumaEventApiId AS lumaEventApiId_56 , t0 . meetupEventId AS meetupEventId_57 , t0 . meetupEventUrl AS meetupEventUrl_58 , t0 . mailDesignTemplate AS mailDesignTemplate_59 , t0 . senderMail AS senderMail_60 , t0 . fromName AS fromName_61 , t0 . recipientMonitoringMail AS recipientMonitoringMail_62 , t0 . confirmationMailSubject AS confirmationMailSubject_63 , t0 . confirmationMailContent AS confirmationMailContent_64 , t0 . adminNotificationMailSubject AS adminNotificationMailSubject_65 , t0 . adminNotificationMailContent AS adminNotificationMailContent_66 , t0 . reminderMailTemplateId AS reminderMailTemplateId_67 , t0 . reminderSenderEmail AS reminderSenderEmail_68 , t0 . reminderBulkMailId AS reminderBulkMailId_69 , t0 . reminderMailSendDate AS reminderMailSendDate_70 , t0 . reminderMailSubject AS reminderMailSubject_71 , t0 . reminderMailContent AS reminderMailContent_72 , t0 . $reminderMailStatus AS reminderMailStatus_73 , t0 . surveyId AS surveyId_74 , t0 . surveyMailTemplateId AS surveyMailTemplateId_75 , t0 . surveyBulkMailId AS surveyBulkMailId_76 , t0 . template AS template_77 , t0 . pageTemplate AS pageTemplate_78 , t0 . footerTemplate AS footerTemplate_79 , t0 . email AS email_80 , t0 . emailSubject AS emailSubject_81 , t0 . emailContent AS emailContent_82 , t0 . landingPageContent AS landingPageContent_83 , t0 . landingPageDescription AS landingPageDescription_84 , t0 . landingPageCss AS landingPageCss_85 , t0 . landingPageJs AS landingPageJs_86 , t0 . landingPageFooterTemplate AS landingPageFooterTemplate_87 , t0 . landingPageSocialImage AS landingPageSocialImage_88 , t0 . hasCustomPage AS hasCustomPage_89 , t0 . landingPageTitle AS landingPageTitle_90 , t0 . landingPageTwig AS landingPageTwig_91 , t0 . goToPage AS goToPage_92 , t0 . phrasesDe AS phrasesDe_93 , t0 . phrasesEn AS phrasesEn_94 , t0 . settings AS settings_95 , t0 . capacity AS capacity_96 , t0 . asssesmentDimensions AS asssesmentDimensions_97 , t0 . start AS start_98 , t0 . end AS end_99 , t0 . pitchTopic AS pitchTopic_100 , t0 . pitchImageLink AS pitchImageLink_101 , t0 . pitchVideoLink AS pitchVideoLink_102 , t0 . pitchPartner AS pitchPartner_103 , t0 . pitchPartnerId AS pitchPartnerId_104 , t0 . pitchDescription AS pitchDescription_105 , t0 . followUpPageContent AS followUpPageContent_106 , t0 . followUpPageDescription AS followUpPageDescription_107 , t0 . followUpPageCss AS followUpPageCss_108 , t0 . followUpPageJs AS followUpPageJs_109 , t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_110 , t0 . followUpPageTitle AS followUpPageTitle_111 , t0 . followUpPageSocialImage AS followUpPageSocialImage_112 , t0 . followUpDescription AS followUpDescription_113 , t0 . followUpVideoLink AS followUpVideoLink_114 , t0 . followUpPresentation AS followUpPresentation_115 , t0 . followUpSkoolUrl AS followUpSkoolUrl_116 , t0 . followUpWhatsAppUrl AS followUpWhatsAppUrl_117 , t0 . followUpCtaText AS followUpCtaText_118 , t0 . followUpCtaUrl AS followUpCtaUrl_119 , t0 . followUpDocuments AS followUpDocuments_120 , t0 . followUpPhotos AS followUpPhotos_121 , t0 . followUpExtraLinks AS followUpExtraLinks_122 , t0 . followUpChecklist AS followUpChecklist_123 , t0 . pitchDate AS pitchDate_124 , t0 . pitchTime AS pitchTime_125 , t0 . prepitchDate AS prepitchDate_126 , t0 . city AS city_127 , t0 . applicationsCount AS applicationsCount_128 , t0 . startedCount AS startedCount_129 , t0 . appliedCount AS appliedCount_130 , t0 . approvedCount AS approvedCount_131 , t0 . rejectedCount AS rejectedCount_132 , t0 . $skoolWebhook AS skoolWebhook_133 , t0 . zapierWebhook AS zapierWebhook_134 , t0 . history AS history_135 , t0 . createdAt AS createdAt_136 , t0 . lastModified AS lastModified_137 , t0 . lastChangeUser AS lastChangeUser_138 , t0 . program_id AS program_id_139 , t0 . assessmentTeamId AS assessmentTeamId_140 FROM sp_batches t0 WHERE t0 . programId = ? AND t0 . eventId = ? AND t0 . status = ? AND t0 . access = ? LIMIT 1
Parameters :
[
27
6839
"completed "
"anonymous "
]
SELECT
t0 . id AS id_1 ,
t0 . programId AS programId_2 ,
t0 . eventId AS eventId_3 ,
t0 . productId AS productId_4 ,
t0 . batchNumber AS batchNumber_5 ,
t0 . url AS url_6 ,
t0 . name AS name_7 ,
t0 . slug AS slug_8 ,
t0 . alias AS alias_9 ,
t0 . status AS status_10 ,
t0 . focusStatus AS focusStatus_11 ,
t0 . lang AS lang_12 ,
t0 . priceInEuroCent AS priceInEuroCent_13 ,
t0 . isTaxIncluded AS isTaxIncluded_14 ,
t0 . discount100MemberTags AS discount100MemberTags_15 ,
t0 . discount50MemberTags AS discount50MemberTags_16 ,
t0 . discount20MemberTags AS discount20MemberTags_17 ,
t0 . askForTeam AS askForTeam_18 ,
t0 . hasEvent AS hasEvent_19 ,
t0 . hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20 ,
t0 . hasIncludeTermsConsent AS hasIncludeTermsConsent_21 ,
t0 . hasIncludeLinkedIn AS hasIncludeLinkedIn_22 ,
t0 . hasIncludePhone AS hasIncludePhone_23 ,
t0 . hasFollowUp AS hasFollowUp_24 ,
t0 . isNetworking AS isNetworking_25 ,
t0 . networkingRounds AS networkingRounds_26 ,
t0 . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27 ,
t0 . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28 ,
t0 . isFutureEvent AS isFutureEvent_29 ,
t0 . visibility AS visibility_30 ,
t0 . access AS access_31 ,
t0 . tags AS tags_32 ,
t0 . typeformLink AS typeformLink_33 ,
t0 . zoomLink AS zoomLink_34 ,
t0 . bgImageUrl AS bgImageUrl_35 ,
t0 . startDate AS startDate_36 ,
t0 . endDate AS endDate_37 ,
t0 . stripePriceId AS stripePriceId_38 ,
t0 . stripeProductId AS stripeProductId_39 ,
t0 . stripeAccount AS stripeAccount_40 ,
t0 . stripePriceIdLive AS stripePriceIdLive_41 ,
t0 . stripePriceIdTest AS stripePriceIdTest_42 ,
t0 . stripeProductIdLive AS stripeProductIdLive_43 ,
t0 . stripeProductIdTest AS stripeProductIdTest_44 ,
t0 . taxBehavior AS taxBehavior_45 ,
t0 . paymentProvider AS paymentProvider_46 ,
t0 . isFreeForKiCampus AS isFreeForKiCampus_47 ,
t0 . isFreeForCommunity AS isFreeForCommunity_48 ,
t0 . registrationMode AS registrationMode_49 ,
t0 . externalRegistrationUrl AS externalRegistrationUrl_50 ,
t0 . externalPlatform AS externalPlatform_51 ,
t0 . registrationHeadline AS registrationHeadline_52 ,
t0 . registrationSubtitle AS registrationSubtitle_53 ,
t0 . registrationButtonText AS registrationButtonText_54 ,
t0 . registrationRedirectUrl AS registrationRedirectUrl_55 ,
t0 . lumaEventApiId AS lumaEventApiId_56 ,
t0 . meetupEventId AS meetupEventId_57 ,
t0 . meetupEventUrl AS meetupEventUrl_58 ,
t0 . mailDesignTemplate AS mailDesignTemplate_59 ,
t0 . senderMail AS senderMail_60 ,
t0 . fromName AS fromName_61 ,
t0 . recipientMonitoringMail AS recipientMonitoringMail_62 ,
t0 . confirmationMailSubject AS confirmationMailSubject_63 ,
t0 . confirmationMailContent AS confirmationMailContent_64 ,
t0 . adminNotificationMailSubject AS adminNotificationMailSubject_65 ,
t0 . adminNotificationMailContent AS adminNotificationMailContent_66 ,
t0 . reminderMailTemplateId AS reminderMailTemplateId_67 ,
t0 . reminderSenderEmail AS reminderSenderEmail_68 ,
t0 . reminderBulkMailId AS reminderBulkMailId_69 ,
t0 . reminderMailSendDate AS reminderMailSendDate_70 ,
t0 . reminderMailSubject AS reminderMailSubject_71 ,
t0 . reminderMailContent AS reminderMailContent_72 ,
t0 . $reminderMailStatus AS reminderMailStatus_73 ,
t0 . surveyId AS surveyId_74 ,
t0 . surveyMailTemplateId AS surveyMailTemplateId_75 ,
t0 . surveyBulkMailId AS surveyBulkMailId_76 ,
t0 . template AS template_77 ,
t0 . pageTemplate AS pageTemplate_78 ,
t0 . footerTemplate AS footerTemplate_79 ,
t0 . email AS email_80 ,
t0 . emailSubject AS emailSubject_81 ,
t0 . emailContent AS emailContent_82 ,
t0 . landingPageContent AS landingPageContent_83 ,
t0 . landingPageDescription AS landingPageDescription_84 ,
t0 . landingPageCss AS landingPageCss_85 ,
t0 . landingPageJs AS landingPageJs_86 ,
t0 . landingPageFooterTemplate AS landingPageFooterTemplate_87 ,
t0 . landingPageSocialImage AS landingPageSocialImage_88 ,
t0 . hasCustomPage AS hasCustomPage_89 ,
t0 . landingPageTitle AS landingPageTitle_90 ,
t0 . landingPageTwig AS landingPageTwig_91 ,
t0 . goToPage AS goToPage_92 ,
t0 . phrasesDe AS phrasesDe_93 ,
t0 . phrasesEn AS phrasesEn_94 ,
t0 . settings AS settings_95 ,
t0 . capacity AS capacity_96 ,
t0 . asssesmentDimensions AS asssesmentDimensions_97 ,
t0 . start AS start_98 ,
t0 . end AS end_99 ,
t0 . pitchTopic AS pitchTopic_100 ,
t0 . pitchImageLink AS pitchImageLink_101 ,
t0 . pitchVideoLink AS pitchVideoLink_102 ,
t0 . pitchPartner AS pitchPartner_103 ,
t0 . pitchPartnerId AS pitchPartnerId_104 ,
t0 . pitchDescription AS pitchDescription_105 ,
t0 . followUpPageContent AS followUpPageContent_106 ,
t0 . followUpPageDescription AS followUpPageDescription_107 ,
t0 . followUpPageCss AS followUpPageCss_108 ,
t0 . followUpPageJs AS followUpPageJs_109 ,
t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_110 ,
t0 . followUpPageTitle AS followUpPageTitle_111 ,
t0 . followUpPageSocialImage AS followUpPageSocialImage_112 ,
t0 . followUpDescription AS followUpDescription_113 ,
t0 . followUpVideoLink AS followUpVideoLink_114 ,
t0 . followUpPresentation AS followUpPresentation_115 ,
t0 . followUpSkoolUrl AS followUpSkoolUrl_116 ,
t0 . followUpWhatsAppUrl AS followUpWhatsAppUrl_117 ,
t0 . followUpCtaText AS followUpCtaText_118 ,
t0 . followUpCtaUrl AS followUpCtaUrl_119 ,
t0 . followUpDocuments AS followUpDocuments_120 ,
t0 . followUpPhotos AS followUpPhotos_121 ,
t0 . followUpExtraLinks AS followUpExtraLinks_122 ,
t0 . followUpChecklist AS followUpChecklist_123 ,
t0 . pitchDate AS pitchDate_124 ,
t0 . pitchTime AS pitchTime_125 ,
t0 . prepitchDate AS prepitchDate_126 ,
t0 . city AS city_127 ,
t0 . applicationsCount AS applicationsCount_128 ,
t0 . startedCount AS startedCount_129 ,
t0 . appliedCount AS appliedCount_130 ,
t0 . approvedCount AS approvedCount_131 ,
t0 . rejectedCount AS rejectedCount_132 ,
t0 . $skoolWebhook AS skoolWebhook_133 ,
t0 . zapierWebhook AS zapierWebhook_134 ,
t0 . history AS history_135 ,
t0 . createdAt AS createdAt_136 ,
t0 . lastModified AS lastModified_137 ,
t0 . lastChangeUser AS lastChangeUser_138 ,
t0 . program_id AS program_id_139 ,
t0 . assessmentTeamId AS assessmentTeamId_140
FROM
sp_batches t0
WHERE
t0 . programId = ?
AND t0 . eventId = ?
AND t0 . status = ?
AND t0 . access = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . programId AS programId_2 , t0 . eventId AS eventId_3 , t0 . productId AS productId_4 , t0 . batchNumber AS batchNumber_5 , t0 . url AS url_6 , t0 . name AS name_7 , t0 . slug AS slug_8 , t0 . alias AS alias_9 , t0 . status AS status_10 , t0 . focusStatus AS focusStatus_11 , t0 . lang AS lang_12 , t0 . priceInEuroCent AS priceInEuroCent_13 , t0 . isTaxIncluded AS isTaxIncluded_14 , t0 . discount100MemberTags AS discount100MemberTags_15 , t0 . discount50MemberTags AS discount50MemberTags_16 , t0 . discount20MemberTags AS discount20MemberTags_17 , t0 . askForTeam AS askForTeam_18 , t0 . hasEvent AS hasEvent_19 , t0 . hasIncludeNewsletterPermission AS hasIncludeNewsletterPermission_20 , t0 . hasIncludeTermsConsent AS hasIncludeTermsConsent_21 , t0 . hasIncludeLinkedIn AS hasIncludeLinkedIn_22 , t0 . hasIncludePhone AS hasIncludePhone_23 , t0 . hasFollowUp AS hasFollowUp_24 , t0 . isNetworking AS isNetworking_25 , t0 . networkingRounds AS networkingRounds_26 , t0 . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_27 , t0 . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_28 , t0 . isFutureEvent AS isFutureEvent_29 , t0 . visibility AS visibility_30 , t0 . access AS access_31 , t0 . tags AS tags_32 , t0 . typeformLink AS typeformLink_33 , t0 . zoomLink AS zoomLink_34 , t0 . bgImageUrl AS bgImageUrl_35 , t0 . startDate AS startDate_36 , t0 . endDate AS endDate_37 , t0 . stripePriceId AS stripePriceId_38 , t0 . stripeProductId AS stripeProductId_39 , t0 . stripeAccount AS stripeAccount_40 , t0 . stripePriceIdLive AS stripePriceIdLive_41 , t0 . stripePriceIdTest AS stripePriceIdTest_42 , t0 . stripeProductIdLive AS stripeProductIdLive_43 , t0 . stripeProductIdTest AS stripeProductIdTest_44 , t0 . taxBehavior AS taxBehavior_45 , t0 . paymentProvider AS paymentProvider_46 , t0 . isFreeForKiCampus AS isFreeForKiCampus_47 , t0 . isFreeForCommunity AS isFreeForCommunity_48 , t0 . registrationMode AS registrationMode_49 , t0 . externalRegistrationUrl AS externalRegistrationUrl_50 , t0 . externalPlatform AS externalPlatform_51 , t0 . registrationHeadline AS registrationHeadline_52 , t0 . registrationSubtitle AS registrationSubtitle_53 , t0 . registrationButtonText AS registrationButtonText_54 , t0 . registrationRedirectUrl AS registrationRedirectUrl_55 , t0 . lumaEventApiId AS lumaEventApiId_56 , t0 . meetupEventId AS meetupEventId_57 , t0 . meetupEventUrl AS meetupEventUrl_58 , t0 . mailDesignTemplate AS mailDesignTemplate_59 , t0 . senderMail AS senderMail_60 , t0 . fromName AS fromName_61 , t0 . recipientMonitoringMail AS recipientMonitoringMail_62 , t0 . confirmationMailSubject AS confirmationMailSubject_63 , t0 . confirmationMailContent AS confirmationMailContent_64 , t0 . adminNotificationMailSubject AS adminNotificationMailSubject_65 , t0 . adminNotificationMailContent AS adminNotificationMailContent_66 , t0 . reminderMailTemplateId AS reminderMailTemplateId_67 , t0 . reminderSenderEmail AS reminderSenderEmail_68 , t0 . reminderBulkMailId AS reminderBulkMailId_69 , t0 . reminderMailSendDate AS reminderMailSendDate_70 , t0 . reminderMailSubject AS reminderMailSubject_71 , t0 . reminderMailContent AS reminderMailContent_72 , t0 . $reminderMailStatus AS reminderMailStatus_73 , t0 . surveyId AS surveyId_74 , t0 . surveyMailTemplateId AS surveyMailTemplateId_75 , t0 . surveyBulkMailId AS surveyBulkMailId_76 , t0 . template AS template_77 , t0 . pageTemplate AS pageTemplate_78 , t0 . footerTemplate AS footerTemplate_79 , t0 . email AS email_80 , t0 . emailSubject AS emailSubject_81 , t0 . emailContent AS emailContent_82 , t0 . landingPageContent AS landingPageContent_83 , t0 . landingPageDescription AS landingPageDescription_84 , t0 . landingPageCss AS landingPageCss_85 , t0 . landingPageJs AS landingPageJs_86 , t0 . landingPageFooterTemplate AS landingPageFooterTemplate_87 , t0 . landingPageSocialImage AS landingPageSocialImage_88 , t0 . hasCustomPage AS hasCustomPage_89 , t0 . landingPageTitle AS landingPageTitle_90 , t0 . landingPageTwig AS landingPageTwig_91 , t0 . goToPage AS goToPage_92 , t0 . phrasesDe AS phrasesDe_93 , t0 . phrasesEn AS phrasesEn_94 , t0 . settings AS settings_95 , t0 . capacity AS capacity_96 , t0 . asssesmentDimensions AS asssesmentDimensions_97 , t0 . start AS start_98 , t0 . end AS end_99 , t0 . pitchTopic AS pitchTopic_100 , t0 . pitchImageLink AS pitchImageLink_101 , t0 . pitchVideoLink AS pitchVideoLink_102 , t0 . pitchPartner AS pitchPartner_103 , t0 . pitchPartnerId AS pitchPartnerId_104 , t0 . pitchDescription AS pitchDescription_105 , t0 . followUpPageContent AS followUpPageContent_106 , t0 . followUpPageDescription AS followUpPageDescription_107 , t0 . followUpPageCss AS followUpPageCss_108 , t0 . followUpPageJs AS followUpPageJs_109 , t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_110 , t0 . followUpPageTitle AS followUpPageTitle_111 , t0 . followUpPageSocialImage AS followUpPageSocialImage_112 , t0 . followUpDescription AS followUpDescription_113 , t0 . followUpVideoLink AS followUpVideoLink_114 , t0 . followUpPresentation AS followUpPresentation_115 , t0 . followUpSkoolUrl AS followUpSkoolUrl_116 , t0 . followUpWhatsAppUrl AS followUpWhatsAppUrl_117 , t0 . followUpCtaText AS followUpCtaText_118 , t0 . followUpCtaUrl AS followUpCtaUrl_119 , t0 . followUpDocuments AS followUpDocuments_120 , t0 . followUpPhotos AS followUpPhotos_121 , t0 . followUpExtraLinks AS followUpExtraLinks_122 , t0 . followUpChecklist AS followUpChecklist_123 , t0 . pitchDate AS pitchDate_124 , t0 . pitchTime AS pitchTime_125 , t0 . prepitchDate AS prepitchDate_126 , t0 . city AS city_127 , t0 . applicationsCount AS applicationsCount_128 , t0 . startedCount AS startedCount_129 , t0 . appliedCount AS appliedCount_130 , t0 . approvedCount AS approvedCount_131 , t0 . rejectedCount AS rejectedCount_132 , t0 . $skoolWebhook AS skoolWebhook_133 , t0 . zapierWebhook AS zapierWebhook_134 , t0 . history AS history_135 , t0 . createdAt AS createdAt_136 , t0 . lastModified AS lastModified_137 , t0 . lastChangeUser AS lastChangeUser_138 , t0 . program_id AS program_id_139 , t0 . assessmentTeamId AS assessmentTeamId_140 FROM sp_batches t0 WHERE t0 . programId = 27 AND t0 . eventId = 6839 AND t0 . status = 'completed' AND t0 . access = 'anonymous' LIMIT 1 ;
Copy
5
0.53 ms
SELECT t0 . id AS id_1 , t0 . spMemberId AS spMemberId_2 , t0 . score AS score_3 , t0 . completenessScore AS completenessScore_4 , t0 . status AS status_5 , t0 . location AS location_6 , t0 . salutation AS salutation_7 , t0 . title AS title_8 , t0 . jobTitle AS jobTitle_9 , t0 . firstName AS firstName_10 , t0 . lastName AS lastName_11 , t0 . name AS name_12 , t0 . sortName AS sortName_13 , t0 . email AS email_14 , t0 . secondaryEmail AS secondaryEmail_15 , t0 . phone AS phone_16 , t0 . hasCommunityMembership AS hasCommunityMembership_17 , t0 . aiMemberValid AS aiMemberValid_18 , t0 . aiMemberStatus AS aiMemberStatus_19 , t0 . aiMemberReason AS aiMemberReason_20 , t0 . aiMemberStart AS aiMemberStart_21 , t0 . aiMemberEnd AS aiMemberEnd_22 , t0 . utm_source AS utm_source_23 , t0 . utm_medium AS utm_medium_24 , t0 . utm_campaign AS utm_campaign_25 , t0 . utm_term AS utm_term_26 , t0 . utm_content AS utm_content_27 , t0 . birthday AS birthday_28 , t0 . addressFieldOne AS addressFieldOne_29 , t0 . addressFieldTwo AS addressFieldTwo_30 , t0 . addressCountryCode AS addressCountryCode_31 , t0 . addressPostalCode AS addressPostalCode_32 , t0 . addressCity AS addressCity_33 , t0 . teamId AS teamId_34 , t0 . teamName AS teamName_35 , t0 . company AS company_36 , t0 . history AS history_37 , t0 . tags AS tags_38 , t0 . annotation AS annotation_39 , t0 . mentorBuckets AS mentorBuckets_40 , t0 . areasOfExpertise AS areasOfExpertise_41 , t0 . mentor_firma AS mentor_firma_42 , t0 . mentor_firma_url AS mentor_firma_url_43 , t0 . mentor_locations AS mentor_locations_44 , t0 . mentor_profile AS mentor_profile_45 , t0 . mentor_note AS mentor_note_46 , t0 . mentor_admin_rating AS mentor_admin_rating_47 , t0 . active AS active_48 , t0 . tiefgarage AS tiefgarage_49 , t0 . transponder AS transponder_50 , t0 . isTransponderAllowed AS isTransponderAllowed_51 , t0 . imageLink AS imageLink_52 , t0 . homepage AS homepage_53 , t0 . xing AS xing_54 , t0 . pipedriveId AS pipedriveId_55 , t0 . linkedin AS linkedin_56 , t0 . facebook AS facebook_57 , t0 . instagram AS instagram_58 , t0 . twitter AS twitter_59 , t0 . skills AS skills_60 , t0 . description AS description_61 , t0 . touchpoints AS touchpoints_62 , t0 . isAddressComplete AS isAddressComplete_63 , t0 . hasMailchimp AS hasMailchimp_64 , t0 . hasKiNewsletter AS hasKiNewsletter_65 , t0 . hubspotSyncPending AS hubspotSyncPending_66 , t0 . enterDate AS enterDate_67 , t0 . exitDate AS exitDate_68 , t0 . physicalMembershipStarted AS physicalMembershipStarted_69 , t0 . physicalMembershipEnded AS physicalMembershipEnded_70 , t0 . lastModified AS lastModified_71 , t0 . lastChangeUser AS lastChangeUser_72 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 , t0 . nAiEventsAttended AS nAiEventsAttended_75 , t0 . nAiEventsApplied AS nAiEventsApplied_76 , t0 . nPaidAttended AS nPaidAttended_77 , t0 . nPaidApplied AS nPaidApplied_78 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 , t0 . nBbqApplied AS nBbqApplied_85 , t0 . nAiFridayApplied AS nAiFridayApplied_86 , t0 . nAiGatheringApplied AS nAiGatheringApplied_87 , t0 . nAiGatheringAttended AS nAiGatheringAttended_88 , t0 . aiSs24Applied AS aiSs24Applied_89 , t0 . aiSs24Booked AS aiSs24Booked_90 , t0 . interestedIn AS interestedIn_91 , t0 . interests AS interests_92 , t0 . mentorMetadata AS mentorMetadata_93 , t0 . eventParticipations AS eventParticipations_94 , t0 . kiKompetenz AS kiKompetenz_95 , t0 . mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . spMemberId AS spMemberId_2 ,
t0 . score AS score_3 ,
t0 . completenessScore AS completenessScore_4 ,
t0 . status AS status_5 ,
t0 . location AS location_6 ,
t0 . salutation AS salutation_7 ,
t0 . title AS title_8 ,
t0 . jobTitle AS jobTitle_9 ,
t0 . firstName AS firstName_10 ,
t0 . lastName AS lastName_11 ,
t0 . name AS name_12 ,
t0 . sortName AS sortName_13 ,
t0 . email AS email_14 ,
t0 . secondaryEmail AS secondaryEmail_15 ,
t0 . phone AS phone_16 ,
t0 . hasCommunityMembership AS hasCommunityMembership_17 ,
t0 . aiMemberValid AS aiMemberValid_18 ,
t0 . aiMemberStatus AS aiMemberStatus_19 ,
t0 . aiMemberReason AS aiMemberReason_20 ,
t0 . aiMemberStart AS aiMemberStart_21 ,
t0 . aiMemberEnd AS aiMemberEnd_22 ,
t0 . utm_source AS utm_source_23 ,
t0 . utm_medium AS utm_medium_24 ,
t0 . utm_campaign AS utm_campaign_25 ,
t0 . utm_term AS utm_term_26 ,
t0 . utm_content AS utm_content_27 ,
t0 . birthday AS birthday_28 ,
t0 . addressFieldOne AS addressFieldOne_29 ,
t0 . addressFieldTwo AS addressFieldTwo_30 ,
t0 . addressCountryCode AS addressCountryCode_31 ,
t0 . addressPostalCode AS addressPostalCode_32 ,
t0 . addressCity AS addressCity_33 ,
t0 . teamId AS teamId_34 ,
t0 . teamName AS teamName_35 ,
t0 . company AS company_36 ,
t0 . history AS history_37 ,
t0 . tags AS tags_38 ,
t0 . annotation AS annotation_39 ,
t0 . mentorBuckets AS mentorBuckets_40 ,
t0 . areasOfExpertise AS areasOfExpertise_41 ,
t0 . mentor_firma AS mentor_firma_42 ,
t0 . mentor_firma_url AS mentor_firma_url_43 ,
t0 . mentor_locations AS mentor_locations_44 ,
t0 . mentor_profile AS mentor_profile_45 ,
t0 . mentor_note AS mentor_note_46 ,
t0 . mentor_admin_rating AS mentor_admin_rating_47 ,
t0 . active AS active_48 ,
t0 . tiefgarage AS tiefgarage_49 ,
t0 . transponder AS transponder_50 ,
t0 . isTransponderAllowed AS isTransponderAllowed_51 ,
t0 . imageLink AS imageLink_52 ,
t0 . homepage AS homepage_53 ,
t0 . xing AS xing_54 ,
t0 . pipedriveId AS pipedriveId_55 ,
t0 . linkedin AS linkedin_56 ,
t0 . facebook AS facebook_57 ,
t0 . instagram AS instagram_58 ,
t0 . twitter AS twitter_59 ,
t0 . skills AS skills_60 ,
t0 . description AS description_61 ,
t0 . touchpoints AS touchpoints_62 ,
t0 . isAddressComplete AS isAddressComplete_63 ,
t0 . hasMailchimp AS hasMailchimp_64 ,
t0 . hasKiNewsletter AS hasKiNewsletter_65 ,
t0 . hubspotSyncPending AS hubspotSyncPending_66 ,
t0 . enterDate AS enterDate_67 ,
t0 . exitDate AS exitDate_68 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_69 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_70 ,
t0 . lastModified AS lastModified_71 ,
t0 . lastChangeUser AS lastChangeUser_72 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 ,
t0 . nAiEventsAttended AS nAiEventsAttended_75 ,
t0 . nAiEventsApplied AS nAiEventsApplied_76 ,
t0 . nPaidAttended AS nPaidAttended_77 ,
t0 . nPaidApplied AS nPaidApplied_78 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 ,
t0 . nBbqApplied AS nBbqApplied_85 ,
t0 . nAiFridayApplied AS nAiFridayApplied_86 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_87 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_88 ,
t0 . aiSs24Applied AS aiSs24Applied_89 ,
t0 . aiSs24Booked AS aiSs24Booked_90 ,
t0 . interestedIn AS interestedIn_91 ,
t0 . interests AS interests_92 ,
t0 . mentorMetadata AS mentorMetadata_93 ,
t0 . eventParticipations AS eventParticipations_94 ,
t0 . kiKompetenz AS kiKompetenz_95 ,
t0 . mentorOwnerId AS mentorOwnerId_96
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . spMemberId AS spMemberId_2 , t0 . score AS score_3 , t0 . completenessScore AS completenessScore_4 , t0 . status AS status_5 , t0 . location AS location_6 , t0 . salutation AS salutation_7 , t0 . title AS title_8 , t0 . jobTitle AS jobTitle_9 , t0 . firstName AS firstName_10 , t0 . lastName AS lastName_11 , t0 . name AS name_12 , t0 . sortName AS sortName_13 , t0 . email AS email_14 , t0 . secondaryEmail AS secondaryEmail_15 , t0 . phone AS phone_16 , t0 . hasCommunityMembership AS hasCommunityMembership_17 , t0 . aiMemberValid AS aiMemberValid_18 , t0 . aiMemberStatus AS aiMemberStatus_19 , t0 . aiMemberReason AS aiMemberReason_20 , t0 . aiMemberStart AS aiMemberStart_21 , t0 . aiMemberEnd AS aiMemberEnd_22 , t0 . utm_source AS utm_source_23 , t0 . utm_medium AS utm_medium_24 , t0 . utm_campaign AS utm_campaign_25 , t0 . utm_term AS utm_term_26 , t0 . utm_content AS utm_content_27 , t0 . birthday AS birthday_28 , t0 . addressFieldOne AS addressFieldOne_29 , t0 . addressFieldTwo AS addressFieldTwo_30 , t0 . addressCountryCode AS addressCountryCode_31 , t0 . addressPostalCode AS addressPostalCode_32 , t0 . addressCity AS addressCity_33 , t0 . teamId AS teamId_34 , t0 . teamName AS teamName_35 , t0 . company AS company_36 , t0 . history AS history_37 , t0 . tags AS tags_38 , t0 . annotation AS annotation_39 , t0 . mentorBuckets AS mentorBuckets_40 , t0 . areasOfExpertise AS areasOfExpertise_41 , t0 . mentor_firma AS mentor_firma_42 , t0 . mentor_firma_url AS mentor_firma_url_43 , t0 . mentor_locations AS mentor_locations_44 , t0 . mentor_profile AS mentor_profile_45 , t0 . mentor_note AS mentor_note_46 , t0 . mentor_admin_rating AS mentor_admin_rating_47 , t0 . active AS active_48 , t0 . tiefgarage AS tiefgarage_49 , t0 . transponder AS transponder_50 , t0 . isTransponderAllowed AS isTransponderAllowed_51 , t0 . imageLink AS imageLink_52 , t0 . homepage AS homepage_53 , t0 . xing AS xing_54 , t0 . pipedriveId AS pipedriveId_55 , t0 . linkedin AS linkedin_56 , t0 . facebook AS facebook_57 , t0 . instagram AS instagram_58 , t0 . twitter AS twitter_59 , t0 . skills AS skills_60 , t0 . description AS description_61 , t0 . touchpoints AS touchpoints_62 , t0 . isAddressComplete AS isAddressComplete_63 , t0 . hasMailchimp AS hasMailchimp_64 , t0 . hasKiNewsletter AS hasKiNewsletter_65 , t0 . hubspotSyncPending AS hubspotSyncPending_66 , t0 . enterDate AS enterDate_67 , t0 . exitDate AS exitDate_68 , t0 . physicalMembershipStarted AS physicalMembershipStarted_69 , t0 . physicalMembershipEnded AS physicalMembershipEnded_70 , t0 . lastModified AS lastModified_71 , t0 . lastChangeUser AS lastChangeUser_72 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 , t0 . nAiEventsAttended AS nAiEventsAttended_75 , t0 . nAiEventsApplied AS nAiEventsApplied_76 , t0 . nPaidAttended AS nPaidAttended_77 , t0 . nPaidApplied AS nPaidApplied_78 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 , t0 . nBbqApplied AS nBbqApplied_85 , t0 . nAiFridayApplied AS nAiFridayApplied_86 , t0 . nAiGatheringApplied AS nAiGatheringApplied_87 , t0 . nAiGatheringAttended AS nAiGatheringAttended_88 , t0 . aiSs24Applied AS aiSs24Applied_89 , t0 . aiSs24Booked AS aiSs24Booked_90 , t0 . interestedIn AS interestedIn_91 , t0 . interests AS interests_92 , t0 . mentorMetadata AS mentorMetadata_93 , t0 . eventParticipations AS eventParticipations_94 , t0 . kiKompetenz AS kiKompetenz_95 , t0 . mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0 . id = '80488' ;
Copy
6
0.45 ms
SELECT t0 . id AS id_1 , t0 . spMemberId AS spMemberId_2 , t0 . score AS score_3 , t0 . completenessScore AS completenessScore_4 , t0 . status AS status_5 , t0 . location AS location_6 , t0 . salutation AS salutation_7 , t0 . title AS title_8 , t0 . jobTitle AS jobTitle_9 , t0 . firstName AS firstName_10 , t0 . lastName AS lastName_11 , t0 . name AS name_12 , t0 . sortName AS sortName_13 , t0 . email AS email_14 , t0 . secondaryEmail AS secondaryEmail_15 , t0 . phone AS phone_16 , t0 . hasCommunityMembership AS hasCommunityMembership_17 , t0 . aiMemberValid AS aiMemberValid_18 , t0 . aiMemberStatus AS aiMemberStatus_19 , t0 . aiMemberReason AS aiMemberReason_20 , t0 . aiMemberStart AS aiMemberStart_21 , t0 . aiMemberEnd AS aiMemberEnd_22 , t0 . utm_source AS utm_source_23 , t0 . utm_medium AS utm_medium_24 , t0 . utm_campaign AS utm_campaign_25 , t0 . utm_term AS utm_term_26 , t0 . utm_content AS utm_content_27 , t0 . birthday AS birthday_28 , t0 . addressFieldOne AS addressFieldOne_29 , t0 . addressFieldTwo AS addressFieldTwo_30 , t0 . addressCountryCode AS addressCountryCode_31 , t0 . addressPostalCode AS addressPostalCode_32 , t0 . addressCity AS addressCity_33 , t0 . teamId AS teamId_34 , t0 . teamName AS teamName_35 , t0 . company AS company_36 , t0 . history AS history_37 , t0 . tags AS tags_38 , t0 . annotation AS annotation_39 , t0 . mentorBuckets AS mentorBuckets_40 , t0 . areasOfExpertise AS areasOfExpertise_41 , t0 . mentor_firma AS mentor_firma_42 , t0 . mentor_firma_url AS mentor_firma_url_43 , t0 . mentor_locations AS mentor_locations_44 , t0 . mentor_profile AS mentor_profile_45 , t0 . mentor_note AS mentor_note_46 , t0 . mentor_admin_rating AS mentor_admin_rating_47 , t0 . active AS active_48 , t0 . tiefgarage AS tiefgarage_49 , t0 . transponder AS transponder_50 , t0 . isTransponderAllowed AS isTransponderAllowed_51 , t0 . imageLink AS imageLink_52 , t0 . homepage AS homepage_53 , t0 . xing AS xing_54 , t0 . pipedriveId AS pipedriveId_55 , t0 . linkedin AS linkedin_56 , t0 . facebook AS facebook_57 , t0 . instagram AS instagram_58 , t0 . twitter AS twitter_59 , t0 . skills AS skills_60 , t0 . description AS description_61 , t0 . touchpoints AS touchpoints_62 , t0 . isAddressComplete AS isAddressComplete_63 , t0 . hasMailchimp AS hasMailchimp_64 , t0 . hasKiNewsletter AS hasKiNewsletter_65 , t0 . hubspotSyncPending AS hubspotSyncPending_66 , t0 . enterDate AS enterDate_67 , t0 . exitDate AS exitDate_68 , t0 . physicalMembershipStarted AS physicalMembershipStarted_69 , t0 . physicalMembershipEnded AS physicalMembershipEnded_70 , t0 . lastModified AS lastModified_71 , t0 . lastChangeUser AS lastChangeUser_72 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 , t0 . nAiEventsAttended AS nAiEventsAttended_75 , t0 . nAiEventsApplied AS nAiEventsApplied_76 , t0 . nPaidAttended AS nPaidAttended_77 , t0 . nPaidApplied AS nPaidApplied_78 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 , t0 . nBbqApplied AS nBbqApplied_85 , t0 . nAiFridayApplied AS nAiFridayApplied_86 , t0 . nAiGatheringApplied AS nAiGatheringApplied_87 , t0 . nAiGatheringAttended AS nAiGatheringAttended_88 , t0 . aiSs24Applied AS aiSs24Applied_89 , t0 . aiSs24Booked AS aiSs24Booked_90 , t0 . interestedIn AS interestedIn_91 , t0 . interests AS interests_92 , t0 . mentorMetadata AS mentorMetadata_93 , t0 . eventParticipations AS eventParticipations_94 , t0 . kiKompetenz AS kiKompetenz_95 , t0 . mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . spMemberId AS spMemberId_2 ,
t0 . score AS score_3 ,
t0 . completenessScore AS completenessScore_4 ,
t0 . status AS status_5 ,
t0 . location AS location_6 ,
t0 . salutation AS salutation_7 ,
t0 . title AS title_8 ,
t0 . jobTitle AS jobTitle_9 ,
t0 . firstName AS firstName_10 ,
t0 . lastName AS lastName_11 ,
t0 . name AS name_12 ,
t0 . sortName AS sortName_13 ,
t0 . email AS email_14 ,
t0 . secondaryEmail AS secondaryEmail_15 ,
t0 . phone AS phone_16 ,
t0 . hasCommunityMembership AS hasCommunityMembership_17 ,
t0 . aiMemberValid AS aiMemberValid_18 ,
t0 . aiMemberStatus AS aiMemberStatus_19 ,
t0 . aiMemberReason AS aiMemberReason_20 ,
t0 . aiMemberStart AS aiMemberStart_21 ,
t0 . aiMemberEnd AS aiMemberEnd_22 ,
t0 . utm_source AS utm_source_23 ,
t0 . utm_medium AS utm_medium_24 ,
t0 . utm_campaign AS utm_campaign_25 ,
t0 . utm_term AS utm_term_26 ,
t0 . utm_content AS utm_content_27 ,
t0 . birthday AS birthday_28 ,
t0 . addressFieldOne AS addressFieldOne_29 ,
t0 . addressFieldTwo AS addressFieldTwo_30 ,
t0 . addressCountryCode AS addressCountryCode_31 ,
t0 . addressPostalCode AS addressPostalCode_32 ,
t0 . addressCity AS addressCity_33 ,
t0 . teamId AS teamId_34 ,
t0 . teamName AS teamName_35 ,
t0 . company AS company_36 ,
t0 . history AS history_37 ,
t0 . tags AS tags_38 ,
t0 . annotation AS annotation_39 ,
t0 . mentorBuckets AS mentorBuckets_40 ,
t0 . areasOfExpertise AS areasOfExpertise_41 ,
t0 . mentor_firma AS mentor_firma_42 ,
t0 . mentor_firma_url AS mentor_firma_url_43 ,
t0 . mentor_locations AS mentor_locations_44 ,
t0 . mentor_profile AS mentor_profile_45 ,
t0 . mentor_note AS mentor_note_46 ,
t0 . mentor_admin_rating AS mentor_admin_rating_47 ,
t0 . active AS active_48 ,
t0 . tiefgarage AS tiefgarage_49 ,
t0 . transponder AS transponder_50 ,
t0 . isTransponderAllowed AS isTransponderAllowed_51 ,
t0 . imageLink AS imageLink_52 ,
t0 . homepage AS homepage_53 ,
t0 . xing AS xing_54 ,
t0 . pipedriveId AS pipedriveId_55 ,
t0 . linkedin AS linkedin_56 ,
t0 . facebook AS facebook_57 ,
t0 . instagram AS instagram_58 ,
t0 . twitter AS twitter_59 ,
t0 . skills AS skills_60 ,
t0 . description AS description_61 ,
t0 . touchpoints AS touchpoints_62 ,
t0 . isAddressComplete AS isAddressComplete_63 ,
t0 . hasMailchimp AS hasMailchimp_64 ,
t0 . hasKiNewsletter AS hasKiNewsletter_65 ,
t0 . hubspotSyncPending AS hubspotSyncPending_66 ,
t0 . enterDate AS enterDate_67 ,
t0 . exitDate AS exitDate_68 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_69 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_70 ,
t0 . lastModified AS lastModified_71 ,
t0 . lastChangeUser AS lastChangeUser_72 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 ,
t0 . nAiEventsAttended AS nAiEventsAttended_75 ,
t0 . nAiEventsApplied AS nAiEventsApplied_76 ,
t0 . nPaidAttended AS nPaidAttended_77 ,
t0 . nPaidApplied AS nPaidApplied_78 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 ,
t0 . nBbqApplied AS nBbqApplied_85 ,
t0 . nAiFridayApplied AS nAiFridayApplied_86 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_87 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_88 ,
t0 . aiSs24Applied AS aiSs24Applied_89 ,
t0 . aiSs24Booked AS aiSs24Booked_90 ,
t0 . interestedIn AS interestedIn_91 ,
t0 . interests AS interests_92 ,
t0 . mentorMetadata AS mentorMetadata_93 ,
t0 . eventParticipations AS eventParticipations_94 ,
t0 . kiKompetenz AS kiKompetenz_95 ,
t0 . mentorOwnerId AS mentorOwnerId_96
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . spMemberId AS spMemberId_2 , t0 . score AS score_3 , t0 . completenessScore AS completenessScore_4 , t0 . status AS status_5 , t0 . location AS location_6 , t0 . salutation AS salutation_7 , t0 . title AS title_8 , t0 . jobTitle AS jobTitle_9 , t0 . firstName AS firstName_10 , t0 . lastName AS lastName_11 , t0 . name AS name_12 , t0 . sortName AS sortName_13 , t0 . email AS email_14 , t0 . secondaryEmail AS secondaryEmail_15 , t0 . phone AS phone_16 , t0 . hasCommunityMembership AS hasCommunityMembership_17 , t0 . aiMemberValid AS aiMemberValid_18 , t0 . aiMemberStatus AS aiMemberStatus_19 , t0 . aiMemberReason AS aiMemberReason_20 , t0 . aiMemberStart AS aiMemberStart_21 , t0 . aiMemberEnd AS aiMemberEnd_22 , t0 . utm_source AS utm_source_23 , t0 . utm_medium AS utm_medium_24 , t0 . utm_campaign AS utm_campaign_25 , t0 . utm_term AS utm_term_26 , t0 . utm_content AS utm_content_27 , t0 . birthday AS birthday_28 , t0 . addressFieldOne AS addressFieldOne_29 , t0 . addressFieldTwo AS addressFieldTwo_30 , t0 . addressCountryCode AS addressCountryCode_31 , t0 . addressPostalCode AS addressPostalCode_32 , t0 . addressCity AS addressCity_33 , t0 . teamId AS teamId_34 , t0 . teamName AS teamName_35 , t0 . company AS company_36 , t0 . history AS history_37 , t0 . tags AS tags_38 , t0 . annotation AS annotation_39 , t0 . mentorBuckets AS mentorBuckets_40 , t0 . areasOfExpertise AS areasOfExpertise_41 , t0 . mentor_firma AS mentor_firma_42 , t0 . mentor_firma_url AS mentor_firma_url_43 , t0 . mentor_locations AS mentor_locations_44 , t0 . mentor_profile AS mentor_profile_45 , t0 . mentor_note AS mentor_note_46 , t0 . mentor_admin_rating AS mentor_admin_rating_47 , t0 . active AS active_48 , t0 . tiefgarage AS tiefgarage_49 , t0 . transponder AS transponder_50 , t0 . isTransponderAllowed AS isTransponderAllowed_51 , t0 . imageLink AS imageLink_52 , t0 . homepage AS homepage_53 , t0 . xing AS xing_54 , t0 . pipedriveId AS pipedriveId_55 , t0 . linkedin AS linkedin_56 , t0 . facebook AS facebook_57 , t0 . instagram AS instagram_58 , t0 . twitter AS twitter_59 , t0 . skills AS skills_60 , t0 . description AS description_61 , t0 . touchpoints AS touchpoints_62 , t0 . isAddressComplete AS isAddressComplete_63 , t0 . hasMailchimp AS hasMailchimp_64 , t0 . hasKiNewsletter AS hasKiNewsletter_65 , t0 . hubspotSyncPending AS hubspotSyncPending_66 , t0 . enterDate AS enterDate_67 , t0 . exitDate AS exitDate_68 , t0 . physicalMembershipStarted AS physicalMembershipStarted_69 , t0 . physicalMembershipEnded AS physicalMembershipEnded_70 , t0 . lastModified AS lastModified_71 , t0 . lastChangeUser AS lastChangeUser_72 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 , t0 . nAiEventsAttended AS nAiEventsAttended_75 , t0 . nAiEventsApplied AS nAiEventsApplied_76 , t0 . nPaidAttended AS nPaidAttended_77 , t0 . nPaidApplied AS nPaidApplied_78 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 , t0 . nBbqApplied AS nBbqApplied_85 , t0 . nAiFridayApplied AS nAiFridayApplied_86 , t0 . nAiGatheringApplied AS nAiGatheringApplied_87 , t0 . nAiGatheringAttended AS nAiGatheringAttended_88 , t0 . aiSs24Applied AS aiSs24Applied_89 , t0 . aiSs24Booked AS aiSs24Booked_90 , t0 . interestedIn AS interestedIn_91 , t0 . interests AS interests_92 , t0 . mentorMetadata AS mentorMetadata_93 , t0 . eventParticipations AS eventParticipations_94 , t0 . kiKompetenz AS kiKompetenz_95 , t0 . mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0 . id = '80487' ;
Copy
7
0.41 ms
SELECT t0 . id AS id_1 , t0 . spMemberId AS spMemberId_2 , t0 . score AS score_3 , t0 . completenessScore AS completenessScore_4 , t0 . status AS status_5 , t0 . location AS location_6 , t0 . salutation AS salutation_7 , t0 . title AS title_8 , t0 . jobTitle AS jobTitle_9 , t0 . firstName AS firstName_10 , t0 . lastName AS lastName_11 , t0 . name AS name_12 , t0 . sortName AS sortName_13 , t0 . email AS email_14 , t0 . secondaryEmail AS secondaryEmail_15 , t0 . phone AS phone_16 , t0 . hasCommunityMembership AS hasCommunityMembership_17 , t0 . aiMemberValid AS aiMemberValid_18 , t0 . aiMemberStatus AS aiMemberStatus_19 , t0 . aiMemberReason AS aiMemberReason_20 , t0 . aiMemberStart AS aiMemberStart_21 , t0 . aiMemberEnd AS aiMemberEnd_22 , t0 . utm_source AS utm_source_23 , t0 . utm_medium AS utm_medium_24 , t0 . utm_campaign AS utm_campaign_25 , t0 . utm_term AS utm_term_26 , t0 . utm_content AS utm_content_27 , t0 . birthday AS birthday_28 , t0 . addressFieldOne AS addressFieldOne_29 , t0 . addressFieldTwo AS addressFieldTwo_30 , t0 . addressCountryCode AS addressCountryCode_31 , t0 . addressPostalCode AS addressPostalCode_32 , t0 . addressCity AS addressCity_33 , t0 . teamId AS teamId_34 , t0 . teamName AS teamName_35 , t0 . company AS company_36 , t0 . history AS history_37 , t0 . tags AS tags_38 , t0 . annotation AS annotation_39 , t0 . mentorBuckets AS mentorBuckets_40 , t0 . areasOfExpertise AS areasOfExpertise_41 , t0 . mentor_firma AS mentor_firma_42 , t0 . mentor_firma_url AS mentor_firma_url_43 , t0 . mentor_locations AS mentor_locations_44 , t0 . mentor_profile AS mentor_profile_45 , t0 . mentor_note AS mentor_note_46 , t0 . mentor_admin_rating AS mentor_admin_rating_47 , t0 . active AS active_48 , t0 . tiefgarage AS tiefgarage_49 , t0 . transponder AS transponder_50 , t0 . isTransponderAllowed AS isTransponderAllowed_51 , t0 . imageLink AS imageLink_52 , t0 . homepage AS homepage_53 , t0 . xing AS xing_54 , t0 . pipedriveId AS pipedriveId_55 , t0 . linkedin AS linkedin_56 , t0 . facebook AS facebook_57 , t0 . instagram AS instagram_58 , t0 . twitter AS twitter_59 , t0 . skills AS skills_60 , t0 . description AS description_61 , t0 . touchpoints AS touchpoints_62 , t0 . isAddressComplete AS isAddressComplete_63 , t0 . hasMailchimp AS hasMailchimp_64 , t0 . hasKiNewsletter AS hasKiNewsletter_65 , t0 . hubspotSyncPending AS hubspotSyncPending_66 , t0 . enterDate AS enterDate_67 , t0 . exitDate AS exitDate_68 , t0 . physicalMembershipStarted AS physicalMembershipStarted_69 , t0 . physicalMembershipEnded AS physicalMembershipEnded_70 , t0 . lastModified AS lastModified_71 , t0 . lastChangeUser AS lastChangeUser_72 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 , t0 . nAiEventsAttended AS nAiEventsAttended_75 , t0 . nAiEventsApplied AS nAiEventsApplied_76 , t0 . nPaidAttended AS nPaidAttended_77 , t0 . nPaidApplied AS nPaidApplied_78 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 , t0 . nBbqApplied AS nBbqApplied_85 , t0 . nAiFridayApplied AS nAiFridayApplied_86 , t0 . nAiGatheringApplied AS nAiGatheringApplied_87 , t0 . nAiGatheringAttended AS nAiGatheringAttended_88 , t0 . aiSs24Applied AS aiSs24Applied_89 , t0 . aiSs24Booked AS aiSs24Booked_90 , t0 . interestedIn AS interestedIn_91 , t0 . interests AS interests_92 , t0 . mentorMetadata AS mentorMetadata_93 , t0 . eventParticipations AS eventParticipations_94 , t0 . kiKompetenz AS kiKompetenz_95 , t0 . mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . spMemberId AS spMemberId_2 ,
t0 . score AS score_3 ,
t0 . completenessScore AS completenessScore_4 ,
t0 . status AS status_5 ,
t0 . location AS location_6 ,
t0 . salutation AS salutation_7 ,
t0 . title AS title_8 ,
t0 . jobTitle AS jobTitle_9 ,
t0 . firstName AS firstName_10 ,
t0 . lastName AS lastName_11 ,
t0 . name AS name_12 ,
t0 . sortName AS sortName_13 ,
t0 . email AS email_14 ,
t0 . secondaryEmail AS secondaryEmail_15 ,
t0 . phone AS phone_16 ,
t0 . hasCommunityMembership AS hasCommunityMembership_17 ,
t0 . aiMemberValid AS aiMemberValid_18 ,
t0 . aiMemberStatus AS aiMemberStatus_19 ,
t0 . aiMemberReason AS aiMemberReason_20 ,
t0 . aiMemberStart AS aiMemberStart_21 ,
t0 . aiMemberEnd AS aiMemberEnd_22 ,
t0 . utm_source AS utm_source_23 ,
t0 . utm_medium AS utm_medium_24 ,
t0 . utm_campaign AS utm_campaign_25 ,
t0 . utm_term AS utm_term_26 ,
t0 . utm_content AS utm_content_27 ,
t0 . birthday AS birthday_28 ,
t0 . addressFieldOne AS addressFieldOne_29 ,
t0 . addressFieldTwo AS addressFieldTwo_30 ,
t0 . addressCountryCode AS addressCountryCode_31 ,
t0 . addressPostalCode AS addressPostalCode_32 ,
t0 . addressCity AS addressCity_33 ,
t0 . teamId AS teamId_34 ,
t0 . teamName AS teamName_35 ,
t0 . company AS company_36 ,
t0 . history AS history_37 ,
t0 . tags AS tags_38 ,
t0 . annotation AS annotation_39 ,
t0 . mentorBuckets AS mentorBuckets_40 ,
t0 . areasOfExpertise AS areasOfExpertise_41 ,
t0 . mentor_firma AS mentor_firma_42 ,
t0 . mentor_firma_url AS mentor_firma_url_43 ,
t0 . mentor_locations AS mentor_locations_44 ,
t0 . mentor_profile AS mentor_profile_45 ,
t0 . mentor_note AS mentor_note_46 ,
t0 . mentor_admin_rating AS mentor_admin_rating_47 ,
t0 . active AS active_48 ,
t0 . tiefgarage AS tiefgarage_49 ,
t0 . transponder AS transponder_50 ,
t0 . isTransponderAllowed AS isTransponderAllowed_51 ,
t0 . imageLink AS imageLink_52 ,
t0 . homepage AS homepage_53 ,
t0 . xing AS xing_54 ,
t0 . pipedriveId AS pipedriveId_55 ,
t0 . linkedin AS linkedin_56 ,
t0 . facebook AS facebook_57 ,
t0 . instagram AS instagram_58 ,
t0 . twitter AS twitter_59 ,
t0 . skills AS skills_60 ,
t0 . description AS description_61 ,
t0 . touchpoints AS touchpoints_62 ,
t0 . isAddressComplete AS isAddressComplete_63 ,
t0 . hasMailchimp AS hasMailchimp_64 ,
t0 . hasKiNewsletter AS hasKiNewsletter_65 ,
t0 . hubspotSyncPending AS hubspotSyncPending_66 ,
t0 . enterDate AS enterDate_67 ,
t0 . exitDate AS exitDate_68 ,
t0 . physicalMembershipStarted AS physicalMembershipStarted_69 ,
t0 . physicalMembershipEnded AS physicalMembershipEnded_70 ,
t0 . lastModified AS lastModified_71 ,
t0 . lastChangeUser AS lastChangeUser_72 ,
t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 ,
t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 ,
t0 . nAiEventsAttended AS nAiEventsAttended_75 ,
t0 . nAiEventsApplied AS nAiEventsApplied_76 ,
t0 . nPaidAttended AS nPaidAttended_77 ,
t0 . nPaidApplied AS nPaidApplied_78 ,
t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 ,
t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 ,
t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 ,
t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 ,
t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 ,
t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 ,
t0 . nBbqApplied AS nBbqApplied_85 ,
t0 . nAiFridayApplied AS nAiFridayApplied_86 ,
t0 . nAiGatheringApplied AS nAiGatheringApplied_87 ,
t0 . nAiGatheringAttended AS nAiGatheringAttended_88 ,
t0 . aiSs24Applied AS aiSs24Applied_89 ,
t0 . aiSs24Booked AS aiSs24Booked_90 ,
t0 . interestedIn AS interestedIn_91 ,
t0 . interests AS interests_92 ,
t0 . mentorMetadata AS mentorMetadata_93 ,
t0 . eventParticipations AS eventParticipations_94 ,
t0 . kiKompetenz AS kiKompetenz_95 ,
t0 . mentorOwnerId AS mentorOwnerId_96
FROM
sp_members t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . spMemberId AS spMemberId_2 , t0 . score AS score_3 , t0 . completenessScore AS completenessScore_4 , t0 . status AS status_5 , t0 . location AS location_6 , t0 . salutation AS salutation_7 , t0 . title AS title_8 , t0 . jobTitle AS jobTitle_9 , t0 . firstName AS firstName_10 , t0 . lastName AS lastName_11 , t0 . name AS name_12 , t0 . sortName AS sortName_13 , t0 . email AS email_14 , t0 . secondaryEmail AS secondaryEmail_15 , t0 . phone AS phone_16 , t0 . hasCommunityMembership AS hasCommunityMembership_17 , t0 . aiMemberValid AS aiMemberValid_18 , t0 . aiMemberStatus AS aiMemberStatus_19 , t0 . aiMemberReason AS aiMemberReason_20 , t0 . aiMemberStart AS aiMemberStart_21 , t0 . aiMemberEnd AS aiMemberEnd_22 , t0 . utm_source AS utm_source_23 , t0 . utm_medium AS utm_medium_24 , t0 . utm_campaign AS utm_campaign_25 , t0 . utm_term AS utm_term_26 , t0 . utm_content AS utm_content_27 , t0 . birthday AS birthday_28 , t0 . addressFieldOne AS addressFieldOne_29 , t0 . addressFieldTwo AS addressFieldTwo_30 , t0 . addressCountryCode AS addressCountryCode_31 , t0 . addressPostalCode AS addressPostalCode_32 , t0 . addressCity AS addressCity_33 , t0 . teamId AS teamId_34 , t0 . teamName AS teamName_35 , t0 . company AS company_36 , t0 . history AS history_37 , t0 . tags AS tags_38 , t0 . annotation AS annotation_39 , t0 . mentorBuckets AS mentorBuckets_40 , t0 . areasOfExpertise AS areasOfExpertise_41 , t0 . mentor_firma AS mentor_firma_42 , t0 . mentor_firma_url AS mentor_firma_url_43 , t0 . mentor_locations AS mentor_locations_44 , t0 . mentor_profile AS mentor_profile_45 , t0 . mentor_note AS mentor_note_46 , t0 . mentor_admin_rating AS mentor_admin_rating_47 , t0 . active AS active_48 , t0 . tiefgarage AS tiefgarage_49 , t0 . transponder AS transponder_50 , t0 . isTransponderAllowed AS isTransponderAllowed_51 , t0 . imageLink AS imageLink_52 , t0 . homepage AS homepage_53 , t0 . xing AS xing_54 , t0 . pipedriveId AS pipedriveId_55 , t0 . linkedin AS linkedin_56 , t0 . facebook AS facebook_57 , t0 . instagram AS instagram_58 , t0 . twitter AS twitter_59 , t0 . skills AS skills_60 , t0 . description AS description_61 , t0 . touchpoints AS touchpoints_62 , t0 . isAddressComplete AS isAddressComplete_63 , t0 . hasMailchimp AS hasMailchimp_64 , t0 . hasKiNewsletter AS hasKiNewsletter_65 , t0 . hubspotSyncPending AS hubspotSyncPending_66 , t0 . enterDate AS enterDate_67 , t0 . exitDate AS exitDate_68 , t0 . physicalMembershipStarted AS physicalMembershipStarted_69 , t0 . physicalMembershipEnded AS physicalMembershipEnded_70 , t0 . lastModified AS lastModified_71 , t0 . lastChangeUser AS lastChangeUser_72 , t0 . nAiWebinarsAttended AS nAiWebinarsAttended_73 , t0 . nAiWebinarsApplied AS nAiWebinarsApplied_74 , t0 . nAiEventsAttended AS nAiEventsAttended_75 , t0 . nAiEventsApplied AS nAiEventsApplied_76 , t0 . nPaidAttended AS nPaidAttended_77 , t0 . nPaidApplied AS nPaidApplied_78 , t0 . nKiEinstiegAttended AS nKiEinstiegAttended_79 , t0 . nKiEinstiegApplied AS nKiEinstiegApplied_80 , t0 . nPromptEngineeringAttended AS nPromptEngineeringAttended_81 , t0 . nPromptEngineeringApplied AS nPromptEngineeringApplied_82 , t0 . nEcodynamicsAttended AS nEcodynamicsAttended_83 , t0 . nEcodynamicsApplied AS nEcodynamicsApplied_84 , t0 . nBbqApplied AS nBbqApplied_85 , t0 . nAiFridayApplied AS nAiFridayApplied_86 , t0 . nAiGatheringApplied AS nAiGatheringApplied_87 , t0 . nAiGatheringAttended AS nAiGatheringAttended_88 , t0 . aiSs24Applied AS aiSs24Applied_89 , t0 . aiSs24Booked AS aiSs24Booked_90 , t0 . interestedIn AS interestedIn_91 , t0 . interests AS interests_92 , t0 . mentorMetadata AS mentorMetadata_93 , t0 . eventParticipations AS eventParticipations_94 , t0 . kiKompetenz AS kiKompetenz_95 , t0 . mentorOwnerId AS mentorOwnerId_96 FROM sp_members t0 WHERE t0 . id = '104168' ;
Copy
8
0.28 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 . isNetworking AS isNetworking_20 , t0 . networkingRounds AS networkingRounds_21 , t0 . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_22 , t0 . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_23 , t0 . eventId AS eventId_24 , t0 . zoomLink AS zoomLink_25 , t0 . typeformLink AS typeformLink_26 , t0 . mailTemplate AS mailTemplate_27 , t0 . mailSubject AS mailSubject_28 , t0 . reminderMailTemplateId AS reminderMailTemplateId_29 , t0 . reminderSenderEmail AS reminderSenderEmail_30 , t0 . phrasesDe AS phrasesDe_31 , t0 . phrasesEn AS phrasesEn_32 , t0 . settings AS settings_33 , t0 . createdAt AS createdAt_34 , t0 . lastModified AS lastModified_35 , t0 . lastChangeUser AS lastChangeUser_36 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 . isNetworking AS isNetworking_20 , t0 . networkingRounds AS networkingRounds_21 , t0 . isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_22 , t0 . isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_23 , t0 . eventId AS eventId_24 , t0 . zoomLink AS zoomLink_25 , t0 . typeformLink AS typeformLink_26 , t0 . mailTemplate AS mailTemplate_27 , t0 . mailSubject AS mailSubject_28 , t0 . reminderMailTemplateId AS reminderMailTemplateId_29 , t0 . reminderSenderEmail AS reminderSenderEmail_30 , t0 . phrasesDe AS phrasesDe_31 , t0 . phrasesEn AS phrasesEn_32 , t0 . settings AS settings_33 , t0 . createdAt AS createdAt_34 , t0 . lastModified AS lastModified_35 , t0 . lastChangeUser AS lastChangeUser_36 FROM sp_programs t0 WHERE t0 . id = 27 ;
Copy
9
0.21 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