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=2308 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2308SELECT 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=2308 ORDER BY register_no ASCSELECT 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='Neoneura' AND (junior_species='bilinearis' OR junior_species='bilinearis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoneura' AND (species='bilinearis' OR species='bilinearis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoneura' AND (species='bilinearis' OR species='bilinearis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoneura' AND (junior_species='bilinearis' OR junior_species='bilinearis')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='Neoneura' AND (species='bilinearis' OR species='bilinearis') 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='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='Acanthagrion' AND (junior_species='cuyabae' OR junior_species='cuyabae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthagrion' AND (species='cuyabae' OR species='cuyabae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthagrion' AND (species='cuyabae' OR species='cuyabae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthagrion' AND (junior_species='cuyabae' OR junior_species='cuyabae')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='cuyabae' OR species='cuyabae') 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='indicatrix' OR junior_species='indicatrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='indicatrix' OR species='indicatrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='indicatrix' OR species='indicatrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='indicatrix' OR junior_species='indicatrix')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='indicatrix' OR species='indicatrix') 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='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='Calvertagrion' 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='Calvertagrion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calvertagrion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calvertagrion' 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='Calvertagrion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telebasis' AND (junior_species='griffinii' OR junior_species='griffini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telebasis' AND (species='griffinii' OR species='griffini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telebasis' AND (species='griffinii' OR species='griffini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telebasis' AND (junior_species='griffinii' OR junior_species='griffini')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='Telebasis' AND (species='griffinii' OR species='griffini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dythemis' AND (junior_species='multipunctata' OR junior_species='multipunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dythemis' AND (species='multipunctata' OR species='multipunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dythemis' AND (species='multipunctata' OR species='multipunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dythemis' AND (junior_species='multipunctata' OR junior_species='multipunctata')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='Dythemis' AND (species='multipunctata' OR species='multipunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='basalis' OR junior_species='basalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='basalis' OR species='basalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='basalis' OR species='basalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='basalis' OR junior_species='basalis')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='basalis' OR species='basalis') 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='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='Erythemis' AND (junior_species='peruviana' OR junior_species='peruviana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythemis' AND (species='peruviana' OR species='peruviana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythemis' AND (species='peruviana' OR species='peruviana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='peruviana' OR junior_species='peruviana')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='peruviana' OR species='peruviana') 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='Gynothemis' AND (junior_species='pumila' OR junior_species='pumila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gynothemis' AND (species='pumila' OR species='pumila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gynothemis' AND (species='pumila' OR species='pumila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gynothemis' AND (junior_species='pumila' OR junior_species='pumila')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='Gynothemis' AND (species='pumila' OR species='pumila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoclada' 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='Oligoclada' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligoclada' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoclada' 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='Oligoclada' 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='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='Perithemis' AND (junior_species='lais' OR junior_species='lais')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perithemis' AND (species='lais' OR species='lais') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perithemis' AND (species='lais' OR species='lais')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perithemis' AND (junior_species='lais' OR junior_species='lais')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='Perithemis' AND (species='lais' OR species='lais') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perithemis' AND (junior_species='mooma' OR junior_species='mooma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perithemis' AND (species='mooma' OR species='mooma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perithemis' AND (species='mooma' OR species='mooma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perithemis' AND (junior_species='mooma' OR junior_species='mooma')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='Perithemis' AND (species='mooma' OR species='mooma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tholymis' AND (junior_species='citrina' OR junior_species='citrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tholymis' AND (species='citrina' OR species='citrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tholymis' AND (species='citrina' OR species='citrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tholymis' AND (junior_species='citrina' OR junior_species='citrina')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='Tholymis' AND (species='citrina' OR species='citrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenithoptera' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zenithoptera' AND (species='fasciata' OR species='fasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zenithoptera' AND (species='fasciata' OR species='fasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenithoptera' AND (junior_species='fasciata' OR junior_species='fasciata')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='fasciata' OR species='fasciata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2308 The Ecological Register: Manaus (intermediate)
Manaus (intermediate)
Basic information
Sample name: Manaus (intermediate)

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° 4' S, 60° 0' W
Coordinate basis: estimated from map

Geography comments: eight sites "in the municipality of Manaus"

•
Environment
Habitat: tropical/subtropical upland river

Protection: unprotected

Substrate: water edge

MAP: 2300.0

Habitat comments: "in peri-urban areas such as 'sĂ­tios' (small plots of non-urban land that are often owned by urban residents for weekend recreation)... 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"

Methods
Life forms: odonates

Sites: 8

Sampling methods: line transect,other nets

Sample size: 298 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: 2308

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-21 09:35:32

Modified: 2020-01-14 07:37:19

Abundance distribution
31 species
9 singletons
total count 298
extrapolated richness: 53.7
Fisher's α: 8.702
geometric series k: 0.8684
Hurlbert's PIE: 0.8964
Shannon's H: 2.7154
Good's u: 0.9699
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Hetaerina amazonica13
Hetaerina moribunda12
Hetaerina sanguinea21
Neoneura bilinearis9
Phasmoneura exigua5
Acanthagrion phallicorne10
Acanthagrion cuyabae1
Argia bicellulata25
Argia indicatrix3
Argia sp. 144
Argia sp. 23
Argia sp. 35
Argia sp. 47
Argia sp. 51
Inpabasis rosea1
Calvertagrion sp.1
said to be new
Telebasis griffinii5
Dythemis multipunctata10
Erythrodiplax basalis69
Erythrodiplax fusca11
Erythrodiplax lativittata1
Erythrodiplax umbrata1
Erythemis peruviana1
Erythemis vesiculosa5
Gynothemis pumila2
Oligoclada sp.1
Orthemis discolor2
Perithemis lais2
Perithemis mooma22
Tholymis citrina1
Zenithoptera fasciata4