| 1 |
0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isNetworking AS isNetworking_20, t0.networkingRounds AS networkingRounds_21, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_22, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_23, t0.eventId AS eventId_24, t0.zoomLink AS zoomLink_25, t0.typeformLink AS typeformLink_26, t0.mailTemplate AS mailTemplate_27, t0.mailSubject AS mailSubject_28, t0.reminderMailTemplateId AS reminderMailTemplateId_29, t0.reminderSenderEmail AS reminderSenderEmail_30, t0.phrasesDe AS phrasesDe_31, t0.phrasesEn AS phrasesEn_32, t0.settings AS settings_33, t0.createdAt AS createdAt_34, t0.lastModified AS lastModified_35, t0.lastChangeUser AS lastChangeUser_36 FROM aab_programs t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"rheinland-pitch-zuschauer"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.status AS status_4, t0.lang AS lang_5, t0.bgImageUrl AS bgImageUrl_6, t0.mailDesignTemplate AS mailDesignTemplate_7, t0.senderMail AS senderMail_8, t0.fromName AS fromName_9, t0.recipientMonitoringMail AS recipientMonitoringMail_10, t0.confirmationMailSubject AS confirmationMailSubject_11, t0.confirmationMailContent AS confirmationMailContent_12, t0.email AS email_13, t0.landingPageContent AS landingPageContent_14, t0.template AS template_15, t0.homepage AS homepage_16, t0.visibility AS visibility_17, t0.access AS access_18, t0.hasEvent AS hasEvent_19, t0.isNetworking AS isNetworking_20, t0.networkingRounds AS networkingRounds_21, t0.isMultipleApplicationsPerMember AS isMultipleApplicationsPerMember_22, t0.isMultipleApplicationsPerTeam AS isMultipleApplicationsPerTeam_23, t0.eventId AS eventId_24, t0.zoomLink AS zoomLink_25, t0.typeformLink AS typeformLink_26, t0.mailTemplate AS mailTemplate_27, t0.mailSubject AS mailSubject_28, t0.reminderMailTemplateId AS reminderMailTemplateId_29, t0.reminderSenderEmail AS reminderSenderEmail_30, t0.phrasesDe AS phrasesDe_31, t0.phrasesEn AS phrasesEn_32, t0.settings AS settings_33, t0.createdAt AS createdAt_34, t0.lastModified AS lastModified_35, t0.lastChangeUser AS lastChangeUser_36 FROM aab_programs t0 WHERE t0.slug = 'rheinland-pitch-zuschauer' LIMIT 1;
|
| 2 |
0.68 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.slug = ? AND t0.program_id = ? LIMIT 1
Parameters: [
"generative-ai-117"
4
]
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.slug = ?
AND t0.program_id = ?
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.slug = 'generative-ai-117' AND t0.program_id = 4 LIMIT 1;
|