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='Trithemis' GROUP BY t.sample_no SELECT life_form FROM register WHERE genus='Trithemis' LIMIT 1 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1558 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1561 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1564 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1565 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1574 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1575 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1580 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1581 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1593 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1596 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1598 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1599 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1603 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1615 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1616 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1619 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1623 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1647 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1650 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1652 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1653 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1654 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1658 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1659 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1726 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2310 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3161 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3162 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3165 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3166 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3167 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3168 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3169 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3176 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3178 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3180 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3183 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3185 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3186 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3188 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3195 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3196 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3201 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3202 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3203 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3210 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3212 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3214 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3216 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3218 SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3220 SELECT genus FROM register WHERE register_no IN (48551,85349,3626,80441,363,97050,63936,54576,91146,49098) AND species REGEXP '^[a-z]*$'