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.Name#) AND (dbo.RelNameQualifier.RelNameQualifierId = 2)

Edit Homonym
#OneBasHomHybParents.FullNameCache#

Rank: #OneBasHomHybParents.Rank#
Suprageneric name:
Genus name: checked onClick="SetHiddenMonomHyb()"> (gen. hybrid) value="on" value = "off" >
Unnamed name phrase:
Cultivar name:
Cultivar group name:
Genus name: checked onClick="SetHiddenMonomHyb()"> (gen. hybrid) value="on" value = "off" >
Infrageneric epithet: checked onClick="SetHiddenBinomHyb()"> (genSubdi. hybrid) value="on" value = "off" >
Unnamed name phrase:
Cultivar name:
Cultivar group name:
Genus name: checked onClick="SetHiddenMonomHyb()"> (gen. hybrid) value="on" value = "off" >
Specific epithet: checked onClick="SetHiddenBinomHyb()"> (sp. hybrid) value="on" value = "off" >
Unnamed name phrase:
Cultivar name:
Cultivar group name:
Genus name: checked onClick="SetHiddenMonomHyb()"> (gen. hybrid) value="on" value = "off" >
Specific epithet: checked onClick="SetHiddenBinomHyb()"> (sp. hybrid) value="on" value = "off" >
Unnamed name phrase:
Cultivar name:
Cultivar group name:
Genus name: checked onClick="SetHiddenMonomHyb()"> (gen. hybrid) value="on" value = "off" >
Specific epithet: checked onClick="SetHiddenBinomHyb()"> (sp. hybrid) value="on" value = "off" >
Infraspecific epithet: checked onClick="SetHiddenTrinomHyb()"> (infsp. hybrid) value="on" value = "off" >
Unnamed name phrase:
Cultivar name:
Cultivar group name:
Loading ...     Basionym "ex" authors:
Edit
Loading ... Basionym authors:
Year: Edit
Loading ...     "Ex" authors:
Edit
Loading ... Authors:
Year: Edit
Hide "ex" authors  
New author team  
Notes(name)
Caution: This name was originally entered with rapid data entry option.
If you want to substitute it with the atomised data check the box checked onClick="SetHiddenNoPreliminary()"> value="on" value = "off" >
(otherwise atomised data will only be added to the original name)