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='Rupicapra' AND species='rupicapra' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Rupicapra' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1962 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1971 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3250 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3277 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3366 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3382 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3384 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3386 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3387 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3391 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3435 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3436 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3931 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3932 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3933 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3934 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4103 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4104 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4108 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4109 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4111 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4112 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4118 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4378 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4384 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4385 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4387 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4388 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4389 SELECT genus FROM register WHERE register_no IN (89003,33099,11821,52643,48447,46624,7780,49843,14825,99833) AND species REGEXP '^[a-z]*$'