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='Chrysemys' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Chrysemys' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=315 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=316 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=318 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=319 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=320 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=321 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=361 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=384 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1023 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3430 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3437 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3438 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3439 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3451 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3452 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3461 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3463 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3464 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3479 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3483 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3496 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3504 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3507 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3517 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3521 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3524 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3525 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3546 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4637 SELECT genus FROM register WHERE register_no IN (56642,24070,95276,76560,89877,20701,61906,10517,82999,85768) AND species REGEXP '^[a-z]*$'
