SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT 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 WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND time_interval IS NULL AND (life_forms LIKE '%ground beetles%') GROUP BY t.sample_noSELECT estimate FROM estimates WHERE sample_no=270 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=271 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=272 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=273 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=289 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=290 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=658 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=673 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=970 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1535 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1536 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1537 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1538 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1539 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1540 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1541 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1542 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1543 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1544 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1545 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1546 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1547 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1548 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1549 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1550 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1551 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1552 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1553 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1554 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1555 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1556 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1709 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1710 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1711 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1712 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1713 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1714 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1715 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1716 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1717 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1718 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1722 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=1787 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=2238 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=2239 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=2240 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=2241 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=2264 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=2991 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=3015 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=3106 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=3107 AND form='ground beetles'SELECT estimate FROM estimates WHERE sample_no=3108 AND form='ground beetles'
The Ecological Register: Ground Beetles
