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=1531 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1531SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1034SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1531 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyonis' AND (junior_species='sthenele' OR junior_species='sthenele')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyonis' AND (species='sthenele' OR species='sthenele') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyonis' AND (species='sthenele' OR species='sthenele')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyonis' AND (junior_species='sthenele' OR junior_species='sthenele')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='sthenele' OR species='sthenele') 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='Erebia' AND (junior_species='epipsodea' OR junior_species='epipsodea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erebia' AND (species='epipsodea' OR species='epipsodea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erebia' AND (species='epipsodea' OR species='epipsodea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erebia' AND (junior_species='epipsodea' OR junior_species='epipsodea')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='Erebia' AND (species='epipsodea' OR species='epipsodea') 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='Chlosyne' AND (junior_species='palla' OR junior_species='palla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlosyne' AND (species='palla' OR species='palla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlosyne' AND (species='palla' OR species='palla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='palla' OR junior_species='palla')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='Chlosyne' AND (species='palla' OR species='palla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='milberti' OR junior_species='milbertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphalis' AND (species='milberti' OR species='milbertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphalis' AND (species='milberti' OR species='milbertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='milberti' OR junior_species='milbertii')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='milberti' OR species='milbertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyciodes' AND (junior_species='campestris' OR junior_species='campestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyciodes' AND (species='campestris' OR species='campestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyciodes' AND (species='campestris' OR species='campestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyciodes' AND (junior_species='campestris' OR junior_species='campestris')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='campestris' OR species='campestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='zephyrus' OR junior_species='zephyrus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polygonia' AND (species='zephyrus' OR species='zephyrus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonia' AND (species='zephyrus' OR species='zephyrus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='zephyrus' OR junior_species='zephyrus')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='zephyrus' OR species='zephyrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='atalanta' OR junior_species='atalanta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='atalanta' OR species='atalanta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='atalanta' OR species='atalanta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='atalanta' OR junior_species='atalanta')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='Vanessa' AND (species='atalanta' OR species='atalanta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='cardui' OR junior_species='carduii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='cardui' OR species='carduii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='cardui' OR junior_species='carduii')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='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptoieta' AND (junior_species='claudia' OR junior_species='claudia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptoieta' AND (species='claudia' OR species='claudia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptoieta' AND (species='claudia' OR species='claudia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptoieta' AND (junior_species='claudia' OR junior_species='claudia')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='Euptoieta' AND (species='claudia' OR species='claudia') 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='mormonia' OR junior_species='mormonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Speyeria' AND (species='mormonia' OR species='mormonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Speyeria' AND (species='mormonia' OR species='mormonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Speyeria' AND (junior_species='mormonia' OR junior_species='mormonia')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='mormonia' OR species='mormonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='heteronea' OR junior_species='heteronea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='heteronea' OR species='heteronea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='heteronea' OR species='heteronea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='heteronea' OR junior_species='heteronea')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='heteronea' OR species='heteronea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='nivalis' OR junior_species='nivalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='nivalis' OR species='nivalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='nivalis' OR species='nivalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='nivalis' OR junior_species='nivalis')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='nivalis' OR species='nivalis') 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='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='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='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='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='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='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='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='Pieris' AND (junior_species='napi' OR junior_species='napii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='napi' OR species='napii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='napi' OR species='napii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='napi' OR junior_species='napii')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='napi' OR species='napii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' 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='Pieris' AND (species='protodice' OR species='protodice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='protodice' OR species='protodice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' 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='Pieris' AND (species='protodice' OR species='protodice') 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='zelicaon' OR junior_species='zelicaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='zelicaon' OR species='zelicaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='zelicaon' OR species='zelicaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='zelicaon' OR junior_species='zelicaon')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='zelicaon' OR species='zelicaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnassius' AND (junior_species='phoebus' OR junior_species='phoebus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parnassius' AND (species='phoebus' OR species='phoebus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parnassius' AND (species='phoebus' OR species='phoebus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnassius' AND (junior_species='phoebus' OR junior_species='phoebus')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='phoebus' OR species='phoebus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1531 The Ecological Register: Rocky Mountain Biological Laboratory (butterflies)
Rocky Mountain Biological Laboratory (butterflies)
Basic information
Sample name: Rocky Mountain Biological Laboratory (butterflies)

Reference: T. H. Ricketts, G. C. Daily, and P. R. Ehrlich. 2002. Does butterfly diversity predict moth diversity? Testing a popular indicator taxon at local scales. Biological Conservation 103:361-370 [ER 1034]
Geography
Country: United States

State: Colorado


Coordinate: 38° 40' N, 107° 1' W
Coordinate basis: based on political unit

Geography comments: coordinate based on Gunnison County
elevation based on Shaw et al. (2000, Plant Ecology)

Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

WMT: 13.4

CMT: -12.5

MAP: 500.0

Habitat comments: subalpine "meadows, aspen forests, and conifer forests"
climate data are for the station and are from Hayes (1981, Oecologia)

Methods
Life forms: butterflies

Sites: 19

Sampling methods: no design,butterfly nets,visual

Sample size: 716 individuals

Sampling comments: "time-constrained searches, netting each observed butterfly or identifying them on the wing if possible. Butterfly sampling occurred between 10:00 and 12:00 h"

Metadata
Sample number: 1531

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-09 15:08:32

Modified: 2016-12-13 08:22:08

Abundance distribution
29 species
7 singletons
total count 716
extrapolated richness: 42.6
Fisher's α: 6.068
geometric series k: 0.8277
Hurlbert's PIE: 0.8737
Shannon's H: 2.5504
Good's u: 0.9902
Each square represents a species. Square sizes are proportional to counts.
Register