SELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t,register t2 WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=t2.sample_no AND genus='Henicorhina' AND species='leucosticta' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Henicorhina' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1025 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1047 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1048 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1054 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1155 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1383 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1384 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1755 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1765 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1774 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1775 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1777 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1779 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2935 SELECT genus FROM register WHERE register_no IN (10452,95333,15996,29845,74683,43035,22554,14213,85959,75814) AND species REGEXP '^[a-z]*$'
