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]*$'
Trithemis (odonate): 51 samples
Standardised estimates are based on the geometric series index (Kerr and Alroy 2023; Carter and Alroy 2024).