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=1183 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1183SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=834SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1183 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='alardus' OR junior_species='alardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astraptes' AND (species='alardus' OR species='alardus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astraptes' AND (species='alardus' OR species='alardus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='alardus' OR junior_species='alardus')SELECT d.diet,d.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='alardus' OR species='alardus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='aulus' OR junior_species='aulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astraptes' AND (species='aulus' OR species='aulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astraptes' AND (species='aulus' OR species='aulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astraptes' AND (junior_species='aulus' OR junior_species='aulus')SELECT d.diet,d.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='aulus' OR species='aulus') 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='zarex' OR junior_species='zarex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Autochton' AND (species='zarex' OR species='zarex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Autochton' AND (species='zarex' OR species='zarex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autochton' AND (junior_species='zarex' OR junior_species='zarex')SELECT d.diet,d.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='zarex' OR species='zarex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonus' AND (junior_species='leo' OR junior_species='leo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polygonus' AND (species='leo' OR species='leo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonus' AND (species='leo' OR species='leo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonus' AND (junior_species='leo' OR junior_species='leo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polygonus' AND (species='leo' OR species='leo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonus' AND (junior_species='savigny' OR junior_species='savigny')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polygonus' AND (species='savigny' OR species='savigny') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonus' AND (species='savigny' OR species='savigny')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonus' AND (junior_species='savigny' OR junior_species='savigny')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polygonus' AND (species='savigny' OR species='savigny') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spathilepia' AND (junior_species='clonius' OR junior_species='clonius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spathilepia' AND (species='clonius' OR species='clonius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spathilepia' AND (species='clonius' OR species='clonius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spathilepia' AND (junior_species='clonius' OR junior_species='clonius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spathilepia' AND (species='clonius' OR species='clonius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='albimargo' OR junior_species='albimargo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='albimargo' OR species='albimargo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='albimargo' OR species='albimargo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='albimargo' OR junior_species='albimargo')SELECT d.diet,d.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='albimargo' OR species='albimargo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='dorantes' OR junior_species='dorantes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='dorantes' OR species='dorantes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='dorantes' OR species='dorantes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='dorantes' OR junior_species='dorantes')SELECT d.diet,d.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='dorantes' OR species='dorantes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='doryssus' OR junior_species='doryssus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='doryssus' OR species='doryssus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='doryssus' OR species='doryssus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='doryssus' OR junior_species='doryssus')SELECT d.diet,d.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='doryssus' OR species='doryssus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='esta' OR junior_species='esta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='esta' OR species='esta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='esta' OR species='esta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='esta' OR junior_species='esta')SELECT d.diet,d.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='esta' OR species='esta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='evenus' OR junior_species='evenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='evenus' OR species='evenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='evenus' OR species='evenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='evenus' OR junior_species='evenus')SELECT d.diet,d.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='evenus' OR species='evenus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='pronta' OR junior_species='pronta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='pronta' OR species='pronta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='pronta' OR species='pronta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='pronta' OR junior_species='pronta')SELECT d.diet,d.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='pronta' OR species='pronta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='proteus' OR junior_species='proteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='proteus' OR species='proteus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='proteus' OR species='proteus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='proteus' OR junior_species='proteus')SELECT d.diet,d.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='proteus' OR species='proteus') 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='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='Urbanus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' 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='Urbanus' AND (species='sp.' OR species='sp.') 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='Urbanus' AND (junior_species='virescens' OR junior_species='virescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urbanus' AND (species='virescens' OR species='virescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urbanus' AND (species='virescens' OR species='virescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urbanus' AND (junior_species='virescens' OR junior_species='virescens')SELECT d.diet,d.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='virescens' OR species='virescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthoptus' AND (junior_species='epictetus' OR junior_species='epictetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthoptus' AND (species='epictetus' OR species='epictetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthoptus' AND (species='epictetus' OR species='epictetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthoptus' AND (junior_species='epictetus' OR junior_species='epictetus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthoptus' AND (species='epictetus' OR species='epictetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corticea' AND (junior_species='corticea' OR junior_species='corticea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corticea' AND (species='corticea' OR species='corticea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corticea' AND (species='corticea' OR species='corticea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corticea' AND (junior_species='corticea' OR junior_species='corticea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corticea' AND (species='corticea' OR species='corticea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synapte' AND (junior_species='silius' OR junior_species='silius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synapte' AND (species='silius' OR species='silius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synapte' AND (species='silius' OR species='silius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synapte' AND (junior_species='silius' OR junior_species='silius')SELECT d.diet,d.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='silius' OR species='silius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evansiella' AND (junior_species='cordela' OR junior_species='cordela')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Evansiella' AND (species='cordela' OR species='cordela') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evansiella' AND (species='cordela' OR species='cordela')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evansiella' AND (junior_species='cordela' OR junior_species='cordela')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Evansiella' AND (species='cordela' OR species='cordela') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lychnuchoides' AND (junior_species='ozias' OR junior_species='ozias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lychnuchoides' AND (species='ozias' OR species='ozias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lychnuchoides' AND (species='ozias' OR species='ozias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lychnuchoides' AND (junior_species='ozias' OR junior_species='ozias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lychnuchoides' AND (species='ozias' OR species='ozias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saliana' AND (junior_species='longirostris' OR junior_species='longirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saliana' AND (species='longirostris' OR species='longirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saliana' AND (species='longirostris' OR species='longirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saliana' AND (junior_species='longirostris' OR junior_species='longirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Saliana' AND (species='longirostris' OR species='longirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenis' AND (junior_species='jebus' OR junior_species='jebus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zenis' AND (species='jebus' OR species='jebus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zenis' AND (species='jebus' OR species='jebus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenis' AND (junior_species='jebus' OR junior_species='jebus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zenis' AND (species='jebus' OR species='jebus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylephila' AND (junior_species='phyleus' OR junior_species='phyleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylephila' AND (species='phyleus' OR species='phyleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylephila' AND (species='phyleus' OR species='phyleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylephila' AND (junior_species='phyleus' OR junior_species='phyleus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylephila' AND (species='phyleus' OR species='phyleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctelius' AND (junior_species='nyctelius' OR junior_species='nyctelius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctelius' AND (species='nyctelius' OR species='nyctelius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctelius' AND (species='nyctelius' OR species='nyctelius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctelius' AND (junior_species='nyctelius' OR junior_species='nyctelius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nyctelius' AND (species='nyctelius' OR species='nyctelius') 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='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='Thespieus' AND (junior_species='ethemides' OR junior_species='ethemides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thespieus' AND (species='ethemides' OR species='ethemides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thespieus' AND (species='ethemides' OR species='ethemides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thespieus' AND (junior_species='ethemides' OR junior_species='ethemides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thespieus' AND (species='ethemides' OR species='ethemides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vacerra' AND (junior_species='bonfilius' OR junior_species='bonfilius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vacerra' AND (species='bonfilius' OR species='bonfilius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vacerra' AND (species='bonfilius' OR species='bonfilius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vacerra' AND (junior_species='bonfilius' OR junior_species='bonfilius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vacerra' AND (species='bonfilius' OR species='bonfilius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wallengrenia' AND (junior_species='premnas' OR junior_species='premnas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wallengrenia' AND (species='premnas' OR species='premnas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wallengrenia' AND (species='premnas' OR species='premnas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wallengrenia' AND (junior_species='premnas' OR junior_species='premnas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Wallengrenia' AND (species='premnas' OR species='premnas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycas' AND (junior_species='argentea' OR junior_species='argentea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycas' AND (species='argentea' OR species='argentea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycas' AND (species='argentea' OR species='argentea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycas' AND (junior_species='argentea' OR junior_species='argentea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lycas' AND (species='argentea' OR species='argentea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arita' AND (junior_species='mubevensis' OR junior_species='mubevensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arita' AND (species='mubevensis' OR species='mubevensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arita' AND (species='mubevensis' OR species='mubevensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arita' AND (junior_species='mubevensis' OR junior_species='mubevensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arita' AND (species='mubevensis' OR species='mubevensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callimormus' AND (junior_species='rivera' OR junior_species='rivera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callimormus' AND (species='rivera' OR species='rivera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callimormus' AND (species='rivera' OR species='rivera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callimormus' AND (junior_species='rivera' OR junior_species='rivera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callimormus' AND (species='rivera' OR species='rivera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callimormus' AND (junior_species='saturnus' OR junior_species='saturnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callimormus' AND (species='saturnus' OR species='saturnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callimormus' AND (species='saturnus' OR species='saturnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callimormus' AND (junior_species='saturnus' OR junior_species='saturnus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callimormus' AND (species='saturnus' OR species='saturnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callimormus' 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='Callimormus' AND (species='simplicius' OR species='simplicius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callimormus' AND (species='simplicius' OR species='simplicius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callimormus' 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='Callimormus' AND (species='simplicius' OR species='simplicius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cobalopsis' AND (junior_species='miaba' OR junior_species='miaba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cobalopsis' AND (species='miaba' OR species='miaba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cobalopsis' AND (species='miaba' OR species='miaba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cobalopsis' AND (junior_species='miaba' OR junior_species='miaba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cobalopsis' AND (species='miaba' OR species='miaba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cumbre' AND (junior_species='triumviralis' OR junior_species='triumviralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cumbre' AND (species='triumviralis' OR species='triumviralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cumbre' AND (species='triumviralis' OR species='triumviralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cumbre' AND (junior_species='triumviralis' OR junior_species='triumviralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cumbre' AND (species='triumviralis' OR species='triumviralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymaenes' AND (junior_species='gisca' OR junior_species='gisca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymaenes' AND (species='gisca' OR species='gisca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymaenes' AND (species='gisca' OR species='gisca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymaenes' AND (junior_species='gisca' OR junior_species='gisca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymaenes' AND (species='gisca' OR species='gisca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymaenes' AND (junior_species='lepta' OR junior_species='lepta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymaenes' AND (species='lepta' OR species='lepta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymaenes' AND (species='lepta' OR species='lepta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymaenes' AND (junior_species='lepta' OR junior_species='lepta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymaenes' AND (species='lepta' OR species='lepta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymaenes' AND (junior_species='perloides' OR junior_species='perloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymaenes' AND (species='perloides' OR species='perloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymaenes' AND (species='perloides' OR species='perloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymaenes' AND (junior_species='perloides' OR junior_species='perloides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymaenes' AND (species='perloides' OR species='perloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymaenes' 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='Cymaenes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymaenes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymaenes' 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='Cymaenes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eprius' AND (junior_species='veleda' OR junior_species='veleda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eprius' AND (species='veleda' OR species='veleda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eprius' AND (species='veleda' OR species='veleda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eprius' AND (junior_species='veleda' OR junior_species='veleda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eprius' AND (species='veleda' OR species='veleda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lento' AND (junior_species='krexoides' OR junior_species='krexoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lento' AND (species='krexoides' OR species='krexoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lento' AND (species='krexoides' OR species='krexoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lento' AND (junior_species='krexoides' OR junior_species='krexoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lento' AND (species='krexoides' OR species='krexoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lucida' AND (junior_species='ranesus' OR junior_species='ranesus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lucida' AND (species='ranesus' OR species='ranesus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lucida' AND (species='ranesus' OR species='ranesus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lucida' AND (junior_species='ranesus' OR junior_species='ranesus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lucida' AND (species='ranesus' OR species='ranesus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miltomiges' AND (junior_species='cinnamomea' OR junior_species='cinnamomea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miltomiges' AND (species='cinnamomea' OR species='cinnamomea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miltomiges' AND (species='cinnamomea' OR species='cinnamomea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miltomiges' AND (junior_species='cinnamomea' OR junior_species='cinnamomea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Miltomiges' AND (species='cinnamomea' OR species='cinnamomea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moeris' AND (junior_species='striga' OR junior_species='striga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moeris' AND (species='striga' OR species='striga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moeris' AND (species='striga' OR species='striga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moeris' AND (junior_species='striga' OR junior_species='striga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moeris' AND (species='striga' OR species='striga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monca' AND (junior_species='branca' OR junior_species='branca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monca' AND (species='branca' OR species='branca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monca' AND (species='branca' OR species='branca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monca' AND (junior_species='branca' OR junior_species='branca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monca' AND (species='branca' OR species='branca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanes' AND (junior_species='rezia' OR junior_species='rezia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phanes' AND (species='rezia' OR species='rezia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phanes' AND (species='rezia' OR species='rezia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phanes' AND (junior_species='rezia' OR junior_species='rezia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phanes' AND (species='rezia' OR species='rezia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheraeus' AND (junior_species='odilia' OR junior_species='odilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheraeus' AND (species='odilia' OR species='odilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheraeus' AND (species='odilia' OR species='odilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheraeus' AND (junior_species='odilia' OR junior_species='odilia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheraeus' AND (species='odilia' OR species='odilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoralis' AND (junior_species='stacara' OR junior_species='stacara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psoralis' AND (species='stacara' OR species='stacara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psoralis' AND (species='stacara' OR species='stacara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psoralis' AND (junior_species='stacara' OR junior_species='stacara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Psoralis' AND (species='stacara' OR species='stacara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sodalia' AND (junior_species='coler' OR junior_species='coler')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sodalia' AND (species='coler' OR species='coler') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sodalia' AND (species='coler' OR species='coler')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sodalia' AND (junior_species='coler' OR junior_species='coler')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sodalia' AND (species='coler' OR species='coler') 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='Vehilius' AND (junior_species='stictomenes' OR junior_species='stictomenes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vehilius' AND (species='stictomenes' OR species='stictomenes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vehilius' AND (species='stictomenes' OR species='stictomenes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vehilius' AND (junior_species='stictomenes' OR junior_species='stictomenes')SELECT d.diet,d.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='stictomenes' OR species='stictomenes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vettius' AND (junior_species='marcus' OR junior_species='marcus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vettius' AND (species='marcus' OR species='marcus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vettius' AND (species='marcus' OR species='marcus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vettius' AND (junior_species='marcus' OR junior_species='marcus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vettius' AND (species='marcus' OR species='marcus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virga' AND (junior_species='austrinus' OR junior_species='austrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Virga' AND (species='austrinus' OR species='austrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Virga' AND (species='austrinus' OR species='austrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Virga' AND (junior_species='austrinus' OR junior_species='austrinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Virga' AND (species='austrinus' OR species='austrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zariaspes' AND (junior_species='mys' OR junior_species='mys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zariaspes' AND (species='mys' OR species='mys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zariaspes' AND (species='mys' OR species='mys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zariaspes' AND (junior_species='mys' OR junior_species='mys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zariaspes' AND (species='mys' OR species='mys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achlyodes' AND (junior_species='thraso' OR junior_species='thraso')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Achlyodes' AND (species='thraso' OR species='thraso') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Achlyodes' AND (species='thraso' OR species='thraso')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achlyodes' AND (junior_species='thraso' OR junior_species='thraso')SELECT d.diet,d.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='thraso' OR species='thraso') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethilla' AND (junior_species='echina' OR junior_species='echina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethilla' AND (species='echina' OR species='echina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethilla' AND (species='echina' OR species='echina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethilla' AND (junior_species='echina' OR junior_species='echina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aethilla' AND (species='echina' OR species='echina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milanion' AND (junior_species='leucaspis' OR junior_species='leucaspis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Milanion' AND (species='leucaspis' OR species='leucaspis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Milanion' AND (species='leucaspis' OR species='leucaspis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Milanion' AND (junior_species='leucaspis' OR junior_species='leucaspis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Milanion' AND (species='leucaspis' OR species='leucaspis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quadrus' AND (junior_species='cerialis' OR junior_species='cerialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quadrus' AND (species='cerialis' OR species='cerialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quadrus' AND (species='cerialis' OR species='cerialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quadrus' AND (junior_species='cerialis' OR junior_species='cerialis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quadrus' AND (species='cerialis' OR species='cerialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bolla' AND (junior_species='atahuallpai' OR junior_species='atahuallpaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bolla' AND (species='atahuallpai' OR species='atahuallpaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bolla' AND (species='atahuallpai' OR species='atahuallpaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bolla' AND (junior_species='atahuallpai' OR junior_species='atahuallpaii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bolla' AND (species='atahuallpai' OR species='atahuallpaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nisoniades' AND (junior_species='macarius' OR junior_species='macarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nisoniades' AND (species='macarius' OR species='macarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nisoniades' AND (species='macarius' OR species='macarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nisoniades' AND (junior_species='macarius' OR junior_species='macarius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nisoniades' AND (species='macarius' OR species='macarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staphylus' AND (junior_species='incisus' OR junior_species='incisus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Staphylus' AND (species='incisus' OR species='incisus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Staphylus' AND (species='incisus' OR species='incisus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staphylus' AND (junior_species='incisus' OR junior_species='incisus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Staphylus' AND (species='incisus' OR species='incisus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staphylus' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Staphylus' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Staphylus' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staphylus' AND (junior_species='minor' OR junior_species='minor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Staphylus' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staphylus' 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='Staphylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Staphylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staphylus' 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='Staphylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celaenorrhinus' AND (junior_species='similis' OR junior_species='similis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celaenorrhinus' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celaenorrhinus' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celaenorrhinus' AND (junior_species='similis' OR junior_species='similis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celaenorrhinus' AND (species='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erynnis' AND (junior_species='funeralis' OR junior_species='funeralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erynnis' AND (species='funeralis' OR species='funeralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erynnis' AND (species='funeralis' OR species='funeralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erynnis' AND (junior_species='funeralis' OR junior_species='funeralis')SELECT d.diet,d.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='funeralis' OR species='funeralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gorgythion' AND (junior_species='begga' OR junior_species='begga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gorgythion' AND (species='begga' OR species='begga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gorgythion' AND (species='begga' OR species='begga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gorgythion' AND (junior_species='begga' OR junior_species='begga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gorgythion' AND (species='begga' OR species='begga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grais' AND (junior_species='stigmaticus' OR junior_species='stigmaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grais' AND (species='stigmaticus' OR species='stigmaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grais' AND (species='stigmaticus' OR species='stigmaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grais' AND (junior_species='stigmaticus' OR junior_species='stigmaticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Grais' AND (species='stigmaticus' OR species='stigmaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helias' AND (junior_species='phalaenoides' OR junior_species='phalaenoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helias' AND (species='phalaenoides' OR species='phalaenoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helias' AND (species='phalaenoides' OR species='phalaenoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helias' AND (junior_species='phalaenoides' OR junior_species='phalaenoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helias' AND (species='phalaenoides' OR species='phalaenoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mylon' AND (junior_species='maimon' OR junior_species='maimon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mylon' AND (species='maimon' OR species='maimon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mylon' AND (species='maimon' OR species='maimon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mylon' AND (junior_species='maimon' OR junior_species='maimon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mylon' AND (species='maimon' OR species='maimon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sostrata' AND (junior_species='cronion' OR junior_species='cronion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sostrata' AND (species='cronion' OR species='cronion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sostrata' AND (species='cronion' OR species='cronion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sostrata' AND (junior_species='cronion' OR junior_species='cronion')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sostrata' AND (species='cronion' OR species='cronion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antigonus' AND (junior_species='liborius' OR junior_species='liborius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antigonus' AND (species='liborius' OR species='liborius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antigonus' AND (species='liborius' OR species='liborius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antigonus' AND (junior_species='liborius' OR junior_species='liborius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Antigonus' AND (species='liborius' OR species='liborius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carrhenes' AND (junior_species='canescens' OR junior_species='canescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carrhenes' AND (species='canescens' OR species='canescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carrhenes' AND (species='canescens' OR species='canescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carrhenes' AND (junior_species='canescens' OR junior_species='canescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carrhenes' AND (species='canescens' OR species='canescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaeus' AND (junior_species='lacaena' OR junior_species='lacaena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaeus' AND (species='lacaena' OR species='lacaena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaeus' AND (species='lacaena' OR species='lacaena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaeus' AND (junior_species='lacaena' OR junior_species='lacaena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaeus' AND (species='lacaena' OR species='lacaena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='alana' OR junior_species='alana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliopetes' AND (species='alana' OR species='alana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliopetes' AND (species='alana' OR species='alana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='alana' OR junior_species='alana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliopetes' AND (species='alana' OR species='alana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='arsalte' OR junior_species='arsalte')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliopetes' AND (species='arsalte' OR species='arsalte') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliopetes' AND (species='arsalte' OR species='arsalte')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='arsalte' OR junior_species='arsalte')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliopetes' AND (species='arsalte' OR species='arsalte') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='libra' OR junior_species='libra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliopetes' AND (species='libra' OR species='libra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliopetes' AND (species='libra' OR species='libra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='libra' OR junior_species='libra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliopetes' AND (species='libra' OR species='libra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='omrina' OR junior_species='omrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliopetes' AND (species='omrina' OR species='omrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliopetes' AND (species='omrina' OR species='omrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliopetes' AND (junior_species='omrina' OR junior_species='omrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliopetes' AND (species='omrina' OR species='omrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='orcus' OR junior_species='orcus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgus' AND (species='orcus' OR species='orcus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgus' AND (species='orcus' OR species='orcus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='orcus' OR junior_species='orcus')SELECT d.diet,d.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='orcus' OR species='orcus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='orcynoides' OR junior_species='orcynoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgus' AND (species='orcynoides' OR species='orcynoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgus' AND (species='orcynoides' OR species='orcynoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='orcynoides' OR junior_species='orcynoides')SELECT d.diet,d.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='orcynoides' OR species='orcynoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trina' AND (junior_species='geometrina' OR junior_species='geometrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trina' AND (species='geometrina' OR species='geometrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trina' AND (species='geometrina' OR species='geometrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trina' AND (junior_species='geometrina' OR junior_species='geometrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trina' AND (species='geometrina' OR species='geometrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenophanes' AND (junior_species='tryxus' OR junior_species='tryxus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenophanes' AND (species='tryxus' OR species='tryxus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenophanes' AND (species='tryxus' OR species='tryxus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenophanes' AND (junior_species='tryxus' OR junior_species='tryxus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xenophanes' AND (species='tryxus' OR species='tryxus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mysoria' AND (junior_species='barcastus' OR junior_species='barcastus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mysoria' AND (species='barcastus' OR species='barcastus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mysoria' AND (species='barcastus' OR species='barcastus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mysoria' AND (junior_species='barcastus' OR junior_species='barcastus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mysoria' AND (species='barcastus' OR species='barcastus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='cassius' OR junior_species='cassius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotes' AND (species='cassius' OR species='cassius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotes' AND (species='cassius' OR species='cassius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotes' AND (junior_species='cassius' OR junior_species='cassius')SELECT d.diet,d.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='cassius' OR species='cassius') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='ellida' OR junior_species='ellida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arawacus' AND (species='ellida' OR species='ellida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arawacus' AND (species='ellida' OR species='ellida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='ellida' OR junior_species='ellida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arawacus' AND (species='ellida' OR species='ellida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='meliboeus' OR junior_species='meliboeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arawacus' AND (species='meliboeus' OR species='meliboeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arawacus' AND (species='meliboeus' OR species='meliboeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='meliboeus' OR junior_species='meliboeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arawacus' AND (species='meliboeus' OR species='meliboeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='separata' OR junior_species='separata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arawacus' AND (species='separata' OR species='separata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arawacus' AND (species='separata' OR species='separata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arawacus' AND (junior_species='separata' OR junior_species='separata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arawacus' AND (species='separata' OR species='separata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brevianta' AND (junior_species='celelata' OR junior_species='celelata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brevianta' AND (species='celelata' OR species='celelata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brevianta' AND (species='celelata' OR species='celelata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brevianta' AND (junior_species='celelata' OR junior_species='celelata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Brevianta' AND (species='celelata' OR species='celelata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='caulonia' OR junior_species='caulonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calycopis' AND (species='caulonia' OR species='caulonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calycopis' AND (species='caulonia' OR species='caulonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calycopis' AND (junior_species='caulonia' OR junior_species='caulonia')SELECT d.diet,d.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='caulonia' OR species='caulonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celmia' AND (junior_species='celmus' OR junior_species='celmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celmia' AND (species='celmus' OR species='celmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celmia' AND (species='celmus' OR species='celmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celmia' AND (junior_species='celmus' OR junior_species='celmus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celmia' AND (species='celmus' OR species='celmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Contrafacia' AND (junior_species='imma' OR junior_species='imma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Contrafacia' AND (species='imma' OR species='imma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Contrafacia' AND (species='imma' OR species='imma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Contrafacia' AND (junior_species='imma' OR junior_species='imma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Contrafacia' AND (species='imma' OR species='imma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicya' AND (junior_species='eumorpha' OR junior_species='eumorpha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicya' AND (species='eumorpha' OR species='eumorpha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicya' AND (species='eumorpha' OR species='eumorpha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicya' AND (junior_species='eumorpha' OR junior_species='eumorpha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dicya' AND (species='eumorpha' OR species='eumorpha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gargina' AND (junior_species='caninius' OR junior_species='caninius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gargina' AND (species='caninius' OR species='caninius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gargina' AND (species='caninius' OR species='caninius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gargina' AND (junior_species='caninius' OR junior_species='caninius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gargina' AND (species='caninius' OR species='caninius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ignata' AND (junior_species='elana' OR junior_species='elana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ignata' AND (species='elana' OR species='elana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ignata' AND (species='elana' OR species='elana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ignata' AND (junior_species='elana' OR junior_species='elana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ignata' AND (species='elana' OR species='elana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nicolaea' AND (junior_species='cupa' OR junior_species='cupa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nicolaea' AND (species='cupa' OR species='cupa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nicolaea' AND (species='cupa' OR species='cupa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nicolaea' AND (junior_species='cupa' OR junior_species='cupa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nicolaea' AND (species='cupa' OR species='cupa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocaria' AND (junior_species='ocrisia' OR junior_species='ocrisia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocaria' AND (species='ocrisia' OR species='ocrisia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocaria' AND (species='ocrisia' OR species='ocrisia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocaria' AND (junior_species='ocrisia' OR junior_species='ocrisia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ocaria' AND (species='ocrisia' OR species='ocrisia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocaria' AND (junior_species='thales' OR junior_species='thales')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocaria' AND (species='thales' OR species='thales') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocaria' AND (species='thales' OR species='thales')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocaria' AND (junior_species='thales' OR junior_species='thales')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ocaria' AND (species='thales' OR species='thales') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrinotes' AND (junior_species='sophocles' OR junior_species='sophocles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ostrinotes' AND (species='sophocles' OR species='sophocles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ostrinotes' AND (species='sophocles' OR species='sophocles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrinotes' AND (junior_species='sophocles' OR junior_species='sophocles')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ostrinotes' AND (species='sophocles' OR species='sophocles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthiades' AND (junior_species='hebraeus' OR junior_species='hebraeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthiades' AND (species='hebraeus' OR species='hebraeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panthiades' AND (species='hebraeus' OR species='hebraeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthiades' AND (junior_species='hebraeus' OR junior_species='hebraeus')SELECT d.diet,d.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='hebraeus' OR species='hebraeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parrhasius' AND (junior_species='orgia' OR junior_species='orgia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parrhasius' AND (species='orgia' OR species='orgia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parrhasius' AND (species='orgia' OR species='orgia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parrhasius' AND (junior_species='orgia' OR junior_species='orgia')SELECT d.diet,d.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='orgia' OR species='orgia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parrhasius' AND (junior_species='polibetes' OR junior_species='polibetes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parrhasius' AND (species='polibetes' OR species='polibetes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parrhasius' AND (species='polibetes' OR species='polibetes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parrhasius' AND (junior_species='polibetes' OR junior_species='polibetes')SELECT d.diet,d.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='polibetes' OR species='polibetes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rekoa' AND (junior_species='malina' OR junior_species='malina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rekoa' AND (species='malina' OR species='malina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rekoa' AND (species='malina' OR species='malina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rekoa' AND (junior_species='malina' OR junior_species='malina')SELECT d.diet,d.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='malina' OR species='malina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rekoa' AND (junior_species='palegon' OR junior_species='palegon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rekoa' AND (species='palegon' OR species='palegon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rekoa' AND (species='palegon' OR species='palegon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rekoa' AND (junior_species='palegon' OR junior_species='palegon')SELECT d.diet,d.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='palegon' OR species='palegon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siderus' AND (junior_species='eliatha' OR junior_species='eliatha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siderus' AND (species='eliatha' OR species='eliatha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siderus' AND (species='eliatha' OR species='eliatha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siderus' AND (junior_species='eliatha' OR junior_species='eliatha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Siderus' AND (species='eliatha' OR species='eliatha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strephonota' AND (junior_species='ambrax' OR junior_species='ambrax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strephonota' AND (species='ambrax' OR species='ambrax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strephonota' AND (species='ambrax' OR species='ambrax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strephonota' AND (junior_species='ambrax' OR junior_species='ambrax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Strephonota' AND (species='ambrax' OR species='ambrax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='astiocha' OR junior_species='astiocha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='astiocha' OR species='astiocha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='astiocha' OR species='astiocha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='astiocha' OR junior_species='astiocha')SELECT d.diet,d.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='astiocha' OR species='astiocha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='bazochii' OR junior_species='bazochi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='bazochii' OR species='bazochi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='bazochii' OR species='bazochi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='bazochii' OR junior_species='bazochi')SELECT d.diet,d.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='bazochii' OR species='bazochi') 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='eurytulus' OR junior_species='eurytulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='eurytulus' OR species='eurytulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='eurytulus' OR species='eurytulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='eurytulus' OR junior_species='eurytulus')SELECT d.diet,d.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='eurytulus' OR species='eurytulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='megarus' OR junior_species='megarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='megarus' OR species='megarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='megarus' OR species='megarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='megarus' OR junior_species='megarus')SELECT d.diet,d.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='megarus' OR species='megarus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='mulucha' OR junior_species='mulucha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='mulucha' OR species='mulucha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='mulucha' OR species='mulucha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='mulucha' OR junior_species='mulucha')SELECT d.diet,d.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='mulucha' OR species='mulucha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='ziba' OR junior_species='ziba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strymon' AND (species='ziba' OR species='ziba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strymon' AND (species='ziba' OR species='ziba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strymon' AND (junior_species='ziba' OR junior_species='ziba')SELECT d.diet,d.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='ziba' OR species='ziba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbiopsis' AND (junior_species='lenitas' OR junior_species='lenitas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symbiopsis' AND (species='lenitas' OR species='lenitas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symbiopsis' AND (species='lenitas' OR species='lenitas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbiopsis' AND (junior_species='lenitas' OR junior_species='lenitas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Symbiopsis' AND (species='lenitas' OR species='lenitas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theritas' AND (junior_species='chaluma' OR junior_species='chaluma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theritas' AND (species='chaluma' OR species='chaluma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theritas' AND (species='chaluma' OR species='chaluma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theritas' AND (junior_species='chaluma' OR junior_species='chaluma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Theritas' AND (species='chaluma' OR species='chaluma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theritas' AND (junior_species='hemon' OR junior_species='hemon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Theritas' AND (species='hemon' OR species='hemon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theritas' AND (species='hemon' OR species='hemon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theritas' AND (junior_species='hemon' OR junior_species='hemon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Theritas' AND (species='hemon' OR species='hemon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tmolus' AND (junior_species='echion' OR junior_species='echion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tmolus' AND (species='echion' OR species='echion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tmolus' AND (species='echion' OR species='echion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tmolus' AND (junior_species='echion' OR junior_species='echion')SELECT d.diet,d.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='echion' OR species='echion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='kallina' OR junior_species='kallina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='kallina' OR species='kallina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='kallina' OR species='kallina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='kallina' OR junior_species='kallina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Doxocopa' AND (species='kallina' OR species='kallina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='laurentia' OR junior_species='laurentia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='laurentia' OR species='laurentia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='laurentia' OR species='laurentia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='laurentia' OR junior_species='laurentia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Doxocopa' AND (species='laurentia' OR species='laurentia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='zunilda' OR junior_species='zunilda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='zunilda' OR species='zunilda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='zunilda' OR species='zunilda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='zunilda' OR junior_species='zunilda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Doxocopa' AND (species='zunilda' OR species='zunilda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectima' AND (junior_species='thecla' OR junior_species='thecla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectima' AND (species='thecla' OR species='thecla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectima' AND (species='thecla' OR species='thecla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectima' AND (junior_species='thecla' OR junior_species='thecla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectima' AND (species='thecla' OR species='thecla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='epinome' OR junior_species='epinome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='epinome' OR species='epinome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='epinome' OR species='epinome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='epinome' OR junior_species='epinome')SELECT d.diet,d.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='epinome' OR species='epinome') 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='Hamadryas' AND (junior_species='feronia' OR junior_species='feronia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='feronia' OR species='feronia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='feronia' OR species='feronia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='feronia' OR junior_species='feronia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hamadryas' AND (species='feronia' OR species='feronia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='fornax' OR junior_species='fornax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='fornax' OR species='fornax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='fornax' OR species='fornax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='fornax' OR junior_species='fornax')SELECT d.diet,d.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='fornax' OR species='fornax') 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='Callicore' AND (junior_species='hydaspes' OR junior_species='hydaspes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicore' AND (species='hydaspes' OR species='hydaspes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicore' AND (species='hydaspes' OR species='hydaspes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='hydaspes' OR junior_species='hydaspes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callicore' AND (species='hydaspes' OR species='hydaspes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='pygas' OR junior_species='pygas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicore' AND (species='pygas' OR species='pygas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicore' AND (species='pygas' OR species='pygas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='pygas' OR junior_species='pygas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callicore' AND (species='pygas' OR species='pygas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='sorana' OR junior_species='sorana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicore' AND (species='sorana' OR species='sorana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicore' AND (species='sorana' OR species='sorana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='sorana' OR junior_species='sorana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Callicore' AND (species='sorana' OR species='sorana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='candrena' OR species='candrena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='candrena' OR species='candrena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='candrena' OR junior_species='candrena')SELECT d.diet,d.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='candrena' OR species='candrena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='clymena' OR junior_species='clymena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaethria' AND (species='clymena' OR species='clymena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaethria' AND (species='clymena' OR species='clymena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaethria' AND (junior_species='clymena' OR junior_species='clymena')SELECT d.diet,d.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='clymena' OR species='clymena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haematera' AND (junior_species='pyrame' OR junior_species='pyrame')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haematera' AND (species='pyrame' OR species='pyrame') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haematera' AND (species='pyrame' OR species='pyrame')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haematera' AND (junior_species='pyrame' OR junior_species='pyrame')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Haematera' AND (species='pyrame' OR species='pyrame') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paulogramma' AND (junior_species='pyracmon' OR junior_species='pyracmon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paulogramma' AND (junior_species='pyracmon' OR junior_species='pyracmon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paulogramma' AND (species='pyracmon' OR species='pyracmon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybdelis' AND (junior_species='phaesyla' OR junior_species='phaesyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cybdelis' AND (species='phaesyla' OR species='phaesyla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cybdelis' AND (species='phaesyla' OR species='phaesyla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cybdelis' AND (junior_species='phaesyla' OR junior_species='phaesyla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cybdelis' AND (species='phaesyla' OR species='phaesyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='eburnea' OR junior_species='eburnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='eburnea' OR species='eburnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='eburnea' OR species='eburnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='eburnea' OR junior_species='eburnea')SELECT d.diet,d.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='eburnea' OR species='eburnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='orsis' OR junior_species='orsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myscelia' AND (species='orsis' OR species='orsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myscelia' AND (species='orsis' OR species='orsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='orsis' OR junior_species='orsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myscelia' AND (species='orsis' OR species='orsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='hubneri' OR junior_species='hubnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiphile' AND (species='hubneri' OR species='hubnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiphile' AND (species='hubneri' OR species='hubnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='hubneri' OR junior_species='hubnerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epiphile' AND (species='hubneri' OR species='hubnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='orea' OR junior_species='orea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiphile' AND (species='orea' OR species='orea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiphile' AND (species='orea' OR species='orea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiphile' AND (junior_species='orea' OR junior_species='orea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epiphile' AND (species='orea' OR species='orea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='neaerea' OR junior_species='neaerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhogyra' AND (species='neaerea' OR species='neaerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhogyra' AND (species='neaerea' OR species='neaerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='neaerea' OR junior_species='neaerea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrrhogyra' AND (species='neaerea' OR species='neaerea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temenis' AND (junior_species='laothoe' OR junior_species='laothoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temenis' AND (species='laothoe' OR species='laothoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temenis' AND (species='laothoe' OR species='laothoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temenis' AND (junior_species='laothoe' OR junior_species='laothoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Temenis' AND (species='laothoe' OR species='laothoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='aerata' OR junior_species='aerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='aerata' OR species='aerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='aerata' OR species='aerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='aerata' OR junior_species='aerata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='aerata' OR species='aerata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='agacles' OR junior_species='agacles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='agacles' OR species='agacles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='agacles' OR species='agacles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='agacles' OR junior_species='agacles')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='agacles' OR species='agacles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='artemisia' OR junior_species='artemisia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='artemisia' OR species='artemisia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='artemisia' OR species='artemisia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='artemisia' OR junior_species='artemisia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='artemisia' OR species='artemisia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='athemon' OR junior_species='athemon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='athemon' OR species='athemon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='athemon' OR species='athemon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='athemon' OR junior_species='athemon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='athemon' OR species='athemon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='coenus' OR junior_species='coenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='coenus' OR species='coenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='coenus' OR species='coenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='coenus' OR junior_species='coenus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='coenus' OR species='coenus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='myrrhina' OR junior_species='myrrhina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='myrrhina' OR species='myrrhina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='myrrhina' OR species='myrrhina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='myrrhina' OR junior_species='myrrhina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='myrrhina' OR species='myrrhina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='postverta' OR junior_species='postverta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='postverta' OR species='postverta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='postverta' OR species='postverta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='postverta' OR junior_species='postverta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='postverta' OR species='postverta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='tithia' OR junior_species='tithia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dynamine' AND (species='tithia' OR species='tithia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dynamine' AND (species='tithia' OR species='tithia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dynamine' AND (junior_species='tithia' OR junior_species='tithia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dynamine' AND (species='tithia' OR species='tithia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='ryphea' OR junior_species='ryphea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fountainea' AND (species='ryphea' OR species='ryphea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fountainea' AND (species='ryphea' OR species='ryphea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='ryphea' OR junior_species='ryphea')SELECT d.diet,d.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='ryphea' OR species='ryphea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypna' AND (junior_species='clytemnestra' OR junior_species='clytemnestra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypna' AND (junior_species='clytemnestra' OR junior_species='clytemnestra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypna' AND (species='clytemnestra' OR species='clytemnestra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='acidalia' OR junior_species='acidalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='acidalia' OR species='acidalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='acidalia' OR species='acidalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='acidalia' OR junior_species='acidalia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Memphis' AND (species='acidalia' OR species='acidalia') 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='Danaus' AND (junior_species='erippus' OR junior_species='erippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='erippus' OR species='erippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='erippus' OR species='erippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='erippus' OR junior_species='erippus')SELECT d.diet,d.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='erippus' OR species='erippus') 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='Dircenna' AND (junior_species='dero' OR junior_species='dero')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dircenna' AND (species='dero' OR species='dero') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dircenna' AND (species='dero' OR species='dero')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dircenna' AND (junior_species='dero' OR junior_species='dero')SELECT d.diet,d.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='dero' OR species='dero') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='carcinia' OR junior_species='carcinia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Episcada' AND (species='carcinia' OR species='carcinia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Episcada' AND (species='carcinia' OR species='carcinia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='carcinia' OR junior_species='carcinia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Episcada' AND (species='carcinia' OR species='carcinia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='hymenaea' OR junior_species='hymenaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Episcada' AND (species='hymenaea' OR species='hymenaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Episcada' AND (species='hymenaea' OR species='hymenaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episcada' AND (junior_species='hymenaea' OR junior_species='hymenaea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Episcada' AND (species='hymenaea' OR species='hymenaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epityches' AND (junior_species='eupompe' OR junior_species='eupompe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epityches' AND (species='eupompe' OR species='eupompe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epityches' AND (species='eupompe' OR species='eupompe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epityches' AND (junior_species='eupompe' OR junior_species='eupompe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epityches' AND (species='eupompe' OR species='eupompe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='lysimnia' OR junior_species='lysimnia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mechanitis' AND (species='lysimnia' OR species='lysimnia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mechanitis' AND (junior_species='lysimnia' OR junior_species='lysimnia')SELECT d.diet,d.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='lysimnia' OR species='lysimnia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placidina' AND (junior_species='euryanassa' OR junior_species='euryanassa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Placidina' AND (species='euryanassa' OR species='euryanassa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Placidina' AND (species='euryanassa' OR species='euryanassa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Placidina' AND (junior_species='euryanassa' OR junior_species='euryanassa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Placidina' AND (species='euryanassa' OR species='euryanassa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoscada' AND (junior_species='erruca' OR junior_species='erruca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoscada' AND (species='erruca' OR species='erruca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoscada' AND (species='erruca' OR species='erruca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoscada' AND (junior_species='erruca' OR junior_species='erruca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudoscada' AND (species='erruca' OR species='erruca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronymia' AND (junior_species='sylvo' OR junior_species='sylvo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pteronymia' AND (species='sylvo' OR species='sylvo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pteronymia' AND (species='sylvo' OR species='sylvo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronymia' AND (junior_species='sylvo' OR junior_species='sylvo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pteronymia' AND (species='sylvo' OR species='sylvo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='melanisans' OR junior_species='melanisans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinote' AND (species='melanisans' OR species='melanisans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinote' AND (species='melanisans' OR species='melanisans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinote' AND (junior_species='melanisans' OR junior_species='melanisans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Actinote' AND (species='melanisans' OR species='melanisans') 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='Agraulis' AND (junior_species='vanillae' OR junior_species='vanillae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agraulis' AND (species='vanillae' OR species='vanillae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agraulis' AND (species='vanillae' OR species='vanillae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agraulis' AND (junior_species='vanillae' OR junior_species='vanillae')SELECT d.diet,d.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='vanillae' OR species='vanillae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='juno' OR junior_species='juno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dione' AND (species='juno' OR species='juno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dione' AND (species='juno' OR species='juno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dione' AND (junior_species='juno' OR junior_species='juno')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dione' AND (species='juno' OR species='juno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryas' AND (junior_species='iulia' OR junior_species='iulia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dryas' AND (species='iulia' OR species='iulia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dryas' AND (species='iulia' OR species='iulia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryas' AND (junior_species='iulia' OR junior_species='iulia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dryas' AND (species='iulia' OR species='iulia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eueides' AND (junior_species='aliphera' OR junior_species='aliphera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eueides' AND (species='aliphera' OR species='aliphera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eueides' AND (species='aliphera' OR species='aliphera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eueides' AND (junior_species='aliphera' OR junior_species='aliphera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eueides' AND (species='aliphera' OR species='aliphera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eueides' AND (junior_species='isabella' OR junior_species='isabella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eueides' AND (species='isabella' OR species='isabella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eueides' AND (species='isabella' OR species='isabella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eueides' AND (junior_species='isabella' OR junior_species='isabella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eueides' AND (species='isabella' OR species='isabella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='erato' OR junior_species='erato')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='erato' OR species='erato') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='erato' OR species='erato')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='erato' OR junior_species='erato')SELECT d.diet,d.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='erato' OR species='erato') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='ethilla' OR junior_species='ethilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='ethilla' OR species='ethilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='ethilla' OR species='ethilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='ethilla' OR junior_species='ethilla')SELECT d.diet,d.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='ethilla' OR species='ethilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libytheana' AND (junior_species='carinenta' OR junior_species='carinenta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libytheana' AND (species='carinenta' OR species='carinenta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libytheana' AND (species='carinenta' OR species='carinenta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libytheana' AND (junior_species='carinenta' OR junior_species='carinenta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Libytheana' AND (species='carinenta' OR species='carinenta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='abia' OR junior_species='abia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='abia' OR species='abia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='abia' OR species='abia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='abia' OR junior_species='abia')SELECT d.diet,d.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='abia' OR species='abia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='syma' OR junior_species='syma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='syma' OR species='syma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='syma' OR species='syma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='syma' OR junior_species='syma')SELECT d.diet,d.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='syma' OR species='syma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='thessalia' OR junior_species='thessalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='thessalia' OR species='thessalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='thessalia' OR species='thessalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='thessalia' OR junior_species='thessalia')SELECT d.diet,d.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='thessalia' OR species='thessalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='evarete' OR junior_species='evarete')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='evarete' OR species='evarete') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='evarete' OR species='evarete')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='evarete' OR junior_species='evarete')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Junonia' AND (species='evarete' OR species='evarete') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='lacinia' OR junior_species='lacinia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlosyne' AND (species='lacinia' OR species='lacinia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlosyne' AND (species='lacinia' OR species='lacinia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlosyne' AND (junior_species='lacinia' OR junior_species='lacinia')SELECT d.diet,d.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='lacinia' OR species='lacinia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='lansdorfi' OR junior_species='lansdorfii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eresia' AND (species='lansdorfi' OR species='lansdorfii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eresia' AND (species='lansdorfi' OR species='lansdorfii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='lansdorfi' OR junior_species='lansdorfii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eresia' AND (species='lansdorfi' OR species='lansdorfii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='dicoma' OR junior_species='dicoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ortilia' AND (species='dicoma' OR species='dicoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ortilia' AND (species='dicoma' OR species='dicoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='dicoma' OR junior_species='dicoma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ortilia' AND (species='dicoma' OR species='dicoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='ithra' OR junior_species='ithra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ortilia' AND (species='ithra' OR species='ithra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ortilia' AND (species='ithra' OR species='ithra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='ithra' OR junior_species='ithra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ortilia' AND (species='ithra' OR species='ithra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='orthia' OR junior_species='orthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ortilia' AND (species='orthia' OR species='orthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ortilia' AND (species='orthia' OR species='orthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='orthia' OR junior_species='orthia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ortilia' AND (species='orthia' OR species='orthia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='velica' OR junior_species='velica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ortilia' AND (species='velica' OR species='velica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ortilia' AND (species='velica' OR species='velica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ortilia' AND (junior_species='velica' OR junior_species='velica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ortilia' AND (species='velica' OR species='velica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='claudina' OR junior_species='claudina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tegosa' AND (species='claudina' OR species='claudina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tegosa' AND (species='claudina' OR species='claudina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tegosa' AND (junior_species='claudina' OR junior_species='claudina')SELECT d.diet,d.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='claudina' OR species='claudina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='bella' OR junior_species='bella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypanartia' AND (species='bella' OR species='bella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypanartia' AND (species='bella' OR species='bella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='bella' OR junior_species='bella')SELECT d.diet,d.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='bella' OR species='bella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='lethe' OR junior_species='lethe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypanartia' AND (species='lethe' OR species='lethe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypanartia' AND (species='lethe' OR species='lethe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypanartia' AND (junior_species='lethe' OR junior_species='lethe')SELECT d.diet,d.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='lethe' OR species='lethe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='braziliensis' OR species='braziliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='braziliensis' OR species='braziliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT d.diet,d.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='braziliensis' OR species='braziliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='amathea' OR junior_species='amathea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anartia' AND (species='amathea' OR species='amathea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anartia' AND (species='amathea' OR species='amathea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anartia' AND (junior_species='amathea' OR junior_species='amathea')SELECT d.diet,d.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='amathea' OR species='amathea') 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='Caligo' AND (junior_species='illioneus' OR junior_species='illioneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caligo' AND (species='illioneus' OR species='illioneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caligo' AND (species='illioneus' OR species='illioneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='illioneus' OR junior_species='illioneus')SELECT d.diet,d.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='illioneus' OR species='illioneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Narope' AND (junior_species='cyllastros' OR junior_species='cyllastros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Narope' AND (species='cyllastros' OR species='cyllastros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Narope' AND (species='cyllastros' OR species='cyllastros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Narope' AND (junior_species='cyllastros' OR junior_species='cyllastros')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Narope' AND (species='cyllastros' OR species='cyllastros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manataria' AND (junior_species='hercyna' OR junior_species='hercyna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manataria' AND (species='hercyna' OR species='hercyna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manataria' AND (species='hercyna' OR species='hercyna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manataria' AND (junior_species='hercyna' OR junior_species='hercyna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Manataria' AND (species='hercyna' OR species='hercyna') 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='Eteona' AND (junior_species='tisiphone' OR junior_species='tisiphone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eteona' AND (species='tisiphone' OR species='tisiphone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eteona' AND (species='tisiphone' OR species='tisiphone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eteona' AND (junior_species='tisiphone' OR junior_species='tisiphone')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eteona' AND (species='tisiphone' OR species='tisiphone') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='necys' OR junior_species='necys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='necys' OR species='necys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='necys' OR species='necys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='necys' OR junior_species='necys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='necys' OR species='necys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='quantius' OR junior_species='quantius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Forsterinaria' AND (species='quantius' OR species='quantius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Forsterinaria' AND (species='quantius' OR species='quantius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Forsterinaria' AND (junior_species='quantius' OR junior_species='quantius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Forsterinaria' AND (species='quantius' OR species='quantius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godartiana' AND (junior_species='muscosa' OR junior_species='muscosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Godartiana' AND (species='muscosa' OR species='muscosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Godartiana' AND (species='muscosa' OR species='muscosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Godartiana' AND (junior_species='muscosa' OR junior_species='muscosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Godartiana' AND (species='muscosa' OR species='muscosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='atalanta' OR junior_species='atalanta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hermeuptychia' AND (species='atalanta' OR species='atalanta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hermeuptychia' AND (species='atalanta' OR species='atalanta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='atalanta' OR junior_species='atalanta')SELECT d.diet,d.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='atalanta' OR species='atalanta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='griseldis' OR junior_species='griseldis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moneuptychia' AND (species='griseldis' OR species='griseldis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moneuptychia' AND (species='griseldis' OR species='griseldis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moneuptychia' AND (junior_species='griseldis' OR junior_species='griseldis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moneuptychia' AND (species='griseldis' OR species='griseldis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='ocirrhoe' OR junior_species='ocirrhoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='ocirrhoe' OR junior_species='ocirrhoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pareuptychia' AND (species='ocirrhoe' OR species='ocirrhoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='summandosa' OR junior_species='summandosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareuptychia' AND (species='summandosa' OR species='summandosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareuptychia' AND (species='summandosa' OR species='summandosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='summandosa' OR junior_species='summandosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pareuptychia' AND (species='summandosa' OR species='summandosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='eous' OR junior_species='eous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='eous' OR species='eous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='eous' OR species='eous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='eous' OR junior_species='eous')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='eous' OR species='eous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='grimon' OR junior_species='grimon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='grimon' OR species='grimon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='grimon' OR species='grimon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='grimon' OR junior_species='grimon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='grimon' OR species='grimon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='phronius' OR junior_species='phronius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='phronius' OR species='phronius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='phronius' OR species='phronius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='phronius' OR junior_species='phronius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='phronius' OR species='phronius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='poltys' OR junior_species='poltys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paryphthimoides' AND (species='poltys' OR species='poltys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paryphthimoides' AND (species='poltys' OR species='poltys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paryphthimoides' AND (junior_species='poltys' OR junior_species='poltys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paryphthimoides' AND (species='poltys' OR species='poltys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pharneuptychia' AND (junior_species='pharnabazos' OR junior_species='pharnabazos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pharneuptychia' AND (species='pharnabazos' OR species='pharnabazos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pharneuptychia' AND (species='pharnabazos' OR species='pharnabazos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pharneuptychia' AND (junior_species='pharnabazos' OR junior_species='pharnabazos')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pharneuptychia' AND (species='pharnabazos' OR species='pharnabazos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praepedaliodes' AND (junior_species='phanias' OR junior_species='phanias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Praepedaliodes' AND (species='phanias' OR species='phanias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Praepedaliodes' AND (species='phanias' OR species='phanias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praepedaliodes' AND (junior_species='phanias' OR junior_species='phanias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Praepedaliodes' AND (species='phanias' OR species='phanias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodebis' AND (junior_species='euptychidia' OR junior_species='euptychidia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodebis' AND (junior_species='euptychidia' OR junior_species='euptychidia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudodebis' AND (species='euptychidia' OR species='euptychidia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='libitina' OR junior_species='libitina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Splendeuptychia' AND (species='libitina' OR species='libitina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Splendeuptychia' AND (species='libitina' OR species='libitina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Splendeuptychia' AND (junior_species='libitina' OR junior_species='libitina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Splendeuptychia' AND (species='libitina' OR species='libitina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='tripunctata' OR junior_species='tripunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='tripunctata' OR species='tripunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='tripunctata' OR species='tripunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='tripunctata' OR junior_species='tripunctata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='tripunctata' OR species='tripunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='ypthima' OR junior_species='ypthima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='ypthima' OR species='ypthima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='ypthima' OR species='ypthima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='ypthima' OR junior_species='ypthima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taygetis' AND (species='ypthima' OR species='ypthima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='celmis' OR junior_species='celmis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='celmis' OR species='celmis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='celmis' OR species='celmis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='celmis' OR junior_species='celmis')SELECT d.diet,d.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='celmis' OR species='celmis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='mimula' OR junior_species='mimula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='mimula' OR species='mimula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='mimula' OR species='mimula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='mimula' OR junior_species='mimula')SELECT d.diet,d.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='mimula' OR species='mimula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='ordinaria' OR junior_species='ordinaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='ordinaria' OR species='ordinaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='ordinaria' OR species='ordinaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='ordinaria' OR junior_species='ordinaria')SELECT d.diet,d.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='ordinaria' OR species='ordinaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='straminea' OR junior_species='straminea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yphthimoides' AND (species='straminea' OR species='straminea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yphthimoides' AND (species='straminea' OR species='straminea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yphthimoides' AND (junior_species='straminea' OR junior_species='straminea')SELECT d.diet,d.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='straminea' OR species='straminea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='polydamas' OR junior_species='polydamas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Battus' AND (species='polydamas' OR species='polydamas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Battus' AND (species='polydamas' OR species='polydamas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='polydamas' OR junior_species='polydamas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Battus' AND (species='polydamas' OR species='polydamas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='polystictus' OR junior_species='polystictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Battus' AND (species='polystictus' OR species='polystictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Battus' AND (species='polystictus' OR species='polystictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Battus' AND (junior_species='polystictus' OR junior_species='polystictus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Battus' AND (species='polystictus' OR species='polystictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='anchisiades' OR junior_species='anchisiades')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='anchisiades' OR species='anchisiades') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='anchisiades' OR species='anchisiades')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='anchisiades' OR junior_species='anchisiades')SELECT d.diet,d.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='anchisiades' OR species='anchisiades') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='astyalus' OR junior_species='astyalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='astyalus' OR species='astyalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='astyalus' OR species='astyalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='astyalus' OR junior_species='astyalus')SELECT d.diet,d.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='astyalus' OR species='astyalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='hectorides' OR junior_species='hectorides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heraclides' AND (species='hectorides' OR species='hectorides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heraclides' AND (species='hectorides' OR species='hectorides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heraclides' AND (junior_species='hectorides' OR junior_species='hectorides')SELECT d.diet,d.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='hectorides' OR species='hectorides') 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='Parides' AND (junior_species='agavus' OR junior_species='agavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parides' AND (species='agavus' OR species='agavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parides' AND (species='agavus' OR species='agavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='agavus' OR junior_species='agavus')SELECT d.diet,d.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='agavus' OR species='agavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='anchises' OR junior_species='anchises')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parides' AND (species='anchises' OR species='anchises') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parides' AND (species='anchises' OR species='anchises')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parides' AND (junior_species='anchises' OR junior_species='anchises')SELECT d.diet,d.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='anchises' OR species='anchises') 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='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='deva' OR junior_species='deva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='deva' OR species='deva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='deva' OR species='deva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='deva' OR junior_species='deva')SELECT d.diet,d.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='deva' OR species='deva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='elathea' OR junior_species='elathea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='elathea' OR species='elathea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='elathea' OR species='elathea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='elathea' OR junior_species='elathea')SELECT d.diet,d.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='elathea' OR species='elathea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='argante' OR junior_species='argante')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebis' AND (species='argante' OR species='argante') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebis' AND (species='argante' OR species='argante')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebis' AND (junior_species='argante' OR junior_species='argante')SELECT d.diet,d.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='argante' OR species='argante') 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='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='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='Pyrisitia' AND (junior_species='leuce' OR junior_species='leuce')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrisitia' AND (species='leuce' OR species='leuce') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrisitia' AND (species='leuce' OR species='leuce')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrisitia' AND (junior_species='leuce' OR junior_species='leuce')SELECT d.diet,d.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='leuce' OR species='leuce') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhabdodryas' AND (junior_species='trite' OR junior_species='trite')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhabdodryas' AND (species='trite' OR species='trite') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhabdodryas' AND (species='trite' OR species='trite')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhabdodryas' AND (junior_species='trite' OR junior_species='trite')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhabdodryas' AND (species='trite' OR species='trite') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='astyocha' OR junior_species='astyocha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dismorphia' AND (species='astyocha' OR species='astyocha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dismorphia' AND (species='astyocha' OR species='astyocha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dismorphia' AND (junior_species='astyocha' OR junior_species='astyocha')SELECT d.diet,d.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='astyocha' OR species='astyocha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enantia' AND (junior_species='lina' OR junior_species='lina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enantia' AND (species='lina' OR species='lina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enantia' AND (species='lina' OR species='lina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enantia' AND (junior_species='lina' OR junior_species='lina')SELECT d.diet,d.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='lina' OR species='lina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopieris' AND (junior_species='nehemia' OR junior_species='nehemia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudopieris' AND (species='nehemia' OR species='nehemia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudopieris' AND (species='nehemia' OR species='nehemia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudopieris' AND (junior_species='nehemia' OR junior_species='nehemia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudopieris' AND (species='nehemia' OR species='nehemia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ascia' AND (junior_species='monuste' OR junior_species='monuste')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ascia' AND (species='monuste' OR species='monuste') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ascia' AND (species='monuste' OR species='monuste')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ascia' AND (junior_species='monuste' OR junior_species='monuste')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ascia' AND (species='monuste' OR species='monuste') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euselasia' AND (junior_species='eucerus' OR junior_species='eucerus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euselasia' AND (species='eucerus' OR species='eucerus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euselasia' AND (species='eucerus' OR species='eucerus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euselasia' AND (junior_species='eucerus' OR junior_species='eucerus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euselasia' AND (species='eucerus' OR species='eucerus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='diogenia' OR junior_species='diogenia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emesis' AND (species='diogenia' OR species='diogenia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emesis' AND (species='diogenia' OR species='diogenia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='diogenia' OR junior_species='diogenia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Emesis' AND (species='diogenia' OR species='diogenia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='ocypore' OR junior_species='ocypore')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emesis' AND (species='ocypore' OR species='ocypore') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emesis' AND (species='ocypore' OR species='ocypore')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='ocypore' OR junior_species='ocypore')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Emesis' AND (species='ocypore' OR species='ocypore') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='satema' OR junior_species='satema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emesis' AND (species='satema' OR species='satema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emesis' AND (species='satema' OR species='satema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emesis' AND (junior_species='satema' OR junior_species='satema')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Emesis' AND (species='satema' OR species='satema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ionotus' AND (junior_species='alector' OR junior_species='alector')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ionotus' AND (species='alector' OR species='alector') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ionotus' AND (species='alector' OR species='alector')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ionotus' AND (junior_species='alector' OR junior_species='alector')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ionotus' AND (species='alector' OR species='alector') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelotypa' AND (junior_species='argiella' OR junior_species='argiella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelotypa' AND (species='argiella' OR species='argiella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelotypa' AND (species='argiella' OR species='argiella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelotypa' AND (junior_species='argiella' OR junior_species='argiella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelotypa' AND (species='argiella' OR species='argiella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synargis' AND (junior_species='calyce' OR junior_species='calyce')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synargis' AND (species='calyce' OR species='calyce') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synargis' AND (species='calyce' OR species='calyce')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synargis' AND (junior_species='calyce' OR junior_species='calyce')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synargis' AND (species='calyce' OR species='calyce') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barbicornis' AND (junior_species='basilis' OR junior_species='basilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Barbicornis' AND (species='basilis' OR species='basilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Barbicornis' AND (species='basilis' OR species='basilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barbicornis' AND (junior_species='basilis' OR junior_species='basilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Barbicornis' AND (species='basilis' OR species='basilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calephelis' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calephelis' AND (species='braziliensis' OR species='braziliensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calephelis' AND (species='braziliensis' OR species='braziliensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calephelis' AND (junior_species='braziliensis' OR junior_species='braziliensis')SELECT d.diet,d.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='braziliensis' OR species='braziliensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calephelis' AND (junior_species='aymaran' OR junior_species='aymaran')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calephelis' AND (species='aymaran' OR species='aymaran') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calephelis' AND (species='aymaran' OR species='aymaran')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calephelis' AND (junior_species='aymaran' OR junior_species='aymaran')SELECT d.diet,d.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='aymaran' OR species='aymaran') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caria' AND (junior_species='marsyas' OR junior_species='marsyas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caria' AND (species='marsyas' OR species='marsyas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caria' AND (species='marsyas' OR species='marsyas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caria' AND (junior_species='marsyas' OR junior_species='marsyas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caria' AND (species='marsyas' OR species='marsyas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalodeta' AND (junior_species='theodora' OR junior_species='theodora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalodeta' AND (species='theodora' OR species='theodora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalodeta' AND (species='theodora' OR species='theodora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalodeta' AND (junior_species='theodora' OR junior_species='theodora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chalodeta' AND (species='theodora' OR species='theodora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasaia' AND (junior_species='agesilas' OR junior_species='agesilas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasaia' AND (species='agesilas' OR species='agesilas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasaia' AND (species='agesilas' OR species='agesilas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasaia' AND (junior_species='agesilas' OR junior_species='agesilas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasaia' AND (species='agesilas' OR species='agesilas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanis' AND (junior_species='xenia' OR junior_species='xenia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanis' AND (species='xenia' OR species='xenia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanis' AND (species='xenia' OR species='xenia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanis' AND (junior_species='xenia' OR junior_species='xenia')SELECT d.diet,d.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='xenia' OR species='xenia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1183 The Ecological Register: Porto Mauâ
Porto Mauâ
Basic information
Sample name: Porto Mauâ

Reference: S. C. Thiele, O. Milcharek, F. L. dos Santos, and L. A. Kaminski. 2014. Butterflies (Lepidoptera: Hesperioidea and Papilionoidea) of Porto Mauá, Upper Paraná Atlantic Forest Ecoregion, Rio Grande do Sul State, Brazil. Biota Neotropica 14(2):1-10 [ER 834]
Geography
Country: Brazil

State: Rio Grande do Sul


Coordinate: 27° 34' S, 54° 40' W
Coordinate basis: stated in text

Geography comments: four transects at two sites "near the Uruguay River"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 32.5

CMT: 7.5

MAP: 1980.0

Habitat comments: "Upper Paranâ Atlantic Forest... subtropical humid, with the absence of a dry period"
temperatures are "31-34" in the summer and "6-9" in the winter

Methods
Life forms: butterflies

Sites: 8

Sampling methods: line transect,butterfly nets

Sample size: 1994 individuals

Years: 2008, 2009

Days: 17

Sampling comments: "entomological nets" used for 204 net hours and 12 net hours per day = 17 days

Metadata
Sample number: 1183

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-10-01 20:16:04

Modified: 2014-10-01 10:50:01

Abundance distribution
254 species
87 singletons
total count 1994
extrapolated richness: 521.5
Fisher's α: 77.222
geometric series k: 0.9807
Hurlbert's PIE: 0.9766
Shannon's H: 4.4898
Good's u: 0.9564
Each square represents a species. Square sizes are proportional to counts.
Register
Astraptes alardus alardus2
Astraptes aulus1
Astraptes fulgerator fulgerator1
Autochton zarex5
Polygonus leo pallida1
Polygonus savigny savigny3
Spathilepia clonius1
Urbanus albimargo rica2
Urbanus dorantes dorantes18
Urbanus doryssus albicuspis1
Urbanus esta1
Urbanus evenus3
Urbanus pronta2
Urbanus proteus proteus1
Urbanus simplicius5
Urbanus sp.1
Urbanus teleus6
Urbanus virescens3
Anthoptus epictetus2
Corticea corticea3
Synapte silius9
Evansiella cordela2
Lychnuchoides ozias ozias6
Saliana longirostris1
Zenis jebus jebus2
Hylephila phyleus phyleus1
Nyctelius nyctelius nyctelius1
Pompeius pompeius2
Quinta cannae3
Thespieus ethemides1
Vacerra bonfilius bonfilius1
Wallengrenia premnas1
Lycas argentea7
Arita mubevensis3
Callimormus rivera2
Callimormus saturnus1
Callimormus simplicius2
Cobalopsis miaba2
Cumbre triumviralis2
Cymaenes gisca1
Cymaenes lepta1
Cymaenes perloides3
Cymaenes sp.2
Eprius veleda obrepta5
Lento krexoides5
Lucida ranesus1
Miltomiges cinnamomea5
Moeris striga striga1
Monca branca1
Phanes rezia1
Pheraeus odilia odilia1
Psoralis stacara7
Sodalia coler7
Vehilius inca5
Vehilius stictomenes stictomenes3
Vettius marcus1
Virga austrinus1
Zariaspes mys1
Achlyodes thraso5
Aethilla echina coracina2
Milanion leucaspis2
Quadrus cerialis2
Bolla atahuallpai2
Nisoniades macarius4
Staphylus incisus10
Staphylus minor minor1
Staphylus sp.7
Celaenorrhinus similis2
Erynnis funeralis1
Gorgythion begga begga8
Grais stigmaticus stigmaticus1
Helias phalaenoides palpalis1
Mylon maimon3
Sostrata cronion5
Antigonus liborius areta3
Carrhenes canescens pallida2
Diaeus lacaena3
Heliopetes alana4
Heliopetes arsalte11
Heliopetes libra1
Heliopetes omrina7
Pyrgus orcus136
Pyrgus orcynoides5
Trina geometrina geometrina33
Xenophanes tryxus10
Mysoria barcastus barta1
Leptotes cassius cassius5
Zizula cyna47
Arawacus ellida2
Arawacus meliboeus2
Arawacus separata17
Brevianta celelata1
Calycopis caulonia9
Celmia celmus1
Contrafacia imma1
Dicya eumorpha1
Gargina caninius1
Ignata cf. elana1
Nicolaea cupa1
Ocaria ocrisia1
Ocaria thales2
Ostrinotes sophocles1
Panthiades hebraeus1
Parrhasius orgia2
Parrhasius polibetes1
Rekoa malina1
Rekoa palegon2
Siderus eliatha1
Strephonota ambrax1
Strymon astiocha3
Strymon bazochii bazochii4
Strymon cestri1
Strymon eurytulus3
Strymon megarus2
Strymon mulucha3
Strymon ziba1
Symbiopsis lenitas1
Theritas chaluma1
Theritas hemon3
Tmolus echion echion1
Doxocopa kallina2
Doxocopa laurentia laurentia4
Doxocopa zunilda zunilda1
Ectima thecla thecla1
Hamadryas epinome6
Hamadryas februa februa5
Hamadryas feronia feronia1
Hamadryas fornax fornax1
Biblis hyperia nectanabis43
Callicore hydaspes1
Callicore pygas thamyras2
Callicore sorana sorana1
Diaethria candrena candrena1
Diaethria clymena janeira1
Haematera pyrame pyrame2
Paulogramma pyracmon pyracmon1
Cybdelis phaesyla1
Eunica eburnea1
Myscelia orsis3
Epiphile hubneri3
Epiphile orea orea1
Pyrrhogyra neaerea arge2
Temenis laothoe meridionalis1
Dynamine aerata2
Dynamine agacles agacles10
Dynamine artemisia artemisia1
Dynamine athemon athemaena9
Dynamine coenus coenus2
Dynamine myrrhina29
Dynamine postverta postverta15
Dynamine tithia tithia21
Fountainea ryphea phidile2
Hypna clytemnestra huebneri2
Memphis acidalia victoria4
Marpesia chiron marius3
Marpesia petreus petreus1
Danaus erippus44
Danaus gilippus gilippus5
Dircenna dero celtina12
Episcada carcinia1
Episcada hymenaea hymenaea20
Epityches eupompe2
Mechanitis lysimnia lysimnia4
Placidina euryanassa6
Pseudoscada erruca10
Pteronymia sylvo6
Actinote melanisans1
Euptoieta hegesia meridiania1
Agraulis vanillae maculosa5
Dione juno juno2
Dryas iulia alcionea32
Eueides aliphera aliphera26
Eueides isabella dianasa1
Heliconius erato phyllis68
Heliconius ethilla narcaea3
Libytheana carinenta carinenta1
Adelpha abia1
Adelpha syma1
Adelpha thessalia indefecta1
Junonia evarete flirtea118
Chlosyne lacinia saundersi5
Eresia lansdorfi5
Ortilia dicoma3
Ortilia ithra26
Ortilia orthia7
Ortilia velica durnfordi6
Tegosa claudina140
Hypanartia bella13
Hypanartia lethe lethe9
Vanessa braziliensis40
Anartia amathea roeselia46
Siproeta epaphus trayja14
Caligo illioneus pampeiro1
Narope cyllastros1
Manataria hercyna hercyna1
Morpho helenor achillides49
Eteona tisiphone5
Forsterinaria necys11
Forsterinaria quantius12
Godartiana muscosa4
Hermeuptychia atalanta67
Moneuptychia griseldis2
Pareuptychia ocirrhoe interjecta1
Pareuptychia summandosa29
Paryphthimoides eous16
Paryphthimoides grimon3
Paryphthimoides phronius76
Paryphthimoides poltys2
Pharneuptychia pharnabazos1
Praepedaliodes phanias24
Pseudodebis euptychidia1
Splendeuptychia libitina11
Taygetis tripunctata2
Taygetis ypthima10
Yphthimoides celmis9
Yphthimoides mimula2
Yphthimoides ordinaria10
Yphthimoides straminea1
Battus polydamas polydamas11
Battus polystictus polystictus4
Heraclides anchisiades capys1
Heraclides astyalus astyalus6
Heraclides hectorides6
Heraclides thoas brasiliensis2
Parides agavus28
Parides anchises nephalion9
Aphrissa statira statira8
Eurema albula sinoe2
Eurema deva deva29
Eurema elathea flavescens2
Phoebis argante argante11
Phoebis neocypris neocypris19
Phoebis philea philea7
Phoebis sennae marcellina12
Pyrisitia leuce leuce2
Rhabdodryas trite banksi4
Dismorphia astyocha1
Enantia lina psamathe3
Pseudopieris nehemia nehemia6
Ascia monuste orseis3
Euselasia eucerus1
Emesis diogenia9
Emesis ocypore zelotes5
Emesis satema2
Ionotus alector2
Adelotypa argiella1
Synargis calyce1
Barbicornis basilis mona4
Calephelis braziliensis2
Calephelis aymaran2
Caria marsyas1
Chalodeta theodora3
Lasaia agesilas agesilas1
Melanis xenia xenia2