// set relnamequalifier constants _IS_BASIONYM_FOR = 1; _IS_LATER_HOMONYM_OF = 2; _IS_REPLACED_SYNONYM_FOR = 3; _IS_TYPE_OF = 6; _IS_FIRST_PARENT_OF = 9; _IS_SECOND_PARENT_OF = 10; _IS_ORTHOGRAPHIC_VARIANT_OF = 16; _IS_LECTOTYPE_OF = 61; SELECT dbo.RelName.NameFk2, dbo.Name.FullNameCache, dbo.Rank.RankId, dbo.Rank.Rank, dbo.RelNameQualifier.RelNameQualifierId, dbo.RelNameQualifier.RelNameQualifier, dbo.RefDetail.FullNomRefCache, dbo.Name.Genus, dbo.Name.GenusSubdivisionEpi, dbo.Name.SpeciesEpi, dbo.Name.InfraSpeciesEpi, dbo.Name.HybridFormulaFlag, dbo.Name.MonomHybFlag, dbo.Name.BinomHybFlag, dbo.Name.TrinomHybFlag, dbo.Name.CultivarName, dbo.Name.CultivarGroupName, dbo.Name.AuthorTeamFk, dbo.RefDetail.PreliminaryFlag AS DetailPreliminaryFlag FROM dbo.Name INNER JOIN dbo.RelName ON dbo.Name.NameId = dbo.RelName.NameFk2 INNER JOIN dbo.RelNameQualifier ON dbo.RelName.RelNameQualifierFk = dbo.RelNameQualifier.RelNameQualifierId INNER JOIN dbo.Rank ON dbo.Name.RankFk = dbo.Rank.RankId LEFT OUTER JOIN dbo.RefDetail ON dbo.Name.NomRefDetailFk = dbo.RefDetail.RefDetailId AND dbo.Name.NomRefFk = dbo.RefDetail.RefFk WHERE (dbo.RelName.NameFk2 = #URL.Name2#) AND (dbo.RelNameQualifier.RelNameQualifierId = #_IS_LATER_HOMONYM_OF#) SELECT Name.* FROM Name, RelName WHERE (NameFk2 = #URL.Name2#) AND(RelNameQualifierFk = #_IS_LATER_HOMONYM_OF#) AND(NameFk1 = NameId) SELECT RefCache, FullRefCache, RelName.Notes, RefId FROM RelName LEFT OUTER JOIN Reference ON RelName.RefFk = Reference.RefId LEFT OUTER JOIN RefDetail ON RelName.RefDetailFk = RefDetail.RefDetailId WHERE RelName.RelNameId = #URL.RelNameId# // set some parameters if (OneBasHomHybParents.RankId lt session.MinimumEditableRank) isRankAboveFamily = true; else isRankAboveFamily = false; if (Nomen.IsEditable) isNameEditable = true; else isNameEditable = false; if (session.isEditSharedObjectsAllowed OR (isNameEditable AND NOT isRankAboveFamily)) isEditAllowed = true; else isEditAllowed = false; if (RelNameQualifier.RelNameQualifierId eq _IS_TYPE_OF or RelNameQualifier.RelNameQualifierId eq _IS_LECTOTYPE_OF) isTypeRel = true; else isTypeRel = false; SELECT StatusId, Status FROM PTaxon, Status WHERE StatusFk = StatusId AND PTNameFk = #OneHomBasAcc.NameId# AND PTRefFk = #URL.Ref# >#TypeReference.RefCache# class="addlink">add reference for type relationship

Name:

#OneBasHomHybParents.FullNameCache#