| 0.0011 |
SELECT `m_Species`.*
FROM (`m_Species`)
WHERE `m_Species`.`Id` = '502'
|
| 0.0010 |
SELECT `Class`,`Subclass`,`Superorder`,`Order`,`Suborder`,`Family`
FROM m_Classification c
JOIN m_Genera g ON c.Suprageneric_Id=g.Suprageneric_Id
WHERE g.ID=139
|
| 0.0097 |
SELECT Id
FROM m_Species
WHERE Basionym_Id=Id
AND AcceptedName_Id=502
ORDER BY IF(Id=502, 1, 0) DESC,
IF(SynonymyUncertain, 1, 0) ASC,
IF(Invalid, 1, 0) ASC,
YEAR ASC
|
| 0.0057 |
SELECT s.Id, g.Genus, s.Epithet, s.Sspvar, s.Infrasp,
s.Sspvar2, s.Infrasp2, s.Author, s.Year, s.NomenclaturalNote, s.Accepted,
s.Basionym_Id, s.SynonymyUncertain, s.Invalid
FROM m_Species s
JOIN m_Genera g ON s.Genera_ID=g.Id
WHERE s.Basionym_Id = 502
ORDER BY IF(s.Id=s.Basionym_Id, 1, 0) DESC,
IF(s.SynonymyUncertain, 1, 0) ASC,
IF(s.Invalid, 1, 0) ASC,
YEAR ASC
|
| 0.0037 |
SELECT count(*) as number
FROM m_Species
WHERE AcceptedName_Id = 502
|
| 0.0018 |
SELECT Species_Id,AcceptedName_Id,Literature_Id,Ref,`as` AS accas
FROM m_qryAcceptedRef m
WHERE Species_Id=502;
|
| 0.0252 |
SELECT Species_Id,
AcceptedName_Id,
Literature_Id,
Ref,
`As` AS repas,
Date
FROM m_qryReports WHERE AcceptedName_Id = 502
ORDER BY Date DESC
|
| 0.0022 |
SELECT count(*) as number
FROM m_qryReports
WHERE AcceptedName_Id = 502
|
| 0.0020 |
SELECT txtDistribution
FROM m_Distribution
WHERE Species_Id=502
|
| 0.0006 |
SELECT txtDistribution
FROM m_Distribution
WHERE Species_Id=502
|
| 0.0006 |
SELECT Id,Species_Id,imgname FROM m_imgs WHERE Species_Id=502
|
| 0.0214 |
SELECT DISTINCT m_AusMossMaps_names.AusMossId
FROM m_AusMossMaps_names
JOIN m_Species
ON m_AusMossMaps_names.AusMossId=m_Species.Id
WHERE AusMossId=502
|
