select int.interactionId, int.interactiondate, int.contactid, int.dispositionuserid, int.cdrdistributorid, int.mileage, int.AdditionalResourceUserId, int.partnerid, int.partnertype, int.reminderDays, int.interactionMethod, int.comment, int.notes, int.closecomment, int.participantid, ma.marketingactivityid, ma.marketingactivityname, int.interactionAttributeId from tbl_crm_interactions int with (nolock) left outer join tbl_CRM_Participants par with (nolock) on par.participantid = int.participantid left outer join tbl_crm_marketingactivities ma with (nolock) on ma.marketingactivityid = par.marketingactivityid where int.interactionid = and int.ownerid = and int.ownertype = select salutation, firstname, lastname, email, title, phone, phoneext from tbl_fspro_members where ownerid = and fsl_tablecode = and fspro_userid = select opr.Distrib1, opr.primaryContactId from tbl_opr_clientoperators opr with (nolock) inner join tbl_fspro_members fsp with (nolock) on fsp.fspro_userid = opr.primaryContactId and fsp.ownerid = opr.ownerid and fsp.fsl_tablecode = opr.fsltablecode where opr.operatorid = and opr.ownerid = and opr.fsltablecode = select cdr.primaryContactId from tbl_cdr_distributors cdr with (nolock) inner join tbl_fspro_members fsp with (nolock) on fsp.fspro_userid = cdr.primaryContactId and fsp.ownerid = cdr.ownerid and fsp.fsl_tablecode = cdr.fsl_tablecode where cdr.ownerid = and cdr.FSL_TableCode = and cdr.cdr_recordid =