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='Protemnodon' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Protemnodon' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3357 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3849 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3850 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3851 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3852 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3853 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3854 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3868 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3879 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3880 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3949 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3950 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3951 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3952 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3955 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3994 SELECT genus FROM register WHERE register_no IN (81471,71753,60146,24775,9550,13126,81969,70307,79291,17378) AND species REGEXP '^[a-z]*$'
