| 1 |
112.19 ms |
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_ WHERE s0_.tags LIKE ? AND s0_.status = ? ORDER BY s0_.lastName ASC, s0_.firstName ASC
Parameters: [
"%mentor-ai-accelerator%"
"active"
]
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_
WHERE
s0_.tags LIKE ?
AND s0_.status = ?
ORDER BY
s0_.lastName ASC,
s0_.firstName 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_ WHERE s0_.tags LIKE '%mentor-ai-accelerator%' AND s0_.status = 'active' ORDER BY s0_.lastName ASC, s0_.firstName ASC;
|