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=1333 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1333SELECT 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=1333 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ouleus' AND (junior_species='fridericus' OR junior_species='fridericus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ouleus' AND (species='fridericus' OR species='fridericus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ouleus' AND (species='fridericus' OR species='fridericus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ouleus' AND (junior_species='fridericus' OR junior_species='fridericus')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='Ouleus' AND (species='fridericus' OR species='fridericus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panoquina' AND (junior_species='ocola' OR junior_species='ocola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panoquina' AND (species='ocola' OR species='ocola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panoquina' AND (species='ocola' OR species='ocola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panoquina' AND (junior_species='ocola' OR junior_species='ocola')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='Panoquina' AND (species='ocola' OR species='ocola') 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='Brangas' AND (junior_species='caranus' OR junior_species='caranus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brangas' AND (species='caranus' OR species='caranus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brangas' AND (species='caranus' OR species='caranus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brangas' AND (junior_species='caranus' OR junior_species='caranus')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='Brangas' AND (species='caranus' OR species='caranus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='demonassa' OR junior_species='demonassa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calycopis' AND (species='demonassa' OR species='demonassa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calycopis' AND (species='demonassa' OR species='demonassa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='demonassa' OR junior_species='demonassa')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='demonassa' OR species='demonassa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='isobeon' OR junior_species='isobeon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calycopis' AND (species='isobeon' OR species='isobeon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calycopis' AND (species='isobeon' OR species='isobeon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='isobeon' OR junior_species='isobeon')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='isobeon' OR species='isobeon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupido' AND (junior_species='comyntas' OR junior_species='comyntas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupido' AND (species='comyntas' OR species='comyntas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupido' AND (species='comyntas' OR species='comyntas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupido' AND (junior_species='comyntas' OR junior_species='comyntas')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='Cupido' AND (species='comyntas' OR species='comyntas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiargus' AND (junior_species='hanno' OR junior_species='hanno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemiargus' AND (species='hanno' OR species='hanno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemiargus' AND (species='hanno' OR species='hanno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiargus' AND (junior_species='hanno' OR junior_species='hanno')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='Hemiargus' AND (species='hanno' OR species='hanno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theritas' AND (junior_species='lisus' OR junior_species='lisus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theritas' AND (species='lisus' OR species='lisus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theritas' AND (species='lisus' OR species='lisus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theritas' AND (junior_species='lisus' OR junior_species='lisus')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='lisus' OR species='lisus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ziegleria' AND (junior_species='syllis' OR junior_species='syllis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ziegleria' AND (species='syllis' OR species='syllis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ziegleria' AND (species='syllis' OR species='syllis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ziegleria' AND (junior_species='syllis' OR junior_species='syllis')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='Ziegleria' AND (species='syllis' OR species='syllis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='boeotia' OR junior_species='boeotia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='boeotia' OR species='boeotia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='boeotia' OR species='boeotia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='boeotia' OR junior_species='boeotia')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='boeotia' OR species='boeotia') 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='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='Anartia' AND (junior_species='jatrophae' OR junior_species='jatrophae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anartia' AND (species='jatrophae' OR species='jatrophae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anartia' AND (species='jatrophae' OR species='jatrophae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='jatrophae' OR junior_species='jatrophae')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='jatrophae' OR species='jatrophae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='frisia' OR junior_species='frisia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthanassa' AND (species='frisia' OR species='frisia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthanassa' AND (species='frisia' OR species='frisia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='frisia' OR junior_species='frisia')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='Anthanassa' AND (species='frisia' OR species='frisia') 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='Ceratinia' AND (junior_species='tutia' OR junior_species='tutia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratinia' AND (species='tutia' OR species='tutia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratinia' AND (species='tutia' OR species='tutia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratinia' AND (junior_species='tutia' OR junior_species='tutia')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='Ceratinia' AND (species='tutia' OR species='tutia') 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='Chlosyne' AND (junior_species='theona' OR junior_species='theona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlosyne' AND (species='theona' OR species='theona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlosyne' AND (species='theona' OR species='theona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='theona' OR junior_species='theona')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='theona' OR species='theona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='pompilia' OR junior_species='pompilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cissia' AND (species='pompilia' OR species='pompilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cissia' AND (species='pompilia' OR species='pompilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='pompilia' OR junior_species='pompilia')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='pompilia' OR species='pompilia') 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='Dynamine' AND (junior_species='agacles' OR junior_species='agacles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='agacles' OR species='agacles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='agacles' OR species='agacles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='agacles' OR junior_species='agacles')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='Dynamine' AND (species='agacles' OR species='agacles') 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='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='alpais' OR junior_species='alpais')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='alpais' OR species='alpais') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='alpais' OR species='alpais')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='alpais' OR junior_species='alpais')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='alpais' OR species='alpais') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='sydonia' OR junior_species='sydonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='sydonia' OR species='sydonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='sydonia' OR species='sydonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='sydonia' OR junior_species='sydonia')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='sydonia' OR species='sydonia') 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='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='ismenius' OR junior_species='ismenius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='ismenius' OR species='ismenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='ismenius' OR species='ismenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='ismenius' OR junior_species='ismenius')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='ismenius' OR species='ismenius') 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='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='Magneuptychia' AND (junior_species='libye' OR junior_species='libye')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Magneuptychia' AND (species='libye' OR species='libye') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Magneuptychia' AND (species='libye' OR species='libye')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Magneuptychia' AND (junior_species='libye' OR junior_species='libye')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='libye' OR species='libye') 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='Pareuptychia' AND (junior_species='ocirrhoe' OR junior_species='ocirrhoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='ocirrhoe' OR junior_species='ocirrhoe')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='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe') 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='Siproeta' AND (junior_species='stelenes' OR junior_species='stelenes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siproeta' AND (species='stelenes' OR species='stelenes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siproeta' AND (species='stelenes' OR species='stelenes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siproeta' AND (junior_species='stelenes' OR junior_species='stelenes')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='Siproeta' AND (species='stelenes' OR species='stelenes') 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='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='Enantia' AND (junior_species='melite' OR junior_species='melite')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enantia' AND (species='melite' OR species='melite') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enantia' AND (species='melite' OR species='melite')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enantia' AND (junior_species='melite' OR junior_species='melite')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='Enantia' AND (species='melite' OR species='melite') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='albula' OR junior_species='albula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='albula' OR species='albula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='albula' OR species='albula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='albula' OR junior_species='albula')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='Eurema' AND (species='albula' OR species='albula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='daira' OR junior_species='daira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='daira' OR species='daira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='daira' OR species='daira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='daira' OR junior_species='daira')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='Eurema' AND (species='daira' OR species='daira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glutophrissa' AND (junior_species='drusilla' OR junior_species='drusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glutophrissa' AND (species='drusilla' OR species='drusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glutophrissa' AND (species='drusilla' OR species='drusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glutophrissa' AND (junior_species='drusilla' OR junior_species='drusilla')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='Glutophrissa' AND (species='drusilla' OR species='drusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrisitia' AND (junior_species='nise' OR junior_species='nise')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrisitia' AND (species='nise' OR species='nise') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrisitia' AND (species='nise' OR species='nise')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrisitia' AND (junior_species='nise' OR junior_species='nise')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='Pyrisitia' AND (species='nise' OR species='nise') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calephelis' AND (junior_species='laverna' OR junior_species='laverna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calephelis' AND (species='laverna' OR species='laverna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calephelis' AND (species='laverna' OR species='laverna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calephelis' AND (junior_species='laverna' OR junior_species='laverna')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='Calephelis' AND (species='laverna' OR species='laverna') 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='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='Euselasia' AND (junior_species='aurantia' OR junior_species='aurantia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euselasia' AND (species='aurantia' OR species='aurantia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euselasia' AND (species='aurantia' OR species='aurantia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euselasia' AND (junior_species='aurantia' OR junior_species='aurantia')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='Euselasia' AND (species='aurantia' OR species='aurantia') 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='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='Napaea' AND (junior_species='eucharila' OR junior_species='eucharila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Napaea' AND (species='eucharila' OR species='eucharila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Napaea' AND (species='eucharila' OR species='eucharila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Napaea' AND (junior_species='eucharila' OR junior_species='eucharila')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='Napaea' AND (species='eucharila' OR species='eucharila') 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='Pirascca' AND (junior_species='arbuscula' OR junior_species='arbuscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pirascca' AND (species='arbuscula' OR species='arbuscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pirascca' AND (species='arbuscula' OR species='arbuscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pirascca' AND (junior_species='arbuscula' OR junior_species='arbuscula')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='Pirascca' AND (species='arbuscula' OR species='arbuscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thisbe' AND (junior_species='lycorias' OR junior_species='lycorias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thisbe' AND (species='lycorias' OR species='lycorias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thisbe' AND (species='lycorias' OR species='lycorias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thisbe' AND (junior_species='lycorias' OR junior_species='lycorias')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='Thisbe' AND (species='lycorias' OR species='lycorias') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1333 The Ecological Register: La Gamba (secondary forest)
La Gamba (secondary forest)
Basic information
Sample name: La Gamba (secondary 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

Altered habitat: secondary forest

Protection: national/state park

Substrate: ground surface

Disturbance: grazing

MAT: 27.4

WMT: 31.5

CMT: 23.2

MAP: 5720.0

Habitat comments: four sites in secondary forest and two sites in "a (partly swampy) plantation of Gmelina arborea"
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: 368 individuals

Years: 2006, 2007

Seasons: dry

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

Metadata
Sample number: 1333

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-22 07:57:46

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

Abundance distribution
62 species
29 singletons
total count 368
extrapolated richness: 153.8
Fisher's α: 21.356
geometric series k: 0.9364
Hurlbert's PIE: 0.9372
Shannon's H: 3.2709
Good's u: 0.9213
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ouleus fridericus1
Panoquina ocola1
Arawacus togarna7
Arumecla galliena1
Brangas caranus1
Calycopis demonassa1
Calycopis isobeon1
Cupido comyntas3
Hemiargus hanno3
Theritas lisus1
Ziegleria syllis1
Adelpha boeotia1
Adelpha cytherea22
Anartia fatima38
Anartia jatrophae31
Anthanassa frisia7
Caligo telamonius1
Ceratinia tutia1
Chloreuptychia arnaca10
Chlosyne theona1
Cissia pompilia2
Dryas iulia4
Dynamine agacles2
Eresia ithomioides1
Eueides lybia1
Eunica alpais1
Eunica sydonia1
Euptychia insolata1
Euptychia jesia6
Heliconius cydno2
Heliconius ismenius1
Heliconius melpomene4
Heliconius sapho4
Heliconius sara1
Hermeuptychia hermes55
Hyposcada virginiana1
Lycorea halia2
Magneuptychia gomezi1
Magneuptychia libye10
Marpesia merops2
Mechanitis polymnia22
Pareuptychia ocirrhoe28
Pierella luna1
Siproeta stelenes2
Tithorea tarricina5
Dismorphia theucharila1
Enantia melite1
Eurema albula2
Eurema daira20
Glutophrissa drusilla1
Pyrisitia nise17
Calephelis laverna4
Charis anius4
Eurybia elvina1
Eurybia lycisca7
Euselasia aurantia1
Juditha molpe4
Mesene phareus1
Napaea eucharila1
Nymphidium ascolia5
Pirascca arbuscula2
Thisbe lycorias3