1
0.41 ms
SELECT t0 . id AS id_1 , t0 . eventbriteId AS eventbriteId_2 , t0 . wpPostId AS wpPostId_3 , t0 . title AS title_4 , t0 . slug AS slug_5 , t0 . lang AS lang_6 , t0 . imagelink AS imagelink_7 , t0 . videolink AS videolink_8 , t0 . bgImagelink AS bgImagelink_9 , t0 . tagline AS tagline_10 , t0 . headerTextColor AS headerTextColor_11 , t0 . spResponsiblePerson AS spResponsiblePerson_12 , t0 . organization AS organization_13 , t0 . organizerName AS organizerName_14 , t0 . organizerEmail AS organizerEmail_15 , t0 . venueName AS venueName_16 , t0 . venueAddress AS venueAddress_17 , t0 . ticketing AS ticketing_18 , t0 . applicationUrl AS applicationUrl_19 , t0 . alert AS alert_20 , t0 . trainer AS trainer_21 , t0 . speakers AS speakers_22 , t0 . teaser AS teaser_23 , t0 . navbar AS navbar_24 , t0 . stripePriceId AS stripePriceId_25 , t0 . stripeProductId AS stripeProductId_26 , t0 . stripeAccount AS stripeAccount_27 , t0 . priceInEuroCent AS priceInEuroCent_28 , t0 . isTaxIncluded AS isTaxIncluded_29 , t0 . isFreeForKiCampus AS isFreeForKiCampus_30 , t0 . isFreeForCommunity AS isFreeForCommunity_31 , t0 . isSinglePage AS isSinglePage_32 , t0 . isFormalLanguage AS isFormalLanguage_33 , t0 . isMultiBatchEvent AS isMultiBatchEvent_34 , t0 . twigFile AS twigFile_35 , t0 . additionalCss AS additionalCss_36 , t0 . content AS content_37 , t0 . contentTwig AS contentTwig_38 , t0 . ctaContent AS ctaContent_39 , t0 . postCtaContent AS postCtaContent_40 , t0 . tags AS tags_41 , t0 . seriesTag AS seriesTag_42 , t0 . type AS type_43 , t0 . location AS location_44 , t0 . startDate AS startDate_45 , t0 . endDate AS endDate_46 , t0 . duration AS duration_47 , t0 . status AS status_48 , t0 . settings AS settings_49 , t0 . displayStartDate AS displayStartDate_50 , t0 . seoTitle AS seoTitle_51 , t0 . seoKeyword AS seoKeyword_52 , t0 . seoDescription AS seoDescription_53 , t0 . navbar_en AS navbar_en_54 , t0 . teaser_en AS teaser_en_55 , t0 . content_en AS content_en_56 , t0 . content_twig_en AS content_twig_en_57 , t0 . post_cta_content_en AS post_cta_content_en_58 , t0 . seo_title_en AS seo_title_en_59 , t0 . seo_description_en AS seo_description_en_60 , t0 . seo_keyword_en AS seo_keyword_en_61 , t0 . has_english_version AS has_english_version_62 , t0 . additional_js AS additional_js_63 , t0 . metaPixelId AS metaPixelId_64 , t0 . createDate AS createDate_65 , t0 . lastChangeDate AS lastChangeDate_66 , t0 . lastChangeUser AS lastChangeUser_67 , t0 . publicId AS publicId_68 , t0 . isExternalSubmission AS isExternalSubmission_69 , t0 . createdBy AS createdBy_70 , t0 . lastModified AS lastModified_71 , t0 . createdAt AS createdAt_72 , t0 . orgaNote AS orgaNote_73 , t0 . history AS history_74 , t0 . todoHistory AS todoHistory_75 FROM sp_event_events t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"genai-ki-leitlinien-und-smarte-automatisierung-fuer-unternehmen-2024-09-26 "
]
SELECT
t0 . id AS id_1 ,
t0 . eventbriteId AS eventbriteId_2 ,
t0 . wpPostId AS wpPostId_3 ,
t0 . title AS title_4 ,
t0 . slug AS slug_5 ,
t0 . lang AS lang_6 ,
t0 . imagelink AS imagelink_7 ,
t0 . videolink AS videolink_8 ,
t0 . bgImagelink AS bgImagelink_9 ,
t0 . tagline AS tagline_10 ,
t0 . headerTextColor AS headerTextColor_11 ,
t0 . spResponsiblePerson AS spResponsiblePerson_12 ,
t0 . organization AS organization_13 ,
t0 . organizerName AS organizerName_14 ,
t0 . organizerEmail AS organizerEmail_15 ,
t0 . venueName AS venueName_16 ,
t0 . venueAddress AS venueAddress_17 ,
t0 . ticketing AS ticketing_18 ,
t0 . applicationUrl AS applicationUrl_19 ,
t0 . alert AS alert_20 ,
t0 . trainer AS trainer_21 ,
t0 . speakers AS speakers_22 ,
t0 . teaser AS teaser_23 ,
t0 . navbar AS navbar_24 ,
t0 . stripePriceId AS stripePriceId_25 ,
t0 . stripeProductId AS stripeProductId_26 ,
t0 . stripeAccount AS stripeAccount_27 ,
t0 . priceInEuroCent AS priceInEuroCent_28 ,
t0 . isTaxIncluded AS isTaxIncluded_29 ,
t0 . isFreeForKiCampus AS isFreeForKiCampus_30 ,
t0 . isFreeForCommunity AS isFreeForCommunity_31 ,
t0 . isSinglePage AS isSinglePage_32 ,
t0 . isFormalLanguage AS isFormalLanguage_33 ,
t0 . isMultiBatchEvent AS isMultiBatchEvent_34 ,
t0 . twigFile AS twigFile_35 ,
t0 . additionalCss AS additionalCss_36 ,
t0 . content AS content_37 ,
t0 . contentTwig AS contentTwig_38 ,
t0 . ctaContent AS ctaContent_39 ,
t0 . postCtaContent AS postCtaContent_40 ,
t0 . tags AS tags_41 ,
t0 . seriesTag AS seriesTag_42 ,
t0 . type AS type_43 ,
t0 . location AS location_44 ,
t0 . startDate AS startDate_45 ,
t0 . endDate AS endDate_46 ,
t0 . duration AS duration_47 ,
t0 . status AS status_48 ,
t0 . settings AS settings_49 ,
t0 . displayStartDate AS displayStartDate_50 ,
t0 . seoTitle AS seoTitle_51 ,
t0 . seoKeyword AS seoKeyword_52 ,
t0 . seoDescription AS seoDescription_53 ,
t0 . navbar_en AS navbar_en_54 ,
t0 . teaser_en AS teaser_en_55 ,
t0 . content_en AS content_en_56 ,
t0 . content_twig_en AS content_twig_en_57 ,
t0 . post_cta_content_en AS post_cta_content_en_58 ,
t0 . seo_title_en AS seo_title_en_59 ,
t0 . seo_description_en AS seo_description_en_60 ,
t0 . seo_keyword_en AS seo_keyword_en_61 ,
t0 . has_english_version AS has_english_version_62 ,
t0 . additional_js AS additional_js_63 ,
t0 . metaPixelId AS metaPixelId_64 ,
t0 . createDate AS createDate_65 ,
t0 . lastChangeDate AS lastChangeDate_66 ,
t0 . lastChangeUser AS lastChangeUser_67 ,
t0 . publicId AS publicId_68 ,
t0 . isExternalSubmission AS isExternalSubmission_69 ,
t0 . createdBy AS createdBy_70 ,
t0 . lastModified AS lastModified_71 ,
t0 . createdAt AS createdAt_72 ,
t0 . orgaNote AS orgaNote_73 ,
t0 . history AS history_74 ,
t0 . todoHistory AS todoHistory_75
FROM
sp_event_events t0
WHERE
t0 . slug = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . eventbriteId AS eventbriteId_2 , t0 . wpPostId AS wpPostId_3 , t0 . title AS title_4 , t0 . slug AS slug_5 , t0 . lang AS lang_6 , t0 . imagelink AS imagelink_7 , t0 . videolink AS videolink_8 , t0 . bgImagelink AS bgImagelink_9 , t0 . tagline AS tagline_10 , t0 . headerTextColor AS headerTextColor_11 , t0 . spResponsiblePerson AS spResponsiblePerson_12 , t0 . organization AS organization_13 , t0 . organizerName AS organizerName_14 , t0 . organizerEmail AS organizerEmail_15 , t0 . venueName AS venueName_16 , t0 . venueAddress AS venueAddress_17 , t0 . ticketing AS ticketing_18 , t0 . applicationUrl AS applicationUrl_19 , t0 . alert AS alert_20 , t0 . trainer AS trainer_21 , t0 . speakers AS speakers_22 , t0 . teaser AS teaser_23 , t0 . navbar AS navbar_24 , t0 . stripePriceId AS stripePriceId_25 , t0 . stripeProductId AS stripeProductId_26 , t0 . stripeAccount AS stripeAccount_27 , t0 . priceInEuroCent AS priceInEuroCent_28 , t0 . isTaxIncluded AS isTaxIncluded_29 , t0 . isFreeForKiCampus AS isFreeForKiCampus_30 , t0 . isFreeForCommunity AS isFreeForCommunity_31 , t0 . isSinglePage AS isSinglePage_32 , t0 . isFormalLanguage AS isFormalLanguage_33 , t0 . isMultiBatchEvent AS isMultiBatchEvent_34 , t0 . twigFile AS twigFile_35 , t0 . additionalCss AS additionalCss_36 , t0 . content AS content_37 , t0 . contentTwig AS contentTwig_38 , t0 . ctaContent AS ctaContent_39 , t0 . postCtaContent AS postCtaContent_40 , t0 . tags AS tags_41 , t0 . seriesTag AS seriesTag_42 , t0 . type AS type_43 , t0 . location AS location_44 , t0 . startDate AS startDate_45 , t0 . endDate AS endDate_46 , t0 . duration AS duration_47 , t0 . status AS status_48 , t0 . settings AS settings_49 , t0 . displayStartDate AS displayStartDate_50 , t0 . seoTitle AS seoTitle_51 , t0 . seoKeyword AS seoKeyword_52 , t0 . seoDescription AS seoDescription_53 , t0 . navbar_en AS navbar_en_54 , t0 . teaser_en AS teaser_en_55 , t0 . content_en AS content_en_56 , t0 . content_twig_en AS content_twig_en_57 , t0 . post_cta_content_en AS post_cta_content_en_58 , t0 . seo_title_en AS seo_title_en_59 , t0 . seo_description_en AS seo_description_en_60 , t0 . seo_keyword_en AS seo_keyword_en_61 , t0 . has_english_version AS has_english_version_62 , t0 . additional_js AS additional_js_63 , t0 . metaPixelId AS metaPixelId_64 , t0 . createDate AS createDate_65 , t0 . lastChangeDate AS lastChangeDate_66 , t0 . lastChangeUser AS lastChangeUser_67 , t0 . publicId AS publicId_68 , t0 . isExternalSubmission AS isExternalSubmission_69 , t0 . createdBy AS createdBy_70 , t0 . lastModified AS lastModified_71 , t0 . createdAt AS createdAt_72 , t0 . orgaNote AS orgaNote_73 , t0 . history AS history_74 , t0 . todoHistory AS todoHistory_75 FROM sp_event_events t0 WHERE t0 . slug = 'genai-ki-leitlinien-und-smarte-automatisierung-fuer-unternehmen-2024-09-26' LIMIT 1 ;
Copy
2
7.01 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 . isFreeForKiCampus AS isFreeForKiCampus_41 , t0 . isFreeForCommunity AS isFreeForCommunity_42 , t0 . mailDesignTemplate AS mailDesignTemplate_43 , t0 . senderMail AS senderMail_44 , t0 . fromName AS fromName_45 , t0 . recipientMonitoringMail AS recipientMonitoringMail_46 , t0 . confirmationMailSubject AS confirmationMailSubject_47 , t0 . confirmationMailContent AS confirmationMailContent_48 , t0 . adminNotificationMailSubject AS adminNotificationMailSubject_49 , t0 . adminNotificationMailContent AS adminNotificationMailContent_50 , t0 . reminderMailTemplateId AS reminderMailTemplateId_51 , t0 . reminderSenderEmail AS reminderSenderEmail_52 , t0 . reminderBulkMailId AS reminderBulkMailId_53 , t0 . reminderMailSendDate AS reminderMailSendDate_54 , t0 . reminderMailSubject AS reminderMailSubject_55 , t0 . reminderMailContent AS reminderMailContent_56 , t0 . $reminderMailStatus AS reminderMailStatus_57 , t0 . surveyId AS surveyId_58 , t0 . surveyMailTemplateId AS surveyMailTemplateId_59 , t0 . surveyBulkMailId AS surveyBulkMailId_60 , t0 . template AS template_61 , t0 . pageTemplate AS pageTemplate_62 , t0 . footerTemplate AS footerTemplate_63 , t0 . email AS email_64 , t0 . emailSubject AS emailSubject_65 , t0 . emailContent AS emailContent_66 , t0 . landingPageContent AS landingPageContent_67 , t0 . landingPageDescription AS landingPageDescription_68 , t0 . landingPageCss AS landingPageCss_69 , t0 . landingPageJs AS landingPageJs_70 , t0 . landingPageFooterTemplate AS landingPageFooterTemplate_71 , t0 . landingPageSocialImage AS landingPageSocialImage_72 , t0 . landingPageTitle AS landingPageTitle_73 , t0 . landingPageTwig AS landingPageTwig_74 , t0 . goToPage AS goToPage_75 , t0 . phrasesDe AS phrasesDe_76 , t0 . phrasesEn AS phrasesEn_77 , t0 . settings AS settings_78 , t0 . asssesmentDimensions AS asssesmentDimensions_79 , t0 . start AS start_80 , t0 . end AS end_81 , t0 . pitchTopic AS pitchTopic_82 , t0 . pitchImageLink AS pitchImageLink_83 , t0 . pitchVideoLink AS pitchVideoLink_84 , t0 . pitchPartner AS pitchPartner_85 , t0 . pitchPartnerId AS pitchPartnerId_86 , t0 . pitchDescription AS pitchDescription_87 , t0 . followUpPageContent AS followUpPageContent_88 , t0 . followUpPageDescription AS followUpPageDescription_89 , t0 . followUpPageCss AS followUpPageCss_90 , t0 . followUpPageJs AS followUpPageJs_91 , t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_92 , t0 . followUpPageTitle AS followUpPageTitle_93 , t0 . followUpPageSocialImage AS followUpPageSocialImage_94 , t0 . followUpDescription AS followUpDescription_95 , t0 . followUpVideoLink AS followUpVideoLink_96 , t0 . followUpPresentation AS followUpPresentation_97 , t0 . pitchDate AS pitchDate_98 , t0 . pitchTime AS pitchTime_99 , t0 . prepitchDate AS prepitchDate_100 , t0 . city AS city_101 , t0 . applicationsCount AS applicationsCount_102 , t0 . startedCount AS startedCount_103 , t0 . appliedCount AS appliedCount_104 , t0 . approvedCount AS approvedCount_105 , t0 . rejectedCount AS rejectedCount_106 , t0 . $skoolWebhook AS skoolWebhook_107 , t0 . zapierWebhook AS zapierWebhook_108 , t0 . history AS history_109 , t0 . createdAt AS createdAt_110 , t0 . lastModified AS lastModified_111 , t0 . lastChangeUser AS lastChangeUser_112 , t0 . program_id AS program_id_113 , t0 . assessmentTeamId AS assessmentTeamId_114 FROM sp_batches t0 WHERE t0 . programId = ? AND t0 . eventId = ? AND t0 . status = ? AND t0 . access = ? LIMIT 1
Parameters :
[
27
6424
"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 . isFreeForKiCampus AS isFreeForKiCampus_41 ,
t0 . isFreeForCommunity AS isFreeForCommunity_42 ,
t0 . mailDesignTemplate AS mailDesignTemplate_43 ,
t0 . senderMail AS senderMail_44 ,
t0 . fromName AS fromName_45 ,
t0 . recipientMonitoringMail AS recipientMonitoringMail_46 ,
t0 . confirmationMailSubject AS confirmationMailSubject_47 ,
t0 . confirmationMailContent AS confirmationMailContent_48 ,
t0 . adminNotificationMailSubject AS adminNotificationMailSubject_49 ,
t0 . adminNotificationMailContent AS adminNotificationMailContent_50 ,
t0 . reminderMailTemplateId AS reminderMailTemplateId_51 ,
t0 . reminderSenderEmail AS reminderSenderEmail_52 ,
t0 . reminderBulkMailId AS reminderBulkMailId_53 ,
t0 . reminderMailSendDate AS reminderMailSendDate_54 ,
t0 . reminderMailSubject AS reminderMailSubject_55 ,
t0 . reminderMailContent AS reminderMailContent_56 ,
t0 . $reminderMailStatus AS reminderMailStatus_57 ,
t0 . surveyId AS surveyId_58 ,
t0 . surveyMailTemplateId AS surveyMailTemplateId_59 ,
t0 . surveyBulkMailId AS surveyBulkMailId_60 ,
t0 . template AS template_61 ,
t0 . pageTemplate AS pageTemplate_62 ,
t0 . footerTemplate AS footerTemplate_63 ,
t0 . email AS email_64 ,
t0 . emailSubject AS emailSubject_65 ,
t0 . emailContent AS emailContent_66 ,
t0 . landingPageContent AS landingPageContent_67 ,
t0 . landingPageDescription AS landingPageDescription_68 ,
t0 . landingPageCss AS landingPageCss_69 ,
t0 . landingPageJs AS landingPageJs_70 ,
t0 . landingPageFooterTemplate AS landingPageFooterTemplate_71 ,
t0 . landingPageSocialImage AS landingPageSocialImage_72 ,
t0 . landingPageTitle AS landingPageTitle_73 ,
t0 . landingPageTwig AS landingPageTwig_74 ,
t0 . goToPage AS goToPage_75 ,
t0 . phrasesDe AS phrasesDe_76 ,
t0 . phrasesEn AS phrasesEn_77 ,
t0 . settings AS settings_78 ,
t0 . asssesmentDimensions AS asssesmentDimensions_79 ,
t0 . start AS start_80 ,
t0 . end AS end_81 ,
t0 . pitchTopic AS pitchTopic_82 ,
t0 . pitchImageLink AS pitchImageLink_83 ,
t0 . pitchVideoLink AS pitchVideoLink_84 ,
t0 . pitchPartner AS pitchPartner_85 ,
t0 . pitchPartnerId AS pitchPartnerId_86 ,
t0 . pitchDescription AS pitchDescription_87 ,
t0 . followUpPageContent AS followUpPageContent_88 ,
t0 . followUpPageDescription AS followUpPageDescription_89 ,
t0 . followUpPageCss AS followUpPageCss_90 ,
t0 . followUpPageJs AS followUpPageJs_91 ,
t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_92 ,
t0 . followUpPageTitle AS followUpPageTitle_93 ,
t0 . followUpPageSocialImage AS followUpPageSocialImage_94 ,
t0 . followUpDescription AS followUpDescription_95 ,
t0 . followUpVideoLink AS followUpVideoLink_96 ,
t0 . followUpPresentation AS followUpPresentation_97 ,
t0 . pitchDate AS pitchDate_98 ,
t0 . pitchTime AS pitchTime_99 ,
t0 . prepitchDate AS prepitchDate_100 ,
t0 . city AS city_101 ,
t0 . applicationsCount AS applicationsCount_102 ,
t0 . startedCount AS startedCount_103 ,
t0 . appliedCount AS appliedCount_104 ,
t0 . approvedCount AS approvedCount_105 ,
t0 . rejectedCount AS rejectedCount_106 ,
t0 . $skoolWebhook AS skoolWebhook_107 ,
t0 . zapierWebhook AS zapierWebhook_108 ,
t0 . history AS history_109 ,
t0 . createdAt AS createdAt_110 ,
t0 . lastModified AS lastModified_111 ,
t0 . lastChangeUser AS lastChangeUser_112 ,
t0 . program_id AS program_id_113 ,
t0 . assessmentTeamId AS assessmentTeamId_114
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 . isFreeForKiCampus AS isFreeForKiCampus_41 , t0 . isFreeForCommunity AS isFreeForCommunity_42 , t0 . mailDesignTemplate AS mailDesignTemplate_43 , t0 . senderMail AS senderMail_44 , t0 . fromName AS fromName_45 , t0 . recipientMonitoringMail AS recipientMonitoringMail_46 , t0 . confirmationMailSubject AS confirmationMailSubject_47 , t0 . confirmationMailContent AS confirmationMailContent_48 , t0 . adminNotificationMailSubject AS adminNotificationMailSubject_49 , t0 . adminNotificationMailContent AS adminNotificationMailContent_50 , t0 . reminderMailTemplateId AS reminderMailTemplateId_51 , t0 . reminderSenderEmail AS reminderSenderEmail_52 , t0 . reminderBulkMailId AS reminderBulkMailId_53 , t0 . reminderMailSendDate AS reminderMailSendDate_54 , t0 . reminderMailSubject AS reminderMailSubject_55 , t0 . reminderMailContent AS reminderMailContent_56 , t0 . $reminderMailStatus AS reminderMailStatus_57 , t0 . surveyId AS surveyId_58 , t0 . surveyMailTemplateId AS surveyMailTemplateId_59 , t0 . surveyBulkMailId AS surveyBulkMailId_60 , t0 . template AS template_61 , t0 . pageTemplate AS pageTemplate_62 , t0 . footerTemplate AS footerTemplate_63 , t0 . email AS email_64 , t0 . emailSubject AS emailSubject_65 , t0 . emailContent AS emailContent_66 , t0 . landingPageContent AS landingPageContent_67 , t0 . landingPageDescription AS landingPageDescription_68 , t0 . landingPageCss AS landingPageCss_69 , t0 . landingPageJs AS landingPageJs_70 , t0 . landingPageFooterTemplate AS landingPageFooterTemplate_71 , t0 . landingPageSocialImage AS landingPageSocialImage_72 , t0 . landingPageTitle AS landingPageTitle_73 , t0 . landingPageTwig AS landingPageTwig_74 , t0 . goToPage AS goToPage_75 , t0 . phrasesDe AS phrasesDe_76 , t0 . phrasesEn AS phrasesEn_77 , t0 . settings AS settings_78 , t0 . asssesmentDimensions AS asssesmentDimensions_79 , t0 . start AS start_80 , t0 . end AS end_81 , t0 . pitchTopic AS pitchTopic_82 , t0 . pitchImageLink AS pitchImageLink_83 , t0 . pitchVideoLink AS pitchVideoLink_84 , t0 . pitchPartner AS pitchPartner_85 , t0 . pitchPartnerId AS pitchPartnerId_86 , t0 . pitchDescription AS pitchDescription_87 , t0 . followUpPageContent AS followUpPageContent_88 , t0 . followUpPageDescription AS followUpPageDescription_89 , t0 . followUpPageCss AS followUpPageCss_90 , t0 . followUpPageJs AS followUpPageJs_91 , t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_92 , t0 . followUpPageTitle AS followUpPageTitle_93 , t0 . followUpPageSocialImage AS followUpPageSocialImage_94 , t0 . followUpDescription AS followUpDescription_95 , t0 . followUpVideoLink AS followUpVideoLink_96 , t0 . followUpPresentation AS followUpPresentation_97 , t0 . pitchDate AS pitchDate_98 , t0 . pitchTime AS pitchTime_99 , t0 . prepitchDate AS prepitchDate_100 , t0 . city AS city_101 , t0 . applicationsCount AS applicationsCount_102 , t0 . startedCount AS startedCount_103 , t0 . appliedCount AS appliedCount_104 , t0 . approvedCount AS approvedCount_105 , t0 . rejectedCount AS rejectedCount_106 , t0 . $skoolWebhook AS skoolWebhook_107 , t0 . zapierWebhook AS zapierWebhook_108 , t0 . history AS history_109 , t0 . createdAt AS createdAt_110 , t0 . lastModified AS lastModified_111 , t0 . lastChangeUser AS lastChangeUser_112 , t0 . program_id AS program_id_113 , t0 . assessmentTeamId AS assessmentTeamId_114 FROM sp_batches t0 WHERE t0 . programId = 27 AND t0 . eventId = 6424 AND t0 . status = 'active' AND t0 . access = 'anonymous' LIMIT 1 ;
Copy
3
2.77 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 . isFreeForKiCampus AS isFreeForKiCampus_41 , t0 . isFreeForCommunity AS isFreeForCommunity_42 , t0 . mailDesignTemplate AS mailDesignTemplate_43 , t0 . senderMail AS senderMail_44 , t0 . fromName AS fromName_45 , t0 . recipientMonitoringMail AS recipientMonitoringMail_46 , t0 . confirmationMailSubject AS confirmationMailSubject_47 , t0 . confirmationMailContent AS confirmationMailContent_48 , t0 . adminNotificationMailSubject AS adminNotificationMailSubject_49 , t0 . adminNotificationMailContent AS adminNotificationMailContent_50 , t0 . reminderMailTemplateId AS reminderMailTemplateId_51 , t0 . reminderSenderEmail AS reminderSenderEmail_52 , t0 . reminderBulkMailId AS reminderBulkMailId_53 , t0 . reminderMailSendDate AS reminderMailSendDate_54 , t0 . reminderMailSubject AS reminderMailSubject_55 , t0 . reminderMailContent AS reminderMailContent_56 , t0 . $reminderMailStatus AS reminderMailStatus_57 , t0 . surveyId AS surveyId_58 , t0 . surveyMailTemplateId AS surveyMailTemplateId_59 , t0 . surveyBulkMailId AS surveyBulkMailId_60 , t0 . template AS template_61 , t0 . pageTemplate AS pageTemplate_62 , t0 . footerTemplate AS footerTemplate_63 , t0 . email AS email_64 , t0 . emailSubject AS emailSubject_65 , t0 . emailContent AS emailContent_66 , t0 . landingPageContent AS landingPageContent_67 , t0 . landingPageDescription AS landingPageDescription_68 , t0 . landingPageCss AS landingPageCss_69 , t0 . landingPageJs AS landingPageJs_70 , t0 . landingPageFooterTemplate AS landingPageFooterTemplate_71 , t0 . landingPageSocialImage AS landingPageSocialImage_72 , t0 . landingPageTitle AS landingPageTitle_73 , t0 . landingPageTwig AS landingPageTwig_74 , t0 . goToPage AS goToPage_75 , t0 . phrasesDe AS phrasesDe_76 , t0 . phrasesEn AS phrasesEn_77 , t0 . settings AS settings_78 , t0 . asssesmentDimensions AS asssesmentDimensions_79 , t0 . start AS start_80 , t0 . end AS end_81 , t0 . pitchTopic AS pitchTopic_82 , t0 . pitchImageLink AS pitchImageLink_83 , t0 . pitchVideoLink AS pitchVideoLink_84 , t0 . pitchPartner AS pitchPartner_85 , t0 . pitchPartnerId AS pitchPartnerId_86 , t0 . pitchDescription AS pitchDescription_87 , t0 . followUpPageContent AS followUpPageContent_88 , t0 . followUpPageDescription AS followUpPageDescription_89 , t0 . followUpPageCss AS followUpPageCss_90 , t0 . followUpPageJs AS followUpPageJs_91 , t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_92 , t0 . followUpPageTitle AS followUpPageTitle_93 , t0 . followUpPageSocialImage AS followUpPageSocialImage_94 , t0 . followUpDescription AS followUpDescription_95 , t0 . followUpVideoLink AS followUpVideoLink_96 , t0 . followUpPresentation AS followUpPresentation_97 , t0 . pitchDate AS pitchDate_98 , t0 . pitchTime AS pitchTime_99 , t0 . prepitchDate AS prepitchDate_100 , t0 . city AS city_101 , t0 . applicationsCount AS applicationsCount_102 , t0 . startedCount AS startedCount_103 , t0 . appliedCount AS appliedCount_104 , t0 . approvedCount AS approvedCount_105 , t0 . rejectedCount AS rejectedCount_106 , t0 . $skoolWebhook AS skoolWebhook_107 , t0 . zapierWebhook AS zapierWebhook_108 , t0 . history AS history_109 , t0 . createdAt AS createdAt_110 , t0 . lastModified AS lastModified_111 , t0 . lastChangeUser AS lastChangeUser_112 , t0 . program_id AS program_id_113 , t0 . assessmentTeamId AS assessmentTeamId_114 FROM sp_batches t0 WHERE t0 . programId = ? AND t0 . eventId = ? AND t0 . status = ? AND t0 . access = ? LIMIT 1
Parameters :
[
27
6424
"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 . isFreeForKiCampus AS isFreeForKiCampus_41 ,
t0 . isFreeForCommunity AS isFreeForCommunity_42 ,
t0 . mailDesignTemplate AS mailDesignTemplate_43 ,
t0 . senderMail AS senderMail_44 ,
t0 . fromName AS fromName_45 ,
t0 . recipientMonitoringMail AS recipientMonitoringMail_46 ,
t0 . confirmationMailSubject AS confirmationMailSubject_47 ,
t0 . confirmationMailContent AS confirmationMailContent_48 ,
t0 . adminNotificationMailSubject AS adminNotificationMailSubject_49 ,
t0 . adminNotificationMailContent AS adminNotificationMailContent_50 ,
t0 . reminderMailTemplateId AS reminderMailTemplateId_51 ,
t0 . reminderSenderEmail AS reminderSenderEmail_52 ,
t0 . reminderBulkMailId AS reminderBulkMailId_53 ,
t0 . reminderMailSendDate AS reminderMailSendDate_54 ,
t0 . reminderMailSubject AS reminderMailSubject_55 ,
t0 . reminderMailContent AS reminderMailContent_56 ,
t0 . $reminderMailStatus AS reminderMailStatus_57 ,
t0 . surveyId AS surveyId_58 ,
t0 . surveyMailTemplateId AS surveyMailTemplateId_59 ,
t0 . surveyBulkMailId AS surveyBulkMailId_60 ,
t0 . template AS template_61 ,
t0 . pageTemplate AS pageTemplate_62 ,
t0 . footerTemplate AS footerTemplate_63 ,
t0 . email AS email_64 ,
t0 . emailSubject AS emailSubject_65 ,
t0 . emailContent AS emailContent_66 ,
t0 . landingPageContent AS landingPageContent_67 ,
t0 . landingPageDescription AS landingPageDescription_68 ,
t0 . landingPageCss AS landingPageCss_69 ,
t0 . landingPageJs AS landingPageJs_70 ,
t0 . landingPageFooterTemplate AS landingPageFooterTemplate_71 ,
t0 . landingPageSocialImage AS landingPageSocialImage_72 ,
t0 . landingPageTitle AS landingPageTitle_73 ,
t0 . landingPageTwig AS landingPageTwig_74 ,
t0 . goToPage AS goToPage_75 ,
t0 . phrasesDe AS phrasesDe_76 ,
t0 . phrasesEn AS phrasesEn_77 ,
t0 . settings AS settings_78 ,
t0 . asssesmentDimensions AS asssesmentDimensions_79 ,
t0 . start AS start_80 ,
t0 . end AS end_81 ,
t0 . pitchTopic AS pitchTopic_82 ,
t0 . pitchImageLink AS pitchImageLink_83 ,
t0 . pitchVideoLink AS pitchVideoLink_84 ,
t0 . pitchPartner AS pitchPartner_85 ,
t0 . pitchPartnerId AS pitchPartnerId_86 ,
t0 . pitchDescription AS pitchDescription_87 ,
t0 . followUpPageContent AS followUpPageContent_88 ,
t0 . followUpPageDescription AS followUpPageDescription_89 ,
t0 . followUpPageCss AS followUpPageCss_90 ,
t0 . followUpPageJs AS followUpPageJs_91 ,
t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_92 ,
t0 . followUpPageTitle AS followUpPageTitle_93 ,
t0 . followUpPageSocialImage AS followUpPageSocialImage_94 ,
t0 . followUpDescription AS followUpDescription_95 ,
t0 . followUpVideoLink AS followUpVideoLink_96 ,
t0 . followUpPresentation AS followUpPresentation_97 ,
t0 . pitchDate AS pitchDate_98 ,
t0 . pitchTime AS pitchTime_99 ,
t0 . prepitchDate AS prepitchDate_100 ,
t0 . city AS city_101 ,
t0 . applicationsCount AS applicationsCount_102 ,
t0 . startedCount AS startedCount_103 ,
t0 . appliedCount AS appliedCount_104 ,
t0 . approvedCount AS approvedCount_105 ,
t0 . rejectedCount AS rejectedCount_106 ,
t0 . $skoolWebhook AS skoolWebhook_107 ,
t0 . zapierWebhook AS zapierWebhook_108 ,
t0 . history AS history_109 ,
t0 . createdAt AS createdAt_110 ,
t0 . lastModified AS lastModified_111 ,
t0 . lastChangeUser AS lastChangeUser_112 ,
t0 . program_id AS program_id_113 ,
t0 . assessmentTeamId AS assessmentTeamId_114
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 . isFreeForKiCampus AS isFreeForKiCampus_41 , t0 . isFreeForCommunity AS isFreeForCommunity_42 , t0 . mailDesignTemplate AS mailDesignTemplate_43 , t0 . senderMail AS senderMail_44 , t0 . fromName AS fromName_45 , t0 . recipientMonitoringMail AS recipientMonitoringMail_46 , t0 . confirmationMailSubject AS confirmationMailSubject_47 , t0 . confirmationMailContent AS confirmationMailContent_48 , t0 . adminNotificationMailSubject AS adminNotificationMailSubject_49 , t0 . adminNotificationMailContent AS adminNotificationMailContent_50 , t0 . reminderMailTemplateId AS reminderMailTemplateId_51 , t0 . reminderSenderEmail AS reminderSenderEmail_52 , t0 . reminderBulkMailId AS reminderBulkMailId_53 , t0 . reminderMailSendDate AS reminderMailSendDate_54 , t0 . reminderMailSubject AS reminderMailSubject_55 , t0 . reminderMailContent AS reminderMailContent_56 , t0 . $reminderMailStatus AS reminderMailStatus_57 , t0 . surveyId AS surveyId_58 , t0 . surveyMailTemplateId AS surveyMailTemplateId_59 , t0 . surveyBulkMailId AS surveyBulkMailId_60 , t0 . template AS template_61 , t0 . pageTemplate AS pageTemplate_62 , t0 . footerTemplate AS footerTemplate_63 , t0 . email AS email_64 , t0 . emailSubject AS emailSubject_65 , t0 . emailContent AS emailContent_66 , t0 . landingPageContent AS landingPageContent_67 , t0 . landingPageDescription AS landingPageDescription_68 , t0 . landingPageCss AS landingPageCss_69 , t0 . landingPageJs AS landingPageJs_70 , t0 . landingPageFooterTemplate AS landingPageFooterTemplate_71 , t0 . landingPageSocialImage AS landingPageSocialImage_72 , t0 . landingPageTitle AS landingPageTitle_73 , t0 . landingPageTwig AS landingPageTwig_74 , t0 . goToPage AS goToPage_75 , t0 . phrasesDe AS phrasesDe_76 , t0 . phrasesEn AS phrasesEn_77 , t0 . settings AS settings_78 , t0 . asssesmentDimensions AS asssesmentDimensions_79 , t0 . start AS start_80 , t0 . end AS end_81 , t0 . pitchTopic AS pitchTopic_82 , t0 . pitchImageLink AS pitchImageLink_83 , t0 . pitchVideoLink AS pitchVideoLink_84 , t0 . pitchPartner AS pitchPartner_85 , t0 . pitchPartnerId AS pitchPartnerId_86 , t0 . pitchDescription AS pitchDescription_87 , t0 . followUpPageContent AS followUpPageContent_88 , t0 . followUpPageDescription AS followUpPageDescription_89 , t0 . followUpPageCss AS followUpPageCss_90 , t0 . followUpPageJs AS followUpPageJs_91 , t0 . followUpPageFooterTemplate AS followUpPageFooterTemplate_92 , t0 . followUpPageTitle AS followUpPageTitle_93 , t0 . followUpPageSocialImage AS followUpPageSocialImage_94 , t0 . followUpDescription AS followUpDescription_95 , t0 . followUpVideoLink AS followUpVideoLink_96 , t0 . followUpPresentation AS followUpPresentation_97 , t0 . pitchDate AS pitchDate_98 , t0 . pitchTime AS pitchTime_99 , t0 . prepitchDate AS prepitchDate_100 , t0 . city AS city_101 , t0 . applicationsCount AS applicationsCount_102 , t0 . startedCount AS startedCount_103 , t0 . appliedCount AS appliedCount_104 , t0 . approvedCount AS approvedCount_105 , t0 . rejectedCount AS rejectedCount_106 , t0 . $skoolWebhook AS skoolWebhook_107 , t0 . zapierWebhook AS zapierWebhook_108 , t0 . history AS history_109 , t0 . createdAt AS createdAt_110 , t0 . lastModified AS lastModified_111 , t0 . lastChangeUser AS lastChangeUser_112 , t0 . program_id AS program_id_113 , t0 . assessmentTeamId AS assessmentTeamId_114 FROM sp_batches t0 WHERE t0 . programId = 27 AND t0 . eventId = 6424 AND t0 . status = 'completed' AND t0 . access = 'anonymous' LIMIT 1 ;
Copy
4
0.30 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
5
0.19 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