| 1 |
0.48 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 asp_events t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"female-modern-work-tour"
]
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
asp_events t0
WHERE
t0.slug = ?
LIMIT
1
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 asp_events t0 WHERE t0.slug = 'female-modern-work-tour' LIMIT 1;
|
| 2 |
2.49 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.city AS city_100, t0.applicationsCount AS applicationsCount_101, t0.startedCount AS startedCount_102, t0.appliedCount AS appliedCount_103, t0.approvedCount AS approvedCount_104, t0.rejectedCount AS rejectedCount_105, t0.$skoolWebhook AS skoolWebhook_106, t0.zapierWebhook AS zapierWebhook_107, t0.history AS history_108, t0.createdAt AS createdAt_109, t0.lastModified AS lastModified_110, t0.lastChangeUser AS lastChangeUser_111, t0.program_id AS program_id_112, t0.assessmentTeamId AS assessmentTeamId_113 FROM aab_batches t0 WHERE t0.programId = ? AND t0.eventId = ? AND t0.status = ? AND t0.access = ? LIMIT 1
Parameters: [
27
5606
"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.city AS city_100,
t0.applicationsCount AS applicationsCount_101,
t0.startedCount AS startedCount_102,
t0.appliedCount AS appliedCount_103,
t0.approvedCount AS approvedCount_104,
t0.rejectedCount AS rejectedCount_105,
t0.$skoolWebhook AS skoolWebhook_106,
t0.zapierWebhook AS zapierWebhook_107,
t0.history AS history_108,
t0.createdAt AS createdAt_109,
t0.lastModified AS lastModified_110,
t0.lastChangeUser AS lastChangeUser_111,
t0.program_id AS program_id_112,
t0.assessmentTeamId AS assessmentTeamId_113
FROM
aab_batches t0
WHERE
t0.programId = ?
AND t0.eventId = ?
AND t0.status = ?
AND t0.access = ?
LIMIT
1
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.city AS city_100, t0.applicationsCount AS applicationsCount_101, t0.startedCount AS startedCount_102, t0.appliedCount AS appliedCount_103, t0.approvedCount AS approvedCount_104, t0.rejectedCount AS rejectedCount_105, t0.$skoolWebhook AS skoolWebhook_106, t0.zapierWebhook AS zapierWebhook_107, t0.history AS history_108, t0.createdAt AS createdAt_109, t0.lastModified AS lastModified_110, t0.lastChangeUser AS lastChangeUser_111, t0.program_id AS program_id_112, t0.assessmentTeamId AS assessmentTeamId_113 FROM aab_batches t0 WHERE t0.programId = 27 AND t0.eventId = 5606 AND t0.status = 'active' AND t0.access = 'anonymous' LIMIT 1;
|
| 3 |
1.95 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.city AS city_100, t0.applicationsCount AS applicationsCount_101, t0.startedCount AS startedCount_102, t0.appliedCount AS appliedCount_103, t0.approvedCount AS approvedCount_104, t0.rejectedCount AS rejectedCount_105, t0.$skoolWebhook AS skoolWebhook_106, t0.zapierWebhook AS zapierWebhook_107, t0.history AS history_108, t0.createdAt AS createdAt_109, t0.lastModified AS lastModified_110, t0.lastChangeUser AS lastChangeUser_111, t0.program_id AS program_id_112, t0.assessmentTeamId AS assessmentTeamId_113 FROM aab_batches t0 WHERE t0.programId = ? AND t0.eventId = ? AND t0.status = ? AND t0.access = ? LIMIT 1
Parameters: [
27
5606
"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.city AS city_100,
t0.applicationsCount AS applicationsCount_101,
t0.startedCount AS startedCount_102,
t0.appliedCount AS appliedCount_103,
t0.approvedCount AS approvedCount_104,
t0.rejectedCount AS rejectedCount_105,
t0.$skoolWebhook AS skoolWebhook_106,
t0.zapierWebhook AS zapierWebhook_107,
t0.history AS history_108,
t0.createdAt AS createdAt_109,
t0.lastModified AS lastModified_110,
t0.lastChangeUser AS lastChangeUser_111,
t0.program_id AS program_id_112,
t0.assessmentTeamId AS assessmentTeamId_113
FROM
aab_batches t0
WHERE
t0.programId = ?
AND t0.eventId = ?
AND t0.status = ?
AND t0.access = ?
LIMIT
1
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.city AS city_100, t0.applicationsCount AS applicationsCount_101, t0.startedCount AS startedCount_102, t0.appliedCount AS appliedCount_103, t0.approvedCount AS approvedCount_104, t0.rejectedCount AS rejectedCount_105, t0.$skoolWebhook AS skoolWebhook_106, t0.zapierWebhook AS zapierWebhook_107, t0.history AS history_108, t0.createdAt AS createdAt_109, t0.lastModified AS lastModified_110, t0.lastChangeUser AS lastChangeUser_111, t0.program_id AS program_id_112, t0.assessmentTeamId AS assessmentTeamId_113 FROM aab_batches t0 WHERE t0.programId = 27 AND t0.eventId = 5606 AND t0.status = 'completed' AND t0.access = 'anonymous' LIMIT 1;
|