| 0.0010 |
SELECT `Id`, `Genus` as Name, `Author`, `Journal_book`, `Collation`, `Year`, `NomenclaturalNote_Genus` as NomenclaturalNote, `Annot`, `Genus_Acc`, `Suprageneric_Id` as Parent_Id, `Endemic`, `Dagger`, `Basionym`, `Type_kind`, `Type`, `Lectotypification` FROM (`m_Genera`) WHERE `Id` = '305'
|
| 0.0062 |
SELECT `m_Species`.`Id` as o_id, `m_Species`.`Genera_Id`, `m_Species`.`Genus` as o_genus, `m_Species`.`epithet` as o_epithet, `m_Species`.`Sspvar` as o_sspvar, `m_Species`.`infrasp` as o_infrasp, `m_Species`.`Sspvar2` as o_sspvar2, `m_Species`.`infrasp2` as o_infrasp2, `m_Species`.`Author` as o_author, `m_Species`.`NomenclaturalNote` as o_nomennote, `m_Species`.`AcceptedName_Id` as accid, `m_Species`.`Status_uncertain`, `m_Species`.`Occurrence_doubtful`, `m_Species`.`Excluded`, `m_Species`.`Excluded_from_genus`, `m_Species`.`Invalid`, `m_Species`.`Variety_only`, `m_Species`.`Accepted`, `m_Species`.`Status`, `newnames`.`Genus` as n_genus, `newnames`.`Id` as n_id, `newnames`.`epithet` as n_epithet, `newnames`.`Sspvar` as n_sspvar, `newnames`.`infrasp` as n_infrasp, `newnames`.`Sspvar2` as n_sspvar2, `newnames`.`infrasp2` as n_infrasp2, `newnames`.`Author` as n_author, `newnames`.`NomenclaturalNote` as n_nomennote FROM (`m_Species`) LEFT JOIN `m_Species` as newnames ON `m_Species`.`AcceptedName_Id` = `newnames`.`Id` WHERE `m_Species`.`Genera_Id` = '305' ORDER BY `m_Species`.`Genus`, `m_Species`.`epithet`, `m_Species`.`infrasp`, `m_Species`.`infrasp2`
|