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 = '3000058' 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.active AS active_19,
  t0.hasCommunityMembership AS hasCommunityMembership_20,
  t0.isTransponderAllowed AS isTransponderAllowed_21,
  t0.hasStartupMembership AS hasStartupMembership_22,
  t0.isIncludeInUpdateType AS isIncludeInUpdateType_23,
  t0.isCompany AS isCompany_24,
  t0.isAddressComplete AS isAddressComplete_25,
  t0.isDebitor AS isDebitor_26,
  t0.type AS type_27,
  t0.internalDescription AS internalDescription_28,
  t0.monsumCustomerType AS monsumCustomerType_29,
  t0.homepage AS homepage_30,
  t0.logoURL AS logoURL_31,
  t0.industries AS industries_32,
  t0.description AS description_33,
  t0.note AS note_34,
  t0.tags AS tags_35,
  t0.categories AS categories_36,
  t0.alertNote AS alertNote_37,
  t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_38,
  t0.monthlyExtraBudget AS monthlyExtraBudget_39,
  t0.sameDayBudget AS sameDayBudget_40,
  t0.sameDayBudgetUsed AS sameDayBudgetUsed_41,
  t0.sameDayExtraBudget AS sameDayExtraBudget_42,
  t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_43,
  t0.communityBudget AS communityBudget_44,
  t0.communityBudgetUsed AS communityBudgetUsed_45,
  t0.meetingRoomsBudget AS meetingRoomsBudget_46,
  t0.conferenceRoomsBudget AS conferenceRoomsBudget_47,
  t0.coffeeCoinsBudget AS coffeeCoinsBudget_48,
  t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_49,
  t0.meetingRoomsBooked AS meetingRoomsBooked_50,
  t0.conferenceRoomsBooked AS conferenceRoomsBooked_51,
  t0.todayRoomsBooked AS todayRoomsBooked_52,
  t0.nDedicatedDesks AS nDedicatedDesks_53,
  t0.nFlexibleDesks AS nFlexibleDesks_54,
  t0.nBasicMemberships AS nBasicMemberships_55,
  t0.nEmployees AS nEmployees_56,
  t0.nTransponders AS nTransponders_57,
  t0.nTiefgarage AS nTiefgarage_58,
  t0.editStatus AS editStatus_59,
  t0.xing AS xing_60,
  t0.linkedin AS linkedin_61,
  t0.facebook AS facebook_62,
  t0.twitter AS twitter_63,
  t0.instagram AS instagram_64,
  t0.enterDate AS enterDate_65,
  t0.lastChangeDate AS lastChangeDate_66,
  t0.lastModified AS lastModified_67,
  t0.lastInvoiceDate AS lastInvoiceDate_68,
  t0.exitDate AS exitDate_69,
  t0.isRedundant AS isRedundant_70,
  t0.gsStatus AS gsStatus_71,
  t0.gsBatchNo AS gsBatchNo_72,
  t0.gsNote AS gsNote_73,
  t0.gsIdeenblattDate AS gsIdeenblattDate_74,
  t0.gsJuryDate AS gsJuryDate_75,
  t0.gsCoachMemberId AS gsCoachMemberId_76,
  t0.gsCoachMemberName AS gsCoachMemberName_77,
  t0.spContactPerson AS spContactPerson_78,
  t0.memberTag AS memberTag_79,
  t0.zapierWebhook AS zapierWebhook_80,
  t0.actionTag AS actionTag_81,
  t0.createdAt AS createdAt_82,
  t0.lastChangeUser AS lastChangeUser_83,
  t0.history AS history_84,
  t0.treatAsSubscribed AS treatAsSubscribed_85,
  t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_86,
  t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_87,
  t0.treatAsSubscribedReason AS treatAsSubscribedReason_88,
  t0.searchAliases AS searchAliases_89
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.active AS active_19, t0.hasCommunityMembership AS hasCommunityMembership_20, t0.isTransponderAllowed AS isTransponderAllowed_21, t0.hasStartupMembership AS hasStartupMembership_22, t0.isIncludeInUpdateType AS isIncludeInUpdateType_23, t0.isCompany AS isCompany_24, t0.isAddressComplete AS isAddressComplete_25, t0.isDebitor AS isDebitor_26, t0.type AS type_27, t0.internalDescription AS internalDescription_28, t0.monsumCustomerType AS monsumCustomerType_29, t0.homepage AS homepage_30, t0.logoURL AS logoURL_31, t0.industries AS industries_32, t0.description AS description_33, t0.note AS note_34, t0.tags AS tags_35, t0.categories AS categories_36, t0.alertNote AS alertNote_37, t0.monthlyRecurringRevenue AS monthlyRecurringRevenue_38, t0.monthlyExtraBudget AS monthlyExtraBudget_39, t0.sameDayBudget AS sameDayBudget_40, t0.sameDayBudgetUsed AS sameDayBudgetUsed_41, t0.sameDayExtraBudget AS sameDayExtraBudget_42, t0.sameDayExtraBudgetUsed AS sameDayExtraBudgetUsed_43, t0.communityBudget AS communityBudget_44, t0.communityBudgetUsed AS communityBudgetUsed_45, t0.meetingRoomsBudget AS meetingRoomsBudget_46, t0.conferenceRoomsBudget AS conferenceRoomsBudget_47, t0.coffeeCoinsBudget AS coffeeCoinsBudget_48, t0.coffeeCoinsHandedOut AS coffeeCoinsHandedOut_49, t0.meetingRoomsBooked AS meetingRoomsBooked_50, t0.conferenceRoomsBooked AS conferenceRoomsBooked_51, t0.todayRoomsBooked AS todayRoomsBooked_52, t0.nDedicatedDesks AS nDedicatedDesks_53, t0.nFlexibleDesks AS nFlexibleDesks_54, t0.nBasicMemberships AS nBasicMemberships_55, t0.nEmployees AS nEmployees_56, t0.nTransponders AS nTransponders_57, t0.nTiefgarage AS nTiefgarage_58, t0.editStatus AS editStatus_59, t0.xing AS xing_60, t0.linkedin AS linkedin_61, t0.facebook AS facebook_62, t0.twitter AS twitter_63, t0.instagram AS instagram_64, t0.enterDate AS enterDate_65, t0.lastChangeDate AS lastChangeDate_66, t0.lastModified AS lastModified_67, t0.lastInvoiceDate AS lastInvoiceDate_68, t0.exitDate AS exitDate_69, t0.isRedundant AS isRedundant_70, t0.gsStatus AS gsStatus_71, t0.gsBatchNo AS gsBatchNo_72, t0.gsNote AS gsNote_73, t0.gsIdeenblattDate AS gsIdeenblattDate_74, t0.gsJuryDate AS gsJuryDate_75, t0.gsCoachMemberId AS gsCoachMemberId_76, t0.gsCoachMemberName AS gsCoachMemberName_77, t0.spContactPerson AS spContactPerson_78, t0.memberTag AS memberTag_79, t0.zapierWebhook AS zapierWebhook_80, t0.actionTag AS actionTag_81, t0.createdAt AS createdAt_82, t0.lastChangeUser AS lastChangeUser_83, t0.history AS history_84, t0.treatAsSubscribed AS treatAsSubscribed_85, t0.treatAsSubscribedSetAt AS treatAsSubscribedSetAt_86, t0.treatAsSubscribedSetBy AS treatAsSubscribedSetBy_87, t0.treatAsSubscribedReason AS treatAsSubscribedReason_88, t0.searchAliases AS searchAliases_89 FROM sp_teams t0 WHERE t0.id = 15752 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 '%\"as-good-as-pros\"%' ORDER BY s0_.score DESC;

SELECT
  *
FROM
  wp_posts
WHERE
  ID = :id

SELECT * FROM wp_posts WHERE ID = 63982;

SELECT
  p.guid
FROM
  wp_posts p,
  wp_postmeta m
WHERE
  m.meta_value = p.id
  AND m.post_id = :id
  AND m.meta_key = '_thumbnail_id'

SELECT p.guid
            FROM wp_posts p, wp_postmeta m
            WHERE m.meta_value = p.id
              AND m.post_id = 63982
              AND m.meta_key = '_thumbnail_id'
        ;

SELECT
  *
FROM
  wp_posts
WHERE
  ID = :id

SELECT * FROM wp_posts WHERE ID = 63770;

SELECT
  p.guid
FROM
  wp_posts p,
  wp_postmeta m
WHERE
  m.meta_value = p.id
  AND m.post_id = :id
  AND m.meta_key = '_thumbnail_id'

SELECT p.guid
            FROM wp_posts p, wp_postmeta m
            WHERE m.meta_value = p.id
              AND m.post_id = 63770
              AND m.meta_key = '_thumbnail_id'
        ;

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 = ?
  )
  AND (s0_.deletedAt IS NULL)

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 = '3000058' AND s0_.programId = 1) AND (s0_.deletedAt IS NULL);

SELECT
  s0_.id AS id_0,
  s0_.spMemberId AS spMemberId_1,
  s0_.score AS score_2,
  s0_.completenessScore AS completenessScore_3,
  s0_.status AS status_4,
  s0_.location AS location_5,
  s0_.salutation AS salutation_6,
  s0_.title AS title_7,
  s0_.jobTitle AS jobTitle_8,
  s0_.firstName AS firstName_9,
  s0_.lastName AS lastName_10,
  s0_.name AS name_11,
  s0_.sortName AS sortName_12,
  s0_.email AS email_13,
  s0_.secondaryEmail AS secondaryEmail_14,
  s0_.phone AS phone_15,
  s0_.hasCommunityMembership AS hasCommunityMembership_16,
  s0_.aiMemberValid AS aiMemberValid_17,
  s0_.aiMemberStatus AS aiMemberStatus_18,
  s0_.aiMemberReason AS aiMemberReason_19,
  s0_.aiMemberStart AS aiMemberStart_20,
  s0_.aiMemberEnd AS aiMemberEnd_21,
  s0_.utm_source AS utm_source_22,
  s0_.utm_medium AS utm_medium_23,
  s0_.utm_campaign AS utm_campaign_24,
  s0_.utm_term AS utm_term_25,
  s0_.utm_content AS utm_content_26,
  s0_.birthday AS birthday_27,
  s0_.addressFieldOne AS addressFieldOne_28,
  s0_.addressFieldTwo AS addressFieldTwo_29,
  s0_.addressCountryCode AS addressCountryCode_30,
  s0_.addressPostalCode AS addressPostalCode_31,
  s0_.addressCity AS addressCity_32,
  s0_.teamId AS teamId_33,
  s0_.teamName AS teamName_34,
  s0_.company AS company_35,
  s0_.history AS history_36,
  s0_.tags AS tags_37,
  s0_.annotation AS annotation_38,
  s0_.mentorBuckets AS mentorBuckets_39,
  s0_.areasOfExpertise AS areasOfExpertise_40,
  s0_.mentor_firma AS mentor_firma_41,
  s0_.mentor_firma_url AS mentor_firma_url_42,
  s0_.mentor_locations AS mentor_locations_43,
  s0_.mentor_profile AS mentor_profile_44,
  s0_.mentor_note AS mentor_note_45,
  s0_.mentor_admin_rating AS mentor_admin_rating_46,
  s0_.active AS active_47,
  s0_.tiefgarage AS tiefgarage_48,
  s0_.transponder AS transponder_49,
  s0_.isTransponderAllowed AS isTransponderAllowed_50,
  s0_.imageLink AS imageLink_51,
  s0_.homepage AS homepage_52,
  s0_.xing AS xing_53,
  s0_.pipedriveId AS pipedriveId_54,
  s0_.linkedin AS linkedin_55,
  s0_.facebook AS facebook_56,
  s0_.instagram AS instagram_57,
  s0_.twitter AS twitter_58,
  s0_.skills AS skills_59,
  s0_.description AS description_60,
  s0_.touchpoints AS touchpoints_61,
  s0_.isAddressComplete AS isAddressComplete_62,
  s0_.hasMailchimp AS hasMailchimp_63,
  s0_.hasKiNewsletter AS hasKiNewsletter_64,
  s0_.hubspotSyncPending AS hubspotSyncPending_65,
  s0_.enterDate AS enterDate_66,
  s0_.exitDate AS exitDate_67,
  s0_.physicalMembershipStarted AS physicalMembershipStarted_68,
  s0_.physicalMembershipEnded AS physicalMembershipEnded_69,
  s0_.lastModified AS lastModified_70,
  s0_.lastChangeUser AS lastChangeUser_71,
  s0_.nAiWebinarsAttended AS nAiWebinarsAttended_72,
  s0_.nAiWebinarsApplied AS nAiWebinarsApplied_73,
  s0_.nAiEventsAttended AS nAiEventsAttended_74,
  s0_.nAiEventsApplied AS nAiEventsApplied_75,
  s0_.nPaidAttended AS nPaidAttended_76,
  s0_.nPaidApplied AS nPaidApplied_77,
  s0_.nKiEinstiegAttended AS nKiEinstiegAttended_78,
  s0_.nKiEinstiegApplied AS nKiEinstiegApplied_79,
  s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_80,
  s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_81,
  s0_.nEcodynamicsAttended AS nEcodynamicsAttended_82,
  s0_.nEcodynamicsApplied AS nEcodynamicsApplied_83,
  s0_.nBbqApplied AS nBbqApplied_84,
  s0_.nAiFridayApplied AS nAiFridayApplied_85,
  s0_.nAiGatheringApplied AS nAiGatheringApplied_86,
  s0_.nAiGatheringAttended AS nAiGatheringAttended_87,
  s0_.aiSs24Applied AS aiSs24Applied_88,
  s0_.aiSs24Booked AS aiSs24Booked_89,
  s0_.interestedIn AS interestedIn_90,
  s0_.interests AS interests_91,
  s0_.mentorMetadata AS mentorMetadata_92,
  s0_.eventParticipations AS eventParticipations_93,
  s0_.kiKompetenz AS kiKompetenz_94,
  s0_.mentorOwnerId AS mentorOwnerId_95
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_.spMemberId AS spMemberId_1, s0_.score AS score_2, s0_.completenessScore AS completenessScore_3, s0_.status AS status_4, s0_.location AS location_5, s0_.salutation AS salutation_6, s0_.title AS title_7, s0_.jobTitle AS jobTitle_8, s0_.firstName AS firstName_9, s0_.lastName AS lastName_10, s0_.name AS name_11, s0_.sortName AS sortName_12, s0_.email AS email_13, s0_.secondaryEmail AS secondaryEmail_14, s0_.phone AS phone_15, s0_.hasCommunityMembership AS hasCommunityMembership_16, s0_.aiMemberValid AS aiMemberValid_17, s0_.aiMemberStatus AS aiMemberStatus_18, s0_.aiMemberReason AS aiMemberReason_19, s0_.aiMemberStart AS aiMemberStart_20, s0_.aiMemberEnd AS aiMemberEnd_21, s0_.utm_source AS utm_source_22, s0_.utm_medium AS utm_medium_23, s0_.utm_campaign AS utm_campaign_24, s0_.utm_term AS utm_term_25, s0_.utm_content AS utm_content_26, s0_.birthday AS birthday_27, s0_.addressFieldOne AS addressFieldOne_28, s0_.addressFieldTwo AS addressFieldTwo_29, s0_.addressCountryCode AS addressCountryCode_30, s0_.addressPostalCode AS addressPostalCode_31, s0_.addressCity AS addressCity_32, s0_.teamId AS teamId_33, s0_.teamName AS teamName_34, s0_.company AS company_35, s0_.history AS history_36, s0_.tags AS tags_37, s0_.annotation AS annotation_38, s0_.mentorBuckets AS mentorBuckets_39, s0_.areasOfExpertise AS areasOfExpertise_40, s0_.mentor_firma AS mentor_firma_41, s0_.mentor_firma_url AS mentor_firma_url_42, s0_.mentor_locations AS mentor_locations_43, s0_.mentor_profile AS mentor_profile_44, s0_.mentor_note AS mentor_note_45, s0_.mentor_admin_rating AS mentor_admin_rating_46, s0_.active AS active_47, s0_.tiefgarage AS tiefgarage_48, s0_.transponder AS transponder_49, s0_.isTransponderAllowed AS isTransponderAllowed_50, s0_.imageLink AS imageLink_51, s0_.homepage AS homepage_52, s0_.xing AS xing_53, s0_.pipedriveId AS pipedriveId_54, s0_.linkedin AS linkedin_55, s0_.facebook AS facebook_56, s0_.instagram AS instagram_57, s0_.twitter AS twitter_58, s0_.skills AS skills_59, s0_.description AS description_60, s0_.touchpoints AS touchpoints_61, s0_.isAddressComplete AS isAddressComplete_62, s0_.hasMailchimp AS hasMailchimp_63, s0_.hasKiNewsletter AS hasKiNewsletter_64, s0_.hubspotSyncPending AS hubspotSyncPending_65, s0_.enterDate AS enterDate_66, s0_.exitDate AS exitDate_67, s0_.physicalMembershipStarted AS physicalMembershipStarted_68, s0_.physicalMembershipEnded AS physicalMembershipEnded_69, s0_.lastModified AS lastModified_70, s0_.lastChangeUser AS lastChangeUser_71, s0_.nAiWebinarsAttended AS nAiWebinarsAttended_72, s0_.nAiWebinarsApplied AS nAiWebinarsApplied_73, s0_.nAiEventsAttended AS nAiEventsAttended_74, s0_.nAiEventsApplied AS nAiEventsApplied_75, s0_.nPaidAttended AS nPaidAttended_76, s0_.nPaidApplied AS nPaidApplied_77, s0_.nKiEinstiegAttended AS nKiEinstiegAttended_78, s0_.nKiEinstiegApplied AS nKiEinstiegApplied_79, s0_.nPromptEngineeringAttended AS nPromptEngineeringAttended_80, s0_.nPromptEngineeringApplied AS nPromptEngineeringApplied_81, s0_.nEcodynamicsAttended AS nEcodynamicsAttended_82, s0_.nEcodynamicsApplied AS nEcodynamicsApplied_83, s0_.nBbqApplied AS nBbqApplied_84, s0_.nAiFridayApplied AS nAiFridayApplied_85, s0_.nAiGatheringApplied AS nAiGatheringApplied_86, s0_.nAiGatheringAttended AS nAiGatheringAttended_87, s0_.aiSs24Applied AS aiSs24Applied_88, s0_.aiSs24Booked AS aiSs24Booked_89, s0_.interestedIn AS interestedIn_90, s0_.interests AS interests_91, s0_.mentorMetadata AS mentorMetadata_92, s0_.eventParticipations AS eventParticipations_93, s0_.kiKompetenz AS kiKompetenz_94, s0_.mentorOwnerId AS mentorOwnerId_95 FROM sp_members s0_, sp_member_teams s1_ WHERE s0_.id = s1_.member_id AND s1_.team_id = 15752 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.utm_source AS utm_source_5,
  t0.utm_medium AS utm_medium_6,
  t0.utm_campaign AS utm_campaign_7,
  t0.utm_term AS utm_term_8,
  t0.utm_content AS utm_content_9,
  t0.votesRegistered AS votesRegistered_10,
  t0.programName AS programName_11,
  t0.programSlug AS programSlug_12,
  t0.batchName AS batchName_13,
  t0.batchSlug AS batchSlug_14,
  t0.template AS template_15,
  t0.teamId AS teamId_16,
  t0.memberId AS memberId_17,
  t0.lang AS lang_18,
  t0.startupName AS startupName_19,
  t0.visibility AS visibility_20,
  t0.firstName AS firstName_21,
  t0.lastName AS lastName_22,
  t0.person AS person_23,
  t0.email AS email_24,
  t0.secondaryEmail AS secondaryEmail_25,
  t0.phone AS phone_26,
  t0.linkedin AS linkedin_27,
  t0.telegram AS telegram_28,
  t0.discord AS discord_29,
  t0.wallet AS wallet_30,
  t0.priceinEuroCent AS priceinEuroCent_31,
  t0.realPriceinEuroCent AS realPriceinEuroCent_32,
  t0.discountPercent AS discountPercent_33,
  t0.discountReason AS discountReason_34,
  t0.teamSize AS teamSize_35,
  t0.city AS city_36,
  t0.startupStage AS startupStage_37,
  t0.industry AS industry_38,
  t0.track AS track_39,
  t0.projectCategory AS projectCategory_40,
  t0.blockchain AS blockchain_41,
  t0.recommendedBy AS recommendedBy_42,
  t0.editStatus AS editStatus_43,
  t0.editMessage AS editMessage_44,
  t0.applicationStatus AS applicationStatus_45,
  t0.reviewStatus AS reviewStatus_46,
  t0.applicantType AS applicantType_47,
  t0.canReadList AS canReadList_48,
  t0.isSitting AS isSitting_49,
  t0.isNewMember AS isNewMember_50,
  t0.hasNewsletterPermissionGiven AS hasNewsletterPermissionGiven_51,
  t0.hasConfirmationMailSent AS hasConfirmationMailSent_52,
  t0.hasTermsAccepted AS hasTermsAccepted_53,
  t0.hasPaid AS hasPaid_54,
  t0.hasVolunteerAgreed AS hasVolunteerAgreed_55,
  t0.hasEmailValidated AS hasEmailValidated_56,
  t0.batchStatus AS batchStatus_57,
  t0.selectionStatus AS selectionStatus_58,
  t0.participationStatus AS participationStatus_59,
  t0.coachMemberId AS coachMemberId_60,
  t0.participationStartedAt AS participationStartedAt_61,
  t0.participationCompletedAt AS participationCompletedAt_62,
  t0.pitchPosition AS pitchPosition_63,
  t0.pitchImageLink AS pitchImageLink_64,
  t0.pitchVideoLink AS pitchVideoLink_65,
  t0.linkPitchDeck AS linkPitchDeck_66,
  t0.publicIdPitchDeck AS publicIdPitchDeck_67,
  t0.ideaPaperUrl AS ideaPaperUrl_68,
  t0.publicIdIdeaPaper AS publicIdIdeaPaper_69,
  t0.websiteUrl AS websiteUrl_70,
  t0.fulltime AS fulltime_71,
  t0.language AS language_72,
  t0.mvpStatus AS mvpStatus_73,
  t0.dealroomUrl AS dealroomUrl_74,
  t0.podioId AS podioId_75,
  t0.podioItemId AS podioItemId_76,
  t0.podioUrl AS podioUrl_77,
  t0.ideaPitch AS ideaPitch_78,
  t0.createdAt AS createdAt_79,
  t0.lastModified AS lastModified_80,
  t0.deletedAt AS deletedAt_81,
  t0.lastChangeUser AS lastChangeUser_82,
  t0.history AS history_83,
  t0.extraFields AS extraFields_84,
  t0.adminNotes AS adminNotes_85,
  t0.ratingJudge1 AS ratingJudge1_86,
  t0.ratingJudge2 AS ratingJudge2_87,
  t0.ratingJudge3 AS ratingJudge3_88,
  t0.ratingJudge4 AS ratingJudge4_89,
  t0.ratingJudge5 AS ratingJudge5_90,
  t0.ratingAverage AS ratingAverage_91,
  t0.ratingUpdatedAt AS ratingUpdatedAt_92,
  t0.memberTagsAtRegistration AS memberTagsAtRegistration_93,
  t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_94,
  t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_95,
  t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_96,
  t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_97,
  t0.pendingMemberData AS pendingMemberData_98,
  t0.pendingTeamData AS pendingTeamData_99,
  t0.resumeToken AS resumeToken_100,
  t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_101,
  t0.isMemberCreated AS isMemberCreated_102,
  t0.isTeamCreated AS isTeamCreated_103
FROM
  sp_applications t0
WHERE
  t0.teamId = ?
  AND t0.programId IN (?)
  AND (
    (t0.deletedAt IS NULL)
  )

SELECT t0.id AS id_1, t0.startupId AS startupId_2, t0.programId AS programId_3, t0.batchId AS batchId_4, t0.utm_source AS utm_source_5, t0.utm_medium AS utm_medium_6, t0.utm_campaign AS utm_campaign_7, t0.utm_term AS utm_term_8, t0.utm_content AS utm_content_9, t0.votesRegistered AS votesRegistered_10, t0.programName AS programName_11, t0.programSlug AS programSlug_12, t0.batchName AS batchName_13, t0.batchSlug AS batchSlug_14, t0.template AS template_15, t0.teamId AS teamId_16, t0.memberId AS memberId_17, t0.lang AS lang_18, t0.startupName AS startupName_19, t0.visibility AS visibility_20, t0.firstName AS firstName_21, t0.lastName AS lastName_22, t0.person AS person_23, t0.email AS email_24, t0.secondaryEmail AS secondaryEmail_25, t0.phone AS phone_26, t0.linkedin AS linkedin_27, t0.telegram AS telegram_28, t0.discord AS discord_29, t0.wallet AS wallet_30, t0.priceinEuroCent AS priceinEuroCent_31, t0.realPriceinEuroCent AS realPriceinEuroCent_32, t0.discountPercent AS discountPercent_33, t0.discountReason AS discountReason_34, t0.teamSize AS teamSize_35, t0.city AS city_36, t0.startupStage AS startupStage_37, t0.industry AS industry_38, t0.track AS track_39, t0.projectCategory AS projectCategory_40, t0.blockchain AS blockchain_41, t0.recommendedBy AS recommendedBy_42, t0.editStatus AS editStatus_43, t0.editMessage AS editMessage_44, t0.applicationStatus AS applicationStatus_45, t0.reviewStatus AS reviewStatus_46, t0.applicantType AS applicantType_47, t0.canReadList AS canReadList_48, t0.isSitting AS isSitting_49, t0.isNewMember AS isNewMember_50, t0.hasNewsletterPermissionGiven AS hasNewsletterPermissionGiven_51, t0.hasConfirmationMailSent AS hasConfirmationMailSent_52, t0.hasTermsAccepted AS hasTermsAccepted_53, t0.hasPaid AS hasPaid_54, t0.hasVolunteerAgreed AS hasVolunteerAgreed_55, t0.hasEmailValidated AS hasEmailValidated_56, t0.batchStatus AS batchStatus_57, t0.selectionStatus AS selectionStatus_58, t0.participationStatus AS participationStatus_59, t0.coachMemberId AS coachMemberId_60, t0.participationStartedAt AS participationStartedAt_61, t0.participationCompletedAt AS participationCompletedAt_62, t0.pitchPosition AS pitchPosition_63, t0.pitchImageLink AS pitchImageLink_64, t0.pitchVideoLink AS pitchVideoLink_65, t0.linkPitchDeck AS linkPitchDeck_66, t0.publicIdPitchDeck AS publicIdPitchDeck_67, t0.ideaPaperUrl AS ideaPaperUrl_68, t0.publicIdIdeaPaper AS publicIdIdeaPaper_69, t0.websiteUrl AS websiteUrl_70, t0.fulltime AS fulltime_71, t0.language AS language_72, t0.mvpStatus AS mvpStatus_73, t0.dealroomUrl AS dealroomUrl_74, t0.podioId AS podioId_75, t0.podioItemId AS podioItemId_76, t0.podioUrl AS podioUrl_77, t0.ideaPitch AS ideaPitch_78, t0.createdAt AS createdAt_79, t0.lastModified AS lastModified_80, t0.deletedAt AS deletedAt_81, t0.lastChangeUser AS lastChangeUser_82, t0.history AS history_83, t0.extraFields AS extraFields_84, t0.adminNotes AS adminNotes_85, t0.ratingJudge1 AS ratingJudge1_86, t0.ratingJudge2 AS ratingJudge2_87, t0.ratingJudge3 AS ratingJudge3_88, t0.ratingJudge4 AS ratingJudge4_89, t0.ratingJudge5 AS ratingJudge5_90, t0.ratingAverage AS ratingAverage_91, t0.ratingUpdatedAt AS ratingUpdatedAt_92, t0.memberTagsAtRegistration AS memberTagsAtRegistration_93, t0.wasCommunityMemberAtRegistration AS wasCommunityMemberAtRegistration_94, t0.wasPhysicalMemberAtRegistration AS wasPhysicalMemberAtRegistration_95, t0.memberUtmSourceAtRegistration AS memberUtmSourceAtRegistration_96, t0.kiKompetenzAtRegistration AS kiKompetenzAtRegistration_97, t0.pendingMemberData AS pendingMemberData_98, t0.pendingTeamData AS pendingTeamData_99, t0.resumeToken AS resumeToken_100, t0.resumeTokenExpiresAt AS resumeTokenExpiresAt_101, t0.isMemberCreated AS isMemberCreated_102, t0.isTeamCreated AS isTeamCreated_103 FROM sp_applications t0 WHERE t0.teamId = 15752 AND t0.programId IN ('1', '2', '3') AND ((t0.deletedAt IS NULL));

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 = '3000058';

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