| 1 |
0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_20, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_21, t0.eventId AS eventId_22, t0.zoomLink AS zoomLink_23, t0.typeformLink AS typeformLink_24, t0.mailTemplate AS mailTemplate_25, t0.mailSubject AS mailSubject_26, t0.reminderMailTemplateId AS reminderMailTemplateId_27, t0.reminderSenderEmail AS reminderSenderEmail_28, t0.phrasesDe AS phrasesDe_29, t0.phrasesEn AS phrasesEn_30, t0.settings AS settings_31, t0.createdAt AS createdAt_32, t0.lastModified AS lastModified_33, t0.lastChangeUser AS lastChangeUser_34 FROM sp_programs t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"membership"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_20, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_21, t0.eventId AS eventId_22, t0.zoomLink AS zoomLink_23, t0.typeformLink AS typeformLink_24, t0.mailTemplate AS mailTemplate_25, t0.mailSubject AS mailSubject_26, t0.reminderMailTemplateId AS reminderMailTemplateId_27, t0.reminderSenderEmail AS reminderSenderEmail_28, t0.phrasesDe AS phrasesDe_29, t0.phrasesEn AS phrasesEn_30, t0.settings AS settings_31, t0.createdAt AS createdAt_32, t0.lastModified AS lastModified_33, t0.lastChangeUser AS lastChangeUser_34 FROM sp_programs t0 WHERE t0.slug = 'membership' LIMIT 1;
|
| 2 |
0.81 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.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.slug = ? AND t0.programId = ? LIMIT 1
Parameters: [
"16018-cgn-community-membership"
5
]
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.hasRequirePhone AS hasRequirePhone_24,
t0.hasFollowUp AS hasFollowUp_25,
t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26,
t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27,
t0.isFutureEvent AS isFutureEvent_28,
t0.visibility AS visibility_29,
t0.access AS access_30,
t0.tags AS tags_31,
t0.typeformLink AS typeformLink_32,
t0.zoomLink AS zoomLink_33,
t0.bgImageUrl AS bgImageUrl_34,
t0.startDate AS startDate_35,
t0.endDate AS endDate_36,
t0.taxBehavior AS taxBehavior_37,
t0.paymentProvider AS paymentProvider_38,
t0.isFreeForKiCampus AS isFreeForKiCampus_39,
t0.isFreeForCommunity AS isFreeForCommunity_40,
t0.registrationMode AS registrationMode_41,
t0.externalRegistrationUrl AS externalRegistrationUrl_42,
t0.externalPlatform AS externalPlatform_43,
t0.registrationHeadline AS registrationHeadline_44,
t0.registrationSubtitle AS registrationSubtitle_45,
t0.registrationButtonText AS registrationButtonText_46,
t0.registrationPriceHtml AS registrationPriceHtml_47,
t0.registrationRedirectUrl AS registrationRedirectUrl_48,
t0.lumaEventApiId AS lumaEventApiId_49,
t0.meetupEventId AS meetupEventId_50,
t0.meetupEventUrl AS meetupEventUrl_51,
t0.mailDesignTemplate AS mailDesignTemplate_52,
t0.senderMail AS senderMail_53,
t0.fromName AS fromName_54,
t0.recipientMonitoringMail AS recipientMonitoringMail_55,
t0.confirmationMailSubject AS confirmationMailSubject_56,
t0.confirmationMailContent AS confirmationMailContent_57,
t0.adminNotificationMailSubject AS adminNotificationMailSubject_58,
t0.adminNotificationMailContent AS adminNotificationMailContent_59,
t0.reminderMailTemplateId AS reminderMailTemplateId_60,
t0.reminderSenderEmail AS reminderSenderEmail_61,
t0.reminderMailSendDate AS reminderMailSendDate_62,
t0.reminderMailSubject AS reminderMailSubject_63,
t0.reminderMailContent AS reminderMailContent_64,
t0.$reminderMailStatus AS reminderMailStatus_65,
t0.surveyId AS surveyId_66,
t0.surveyMailTemplateId AS surveyMailTemplateId_67,
t0.surveyBulkMailId AS surveyBulkMailId_68,
t0.template AS template_69,
t0.pageTemplate AS pageTemplate_70,
t0.footerTemplate AS footerTemplate_71,
t0.email AS email_72,
t0.emailSubject AS emailSubject_73,
t0.emailContent AS emailContent_74,
t0.landingPageContent AS landingPageContent_75,
t0.landingPageDescription AS landingPageDescription_76,
t0.landingPageCss AS landingPageCss_77,
t0.landingPageJs AS landingPageJs_78,
t0.landingPageFooterTemplate AS landingPageFooterTemplate_79,
t0.landingPageTitle AS landingPageTitle_80,
t0.landingPageTwig AS landingPageTwig_81,
t0.title AS title_82,
t0.teaser AS teaser_83,
t0.navbar AS navbar_84,
t0.content AS content_85,
t0.contentTwig AS contentTwig_86,
t0.content_blocks AS content_blocks_87,
t0.content_blocks_en AS content_blocks_en_88,
t0.ctaContent AS ctaContent_89,
t0.postCtaContent AS postCtaContent_90,
t0.tagline AS tagline_91,
t0.seoTitle AS seoTitle_92,
t0.seoDescription AS seoDescription_93,
t0.seoKeyword AS seoKeyword_94,
t0.imagelink AS imagelink_95,
t0.bgImagelink AS bgImagelink_96,
t0.additionalCss AS additionalCss_97,
t0.additionalJs AS additionalJs_98,
t0.navbarEn AS navbarEn_99,
t0.teaserEn AS teaserEn_100,
t0.contentEn AS contentEn_101,
t0.contentTwigEn AS contentTwigEn_102,
t0.postCtaContentEn AS postCtaContentEn_103,
t0.seoTitleEn AS seoTitleEn_104,
t0.seoDescriptionEn AS seoDescriptionEn_105,
t0.seoKeywordEn AS seoKeywordEn_106,
t0.trainer AS trainer_107,
t0.videolink AS videolink_108,
t0.goToPage AS goToPage_109,
t0.phrasesDe AS phrasesDe_110,
t0.phrasesEn AS phrasesEn_111,
t0.settings AS settings_112,
t0.capacity AS capacity_113,
t0.asssesmentDimensions AS asssesmentDimensions_114,
t0.start AS start_115,
t0.end AS end_116,
t0.pitchTopic AS pitchTopic_117,
t0.pitchImageLink AS pitchImageLink_118,
t0.pitchVideoLink AS pitchVideoLink_119,
t0.pitchPartner AS pitchPartner_120,
t0.pitchPartnerId AS pitchPartnerId_121,
t0.pitchDescription AS pitchDescription_122,
t0.followUpPageContent AS followUpPageContent_123,
t0.followUpPageDescription AS followUpPageDescription_124,
t0.followUpPageCss AS followUpPageCss_125,
t0.followUpPageJs AS followUpPageJs_126,
t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127,
t0.followUpPageTitle AS followUpPageTitle_128,
t0.followUpDescription AS followUpDescription_129,
t0.followUpVideoLink AS followUpVideoLink_130,
t0.followUpPresentation AS followUpPresentation_131,
t0.followUpSkoolUrl AS followUpSkoolUrl_132,
t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133,
t0.followUpCtaText AS followUpCtaText_134,
t0.followUpCtaUrl AS followUpCtaUrl_135,
t0.followUpDocuments AS followUpDocuments_136,
t0.followUpPhotos AS followUpPhotos_137,
t0.followUpExtraLinks AS followUpExtraLinks_138,
t0.followUpChecklist AS followUpChecklist_139,
t0.pitchDate AS pitchDate_140,
t0.pitchTime AS pitchTime_141,
t0.prepitchDate AS prepitchDate_142,
t0.scoutingEndDate AS scoutingEndDate_143,
t0.applicationStartDate AS applicationStartDate_144,
t0.applicationEndDate AS applicationEndDate_145,
t0.interviewInviteStartDate AS interviewInviteStartDate_146,
t0.interviewInviteEndDate AS interviewInviteEndDate_147,
t0.interviewStartDate AS interviewStartDate_148,
t0.interviewEndDate AS interviewEndDate_149,
t0.decisionDate AS decisionDate_150,
t0.contractDeadlineDate AS contractDeadlineDate_151,
t0.finalReportDate AS finalReportDate_152,
t0.applicationFormState AS applicationFormState_153,
t0.googleCalendarUrl AS googleCalendarUrl_154,
t0.city AS city_155,
t0.applicationsCount AS applicationsCount_156,
t0.startedCount AS startedCount_157,
t0.appliedCount AS appliedCount_158,
t0.approvedCount AS approvedCount_159,
t0.rejectedCount AS rejectedCount_160,
t0.$skoolWebhook AS skoolWebhook_161,
t0.zapierWebhook AS zapierWebhook_162,
t0.history AS history_163,
t0.createdAt AS createdAt_164,
t0.lastModified AS lastModified_165,
t0.lastChangeUser AS lastChangeUser_166,
t0.programId AS programId_167,
t0.assessmentTeamId AS assessmentTeamId_168
FROM
sp_batches t0
WHERE
t0.slug = ?
AND t0.programId = ?
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.hasRequirePhone AS hasRequirePhone_24, t0.hasFollowUp AS hasFollowUp_25, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_26, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_27, t0.isFutureEvent AS isFutureEvent_28, t0.visibility AS visibility_29, t0.access AS access_30, t0.tags AS tags_31, t0.typeformLink AS typeformLink_32, t0.zoomLink AS zoomLink_33, t0.bgImageUrl AS bgImageUrl_34, t0.startDate AS startDate_35, t0.endDate AS endDate_36, t0.taxBehavior AS taxBehavior_37, t0.paymentProvider AS paymentProvider_38, t0.isFreeForKiCampus AS isFreeForKiCampus_39, t0.isFreeForCommunity AS isFreeForCommunity_40, t0.registrationMode AS registrationMode_41, t0.externalRegistrationUrl AS externalRegistrationUrl_42, t0.externalPlatform AS externalPlatform_43, t0.registrationHeadline AS registrationHeadline_44, t0.registrationSubtitle AS registrationSubtitle_45, t0.registrationButtonText AS registrationButtonText_46, t0.registrationPriceHtml AS registrationPriceHtml_47, t0.registrationRedirectUrl AS registrationRedirectUrl_48, t0.lumaEventApiId AS lumaEventApiId_49, t0.meetupEventId AS meetupEventId_50, t0.meetupEventUrl AS meetupEventUrl_51, t0.mailDesignTemplate AS mailDesignTemplate_52, t0.senderMail AS senderMail_53, t0.fromName AS fromName_54, t0.recipientMonitoringMail AS recipientMonitoringMail_55, t0.confirmationMailSubject AS confirmationMailSubject_56, t0.confirmationMailContent AS confirmationMailContent_57, t0.adminNotificationMailSubject AS adminNotificationMailSubject_58, t0.adminNotificationMailContent AS adminNotificationMailContent_59, t0.reminderMailTemplateId AS reminderMailTemplateId_60, t0.reminderSenderEmail AS reminderSenderEmail_61, t0.reminderMailSendDate AS reminderMailSendDate_62, t0.reminderMailSubject AS reminderMailSubject_63, t0.reminderMailContent AS reminderMailContent_64, t0.$reminderMailStatus AS reminderMailStatus_65, t0.surveyId AS surveyId_66, t0.surveyMailTemplateId AS surveyMailTemplateId_67, t0.surveyBulkMailId AS surveyBulkMailId_68, t0.template AS template_69, t0.pageTemplate AS pageTemplate_70, t0.footerTemplate AS footerTemplate_71, t0.email AS email_72, t0.emailSubject AS emailSubject_73, t0.emailContent AS emailContent_74, t0.landingPageContent AS landingPageContent_75, t0.landingPageDescription AS landingPageDescription_76, t0.landingPageCss AS landingPageCss_77, t0.landingPageJs AS landingPageJs_78, t0.landingPageFooterTemplate AS landingPageFooterTemplate_79, t0.landingPageTitle AS landingPageTitle_80, t0.landingPageTwig AS landingPageTwig_81, t0.title AS title_82, t0.teaser AS teaser_83, t0.navbar AS navbar_84, t0.content AS content_85, t0.contentTwig AS contentTwig_86, t0.content_blocks AS content_blocks_87, t0.content_blocks_en AS content_blocks_en_88, t0.ctaContent AS ctaContent_89, t0.postCtaContent AS postCtaContent_90, t0.tagline AS tagline_91, t0.seoTitle AS seoTitle_92, t0.seoDescription AS seoDescription_93, t0.seoKeyword AS seoKeyword_94, t0.imagelink AS imagelink_95, t0.bgImagelink AS bgImagelink_96, t0.additionalCss AS additionalCss_97, t0.additionalJs AS additionalJs_98, t0.navbarEn AS navbarEn_99, t0.teaserEn AS teaserEn_100, t0.contentEn AS contentEn_101, t0.contentTwigEn AS contentTwigEn_102, t0.postCtaContentEn AS postCtaContentEn_103, t0.seoTitleEn AS seoTitleEn_104, t0.seoDescriptionEn AS seoDescriptionEn_105, t0.seoKeywordEn AS seoKeywordEn_106, t0.trainer AS trainer_107, t0.videolink AS videolink_108, t0.goToPage AS goToPage_109, t0.phrasesDe AS phrasesDe_110, t0.phrasesEn AS phrasesEn_111, t0.settings AS settings_112, t0.capacity AS capacity_113, t0.asssesmentDimensions AS asssesmentDimensions_114, t0.start AS start_115, t0.end AS end_116, t0.pitchTopic AS pitchTopic_117, t0.pitchImageLink AS pitchImageLink_118, t0.pitchVideoLink AS pitchVideoLink_119, t0.pitchPartner AS pitchPartner_120, t0.pitchPartnerId AS pitchPartnerId_121, t0.pitchDescription AS pitchDescription_122, t0.followUpPageContent AS followUpPageContent_123, t0.followUpPageDescription AS followUpPageDescription_124, t0.followUpPageCss AS followUpPageCss_125, t0.followUpPageJs AS followUpPageJs_126, t0.followUpPageFooterTemplate AS followUpPageFooterTemplate_127, t0.followUpPageTitle AS followUpPageTitle_128, t0.followUpDescription AS followUpDescription_129, t0.followUpVideoLink AS followUpVideoLink_130, t0.followUpPresentation AS followUpPresentation_131, t0.followUpSkoolUrl AS followUpSkoolUrl_132, t0.followUpWhatsAppUrl AS followUpWhatsAppUrl_133, t0.followUpCtaText AS followUpCtaText_134, t0.followUpCtaUrl AS followUpCtaUrl_135, t0.followUpDocuments AS followUpDocuments_136, t0.followUpPhotos AS followUpPhotos_137, t0.followUpExtraLinks AS followUpExtraLinks_138, t0.followUpChecklist AS followUpChecklist_139, t0.pitchDate AS pitchDate_140, t0.pitchTime AS pitchTime_141, t0.prepitchDate AS prepitchDate_142, t0.scoutingEndDate AS scoutingEndDate_143, t0.applicationStartDate AS applicationStartDate_144, t0.applicationEndDate AS applicationEndDate_145, t0.interviewInviteStartDate AS interviewInviteStartDate_146, t0.interviewInviteEndDate AS interviewInviteEndDate_147, t0.interviewStartDate AS interviewStartDate_148, t0.interviewEndDate AS interviewEndDate_149, t0.decisionDate AS decisionDate_150, t0.contractDeadlineDate AS contractDeadlineDate_151, t0.finalReportDate AS finalReportDate_152, t0.applicationFormState AS applicationFormState_153, t0.googleCalendarUrl AS googleCalendarUrl_154, t0.city AS city_155, t0.applicationsCount AS applicationsCount_156, t0.startedCount AS startedCount_157, t0.appliedCount AS appliedCount_158, t0.approvedCount AS approvedCount_159, t0.rejectedCount AS rejectedCount_160, t0.$skoolWebhook AS skoolWebhook_161, t0.zapierWebhook AS zapierWebhook_162, t0.history AS history_163, t0.createdAt AS createdAt_164, t0.lastModified AS lastModified_165, t0.lastChangeUser AS lastChangeUser_166, t0.programId AS programId_167, t0.assessmentTeamId AS assessmentTeamId_168 FROM sp_batches t0 WHERE t0.slug = '16018-cgn-community-membership' AND t0.programId = 5 LIMIT 1;
|
| 3 |
0.39 ms |
SELECT t0.id AS id_1, t0.account AS account_2, t0.agent AS agent_3, t0.productNumber AS productNumber_4, t0.prevNumber AS prevNumber_5, t0.status AS status_6, t0.location AS location_7, t0.name AS name_8, t0.slug AS slug_9, t0.description AS description_10, t0.imageUrl AS imageUrl_11, t0.faq AS faq_12, t0.landingPageSnippet AS landingPageSnippet_13, t0.type AS type_14, t0.bookingAccount AS bookingAccount_15, t0.noticeDays AS noticeDays_16, t0.easybillPositionId AS easybillPositionId_17, t0.easybillGroupId AS easybillGroupId_18, t0.monsumArticleId AS monsumArticleId_19, t0.monsumArticleNumber AS monsumArticleNumber_20, t0.monsumSettings AS monsumSettings_21, t0.stripeProductId AS stripeProductId_22, t0.stripePriceId AS stripePriceId_23, t0.stripeProductIdLive AS stripeProductIdLive_24, t0.stripePriceIdLive AS stripePriceIdLive_25, t0.stripeProductIdTest AS stripeProductIdTest_26, t0.stripePriceIdTest AS stripePriceIdTest_27, t0.stripeAccount AS stripeAccount_28, t0.stripeMode AS stripeMode_29, t0.stripeBillingInterval AS stripeBillingInterval_30, t0.settings AS settings_31, t0.isAddon AS isAddon_32, t0.isBookableByMember AS isBookableByMember_33, t0.isBookableByAdmin AS isBookableByAdmin_34, t0.hasToBeDelivered AS hasToBeDelivered_35, t0.price AS price_36, t0.pricePerHour AS pricePerHour_37, t0.reducedPrice AS reducedPrice_38, t0.reducedPricePerHour AS reducedPricePerHour_39, t0.vatPercent AS vatPercent_40, t0.costCenter AS costCenter_41, t0.lastChangeUser AS lastChangeUser_42, t0.lastModified AS lastModified_43, t0.history AS history_44 FROM sp_products t0 WHERE t0.account = ? AND t0.productNumber = ? AND t0.agent = ? LIMIT 1
Parameters: [
"SP-CGN"
"16018"
"monsum"
]
SELECT
t0.id AS id_1,
t0.account AS account_2,
t0.agent AS agent_3,
t0.productNumber AS productNumber_4,
t0.prevNumber AS prevNumber_5,
t0.status AS status_6,
t0.location AS location_7,
t0.name AS name_8,
t0.slug AS slug_9,
t0.description AS description_10,
t0.imageUrl AS imageUrl_11,
t0.faq AS faq_12,
t0.landingPageSnippet AS landingPageSnippet_13,
t0.type AS type_14,
t0.bookingAccount AS bookingAccount_15,
t0.noticeDays AS noticeDays_16,
t0.easybillPositionId AS easybillPositionId_17,
t0.easybillGroupId AS easybillGroupId_18,
t0.monsumArticleId AS monsumArticleId_19,
t0.monsumArticleNumber AS monsumArticleNumber_20,
t0.monsumSettings AS monsumSettings_21,
t0.stripeProductId AS stripeProductId_22,
t0.stripePriceId AS stripePriceId_23,
t0.stripeProductIdLive AS stripeProductIdLive_24,
t0.stripePriceIdLive AS stripePriceIdLive_25,
t0.stripeProductIdTest AS stripeProductIdTest_26,
t0.stripePriceIdTest AS stripePriceIdTest_27,
t0.stripeAccount AS stripeAccount_28,
t0.stripeMode AS stripeMode_29,
t0.stripeBillingInterval AS stripeBillingInterval_30,
t0.settings AS settings_31,
t0.isAddon AS isAddon_32,
t0.isBookableByMember AS isBookableByMember_33,
t0.isBookableByAdmin AS isBookableByAdmin_34,
t0.hasToBeDelivered AS hasToBeDelivered_35,
t0.price AS price_36,
t0.pricePerHour AS pricePerHour_37,
t0.reducedPrice AS reducedPrice_38,
t0.reducedPricePerHour AS reducedPricePerHour_39,
t0.vatPercent AS vatPercent_40,
t0.costCenter AS costCenter_41,
t0.lastChangeUser AS lastChangeUser_42,
t0.lastModified AS lastModified_43,
t0.history AS history_44
FROM
sp_products t0
WHERE
t0.account = ?
AND t0.productNumber = ?
AND t0.agent = ?
LIMIT
1
SELECT t0.id AS id_1, t0.account AS account_2, t0.agent AS agent_3, t0.productNumber AS productNumber_4, t0.prevNumber AS prevNumber_5, t0.status AS status_6, t0.location AS location_7, t0.name AS name_8, t0.slug AS slug_9, t0.description AS description_10, t0.imageUrl AS imageUrl_11, t0.faq AS faq_12, t0.landingPageSnippet AS landingPageSnippet_13, t0.type AS type_14, t0.bookingAccount AS bookingAccount_15, t0.noticeDays AS noticeDays_16, t0.easybillPositionId AS easybillPositionId_17, t0.easybillGroupId AS easybillGroupId_18, t0.monsumArticleId AS monsumArticleId_19, t0.monsumArticleNumber AS monsumArticleNumber_20, t0.monsumSettings AS monsumSettings_21, t0.stripeProductId AS stripeProductId_22, t0.stripePriceId AS stripePriceId_23, t0.stripeProductIdLive AS stripeProductIdLive_24, t0.stripePriceIdLive AS stripePriceIdLive_25, t0.stripeProductIdTest AS stripeProductIdTest_26, t0.stripePriceIdTest AS stripePriceIdTest_27, t0.stripeAccount AS stripeAccount_28, t0.stripeMode AS stripeMode_29, t0.stripeBillingInterval AS stripeBillingInterval_30, t0.settings AS settings_31, t0.isAddon AS isAddon_32, t0.isBookableByMember AS isBookableByMember_33, t0.isBookableByAdmin AS isBookableByAdmin_34, t0.hasToBeDelivered AS hasToBeDelivered_35, t0.price AS price_36, t0.pricePerHour AS pricePerHour_37, t0.reducedPrice AS reducedPrice_38, t0.reducedPricePerHour AS reducedPricePerHour_39, t0.vatPercent AS vatPercent_40, t0.costCenter AS costCenter_41, t0.lastChangeUser AS lastChangeUser_42, t0.lastModified AS lastModified_43, t0.history AS history_44 FROM sp_products t0 WHERE t0.account = 'SP-CGN' AND t0.productNumber = '16018' AND t0.agent = 'monsum' LIMIT 1;
|
| 4 |
0.78 ms |
SELECT t0.id AS id_1, t0.attributeId AS attributeId_2, t0.name AS name_3, t0.level AS level_4, t0.code AS code_5, t0.parent AS parent_6, t0.label AS label_7, t0.description AS description_8, t0.note AS note_9, t0.createdAt AS createdAt_10, t0.lastModified AS lastModified_11, t0.history AS history_12, t0.lastChangeUser AS lastChangeUser_13 FROM sp_setting_attributes t0 WHERE t0.name = ? ORDER BY t0.label ASC
Parameters: [
"startup.industry"
]
SELECT t0.id AS id_1, t0.attributeId AS attributeId_2, t0.name AS name_3, t0.level AS level_4, t0.code AS code_5, t0.parent AS parent_6, t0.label AS label_7, t0.description AS description_8, t0.note AS note_9, t0.createdAt AS createdAt_10, t0.lastModified AS lastModified_11, t0.history AS history_12, t0.lastChangeUser AS lastChangeUser_13 FROM sp_setting_attributes t0 WHERE t0.name = 'startup.industry' ORDER BY t0.label ASC;
|
| 5 |
0.50 ms |
SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.email = ? LIMIT 1
SELECT
t0.id AS id_1,
t0.score AS score_2,
t0.completenessScore AS completenessScore_3,
t0.status AS status_4,
t0.location AS location_5,
t0.salutation AS salutation_6,
t0.title AS title_7,
t0.jobTitle AS jobTitle_8,
t0.firstName AS firstName_9,
t0.lastName AS lastName_10,
t0.name AS name_11,
t0.sortName AS sortName_12,
t0.email AS email_13,
t0.secondaryEmail AS secondaryEmail_14,
t0.phone AS phone_15,
t0.hasCommunityMembership AS hasCommunityMembership_16,
t0.utm_source AS utm_source_17,
t0.utm_medium AS utm_medium_18,
t0.utm_campaign AS utm_campaign_19,
t0.utm_term AS utm_term_20,
t0.utm_content AS utm_content_21,
t0.birthday AS birthday_22,
t0.addressFieldOne AS addressFieldOne_23,
t0.addressFieldTwo AS addressFieldTwo_24,
t0.addressCountryCode AS addressCountryCode_25,
t0.addressPostalCode AS addressPostalCode_26,
t0.addressCity AS addressCity_27,
t0.teamId AS teamId_28,
t0.teamName AS teamName_29,
t0.company AS company_30,
t0.history AS history_31,
t0.tags AS tags_32,
t0.annotation AS annotation_33,
t0.mentorBuckets AS mentorBuckets_34,
t0.areasOfExpertise AS areasOfExpertise_35,
t0.mentor_firma AS mentor_firma_36,
t0.mentor_firma_url AS mentor_firma_url_37,
t0.mentor_locations AS mentor_locations_38,
t0.mentor_profile AS mentor_profile_39,
t0.mentor_note AS mentor_note_40,
t0.mentor_admin_rating AS mentor_admin_rating_41,
t0.active AS active_42,
t0.tiefgarage AS tiefgarage_43,
t0.transponder AS transponder_44,
t0.isTransponderAllowed AS isTransponderAllowed_45,
t0.imageLink AS imageLink_46,
t0.homepage AS homepage_47,
t0.xing AS xing_48,
t0.pipedriveId AS pipedriveId_49,
t0.linkedin AS linkedin_50,
t0.facebook AS facebook_51,
t0.instagram AS instagram_52,
t0.tiktok AS tiktok_53,
t0.threads AS threads_54,
t0.youtube AS youtube_55,
t0.twitter AS twitter_56,
t0.github AS github_57,
t0.reachableLocation AS reachableLocation_58,
t0.skills AS skills_59,
t0.description AS description_60,
t0.isVisibleInNetworking AS isVisibleInNetworking_61,
t0.gender AS gender_62,
t0.currentFocus AS currentFocus_63,
t0.networkingConsentAt AS networkingConsentAt_64,
t0.networkingConsentVersion AS networkingConsentVersion_65,
t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66,
t0.touchpoints AS touchpoints_67,
t0.isAddressComplete AS isAddressComplete_68,
t0.hasMailchimp AS hasMailchimp_69,
t0.hasKiNewsletter AS hasKiNewsletter_70,
t0.hubspotSyncPending AS hubspotSyncPending_71,
t0.enterDate AS enterDate_72,
t0.exitDate AS exitDate_73,
t0.physicalMembershipStarted AS physicalMembershipStarted_74,
t0.physicalMembershipEnded AS physicalMembershipEnded_75,
t0.lastModified AS lastModified_76,
t0.lastChangeUser AS lastChangeUser_77,
t0.onboardingCompletedAt AS onboardingCompletedAt_78,
t0.nAiWebinarsAttended AS nAiWebinarsAttended_79,
t0.nAiWebinarsApplied AS nAiWebinarsApplied_80,
t0.nAiEventsAttended AS nAiEventsAttended_81,
t0.nAiEventsApplied AS nAiEventsApplied_82,
t0.nPaidAttended AS nPaidAttended_83,
t0.nPaidApplied AS nPaidApplied_84,
t0.nKiEinstiegAttended AS nKiEinstiegAttended_85,
t0.nKiEinstiegApplied AS nKiEinstiegApplied_86,
t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87,
t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88,
t0.nEcodynamicsAttended AS nEcodynamicsAttended_89,
t0.nEcodynamicsApplied AS nEcodynamicsApplied_90,
t0.nBbqApplied AS nBbqApplied_91,
t0.nAiFridayApplied AS nAiFridayApplied_92,
t0.nAiGatheringApplied AS nAiGatheringApplied_93,
t0.nAiGatheringAttended AS nAiGatheringAttended_94,
t0.aiSs24Applied AS aiSs24Applied_95,
t0.aiSs24Booked AS aiSs24Booked_96,
t0.interestedIn AS interestedIn_97,
t0.interests AS interests_98,
t0.mentorMetadata AS mentorMetadata_99,
t0.eventParticipations AS eventParticipations_100,
t0.kiKompetenz AS kiKompetenz_101,
t0.mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0.email = ?
LIMIT
1
SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.email = '' LIMIT 1;
|
| 6 |
0.51 ms |
SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.location AS location_3, t0.locationSecond AS locationSecond_4, t0.name AS name_5, t0.shortName AS shortName_6, t0.previousName AS previousName_7, t0.person AS person_8, t0.phone AS phone_9, t0.addressFieldOne AS addressFieldOne_10, t0.addressFieldTwo AS addressFieldTwo_11, t0.addressCountryCode AS addressCountryCode_12, t0.addressPostalCode AS addressPostalCode_13, t0.addressCity AS addressCity_14, t0.spTeamId AS spTeamId_15, t0.accountEmail AS accountEmail_16, t0.connectEmail AS connectEmail_17, t0.status AS status_18, t0.hasCommunityMembership AS hasCommunityMembership_19, t0.isTransponderAllowed AS isTransponderAllowed_20, t0.jobPostingEnabled AS jobPostingEnabled_21, t0.jobPostingNoExpiry AS jobPostingNoExpiry_22, t0.jobCompanyType AS jobCompanyType_23, t0.hasStartupMembership AS hasStartupMembership_24, t0.isIncludeInUpdateType AS isIncludeInUpdateType_25, t0.isCompany AS isCompany_26, t0.isAddressComplete AS isAddressComplete_27, t0.isDebitor AS isDebitor_28, t0.type AS type_29, t0.internalDescription AS internalDescription_30, t0.monsumCustomerType AS monsumCustomerType_31, t0.homepage AS homepage_32, t0.logoURL AS logoURL_33, t0.industries AS industries_34, t0.description AS description_35, t0.note AS note_36, t0.tags AS tags_37, t0.categories AS categories_38, t0.alertNote AS alertNote_39, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_40, t0.monthlyExtraBudget AS monthlyExtraBudget_41, t0.sameDayBudget AS sameDayBudget_42, t0.sameDayBudgetUsed AS sameDayBudgetUsed_43, t0.sameDayExtraBudget AS sameDayExtraBudget_44, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_45, t0.communityBudget AS communityBudget_46, t0.communityBudgetUsed AS communityBudgetUsed_47, t0.meetingRoomsBudget AS meetingRoomsBudget_48, t0.conferenceRoomsBudget AS conferenceRoomsBudget_49, t0.coffeeCoinsBudget AS coffeeCoinsBudget_50, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_51, t0.meetingRoomsBooked AS meetingRoomsBooked_52, t0.conferenceRoomsBooked AS conferenceRoomsBooked_53, t0.todayRoomsBooked AS todayRoomsBooked_54, t0.nDedicatedDesks AS nDedicatedDesks_55, t0.nFlexibleDesks AS nFlexibleDesks_56, t0.nBasicMemberships AS nBasicMemberships_57, t0.nEmployees AS nEmployees_58, t0.nTransponders AS nTransponders_59, t0.nTiefgarage AS nTiefgarage_60, t0.editStatus AS editStatus_61, t0.xing AS xing_62, t0.linkedin AS linkedin_63, t0.facebook AS facebook_64, t0.twitter AS twitter_65, t0.instagram AS instagram_66, t0.enterDate AS enterDate_67, t0.lastChangeDate AS lastChangeDate_68, t0.lastModified AS lastModified_69, t0.lastInvoiceDate AS lastInvoiceDate_70, t0.exitDate AS exitDate_71, t0.isRedundant AS isRedundant_72, t0.gsStatus AS gsStatus_73, t0.gsBatchNo AS gsBatchNo_74, t0.gsNote AS gsNote_75, t0.gsIdeenblattDate AS gsIdeenblattDate_76, t0.gsJuryDate AS gsJuryDate_77, t0.gsCoachMemberId AS gsCoachMemberId_78, t0.gsCoachMemberName AS gsCoachMemberName_79, t0.spContactPerson AS spContactPerson_80, t0.memberTag AS memberTag_81, t0.actionTag AS actionTag_82, t0.createdAt AS createdAt_83, t0.lastChangeUser AS lastChangeUser_84, t0.history AS history_85, t0.treatAsSubscribed AS treatAsSubscribed_86, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_87, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_88, t0.treatAsSubscribedReason AS treatAsSubscribedReason_89, t0.searchAliases AS searchAliases_90 FROM sp_teams t0 WHERE t0.type = ? AND t0.name = ? LIMIT 1
Parameters: [
"Virtual Team"
"membership-16018-applicants"
]
SELECT
t0.id AS id_1,
t0.startupId AS startupId_2,
t0.location AS location_3,
t0.locationSecond AS locationSecond_4,
t0.name AS name_5,
t0.shortName AS shortName_6,
t0.previousName AS previousName_7,
t0.person AS person_8,
t0.phone AS phone_9,
t0.addressFieldOne AS addressFieldOne_10,
t0.addressFieldTwo AS addressFieldTwo_11,
t0.addressCountryCode AS addressCountryCode_12,
t0.addressPostalCode AS addressPostalCode_13,
t0.addressCity AS addressCity_14,
t0.spTeamId AS spTeamId_15,
t0.accountEmail AS accountEmail_16,
t0.connectEmail AS connectEmail_17,
t0.status AS status_18,
t0.hasCommunityMembership AS hasCommunityMembership_19,
t0.isTransponderAllowed AS isTransponderAllowed_20,
t0.jobPostingEnabled AS jobPostingEnabled_21,
t0.jobPostingNoExpiry AS jobPostingNoExpiry_22,
t0.jobCompanyType AS jobCompanyType_23,
t0.hasStartupMembership AS hasStartupMembership_24,
t0.isIncludeInUpdateType AS isIncludeInUpdateType_25,
t0.isCompany AS isCompany_26,
t0.isAddressComplete AS isAddressComplete_27,
t0.isDebitor AS isDebitor_28,
t0.type AS type_29,
t0.internalDescription AS internalDescription_30,
t0.monsumCustomerType AS monsumCustomerType_31,
t0.homepage AS homepage_32,
t0.logoURL AS logoURL_33,
t0.industries AS industries_34,
t0.description AS description_35,
t0.note AS note_36,
t0.tags AS tags_37,
t0.categories AS categories_38,
t0.alertNote AS alertNote_39,
t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_40,
t0.monthlyExtraBudget AS monthlyExtraBudget_41,
t0.sameDayBudget AS sameDayBudget_42,
t0.sameDayBudgetUsed AS sameDayBudgetUsed_43,
t0.sameDayExtraBudget AS sameDayExtraBudget_44,
t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_45,
t0.communityBudget AS communityBudget_46,
t0.communityBudgetUsed AS communityBudgetUsed_47,
t0.meetingRoomsBudget AS meetingRoomsBudget_48,
t0.conferenceRoomsBudget AS conferenceRoomsBudget_49,
t0.coffeeCoinsBudget AS coffeeCoinsBudget_50,
t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_51,
t0.meetingRoomsBooked AS meetingRoomsBooked_52,
t0.conferenceRoomsBooked AS conferenceRoomsBooked_53,
t0.todayRoomsBooked AS todayRoomsBooked_54,
t0.nDedicatedDesks AS nDedicatedDesks_55,
t0.nFlexibleDesks AS nFlexibleDesks_56,
t0.nBasicMemberships AS nBasicMemberships_57,
t0.nEmployees AS nEmployees_58,
t0.nTransponders AS nTransponders_59,
t0.nTiefgarage AS nTiefgarage_60,
t0.editStatus AS editStatus_61,
t0.xing AS xing_62,
t0.linkedin AS linkedin_63,
t0.facebook AS facebook_64,
t0.twitter AS twitter_65,
t0.instagram AS instagram_66,
t0.enterDate AS enterDate_67,
t0.lastChangeDate AS lastChangeDate_68,
t0.lastModified AS lastModified_69,
t0.lastInvoiceDate AS lastInvoiceDate_70,
t0.exitDate AS exitDate_71,
t0.isRedundant AS isRedundant_72,
t0.gsStatus AS gsStatus_73,
t0.gsBatchNo AS gsBatchNo_74,
t0.gsNote AS gsNote_75,
t0.gsIdeenblattDate AS gsIdeenblattDate_76,
t0.gsJuryDate AS gsJuryDate_77,
t0.gsCoachMemberId AS gsCoachMemberId_78,
t0.gsCoachMemberName AS gsCoachMemberName_79,
t0.spContactPerson AS spContactPerson_80,
t0.memberTag AS memberTag_81,
t0.actionTag AS actionTag_82,
t0.createdAt AS createdAt_83,
t0.lastChangeUser AS lastChangeUser_84,
t0.history AS history_85,
t0.treatAsSubscribed AS treatAsSubscribed_86,
t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_87,
t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_88,
t0.treatAsSubscribedReason AS treatAsSubscribedReason_89,
t0.searchAliases AS searchAliases_90
FROM
sp_teams t0
WHERE
t0.type = ?
AND t0.name = ?
LIMIT
1
SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.location AS location_3, t0.locationSecond AS locationSecond_4, t0.name AS name_5, t0.shortName AS shortName_6, t0.previousName AS previousName_7, t0.person AS person_8, t0.phone AS phone_9, t0.addressFieldOne AS addressFieldOne_10, t0.addressFieldTwo AS addressFieldTwo_11, t0.addressCountryCode AS addressCountryCode_12, t0.addressPostalCode AS addressPostalCode_13, t0.addressCity AS addressCity_14, t0.spTeamId AS spTeamId_15, t0.accountEmail AS accountEmail_16, t0.connectEmail AS connectEmail_17, t0.status AS status_18, t0.hasCommunityMembership AS hasCommunityMembership_19, t0.isTransponderAllowed AS isTransponderAllowed_20, t0.jobPostingEnabled AS jobPostingEnabled_21, t0.jobPostingNoExpiry AS jobPostingNoExpiry_22, t0.jobCompanyType AS jobCompanyType_23, t0.hasStartupMembership AS hasStartupMembership_24, t0.isIncludeInUpdateType AS isIncludeInUpdateType_25, t0.isCompany AS isCompany_26, t0.isAddressComplete AS isAddressComplete_27, t0.isDebitor AS isDebitor_28, t0.type AS type_29, t0.internalDescription AS internalDescription_30, t0.monsumCustomerType AS monsumCustomerType_31, t0.homepage AS homepage_32, t0.logoURL AS logoURL_33, t0.industries AS industries_34, t0.description AS description_35, t0.note AS note_36, t0.tags AS tags_37, t0.categories AS categories_38, t0.alertNote AS alertNote_39, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_40, t0.monthlyExtraBudget AS monthlyExtraBudget_41, t0.sameDayBudget AS sameDayBudget_42, t0.sameDayBudgetUsed AS sameDayBudgetUsed_43, t0.sameDayExtraBudget AS sameDayExtraBudget_44, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_45, t0.communityBudget AS communityBudget_46, t0.communityBudgetUsed AS communityBudgetUsed_47, t0.meetingRoomsBudget AS meetingRoomsBudget_48, t0.conferenceRoomsBudget AS conferenceRoomsBudget_49, t0.coffeeCoinsBudget AS coffeeCoinsBudget_50, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_51, t0.meetingRoomsBooked AS meetingRoomsBooked_52, t0.conferenceRoomsBooked AS conferenceRoomsBooked_53, t0.todayRoomsBooked AS todayRoomsBooked_54, t0.nDedicatedDesks AS nDedicatedDesks_55, t0.nFlexibleDesks AS nFlexibleDesks_56, t0.nBasicMemberships AS nBasicMemberships_57, t0.nEmployees AS nEmployees_58, t0.nTransponders AS nTransponders_59, t0.nTiefgarage AS nTiefgarage_60, t0.editStatus AS editStatus_61, t0.xing AS xing_62, t0.linkedin AS linkedin_63, t0.facebook AS facebook_64, t0.twitter AS twitter_65, t0.instagram AS instagram_66, t0.enterDate AS enterDate_67, t0.lastChangeDate AS lastChangeDate_68, t0.lastModified AS lastModified_69, t0.lastInvoiceDate AS lastInvoiceDate_70, t0.exitDate AS exitDate_71, t0.isRedundant AS isRedundant_72, t0.gsStatus AS gsStatus_73, t0.gsBatchNo AS gsBatchNo_74, t0.gsNote AS gsNote_75, t0.gsIdeenblattDate AS gsIdeenblattDate_76, t0.gsJuryDate AS gsJuryDate_77, t0.gsCoachMemberId AS gsCoachMemberId_78, t0.gsCoachMemberName AS gsCoachMemberName_79, t0.spContactPerson AS spContactPerson_80, t0.memberTag AS memberTag_81, t0.actionTag AS actionTag_82, t0.createdAt AS createdAt_83, t0.lastChangeUser AS lastChangeUser_84, t0.history AS history_85, t0.treatAsSubscribed AS treatAsSubscribed_86, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_87, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_88, t0.treatAsSubscribedReason AS treatAsSubscribedReason_89, t0.searchAliases AS searchAliases_90 FROM sp_teams t0 WHERE t0.type = 'Virtual Team' AND t0.name = 'membership-16018-applicants' LIMIT 1;
|
| 7 |
0.41 ms |
SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.email = ? LIMIT 1
SELECT
t0.id AS id_1,
t0.score AS score_2,
t0.completenessScore AS completenessScore_3,
t0.status AS status_4,
t0.location AS location_5,
t0.salutation AS salutation_6,
t0.title AS title_7,
t0.jobTitle AS jobTitle_8,
t0.firstName AS firstName_9,
t0.lastName AS lastName_10,
t0.name AS name_11,
t0.sortName AS sortName_12,
t0.email AS email_13,
t0.secondaryEmail AS secondaryEmail_14,
t0.phone AS phone_15,
t0.hasCommunityMembership AS hasCommunityMembership_16,
t0.utm_source AS utm_source_17,
t0.utm_medium AS utm_medium_18,
t0.utm_campaign AS utm_campaign_19,
t0.utm_term AS utm_term_20,
t0.utm_content AS utm_content_21,
t0.birthday AS birthday_22,
t0.addressFieldOne AS addressFieldOne_23,
t0.addressFieldTwo AS addressFieldTwo_24,
t0.addressCountryCode AS addressCountryCode_25,
t0.addressPostalCode AS addressPostalCode_26,
t0.addressCity AS addressCity_27,
t0.teamId AS teamId_28,
t0.teamName AS teamName_29,
t0.company AS company_30,
t0.history AS history_31,
t0.tags AS tags_32,
t0.annotation AS annotation_33,
t0.mentorBuckets AS mentorBuckets_34,
t0.areasOfExpertise AS areasOfExpertise_35,
t0.mentor_firma AS mentor_firma_36,
t0.mentor_firma_url AS mentor_firma_url_37,
t0.mentor_locations AS mentor_locations_38,
t0.mentor_profile AS mentor_profile_39,
t0.mentor_note AS mentor_note_40,
t0.mentor_admin_rating AS mentor_admin_rating_41,
t0.active AS active_42,
t0.tiefgarage AS tiefgarage_43,
t0.transponder AS transponder_44,
t0.isTransponderAllowed AS isTransponderAllowed_45,
t0.imageLink AS imageLink_46,
t0.homepage AS homepage_47,
t0.xing AS xing_48,
t0.pipedriveId AS pipedriveId_49,
t0.linkedin AS linkedin_50,
t0.facebook AS facebook_51,
t0.instagram AS instagram_52,
t0.tiktok AS tiktok_53,
t0.threads AS threads_54,
t0.youtube AS youtube_55,
t0.twitter AS twitter_56,
t0.github AS github_57,
t0.reachableLocation AS reachableLocation_58,
t0.skills AS skills_59,
t0.description AS description_60,
t0.isVisibleInNetworking AS isVisibleInNetworking_61,
t0.gender AS gender_62,
t0.currentFocus AS currentFocus_63,
t0.networkingConsentAt AS networkingConsentAt_64,
t0.networkingConsentVersion AS networkingConsentVersion_65,
t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66,
t0.touchpoints AS touchpoints_67,
t0.isAddressComplete AS isAddressComplete_68,
t0.hasMailchimp AS hasMailchimp_69,
t0.hasKiNewsletter AS hasKiNewsletter_70,
t0.hubspotSyncPending AS hubspotSyncPending_71,
t0.enterDate AS enterDate_72,
t0.exitDate AS exitDate_73,
t0.physicalMembershipStarted AS physicalMembershipStarted_74,
t0.physicalMembershipEnded AS physicalMembershipEnded_75,
t0.lastModified AS lastModified_76,
t0.lastChangeUser AS lastChangeUser_77,
t0.onboardingCompletedAt AS onboardingCompletedAt_78,
t0.nAiWebinarsAttended AS nAiWebinarsAttended_79,
t0.nAiWebinarsApplied AS nAiWebinarsApplied_80,
t0.nAiEventsAttended AS nAiEventsAttended_81,
t0.nAiEventsApplied AS nAiEventsApplied_82,
t0.nPaidAttended AS nPaidAttended_83,
t0.nPaidApplied AS nPaidApplied_84,
t0.nKiEinstiegAttended AS nKiEinstiegAttended_85,
t0.nKiEinstiegApplied AS nKiEinstiegApplied_86,
t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87,
t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88,
t0.nEcodynamicsAttended AS nEcodynamicsAttended_89,
t0.nEcodynamicsApplied AS nEcodynamicsApplied_90,
t0.nBbqApplied AS nBbqApplied_91,
t0.nAiFridayApplied AS nAiFridayApplied_92,
t0.nAiGatheringApplied AS nAiGatheringApplied_93,
t0.nAiGatheringAttended AS nAiGatheringAttended_94,
t0.aiSs24Applied AS aiSs24Applied_95,
t0.aiSs24Booked AS aiSs24Booked_96,
t0.interestedIn AS interestedIn_97,
t0.interests AS interests_98,
t0.mentorMetadata AS mentorMetadata_99,
t0.eventParticipations AS eventParticipations_100,
t0.kiKompetenz AS kiKompetenz_101,
t0.mentorOwnerId AS mentorOwnerId_102
FROM
sp_members t0
WHERE
t0.email = ?
LIMIT
1
SELECT t0.id AS id_1, t0.score AS score_2, t0.completenessScore AS completenessScore_3, t0.status AS status_4, t0.location AS location_5, t0.salutation AS salutation_6, t0.title AS title_7, t0.jobTitle AS jobTitle_8, t0.firstName AS firstName_9, t0.lastName AS lastName_10, t0.name AS name_11, t0.sortName AS sortName_12, t0.email AS email_13, t0.secondaryEmail AS secondaryEmail_14, t0.phone AS phone_15, t0.hasCommunityMembership AS hasCommunityMembership_16, t0.utm_source AS utm_source_17, t0.utm_medium AS utm_medium_18, t0.utm_campaign AS utm_campaign_19, t0.utm_term AS utm_term_20, t0.utm_content AS utm_content_21, t0.birthday AS birthday_22, t0.addressFieldOne AS addressFieldOne_23, t0.addressFieldTwo AS addressFieldTwo_24, t0.addressCountryCode AS addressCountryCode_25, t0.addressPostalCode AS addressPostalCode_26, t0.addressCity AS addressCity_27, t0.teamId AS teamId_28, t0.teamName AS teamName_29, t0.company AS company_30, t0.history AS history_31, t0.tags AS tags_32, t0.annotation AS annotation_33, t0.mentorBuckets AS mentorBuckets_34, t0.areasOfExpertise AS areasOfExpertise_35, t0.mentor_firma AS mentor_firma_36, t0.mentor_firma_url AS mentor_firma_url_37, t0.mentor_locations AS mentor_locations_38, t0.mentor_profile AS mentor_profile_39, t0.mentor_note AS mentor_note_40, t0.mentor_admin_rating AS mentor_admin_rating_41, t0.active AS active_42, t0.tiefgarage AS tiefgarage_43, t0.transponder AS transponder_44, t0.isTransponderAllowed AS isTransponderAllowed_45, t0.imageLink AS imageLink_46, t0.homepage AS homepage_47, t0.xing AS xing_48, t0.pipedriveId AS pipedriveId_49, t0.linkedin AS linkedin_50, t0.facebook AS facebook_51, t0.instagram AS instagram_52, t0.tiktok AS tiktok_53, t0.threads AS threads_54, t0.youtube AS youtube_55, t0.twitter AS twitter_56, t0.github AS github_57, t0.reachableLocation AS reachableLocation_58, t0.skills AS skills_59, t0.description AS description_60, t0.isVisibleInNetworking AS isVisibleInNetworking_61, t0.gender AS gender_62, t0.currentFocus AS currentFocus_63, t0.networkingConsentAt AS networkingConsentAt_64, t0.networkingConsentVersion AS networkingConsentVersion_65, t0.networkingConsentRevokedAt AS networkingConsentRevokedAt_66, t0.touchpoints AS touchpoints_67, t0.isAddressComplete AS isAddressComplete_68, t0.hasMailchimp AS hasMailchimp_69, t0.hasKiNewsletter AS hasKiNewsletter_70, t0.hubspotSyncPending AS hubspotSyncPending_71, t0.enterDate AS enterDate_72, t0.exitDate AS exitDate_73, t0.physicalMembershipStarted AS physicalMembershipStarted_74, t0.physicalMembershipEnded AS physicalMembershipEnded_75, t0.lastModified AS lastModified_76, t0.lastChangeUser AS lastChangeUser_77, t0.onboardingCompletedAt AS onboardingCompletedAt_78, t0.nAiWebinarsAttended AS nAiWebinarsAttended_79, t0.nAiWebinarsApplied AS nAiWebinarsApplied_80, t0.nAiEventsAttended AS nAiEventsAttended_81, t0.nAiEventsApplied AS nAiEventsApplied_82, t0.nPaidAttended AS nPaidAttended_83, t0.nPaidApplied AS nPaidApplied_84, t0.nKiEinstiegAttended AS nKiEinstiegAttended_85, t0.nKiEinstiegApplied AS nKiEinstiegApplied_86, t0.nPromptEngineeringAttended AS nPromptEngineeringAttended_87, t0.nPromptEngineeringApplied AS nPromptEngineeringApplied_88, t0.nEcodynamicsAttended AS nEcodynamicsAttended_89, t0.nEcodynamicsApplied AS nEcodynamicsApplied_90, t0.nBbqApplied AS nBbqApplied_91, t0.nAiFridayApplied AS nAiFridayApplied_92, t0.nAiGatheringApplied AS nAiGatheringApplied_93, t0.nAiGatheringAttended AS nAiGatheringAttended_94, t0.aiSs24Applied AS aiSs24Applied_95, t0.aiSs24Booked AS aiSs24Booked_96, t0.interestedIn AS interestedIn_97, t0.interests AS interests_98, t0.mentorMetadata AS mentorMetadata_99, t0.eventParticipations AS eventParticipations_100, t0.kiKompetenz AS kiKompetenz_101, t0.mentorOwnerId AS mentorOwnerId_102 FROM sp_members t0 WHERE t0.email = '' LIMIT 1;
|
| 8 |
0.18 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.isConfirmed AS isConfirmed_3, t0.team_id AS team_id_4, t0.member_id AS member_id_5 FROM sp_member_teams t0 WHERE t0.team_id = ? AND t0.member_id = ? LIMIT 1
Parameters: [
18324
null
]
SELECT t0.id AS id_1, t0.type AS type_2, t0.isConfirmed AS isConfirmed_3, t0.team_id AS team_id_4, t0.member_id AS member_id_5 FROM sp_member_teams t0 WHERE t0.team_id = 18324 AND t0.member_id = NULL LIMIT 1;
|
| 9 |
0.25 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;
|
| 10 |
0.17 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.isConfirmed AS isConfirmed_3, t0.team_id AS team_id_4, t0.member_id AS member_id_5 FROM sp_member_teams t0 WHERE t0.team_id = ? AND t0.member_id = ? LIMIT 1
Parameters: [
18324
null
]
SELECT t0.id AS id_1, t0.type AS type_2, t0.isConfirmed AS isConfirmed_3, t0.team_id AS team_id_4, t0.member_id AS member_id_5 FROM sp_member_teams t0 WHERE t0.team_id = 18324 AND t0.member_id = NULL LIMIT 1;
|
| 11 |
0.40 ms |
SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.id IS NULL LIMIT 1
SELECT
t0.id AS id_1,
t0.eventbriteId AS eventbriteId_2,
t0.googleCalendarEventId AS googleCalendarEventId_3,
t0.wpPostId AS wpPostId_4,
t0.title AS title_5,
t0.title_en AS title_en_6,
t0.slug AS slug_7,
t0.lang AS lang_8,
t0.imagelink AS imagelink_9,
t0.videolink AS videolink_10,
t0.bgImagelink AS bgImagelink_11,
t0.tagline AS tagline_12,
t0.headerTextColor AS headerTextColor_13,
t0.spResponsiblePerson AS spResponsiblePerson_14,
t0.organization AS organization_15,
t0.organizerName AS organizerName_16,
t0.organizerEmail AS organizerEmail_17,
t0.venueName AS venueName_18,
t0.venueAddress AS venueAddress_19,
t0.showFullVenue AS showFullVenue_20,
t0.ticketing AS ticketing_21,
t0.applicationUrl AS applicationUrl_22,
t0.alert AS alert_23,
t0.trainer AS trainer_24,
t0.speakers AS speakers_25,
t0.teaser AS teaser_26,
t0.navbar AS navbar_27,
t0.stripePriceId AS stripePriceId_28,
t0.stripeProductId AS stripeProductId_29,
t0.stripeAccount AS stripeAccount_30,
t0.priceInEuroCent AS priceInEuroCent_31,
t0.isTaxIncluded AS isTaxIncluded_32,
t0.isFreeForKiCampus AS isFreeForKiCampus_33,
t0.isFreeForCommunity AS isFreeForCommunity_34,
t0.isSinglePage AS isSinglePage_35,
t0.isFormalLanguage AS isFormalLanguage_36,
t0.isMultiBatchEvent AS isMultiBatchEvent_37,
t0.isFeatured AS isFeatured_38,
t0.isFlagship AS isFlagship_39,
t0.capacity AS capacity_40,
t0.targetCapacity AS targetCapacity_41,
t0.twigFile AS twigFile_42,
t0.additionalCss AS additionalCss_43,
t0.content AS content_44,
t0.contentTwig AS contentTwig_45,
t0.content_blocks AS content_blocks_46,
t0.content_blocks_en AS content_blocks_en_47,
t0.ctaContent AS ctaContent_48,
t0.postCtaContent AS postCtaContent_49,
t0.tags AS tags_50,
t0.seriesTag AS seriesTag_51,
t0.feedbackFormId AS feedbackFormId_52,
t0.type AS type_53,
t0.location AS location_54,
t0.startDate AS startDate_55,
t0.endDate AS endDate_56,
t0.duration AS duration_57,
t0.status AS status_58,
t0.publishedAt AS publishedAt_59,
t0.publishedBy AS publishedBy_60,
t0.settings AS settings_61,
t0.displayStartDate AS displayStartDate_62,
t0.seoTitle AS seoTitle_63,
t0.seoKeyword AS seoKeyword_64,
t0.seoDescription AS seoDescription_65,
t0.navbar_en AS navbar_en_66,
t0.teaser_en AS teaser_en_67,
t0.content_en AS content_en_68,
t0.content_twig_en AS content_twig_en_69,
t0.post_cta_content_en AS post_cta_content_en_70,
t0.seo_title_en AS seo_title_en_71,
t0.seo_description_en AS seo_description_en_72,
t0.seo_keyword_en AS seo_keyword_en_73,
t0.has_english_version AS has_english_version_74,
t0.additional_js AS additional_js_75,
t0.metaPixelId AS metaPixelId_76,
t0.createDate AS createDate_77,
t0.lastChangeDate AS lastChangeDate_78,
t0.lastChangeUser AS lastChangeUser_79,
t0.publicId AS publicId_80,
t0.isExternalSubmission AS isExternalSubmission_81,
t0.createdBy AS createdBy_82,
t0.lastModified AS lastModified_83,
t0.createdAt AS createdAt_84,
t0.orgaNote AS orgaNote_85,
t0.calendarSyncedAt AS calendarSyncedAt_86,
t0.logisticsRoom AS logisticsRoom_87,
t0.logisticsCatering AS logisticsCatering_88,
t0.logisticsEquipment AS logisticsEquipment_89,
t0.logisticsHelpers AS logisticsHelpers_90,
t0.history AS history_91,
t0.todoHistory AS todoHistory_92
FROM
sp_event_events t0
WHERE
t0.id IS NULL
LIMIT
1
SELECT t0.id AS id_1, t0.eventbriteId AS eventbriteId_2, t0.googleCalendarEventId AS googleCalendarEventId_3, t0.wpPostId AS wpPostId_4, t0.title AS title_5, t0.title_en AS title_en_6, t0.slug AS slug_7, t0.lang AS lang_8, t0.imagelink AS imagelink_9, t0.videolink AS videolink_10, t0.bgImagelink AS bgImagelink_11, t0.tagline AS tagline_12, t0.headerTextColor AS headerTextColor_13, t0.spResponsiblePerson AS spResponsiblePerson_14, t0.organization AS organization_15, t0.organizerName AS organizerName_16, t0.organizerEmail AS organizerEmail_17, t0.venueName AS venueName_18, t0.venueAddress AS venueAddress_19, t0.showFullVenue AS showFullVenue_20, t0.ticketing AS ticketing_21, t0.applicationUrl AS applicationUrl_22, t0.alert AS alert_23, t0.trainer AS trainer_24, t0.speakers AS speakers_25, t0.teaser AS teaser_26, t0.navbar AS navbar_27, t0.stripePriceId AS stripePriceId_28, t0.stripeProductId AS stripeProductId_29, t0.stripeAccount AS stripeAccount_30, t0.priceInEuroCent AS priceInEuroCent_31, t0.isTaxIncluded AS isTaxIncluded_32, t0.isFreeForKiCampus AS isFreeForKiCampus_33, t0.isFreeForCommunity AS isFreeForCommunity_34, t0.isSinglePage AS isSinglePage_35, t0.isFormalLanguage AS isFormalLanguage_36, t0.isMultiBatchEvent AS isMultiBatchEvent_37, t0.isFeatured AS isFeatured_38, t0.isFlagship AS isFlagship_39, t0.capacity AS capacity_40, t0.targetCapacity AS targetCapacity_41, t0.twigFile AS twigFile_42, t0.additionalCss AS additionalCss_43, t0.content AS content_44, t0.contentTwig AS contentTwig_45, t0.content_blocks AS content_blocks_46, t0.content_blocks_en AS content_blocks_en_47, t0.ctaContent AS ctaContent_48, t0.postCtaContent AS postCtaContent_49, t0.tags AS tags_50, t0.seriesTag AS seriesTag_51, t0.feedbackFormId AS feedbackFormId_52, t0.type AS type_53, t0.location AS location_54, t0.startDate AS startDate_55, t0.endDate AS endDate_56, t0.duration AS duration_57, t0.status AS status_58, t0.publishedAt AS publishedAt_59, t0.publishedBy AS publishedBy_60, t0.settings AS settings_61, t0.displayStartDate AS displayStartDate_62, t0.seoTitle AS seoTitle_63, t0.seoKeyword AS seoKeyword_64, t0.seoDescription AS seoDescription_65, t0.navbar_en AS navbar_en_66, t0.teaser_en AS teaser_en_67, t0.content_en AS content_en_68, t0.content_twig_en AS content_twig_en_69, t0.post_cta_content_en AS post_cta_content_en_70, t0.seo_title_en AS seo_title_en_71, t0.seo_description_en AS seo_description_en_72, t0.seo_keyword_en AS seo_keyword_en_73, t0.has_english_version AS has_english_version_74, t0.additional_js AS additional_js_75, t0.metaPixelId AS metaPixelId_76, t0.createDate AS createDate_77, t0.lastChangeDate AS lastChangeDate_78, t0.lastChangeUser AS lastChangeUser_79, t0.publicId AS publicId_80, t0.isExternalSubmission AS isExternalSubmission_81, t0.createdBy AS createdBy_82, t0.lastModified AS lastModified_83, t0.createdAt AS createdAt_84, t0.orgaNote AS orgaNote_85, t0.calendarSyncedAt AS calendarSyncedAt_86, t0.logisticsRoom AS logisticsRoom_87, t0.logisticsCatering AS logisticsCatering_88, t0.logisticsEquipment AS logisticsEquipment_89, t0.logisticsHelpers AS logisticsHelpers_90, t0.history AS history_91, t0.todoHistory AS todoHistory_92 FROM sp_event_events t0 WHERE t0.id IS NULL LIMIT 1;
|