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='Copsychus' AND species='malabaricus' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Copsychus' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1043 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1044 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=1149 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1157 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=1522 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1667 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1668 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1901 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2924 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2933 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3595 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3596 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3597 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3710 SELECT genus FROM register WHERE register_no IN (56135,15305,41659,78595,72306,80097,83303,9676,27853,30444) AND species REGEXP '^[a-z]*$'
