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=982 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=982SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=675SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=982 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnassius' AND (junior_species='smintheus' OR junior_species='smintheus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parnassius' AND (species='smintheus' OR species='smintheus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parnassius' AND (species='smintheus' OR species='smintheus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnassius' AND (junior_species='smintheus' OR junior_species='smintheus')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='Parnassius' AND (species='smintheus' OR species='smintheus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='rutulus' OR junior_species='rutulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='rutulus' OR species='rutulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='rutulus' OR species='rutulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='rutulus' OR junior_species='rutulus')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='Papilio' AND (species='rutulus' OR species='rutulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='multicaudatus' OR junior_species='multicaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='multicaudatus' OR species='multicaudatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='multicaudatus' OR species='multicaudatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='multicaudatus' OR junior_species='multicaudatus')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='Papilio' AND (species='multicaudatus' OR species='multicaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pontia' AND (junior_species='protodice' OR junior_species='protodice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pontia' AND (species='protodice' OR species='protodice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pontia' AND (species='protodice' OR species='protodice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pontia' AND (junior_species='protodice' OR junior_species='protodice')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='Pontia' AND (species='protodice' OR species='protodice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='marginalis' OR junior_species='marginalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='marginalis' OR species='marginalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='marginalis' OR species='marginalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='marginalis' OR junior_species='marginalis')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='Pieris' AND (species='marginalis' OR species='marginalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchloe' AND (junior_species='ausonides' OR junior_species='ausonides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euchloe' AND (species='ausonides' OR species='ausonides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euchloe' AND (species='ausonides' OR species='ausonides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euchloe' AND (junior_species='ausonides' OR junior_species='ausonides')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='Euchloe' AND (species='ausonides' OR species='ausonides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='philodice' OR junior_species='philodice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='philodice' OR species='philodice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='philodice' OR species='philodice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='philodice' OR junior_species='philodice')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='Colias' AND (species='philodice' OR species='philodice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='eurytheme' OR junior_species='eurytheme')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='eurytheme' OR species='eurytheme') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='eurytheme' OR species='eurytheme')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='eurytheme' OR junior_species='eurytheme')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='Colias' AND (species='eurytheme' OR species='eurytheme') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='alexandra' OR junior_species='alexandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='alexandra' OR species='alexandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='alexandra' OR species='alexandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='alexandra' OR junior_species='alexandra')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='Colias' AND (species='alexandra' OR species='alexandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='rubidus' OR junior_species='rubidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='rubidus' OR species='rubidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='rubidus' OR species='rubidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='rubidus' OR junior_species='rubidus')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='Lycaena' AND (species='rubidus' OR species='rubidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='helloides' OR junior_species='helloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='helloides' OR species='helloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='helloides' OR species='helloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='helloides' OR junior_species='helloides')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='Lycaena' AND (species='helloides' OR species='helloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='spinetorum' OR junior_species='spinetorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callophrys' AND (species='spinetorum' OR species='spinetorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callophrys' AND (species='spinetorum' OR species='spinetorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='spinetorum' OR junior_species='spinetorum')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='Callophrys' AND (species='spinetorum' OR species='spinetorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='eryphon' OR junior_species='eryphon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callophrys' AND (species='eryphon' OR species='eryphon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callophrys' AND (species='eryphon' OR species='eryphon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='eryphon' OR junior_species='eryphon')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='Callophrys' AND (species='eryphon' OR species='eryphon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Everes' AND (junior_species='amyntula' OR junior_species='amyntula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Everes' AND (species='amyntula' OR species='amyntula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Everes' AND (species='amyntula' OR species='amyntula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Everes' AND (junior_species='amyntula' OR junior_species='amyntula')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='Everes' AND (species='amyntula' OR species='amyntula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='ladon' OR junior_species='ladon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celastrina' AND (species='ladon' OR species='ladon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celastrina' AND (species='ladon' OR species='ladon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='ladon' OR junior_species='ladon')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='Celastrina' AND (species='ladon' OR species='ladon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucopsyche' AND (junior_species='lygdamus' OR junior_species='lygdamus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucopsyche' AND (species='lygdamus' OR species='lygdamus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucopsyche' AND (species='lygdamus' OR species='lygdamus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucopsyche' AND (junior_species='lygdamus' OR junior_species='lygdamus')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='Glaucopsyche' AND (species='lygdamus' OR species='lygdamus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriades' AND (junior_species='glandon' OR junior_species='glandon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriades' AND (species='glandon' OR species='glandon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriades' AND (species='glandon' OR species='glandon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriades' AND (junior_species='glandon' OR junior_species='glandon')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='Agriades' AND (species='glandon' OR species='glandon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='saepiolus' OR junior_species='saepiolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plebejus' AND (species='saepiolus' OR species='saepiolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plebejus' AND (species='saepiolus' OR species='saepiolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='saepiolus' OR junior_species='saepiolus')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='Plebejus' AND (species='saepiolus' OR species='saepiolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icaricia' AND (junior_species='acmon' OR junior_species='acmon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Icaricia' AND (species='acmon' OR species='acmon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Icaricia' AND (species='acmon' OR species='acmon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icaricia' AND (junior_species='acmon' OR junior_species='acmon')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='Icaricia' AND (species='acmon' OR species='acmon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Speyeria' AND (junior_species='atlantis' OR junior_species='atlantis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Speyeria' AND (species='atlantis' OR species='atlantis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Speyeria' AND (species='atlantis' OR species='atlantis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Speyeria' AND (junior_species='atlantis' OR junior_species='atlantis')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='Speyeria' AND (species='atlantis' OR species='atlantis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Speyeria' AND (junior_species='aphrodite' OR junior_species='aphrodite')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Speyeria' AND (species='aphrodite' OR species='aphrodite') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Speyeria' AND (species='aphrodite' OR species='aphrodite')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Speyeria' AND (junior_species='aphrodite' OR junior_species='aphrodite')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='Speyeria' AND (species='aphrodite' OR species='aphrodite') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Speyeria' AND (junior_species='edwardsii' OR junior_species='edwardsi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Speyeria' AND (species='edwardsii' OR species='edwardsi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Speyeria' AND (species='edwardsii' OR species='edwardsi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Speyeria' AND (junior_species='edwardsii' OR junior_species='edwardsi')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='Speyeria' AND (species='edwardsii' OR species='edwardsi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyciodes' AND (junior_species='pratensis' OR junior_species='pratensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyciodes' AND (species='pratensis' OR species='pratensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyciodes' AND (species='pratensis' OR species='pratensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyciodes' AND (junior_species='pratensis' OR junior_species='pratensis')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='Phyciodes' AND (species='pratensis' OR species='pratensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='faunus' OR junior_species='faunus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polygonia' AND (species='faunus' OR species='faunus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonia' AND (species='faunus' OR species='faunus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='faunus' OR junior_species='faunus')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='Polygonia' AND (species='faunus' OR species='faunus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' 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='Polygonia' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonia' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' 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='Polygonia' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='antiopa' OR junior_species='antiopa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphalis' AND (species='antiopa' OR species='antiopa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphalis' AND (species='antiopa' OR species='antiopa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='antiopa' OR junior_species='antiopa')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='Nymphalis' AND (species='antiopa' OR species='antiopa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limentis' AND (junior_species='weidemeyerii' OR junior_species='weidemeyeri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limentis' AND (species='weidemeyerii' OR species='weidemeyeri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limentis' AND (species='weidemeyerii' OR species='weidemeyeri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limentis' AND (junior_species='weidemeyerii' OR junior_species='weidemeyeri')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='Limentis' AND (species='weidemeyerii' OR species='weidemeyeri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='tullia' OR junior_species='tullia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='tullia' OR species='tullia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='tullia' OR species='tullia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='tullia' OR junior_species='tullia')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='Coenonympha' AND (species='tullia' OR species='tullia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyonis' AND (junior_species='oetus' OR junior_species='oetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyonis' AND (species='oetus' OR species='oetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyonis' AND (species='oetus' OR species='oetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyonis' AND (junior_species='oetus' OR junior_species='oetus')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='Cercyonis' AND (species='oetus' OR species='oetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oeneis' AND (junior_species='chryxus' OR junior_species='chryxus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oeneis' AND (species='chryxus' OR species='chryxus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oeneis' AND (species='chryxus' OR species='chryxus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oeneis' AND (junior_species='chryxus' OR junior_species='chryxus')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='Oeneis' AND (species='chryxus' OR species='chryxus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erynnis' AND (junior_species='persius' OR junior_species='persius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erynnis' AND (species='persius' OR species='persius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erynnis' AND (species='persius' OR species='persius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erynnis' AND (junior_species='persius' OR junior_species='persius')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='Erynnis' AND (species='persius' OR species='persius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oarisma' AND (junior_species='garita' OR junior_species='garita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oarisma' AND (species='garita' OR species='garita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oarisma' AND (species='garita' OR species='garita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oarisma' AND (junior_species='garita' OR junior_species='garita')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='Oarisma' AND (species='garita' OR species='garita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polites' AND (junior_species='draco' OR junior_species='draco')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polites' AND (species='draco' OR species='draco') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polites' AND (species='draco' OR species='draco')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polites' AND (junior_species='draco' OR junior_species='draco')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='Polites' AND (species='draco' OR species='draco') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=982 The Ecological Register: Beaver Meadows (aspen)
Beaver Meadows (aspen)
Basic information
Sample name: Beaver Meadows (aspen)

Reference: S. E. Simonson, P. A. Opler, T. J. Stohlgren, and G. W. Chong. 2001. Rapid assessment of butterfly diversity in a montane landscape. Biodiversity and Conservation 10:1369-1386 [ER 675]
Geography
Country: United States

State: Colorado


Coordinate: 40.37° N, -105.60° W
Coordinate basis: stated in text

Geography comments: "T 5N, R 73W, S 29,30"

Environment
Habitat: temperate coniferous forest

Substrate: ground surface

WMT: 22.8

CMT: -0.6

MAP: 381.0

Habitat comments: "quaking aspen" forest
climate based on station 72469 (Denver)

Methods
Life forms: butterflies

Sites: 4

Site area: 0.4

Sampling methods: visual

Sample size: 252 captures or sightings

Years: 1996

Sampling comments: visual surveys of four 0.1 ha plots

Metadata
Sample number: 982

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-06-28 23:00:36

Modified: 2014-06-28 13:00:36

Abundance distribution
33 species
6 singletons
total count 252
extrapolated richness: 52.9
Fisher's α: 10.149
geometric series k: 0.8813
Hurlbert's PIE: 0.9096
Shannon's H: 2.8840
Good's u: 0.9764
Each square represents a species. Square sizes are proportional to counts.
Register