DECLARE
@PROF INT = XXX
SELECT
CPM.person_id AS [person_id],
P.last_name + ', ' + P.nick_name AS [person_name],
CPM.notes AS [Notes]
FROM
core_profile_member CPM
LEFT JOIN core_person P ON P.person_id = CPM.person_id
WHERE
CPM.profile_id = @PROF
ORDER BY
P.last_name , P.nick_name