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=1185 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1185SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=836SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1185 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abaeis' AND (junior_species='nicippe' OR junior_species='nicippe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abaeis' AND (species='nicippe' OR species='nicippe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abaeis' AND (species='nicippe' OR species='nicippe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abaeis' AND (junior_species='nicippe' OR junior_species='nicippe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abaeis' AND (species='nicippe' OR species='nicippe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achlyodes' AND (junior_species='pallida' OR junior_species='pallida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Achlyodes' AND (species='pallida' OR species='pallida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Achlyodes' AND (species='pallida' OR species='pallida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achlyodes' AND (junior_species='pallida' OR junior_species='pallida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Achlyodes' AND (species='pallida' OR species='pallida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='iphicleola' OR junior_species='iphicleola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='iphicleola' OR species='iphicleola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='iphicleola' OR species='iphicleola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='iphicleola' OR junior_species='iphicleola')SELECT d.diet,d.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='iphicleola' OR species='iphicleola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='leuceria' OR junior_species='leuceria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='leuceria' OR species='leuceria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='leuceria' OR species='leuceria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='leuceria' OR junior_species='leuceria')SELECT d.diet,d.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='leuceria' OR species='leuceria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='pithys' OR junior_species='pithys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='pithys' OR species='pithys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='pithys' OR species='pithys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='pithys' OR junior_species='pithys')SELECT d.diet,d.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='pithys' OR species='pithys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agraulis' AND (junior_species='vallinae' OR junior_species='vallinae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agraulis' AND (species='vallinae' OR species='vallinae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agraulis' AND (species='vallinae' OR species='vallinae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agraulis' AND (junior_species='vallinae' OR junior_species='vallinae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agraulis' AND (species='vallinae' OR species='vallinae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altinote' AND (junior_species='ozomene' OR junior_species='ozomene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Altinote' AND (species='ozomene' OR species='ozomene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Altinote' AND (species='ozomene' OR species='ozomene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Altinote' AND (junior_species='ozomene' OR junior_species='ozomene')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Altinote' AND (species='ozomene' OR species='ozomene') 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='Ancyloxypha' AND (junior_species='numitor' OR junior_species='numitor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ancyloxypha' AND (species='numitor' OR species='numitor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ancyloxypha' AND (species='numitor' OR species='numitor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ancyloxypha' AND (junior_species='numitor' OR junior_species='numitor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ancyloxypha' AND (species='numitor' OR species='numitor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anteos' AND (junior_species='clorinde' OR junior_species='clorinde')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anteos' AND (species='clorinde' OR species='clorinde') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anteos' AND (species='clorinde' OR species='clorinde')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anteos' AND (junior_species='clorinde' OR junior_species='clorinde')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anteos' AND (species='clorinde' OR species='clorinde') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anteos' AND (junior_species='maerula' OR junior_species='maerula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anteos' AND (species='maerula' OR species='maerula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anteos' AND (species='maerula' OR species='maerula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anteos' AND (junior_species='maerula' OR junior_species='maerula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anteos' AND (species='maerula' OR species='maerula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='ardys' OR junior_species='ardys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthanassa' AND (species='ardys' OR species='ardys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthanassa' AND (species='ardys' OR species='ardys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='ardys' OR junior_species='ardys')SELECT d.diet,d.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='ardys' OR species='ardys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' 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='Anthanassa' AND (species='drusilla' OR species='drusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthanassa' AND (species='drusilla' OR species='drusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' 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='Anthanassa' AND (species='drusilla' OR species='drusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='otanes' OR junior_species='otanes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthanassa' AND (species='otanes' OR species='otanes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthanassa' AND (species='otanes' OR species='otanes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='otanes' OR junior_species='otanes')SELECT d.diet,d.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='otanes' OR species='otanes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='ptolyca' OR junior_species='ptolyca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthanassa' AND (species='ptolyca' OR species='ptolyca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthanassa' AND (species='ptolyca' OR species='ptolyca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='ptolyca' OR junior_species='ptolyca')SELECT d.diet,d.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='ptolyca' OR species='ptolyca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='texana' OR junior_species='texana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthanassa' AND (species='texana' OR species='texana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthanassa' AND (species='texana' OR species='texana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthanassa' AND (junior_species='texana' OR junior_species='texana')SELECT d.diet,d.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='texana' OR species='texana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphrissa' AND (junior_species='statira' OR junior_species='statira')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphrissa' AND (species='statira' OR species='statira') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphrissa' AND (species='statira' OR species='statira')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphrissa' AND (junior_species='statira' OR junior_species='statira')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aphrissa' AND (species='statira' OR species='statira') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apuecla' AND (junior_species='maeonis' OR junior_species='maeonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apuecla' AND (species='maeonis' OR species='maeonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apuecla' AND (species='maeonis' OR species='maeonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apuecla' AND (junior_species='maeonis' OR junior_species='maeonis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apuecla' AND (species='maeonis' OR species='maeonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='fulgerator' OR junior_species='fulgerator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astraptes' AND (species='fulgerator' OR species='fulgerator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astraptes' AND (species='fulgerator' OR species='fulgerator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='fulgerator' OR junior_species='fulgerator')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Astraptes' AND (species='fulgerator' OR species='fulgerator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='cellus' OR junior_species='cellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Autochton' AND (species='cellus' OR species='cellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Autochton' AND (species='cellus' OR species='cellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='cellus' OR junior_species='cellus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Autochton' AND (species='cellus' OR species='cellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='vectilucis' OR junior_species='vectilucis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Autochton' AND (species='vectilucis' OR species='vectilucis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Autochton' AND (species='vectilucis' OR species='vectilucis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='vectilucis' OR junior_species='vectilucis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Autochton' AND (species='vectilucis' OR species='vectilucis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Autochton' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Autochton' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Autochton' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biblis' AND (junior_species='hyperia' OR junior_species='hyperia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Biblis' AND (species='hyperia' OR species='hyperia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Biblis' AND (species='hyperia' OR species='hyperia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biblis' AND (junior_species='hyperia' OR junior_species='hyperia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Biblis' AND (species='hyperia' OR species='hyperia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calephelis' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calephelis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calephelis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calephelis' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='uranus' OR junior_species='uranus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caligo' AND (species='uranus' OR species='uranus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caligo' AND (species='uranus' OR species='uranus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='uranus' OR junior_species='uranus')SELECT d.diet,d.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='uranus' OR species='uranus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='clarina' OR junior_species='clarina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calycopis' AND (species='clarina' OR species='clarina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calycopis' AND (species='clarina' OR species='clarina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='clarina' OR junior_species='clarina')SELECT d.diet,d.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='clarina' OR species='clarina') 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='Catasticta' AND (junior_species='flisa' OR junior_species='flisa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catasticta' AND (species='flisa' OR species='flisa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catasticta' AND (species='flisa' OR species='flisa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catasticta' AND (junior_species='flisa' OR junior_species='flisa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catasticta' AND (species='flisa' OR species='flisa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='philea' OR junior_species='philea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='philea' OR species='philea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='philea' OR species='philea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='philea' OR junior_species='philea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoebis' AND (species='philea' OR species='philea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catasticta' AND (junior_species='nimbice' OR junior_species='nimbice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catasticta' AND (species='nimbice' OR species='nimbice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catasticta' AND (species='nimbice' OR species='nimbice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catasticta' AND (junior_species='nimbice' OR junior_species='nimbice')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catasticta' AND (species='nimbice' OR species='nimbice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catasticta' AND (junior_species='teutila' OR junior_species='teutila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catasticta' AND (species='teutila' OR species='teutila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catasticta' AND (species='teutila' OR species='teutila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catasticta' AND (junior_species='teutila' OR junior_species='teutila')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catasticta' AND (species='teutila' OR species='teutila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celastrina' AND (species='argiolus' OR species='argiolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celastrina' AND (species='argiolus' OR species='argiolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celastrina' AND (species='argiolus' OR species='argiolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='erodyle' OR junior_species='erodyle')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlosyne' AND (species='erodyle' OR species='erodyle') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlosyne' AND (species='erodyle' OR species='erodyle')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='erodyle' OR junior_species='erodyle')SELECT d.diet,d.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='erodyle' OR species='erodyle') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='janais' OR junior_species='janais')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlosyne' AND (species='janais' OR species='janais') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlosyne' AND (species='janais' OR species='janais')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='janais' OR junior_species='janais')SELECT d.diet,d.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='janais' OR species='janais') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='marina' OR junior_species='marina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlosyne' AND (species='marina' OR species='marina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlosyne' AND (species='marina' OR species='marina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='marina' OR junior_species='marina')SELECT d.diet,d.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='marina' OR species='marina') 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='Consul' AND (junior_species='excellens' OR junior_species='excellens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Consul' AND (species='excellens' OR species='excellens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Consul' AND (species='excellens' OR species='excellens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Consul' AND (junior_species='excellens' OR junior_species='excellens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Consul' AND (species='excellens' OR species='excellens') 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='Cyllopsis' AND (junior_species='hedemanni' OR junior_species='hedemannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyllopsis' AND (species='hedemanni' OR species='hedemannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyllopsis' AND (species='hedemanni' OR species='hedemannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyllopsis' AND (junior_species='hedemanni' OR junior_species='hedemannii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyllopsis' AND (species='hedemanni' OR species='hedemannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyllopsis' AND (junior_species='hilaria' OR junior_species='hilaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyllopsis' AND (species='hilaria' OR species='hilaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyllopsis' AND (species='hilaria' OR species='hilaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyllopsis' AND (junior_species='hilaria' OR junior_species='hilaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyllopsis' AND (species='hilaria' OR species='hilaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='gilippus' OR junior_species='gilippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='gilippus' OR species='gilippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='gilippus' OR species='gilippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='gilippus' OR junior_species='gilippus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Danaus' AND (species='gilippus' OR species='gilippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='plexippus' OR junior_species='plexippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='plexippus' OR species='plexippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='plexippus' OR species='plexippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='plexippus' OR junior_species='plexippus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Danaus' AND (species='plexippus' OR species='plexippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Denivia' AND (junior_species='augustinula' OR junior_species='augustinula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Denivia' AND (species='augustinula' OR species='augustinula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Denivia' AND (species='augustinula' OR species='augustinula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Denivia' AND (junior_species='augustinula' OR junior_species='augustinula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Denivia' AND (species='augustinula' OR species='augustinula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='anna' OR junior_species='anna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='anna' OR species='anna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='anna' OR species='anna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='anna' OR junior_species='anna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaethria' AND (species='anna' OR species='anna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='pandama' OR junior_species='pandama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='pandama' OR species='pandama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='pandama' OR species='pandama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='pandama' OR junior_species='pandama')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaethria' AND (species='pandama' OR species='pandama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='juno' OR junior_species='juno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dione' AND (species='juno' OR species='juno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dione' AND (species='juno' OR species='juno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='juno' OR junior_species='juno')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dione' AND (species='juno' OR species='juno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='moneta' OR junior_species='moneta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dione' AND (species='moneta' OR species='moneta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dione' AND (species='moneta' OR species='moneta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='moneta' OR junior_species='moneta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dione' AND (species='moneta' OR species='moneta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dircenna' AND (junior_species='klugii' OR junior_species='klugi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dircenna' AND (species='klugii' OR species='klugi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dircenna' AND (species='klugii' OR species='klugi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dircenna' AND (junior_species='klugii' OR junior_species='klugi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dircenna' AND (species='klugii' OR species='klugi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='crisia' OR junior_species='crisia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dismorphia' AND (species='crisia' OR species='crisia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dismorphia' AND (species='crisia' OR species='crisia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='crisia' OR junior_species='crisia')SELECT d.diet,d.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='crisia' OR species='crisia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doberes' AND (junior_species='anticus' OR junior_species='anticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doberes' AND (species='anticus' OR species='anticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doberes' AND (species='anticus' OR species='anticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doberes' AND (junior_species='anticus' OR junior_species='anticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Doberes' AND (species='anticus' OR species='anticus') 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='Echinargus' AND (junior_species='isola' OR junior_species='isola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Echinargus' AND (species='isola' OR species='isola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Echinargus' AND (species='isola' OR species='isola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Echinargus' AND (junior_species='isola' OR junior_species='isola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Echinargus' AND (species='isola' OR species='isola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Electrostrymon' AND (junior_species='sangala' OR junior_species='sangala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Electrostrymon' AND (species='sangala' OR species='sangala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Electrostrymon' AND (species='sangala' OR species='sangala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Electrostrymon' AND (junior_species='sangala' OR junior_species='sangala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Electrostrymon' AND (species='sangala' OR species='sangala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enantia' AND (junior_species='jethys' OR junior_species='jethys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enantia' AND (species='jethys' OR species='jethys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enantia' AND (species='jethys' OR species='jethys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enantia' AND (junior_species='jethys' OR junior_species='jethys')SELECT d.diet,d.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='jethys' OR species='jethys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epargyreus' AND (junior_species='aspina' OR junior_species='aspina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epargyreus' AND (species='aspina' OR species='aspina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epargyreus' AND (species='aspina' OR species='aspina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epargyreus' AND (junior_species='aspina' OR junior_species='aspina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epargyreus' AND (species='aspina' OR species='aspina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erynnis' AND (junior_species='tristis' OR junior_species='tristis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erynnis' AND (species='tristis' OR species='tristis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erynnis' AND (species='tristis' OR species='tristis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erynnis' AND (junior_species='tristis' OR junior_species='tristis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erynnis' AND (species='tristis' OR species='tristis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='monima' OR junior_species='monima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='monima' OR species='monima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='monima' OR species='monima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='monima' OR junior_species='monima')SELECT d.diet,d.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='monima' OR species='monima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptoieta' AND (junior_species='claudia' OR junior_species='claudia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptoieta' AND (species='claudia' OR species='claudia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptoieta' AND (species='claudia' OR species='claudia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptoieta' AND (junior_species='claudia' OR junior_species='claudia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euptoieta' AND (species='claudia' OR species='claudia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptoieta' AND (junior_species='hegesia' OR junior_species='hegesia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euptoieta' AND (species='hegesia' OR species='hegesia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euptoieta' AND (species='hegesia' OR species='hegesia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euptoieta' AND (junior_species='hegesia' OR junior_species='hegesia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euptoieta' AND (species='hegesia' OR species='hegesia') 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='Eurema' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='mexicana' OR species='mexicana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='mexicana' OR species='mexicana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT d.diet,d.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='mexicana' OR species='mexicana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='salome' OR junior_species='salome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='salome' OR species='salome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='salome' OR species='salome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='salome' OR junior_species='salome')SELECT d.diet,d.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='salome' OR species='salome') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='glycerium' OR junior_species='glycerium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fountainea' AND (species='glycerium' OR species='glycerium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fountainea' AND (species='glycerium' OR species='glycerium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='glycerium' OR junior_species='glycerium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fountainea' AND (species='glycerium' OR species='glycerium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ganyra' AND (junior_species='josephina' OR junior_species='josephina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ganyra' AND (species='josephina' OR species='josephina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ganyra' AND (species='josephina' OR species='josephina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ganyra' AND (junior_species='josephina' OR junior_species='josephina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ganyra' AND (species='josephina' OR species='josephina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Greta' AND (junior_species='annette' OR junior_species='annette')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Greta' AND (species='annette' OR species='annette') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Greta' AND (species='annette' OR species='annette')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Greta' AND (junior_species='annette' OR junior_species='annette')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Greta' AND (species='annette' OR species='annette') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='februa' OR junior_species='februa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='februa' OR species='februa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='februa' OR species='februa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='februa' OR junior_species='februa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='februa' OR species='februa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='charithonia' OR junior_species='charithonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='charithonia' OR species='charithonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='charithonia' OR species='charithonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='charithonia' OR junior_species='charithonia')SELECT d.diet,d.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='charithonia' OR species='charithonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='hortense' OR junior_species='hortense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='hortense' OR species='hortense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='hortense' OR species='hortense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='hortense' OR junior_species='hortense')SELECT d.diet,d.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='hortense' OR species='hortense') 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='Heraclides' AND (junior_species='thoas' OR junior_species='thoas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='thoas' OR species='thoas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='thoas' OR species='thoas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='thoas' OR junior_species='thoas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heraclides' AND (species='thoas' OR species='thoas') 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='Hypanartia' AND (junior_species='godmanii' OR junior_species='godmani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypanartia' AND (species='godmanii' OR species='godmani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypanartia' AND (species='godmanii' OR species='godmani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='godmanii' OR junior_species='godmani')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypanartia' AND (species='godmanii' OR species='godmani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoleria' AND (junior_species='lavinia' OR junior_species='lavinia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoleria' AND (species='lavinia' OR species='lavinia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoleria' AND (species='lavinia' OR species='lavinia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoleria' AND (junior_species='lavinia' OR junior_species='lavinia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoleria' AND (species='lavinia' OR species='lavinia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jonaspyge' AND (junior_species='jonas' OR junior_species='jonas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jonaspyge' AND (species='jonas' OR species='jonas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jonaspyge' AND (species='jonas' OR species='jonas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jonaspyge' AND (junior_species='jonas' OR junior_species='jonas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jonaspyge' AND (species='jonas' OR species='jonas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laothus' AND (junior_species='barajo' OR junior_species='barajo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laothus' AND (species='barajo' OR species='barajo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laothus' AND (species='barajo' OR species='barajo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laothus' AND (junior_species='barajo' OR junior_species='barajo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Laothus' AND (species='barajo' OR species='barajo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='aripa' OR junior_species='aripa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophobia' AND (species='aripa' OR species='aripa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophobia' AND (species='aripa' OR species='aripa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophobia' AND (junior_species='aripa' OR junior_species='aripa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptophobia' AND (species='aripa' OR species='aripa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='marina' OR junior_species='marina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotes' AND (species='marina' OR species='marina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotes' AND (species='marina' OR species='marina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='marina' OR junior_species='marina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptotes' AND (species='marina' OR species='marina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerema' AND (junior_species='accius' OR junior_species='accius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lerema' AND (species='accius' OR species='accius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lerema' AND (species='accius' OR species='accius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerema' AND (junior_species='accius' OR junior_species='accius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lerema' AND (species='accius' OR species='accius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerema' AND (junior_species='lumina' OR junior_species='lumina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lerema' AND (species='lumina' OR species='lumina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lerema' AND (species='lumina' OR species='lumina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lerema' AND (junior_species='lumina' OR junior_species='lumina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lerema' AND (species='lumina' OR species='lumina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Librita' AND (junior_species='librita' OR junior_species='librita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Librita' AND (species='librita' OR species='librita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Librita' AND (species='librita' OR species='librita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Librita' AND (junior_species='librita' OR junior_species='librita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Librita' AND (species='librita' OR species='librita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lieinix' AND (junior_species='nemesis' OR junior_species='nemesis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lieinix' AND (species='nemesis' OR species='nemesis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lieinix' AND (species='nemesis' OR species='nemesis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lieinix' AND (junior_species='nemesis' OR junior_species='nemesis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lieinix' AND (species='nemesis' OR species='nemesis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='chiron' OR junior_species='chiron')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpesia' AND (species='chiron' OR species='chiron') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpesia' AND (species='chiron' OR species='chiron')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='chiron' OR junior_species='chiron')SELECT d.diet,d.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='chiron' OR species='chiron') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='petreus' OR junior_species='petreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpesia' AND (species='petreus' OR species='petreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpesia' AND (species='petreus' OR species='petreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='petreus' OR junior_species='petreus')SELECT d.diet,d.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='petreus' OR species='petreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='zerynthia' OR junior_species='zerynthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpesia' AND (species='zerynthia' OR species='zerynthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpesia' AND (species='zerynthia' OR species='zerynthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='zerynthia' OR junior_species='zerynthia')SELECT d.diet,d.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='zerynthia' OR species='zerynthia') 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='Melanis' AND (junior_species='pixe' OR junior_species='pixe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanis' AND (species='pixe' OR species='pixe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanis' AND (species='pixe' OR species='pixe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanis' AND (junior_species='pixe' OR junior_species='pixe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanis' AND (species='pixe' OR species='pixe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mestra' AND (junior_species='dorcas' OR junior_species='dorcas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mestra' AND (species='dorcas' OR species='dorcas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mestra' AND (species='dorcas' OR species='dorcas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mestra' AND (junior_species='dorcas' OR junior_species='dorcas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mestra' AND (species='dorcas' OR species='dorcas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Methion' AND (junior_species='melas' OR junior_species='melas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Methion' AND (species='melas' OR species='melas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Methion' AND (species='melas' OR species='melas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Methion' AND (junior_species='melas' OR junior_species='melas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Methion' AND (species='melas' OR species='melas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Morpho' AND (species='helenor' OR species='helenor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Morpho' AND (junior_species='helenor' OR junior_species='helenor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Morpho' AND (species='helenor' OR species='helenor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nathalis' AND (junior_species='iole' OR junior_species='iole')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nathalis' AND (species='iole' OR species='iole') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nathalis' AND (species='iole' OR species='iole')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nathalis' AND (junior_species='iole' OR junior_species='iole')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nathalis' AND (species='iole' OR species='iole') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niconiades' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Niconiades' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Niconiades' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niconiades' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Niconiades' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuana' AND (junior_species='lactifera' OR junior_species='lactifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuana' AND (species='lactifera' OR species='lactifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuana' AND (species='lactifera' OR species='lactifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuana' AND (junior_species='lactifera' OR junior_species='lactifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuana' AND (species='lactifera' OR species='lactifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuana' AND (junior_species='stator' OR junior_species='stator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuana' AND (species='stator' OR species='stator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuana' AND (species='stator' OR species='stator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuana' AND (junior_species='stator' OR junior_species='stator')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuana' AND (species='stator' OR species='stator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxeoschistus' AND (junior_species='tauropolis' OR junior_species='tauropolis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxeoschistus' AND (species='tauropolis' OR species='tauropolis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxeoschistus' AND (species='tauropolis' OR species='tauropolis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxeoschistus' AND (junior_species='tauropolis' OR junior_species='tauropolis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxeoschistus' AND (species='tauropolis' OR species='tauropolis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthiades' AND (junior_species='bathildis' OR junior_species='bathildis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthiades' AND (species='bathildis' OR species='bathildis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panthiades' AND (species='bathildis' OR species='bathildis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthiades' AND (junior_species='bathildis' OR junior_species='bathildis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Panthiades' AND (species='bathildis' OR species='bathildis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papias' AND (junior_species='dictys' OR junior_species='dictys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papias' AND (species='dictys' OR species='dictys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papias' AND (species='dictys' OR species='dictys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papias' AND (junior_species='dictys' OR junior_species='dictys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papias' AND (species='dictys' OR species='dictys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polyxenes' OR junior_species='polyxenes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='polyxenes' OR species='polyxenes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='polyxenes' OR species='polyxenes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polyxenes' OR junior_species='polyxenes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='polyxenes' OR species='polyxenes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='photinus' OR junior_species='photinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parides' AND (species='photinus' OR species='photinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parides' AND (species='photinus' OR species='photinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='photinus' OR junior_species='photinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parides' AND (species='photinus' OR species='photinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parrhasius' AND (junior_species='moctezuma' OR junior_species='moctezuma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parrhasius' AND (species='moctezuma' OR species='moctezuma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parrhasius' AND (species='moctezuma' OR species='moctezuma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parrhasius' AND (junior_species='moctezuma' OR junior_species='moctezuma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parrhasius' AND (species='moctezuma' OR species='moctezuma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pereute' AND (junior_species='charops' OR junior_species='charops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pereute' AND (species='charops' OR species='charops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pereute' AND (species='charops' OR species='charops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pereute' AND (junior_species='charops' OR junior_species='charops')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pereute' AND (species='charops' OR species='charops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phocides' AND (junior_species='urania' OR junior_species='urania')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phocides' AND (species='urania' OR species='urania') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phocides' AND (species='urania' OR species='urania')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phocides' AND (junior_species='urania' OR junior_species='urania')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phocides' AND (species='urania' OR species='urania') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='agarithe' OR junior_species='agarithe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='agarithe' OR species='agarithe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='agarithe' OR species='agarithe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='agarithe' OR junior_species='agarithe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoebis' AND (species='agarithe' OR species='agarithe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='neocypris' OR junior_species='neocypris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='neocypris' OR species='neocypris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='neocypris' OR species='neocypris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='neocypris' OR junior_species='neocypris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoebis' AND (species='neocypris' OR species='neocypris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='sennae' OR junior_species='sennae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='sennae' OR species='sennae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='sennae' OR species='sennae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='sennae' OR junior_species='sennae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoebis' AND (species='sennae' OR species='sennae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poanes' AND (junior_species='inimica' OR junior_species='inimica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poanes' AND (species='inimica' OR species='inimica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poanes' AND (species='inimica' OR species='inimica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poanes' AND (junior_species='inimica' OR junior_species='inimica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poanes' AND (species='inimica' OR species='inimica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poanes' AND (junior_species='melane' OR junior_species='melane')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poanes' AND (species='melane' OR species='melane') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poanes' AND (species='melane' OR species='melane')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poanes' AND (junior_species='melane' OR junior_species='melane')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poanes' AND (species='melane' OR species='melane') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poanes' AND (junior_species='zabulon' OR junior_species='zabulon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poanes' AND (species='zabulon' OR species='zabulon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poanes' AND (species='zabulon' OR species='zabulon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poanes' AND (junior_species='zabulon' OR junior_species='zabulon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poanes' AND (species='zabulon' OR species='zabulon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pompeius' AND (junior_species='pompeius' OR junior_species='pompeius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pompeius' AND (species='pompeius' OR species='pompeius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pompeius' AND (species='pompeius' OR species='pompeius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pompeius' AND (junior_species='pompeius' OR junior_species='pompeius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pompeius' AND (species='pompeius' OR species='pompeius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protographium' AND (junior_species='epidaus' OR junior_species='epidaus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protographium' AND (species='epidaus' OR species='epidaus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protographium' AND (species='epidaus' OR species='epidaus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protographium' AND (junior_species='epidaus' OR junior_species='epidaus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protographium' AND (species='epidaus' OR species='epidaus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterourus' AND (junior_species='garamas' OR junior_species='garamas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterourus' AND (species='garamas' OR species='garamas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterourus' AND (species='garamas' OR species='garamas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterourus' AND (junior_species='garamas' OR junior_species='garamas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterourus' AND (species='garamas' OR species='garamas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterourus' AND (junior_species='menatius' OR junior_species='menatius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterourus' AND (species='menatius' OR species='menatius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterourus' AND (species='menatius' OR species='menatius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterourus' AND (junior_species='menatius' OR junior_species='menatius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterourus' AND (species='menatius' OR species='menatius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='communis' OR junior_species='communis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgus' AND (species='communis' OR species='communis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgus' AND (species='communis' OR species='communis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='communis' OR junior_species='communis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrgus' AND (species='communis' OR species='communis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='oileus' OR junior_species='oileus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgus' AND (species='oileus' OR species='oileus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgus' AND (species='oileus' OR species='oileus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='oileus' OR junior_species='oileus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrgus' AND (species='oileus' OR species='oileus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrisitia' AND (junior_species='dina' OR junior_species='dina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrisitia' AND (species='dina' OR species='dina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrisitia' AND (species='dina' OR species='dina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrisitia' AND (junior_species='dina' OR junior_species='dina')SELECT d.diet,d.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='dina' OR species='dina') 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='Pyrisitia' AND (junior_species='proterpia' OR junior_species='proterpia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrisitia' AND (species='proterpia' OR species='proterpia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrisitia' AND (species='proterpia' OR species='proterpia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrisitia' AND (junior_species='proterpia' OR junior_species='proterpia')SELECT d.diet,d.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='proterpia' OR species='proterpia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quasimellana' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quasimellana' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quasimellana' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quasimellana' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quasimellana' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quinta' AND (junior_species='cannae' OR junior_species='cannae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quinta' AND (species='cannae' OR species='cannae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quinta' AND (species='cannae' OR species='cannae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quinta' AND (junior_species='cannae' OR junior_species='cannae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quinta' AND (species='cannae' OR species='cannae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rekoa' AND (junior_species='menton' OR junior_species='menton')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rekoa' AND (species='menton' OR species='menton') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rekoa' AND (species='menton' OR species='menton')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rekoa' AND (junior_species='menton' OR junior_species='menton')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rekoa' AND (species='menton' OR species='menton') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Remella' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Remella' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Remella' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Remella' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Remella' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Satyrotaygetis' AND (junior_species='satyrina' OR junior_species='satyrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Satyrotaygetis' AND (species='satyrina' OR species='satyrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Satyrotaygetis' AND (species='satyrina' OR species='satyrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Satyrotaygetis' AND (junior_species='satyrina' OR junior_species='satyrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Satyrotaygetis' AND (species='satyrina' OR species='satyrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siproeta' AND (junior_species='epaphus' OR junior_species='epaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siproeta' AND (species='epaphus' OR species='epaphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siproeta' AND (species='epaphus' OR species='epaphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siproeta' AND (junior_species='epaphus' OR junior_species='epaphus')SELECT d.diet,d.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='epaphus' OR species='epaphus') 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='Smyrna' AND (junior_species='blomfildia' OR junior_species='blomfildia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Smyrna' AND (species='blomfildia' OR species='blomfildia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Smyrna' AND (species='blomfildia' OR species='blomfildia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smyrna' AND (junior_species='blomfildia' OR junior_species='blomfildia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Smyrna' AND (species='blomfildia' OR species='blomfildia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='cestri' OR junior_species='cestrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='cestri' OR species='cestrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='cestri' OR species='cestrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='cestri' OR junior_species='cestrii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strymon' AND (species='cestri' OR species='cestrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='melinus' OR junior_species='melinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='melinus' OR species='melinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='melinus' OR species='melinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='melinus' OR junior_species='melinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strymon' AND (species='melinus' OR species='melinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synapte' AND (junior_species='salenus' OR junior_species='salenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synapte' AND (species='salenus' OR species='salenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synapte' AND (species='salenus' OR species='salenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synapte' AND (junior_species='salenus' OR junior_species='salenus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synapte' AND (species='salenus' OR species='salenus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='anieta' OR junior_species='anieta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tegosa' AND (species='anieta' OR species='anieta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tegosa' AND (species='anieta' OR species='anieta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='anieta' OR junior_species='anieta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tegosa' AND (species='anieta' OR species='anieta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theagenes' AND (junior_species='aegides' OR junior_species='aegides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theagenes' AND (species='aegides' OR species='aegides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theagenes' AND (species='aegides' OR species='aegides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theagenes' AND (junior_species='aegides' OR junior_species='aegides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Theagenes' AND (species='aegides' OR species='aegides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thecla' AND (junior_species='maeonis' OR junior_species='maeonis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thecla' AND (species='maeonis' OR species='maeonis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thecla' AND (species='maeonis' OR species='maeonis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thecla' AND (junior_species='maeonis' OR junior_species='maeonis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thecla' AND (species='maeonis' OR species='maeonis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tmolus' AND (junior_species='crolinus' OR junior_species='crolinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tmolus' AND (species='crolinus' OR species='crolinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tmolus' AND (species='crolinus' OR species='crolinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tmolus' AND (junior_species='crolinus' OR junior_species='crolinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tmolus' AND (species='crolinus' OR species='crolinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='prodicus' OR junior_species='prodicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='prodicus' OR species='prodicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='prodicus' OR species='prodicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='prodicus' OR junior_species='prodicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urbanus' AND (species='prodicus' OR species='prodicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='simplicius' OR junior_species='simplicius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='simplicius' OR species='simplicius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='simplicius' OR species='simplicius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='simplicius' OR junior_species='simplicius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urbanus' AND (species='simplicius' OR species='simplicius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='teleus' OR junior_species='teleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='teleus' OR species='teleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='teleus' OR species='teleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='teleus' OR junior_species='teleus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Urbanus' AND (species='teleus' OR species='teleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='annabella' OR junior_species='annabella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='annabella' OR species='annabella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='annabella' OR species='annabella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='annabella' OR junior_species='annabella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vanessa' AND (species='annabella' OR species='annabella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='virginiensis' OR junior_species='virginiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='virginiensis' OR species='virginiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='virginiensis' OR species='virginiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='virginiensis' OR junior_species='virginiensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vanessa' AND (species='virginiensis' OR species='virginiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vehilius' AND (junior_species='inca' OR junior_species='inca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vehilius' AND (species='inca' OR species='inca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vehilius' AND (species='inca' OR species='inca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vehilius' AND (junior_species='inca' OR junior_species='inca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vehilius' AND (species='inca' OR species='inca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='renata' OR junior_species='renata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='renata' OR species='renata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='renata' OR species='renata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='renata' OR junior_species='renata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Yphthimoides' AND (species='renata' OR species='renata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zerene' AND (junior_species='cesonia' OR junior_species='cesonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zerene' AND (species='cesonia' OR species='cesonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zerene' AND (species='cesonia' OR species='cesonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zerene' AND (junior_species='cesonia' OR junior_species='cesonia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zerene' AND (species='cesonia' OR species='cesonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ziegleria' AND (junior_species='ceromia' OR junior_species='ceromia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ziegleria' AND (species='ceromia' OR species='ceromia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ziegleria' AND (species='ceromia' OR species='ceromia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ziegleria' AND (junior_species='ceromia' OR junior_species='ceromia')SELECT d.diet,d.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='ceromia' OR species='ceromia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizula' AND (junior_species='cyna' OR junior_species='cyna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizula' AND (species='cyna' OR species='cyna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizula' AND (species='cyna' OR species='cyna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizula' AND (junior_species='cyna' OR junior_species='cyna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zizula' AND (species='cyna' OR species='cyna') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1185 The Ecological Register: Coapilla
Coapilla
Basic information
Sample name: Coapilla

Reference: Y. del Rocío Balam-Ballote and J. L. León-Cortés. 2010. Forest management and biodiversity: A study of an indicator insect group in Southern Mexico. Interciencia 35(7):526-533 [ER 836]
Geography
Country: Mexico

State: Chiapas


Coordinate: 17° 8' 6" N, 93° 9' 5" W
Coordinate basis: stated in text as range

Geography comments: coordinate is the midpoint of ranges stated in text

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

Disturbance: selective logging

WMT: 28.8

CMT: 22.4

MAP: 1800.0

Habitat comments: "warm and humid with heavy summer rains... mostly cloud forest habitats, but... 16%... has now been converted into forest stands that include different successional stages, which mostly result from logging"
MAP stated in text; CMT and WMT based on station 76741 (Coatzacoalcos), which has almost the same MAP

Methods
Life forms: butterflies

Site length: 8500

Sampling methods: line transect,butterfly nets,visual

Sample size: 9413 individuals

Years: 2007

Sampling comments: 12 transects in 9 forest stands totalling 8500 m; sampling effort not stated
mostly visual but some species caught with "aerial nets"

Metadata
Sample number: 1185

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-10-02 20:14:58

Modified: 2014-10-02 10:14:58

Abundance distribution
142 species
33 singletons
total count 9413
extrapolated richness: 228.1
Fisher's α: 23.722
geometric series k: 0.9396
Hurlbert's PIE: 0.5140
Shannon's H: 1.7426
Good's u: 0.9965
Each square represents a species. Square sizes are proportional to counts.
Register
Abaeis nicippe4
Achlyodes pallida8
Adelpha iphicleola iphicleola12
Adelpha leuceria leuceria9
Adelpha pithys13
Agraulis vallinae incarnata1
Altinote ozomene nox3
Anartia fatima fatima1
Ancyloxypha numitor3
Anteos clorinde2
Anteos maerula2
Anthanassa ardys ardys2
Anthanassa drusilla leeles5
Anthanassa otanes otanes2
Anthanassa aff. ptolyca ptolyca2
Anthanassa texana texana2
Aphrissa statira statira1
Apuecla maeonis1
Astraptes fulgerator4
Autochton cellus24
Autochton vectilucis69
Autochton sp.52
Biblis hyperia aganisa2
Calephelis sp.31
Caligo uranus2
Calycopis clarina1
Calycopis isobeon21
Catasticta flisa flisa12
Phoebis philea philea19
Catasticta nimbice nimbice28
Catasticta teutila flavifaciata1
Celastrina argiolus gozora20
Chlosyne erodyle erodyle17
Chlosyne janais janais14
Chlosyne aff. marina2
Cissia pompilia2
Consul excellens genini2
Cupido comyntas58
Cyllopsis hedemanni hedemanni27
Cyllopsis hilaria3
Danaus gilippus thersippus13
Danaus plexippus plexippus6
Denivia augustinula2
Diaethria anna anna28
Diaethria pandama1
Dione juno huascuma18
Dione moneta poeyii86
Dircenna klugii klugii38
Dismorphia crisia virgo27
Doberes anticus1
Dryas iulia moderata10
Echinargus isola2
Electrostrymon sangala1
Enantia jethys10
Epargyreus aspina6
Erynnis tristis tatius3
Eunica monima6522
Euptoieta claudia daunius3
Euptoieta hegesia meridiania32
Eurema albula celata2
Eurema daira eugenia42
Eurema mexicana mexicana271
Eurema salome jamapa244
Fountainea glycerium glycerium1
Ganyra josephina josepha1
Greta annette annette28
Hamadryas februa ferentina8
Heliconius charithonia vazquezae25
Heliconius hortense20
Hemiargus hanno antibubastus2
Heraclides thoas autocles4
Hermeuptychia hermes554
Hypanartia godmanii6
Hypoleria lavinia cassotis31
Jonaspyge jonas17
Laothus barajo1
Leptophobia aripa elodia20
Leptotes marina2
Lerema accius accius3
Lerema lumina20
Librita librita1
Lieinix nemesis atthis1
Marpesia chiron marius6
Marpesia petreus13
Marpesia zerynthia dentigera1
Mechanitis polymnia lycidice3
Melanis pixe pixe1
Mestra dorcas amymone17
Methion aff. melas27
Morpho helenor montezuma2
Nathalis iole9
Niconiades sp.2
Noctuana lactifera bipuncta1
Noctuana stator1
Oxeoschistus tauropolis tauropolis1
Panthiades bathildis1
Papias aff. dictys9
Papilio polyxenes asterius1
Parides photinus114
Parrhasius moctezuma1
Pereute charops nigricans13
Phocides urania urania1
Phoebis agarithe agarithe64
Phoebis neocypris virgo9
Phoebis sennae marcellina9
Poanes inimica12
Poanes melane32
Poanes zabulon40
Pompeius pompeius4
Protographium epidaus epidaus4
Pterourus garamas electryon4
Pterourus menatius victorinus1
Pyrgus communis4
Pyrgus oileus25
Pyrisitia dina westwoodi3
Pyrisitia nise nelphe107
Pyrisitia proterpia31
Quasimellana sp.2
Quinta cannae1
Rekoa menton1
Remella sp.8
Satyrotaygetis satyrina57
Siproeta epaphus epaphus33
Siproeta stelenes biplagiata1
Smyrna blomfildia datis5
Strymon cestri1
Strymon melinus1
Synapte salenus1
Tegosa anieta cluvia10
Theagenes aegides1
Thecla maeonis1
Tmolus crolinus1
Urbanus prodicus46
Urbanus simplicius6
Urbanus teleus7
Vanessa annabella4
Vanessa virginiensis20
Vehilius inca2
Yphthimoides renata3
Zerene cesonia cesonia2
Ziegleria ceromia2
Zizula cyna27