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=1366 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1366SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=825SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1366 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocharis' AND (junior_species='cardamines' OR junior_species='cardamines')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthocharis' AND (species='cardamines' OR species='cardamines') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthocharis' AND (species='cardamines' OR species='cardamines')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocharis' AND (junior_species='cardamines' OR junior_species='cardamines')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='Anthocharis' AND (species='cardamines' OR species='cardamines') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporia' AND (junior_species='crataegi' OR junior_species='crataegii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporia' AND (species='crataegi' OR species='crataegii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporia' AND (species='crataegi' OR species='crataegii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporia' AND (junior_species='crataegi' OR junior_species='crataegii')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='Aporia' AND (species='crataegi' OR species='crataegii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='alfacariensis' OR junior_species='alfacariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='alfacariensis' OR species='alfacariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='alfacariensis' OR species='alfacariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='alfacariensis' OR junior_species='alfacariensis')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='alfacariensis' OR species='alfacariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='crocea' OR junior_species='crocea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='crocea' OR species='crocea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='crocea' OR species='crocea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='crocea' OR junior_species='crocea')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='crocea' OR species='crocea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='daplidice' OR junior_species='daplidice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='daplidice' OR species='daplidice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='daplidice' OR species='daplidice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='daplidice' OR junior_species='daplidice')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='daplidice' OR species='daplidice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='rapae' OR species='rapae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='rapae' OR species='rapae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')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='rapae' OR species='rapae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='rubi' OR junior_species='rubii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callophrys' AND (species='rubi' OR species='rubii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callophrys' AND (species='rubi' OR species='rubii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='rubi' OR junior_species='rubii')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='rubi' OR species='rubii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celastrina' AND (species='argiolus' OR species='argiolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celastrina' AND (species='argiolus' OR species='argiolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')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='argiolus' OR species='argiolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucopsyche' AND (junior_species='alexis' OR junior_species='alexis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucopsyche' AND (species='alexis' OR species='alexis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucopsyche' AND (species='alexis' OR species='alexis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucopsyche' AND (junior_species='alexis' OR junior_species='alexis')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='alexis' OR species='alexis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nordmannia' AND (junior_species='esculi' OR junior_species='esculii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nordmannia' AND (species='esculi' OR species='esculii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nordmannia' AND (species='esculi' OR species='esculii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nordmannia' AND (junior_species='esculi' OR junior_species='esculii')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='Nordmannia' AND (species='esculi' OR species='esculii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nordmannia' AND (junior_species='ilicis' OR junior_species='ilicis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nordmannia' AND (species='ilicis' OR species='ilicis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nordmannia' AND (species='ilicis' OR species='ilicis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nordmannia' AND (junior_species='ilicis' OR junior_species='ilicis')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='Nordmannia' AND (species='ilicis' OR species='ilicis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nordrnannia' AND (junior_species='spini' OR junior_species='spinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nordrnannia' AND (species='spini' OR species='spinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nordrnannia' AND (species='spini' OR species='spinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nordrnannia' AND (junior_species='spini' OR junior_species='spinii')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='Nordrnannia' AND (species='spini' OR species='spinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='albicans' OR junior_species='albicans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='albicans' OR species='albicans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='albicans' OR species='albicans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='albicans' OR junior_species='albicans')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='Polyommatus' AND (species='albicans' OR species='albicans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='bellargus' OR junior_species='bellargus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='bellargus' OR species='bellargus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='bellargus' OR species='bellargus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='bellargus' OR junior_species='bellargus')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='Polyommatus' AND (species='bellargus' OR species='bellargus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='dorylas' OR junior_species='dorylas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='dorylas' OR species='dorylas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='dorylas' OR species='dorylas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='dorylas' OR junior_species='dorylas')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='Polyommatus' AND (species='dorylas' OR species='dorylas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='icarus' OR junior_species='icarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='icarus' OR species='icarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='icarus' OR species='icarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='icarus' OR junior_species='icarus')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='Polyommatus' AND (species='icarus' OR species='icarus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chazara' AND (junior_species='briseis' OR junior_species='briseis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chazara' AND (species='briseis' OR species='briseis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chazara' AND (species='briseis' OR species='briseis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chazara' AND (junior_species='briseis' OR junior_species='briseis')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='Chazara' AND (species='briseis' OR species='briseis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='dorus' OR junior_species='dorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='dorus' OR species='dorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='dorus' OR species='dorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='dorus' OR junior_species='dorus')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='dorus' OR species='dorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='pamphilus' OR junior_species='pamphilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='pamphilus' OR species='pamphilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='pamphilus' OR species='pamphilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='pamphilus' OR junior_species='pamphilus')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='pamphilus' OR species='pamphilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipparchia' AND (junior_species='semele' OR junior_species='semele')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipparchia' AND (species='semele' OR species='semele') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hipparchia' AND (species='semele' OR species='semele')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipparchia' AND (junior_species='semele' OR junior_species='semele')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='Hipparchia' AND (species='semele' OR species='semele') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipparchia' AND (junior_species='statilinus' OR junior_species='statilinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipparchia' AND (species='statilinus' OR species='statilinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hipparchia' AND (species='statilinus' OR species='statilinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipparchia' AND (junior_species='statilinus' OR junior_species='statilinus')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='Hipparchia' AND (species='statilinus' OR species='statilinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyponephele' AND (junior_species='lupina' OR junior_species='lupina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyponephele' AND (species='lupina' OR species='lupina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyponephele' AND (species='lupina' OR species='lupina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyponephele' AND (junior_species='lupina' OR junior_species='lupina')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='Hyponephele' AND (species='lupina' OR species='lupina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyponephele' AND (junior_species='lycaon' OR junior_species='lycaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyponephele' AND (species='lycaon' OR species='lycaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyponephele' AND (species='lycaon' OR species='lycaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyponephele' AND (junior_species='lycaon' OR junior_species='lycaon')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='Hyponephele' AND (species='lycaon' OR species='lycaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kanetisa' AND (junior_species='circe' OR junior_species='circe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kanetisa' AND (species='circe' OR species='circe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kanetisa' AND (species='circe' OR species='circe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kanetisa' AND (junior_species='circe' OR junior_species='circe')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='Kanetisa' AND (species='circe' OR species='circe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lassiommata' AND (junior_species='megera' OR junior_species='megera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lassiommata' AND (species='megera' OR species='megera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lassiommata' AND (species='megera' OR species='megera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lassiommata' AND (junior_species='megera' OR junior_species='megera')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='Lassiommata' AND (species='megera' OR species='megera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maniola' AND (junior_species='jurtina' OR junior_species='jurtina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maniola' AND (species='jurtina' OR species='jurtina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maniola' AND (species='jurtina' OR species='jurtina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maniola' AND (junior_species='jurtina' OR junior_species='jurtina')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='Maniola' AND (species='jurtina' OR species='jurtina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanargia' AND (junior_species='lachesis' OR junior_species='lachesis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanargia' AND (species='lachesis' OR species='lachesis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanargia' AND (species='lachesis' OR species='lachesis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanargia' AND (junior_species='lachesis' OR junior_species='lachesis')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='Melanargia' AND (species='lachesis' OR species='lachesis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyronia' AND (junior_species='bathseba' OR junior_species='bathseba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyronia' AND (species='bathseba' OR species='bathseba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyronia' AND (species='bathseba' OR species='bathseba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyronia' AND (junior_species='bathseba' OR junior_species='bathseba')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='Pyronia' AND (species='bathseba' OR species='bathseba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphidryas' AND (junior_species='desfontainii' OR junior_species='desfontaini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphidryas' AND (species='desfontainii' OR species='desfontaini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphidryas' AND (species='desfontainii' OR species='desfontaini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphidryas' AND (junior_species='desfontainii' OR junior_species='desfontaini')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='Euphidryas' AND (species='desfontainii' OR species='desfontaini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='reducta' OR junior_species='reducta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limenitis' AND (species='reducta' OR species='reducta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limenitis' AND (species='reducta' OR species='reducta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='reducta' OR junior_species='reducta')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='Limenitis' AND (species='reducta' OR species='reducta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaea' AND (junior_species='cinxia' OR junior_species='cinxia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melitaea' AND (species='cinxia' OR species='cinxia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melitaea' AND (species='cinxia' OR species='cinxia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaea' AND (junior_species='cinxia' OR junior_species='cinxia')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='Melitaea' AND (species='cinxia' OR species='cinxia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaea' AND (junior_species='phoebe' OR junior_species='phoebe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melitaea' AND (species='phoebe' OR species='phoebe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melitaea' AND (species='phoebe' OR species='phoebe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaea' AND (junior_species='phoebe' OR junior_species='phoebe')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='Melitaea' AND (species='phoebe' OR species='phoebe') 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='Pyrgus' AND (junior_species='carthami' OR junior_species='carthamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgus' AND (species='carthami' OR species='carthamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgus' AND (species='carthami' OR species='carthamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='carthami' OR junior_species='carthamii')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='Pyrgus' AND (species='carthami' OR species='carthamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrichtus' AND (junior_species='proto' OR junior_species='proto')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syrichtus' AND (species='proto' OR species='proto') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syrichtus' AND (species='proto' OR species='proto')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syrichtus' AND (junior_species='proto' OR junior_species='proto')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='Syrichtus' AND (species='proto' OR species='proto') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1366 The Ecological Register: Northeast of Guadalajara (forest fragment 13)
Northeast of Guadalajara (forest fragment 13)
Basic information
Sample name: Northeast of Guadalajara (forest fragment 13)

Reference: A. Baz and A. Garcia-Boyero. 1996. The SLOSS dilemma: a butterfly case study. Biodiversity and Conservation 5:493-502 [ER 825]
Geography
Country: Spain

State: Guadalajara


Coordinate: 40° 47' N, 2° 46' W
Coordinate basis: based on nearby landmark

Geography comments: sites are shown on a map as being northeast of Guadalajara near Brihuega and Cifuentes (basis of coordinate)

Environment
Habitat: Mediterranean woodland

Substrate: ground surface

WMT: 23.5

CMT: 5.6

MAP: 340.0

Habitat comments: "holm oak (Quercus rotundifolia Lam.)"
site is a 2115 ha fragment
climate data based on station 8226 (Guadalajara)

Methods
Life forms: butterflies

Sampling methods: butterfly nets

Sample size: 171 individuals

Years: 1991

Days: 9

Sampling comments: "9 sample days"
all individuals were caught (presumably using nets)

Metadata
Sample number: 1366

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-24 11:12:20

Modified: 2015-02-24 00:12:20

Abundance distribution
35 species
11 singletons
total count 171
extrapolated richness: 67.1
Fisher's α: 13.322
geometric series k: 0.9217
Hurlbert's PIE: 0.9486
Shannon's H: 3.1841
Good's u: 0.9361
Each square represents a species. Square sizes are proportional to counts.
Register