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=1334 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1334SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=890SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1334 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theorema' AND (junior_species='eumenia' OR junior_species='eumenia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theorema' AND (species='eumenia' OR species='eumenia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theorema' AND (species='eumenia' OR species='eumenia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theorema' AND (junior_species='eumenia' OR junior_species='eumenia')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='Theorema' AND (species='eumenia' OR species='eumenia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theritas' AND (junior_species='hemon' OR junior_species='hemon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theritas' AND (species='hemon' OR species='hemon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theritas' AND (species='hemon' OR species='hemon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theritas' AND (junior_species='hemon' OR junior_species='hemon')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='Theritas' AND (species='hemon' OR species='hemon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='cocala' OR junior_species='cocala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='cocala' OR species='cocala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='cocala' OR species='cocala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='cocala' OR junior_species='cocala')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='Adelpha' AND (species='cocala' OR species='cocala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='cytherea' OR junior_species='cytherea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='cytherea' OR species='cytherea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='cytherea' OR species='cytherea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='cytherea' OR junior_species='cytherea')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='Adelpha' AND (species='cytherea' OR species='cytherea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='justina' OR junior_species='justina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='justina' OR species='justina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='justina' OR species='justina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='justina' OR junior_species='justina')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='Adelpha' AND (species='justina' OR species='justina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='salmoneus' OR junior_species='salmoneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='salmoneus' OR species='salmoneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='salmoneus' OR species='salmoneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='salmoneus' OR junior_species='salmoneus')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='Adelpha' AND (species='salmoneus' OR species='salmoneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeria' AND (junior_species='eurimedia' OR junior_species='eurimedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeria' AND (species='eurimedia' OR species='eurimedia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeria' AND (species='eurimedia' OR species='eurimedia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeria' AND (junior_species='eurimedia' OR junior_species='eurimedia')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='Aeria' AND (species='eurimedia' OR species='eurimedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='fatima' OR junior_species='fatima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anartia' AND (species='fatima' OR species='fatima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anartia' AND (species='fatima' OR species='fatima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='fatima' OR junior_species='fatima')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='Anartia' AND (species='fatima' OR species='fatima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='telamonius' OR junior_species='telamonius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caligo' AND (species='telamonius' OR species='telamonius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caligo' AND (species='telamonius' OR species='telamonius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='telamonius' OR junior_species='telamonius')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='Caligo' AND (species='telamonius' OR species='telamonius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castilia' AND (junior_species='eranites' OR junior_species='eranites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castilia' AND (species='eranites' OR species='eranites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castilia' AND (species='eranites' OR species='eranites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castilia' AND (junior_species='eranites' OR junior_species='eranites')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='Castilia' AND (species='eranites' OR species='eranites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='orgetorix' OR junior_species='orgetorix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catoblepia' AND (species='orgetorix' OR species='orgetorix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catoblepia' AND (species='orgetorix' OR species='orgetorix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='orgetorix' OR junior_species='orgetorix')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='Catoblepia' AND (species='orgetorix' OR species='orgetorix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloreuptychia' AND (junior_species='arnaca' OR junior_species='arnaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloreuptychia' AND (species='arnaca' OR species='arnaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloreuptychia' AND (species='arnaca' OR species='arnaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloreuptychia' AND (junior_species='arnaca' OR junior_species='arnaca')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='Chloreuptychia' AND (species='arnaca' OR species='arnaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='confusa' OR junior_species='confusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cissia' AND (species='confusa' OR species='confusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cissia' AND (species='confusa' OR species='confusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='confusa' OR junior_species='confusa')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='Cissia' AND (species='confusa' OR species='confusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cithaerias' AND (junior_species='pireta' OR junior_species='pireta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cithaerias' AND (species='pireta' OR species='pireta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cithaerias' AND (species='pireta' OR species='pireta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cithaerias' AND (junior_species='pireta' OR junior_species='pireta')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='Cithaerias' AND (species='pireta' OR species='pireta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='juno' OR junior_species='juno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dione' AND (species='juno' OR species='juno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dione' AND (species='juno' OR species='juno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='juno' OR junior_species='juno')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='Dione' AND (species='juno' OR species='juno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryas' AND (junior_species='iulia' OR junior_species='iulia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dryas' AND (species='iulia' OR species='iulia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dryas' AND (species='iulia' OR species='iulia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryas' AND (junior_species='iulia' OR junior_species='iulia')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='Dryas' AND (species='iulia' OR species='iulia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='ithomioides' OR junior_species='ithomioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eresia' AND (species='ithomioides' OR species='ithomioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eresia' AND (species='ithomioides' OR species='ithomioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='ithomioides' OR junior_species='ithomioides')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='Eresia' AND (species='ithomioides' OR species='ithomioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eueides' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eueides' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eueides' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eueides' AND (junior_species='lineata' OR junior_species='lineata')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='Eueides' AND (species='lineata' OR species='lineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eueides' AND (junior_species='lybia' OR junior_species='lybia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eueides' AND (species='lybia' OR species='lybia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eueides' AND (species='lybia' OR species='lybia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eueides' AND (junior_species='lybia' OR junior_species='lybia')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='Eueides' AND (species='lybia' OR species='lybia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='chlororhoa' OR junior_species='chlororhoa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='chlororhoa' OR species='chlororhoa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='chlororhoa' OR species='chlororhoa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='chlororhoa' OR junior_species='chlororhoa')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='Eunica' AND (species='chlororhoa' OR species='chlororhoa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychia' AND (junior_species='insolata' OR junior_species='insolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptychia' AND (species='insolata' OR species='insolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptychia' AND (species='insolata' OR species='insolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychia' AND (junior_species='insolata' OR junior_species='insolata')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='Euptychia' AND (species='insolata' OR species='insolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychia' AND (junior_species='jesia' OR junior_species='jesia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptychia' AND (species='jesia' OR species='jesia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptychia' AND (species='jesia' OR species='jesia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptychia' AND (junior_species='jesia' OR junior_species='jesia')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='Euptychia' AND (species='jesia' OR species='jesia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='feronia' OR junior_species='feronia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='feronia' OR species='feronia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='feronia' OR species='feronia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='feronia' OR junior_species='feronia')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='Hamadryas' AND (species='feronia' OR species='feronia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='cydno' OR junior_species='cydno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='cydno' OR species='cydno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='cydno' OR species='cydno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='cydno' OR junior_species='cydno')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='Heliconius' AND (species='cydno' OR species='cydno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='melpomene' OR junior_species='melpomene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='melpomene' OR species='melpomene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='melpomene' OR species='melpomene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='melpomene' OR junior_species='melpomene')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='Heliconius' AND (species='melpomene' OR species='melpomene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='sapho' OR junior_species='sapho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='sapho' OR species='sapho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='sapho' OR species='sapho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='sapho' OR junior_species='sapho')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='Heliconius' AND (species='sapho' OR species='sapho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='sara' OR junior_species='sara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='sara' OR species='sara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='sara' OR species='sara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='sara' OR junior_species='sara')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='Heliconius' AND (species='sara' OR species='sara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='hermes' OR junior_species='hermes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hermeuptychia' AND (species='hermes' OR species='hermes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hermeuptychia' AND (species='hermes' OR species='hermes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='hermes' OR junior_species='hermes')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='Hermeuptychia' AND (species='hermes' OR species='hermes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyposcada' AND (junior_species='virginiana' OR junior_species='virginiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyposcada' AND (species='virginiana' OR species='virginiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyposcada' AND (species='virginiana' OR species='virginiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyposcada' AND (junior_species='virginiana' OR junior_species='virginiana')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='Hyposcada' AND (species='virginiana' OR species='virginiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laparus' AND (junior_species='doris' OR junior_species='doris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laparus' AND (species='doris' OR species='doris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laparus' AND (species='doris' OR species='doris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laparus' AND (junior_species='doris' OR junior_species='doris')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='Laparus' AND (species='doris' OR species='doris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycorea' AND (junior_species='halia' OR junior_species='halia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycorea' AND (species='halia' OR species='halia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycorea' AND (species='halia' OR species='halia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycorea' AND (junior_species='halia' OR junior_species='halia')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='Lycorea' AND (species='halia' OR species='halia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magneuptychia' AND (junior_species='gomezi' OR junior_species='gomezii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Magneuptychia' AND (species='gomezi' OR species='gomezii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Magneuptychia' AND (species='gomezi' OR species='gomezii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magneuptychia' AND (junior_species='gomezi' OR junior_species='gomezii')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='Magneuptychia' AND (species='gomezi' OR species='gomezii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='merops' OR junior_species='merops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpesia' AND (species='merops' OR species='merops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpesia' AND (species='merops' OR species='merops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='merops' OR junior_species='merops')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='Marpesia' AND (species='merops' OR species='merops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='polymnia' OR junior_species='polymnia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mechanitis' AND (species='polymnia' OR species='polymnia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mechanitis' AND (species='polymnia' OR species='polymnia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='polymnia' OR junior_species='polymnia')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='Mechanitis' AND (species='polymnia' OR species='polymnia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megeuptychia' AND (junior_species='antonoe' OR junior_species='antonoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megeuptychia' AND (species='antonoe' OR species='antonoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megeuptychia' AND (species='antonoe' OR species='antonoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megeuptychia' AND (junior_species='antonoe' OR junior_species='antonoe')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='Megeuptychia' AND (species='antonoe' OR species='antonoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melinaea' AND (junior_species='lilis' OR junior_species='lilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melinaea' AND (species='lilis' OR species='lilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melinaea' AND (species='lilis' OR species='lilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melinaea' AND (junior_species='lilis' OR junior_species='lilis')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='Melinaea' AND (species='lilis' OR species='lilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='helenor' OR species='helenor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')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='Morpho' AND (species='helenor' OR species='helenor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='menelaus' OR junior_species='menelaus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='menelaus' OR species='menelaus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='menelaus' OR species='menelaus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='menelaus' OR junior_species='menelaus')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='Morpho' AND (species='menelaus' OR species='menelaus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nessaea' AND (junior_species='aglaura' OR junior_species='aglaura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nessaea' AND (species='aglaura' OR species='aglaura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nessaea' AND (species='aglaura' OR species='aglaura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nessaea' AND (junior_species='aglaura' OR junior_species='aglaura')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='Nessaea' AND (species='aglaura' OR species='aglaura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='neis' OR junior_species='neis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Autochton' AND (species='neis' OR species='neis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Autochton' AND (species='neis' OR species='neis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='neis' OR junior_species='neis')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='Autochton' AND (species='neis' OR species='neis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philaethria' AND (junior_species='dido' OR junior_species='dido')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philaethria' AND (species='dido' OR species='dido') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philaethria' AND (species='dido' OR species='dido')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philaethria' AND (junior_species='dido' OR junior_species='dido')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='Philaethria' AND (species='dido' OR species='dido') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pierella' AND (junior_species='helvina' OR junior_species='helvina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pierella' AND (species='helvina' OR species='helvina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pierella' AND (species='helvina' OR species='helvina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pierella' AND (junior_species='helvina' OR junior_species='helvina')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='Pierella' AND (species='helvina' OR species='helvina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pierella' AND (junior_species='luna' OR junior_species='luna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pierella' AND (species='luna' OR species='luna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pierella' AND (species='luna' OR species='luna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pierella' AND (junior_species='luna' OR junior_species='luna')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='Pierella' AND (species='luna' OR species='luna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='crameri' OR junior_species='cramerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhogyra' AND (species='crameri' OR species='cramerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhogyra' AND (species='crameri' OR species='cramerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='crameri' OR junior_species='cramerii')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='Pyrrhogyra' AND (species='crameri' OR species='cramerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tithorea' AND (junior_species='tarricina' OR junior_species='tarricina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tithorea' AND (species='tarricina' OR species='tarricina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tithorea' AND (species='tarricina' OR species='tarricina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tithorea' AND (junior_species='tarricina' OR junior_species='tarricina')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='Tithorea' AND (species='tarricina' OR species='tarricina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='lycidas' OR junior_species='lycidas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Battus' AND (species='lycidas' OR species='lycidas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Battus' AND (species='lycidas' OR species='lycidas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='lycidas' OR junior_species='lycidas')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='Battus' AND (species='lycidas' OR species='lycidas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimoides' AND (junior_species='ilus' OR junior_species='ilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimoides' AND (species='ilus' OR species='ilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimoides' AND (species='ilus' OR species='ilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimoides' AND (junior_species='ilus' OR junior_species='ilus')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='Mimoides' AND (species='ilus' OR species='ilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='childrenae' OR junior_species='childrenae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parides' AND (species='childrenae' OR species='childrenae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parides' AND (species='childrenae' OR species='childrenae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='childrenae' OR junior_species='childrenae')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='Parides' AND (species='childrenae' OR species='childrenae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='panares' OR junior_species='panares')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parides' AND (species='panares' OR species='panares') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parides' AND (species='panares' OR species='panares')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='panares' OR junior_species='panares')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='Parides' AND (species='panares' OR species='panares') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphrissa' AND (junior_species='statira' OR junior_species='statira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphrissa' AND (species='statira' OR species='statira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphrissa' AND (species='statira' OR species='statira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphrissa' AND (junior_species='statira' OR junior_species='statira')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='Aphrissa' AND (species='statira' OR species='statira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archonias' AND (junior_species='brassolis' OR junior_species='brassolis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archonias' AND (species='brassolis' OR species='brassolis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archonias' AND (species='brassolis' OR species='brassolis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archonias' AND (junior_species='brassolis' OR junior_species='brassolis')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='Archonias' AND (species='brassolis' OR species='brassolis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='theucharila' OR junior_species='theucharila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dismorphia' AND (species='theucharila' OR species='theucharila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dismorphia' AND (species='theucharila' OR species='theucharila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='theucharila' OR junior_species='theucharila')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='Dismorphia' AND (species='theucharila' OR species='theucharila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='sennae' OR junior_species='sennae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='sennae' OR species='sennae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='sennae' OR species='sennae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='sennae' OR junior_species='sennae')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='Phoebis' AND (species='sennae' OR species='sennae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charis' AND (junior_species='anius' OR junior_species='anius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charis' AND (species='anius' OR species='anius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charis' AND (species='anius' OR species='anius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charis' AND (junior_species='anius' OR junior_species='anius')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='Charis' AND (species='anius' OR species='anius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Detritivora' AND (junior_species='gynaea' OR junior_species='gynaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Detritivora' AND (species='gynaea' OR species='gynaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Detritivora' AND (species='gynaea' OR species='gynaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Detritivora' AND (junior_species='gynaea' OR junior_species='gynaea')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='Detritivora' AND (species='gynaea' OR species='gynaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurybia' AND (junior_species='elvina' OR junior_species='elvina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurybia' AND (species='elvina' OR species='elvina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurybia' AND (species='elvina' OR species='elvina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurybia' AND (junior_species='elvina' OR junior_species='elvina')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='Eurybia' AND (species='elvina' OR species='elvina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurybia' AND (junior_species='lycisca' OR junior_species='lycisca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurybia' AND (species='lycisca' OR species='lycisca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurybia' AND (species='lycisca' OR species='lycisca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurybia' AND (junior_species='lycisca' OR junior_species='lycisca')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='Eurybia' AND (species='lycisca' OR species='lycisca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Juditha' AND (junior_species='molpe' OR junior_species='molpe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Juditha' AND (species='molpe' OR species='molpe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Juditha' AND (species='molpe' OR species='molpe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Juditha' AND (junior_species='molpe' OR junior_species='molpe')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='Juditha' AND (species='molpe' OR species='molpe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucochimona' AND (junior_species='lepida' OR junior_species='lepida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucochimona' AND (species='lepida' OR species='lepida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucochimona' AND (species='lepida' OR species='lepida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucochimona' AND (junior_species='lepida' OR junior_species='lepida')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='Leucochimona' AND (species='lepida' OR species='lepida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menander' AND (junior_species='pretus' OR junior_species='pretus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menander' AND (species='pretus' OR species='pretus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menander' AND (species='pretus' OR species='pretus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menander' AND (junior_species='pretus' OR junior_species='pretus')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='Menander' AND (species='pretus' OR species='pretus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesene' AND (junior_species='phareus' OR junior_species='phareus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesene' AND (species='phareus' OR species='phareus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesene' AND (species='phareus' OR species='phareus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesene' AND (junior_species='phareus' OR junior_species='phareus')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='Mesene' AND (species='phareus' OR species='phareus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesenopsis' AND (junior_species='melanochlora' OR junior_species='melanochlora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesenopsis' AND (species='melanochlora' OR species='melanochlora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesenopsis' AND (species='melanochlora' OR species='melanochlora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesenopsis' AND (junior_species='melanochlora' OR junior_species='melanochlora')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='Mesenopsis' AND (species='melanochlora' OR species='melanochlora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='asa' OR junior_species='asa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesosemia' AND (species='asa' OR species='asa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesosemia' AND (species='asa' OR species='asa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='asa' OR junior_species='asa')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='Mesosemia' AND (species='asa' OR species='asa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='telegone' OR junior_species='telegone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesosemia' AND (species='telegone' OR species='telegone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesosemia' AND (species='telegone' OR species='telegone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='telegone' OR junior_species='telegone')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='Mesosemia' AND (species='telegone' OR species='telegone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='zonalis' OR junior_species='zonalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesosemia' AND (species='zonalis' OR species='zonalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesosemia' AND (species='zonalis' OR species='zonalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesosemia' AND (junior_species='zonalis' OR junior_species='zonalis')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='Mesosemia' AND (species='zonalis' OR species='zonalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphidium' AND (junior_species='ascolia' OR junior_species='ascolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphidium' AND (species='ascolia' OR species='ascolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphidium' AND (species='ascolia' OR species='ascolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphidium' AND (junior_species='ascolia' OR junior_species='ascolia')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='Nymphidium' AND (species='ascolia' OR species='ascolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perophthalma' AND (junior_species='lasus' OR junior_species='lasus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perophthalma' AND (species='lasus' OR species='lasus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perophthalma' AND (species='lasus' OR species='lasus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perophthalma' AND (junior_species='lasus' OR junior_species='lasus')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='Perophthalma' AND (species='lasus' OR species='lasus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarota' AND (junior_species='chrysus' OR junior_species='chrysus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sarota' AND (species='chrysus' OR species='chrysus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sarota' AND (species='chrysus' OR species='chrysus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sarota' AND (junior_species='chrysus' OR junior_species='chrysus')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='Sarota' AND (species='chrysus' OR species='chrysus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mnasilus' AND (junior_species='allubita' OR junior_species='allubita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mnasilus' AND (species='allubita' OR species='allubita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mnasilus' AND (species='allubita' OR species='allubita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mnasilus' AND (junior_species='allubita' OR junior_species='allubita')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='Mnasilus' AND (species='allubita' OR species='allubita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='togarna' OR junior_species='togarna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arawacus' AND (species='togarna' OR species='togarna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arawacus' AND (species='togarna' OR species='togarna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='togarna' OR junior_species='togarna')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='Arawacus' AND (species='togarna' OR species='togarna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arumecla' AND (junior_species='galliena' OR junior_species='galliena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arumecla' AND (species='galliena' OR species='galliena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arumecla' AND (species='galliena' OR species='galliena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arumecla' AND (junior_species='galliena' OR junior_species='galliena')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='Arumecla' AND (species='galliena' OR species='galliena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='trebula' OR junior_species='trebula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calycopis' AND (species='trebula' OR species='trebula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calycopis' AND (species='trebula' OR species='trebula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='trebula' OR junior_species='trebula')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='Calycopis' AND (species='trebula' OR species='trebula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocaria' AND (junior_species='thales' OR junior_species='thales')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocaria' AND (species='thales' OR species='thales') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocaria' AND (species='thales' OR species='thales')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocaria' AND (junior_species='thales' OR junior_species='thales')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='Ocaria' AND (species='thales' OR species='thales') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siderus' AND (junior_species='leucophaeus' OR junior_species='leucophaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siderus' AND (species='leucophaeus' OR species='leucophaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siderus' AND (species='leucophaeus' OR species='leucophaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siderus' AND (junior_species='leucophaeus' OR junior_species='leucophaeus')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='Siderus' AND (species='leucophaeus' OR species='leucophaeus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1334 The Ecological Register: La Gamba (natural forest)
La Gamba (natural forest)
Basic information
Sample name: La Gamba (natural forest)

Sample aka: Piedras Blancas National Park

Reference: M. Wiemers and K. Fiedler. 2008. Butterfly diversity of the Piedras Blancas National Park and its vicinity - a preliminary assessment (Lepidoptera: Papilionoidea and Hesperioidea). Stapfia 88:277-294 [ER 890]
Geography
Country: Costa Rica

State: Puntarenas


Coordinate: 8° 42' 30" N, 83° 11' 0" W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on La Gamba

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

Disturbance: grazing

MAT: 27.4

WMT: 31.5

CMT: 23.2

MAP: 5720.0

Habitat comments: six sites in ridge and riverine forest
climate data are for the Tropical Field Station La Gamba and are from Umana and Wanek (2010, Ecosystems)

Methods
Life forms: butterflies

Sampling methods: no design,visual

Sample size: 204 individuals

Years: 2006, 2007

Seasons: dry

Sampling comments: sampling in 2006 was at fixed sites and in 2007 was along transects

Metadata
Sample number: 1334

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-22 08:15:26

Modified: 2016-12-13 08:51:46

Abundance distribution
74 species
40 singletons
total count 204
extrapolated richness: 227.7
Fisher's α: 41.743
geometric series k: 0.9665
Hurlbert's PIE: 0.9726
Shannon's H: 3.9116
Good's u: 0.8045
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Theorema eumenia1
Theritas hemon1
Adelpha cocala2
Adelpha cytherea1
Adelpha justina2
Adelpha salmoneus1
Aeria eurimedia2
Anartia fatima1
Caligo telamonius2
Castilia eranites1
Catoblepia orgetorix1
Chloreuptychia arnaca9
Cissia confusa2
Cithaerias pireta1
Dione juno1
Dryas iulia2
Eresia ithomioides2
Eueides lineata4
Eueides lybia6
Eunica chlororhoa1
Euptychia insolata4
Euptychia jesia9
Hamadryas feronia1
Heliconius cydno11
Heliconius melpomene1
Heliconius sapho10
Heliconius sara1
Hermeuptychia hermes6
Hyposcada virginiana5
Laparus doris12
Lycorea halia1
Magneuptychia gomezi1
Marpesia merops3
Mechanitis polymnia5
Megeuptychia antonoe1
Melinaea lilis1
Morpho helenor1
Morpho menelaus4
Nessaea aglaura2
Autochton neis1
Philaethria dido8
Pierella helvina4
Pierella luna5
Pyrrhogyra crameri1
Tithorea tarricina1
Battus lycidas1
Mimoides ilus1
Parides childrenae5
Parides panares1
Aphrissa statira1
Archonias brassolis5
Dismorphia theucharila1
Phoebis sennae1
Charis anius2
Detritivora gynaea1
Eurybia elvina1
Eurybia lycisca3
Juditha molpe1
Leucochimona lepida1
Menander pretus2
Mesene phareus1
Mesenopsis melanochlora1
Mesosemia asa5
Mesosemia telegone1
Mesosemia zonalis1
Nymphidium ascolia1
Perophthalma lasus1
Sarota chrysus1
Mnasilus allubita1
Arawacus togarna5
Arumecla galliena11
Calycopis trebula3
Ocaria thales1
Siderus leucophaeus2