Coordinate: 8° 42' 30" N, 83° 11' 0" W
climate data are for the Tropical Field Station La Gamba and are from Umana and Wanek (2010, Ecosystems)
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