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=1583 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1583SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1073SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1583 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='dimidiata' OR junior_species='dimidiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calopteryx' AND (species='dimidiata' OR species='dimidiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calopteryx' AND (species='dimidiata' OR species='dimidiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='dimidiata' OR junior_species='dimidiata')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='Calopteryx' AND (species='dimidiata' OR species='dimidiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calopteryx' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calopteryx' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calopteryx' AND (junior_species='maculata' OR junior_species='maculata')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='Calopteryx' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='titia' OR junior_species='titia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='titia' OR species='titia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='titia' OR species='titia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='titia' OR junior_species='titia')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='titia' OR species='titia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='fumipennis' OR junior_species='fumipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='fumipennis' OR species='fumipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='fumipennis' OR species='fumipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='fumipennis' OR junior_species='fumipennis')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='fumipennis' OR species='fumipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='sedula' OR junior_species='sedula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='sedula' OR species='sedula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='sedula' OR species='sedula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='sedula' OR junior_species='sedula')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='sedula' OR species='sedula') 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='Aeshna' AND (junior_species='umbrosa' OR junior_species='umbrosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeshna' AND (species='umbrosa' OR species='umbrosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeshna' AND (species='umbrosa' OR species='umbrosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='umbrosa' OR junior_species='umbrosa')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='Aeshna' AND (species='umbrosa' OR species='umbrosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boyeria' AND (junior_species='grafiana' OR junior_species='grafiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boyeria' AND (species='grafiana' OR species='grafiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boyeria' AND (species='grafiana' OR species='grafiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boyeria' AND (junior_species='grafiana' OR junior_species='grafiana')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='Boyeria' AND (species='grafiana' OR species='grafiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boyeria' AND (junior_species='vinosa' OR junior_species='vinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boyeria' AND (species='vinosa' OR species='vinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boyeria' AND (species='vinosa' OR species='vinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boyeria' AND (junior_species='vinosa' OR junior_species='vinosa')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='Boyeria' AND (species='vinosa' OR species='vinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromogomphus' AND (junior_species='spinosus' OR junior_species='spinosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dromogomphus' AND (species='spinosus' OR species='spinosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dromogomphus' AND (species='spinosus' OR species='spinosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromogomphus' AND (junior_species='spinosus' OR junior_species='spinosus')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='Dromogomphus' AND (species='spinosus' OR species='spinosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='abbreviatus' OR junior_species='abbreviatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='abbreviatus' OR species='abbreviatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='abbreviatus' OR species='abbreviatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='abbreviatus' OR junior_species='abbreviatus')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='Gomphus' AND (species='abbreviatus' OR species='abbreviatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='cavillaris' OR junior_species='cavillaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='cavillaris' OR species='cavillaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='cavillaris' OR species='cavillaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='cavillaris' OR junior_species='cavillaris')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='Gomphus' AND (species='cavillaris' OR species='cavillaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='dilitatus' OR junior_species='dilitatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='dilitatus' OR species='dilitatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='dilitatus' OR species='dilitatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='dilitatus' OR junior_species='dilitatus')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='Gomphus' AND (species='dilitatus' OR species='dilitatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='lividus' OR junior_species='lividus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='lividus' OR species='lividus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='lividus' OR species='lividus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='lividus' OR junior_species='lividus')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='Gomphus' AND (species='lividus' OR species='lividus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='parvidens' OR junior_species='parvidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='parvidens' OR species='parvidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='parvidens' OR species='parvidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='parvidens' OR junior_species='parvidens')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='Gomphus' AND (species='parvidens' OR species='parvidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='vastus' OR junior_species='vastus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphus' AND (species='vastus' OR species='vastus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='vastus' OR species='vastus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' AND (junior_species='vastus' OR junior_species='vastus')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='Gomphus' AND (species='vastus' OR species='vastus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hagenius' AND (junior_species='brevistylus' OR junior_species='brevistylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hagenius' AND (species='brevistylus' OR species='brevistylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hagenius' AND (species='brevistylus' OR species='brevistylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hagenius' AND (junior_species='brevistylus' OR junior_species='brevistylus')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='Hagenius' AND (species='brevistylus' OR species='brevistylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanthus' AND (junior_species='parvulus' OR junior_species='parvulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanthus' AND (species='parvulus' OR species='parvulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanthus' AND (species='parvulus' OR species='parvulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanthus' AND (junior_species='parvulus' OR junior_species='parvulus')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='Lanthus' AND (species='parvulus' OR species='parvulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiogomphus' AND (junior_species='mainensis' OR junior_species='mainensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophiogomphus' AND (species='mainensis' OR species='mainensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophiogomphus' AND (species='mainensis' OR species='mainensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiogomphus' AND (junior_species='mainensis' OR junior_species='mainensis')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='Ophiogomphus' AND (species='mainensis' OR species='mainensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Progomphus' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Progomphus' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='obscurus' OR junior_species='obscurus')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='Progomphus' AND (species='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylogomphus' AND (junior_species='albistylus' OR junior_species='albistylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylogomphus' AND (species='albistylus' OR species='albistylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylogomphus' AND (species='albistylus' OR species='albistylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylogomphus' AND (junior_species='albistylus' OR junior_species='albistylus')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='Stylogomphus' AND (species='albistylus' OR species='albistylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='amnicola' OR junior_species='amnicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylurus' AND (species='amnicola' OR species='amnicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylurus' AND (species='amnicola' OR species='amnicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='amnicola' OR junior_species='amnicola')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='Stylurus' AND (species='amnicola' OR species='amnicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='ivae' OR junior_species='ivae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylurus' AND (species='ivae' OR species='ivae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylurus' AND (species='ivae' OR species='ivae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='ivae' OR junior_species='ivae')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='Stylurus' AND (species='ivae' OR species='ivae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='notatus' OR junior_species='notatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylurus' AND (species='notatus' OR species='notatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylurus' AND (species='notatus' OR species='notatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='notatus' OR junior_species='notatus')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='Stylurus' AND (species='notatus' OR species='notatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='scudderi' OR junior_species='scudderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylurus' AND (species='scudderi' OR species='scudderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylurus' AND (species='scudderi' OR species='scudderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='scudderi' OR junior_species='scudderii')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='Stylurus' AND (species='scudderi' OR species='scudderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='spiniceps' OR junior_species='spiniceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stylurus' AND (species='spiniceps' OR species='spiniceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stylurus' AND (species='spiniceps' OR species='spiniceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stylurus' AND (junior_species='spiniceps' OR junior_species='spiniceps')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='Stylurus' AND (species='spiniceps' OR species='spiniceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulegaster' AND (junior_species='erronea' OR junior_species='erronea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordulegaster' AND (species='erronea' OR species='erronea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordulegaster' AND (species='erronea' OR species='erronea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulegaster' AND (junior_species='erronea' OR junior_species='erronea')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='Cordulegaster' AND (species='erronea' OR species='erronea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulegaster' AND (junior_species='maculata' OR junior_species='maculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordulegaster' AND (species='maculata' OR species='maculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordulegaster' AND (species='maculata' OR species='maculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulegaster' AND (junior_species='maculata' OR junior_species='maculata')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='Cordulegaster' AND (species='maculata' OR species='maculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didymops' AND (junior_species='transversa' OR junior_species='transversa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didymops' AND (species='transversa' OR species='transversa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Didymops' AND (species='transversa' OR species='transversa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didymops' AND (junior_species='transversa' OR junior_species='transversa')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='Didymops' AND (species='transversa' OR species='transversa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='illinoiensis' OR junior_species='illinoiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macromia' AND (species='illinoiensis' OR species='illinoiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macromia' AND (species='illinoiensis' OR species='illinoiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='illinoiensis' OR junior_species='illinoiensis')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='Macromia' AND (species='illinoiensis' OR species='illinoiensis') 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='Somatochlora' AND (junior_species='provocans' OR junior_species='provocans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Somatochlora' AND (species='provocans' OR species='provocans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Somatochlora' AND (species='provocans' OR species='provocans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Somatochlora' AND (junior_species='provocans' OR junior_species='provocans')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='Somatochlora' AND (species='provocans' OR species='provocans') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1583 The Ecological Register: Enoree River Basin
Enoree River Basin
Basic information
Sample name: Enoree River Basin

Reference: W. B. Worthen. 2002. The structure of larval odonate assemblages in the Enoree River Basin of South Carolina. Southeastern Naturalist 1(3):205-216 [ER 1073]
Geography
Country: United States

State: South Carolina


Coordinate: 34° 26' N, 81° 25' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Enoree River

Environment
Habitat: temperate upland river

Substrate: lake bottom/stream bed

Habitat comments: "pool, riffle, run" habitats "upstream from bridge crossings"

Methods
Life forms: odonates

Sampling methods: other nets

Sample size: 7568 individuals

Years: 1999 - 2000

Seasons: spring,summer

Sampling comments: "odonates were collected by electrofishing... for a total of 8 minutes at each site... Immobilized invertebrates were collected downstream from the Electrofisher with a seine (1.5m x 3.3m x 3.0mm) and dip nets"

Metadata
Sample number: 1583

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-22 14:31:02

Modified: 2016-10-21 04:39:40

Abundance distribution
32 species
8 singletons
total count 7568
extrapolated richness: 47.5
Fisher's α: 4.279
geometric series k: 0.7670
Hurlbert's PIE: 0.7120
Shannon's H: 1.7515
Good's u: 0.9989
Each square represents a species. Square sizes are proportional to counts.
Register