1
0.55 ms
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 . imageLink AS imageLink_14 , t0 . startplatz AS startplatz_15 , t0 . gruenderstipendium AS gruenderstipendium_16 , t0 . gsJury AS gsJury_17 , t0 . gsStatus AS gsStatus_18 , t0 . accelerator AS accelerator_19 , t0 . batch AS batch_20 , t0 . batchFirst AS batchFirst_21 , t0 . batchLast AS batchLast_22 , t0 . batchYear AS batchYear_23 , t0 . hasCertificate AS hasCertificate_24 , t0 . hasBadgeStartplatz AS hasBadgeStartplatz_25 , t0 . rheinlandPitch AS rheinlandPitch_26 , t0 . rheinlandPitchStatus AS rheinlandPitchStatus_27 , t0 . rheinlandPitchBestResult AS rheinlandPitchBestResult_28 , t0 . rheinlandPitchHistory AS rheinlandPitchHistory_29 , t0 . pitchNumber AS pitchNumber_30 , t0 . pitchDate AS pitchDate_31 , t0 . pitchTopic AS pitchTopic_32 , t0 . todos AS todos_33 , t0 . industry AS industry_34 , t0 . industryCondensed AS industryCondensed_35 , t0 . customerFocus AS customerFocus_36 , t0 . BusinessModel AS BusinessModel_37 , t0 . tags AS tags_38 , t0 . oneSentencePitch AS oneSentencePitch_39 , t0 . foundationYear AS foundationYear_40 , t0 . location AS location_41 , t0 . city AS city_42 , t0 . employeesCount AS employeesCount_43 , t0 . funding AS funding_44 , t0 . investors AS investors_45 , t0 . revenue AS revenue_46 , t0 . contactPerson AS contactPerson_47 , t0 . contactEmail AS contactEmail_48 , t0 . contactTelefon AS contactTelefon_49 , t0 . xing AS xing_50 , t0 . linkedin AS linkedin_51 , t0 . facebook AS facebook_52 , t0 . twitter AS twitter_53 , t0 . instagram AS instagram_54 , t0 . description AS description_55 , t0 . comments AS comments_56 , t0 . history AS history_57 , t0 . lastChangeUser AS lastChangeUser_58 , t0 . createdAt AS createdAt_59 , t0 . lastModified AS lastModified_60 , t0 . lastChangedBy AS lastChangedBy_61 FROM aaa_startups t0 WHERE t0 . id = ? LIMIT 1
Parameters :
[
"3000836 "
]
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 . imageLink AS imageLink_14 ,
t0 . startplatz AS startplatz_15 ,
t0 . gruenderstipendium AS gruenderstipendium_16 ,
t0 . gsJury AS gsJury_17 ,
t0 . gsStatus AS gsStatus_18 ,
t0 . accelerator AS accelerator_19 ,
t0 . batch AS batch_20 ,
t0 . batchFirst AS batchFirst_21 ,
t0 . batchLast AS batchLast_22 ,
t0 . batchYear AS batchYear_23 ,
t0 . hasCertificate AS hasCertificate_24 ,
t0 . hasBadgeStartplatz AS hasBadgeStartplatz_25 ,
t0 . rheinlandPitch AS rheinlandPitch_26 ,
t0 . rheinlandPitchStatus AS rheinlandPitchStatus_27 ,
t0 . rheinlandPitchBestResult AS rheinlandPitchBestResult_28 ,
t0 . rheinlandPitchHistory AS rheinlandPitchHistory_29 ,
t0 . pitchNumber AS pitchNumber_30 ,
t0 . pitchDate AS pitchDate_31 ,
t0 . pitchTopic AS pitchTopic_32 ,
t0 . todos AS todos_33 ,
t0 . industry AS industry_34 ,
t0 . industryCondensed AS industryCondensed_35 ,
t0 . customerFocus AS customerFocus_36 ,
t0 . BusinessModel AS BusinessModel_37 ,
t0 . tags AS tags_38 ,
t0 . oneSentencePitch AS oneSentencePitch_39 ,
t0 . foundationYear AS foundationYear_40 ,
t0 . location AS location_41 ,
t0 . city AS city_42 ,
t0 . employeesCount AS employeesCount_43 ,
t0 . funding AS funding_44 ,
t0 . investors AS investors_45 ,
t0 . revenue AS revenue_46 ,
t0 . contactPerson AS contactPerson_47 ,
t0 . contactEmail AS contactEmail_48 ,
t0 . contactTelefon AS contactTelefon_49 ,
t0 . xing AS xing_50 ,
t0 . linkedin AS linkedin_51 ,
t0 . facebook AS facebook_52 ,
t0 . twitter AS twitter_53 ,
t0 . instagram AS instagram_54 ,
t0 . description AS description_55 ,
t0 . comments AS comments_56 ,
t0 . history AS history_57 ,
t0 . lastChangeUser AS lastChangeUser_58 ,
t0 . createdAt AS createdAt_59 ,
t0 . lastModified AS lastModified_60 ,
t0 . lastChangedBy AS lastChangedBy_61
FROM
aaa_startups t0
WHERE
t0 . id = ?
LIMIT
1
Copy
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 . imageLink AS imageLink_14 , t0 . startplatz AS startplatz_15 , t0 . gruenderstipendium AS gruenderstipendium_16 , t0 . gsJury AS gsJury_17 , t0 . gsStatus AS gsStatus_18 , t0 . accelerator AS accelerator_19 , t0 . batch AS batch_20 , t0 . batchFirst AS batchFirst_21 , t0 . batchLast AS batchLast_22 , t0 . batchYear AS batchYear_23 , t0 . hasCertificate AS hasCertificate_24 , t0 . hasBadgeStartplatz AS hasBadgeStartplatz_25 , t0 . rheinlandPitch AS rheinlandPitch_26 , t0 . rheinlandPitchStatus AS rheinlandPitchStatus_27 , t0 . rheinlandPitchBestResult AS rheinlandPitchBestResult_28 , t0 . rheinlandPitchHistory AS rheinlandPitchHistory_29 , t0 . pitchNumber AS pitchNumber_30 , t0 . pitchDate AS pitchDate_31 , t0 . pitchTopic AS pitchTopic_32 , t0 . todos AS todos_33 , t0 . industry AS industry_34 , t0 . industryCondensed AS industryCondensed_35 , t0 . customerFocus AS customerFocus_36 , t0 . BusinessModel AS BusinessModel_37 , t0 . tags AS tags_38 , t0 . oneSentencePitch AS oneSentencePitch_39 , t0 . foundationYear AS foundationYear_40 , t0 . location AS location_41 , t0 . city AS city_42 , t0 . employeesCount AS employeesCount_43 , t0 . funding AS funding_44 , t0 . investors AS investors_45 , t0 . revenue AS revenue_46 , t0 . contactPerson AS contactPerson_47 , t0 . contactEmail AS contactEmail_48 , t0 . contactTelefon AS contactTelefon_49 , t0 . xing AS xing_50 , t0 . linkedin AS linkedin_51 , t0 . facebook AS facebook_52 , t0 . twitter AS twitter_53 , t0 . instagram AS instagram_54 , t0 . description AS description_55 , t0 . comments AS comments_56 , t0 . history AS history_57 , t0 . lastChangeUser AS lastChangeUser_58 , t0 . createdAt AS createdAt_59 , t0 . lastModified AS lastModified_60 , t0 . lastChangedBy AS lastChangedBy_61 FROM aaa_startups t0 WHERE t0 . id = '3000836' LIMIT 1 ;
Copy
2
0.38 ms
SELECT t0 . id AS id_1 , t0 . startupId AS startupId_2 , t0 . location AS location_3 , t0 . locationSecond AS locationSecond_4 , t0 . name AS name_5 , t0 . shortName AS shortName_6 , t0 . previousName AS previousName_7 , t0 . person AS person_8 , t0 . phone AS phone_9 , t0 . addressFieldOne AS addressFieldOne_10 , t0 . addressFieldTwo AS addressFieldTwo_11 , t0 . addressCountryCode AS addressCountryCode_12 , t0 . addressPostalCode AS addressPostalCode_13 , t0 . addressCity AS addressCity_14 , t0 . spTeamId AS spTeamId_15 , t0 . accountEmail AS accountEmail_16 , t0 . connectEmail AS connectEmail_17 , t0 . status AS status_18 , t0 . 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 FROM aaa_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
FROM
aaa_sp_teams t0
WHERE
t0 . id = ?
LIMIT
1
Copy
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 FROM aaa_sp_teams t0 WHERE t0 . id = 16284 LIMIT 1 ;
Copy
3
1.92 ms
SELECT a0_ . id AS id_0 , a0_ . owner AS owner_1 , a0_ . type AS type_2 , a0_ . externalId AS externalId_3 , a0_ . score AS score_4 , a0_ . name AS name_5 , a0_ . title AS title_6 , a0_ . imageLink AS imageLink_7 , a0_ . categories AS categories_8 , a0_ . tags AS tags_9 , a0_ . isActive AS isActive_10 , a0_ . lastModified AS lastModified_11 , a0_ . lastChangeUser AS lastChangeUser_12 , a0_ . createdAt AS createdAt_13 FROM aaa_feed a0_ WHERE a0_ . tags LIKE ? ORDER BY a0_ . score DESC
Parameters :
[
"%"the-trip-hero-app"% "
]
SELECT a0_ . id AS id_0 , a0_ . owner AS owner_1 , a0_ . type AS type_2 , a0_ . externalId AS externalId_3 , a0_ . score AS score_4 , a0_ . name AS name_5 , a0_ . title AS title_6 , a0_ . imageLink AS imageLink_7 , a0_ . categories AS categories_8 , a0_ . tags AS tags_9 , a0_ . isActive AS isActive_10 , a0_ . lastModified AS lastModified_11 , a0_ . lastChangeUser AS lastChangeUser_12 , a0_ . createdAt AS createdAt_13 FROM aaa_feed a0_ WHERE a0_ . tags LIKE '%\"the-trip-hero-app\"%' ORDER BY a0_ . score DESC ;
Copy
4
16.25 ms
SELECT a0_ . startupName AS startupName_0 , a0_ . pitchPosition AS pitchPosition_1 , a0_ . programName AS programName_2 , a0_ . batchName AS batchName_3 , a1_ . pitchDate AS pitchDate_4 , a1_ . city AS city_5 FROM aab_applications a0_ INNER JOIN aab_batches a1_ ON (a0_ . batchId = a1_ . id ) WHERE a0_ . startupId = ? AND a0_ . programId = ?
Parameters :
[
"3000836 "
1
]
SELECT a0_ . startupName AS startupName_0 , a0_ . pitchPosition AS pitchPosition_1 , a0_ . programName AS programName_2 , a0_ . batchName AS batchName_3 , a1_ . pitchDate AS pitchDate_4 , a1_ . city AS city_5 FROM aab_applications a0_ INNER JOIN aab_batches a1_ ON (a0_ . batchId = a1_ . id ) WHERE a0_ . startupId = '3000836' AND a0_ . programId = 1 ;
Copy
5
1.42 ms
SELECT a0_ . id AS id_0 , a0_ . spMemberId AS spMemberId_1 , a0_ . score AS score_2 , a0_ . completenessScore AS completenessScore_3 , a0_ . status AS status_4 , a0_ . location AS location_5 , a0_ . salutation AS salutation_6 , a0_ . title AS title_7 , a0_ . jobTitle AS jobTitle_8 , a0_ . firstName AS firstName_9 , a0_ . lastName AS lastName_10 , a0_ . name AS name_11 , a0_ . sortName AS sortName_12 , a0_ . email AS email_13 , a0_ . secondaryEmail AS secondaryEmail_14 , a0_ . phone AS phone_15 , a0_ . hasCommunityMembership AS hasCommunityMembership_16 , a0_ . aiMemberValid AS aiMemberValid_17 , a0_ . aiMemberStatus AS aiMemberStatus_18 , a0_ . aiMemberReason AS aiMemberReason_19 , a0_ . aiMemberStart AS aiMemberStart_20 , a0_ . aiMemberEnd AS aiMemberEnd_21 , a0_ . utm_source AS utm_source_22 , a0_ . utm_medium AS utm_medium_23 , a0_ . utm_campaign AS utm_campaign_24 , a0_ . utm_term AS utm_term_25 , a0_ . utm_content AS utm_content_26 , a0_ . birthday AS birthday_27 , a0_ . addressFieldOne AS addressFieldOne_28 , a0_ . addressFieldTwo AS addressFieldTwo_29 , a0_ . addressCountryCode AS addressCountryCode_30 , a0_ . addressPostalCode AS addressPostalCode_31 , a0_ . addressCity AS addressCity_32 , a0_ . teamId AS teamId_33 , a0_ . teamName AS teamName_34 , a0_ . company AS company_35 , a0_ . history AS history_36 , a0_ . tags AS tags_37 , a0_ . annotation AS annotation_38 , a0_ . mentorBuckets AS mentorBuckets_39 , a0_ . areasOfExpertise AS areasOfExpertise_40 , a0_ . mentor_firma AS mentor_firma_41 , a0_ . mentor_firma_url AS mentor_firma_url_42 , a0_ . mentor_locations AS mentor_locations_43 , a0_ . mentor_profile AS mentor_profile_44 , a0_ . mentor_note AS mentor_note_45 , a0_ . mentor_admin_rating AS mentor_admin_rating_46 , a0_ . active AS active_47 , a0_ . tiefgarage AS tiefgarage_48 , a0_ . transponder AS transponder_49 , a0_ . isTransponderAllowed AS isTransponderAllowed_50 , a0_ . imageLink AS imageLink_51 , a0_ . homepage AS homepage_52 , a0_ . xing AS xing_53 , a0_ . pipedriveId AS pipedriveId_54 , a0_ . linkedin AS linkedin_55 , a0_ . facebook AS facebook_56 , a0_ . instagram AS instagram_57 , a0_ . twitter AS twitter_58 , a0_ . skills AS skills_59 , a0_ . description AS description_60 , a0_ . touchpoints AS touchpoints_61 , a0_ . isAddressComplete AS isAddressComplete_62 , a0_ . hasMailchimp AS hasMailchimp_63 , a0_ . hasKiNewsletter AS hasKiNewsletter_64 , a0_ . enterDate AS enterDate_65 , a0_ . exitDate AS exitDate_66 , a0_ . physicalMembershipStarted AS physicalMembershipStarted_67 , a0_ . physicalMembershipEnded AS physicalMembershipEnded_68 , a0_ . lastModified AS lastModified_69 , a0_ . lastChangeUser AS lastChangeUser_70 , a0_ . nAiWebinarsAttended AS nAiWebinarsAttended_71 , a0_ . nAiWebinarsApplied AS nAiWebinarsApplied_72 , a0_ . nAiEventsAttended AS nAiEventsAttended_73 , a0_ . nAiEventsApplied AS nAiEventsApplied_74 , a0_ . nPaidAttended AS nPaidAttended_75 , a0_ . nPaidApplied AS nPaidApplied_76 , a0_ . nKiEinstiegAttended AS nKiEinstiegAttended_77 , a0_ . nKiEinstiegApplied AS nKiEinstiegApplied_78 , a0_ . nPromptEngineeringAttended AS nPromptEngineeringAttended_79 , a0_ . nPromptEngineeringApplied AS nPromptEngineeringApplied_80 , a0_ . nEcodynamicsAttended AS nEcodynamicsAttended_81 , a0_ . nEcodynamicsApplied AS nEcodynamicsApplied_82 , a0_ . nBbqApplied AS nBbqApplied_83 , a0_ . nAiFridayApplied AS nAiFridayApplied_84 , a0_ . nAiGatheringApplied AS nAiGatheringApplied_85 , a0_ . nAiGatheringAttended AS nAiGatheringAttended_86 , a0_ . aiSs24Applied AS aiSs24Applied_87 , a0_ . aiSs24Booked AS aiSs24Booked_88 , a0_ . interestedIn AS interestedIn_89 , a0_ . interests AS interests_90 , a0_ . mentorMetadata AS mentorMetadata_91 , a0_ . eventParticipations AS eventParticipations_92 , a0_ . kiKompetenz AS kiKompetenz_93 , a0_ . mentorOwnerId AS mentorOwnerId_94 FROM aaa_sp_members a0_ , aaa_sp_members_teams a1_ WHERE a0_ . id = a1_ . member_id AND a1_ . team_id = ? ORDER BY a0_ . firstName ASC , a0_ . lastName ASC
SELECT
a0_ . id AS id_0 ,
a0_ . spMemberId AS spMemberId_1 ,
a0_ . score AS score_2 ,
a0_ . completenessScore AS completenessScore_3 ,
a0_ . status AS status_4 ,
a0_ . location AS location_5 ,
a0_ . salutation AS salutation_6 ,
a0_ . title AS title_7 ,
a0_ . jobTitle AS jobTitle_8 ,
a0_ . firstName AS firstName_9 ,
a0_ . lastName AS lastName_10 ,
a0_ . name AS name_11 ,
a0_ . sortName AS sortName_12 ,
a0_ . email AS email_13 ,
a0_ . secondaryEmail AS secondaryEmail_14 ,
a0_ . phone AS phone_15 ,
a0_ . hasCommunityMembership AS hasCommunityMembership_16 ,
a0_ . aiMemberValid AS aiMemberValid_17 ,
a0_ . aiMemberStatus AS aiMemberStatus_18 ,
a0_ . aiMemberReason AS aiMemberReason_19 ,
a0_ . aiMemberStart AS aiMemberStart_20 ,
a0_ . aiMemberEnd AS aiMemberEnd_21 ,
a0_ . utm_source AS utm_source_22 ,
a0_ . utm_medium AS utm_medium_23 ,
a0_ . utm_campaign AS utm_campaign_24 ,
a0_ . utm_term AS utm_term_25 ,
a0_ . utm_content AS utm_content_26 ,
a0_ . birthday AS birthday_27 ,
a0_ . addressFieldOne AS addressFieldOne_28 ,
a0_ . addressFieldTwo AS addressFieldTwo_29 ,
a0_ . addressCountryCode AS addressCountryCode_30 ,
a0_ . addressPostalCode AS addressPostalCode_31 ,
a0_ . addressCity AS addressCity_32 ,
a0_ . teamId AS teamId_33 ,
a0_ . teamName AS teamName_34 ,
a0_ . company AS company_35 ,
a0_ . history AS history_36 ,
a0_ . tags AS tags_37 ,
a0_ . annotation AS annotation_38 ,
a0_ . mentorBuckets AS mentorBuckets_39 ,
a0_ . areasOfExpertise AS areasOfExpertise_40 ,
a0_ . mentor_firma AS mentor_firma_41 ,
a0_ . mentor_firma_url AS mentor_firma_url_42 ,
a0_ . mentor_locations AS mentor_locations_43 ,
a0_ . mentor_profile AS mentor_profile_44 ,
a0_ . mentor_note AS mentor_note_45 ,
a0_ . mentor_admin_rating AS mentor_admin_rating_46 ,
a0_ . active AS active_47 ,
a0_ . tiefgarage AS tiefgarage_48 ,
a0_ . transponder AS transponder_49 ,
a0_ . isTransponderAllowed AS isTransponderAllowed_50 ,
a0_ . imageLink AS imageLink_51 ,
a0_ . homepage AS homepage_52 ,
a0_ . xing AS xing_53 ,
a0_ . pipedriveId AS pipedriveId_54 ,
a0_ . linkedin AS linkedin_55 ,
a0_ . facebook AS facebook_56 ,
a0_ . instagram AS instagram_57 ,
a0_ . twitter AS twitter_58 ,
a0_ . skills AS skills_59 ,
a0_ . description AS description_60 ,
a0_ . touchpoints AS touchpoints_61 ,
a0_ . isAddressComplete AS isAddressComplete_62 ,
a0_ . hasMailchimp AS hasMailchimp_63 ,
a0_ . hasKiNewsletter AS hasKiNewsletter_64 ,
a0_ . enterDate AS enterDate_65 ,
a0_ . exitDate AS exitDate_66 ,
a0_ . physicalMembershipStarted AS physicalMembershipStarted_67 ,
a0_ . physicalMembershipEnded AS physicalMembershipEnded_68 ,
a0_ . lastModified AS lastModified_69 ,
a0_ . lastChangeUser AS lastChangeUser_70 ,
a0_ . nAiWebinarsAttended AS nAiWebinarsAttended_71 ,
a0_ . nAiWebinarsApplied AS nAiWebinarsApplied_72 ,
a0_ . nAiEventsAttended AS nAiEventsAttended_73 ,
a0_ . nAiEventsApplied AS nAiEventsApplied_74 ,
a0_ . nPaidAttended AS nPaidAttended_75 ,
a0_ . nPaidApplied AS nPaidApplied_76 ,
a0_ . nKiEinstiegAttended AS nKiEinstiegAttended_77 ,
a0_ . nKiEinstiegApplied AS nKiEinstiegApplied_78 ,
a0_ . nPromptEngineeringAttended AS nPromptEngineeringAttended_79 ,
a0_ . nPromptEngineeringApplied AS nPromptEngineeringApplied_80 ,
a0_ . nEcodynamicsAttended AS nEcodynamicsAttended_81 ,
a0_ . nEcodynamicsApplied AS nEcodynamicsApplied_82 ,
a0_ . nBbqApplied AS nBbqApplied_83 ,
a0_ . nAiFridayApplied AS nAiFridayApplied_84 ,
a0_ . nAiGatheringApplied AS nAiGatheringApplied_85 ,
a0_ . nAiGatheringAttended AS nAiGatheringAttended_86 ,
a0_ . aiSs24Applied AS aiSs24Applied_87 ,
a0_ . aiSs24Booked AS aiSs24Booked_88 ,
a0_ . interestedIn AS interestedIn_89 ,
a0_ . interests AS interests_90 ,
a0_ . mentorMetadata AS mentorMetadata_91 ,
a0_ . eventParticipations AS eventParticipations_92 ,
a0_ . kiKompetenz AS kiKompetenz_93 ,
a0_ . mentorOwnerId AS mentorOwnerId_94
FROM
aaa_sp_members a0_ ,
aaa_sp_members_teams a1_
WHERE
a0_ . id = a1_ . member_id
AND a1_ . team_id = ?
ORDER BY
a0_ . firstName ASC ,
a0_ . lastName ASC
Copy
SELECT a0_ . id AS id_0 , a0_ . spMemberId AS spMemberId_1 , a0_ . score AS score_2 , a0_ . completenessScore AS completenessScore_3 , a0_ . status AS status_4 , a0_ . location AS location_5 , a0_ . salutation AS salutation_6 , a0_ . title AS title_7 , a0_ . jobTitle AS jobTitle_8 , a0_ . firstName AS firstName_9 , a0_ . lastName AS lastName_10 , a0_ . name AS name_11 , a0_ . sortName AS sortName_12 , a0_ . email AS email_13 , a0_ . secondaryEmail AS secondaryEmail_14 , a0_ . phone AS phone_15 , a0_ . hasCommunityMembership AS hasCommunityMembership_16 , a0_ . aiMemberValid AS aiMemberValid_17 , a0_ . aiMemberStatus AS aiMemberStatus_18 , a0_ . aiMemberReason AS aiMemberReason_19 , a0_ . aiMemberStart AS aiMemberStart_20 , a0_ . aiMemberEnd AS aiMemberEnd_21 , a0_ . utm_source AS utm_source_22 , a0_ . utm_medium AS utm_medium_23 , a0_ . utm_campaign AS utm_campaign_24 , a0_ . utm_term AS utm_term_25 , a0_ . utm_content AS utm_content_26 , a0_ . birthday AS birthday_27 , a0_ . addressFieldOne AS addressFieldOne_28 , a0_ . addressFieldTwo AS addressFieldTwo_29 , a0_ . addressCountryCode AS addressCountryCode_30 , a0_ . addressPostalCode AS addressPostalCode_31 , a0_ . addressCity AS addressCity_32 , a0_ . teamId AS teamId_33 , a0_ . teamName AS teamName_34 , a0_ . company AS company_35 , a0_ . history AS history_36 , a0_ . tags AS tags_37 , a0_ . annotation AS annotation_38 , a0_ . mentorBuckets AS mentorBuckets_39 , a0_ . areasOfExpertise AS areasOfExpertise_40 , a0_ . mentor_firma AS mentor_firma_41 , a0_ . mentor_firma_url AS mentor_firma_url_42 , a0_ . mentor_locations AS mentor_locations_43 , a0_ . mentor_profile AS mentor_profile_44 , a0_ . mentor_note AS mentor_note_45 , a0_ . mentor_admin_rating AS mentor_admin_rating_46 , a0_ . active AS active_47 , a0_ . tiefgarage AS tiefgarage_48 , a0_ . transponder AS transponder_49 , a0_ . isTransponderAllowed AS isTransponderAllowed_50 , a0_ . imageLink AS imageLink_51 , a0_ . homepage AS homepage_52 , a0_ . xing AS xing_53 , a0_ . pipedriveId AS pipedriveId_54 , a0_ . linkedin AS linkedin_55 , a0_ . facebook AS facebook_56 , a0_ . instagram AS instagram_57 , a0_ . twitter AS twitter_58 , a0_ . skills AS skills_59 , a0_ . description AS description_60 , a0_ . touchpoints AS touchpoints_61 , a0_ . isAddressComplete AS isAddressComplete_62 , a0_ . hasMailchimp AS hasMailchimp_63 , a0_ . hasKiNewsletter AS hasKiNewsletter_64 , a0_ . enterDate AS enterDate_65 , a0_ . exitDate AS exitDate_66 , a0_ . physicalMembershipStarted AS physicalMembershipStarted_67 , a0_ . physicalMembershipEnded AS physicalMembershipEnded_68 , a0_ . lastModified AS lastModified_69 , a0_ . lastChangeUser AS lastChangeUser_70 , a0_ . nAiWebinarsAttended AS nAiWebinarsAttended_71 , a0_ . nAiWebinarsApplied AS nAiWebinarsApplied_72 , a0_ . nAiEventsAttended AS nAiEventsAttended_73 , a0_ . nAiEventsApplied AS nAiEventsApplied_74 , a0_ . nPaidAttended AS nPaidAttended_75 , a0_ . nPaidApplied AS nPaidApplied_76 , a0_ . nKiEinstiegAttended AS nKiEinstiegAttended_77 , a0_ . nKiEinstiegApplied AS nKiEinstiegApplied_78 , a0_ . nPromptEngineeringAttended AS nPromptEngineeringAttended_79 , a0_ . nPromptEngineeringApplied AS nPromptEngineeringApplied_80 , a0_ . nEcodynamicsAttended AS nEcodynamicsAttended_81 , a0_ . nEcodynamicsApplied AS nEcodynamicsApplied_82 , a0_ . nBbqApplied AS nBbqApplied_83 , a0_ . nAiFridayApplied AS nAiFridayApplied_84 , a0_ . nAiGatheringApplied AS nAiGatheringApplied_85 , a0_ . nAiGatheringAttended AS nAiGatheringAttended_86 , a0_ . aiSs24Applied AS aiSs24Applied_87 , a0_ . aiSs24Booked AS aiSs24Booked_88 , a0_ . interestedIn AS interestedIn_89 , a0_ . interests AS interests_90 , a0_ . mentorMetadata AS mentorMetadata_91 , a0_ . eventParticipations AS eventParticipations_92 , a0_ . kiKompetenz AS kiKompetenz_93 , a0_ . mentorOwnerId AS mentorOwnerId_94 FROM aaa_sp_members a0_ , aaa_sp_members_teams a1_ WHERE a0_ . id = a1_ . member_id AND a1_ . team_id = 16284 ORDER BY a0_ . firstName ASC , a0_ . lastName ASC ;
Copy
6
62.39 ms
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 . projectCategory AS projectCategory_39 , t0 . blockchain AS blockchain_40 , t0 . recommendedBy AS recommendedBy_41 , t0 . editStatus AS editStatus_42 , t0 . editMessage AS editMessage_43 , t0 . applicationStatus AS applicationStatus_44 , t0 . reviewStatus AS reviewStatus_45 , t0 . applicantType AS applicantType_46 , t0 . canReadList AS canReadList_47 , t0 . isSitting AS isSitting_48 , t0 . isNewMember AS isNewMember_49 , t0 . hasNewsletterPermissionGiven AS hasNewsletterPermissionGiven_50 , t0 . hasConfirmationMailSent AS hasConfirmationMailSent_51 , t0 . hasTermsAccepted AS hasTermsAccepted_52 , t0 . hasPaid AS hasPaid_53 , t0 . hasVolunteerAgreed AS hasVolunteerAgreed_54 , t0 . hasEmailValidated AS hasEmailValidated_55 , t0 . batchStatus AS batchStatus_56 , t0 . pitchPosition AS pitchPosition_57 , t0 . pitchImageLink AS pitchImageLink_58 , t0 . pitchVideoLink AS pitchVideoLink_59 , t0 . linkPitchDeck AS linkPitchDeck_60 , t0 . publicIdPitchDeck AS publicIdPitchDeck_61 , t0 . websiteUrl AS websiteUrl_62 , t0 . fulltime AS fulltime_63 , t0 . language AS language_64 , t0 . mvpStatus AS mvpStatus_65 , t0 . dealroomUrl AS dealroomUrl_66 , t0 . podioId AS podioId_67 , t0 . podioItemId AS podioItemId_68 , t0 . podioUrl AS podioUrl_69 , t0 . ideaPitch AS ideaPitch_70 , t0 . createdAt AS createdAt_71 , t0 . lastModified AS lastModified_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 FROM aab_applications t0 WHERE t0 . teamId = ? AND t0 . programId IN (? )
Parameters :
[
16284
[
"1 "
"2 "
"3 "
]
]
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 . projectCategory AS projectCategory_39 ,
t0 . blockchain AS blockchain_40 ,
t0 . recommendedBy AS recommendedBy_41 ,
t0 . editStatus AS editStatus_42 ,
t0 . editMessage AS editMessage_43 ,
t0 . applicationStatus AS applicationStatus_44 ,
t0 . reviewStatus AS reviewStatus_45 ,
t0 . applicantType AS applicantType_46 ,
t0 . canReadList AS canReadList_47 ,
t0 . isSitting AS isSitting_48 ,
t0 . isNewMember AS isNewMember_49 ,
t0 . hasNewsletterPermissionGiven AS hasNewsletterPermissionGiven_50 ,
t0 . hasConfirmationMailSent AS hasConfirmationMailSent_51 ,
t0 . hasTermsAccepted AS hasTermsAccepted_52 ,
t0 . hasPaid AS hasPaid_53 ,
t0 . hasVolunteerAgreed AS hasVolunteerAgreed_54 ,
t0 . hasEmailValidated AS hasEmailValidated_55 ,
t0 . batchStatus AS batchStatus_56 ,
t0 . pitchPosition AS pitchPosition_57 ,
t0 . pitchImageLink AS pitchImageLink_58 ,
t0 . pitchVideoLink AS pitchVideoLink_59 ,
t0 . linkPitchDeck AS linkPitchDeck_60 ,
t0 . publicIdPitchDeck AS publicIdPitchDeck_61 ,
t0 . websiteUrl AS websiteUrl_62 ,
t0 . fulltime AS fulltime_63 ,
t0 . language AS language_64 ,
t0 . mvpStatus AS mvpStatus_65 ,
t0 . dealroomUrl AS dealroomUrl_66 ,
t0 . podioId AS podioId_67 ,
t0 . podioItemId AS podioItemId_68 ,
t0 . podioUrl AS podioUrl_69 ,
t0 . ideaPitch AS ideaPitch_70 ,
t0 . createdAt AS createdAt_71 ,
t0 . lastModified AS lastModified_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
FROM
aab_applications t0
WHERE
t0 . teamId = ?
AND t0 . programId IN (? )
Copy
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 . projectCategory AS projectCategory_39 , t0 . blockchain AS blockchain_40 , t0 . recommendedBy AS recommendedBy_41 , t0 . editStatus AS editStatus_42 , t0 . editMessage AS editMessage_43 , t0 . applicationStatus AS applicationStatus_44 , t0 . reviewStatus AS reviewStatus_45 , t0 . applicantType AS applicantType_46 , t0 . canReadList AS canReadList_47 , t0 . isSitting AS isSitting_48 , t0 . isNewMember AS isNewMember_49 , t0 . hasNewsletterPermissionGiven AS hasNewsletterPermissionGiven_50 , t0 . hasConfirmationMailSent AS hasConfirmationMailSent_51 , t0 . hasTermsAccepted AS hasTermsAccepted_52 , t0 . hasPaid AS hasPaid_53 , t0 . hasVolunteerAgreed AS hasVolunteerAgreed_54 , t0 . hasEmailValidated AS hasEmailValidated_55 , t0 . batchStatus AS batchStatus_56 , t0 . pitchPosition AS pitchPosition_57 , t0 . pitchImageLink AS pitchImageLink_58 , t0 . pitchVideoLink AS pitchVideoLink_59 , t0 . linkPitchDeck AS linkPitchDeck_60 , t0 . publicIdPitchDeck AS publicIdPitchDeck_61 , t0 . websiteUrl AS websiteUrl_62 , t0 . fulltime AS fulltime_63 , t0 . language AS language_64 , t0 . mvpStatus AS mvpStatus_65 , t0 . dealroomUrl AS dealroomUrl_66 , t0 . podioId AS podioId_67 , t0 . podioItemId AS podioItemId_68 , t0 . podioUrl AS podioUrl_69 , t0 . ideaPitch AS ideaPitch_70 , t0 . createdAt AS createdAt_71 , t0 . lastModified AS lastModified_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 FROM aab_applications t0 WHERE t0 . teamId = 16284 AND t0 . programId IN ('1' , '2' , '3' );
Copy
7
1.87 ms
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a1_ . type AS type_2 , a0_ . email AS email_3 FROM aaa_sp_members_teams a1_ INNER JOIN aaa_sp_members a0_ ON (a1_ . member_id = a0_ . id ) WHERE a1_ . team_id = ?
Parameters :
[
"3000836 "
]
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a1_ . type AS type_2 , a0_ . email AS email_3 FROM aaa_sp_members_teams a1_ INNER JOIN aaa_sp_members a0_ ON (a1_ . member_id = a0_ . id ) WHERE a1_ . team_id = '3000836' ;
Copy
8
3.41 ms
SELECT a0_ . id AS id_0 , a0_ . owner AS owner_1 , a0_ . type AS type_2 , a0_ . externalId AS externalId_3 , a0_ . score AS score_4 , a0_ . name AS name_5 , a0_ . title AS title_6 , a0_ . imageLink AS imageLink_7 , a0_ . categories AS categories_8 , a0_ . tags AS tags_9 , a0_ . isActive AS isActive_10 , a0_ . lastModified AS lastModified_11 , a0_ . lastChangeUser AS lastChangeUser_12 , a0_ . createdAt AS createdAt_13 FROM aaa_feed a0_ WHERE a0_ . tags LIKE ? ORDER BY a0_ . score DESC
Parameters :
[
"%"the-trip-hero-app"% "
]
SELECT a0_ . id AS id_0 , a0_ . owner AS owner_1 , a0_ . type AS type_2 , a0_ . externalId AS externalId_3 , a0_ . score AS score_4 , a0_ . name AS name_5 , a0_ . title AS title_6 , a0_ . imageLink AS imageLink_7 , a0_ . categories AS categories_8 , a0_ . tags AS tags_9 , a0_ . isActive AS isActive_10 , a0_ . lastModified AS lastModified_11 , a0_ . lastChangeUser AS lastChangeUser_12 , a0_ . createdAt AS createdAt_13 FROM aaa_feed a0_ WHERE a0_ . tags LIKE '%\"the-trip-hero-app\"%' ORDER BY a0_ . score DESC ;
Copy
9
1.23 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . externalId AS externalId_3 , t0 . score AS score_4 , t0 . feedItemsCount AS feedItemsCount_5 , t0 . name AS name_6 , t0 . title AS title_7 , t0 . imageLink AS imageLink_8 , t0 . targetUrl AS targetUrl_9 , t0 . categories AS categories_10 , t0 . tags AS tags_11 , t0 . isActive AS isActive_12 , t0 . lastModified AS lastModified_13 , t0 . createdAt AS createdAt_14 FROM aaa_actors t0 WHERE t0 . externalId = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . externalId AS externalId_3 , t0 . score AS score_4 , t0 . feedItemsCount AS feedItemsCount_5 , t0 . name AS name_6 , t0 . title AS title_7 , t0 . imageLink AS imageLink_8 , t0 . targetUrl AS targetUrl_9 , t0 . categories AS categories_10 , t0 . tags AS tags_11 , t0 . isActive AS isActive_12 , t0 . lastModified AS lastModified_13 , t0 . createdAt AS createdAt_14 FROM aaa_actors t0 WHERE t0 . externalId = 3000836 LIMIT 1 ;
Copy
10
5.87 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . externalId AS externalId_3 , t0 . score AS score_4 , t0 . feedItemsCount AS feedItemsCount_5 , t0 . name AS name_6 , t0 . title AS title_7 , t0 . imageLink AS imageLink_8 , t0 . targetUrl AS targetUrl_9 , t0 . categories AS categories_10 , t0 . tags AS tags_11 , t0 . isActive AS isActive_12 , t0 . lastModified AS lastModified_13 , t0 . createdAt AS createdAt_14 FROM aaa_actors t0 WHERE t0 . externalId = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . externalId AS externalId_3 , t0 . score AS score_4 , t0 . feedItemsCount AS feedItemsCount_5 , t0 . name AS name_6 , t0 . title AS title_7 , t0 . imageLink AS imageLink_8 , t0 . targetUrl AS targetUrl_9 , t0 . categories AS categories_10 , t0 . tags AS tags_11 , t0 . isActive AS isActive_12 , t0 . lastModified AS lastModified_13 , t0 . createdAt AS createdAt_14 FROM aaa_actors t0 WHERE t0 . externalId = 3000836 LIMIT 1 ;
Copy