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='Nylanderia' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Nylanderia' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=830 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=849 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=854 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=864 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=876 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=877 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=900 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=901 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=911 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1679 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1789 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1790 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2091 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2092 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2093 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2095 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2096 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2097 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2101 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2103 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2111 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2112 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2327 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2328 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2333 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2334 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2335 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2336 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2337 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2338 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2339 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2340 SELECT genus FROM register WHERE register_no IN (5347,56746,72993,11040,47659,45462,19752,27509,99530,7788) AND species REGEXP '^[a-z]*$'
