| 0.0013 |
SELECT `m_Species`.* FROM (`m_Species`) WHERE `m_Species`.`Id` = '1427'
|
| 0.0012 |
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=301
|
| 0.0107 |
SELECT Id FROM m_Species WHERE Basionym_Id=Id AND AcceptedName_Id=1427 ORDER BY IF(Id=84, 1, 0) DESC, IF(SynonymyUncertain, 1, 0) ASC, IF(Invalid, 1, 0) ASC, YEAR ASC
|
| 0.0052 |
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 = 84 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.0048 |
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 = 9640 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.0047 |
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 = 9694 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.0048 |
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 = 9697 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.0048 |
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 = 9699 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.0048 |
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 = 9698 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.0047 |
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 = 11557 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.0048 |
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 = 11552 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.0048 |
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 = 9645 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.0048 |
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 = 9683 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.0047 |
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 = 9531 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.0047 |
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 = 9528 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.0047 |
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 = 9627 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.0047 |
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 = 9539 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.0047 |
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 = 9565 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.0048 |
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 = 9612 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.0048 |
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 = 9597 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.0048 |
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 = 11583 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.0047 |
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 = 11584 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.0048 |
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 = 9613 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 = 9560 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.0047 |
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 = 9617 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.0047 |
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 = 9589 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.0048 |
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 = 9653 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 = 1427
|
| 0.0017 |
SELECT Species_Id,AcceptedName_Id,Literature_Id,Ref,`as` AS accas FROM m_qryAcceptedRef m WHERE Species_Id=1427;
|
| 0.0242 |
SELECT Species_Id, AcceptedName_Id, Literature_Id, Ref, `As` AS repas, Date FROM m_qryReports WHERE AcceptedName_Id = 1427 ORDER BY Date DESC
|
| 0.0021 |
SELECT count(*) as number FROM m_qryReports WHERE AcceptedName_Id = 1427
|
| 0.0027 |
SELECT txtDistribution FROM m_Distribution WHERE Species_Id=1427
|
| 0.0005 |
SELECT txtDistribution FROM m_Distribution WHERE Species_Id=1427
|
| 0.0007 |
SELECT Id,Species_Id,imgname FROM m_imgs WHERE Species_Id=1427
|
| 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=1427
|