0.98 ms (100.00%)
|
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 = ? AND t0.programId = ? AND t0.status = ? LIMIT 1
Parameters: [
"ki-accelerator-nrw-03"
3
"active"
]
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 = ?
AND t0.status = ?
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 = 'ki-accelerator-nrw-03' AND t0.programId = 3 AND t0.status = 'active' LIMIT 1;
|