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='Euryoryzomys' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Euryoryzomys' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1186 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1187 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1190 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1193 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1202 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1203 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1219 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1220 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1221 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1526 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1661 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1662 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1810 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1816 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1825 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1826 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1832 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1845 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1933 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2827 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2829 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2831 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2878 SELECT genus FROM register WHERE register_no IN (24274,37165,7086,15025,64144,22486,31370,94724,97664,24265) AND species REGEXP '^[a-z]*$'
