EDIT

Useful scripts

DECLARE @authorId as int;
Set @authorId = 3395
;

SELECT *
FROM Name n INNER JOIN dbo.v_cdm_exp_namesAll v ON n.NameId = v.NameId
WHERE (1=0)
   OR n.AuthorTeamFk IN (@authorId) OR n.ExAuthorTeamFk IN (@authorId) OR n.BasAuthorTeamFk IN (@authorId) OR n.ExBasAuthorTeamFk IN (@authorId)
   OR n.NomRefFk IN (SELECT r.RefId
FROM Reference r INNER JOIN v_cdm_exp_refAll v ON v.RefId = r.RefId  
WHERE r.NomAuthorTeamFk  IN (@authorId))
   ;
SELECT *
FROM Reference r INNER JOIN v_cdm_exp_refAll v ON v.RefId = r.RefId  
WHERE r.NomAuthorTeamFk  IN (@authorId);

SELECT *
FROM AuthorTeam at
WHERE at.AuthorTeamId IN (@authorId);

SELECT *
FROM AuthorTeamSequence seq
WHERE seq.AuthorTeamFk IN (@authorId)

DECLARE @id int;

SET @id = 3453;  -- 697, 2168, 3453
--113977, 88135, 88204 
SELECT n.*
FROM Name n INNER JOIN dbo.v_cdm_exp_namesAll v ON n.NameId = v.NameId
WHERE n.NomRefFk IN (@id)

SELECT *
FROM v_cdm_exp_refSourceNumbers
WHERE RefId IN (@id);

SELECT *
FROM v_cdm_exp_refNomStatusRefs
WHERE RefId IN (@id);

SELECT pt.*
FROM PTaxon pt INNER JOIN dbo.v_cdm_exp_taxaAll v ON pt.RIdentifier = v.RIdentifier
WHERE pt.PTRefFk IN (@id) or pt.LastScrutinyFk IN (@id)

SELECT *
FROM v_cdm_exp_refLanguageRefs
WHERE RefId IN (@id);

SELECT *
FROM v_cdm_exp_refFactRefs
WHERE RefId IN (@id);

SELECT *
FROM v_cdm_exp_refInRefs
WHERE RefId IN (@id);