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 t.sample_no=3192 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3192SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2982SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3192 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestes' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestes' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='pictus' OR junior_species='pictus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lestes' AND (species='pictus' OR species='pictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='tricolor' OR junior_species='tricolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestes' AND (species='tricolor' OR species='tricolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestes' AND (species='tricolor' OR species='tricolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='tricolor' OR junior_species='tricolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lestes' AND (species='tricolor' OR species='tricolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' AND (junior_species='aurantiacum' OR junior_species='aurantiacum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteragrion' AND (species='aurantiacum' OR species='aurantiacum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteragrion' AND (species='aurantiacum' OR species='aurantiacum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' AND (junior_species='aurantiacum' OR junior_species='aurantiacum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteragrion' AND (species='aurantiacum' OR species='aurantiacum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanallagma' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanallagma' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanallagma' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanallagma' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyanallagma' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='capreolus' OR junior_species='capreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='capreolus' OR species='capreolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='capreolus' OR junior_species='capreolus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ischnura' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forcepsioneura' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forcepsioneura' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forcepsioneura' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forcepsioneura' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forcepsioneura' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idioneura' AND (junior_species='celioi' OR junior_species='celioii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idioneura' AND (species='celioi' OR species='celioii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idioneura' AND (species='celioi' OR species='celioii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idioneura' AND (junior_species='celioi' OR junior_species='celioii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Idioneura' AND (species='celioi' OR species='celioii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idoneura' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idoneura' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idoneura' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idoneura' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Idoneura' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptagrion' AND (junior_species='macrurum' OR junior_species='macrurum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptagrion' AND (species='macrurum' OR species='macrurum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptagrion' AND (species='macrurum' OR species='macrurum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptagrion' AND (junior_species='macrurum' OR junior_species='macrurum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptagrion' AND (species='macrurum' OR species='macrurum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptagrion' AND (junior_species='perlongum' OR junior_species='perlongum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptagrion' AND (species='perlongum' OR species='perlongum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptagrion' AND (species='perlongum' OR species='perlongum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptagrion' AND (junior_species='perlongum' OR junior_species='perlongum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptagrion' AND (species='perlongum' OR species='perlongum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecistogaster' AND (junior_species='amalia' OR junior_species='amalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mecistogaster' AND (species='amalia' OR species='amalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mecistogaster' AND (species='amalia' OR species='amalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecistogaster' AND (junior_species='amalia' OR junior_species='amalia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mecistogaster' AND (species='amalia' OR species='amalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castoraeschna' AND (junior_species='castor' OR junior_species='castor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castoraeschna' AND (species='castor' OR species='castor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castoraeschna' AND (species='castor' OR species='castor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castoraeschna' AND (junior_species='castor' OR junior_species='castor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Castoraeschna' AND (species='castor' OR species='castor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryphaeschna' AND (junior_species='perrensi' OR junior_species='perrensii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coryphaeschna' AND (species='perrensi' OR species='perrensii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coryphaeschna' AND (species='perrensi' OR species='perrensii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryphaeschna' AND (junior_species='perrensi' OR junior_species='perrensii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coryphaeschna' AND (species='perrensi' OR species='perrensii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staurophlebia' AND (junior_species='reticulata' OR junior_species='reticulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Staurophlebia' AND (species='reticulata' OR species='reticulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Staurophlebia' AND (species='reticulata' OR species='reticulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staurophlebia' AND (junior_species='reticulata' OR junior_species='reticulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Staurophlebia' AND (species='reticulata' OR species='reticulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllocycla' AND (junior_species='pallida' OR junior_species='pallida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllocycla' AND (species='pallida' OR species='pallida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllocycla' AND (species='pallida' OR species='pallida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllocycla' AND (junior_species='pallida' OR junior_species='pallida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phyllocycla' AND (species='pallida' OR species='pallida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lauromacromia' AND (junior_species='picinguaba' OR junior_species='picinguaba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lauromacromia' AND (species='picinguaba' OR species='picinguaba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lauromacromia' AND (species='picinguaba' OR species='picinguaba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lauromacromia' AND (junior_species='picinguaba' OR junior_species='picinguaba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lauromacromia' AND (species='picinguaba' OR species='picinguaba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Navicordulia' AND (junior_species='mielkei' OR junior_species='mielkeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Navicordulia' AND (species='mielkei' OR species='mielkeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Navicordulia' AND (species='mielkei' OR species='mielkeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Navicordulia' AND (junior_species='mielkei' OR junior_species='mielkeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Navicordulia' AND (species='mielkei' OR species='mielkeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schizocordulia' AND (junior_species='rustica' OR junior_species='rustica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schizocordulia' AND (species='rustica' OR species='rustica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schizocordulia' AND (species='rustica' OR species='rustica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schizocordulia' AND (junior_species='rustica' OR junior_species='rustica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Schizocordulia' AND (species='rustica' OR species='rustica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='vesiculosa' OR junior_species='vesiculosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythemis' AND (species='vesiculosa' OR species='vesiculosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythemis' AND (species='vesiculosa' OR species='vesiculosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='vesiculosa' OR junior_species='vesiculosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythemis' AND (species='vesiculosa' OR species='vesiculosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='anomala' OR junior_species='anomala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='anomala' OR species='anomala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='anomala' OR species='anomala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='anomala' OR junior_species='anomala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrodiplax' AND (species='anomala' OR species='anomala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='castanea' OR junior_species='castanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='castanea' OR species='castanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='castanea' OR species='castanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='castanea' OR junior_species='castanea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrodiplax' AND (species='castanea' OR species='castanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='fusca' OR junior_species='fusca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrodiplax' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='umbrata' OR junior_species='umbrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='umbrata' OR species='umbrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='umbrata' OR species='umbrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='umbrata' OR junior_species='umbrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrodiplax' AND (species='umbrata' OR species='umbrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrathyria' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrathyria' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrathyria' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrathyria' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micrathyria' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='cultriformis' OR junior_species='cultriformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthemis' AND (species='cultriformis' OR species='cultriformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthemis' AND (species='cultriformis' OR species='cultriformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='cultriformis' OR junior_species='cultriformis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthemis' AND (species='cultriformis' OR species='cultriformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='discolor' OR junior_species='discolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthemis' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthemis' AND (species='discolor' OR species='discolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='discolor' OR junior_species='discolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthemis' AND (species='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantala' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantala' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pantala' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='binotata' OR junior_species='binotata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tramea' AND (species='binotata' OR species='binotata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tramea' AND (species='binotata' OR species='binotata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='binotata' OR junior_species='binotata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tramea' AND (species='binotata' OR species='binotata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenithoptera' AND (junior_species='lanei' OR junior_species='laneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zenithoptera' AND (species='lanei' OR species='laneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zenithoptera' AND (species='lanei' OR species='laneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenithoptera' AND (junior_species='lanei' OR junior_species='laneii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zenithoptera' AND (species='lanei' OR species='laneii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3192 The Ecological Register: Nùcleo Perequê (adults)
Nùcleo Perequê (adults)
Basic information
Sample name: Nùcleo Perequê (adults)

Sample aka: Parque Estadual da Ilha do Cardoso

Reference: A. P. Pinto. 2018. First report on the dragonflies from Parque Estadual da Ilha do Cardoso, state of São Paulo, Brazil, with notes on the morphology and behavior of Lauromacromia picinguaba (Odonata: Corduliidae s.l.). Studies on Neotropical Fauna and Environment -:1-13 [ER 2982]
Geography
Country: Brazil

State: Säo Paulo


Coordinate: -25.13° S, -47.96° W
Coordinate basis: based on nearby landmark

Geography comments: from "Parque Estadual da Ilha do Cardoso (PEIC), a conservation unit created by state government decree"
coordinate based on Parque Estadual da Ilha do Cardoso

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

Habitat comments: "a protected area of Atlantic Forest"

Methods
Life forms: odonates

Sites: 8

Sampling methods: no design,other nets

Sample size: 140 individuals

Years: 2011

Days: 4

Sampling comments: "A short sampling effort of four days during 19–22 October 2011 was conducted at eight collecting sites... along a 5 km transect... Adults were collected using regular aerial nets, and larvae were collected using mesh metal sieves"

Metadata
Sample number: 3192

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-01-08 19:53:06

Modified: 2019-01-08 09:12:28

Abundance distribution
29 species
9 singletons
total count 140
extrapolated richness: 56.4
Fisher's α: 11.111
geometric series k: 0.8985
Hurlbert's PIE: 0.9305
Shannon's H: 2.9452
Good's u: 0.9362
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Lestes pictus3
Lestes tricolor2
Heteragrion aurantiacum6
Cyanallagma sp.9
said to be new
Ischnura capreolus1
Forcepsioneura sp.3
said to be new
Idioneura celioi1
Idoneura sp.20
said to be new
Leptagrion macrurum8
Leptagrion perlongum8
Mecistogaster amalia1
Castoraeschna castor1
Coryphaeschna perrensi1
Staurophlebia reticulata reticulata1
Phyllocycla pallida1
Lauromacromia picinguaba14
Navicordulia mielkei3
Schizocordulia rustica2
Erythemis vesiculosa1
Erythrodiplax anomala12
Erythrodiplax castanea2
Erythrodiplax fusca7
Erythrodiplax umbrata5
Micrathyria sp. A14
Orthemis cultriformis2
Orthemis discolor2
Pantala flavescens1
Tramea binotata5
Zenithoptera lanei4