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='Papilio' AND species='memnon' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Papilio' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=288 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=980 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=990 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2117 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2303 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2305 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2329 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2330 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2331 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2332 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3111 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3112 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3113 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3114 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3120 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3157 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3253 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3600 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3604 SELECT genus FROM register WHERE register_no IN (3406,21373,27635,90178,53079,86743,13564,88651,9139,8263) AND species REGEXP '^[a-z]*$'
