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='Orthotomus' AND species='sutorius' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Orthotomus' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1044 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1059 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1064 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1084 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1085 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1138 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1157 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1158 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1227 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1312 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1368 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1460 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2927 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2928 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2929 SELECT genus FROM register WHERE register_no IN (16538,76559,61079,48713,69893,75903,19061,74376,98249,63350) AND species REGEXP '^[a-z]*$'
