SELECT `m_Species`.*FROM (`m_Species`)WHERE `m_Species`.`Id` = '10685'
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=77
SELECT count(*) as number FROM m_Species WHERE AcceptedName_Id = 10685
SELECT Species_Id,AcceptedName_Id,Literature_Id,Ref,`as` AS accas FROM m_qryAcceptedRef m WHERE Species_Id=10685;
SELECT Species_Id, AcceptedName_Id, Literature_Id, Ref, `As` AS repas, Date FROM m_qryReports WHERE AcceptedName_Id = 10685 ORDER BY Date DESC
SELECT count(*) as number FROM m_qryReports WHERE AcceptedName_Id = 10685
SELECT txtDistribution FROM m_Distribution WHERE Species_Id=10685
SELECT Id,Species_Id,imgname FROM m_imgs WHERE Species_Id=10685
SELECT DISTINCT m_AusMossMaps_names.AusMossId FROM m_AusMossMaps_names JOIN m_Species ON m_AusMossMaps_names.AusMossId=m_Species.Id WHERE AusMossId=10685