select partnerid, partnertype, contactid from tbl_crm_interactions where interactionid = and ownerid = and ownertype = select fspro_userid, firstname, lastname, title from tbl_fspro_members where ownerid = and fsl_tablecode = and orgid = and orgtype = order by lastname