Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.extId AS extId_2,
  t0.visibility AS visibility_3,
  t0.score AS score_4,
  t0.name AS name_5,
  t0.teamId AS teamId_6,
  t0.website AS website_7,
  t0.domain AS domain_8,
  t0.slug AS slug_9,
  t0.status AS status_10,
  t0.editStatus AS editStatus_11,
  t0.stage AS stage_12,
  t0.logoUrl AS logoUrl_13,
  t0.logoBackground AS logoBackground_14,
  t0.imageLink AS imageLink_15,
  t0.currentPitchDeckUrl AS currentPitchDeckUrl_16,
  t0.kiAccelerator AS kiAccelerator_17,
  t0.todos AS todos_18,
  t0.industry AS industry_19,
  t0.industryCondensed AS industryCondensed_20,
  t0.customerFocus AS customerFocus_21,
  t0.BusinessModel AS BusinessModel_22,
  t0.tags AS tags_23,
  t0.oneSentencePitch AS oneSentencePitch_24,
  t0.oneSentencePitchEn AS oneSentencePitchEn_25,
  t0.foundationYear AS foundationYear_26,
  t0.location AS location_27,
  t0.city AS city_28,
  t0.employeesCount AS employeesCount_29,
  t0.funding AS funding_30,
  t0.investors AS investors_31,
  t0.revenue AS revenue_32,
  t0.contactPerson AS contactPerson_33,
  t0.contactEmail AS contactEmail_34,
  t0.contactTelefon AS contactTelefon_35,
  t0.xing AS xing_36,
  t0.linkedin AS linkedin_37,
  t0.facebook AS facebook_38,
  t0.twitter AS twitter_39,
  t0.instagram AS instagram_40,
  t0.description AS description_41,
  t0.publicDetailHtml AS publicDetailHtml_42,
  t0.publicDetailHtmlEn AS publicDetailHtmlEn_43,
  t0.internalDetailHtml AS internalDetailHtml_44,
  t0.internalDetailHtmlEn AS internalDetailHtmlEn_45,
  t0.gsPublicSummary AS gsPublicSummary_46,
  t0.gsIndustries AS gsIndustries_47,
  t0.gsKeywords AS gsKeywords_48,
  t0.gsProfile AS gsProfile_49,
  t0.comments AS comments_50,
  t0.history AS history_51,
  t0.lastChangeUser AS lastChangeUser_52,
  t0.createdAt AS createdAt_53,
  t0.lastModified AS lastModified_54,
  t0.lastChangedBy AS lastChangedBy_55
FROM
  sp_startup_profiles t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.extId AS extId_2, t0.visibility AS visibility_3, t0.score AS score_4, t0.name AS name_5, t0.teamId AS teamId_6, t0.website AS website_7, t0.domain AS domain_8, t0.slug AS slug_9, t0.status AS status_10, t0.editStatus AS editStatus_11, t0.stage AS stage_12, t0.logoUrl AS logoUrl_13, t0.logoBackground AS logoBackground_14, t0.imageLink AS imageLink_15, t0.currentPitchDeckUrl AS currentPitchDeckUrl_16, t0.kiAccelerator AS kiAccelerator_17, t0.todos AS todos_18, t0.industry AS industry_19, t0.industryCondensed AS industryCondensed_20, t0.customerFocus AS customerFocus_21, t0.BusinessModel AS BusinessModel_22, t0.tags AS tags_23, t0.oneSentencePitch AS oneSentencePitch_24, t0.oneSentencePitchEn AS oneSentencePitchEn_25, t0.foundationYear AS foundationYear_26, t0.location AS location_27, t0.city AS city_28, t0.employeesCount AS employeesCount_29, t0.funding AS funding_30, t0.investors AS investors_31, t0.revenue AS revenue_32, t0.contactPerson AS contactPerson_33, t0.contactEmail AS contactEmail_34, t0.contactTelefon AS contactTelefon_35, t0.xing AS xing_36, t0.linkedin AS linkedin_37, t0.facebook AS facebook_38, t0.twitter AS twitter_39, t0.instagram AS instagram_40, t0.description AS description_41, t0.publicDetailHtml AS publicDetailHtml_42, t0.publicDetailHtmlEn AS publicDetailHtmlEn_43, t0.internalDetailHtml AS internalDetailHtml_44, t0.internalDetailHtmlEn AS internalDetailHtmlEn_45, t0.gsPublicSummary AS gsPublicSummary_46, t0.gsIndustries AS gsIndustries_47, t0.gsKeywords AS gsKeywords_48, t0.gsProfile AS gsProfile_49, t0.comments AS comments_50, t0.history AS history_51, t0.lastChangeUser AS lastChangeUser_52, t0.createdAt AS createdAt_53, t0.lastModified AS lastModified_54, t0.lastChangedBy AS lastChangedBy_55 FROM sp_startup_profiles t0 WHERE t0.id = '3000004' 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.hasStartupMembership AS hasStartupMembership_21,
  t0.isIncludeInUpdateType AS isIncludeInUpdateType_22,
  t0.isCompany AS isCompany_23,
  t0.isAddressComplete AS isAddressComplete_24,
  t0.isDebitor AS isDebitor_25,
  t0.type AS type_26,
  t0.internalDescription AS internalDescription_27,
  t0.monsumCustomerType AS monsumCustomerType_28,
  t0.homepage AS homepage_29,
  t0.logoURL AS logoURL_30,
  t0.industries AS industries_31,
  t0.description AS description_32,
  t0.note AS note_33,
  t0.tags AS tags_34,
  t0.categories AS categories_35,
  t0.alertNote AS alertNote_36,
  t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37,
  t0.monthlyExtraBudget AS monthlyExtraBudget_38,
  t0.sameDayBudget AS sameDayBudget_39,
  t0.sameDayBudgetUsed AS sameDayBudgetUsed_40,
  t0.sameDayExtraBudget AS sameDayExtraBudget_41,
  t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42,
  t0.communityBudget AS communityBudget_43,
  t0.communityBudgetUsed AS communityBudgetUsed_44,
  t0.meetingRoomsBudget AS meetingRoomsBudget_45,
  t0.conferenceRoomsBudget AS conferenceRoomsBudget_46,
  t0.coffeeCoinsBudget AS coffeeCoinsBudget_47,
  t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48,
  t0.meetingRoomsBooked AS meetingRoomsBooked_49,
  t0.conferenceRoomsBooked AS conferenceRoomsBooked_50,
  t0.todayRoomsBooked AS todayRoomsBooked_51,
  t0.nDedicatedDesks AS nDedicatedDesks_52,
  t0.nFlexibleDesks AS nFlexibleDesks_53,
  t0.nBasicMemberships AS nBasicMemberships_54,
  t0.nEmployees AS nEmployees_55,
  t0.nTransponders AS nTransponders_56,
  t0.nTiefgarage AS nTiefgarage_57,
  t0.editStatus AS editStatus_58,
  t0.xing AS xing_59,
  t0.linkedin AS linkedin_60,
  t0.facebook AS facebook_61,
  t0.twitter AS twitter_62,
  t0.instagram AS instagram_63,
  t0.enterDate AS enterDate_64,
  t0.lastChangeDate AS lastChangeDate_65,
  t0.lastModified AS lastModified_66,
  t0.lastInvoiceDate AS lastInvoiceDate_67,
  t0.exitDate AS exitDate_68,
  t0.isRedundant AS isRedundant_69,
  t0.gsStatus AS gsStatus_70,
  t0.gsBatchNo AS gsBatchNo_71,
  t0.gsNote AS gsNote_72,
  t0.gsIdeenblattDate AS gsIdeenblattDate_73,
  t0.gsJuryDate AS gsJuryDate_74,
  t0.gsCoachMemberId AS gsCoachMemberId_75,
  t0.gsCoachMemberName AS gsCoachMemberName_76,
  t0.spContactPerson AS spContactPerson_77,
  t0.memberTag AS memberTag_78,
  t0.actionTag AS actionTag_79,
  t0.createdAt AS createdAt_80,
  t0.lastChangeUser AS lastChangeUser_81,
  t0.history AS history_82,
  t0.treatAsSubscribed AS treatAsSubscribed_83,
  t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84,
  t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85,
  t0.treatAsSubscribedReason AS treatAsSubscribedReason_86,
  t0.searchAliases AS searchAliases_87
FROM
  sp_teams t0
WHERE
  t0.id = ?
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.hasStartupMembership AS hasStartupMembership_21, t0.isIncludeInUpdateType AS isIncludeInUpdateType_22, t0.isCompany AS isCompany_23, t0.isAddressComplete AS isAddressComplete_24, t0.isDebitor AS isDebitor_25, t0.type AS type_26, t0.internalDescription AS internalDescription_27, t0.monsumCustomerType AS monsumCustomerType_28, t0.homepage AS homepage_29, t0.logoURL AS logoURL_30, t0.industries AS industries_31, t0.description AS description_32, t0.note AS note_33, t0.tags AS tags_34, t0.categories AS categories_35, t0.alertNote AS alertNote_36, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_37, t0.monthlyExtraBudget AS monthlyExtraBudget_38, t0.sameDayBudget AS sameDayBudget_39, t0.sameDayBudgetUsed AS sameDayBudgetUsed_40, t0.sameDayExtraBudget AS sameDayExtraBudget_41, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_42, t0.communityBudget AS communityBudget_43, t0.communityBudgetUsed AS communityBudgetUsed_44, t0.meetingRoomsBudget AS meetingRoomsBudget_45, t0.conferenceRoomsBudget AS conferenceRoomsBudget_46, t0.coffeeCoinsBudget AS coffeeCoinsBudget_47, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_48, t0.meetingRoomsBooked AS meetingRoomsBooked_49, t0.conferenceRoomsBooked AS conferenceRoomsBooked_50, t0.todayRoomsBooked AS todayRoomsBooked_51, t0.nDedicatedDesks AS nDedicatedDesks_52, t0.nFlexibleDesks AS nFlexibleDesks_53, t0.nBasicMemberships AS nBasicMemberships_54, t0.nEmployees AS nEmployees_55, t0.nTransponders AS nTransponders_56, t0.nTiefgarage AS nTiefgarage_57, t0.editStatus AS editStatus_58, t0.xing AS xing_59, t0.linkedin AS linkedin_60, t0.facebook AS facebook_61, t0.twitter AS twitter_62, t0.instagram AS instagram_63, t0.enterDate AS enterDate_64, t0.lastChangeDate AS lastChangeDate_65, t0.lastModified AS lastModified_66, t0.lastInvoiceDate AS lastInvoiceDate_67, t0.exitDate AS exitDate_68, t0.isRedundant AS isRedundant_69, t0.gsStatus AS gsStatus_70, t0.gsBatchNo AS gsBatchNo_71, t0.gsNote AS gsNote_72, t0.gsIdeenblattDate AS gsIdeenblattDate_73, t0.gsJuryDate AS gsJuryDate_74, t0.gsCoachMemberId AS gsCoachMemberId_75, t0.gsCoachMemberName AS gsCoachMemberName_76, t0.spContactPerson AS spContactPerson_77, t0.memberTag AS memberTag_78, t0.actionTag AS actionTag_79, t0.createdAt AS createdAt_80, t0.lastChangeUser AS lastChangeUser_81, t0.history AS history_82, t0.treatAsSubscribed AS treatAsSubscribed_83, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_84, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_85, t0.treatAsSubscribedReason AS treatAsSubscribedReason_86, t0.searchAliases AS searchAliases_87 FROM sp_teams t0 WHERE t0.id = 19480 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.owner AS owner_1,
  s0_.type AS type_2,
  s0_.externalId AS externalId_3,
  s0_.score AS score_4,
  s0_.name AS name_5,
  s0_.title AS title_6,
  s0_.imageLink AS imageLink_7,
  s0_.categories AS categories_8,
  s0_.tags AS tags_9,
  s0_.isActive AS isActive_10,
  s0_.lastModified AS lastModified_11,
  s0_.lastChangeUser AS lastChangeUser_12,
  s0_.createdAt AS createdAt_13,
  s0_.rankingScore AS rankingScore_14,
  s0_.eventStartDate AS eventStartDate_15,
  s0_.jobEndDate AS jobEndDate_16,
  s0_.rankingUpdatedAt AS rankingUpdatedAt_17
FROM
  sp_content_feed s0_
WHERE
  s0_.tags LIKE ?
ORDER BY
  s0_.score DESC

SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE '%\"25ways\"%' ORDER BY s0_.score DESC;

SELECT
  s0_.startupName AS startupName_0,
  s0_.pitchPosition AS pitchPosition_1,
  s0_.programName AS programName_2,
  s0_.batchName AS batchName_3,
  s1_.pitchDate AS pitchDate_4,
  s1_.city AS city_5
FROM
  sp_applications s0_
  INNER JOIN sp_batches s1_ ON (s0_.batchId = s1_.id)
WHERE
  s0_.startupId = ?
  AND s0_.programId = ?

SELECT s0_.startupName AS startupName_0, s0_.pitchPosition AS pitchPosition_1, s0_.programName AS programName_2, s0_.batchName AS batchName_3, s1_.pitchDate AS pitchDate_4, s1_.city AS city_5 FROM sp_applications s0_ INNER JOIN sp_batches s1_ ON (s0_.batchId = s1_.id) WHERE s0_.startupId = '3000004' AND s0_.programId = 1;

SELECT
  s0_.id AS id_0,
  s0_.score AS score_1,
  s0_.completenessScore AS completenessScore_2,
  s0_.status AS status_3,
  s0_.location AS location_4,
  s0_.salutation AS salutation_5,
  s0_.title AS title_6,
  s0_.jobTitle AS jobTitle_7,
  s0_.firstName AS firstName_8,
  s0_.lastName AS lastName_9,
  s0_.name AS name_10,
  s0_.sortName AS sortName_11,
  s0_.email AS email_12,
  s0_.secondaryEmail AS secondaryEmail_13,
  s0_.phone AS phone_14,
  s0_.hasCommunityMembership AS hasCommunityMembership_15,
  s0_.utm_source AS utm_source_16,
  s0_.utm_medium AS utm_medium_17,
  s0_.utm_campaign AS utm_campaign_18,
  s0_.utm_term AS utm_term_19,
  s0_.utm_content AS utm_content_20,
  s0_.birthday AS birthday_21,
  s0_.addressFieldOne AS addressFieldOne_22,
  s0_.addressFieldTwo AS addressFieldTwo_23,
  s0_.addressCountryCode AS addressCountryCode_24,
  s0_.addressPostalCode AS addressPostalCode_25,
  s0_.addressCity AS addressCity_26,
  s0_.teamId AS teamId_27,
  s0_.teamName AS teamName_28,
  s0_.company AS company_29,
  s0_.history AS history_30,
  s0_.tags AS tags_31,
  s0_.annotation AS annotation_32,
  s0_.mentorBuckets AS mentorBuckets_33,
  s0_.areasOfExpertise AS areasOfExpertise_34,
  s0_.mentor_firma AS mentor_firma_35,
  s0_.mentor_firma_url AS mentor_firma_url_36,
  s0_.mentor_locations AS mentor_locations_37,
  s0_.mentor_profile AS mentor_profile_38,
  s0_.mentor_note AS mentor_note_39,
  s0_.mentor_admin_rating AS mentor_admin_rating_40,
  s0_.active AS active_41,
  s0_.tiefgarage AS tiefgarage_42,
  s0_.transponder AS transponder_43,
  s0_.isTransponderAllowed AS isTransponderAllowed_44,
  s0_.imageLink AS imageLink_45,
  s0_.homepage AS homepage_46,
  s0_.xing AS xing_47,
  s0_.pipedriveId AS pipedriveId_48,
  s0_.linkedin AS linkedin_49,
  s0_.facebook AS facebook_50,
  s0_.instagram AS instagram_51,
  s0_.twitter AS twitter_52,
  s0_.skills AS skills_53,
  s0_.description AS description_54,
  s0_.touchpoints AS touchpoints_55,
  s0_.isAddressComplete AS isAddressComplete_56,
  s0_.hasMailchimp AS hasMailchimp_57,
  s0_.hasKiNewsletter AS hasKiNewsletter_58,
  s0_.hubspotSyncPending AS hubspotSyncPending_59,
  s0_.enterDate AS enterDate_60,
  s0_.exitDate AS exitDate_61,
  s0_.physicalMembershipStarted AS physicalMembershipStarted_62,
  s0_.physicalMembershipEnded AS physicalMembershipEnded_63,
  s0_.lastModified AS lastModified_64,
  s0_.lastChangeUser AS lastChangeUser_65,
  s0_.onboardingCompletedAt AS onboardingCompletedAt_66,
  s0_.nAiWebinarsAttended AS nAiWebinarsAttended_67,
  s0_.nAiWebinarsApplied AS nAiWebinarsApplied_68,
  s0_.nAiEventsAttended AS nAiEventsAttended_69,
  s0_.nAiEventsApplied AS nAiEventsApplied_70,
  s0_.nPaidAttended AS nPaidAttended_71,
  s0_.nPaidApplied AS nPaidApplied_72,
  s0_.nKiEinstiegAttended AS nKiEinstiegAttended_73,
  s0_.nKiEinstiegApplied AS nKiEinstiegApplied_74,
  s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_75,
  s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_76,
  s0_.nEcodynamicsAttended AS nEcodynamicsAttended_77,
  s0_.nEcodynamicsApplied AS nEcodynamicsApplied_78,
  s0_.nBbqApplied AS nBbqApplied_79,
  s0_.nAiFridayApplied AS nAiFridayApplied_80,
  s0_.nAiGatheringApplied AS nAiGatheringApplied_81,
  s0_.nAiGatheringAttended AS nAiGatheringAttended_82,
  s0_.aiSs24Applied AS aiSs24Applied_83,
  s0_.aiSs24Booked AS aiSs24Booked_84,
  s0_.interestedIn AS interestedIn_85,
  s0_.interests AS interests_86,
  s0_.mentorMetadata AS mentorMetadata_87,
  s0_.eventParticipations AS eventParticipations_88,
  s0_.kiKompetenz AS kiKompetenz_89,
  s0_.mentorOwnerId AS mentorOwnerId_90
FROM
  sp_members s0_,
  sp_member_teams s1_
WHERE
  s0_.id = s1_.member_id
  AND s1_.team_id = ?
ORDER BY
  s0_.firstName ASC,
  s0_.lastName ASC

SELECT s0_.id AS id_0, s0_.score AS score_1, s0_.completenessScore AS completenessScore_2, s0_.status AS status_3, s0_.location AS location_4, s0_.salutation AS salutation_5, s0_.title AS title_6, s0_.jobTitle AS jobTitle_7, s0_.firstName AS firstName_8, s0_.lastName AS lastName_9, s0_.name AS name_10, s0_.sortName AS sortName_11, s0_.email AS email_12, s0_.secondaryEmail AS secondaryEmail_13, s0_.phone AS phone_14, s0_.hasCommunityMembership AS hasCommunityMembership_15, s0_.utm_source AS utm_source_16, s0_.utm_medium AS utm_medium_17, s0_.utm_campaign AS utm_campaign_18, s0_.utm_term AS utm_term_19, s0_.utm_content AS utm_content_20, s0_.birthday AS birthday_21, s0_.addressFieldOne AS addressFieldOne_22, s0_.addressFieldTwo AS addressFieldTwo_23, s0_.addressCountryCode AS addressCountryCode_24, s0_.addressPostalCode AS addressPostalCode_25, s0_.addressCity AS addressCity_26, s0_.teamId AS teamId_27, s0_.teamName AS teamName_28, s0_.company AS company_29, s0_.history AS history_30, s0_.tags AS tags_31, s0_.annotation AS annotation_32, s0_.mentorBuckets AS mentorBuckets_33, s0_.areasOfExpertise AS areasOfExpertise_34, s0_.mentor_firma AS mentor_firma_35, s0_.mentor_firma_url AS mentor_firma_url_36, s0_.mentor_locations AS mentor_locations_37, s0_.mentor_profile AS mentor_profile_38, s0_.mentor_note AS mentor_note_39, s0_.mentor_admin_rating AS mentor_admin_rating_40, s0_.active AS active_41, s0_.tiefgarage AS tiefgarage_42, s0_.transponder AS transponder_43, s0_.isTransponderAllowed AS isTransponderAllowed_44, s0_.imageLink AS imageLink_45, s0_.homepage AS homepage_46, s0_.xing AS xing_47, s0_.pipedriveId AS pipedriveId_48, s0_.linkedin AS linkedin_49, s0_.facebook AS facebook_50, s0_.instagram AS instagram_51, s0_.twitter AS twitter_52, s0_.skills AS skills_53, s0_.description AS description_54, s0_.touchpoints AS touchpoints_55, s0_.isAddressComplete AS isAddressComplete_56, s0_.hasMailchimp AS hasMailchimp_57, s0_.hasKiNewsletter AS hasKiNewsletter_58, s0_.hubspotSyncPending AS hubspotSyncPending_59, s0_.enterDate AS enterDate_60, s0_.exitDate AS exitDate_61, s0_.physicalMembershipStarted AS physicalMembershipStarted_62, s0_.physicalMembershipEnded AS physicalMembershipEnded_63, s0_.lastModified AS lastModified_64, s0_.lastChangeUser AS lastChangeUser_65, s0_.onboardingCompletedAt AS onboardingCompletedAt_66, s0_.nAiWebinarsAttended AS nAiWebinarsAttended_67, s0_.nAiWebinarsApplied AS nAiWebinarsApplied_68, s0_.nAiEventsAttended AS nAiEventsAttended_69, s0_.nAiEventsApplied AS nAiEventsApplied_70, s0_.nPaidAttended AS nPaidAttended_71, s0_.nPaidApplied AS nPaidApplied_72, s0_.nKiEinstiegAttended AS nKiEinstiegAttended_73, s0_.nKiEinstiegApplied AS nKiEinstiegApplied_74, s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_75, s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_76, s0_.nEcodynamicsAttended AS nEcodynamicsAttended_77, s0_.nEcodynamicsApplied AS nEcodynamicsApplied_78, s0_.nBbqApplied AS nBbqApplied_79, s0_.nAiFridayApplied AS nAiFridayApplied_80, s0_.nAiGatheringApplied AS nAiGatheringApplied_81, s0_.nAiGatheringAttended AS nAiGatheringAttended_82, s0_.aiSs24Applied AS aiSs24Applied_83, s0_.aiSs24Booked AS aiSs24Booked_84, s0_.interestedIn AS interestedIn_85, s0_.interests AS interests_86, s0_.mentorMetadata AS mentorMetadata_87, s0_.eventParticipations AS eventParticipations_88, s0_.kiKompetenz AS kiKompetenz_89, s0_.mentorOwnerId AS mentorOwnerId_90 FROM sp_members s0_, sp_member_teams s1_ WHERE s0_.id = s1_.member_id AND s1_.team_id = 19480 ORDER BY s0_.firstName ASC, s0_.lastName ASC;

SELECT
  t0.id AS id_1,
  t0.startupId AS startupId_2,
  t0.programId AS programId_3,
  t0.batchId AS batchId_4,
  t0.metaLeadId AS metaLeadId_5,
  t0.metaFormId AS metaFormId_6,
  t0.utm_source AS utm_source_7,
  t0.utm_medium AS utm_medium_8,
  t0.utm_campaign AS utm_campaign_9,
  t0.utm_term AS utm_term_10,
  t0.utm_content AS utm_content_11,
  t0.votesRegistered AS votesRegistered_12,
  t0.programName AS programName_13,
  t0.programSlug AS programSlug_14,
  t0.batchName AS batchName_15,
  t0.batchSlug AS batchSlug_16,
  t0.template AS template_17,
  t0.teamId AS teamId_18,
  t0.memberId AS memberId_19,
  t0.lang AS lang_20,
  t0.startupName AS startupName_21,
  t0.visibility AS visibility_22,
  t0.firstName AS firstName_23,
  t0.lastName AS lastName_24,
  t0.person AS person_25,
  t0.email AS email_26,
  t0.secondaryEmail AS secondaryEmail_27,
  t0.phone AS phone_28,
  t0.linkedin AS linkedin_29,
  t0.telegram AS telegram_30,
  t0.discord AS discord_31,
  t0.wallet AS wallet_32,
  t0.teamSize AS teamSize_33,
  t0.city AS city_34,
  t0.startupStage AS startupStage_35,
  t0.industry AS industry_36,
  t0.track AS track_37,
  t0.projectCategory AS projectCategory_38,
  t0.blockchain AS blockchain_39,
  t0.recommendedBy AS recommendedBy_40,
  t0.editStatus AS editStatus_41,
  t0.editMessage AS editMessage_42,
  t0.applicationStatus AS applicationStatus_43,
  t0.reviewStatus AS reviewStatus_44,
  t0.isNewMember AS isNewMember_45,
  t0.hasConfirmationMailSent AS hasConfirmationMailSent_46,
  t0.hasTermsAccepted AS hasTermsAccepted_47,
  t0.batchStatus AS batchStatus_48,
  t0.selectionStatus AS selectionStatus_49,
  t0.participationStatus AS participationStatus_50,
  t0.coachMemberId AS coachMemberId_51,
  t0.participationStartedAt AS participationStartedAt_52,
  t0.participationCompletedAt AS participationCompletedAt_53,
  t0.pitchPosition AS pitchPosition_54,
  t0.pitchImageLink AS pitchImageLink_55,
  t0.pitchVideoLink AS pitchVideoLink_56,
  t0.linkPitchDeck AS linkPitchDeck_57,
  t0.publicIdPitchDeck AS publicIdPitchDeck_58,
  t0.ideaPaperUrl AS ideaPaperUrl_59,
  t0.publicIdIdeaPaper AS publicIdIdeaPaper_60,
  t0.websiteUrl AS websiteUrl_61,
  t0.fulltime AS fulltime_62,
  t0.language AS language_63,
  t0.mvpStatus AS mvpStatus_64,
  t0.dealroomUrl AS dealroomUrl_65,
  t0.podioId AS podioId_66,
  t0.podioItemId AS podioItemId_67,
  t0.podioUrl AS podioUrl_68,
  t0.ideaPitch AS ideaPitch_69,
  t0.createdAt AS createdAt_70,
  t0.lastModified AS lastModified_71,
  t0.deletedAt AS deletedAt_72,
  t0.lastChangeUser AS lastChangeUser_73,
  t0.history AS history_74,
  t0.extraFields AS extraFields_75,
  t0.adminNotes AS adminNotes_76,
  t0.ratingJudge1 AS ratingJudge1_77,
  t0.ratingJudge2 AS ratingJudge2_78,
  t0.ratingJudge3 AS ratingJudge3_79,
  t0.ratingJudge4 AS ratingJudge4_80,
  t0.ratingJudge5 AS ratingJudge5_81,
  t0.ratingAverage AS ratingAverage_82,
  t0.ratingUpdatedAt AS ratingUpdatedAt_83,
  t0.memberTagsAtRegistration AS memberTagsAtRegistration_84,
  t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_85,
  t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_86,
  t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_87,
  t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_88,
  t0.pendingMemberData AS pendingMemberData_89,
  t0.pendingTeamData AS pendingTeamData_90,
  t0.resumeToken AS resumeToken_91,
  t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_92,
  t0.isMemberCreated AS isMemberCreated_93,
  t0.isTeamCreated AS isTeamCreated_94
FROM
  sp_applications t0
WHERE
  t0.teamId = ?
  AND t0.programId IN (?, ?, ?)

SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.programId AS programId_3, t0.batchId AS batchId_4, t0.metaLeadId AS metaLeadId_5, t0.metaFormId AS metaFormId_6, t0.utm_source AS utm_source_7, t0.utm_medium AS utm_medium_8, t0.utm_campaign AS utm_campaign_9, t0.utm_term AS utm_term_10, t0.utm_content AS utm_content_11, t0.votesRegistered AS votesRegistered_12, t0.programName AS programName_13, t0.programSlug AS programSlug_14, t0.batchName AS batchName_15, t0.batchSlug AS batchSlug_16, t0.template AS template_17, t0.teamId AS teamId_18, t0.memberId AS memberId_19, t0.lang AS lang_20, t0.startupName AS startupName_21, t0.visibility AS visibility_22, t0.firstName AS firstName_23, t0.lastName AS lastName_24, t0.person AS person_25, t0.email AS email_26, t0.secondaryEmail AS secondaryEmail_27, t0.phone AS phone_28, t0.linkedin AS linkedin_29, t0.telegram AS telegram_30, t0.discord AS discord_31, t0.wallet AS wallet_32, t0.teamSize AS teamSize_33, t0.city AS city_34, t0.startupStage AS startupStage_35, t0.industry AS industry_36, t0.track AS track_37, t0.projectCategory AS projectCategory_38, t0.blockchain AS blockchain_39, t0.recommendedBy AS recommendedBy_40, t0.editStatus AS editStatus_41, t0.editMessage AS editMessage_42, t0.applicationStatus AS applicationStatus_43, t0.reviewStatus AS reviewStatus_44, t0.isNewMember AS isNewMember_45, t0.hasConfirmationMailSent AS hasConfirmationMailSent_46, t0.hasTermsAccepted AS hasTermsAccepted_47, t0.batchStatus AS batchStatus_48, t0.selectionStatus AS selectionStatus_49, t0.participationStatus AS participationStatus_50, t0.coachMemberId AS coachMemberId_51, t0.participationStartedAt AS participationStartedAt_52, t0.participationCompletedAt AS participationCompletedAt_53, t0.pitchPosition AS pitchPosition_54, t0.pitchImageLink AS pitchImageLink_55, t0.pitchVideoLink AS pitchVideoLink_56, t0.linkPitchDeck AS linkPitchDeck_57, t0.publicIdPitchDeck AS publicIdPitchDeck_58, t0.ideaPaperUrl AS ideaPaperUrl_59, t0.publicIdIdeaPaper AS publicIdIdeaPaper_60, t0.websiteUrl AS websiteUrl_61, t0.fulltime AS fulltime_62, t0.language AS language_63, t0.mvpStatus AS mvpStatus_64, t0.dealroomUrl AS dealroomUrl_65, t0.podioId AS podioId_66, t0.podioItemId AS podioItemId_67, t0.podioUrl AS podioUrl_68, t0.ideaPitch AS ideaPitch_69, t0.createdAt AS createdAt_70, t0.lastModified AS lastModified_71, t0.deletedAt AS deletedAt_72, t0.lastChangeUser AS lastChangeUser_73, t0.history AS history_74, t0.extraFields AS extraFields_75, t0.adminNotes AS adminNotes_76, t0.ratingJudge1 AS ratingJudge1_77, t0.ratingJudge2 AS ratingJudge2_78, t0.ratingJudge3 AS ratingJudge3_79, t0.ratingJudge4 AS ratingJudge4_80, t0.ratingJudge5 AS ratingJudge5_81, t0.ratingAverage AS ratingAverage_82, t0.ratingUpdatedAt AS ratingUpdatedAt_83, t0.memberTagsAtRegistration AS memberTagsAtRegistration_84, t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_85, t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_86, t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_87, t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_88, t0.pendingMemberData AS pendingMemberData_89, t0.pendingTeamData AS pendingTeamData_90, t0.resumeToken AS resumeToken_91, t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_92, t0.isMemberCreated AS isMemberCreated_93, t0.isTeamCreated AS isTeamCreated_94 FROM sp_applications t0 WHERE t0.teamId = 19480 AND t0.programId IN ('1', '2', '3');

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s1_.type AS type_2,
  s0_.email AS email_3
FROM
  sp_member_teams s1_
  INNER JOIN sp_members s0_ ON (s1_.member_id = s0_.id)
WHERE
  s1_.team_id = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s1_.type AS type_2, s0_.email AS email_3 FROM sp_member_teams s1_ INNER JOIN sp_members s0_ ON (s1_.member_id = s0_.id) WHERE s1_.team_id = '3000004';

SELECT
  s0_.id AS id_0,
  s0_.owner AS owner_1,
  s0_.type AS type_2,
  s0_.externalId AS externalId_3,
  s0_.score AS score_4,
  s0_.name AS name_5,
  s0_.title AS title_6,
  s0_.imageLink AS imageLink_7,
  s0_.categories AS categories_8,
  s0_.tags AS tags_9,
  s0_.isActive AS isActive_10,
  s0_.lastModified AS lastModified_11,
  s0_.lastChangeUser AS lastChangeUser_12,
  s0_.createdAt AS createdAt_13,
  s0_.rankingScore AS rankingScore_14,
  s0_.eventStartDate AS eventStartDate_15,
  s0_.jobEndDate AS jobEndDate_16,
  s0_.rankingUpdatedAt AS rankingUpdatedAt_17
FROM
  sp_content_feed s0_
WHERE
  s0_.tags LIKE ?
ORDER BY
  s0_.score DESC

SELECT s0_.id AS id_0, s0_.owner AS owner_1, s0_.type AS type_2, s0_.externalId AS externalId_3, s0_.score AS score_4, s0_.name AS name_5, s0_.title AS title_6, s0_.imageLink AS imageLink_7, s0_.categories AS categories_8, s0_.tags AS tags_9, s0_.isActive AS isActive_10, s0_.lastModified AS lastModified_11, s0_.lastChangeUser AS lastChangeUser_12, s0_.createdAt AS createdAt_13, s0_.rankingScore AS rankingScore_14, s0_.eventStartDate AS eventStartDate_15, s0_.jobEndDate AS jobEndDate_16, s0_.rankingUpdatedAt AS rankingUpdatedAt_17 FROM sp_content_feed s0_ WHERE s0_.tags LIKE '%\"25ways\"%' ORDER BY s0_.score DESC;