| 0.0012 |
SELECT `m_Species`.*
FROM (`m_Species`)
WHERE `m_Species`.`Id` = '1439'
|
| 0.0011 |
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=168
|
| 0.0091 |
SELECT Id
FROM m_Species
WHERE Basionym_Id=Id
AND AcceptedName_Id=1439
ORDER BY IF(Id=1439, 1, 0) DESC,
IF(SynonymyUncertain, 1, 0) ASC,
IF(Invalid, 1, 0) ASC,
YEAR ASC
|
| 0.0053 |
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 = 1439
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.0050 |
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 = 12566
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.0049 |
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 = 634
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.0049 |
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 = 9469
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 = 1439
|
| 0.0017 |
SELECT Species_Id,AcceptedName_Id,Literature_Id,Ref,`as` AS accas
FROM m_qryAcceptedRef m
WHERE Species_Id=1439;
|
| 0.0237 |
SELECT Species_Id,
AcceptedName_Id,
Literature_Id,
Ref,
`As` AS repas,
Date
FROM m_qryReports WHERE AcceptedName_Id = 1439
ORDER BY Date DESC
|
| 0.0022 |
SELECT count(*) as number
FROM m_qryReports
WHERE AcceptedName_Id = 1439
|
| 0.0020 |
SELECT txtDistribution
FROM m_Distribution
WHERE Species_Id=1439
|
| 0.0006 |
SELECT txtDistribution
FROM m_Distribution
WHERE Species_Id=1439
|
| 0.0006 |
SELECT Id,Species_Id,imgname FROM m_imgs WHERE Species_Id=1439
|
| 0.0213 |
SELECT DISTINCT m_AusMossMaps_names.AusMossId
FROM m_AusMossMaps_names
JOIN m_Species
ON m_AusMossMaps_names.AusMossId=m_Species.Id
WHERE AusMossId=1439
|
