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=2307 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2307SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2249SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2307 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcopteryx' AND (junior_species='scintillans' OR junior_species='scintillans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcopteryx' AND (species='scintillans' OR species='scintillans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcopteryx' AND (species='scintillans' OR species='scintillans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcopteryx' AND (junior_species='scintillans' OR junior_species='scintillans')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='Chalcopteryx' AND (species='scintillans' OR species='scintillans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='amazonica' OR junior_species='amazonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='amazonica' OR species='amazonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='amazonica' OR species='amazonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='amazonica' OR junior_species='amazonica')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='Hetaerina' AND (species='amazonica' OR species='amazonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='moribunda' OR junior_species='moribunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='moribunda' OR species='moribunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='moribunda' OR species='moribunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='moribunda' OR junior_species='moribunda')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='Hetaerina' AND (species='moribunda' OR species='moribunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='sanguinea' OR junior_species='sanguinea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='sanguinea' OR species='sanguinea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='sanguinea' OR species='sanguinea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='sanguinea' OR junior_species='sanguinea')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='Hetaerina' AND (species='sanguinea' OR species='sanguinea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mnesarete' AND (junior_species='astrape' OR junior_species='astrape')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mnesarete' AND (species='astrape' OR species='astrape') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mnesarete' AND (species='astrape' OR species='astrape')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mnesarete' AND (junior_species='astrape' OR junior_species='astrape')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='Mnesarete' AND (species='astrape' OR species='astrape') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicterias' AND (junior_species='atrosanguinea' OR junior_species='atrosanguinea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicterias' AND (species='atrosanguinea' OR species='atrosanguinea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicterias' AND (species='atrosanguinea' OR species='atrosanguinea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicterias' AND (junior_species='atrosanguinea' OR junior_species='atrosanguinea')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='Dicterias' AND (species='atrosanguinea' OR species='atrosanguinea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epipleoneura' AND (junior_species='manauensis' OR junior_species='manauensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epipleoneura' AND (species='manauensis' OR species='manauensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epipleoneura' AND (species='manauensis' OR species='manauensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epipleoneura' AND (junior_species='manauensis' OR junior_species='manauensis')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='Epipleoneura' AND (species='manauensis' OR species='manauensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiplioneura' AND (junior_species='capilliformis' OR junior_species='capilliformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiplioneura' AND (species='capilliformis' OR species='capilliformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiplioneura' AND (species='capilliformis' OR species='capilliformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiplioneura' AND (junior_species='capilliformis' OR junior_species='capilliformis')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='Epiplioneura' AND (species='capilliformis' OR species='capilliformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epipleoneura' AND (junior_species='haroldoi' OR junior_species='haroldoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epipleoneura' AND (species='haroldoi' OR species='haroldoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epipleoneura' AND (species='haroldoi' OR species='haroldoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epipleoneura' AND (junior_species='haroldoi' OR junior_species='haroldoii')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='Epipleoneura' AND (species='haroldoi' OR species='haroldoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epipotoneura' AND (junior_species='nehalennia' OR junior_species='nehalennia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epipotoneura' AND (species='nehalennia' OR species='nehalennia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epipotoneura' AND (species='nehalennia' OR species='nehalennia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epipotoneura' AND (junior_species='nehalennia' OR junior_species='nehalennia')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='Epipotoneura' AND (species='nehalennia' OR species='nehalennia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phasmoneura' AND (junior_species='exigua' OR junior_species='exigua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phasmoneura' AND (species='exigua' OR species='exigua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phasmoneura' AND (species='exigua' OR species='exigua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phasmoneura' AND (junior_species='exigua' OR junior_species='exigua')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='Phasmoneura' AND (species='exigua' OR species='exigua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psaironeura' AND (junior_species='bifurcata' OR junior_species='bifurcata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psaironeura' AND (species='bifurcata' OR species='bifurcata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psaironeura' AND (species='bifurcata' OR species='bifurcata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psaironeura' AND (junior_species='bifurcata' OR junior_species='bifurcata')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='Psaironeura' AND (species='bifurcata' OR species='bifurcata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psaironeura' AND (junior_species='tenuissima' OR junior_species='tenuissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psaironeura' AND (species='tenuissima' OR species='tenuissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psaironeura' AND (species='tenuissima' OR species='tenuissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psaironeura' AND (junior_species='tenuissima' OR junior_species='tenuissima')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='Psaironeura' AND (species='tenuissima' OR species='tenuissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthagrion' AND (junior_species='phallicorne' OR junior_species='phallicorne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthagrion' AND (species='phallicorne' OR species='phallicorne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthagrion' AND (species='phallicorne' OR species='phallicorne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthagrion' AND (junior_species='phallicorne' OR junior_species='phallicorne')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='Acanthagrion' AND (species='phallicorne' OR species='phallicorne') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='bicellulata' OR junior_species='bicellulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='bicellulata' OR species='bicellulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='bicellulata' OR species='bicellulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='bicellulata' OR junior_species='bicellulata')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='Argia' AND (species='bicellulata' OR species='bicellulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inpabasis' AND (junior_species='rosea' OR junior_species='rosea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inpabasis' AND (species='rosea' OR species='rosea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inpabasis' AND (species='rosea' OR species='rosea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inpabasis' AND (junior_species='rosea' OR junior_species='rosea')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='Inpabasis' AND (species='rosea' OR species='rosea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecistogaster' AND (junior_species='lineares' OR junior_species='lineares')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mecistogaster' AND (species='lineares' OR species='lineares') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mecistogaster' AND (species='lineares' OR species='lineares')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecistogaster' AND (junior_species='lineares' OR junior_species='lineares')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='lineares' OR species='lineares') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microstigma' AND (junior_species='maculatum' OR junior_species='maculatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microstigma' AND (species='maculatum' OR species='maculatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microstigma' AND (species='maculatum' OR species='maculatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microstigma' AND (junior_species='maculatum' OR junior_species='maculatum')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='Microstigma' AND (species='maculatum' OR species='maculatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' AND (junior_species='bariai' OR junior_species='bariaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteragrion' AND (species='bariai' OR species='bariaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteragrion' AND (species='bariai' OR species='bariaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' AND (junior_species='bariai' OR junior_species='bariaii')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='bariai' OR species='bariaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' AND (junior_species='icterops' OR junior_species='icterops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteragrion' AND (species='icterops' OR species='icterops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteragrion' AND (species='icterops' OR species='icterops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' AND (junior_species='icterops' OR junior_species='icterops')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='icterops' OR species='icterops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' 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='Heteragrion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteragrion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' 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='Heteragrion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' 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='Heteragrion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteragrion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteragrion' 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='Heteragrion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxystigma' AND (junior_species='petiolatum' OR junior_species='petiolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxystigma' AND (species='petiolatum' OR species='petiolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxystigma' AND (species='petiolatum' OR species='petiolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxystigma' AND (junior_species='petiolatum' OR junior_species='petiolatum')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='Oxystigma' AND (species='petiolatum' OR species='petiolatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxystigma' AND (junior_species='williansony' OR junior_species='williansony')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxystigma' AND (species='williansony' OR species='williansony') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxystigma' AND (species='williansony' OR species='williansony')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxystigma' AND (junior_species='williansony' OR junior_species='williansony')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='Oxystigma' AND (species='williansony' OR species='williansony') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perilestes' AND (junior_species='attenuatus' OR junior_species='attenuatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perilestes' AND (species='attenuatus' OR species='attenuatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perilestes' AND (species='attenuatus' OR species='attenuatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perilestes' AND (junior_species='attenuatus' OR junior_species='attenuatus')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='Perilestes' AND (species='attenuatus' OR species='attenuatus') 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='lativittata' OR junior_species='lativittata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='lativittata' OR species='lativittata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='lativittata' OR species='lativittata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='lativittata' OR junior_species='lativittata')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='lativittata' OR species='lativittata') 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='Fylgia' AND (junior_species='amazonica' OR junior_species='amazonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fylgia' AND (species='amazonica' OR species='amazonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fylgia' AND (species='amazonica' OR species='amazonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fylgia' AND (junior_species='amazonica' OR junior_species='amazonica')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='Fylgia' AND (species='amazonica' OR species='amazonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoclada' AND (junior_species='walkeri' OR junior_species='walkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligoclada' AND (species='walkeri' OR species='walkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligoclada' AND (species='walkeri' OR species='walkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoclada' AND (junior_species='walkeri' OR junior_species='walkerii')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='Oligoclada' AND (species='walkeri' OR species='walkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uracis' AND (junior_species='siemensi' OR junior_species='siemensii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uracis' AND (species='siemensi' OR species='siemensii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uracis' AND (species='siemensi' OR species='siemensii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uracis' AND (junior_species='siemensi' OR junior_species='siemensii')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='Uracis' AND (species='siemensi' OR species='siemensii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonophora' AND (junior_species='batesi' OR junior_species='batesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonophora' AND (species='batesi' OR species='batesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonophora' AND (species='batesi' OR species='batesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonophora' AND (junior_species='batesi' OR junior_species='batesii')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='Zonophora' AND (species='batesi' OR species='batesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gynacantha' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gynacantha' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gynacantha' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gynacantha' AND (junior_species='gracilis' OR junior_species='gracilis')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='Gynacantha' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gynacantha' 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='Gynacantha' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gynacantha' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gynacantha' 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='Gynacantha' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triacanthagyna' AND (junior_species='caribbea' OR junior_species='caribbea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triacanthagyna' AND (species='caribbea' OR species='caribbea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triacanthagyna' AND (species='caribbea' OR species='caribbea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triacanthagyna' AND (junior_species='caribbea' OR junior_species='caribbea')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='Triacanthagyna' AND (species='caribbea' OR species='caribbea') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2307 The Ecological Register: Manaus (preserved)
Manaus (preserved)
Basic information
Sample name: Manaus (preserved)

Reference: C. S. Monteiro-Júnior, L. Juen, and N. Hamada. 2014. Effects of urbanization on stream habitats and associated adult dragonfly and damselfly communities in central Brazilian Amazonia. Landscape and Urban Planning 127:28-40 [ER 2249]
Geography
Country: Brazil

State: Amazonas


Coordinate: 3° 1' S, 60° 1' W
Coordinate basis: estimated from map

Geography comments: "in the municipality of Manaus" with five of 11 sites in the Ducke Forest Reserve

•
Environment
Habitat: tropical/subtropical upland river

Substrate: water edge

MAP: 2300.0

Habitat comments: "well-preserved Amazon rainforest... The region’s climate is of the equatorial hot and humid Am type, according to the current Köppen climate classification... with two well-defined climatic seasons (a rainy season between November and June, and a dry season between July and October) and average annual rainfall ranging from 2200 to 2400mm... relatively undisturbed streams"

Methods
Life forms: odonates

Sites: 11

Sampling methods: line transect,other nets

Sample size: 337 individuals

Years: 2010, 2011

Seasons: dry,wet or monsoon

Sampling comments: "Samples were collected on the banks of each stream during two different periods... from November to December 2010 (rainy season) and June to July 2011 (dry season)... Each site was sampled twice for 90 min, on average, by two collectors... Adults were collected according to the protocol of De Marco (1998), which involves sweeping a set area (a 100 m stretch on each bank of the stream and divided into five segments of 20m) with an entomological hand-net"

Metadata
Sample number: 2307

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-21 09:33:20

Modified: 2016-10-21 04:48:14

Abundance distribution
39 species
15 singletons
total count 337
extrapolated richness: 85.1
Fisher's α: 11.406
geometric series k: 0.8861
Hurlbert's PIE: 0.8623
Shannon's H: 2.5834
Good's u: 0.9556
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Chalcopteryx scintillans36
Hetaerina amazonica25
Hetaerina moribunda54
Hetaerina sanguinea4
Mnesarete astrape1
Dicterias atrosanguinea6
Epipleoneura manauensis6
Epiplioneura capilliformis17
Epipleoneura haroldoi2
Epipotoneura nehalennia3
Phasmoneura exigua14
Psaironeura bifurcata1
Psaironeura tenuissima9
Acanthagrion phallicorne2
Argia bicellulata2
Argia sp. 12
Argia sp. 299
Argia sp. 41
Argia sp. 52
Inpabasis rosea4
Mecistogaster lineares1
Microstigma maculatum1
Heteragrion bariai1
Heteragrion icterops2
Heteragrion sp. 19
Heteragrion sp. 210
Oxystigma petiolatum1
Oxystigma williansony2
Perilestes attenuatus6
Erythrodiplax fusca1
Erythrodiplax lativittata1
Erythemis vesiculosa1
Fylgia amazonica1
Oligoclada walkeri4
Uracis siemensi1
Zonophora batesi2
Gynacantha gracilis1
Gynacantha sp.1
Triacanthagyna caribbea1