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=2306 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2306SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2248SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2306 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='agathina' OR junior_species='agathina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='agathina' OR species='agathina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='agathina' OR species='agathina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='agathina' OR junior_species='agathina')SELECT d.diet,d.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='agathina' OR species='agathina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='linda' OR junior_species='linda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doxocopa' AND (species='linda' OR species='linda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doxocopa' AND (species='linda' OR species='linda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doxocopa' AND (junior_species='linda' OR junior_species='linda')SELECT d.diet,d.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='linda' OR species='linda') 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='Asterope' AND (junior_species='markii' OR junior_species='marki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asterope' AND (species='markii' OR species='marki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asterope' AND (species='markii' OR species='marki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asterope' AND (junior_species='markii' OR junior_species='marki')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Asterope' AND (species='markii' OR species='marki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Batesia' AND (junior_species='hypochlora' OR junior_species='hypochlora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Batesia' AND (species='hypochlora' OR species='hypochlora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Batesia' AND (species='hypochlora' OR species='hypochlora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Batesia' AND (junior_species='hypochlora' OR junior_species='hypochlora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Batesia' AND (species='hypochlora' OR species='hypochlora') 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='cynosura' OR junior_species='cynosura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicore' AND (species='cynosura' OR species='cynosura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicore' AND (species='cynosura' OR species='cynosura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='cynosura' OR junior_species='cynosura')SELECT d.diet,d.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='cynosura' OR species='cynosura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='hesperis' OR junior_species='hesperis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicore' AND (species='hesperis' OR species='hesperis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicore' AND (species='hesperis' OR species='hesperis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicore' AND (junior_species='hesperis' OR junior_species='hesperis')SELECT d.diet,d.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='hesperis' OR species='hesperis') 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='Catonephele' AND (junior_species='acontius' OR junior_species='acontius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catonephele' AND (species='acontius' OR species='acontius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catonephele' AND (species='acontius' OR species='acontius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='acontius' OR junior_species='acontius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catonephele' AND (species='acontius' OR species='acontius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='numilia' OR junior_species='numilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catonephele' AND (species='numilia' OR species='numilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catonephele' AND (species='numilia' OR species='numilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='numilia' OR junior_species='numilia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catonephele' AND (species='numilia' OR species='numilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='salacia' OR junior_species='salacia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catonephele' AND (species='salacia' OR species='salacia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catonephele' AND (species='salacia' OR species='salacia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catonephele' AND (junior_species='salacia' OR junior_species='salacia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catonephele' AND (species='salacia' OR species='salacia') 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='Eunica' AND (junior_species='concordia' OR junior_species='concordia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='concordia' OR species='concordia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='concordia' OR species='concordia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='concordia' OR junior_species='concordia')SELECT d.diet,d.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='concordia' OR species='concordia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='marsolia' OR junior_species='marsolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='marsolia' OR species='marsolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='marsolia' OR species='marsolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='marsolia' OR junior_species='marsolia')SELECT d.diet,d.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='marsolia' OR species='marsolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='orphise' OR junior_species='orphise')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='orphise' OR species='orphise') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='orphise' OR species='orphise')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='orphise' OR junior_species='orphise')SELECT d.diet,d.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='orphise' OR species='orphise') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='sophonisba' OR junior_species='sophonisba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eunica' AND (species='sophonisba' OR species='sophonisba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eunica' AND (species='sophonisba' OR species='sophonisba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eunica' AND (junior_species='sophonisba' OR junior_species='sophonisba')SELECT d.diet,d.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='sophonisba' OR species='sophonisba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='arinome' OR junior_species='arinome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='arinome' OR species='arinome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='arinome' OR species='arinome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='arinome' OR junior_species='arinome')SELECT d.diet,d.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='arinome' OR species='arinome') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='chloe' OR junior_species='chloe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamadryas' AND (species='chloe' OR species='chloe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamadryas' AND (species='chloe' OR species='chloe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamadryas' AND (junior_species='chloe' OR junior_species='chloe')SELECT d.diet,d.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='chloe' OR species='chloe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='berania' OR junior_species='berania')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marpesia' AND (species='berania' OR species='berania') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marpesia' AND (species='berania' OR species='berania')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marpesia' AND (junior_species='berania' OR junior_species='berania')SELECT d.diet,d.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='berania' OR species='berania') 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='Myscelia' AND (junior_species='capenas' OR junior_species='capenas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myscelia' AND (species='capenas' OR species='capenas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myscelia' AND (species='capenas' OR species='capenas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myscelia' AND (junior_species='capenas' OR junior_species='capenas')SELECT d.diet,d.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='capenas' OR species='capenas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nessaea' AND (junior_species='hewitsonii' OR junior_species='hewitsoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nessaea' AND (species='hewitsonii' OR species='hewitsoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nessaea' AND (species='hewitsonii' OR species='hewitsoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nessaea' AND (junior_species='hewitsonii' OR junior_species='hewitsoni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nessaea' AND (species='hewitsonii' OR species='hewitsoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nessaea' AND (junior_species='obrinus' OR junior_species='obrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nessaea' AND (species='obrinus' OR species='obrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nessaea' AND (species='obrinus' OR species='obrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nessaea' AND (junior_species='obrinus' OR junior_species='obrinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nessaea' AND (species='obrinus' OR species='obrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nica' AND (junior_species='flavilla' OR junior_species='flavilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nica' AND (species='flavilla' OR species='flavilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nica' AND (species='flavilla' OR species='flavilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nica' AND (junior_species='flavilla' OR junior_species='flavilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nica' AND (species='flavilla' OR species='flavilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panacea' AND (junior_species='procilla' OR junior_species='procilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panacea' AND (species='procilla' OR species='procilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panacea' AND (species='procilla' OR species='procilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panacea' AND (junior_species='procilla' OR junior_species='procilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Panacea' AND (species='procilla' OR species='procilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panacea' AND (junior_species='prola' OR junior_species='prola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panacea' AND (species='prola' OR species='prola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panacea' AND (species='prola' OR species='prola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panacea' AND (junior_species='prola' OR junior_species='prola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Panacea' AND (species='prola' OR species='prola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peria' AND (junior_species='lamis' OR junior_species='lamis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peria' AND (species='lamis' OR species='lamis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peria' AND (species='lamis' OR species='lamis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peria' AND (junior_species='lamis' OR junior_species='lamis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peria' AND (species='lamis' OR species='lamis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='amphiro' OR junior_species='amphiro')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhogyra' AND (species='amphiro' OR species='amphiro') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhogyra' AND (species='amphiro' OR species='amphiro')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='amphiro' OR junior_species='amphiro')SELECT d.diet,d.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='amphiro' OR species='amphiro') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='crameri' OR junior_species='cramerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhogyra' AND (species='crameri' OR species='cramerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhogyra' AND (species='crameri' OR species='cramerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='crameri' OR junior_species='cramerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrrhogyra' AND (species='crameri' OR species='cramerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='edocla' OR junior_species='edocla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhogyra' AND (species='edocla' OR species='edocla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhogyra' AND (species='edocla' OR species='edocla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='edocla' OR junior_species='edocla')SELECT d.diet,d.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='edocla' OR species='edocla') 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='Pyrrhogyra' AND (junior_species='otolais' OR junior_species='otolais')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhogyra' AND (species='otolais' OR species='otolais') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhogyra' AND (species='otolais' OR species='otolais')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhogyra' AND (junior_species='otolais' OR junior_species='otolais')SELECT d.diet,d.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='otolais' OR species='otolais') 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='Temenis' AND (junior_species='pulchra' OR junior_species='pulchra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Temenis' AND (species='pulchra' OR species='pulchra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Temenis' AND (species='pulchra' OR species='pulchra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Temenis' AND (junior_species='pulchra' OR junior_species='pulchra')SELECT d.diet,d.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='pulchra' OR species='pulchra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vila' AND (junior_species='emilia' OR junior_species='emilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vila' AND (species='emilia' OR species='emilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vila' AND (species='emilia' OR species='emilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vila' AND (junior_species='emilia' OR junior_species='emilia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vila' AND (species='emilia' OR species='emilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrias' 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='Agrias' AND (species='claudina' OR species='claudina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrias' AND (species='claudina' OR species='claudina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrias' 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='Agrias' AND (species='claudina' OR species='claudina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaeomorpha' AND (junior_species='splendida' OR junior_species='splendida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anaeomorpha' AND (species='splendida' OR species='splendida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anaeomorpha' AND (species='splendida' OR species='splendida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anaeomorpha' AND (junior_species='splendida' OR junior_species='splendida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anaeomorpha' AND (species='splendida' OR species='splendida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophon' OR junior_species='demophon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='demophon' OR species='demophon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='demophon' OR species='demophon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophon' OR junior_species='demophon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeoprepona' AND (species='demophon' OR species='demophon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophoon' OR junior_species='demophoon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='demophoon' OR species='demophoon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='demophoon' OR species='demophoon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='demophoon' OR junior_species='demophoon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeoprepona' AND (species='demophoon' OR species='demophoon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='licomedes' OR junior_species='licomedes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='licomedes' OR species='licomedes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='licomedes' OR species='licomedes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='licomedes' OR junior_species='licomedes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeoprepona' AND (species='licomedes' OR species='licomedes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='meander' OR junior_species='meander')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeoprepona' AND (species='meander' OR species='meander') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeoprepona' AND (species='meander' OR species='meander')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeoprepona' AND (junior_species='meander' OR junior_species='meander')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Archaeoprepona' AND (species='meander' OR species='meander') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='eurypyle' OR junior_species='eurypyle')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fountainea' AND (species='eurypyle' OR species='eurypyle') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fountainea' AND (species='eurypyle' OR species='eurypyle')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fountainea' AND (junior_species='eurypyle' OR junior_species='eurypyle')SELECT d.diet,d.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='eurypyle' OR species='eurypyle') 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='Memphis' AND (junior_species='basilia' OR junior_species='basilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='basilia' OR species='basilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='basilia' OR species='basilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='basilia' OR junior_species='basilia')SELECT d.diet,d.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='basilia' OR species='basilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='moruus' OR junior_species='moruus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='moruus' OR species='moruus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='moruus' OR species='moruus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='moruus' OR junior_species='moruus')SELECT d.diet,d.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='moruus' OR species='moruus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='philumena' OR junior_species='philumena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='philumena' OR species='philumena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='philumena' OR species='philumena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='philumena' OR junior_species='philumena')SELECT d.diet,d.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='philumena' OR species='philumena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='polycarmes' OR junior_species='polycarmes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memphis' AND (species='polycarmes' OR species='polycarmes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memphis' AND (species='polycarmes' OR species='polycarmes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memphis' AND (junior_species='polycarmes' OR junior_species='polycarmes')SELECT d.diet,d.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='polycarmes' OR species='polycarmes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prepona' AND (junior_species='laertes' OR junior_species='laertes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prepona' AND (species='laertes' OR species='laertes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prepona' AND (species='laertes' OR species='laertes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prepona' AND (junior_species='laertes' OR junior_species='laertes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prepona' AND (species='laertes' OR species='laertes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prepona' AND (junior_species='pheridamas' OR junior_species='pheridamas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prepona' AND (species='pheridamas' OR species='pheridamas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prepona' AND (species='pheridamas' OR species='pheridamas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prepona' AND (junior_species='pheridamas' OR junior_species='pheridamas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prepona' AND (species='pheridamas' OR species='pheridamas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zaretis' AND (junior_species='isidora' OR junior_species='isidora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zaretis' AND (species='isidora' OR species='isidora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zaretis' AND (species='isidora' OR species='isidora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zaretis' AND (junior_species='isidora' OR junior_species='isidora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zaretis' AND (species='isidora' OR species='isidora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='elevatus' OR junior_species='elevatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='elevatus' OR species='elevatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='elevatus' OR species='elevatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='elevatus' OR junior_species='elevatus')SELECT d.diet,d.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='elevatus' OR species='elevatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='hecale' OR junior_species='hecale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='hecale' OR species='hecale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='hecale' OR species='hecale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='hecale' OR junior_species='hecale')SELECT d.diet,d.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='hecale' OR species='hecale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='melpomene' OR junior_species='melpomene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='melpomene' OR species='melpomene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='melpomene' OR species='melpomene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='melpomene' OR junior_species='melpomene')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliconius' AND (species='melpomene' OR species='melpomene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='numata' OR junior_species='numata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliconius' AND (species='numata' OR species='numata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliconius' AND (species='numata' OR species='numata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliconius' AND (junior_species='numata' OR junior_species='numata')SELECT d.diet,d.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='numata' OR species='numata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laparus' AND (junior_species='doris' OR junior_species='doris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laparus' AND (species='doris' OR species='doris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laparus' AND (species='doris' OR species='doris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laparus' AND (junior_species='doris' OR junior_species='doris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Laparus' AND (species='doris' OR species='doris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='attica' OR junior_species='attica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='attica' OR species='attica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='attica' OR species='attica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='attica' OR junior_species='attica')SELECT d.diet,d.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='attica' OR species='attica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='boeotia' OR junior_species='boeotia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='boeotia' OR species='boeotia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='boeotia' OR species='boeotia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='boeotia' OR junior_species='boeotia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='boeotia' OR species='boeotia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='capucinus' OR junior_species='capucinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='capucinus' OR species='capucinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='capucinus' OR species='capucinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='capucinus' OR junior_species='capucinus')SELECT d.diet,d.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='capucinus' OR species='capucinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='cocala' OR junior_species='cocala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='cocala' OR species='cocala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='cocala' OR species='cocala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='cocala' OR junior_species='cocala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='cocala' OR species='cocala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='cytherea' OR junior_species='cytherea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='cytherea' OR species='cytherea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='cytherea' OR species='cytherea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='cytherea' OR junior_species='cytherea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelpha' AND (species='cytherea' OR species='cytherea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='delinita' OR junior_species='delinita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='delinita' OR species='delinita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='delinita' OR species='delinita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='delinita' OR junior_species='delinita')SELECT d.diet,d.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='delinita' OR species='delinita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='erotia' OR junior_species='erotia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='erotia' OR species='erotia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='erotia' OR species='erotia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='erotia' OR junior_species='erotia')SELECT d.diet,d.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='erotia' OR species='erotia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='fabricia' OR junior_species='fabricia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='fabricia' OR species='fabricia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='fabricia' OR species='fabricia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='fabricia' OR junior_species='fabricia')SELECT d.diet,d.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='fabricia' OR species='fabricia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='iphiclus' OR junior_species='iphiclus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='iphiclus' OR species='iphiclus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='iphiclus' OR species='iphiclus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='iphiclus' OR junior_species='iphiclus')SELECT d.diet,d.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='iphiclus' OR species='iphiclus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='malea' OR junior_species='malea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='malea' OR species='malea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='malea' OR species='malea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='malea' OR junior_species='malea')SELECT d.diet,d.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='malea' OR species='malea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='melona' OR junior_species='melona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='melona' OR species='melona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='melona' OR species='melona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='melona' OR junior_species='melona')SELECT d.diet,d.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='melona' OR species='melona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='mesentina' OR junior_species='mesentina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='mesentina' OR species='mesentina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='mesentina' OR species='mesentina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='mesentina' OR junior_species='mesentina')SELECT d.diet,d.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='mesentina' OR species='mesentina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='messana' OR junior_species='messana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='messana' OR species='messana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='messana' OR species='messana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='messana' OR junior_species='messana')SELECT d.diet,d.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='messana' OR species='messana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='plesaure' OR junior_species='plesaure')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='plesaure' OR species='plesaure') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='plesaure' OR species='plesaure')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='plesaure' OR junior_species='plesaure')SELECT d.diet,d.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='plesaure' OR species='plesaure') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='thesprotia' OR junior_species='thesprotia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelpha' AND (species='thesprotia' OR species='thesprotia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelpha' AND (species='thesprotia' OR species='thesprotia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelpha' AND (junior_species='thesprotia' OR junior_species='thesprotia')SELECT d.diet,d.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='thesprotia' OR species='thesprotia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='idomeneus' OR junior_species='idomeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caligo' AND (species='idomeneus' OR species='idomeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caligo' AND (species='idomeneus' OR species='idomeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caligo' AND (junior_species='idomeneus' OR junior_species='idomeneus')SELECT d.diet,d.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='idomeneus' OR species='idomeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='berecynthia' OR junior_species='berecynthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catoblepia' AND (species='berecynthia' OR species='berecynthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catoblepia' AND (species='berecynthia' OR species='berecynthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='berecynthia' OR junior_species='berecynthia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catoblepia' AND (species='berecynthia' OR species='berecynthia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='soranus' OR junior_species='soranus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catoblepia' AND (species='soranus' OR species='soranus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catoblepia' AND (species='soranus' OR species='soranus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catoblepia' AND (junior_species='soranus' OR junior_species='soranus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catoblepia' AND (species='soranus' OR species='soranus') 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='Opsiphanes' AND (junior_species='cassiae' OR junior_species='cassiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opsiphanes' AND (species='cassiae' OR species='cassiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opsiphanes' AND (species='cassiae' OR species='cassiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opsiphanes' AND (junior_species='cassiae' OR junior_species='cassiae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Opsiphanes' AND (species='cassiae' OR species='cassiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opsiphanes' AND (junior_species='invirae' OR junior_species='invirae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opsiphanes' AND (species='invirae' OR species='invirae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opsiphanes' AND (species='invirae' OR species='invirae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opsiphanes' AND (junior_species='invirae' OR junior_species='invirae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Opsiphanes' AND (species='invirae' OR species='invirae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opsiphanes' AND (junior_species='quiteria' OR junior_species='quiteria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opsiphanes' AND (species='quiteria' OR species='quiteria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opsiphanes' AND (species='quiteria' OR species='quiteria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opsiphanes' AND (junior_species='quiteria' OR junior_species='quiteria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Opsiphanes' AND (species='quiteria' OR species='quiteria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobura' AND (junior_species='annulata' OR junior_species='annulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colobura' AND (species='annulata' OR species='annulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colobura' AND (species='annulata' OR species='annulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobura' AND (junior_species='annulata' OR junior_species='annulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colobura' AND (species='annulata' OR species='annulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobura' AND (junior_species='dirce' OR junior_species='dirce')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colobura' AND (species='dirce' OR species='dirce') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colobura' AND (species='dirce' OR species='dirce')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobura' AND (junior_species='dirce' OR junior_species='dirce')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colobura' AND (species='dirce' OR species='dirce') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='pelonia' OR junior_species='pelonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eresia' AND (species='pelonia' OR species='pelonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eresia' AND (species='pelonia' OR species='pelonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eresia' AND (junior_species='pelonia' OR junior_species='pelonia')SELECT d.diet,d.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='pelonia' OR species='pelonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siproeta' AND (junior_species='stelenes' OR junior_species='stelenes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Siproeta' AND (species='stelenes' OR species='stelenes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Siproeta' AND (species='stelenes' OR species='stelenes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Siproeta' AND (junior_species='stelenes' OR junior_species='stelenes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Siproeta' AND (species='stelenes' OR species='stelenes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tigridia' AND (junior_species='acesta' OR junior_species='acesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tigridia' AND (species='acesta' OR species='acesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tigridia' AND (species='acesta' OR species='acesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tigridia' AND (junior_species='acesta' OR junior_species='acesta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tigridia' AND (species='acesta' OR species='acesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='penelope' OR junior_species='penelope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cissia' AND (species='penelope' OR species='penelope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cissia' AND (species='penelope' OR species='penelope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='penelope' OR junior_species='penelope')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cissia' AND (species='penelope' OR species='penelope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='proba' OR junior_species='proba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cissia' AND (species='proba' OR species='proba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cissia' AND (species='proba' OR species='proba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissia' AND (junior_species='proba' OR junior_species='proba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cissia' AND (species='proba' OR species='proba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='hermes' OR junior_species='hermes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hermeuptychia' AND (species='hermes' OR species='hermes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hermeuptychia' AND (species='hermes' OR species='hermes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hermeuptychia' AND (junior_species='hermes' OR junior_species='hermes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hermeuptychia' AND (species='hermes' OR species='hermes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megeuptychia' AND (junior_species='antonoe' OR junior_species='antonoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megeuptychia' AND (species='antonoe' OR species='antonoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megeuptychia' AND (species='antonoe' OR species='antonoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megeuptychia' AND (junior_species='antonoe' OR junior_species='antonoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megeuptychia' AND (species='antonoe' OR species='antonoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='hesionides' OR junior_species='hesionides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareuptychia' AND (species='hesionides' OR species='hesionides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareuptychia' AND (species='hesionides' OR species='hesionides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareuptychia' AND (junior_species='hesionides' OR junior_species='hesionides')SELECT d.diet,d.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='hesionides' OR species='hesionides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='cleopatra' OR junior_species='cleopatra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='cleopatra' OR species='cleopatra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='cleopatra' OR species='cleopatra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='cleopatra' OR junior_species='cleopatra')SELECT d.diet,d.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='cleopatra' OR species='cleopatra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='thamyra' OR junior_species='thamyra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taygetis' AND (species='thamyra' OR species='thamyra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taygetis' AND (species='thamyra' OR species='thamyra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taygetis' AND (junior_species='thamyra' OR junior_species='thamyra')SELECT d.diet,d.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='thamyra' OR species='thamyra') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2306 The Ecological Register: Yasuni Scientific Research Station (April 2002)
Yasuni Scientific Research Station (April 2002)
Basic information
Sample name: Yasuni Scientific Research Station (April 2002)

Reference: M. F. Checa, A. Barragán, J. Rodríguez, and M. Christman. 2009. Temporal abundance patterns of butterfly communities (Lepidoptera: Nymphalidae) in the Ecuadorian Amazonia and their relationship with climate. Annales de la Société Entomologique de France 45(4):470-486 [ER 2248]
Geography
Country: Ecuador


Coordinate: 0° 39' 3" N, 76° 22' 42" W
Coordinate basis: stated in text

Geography comments: "in the Yasuni National Park"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

MAT: 26.0

MAP: 3000.0

Habitat comments: "The park contains extensive areas of primary forest and is inhabited by indigenous groups... Trees reach canopy heights of 30-35 m and emergent trees higher than 50 m exist in the area. The most abundant tree species in the park is a palm, Iriartea deltoidea... Weather is tropical and humid. Rainfall and temperature are aseasonal"

Methods
Life forms: butterflies

Sites: 4

Sampling methods: no design,baited,other traps

Sample size: 474 individuals

Years: 2002

Days: 11

Nets or traps: 48

Net or trap nights: 528

Sampling comments: "Butterflies were successively sampled using Van Someren-Rydon traps.. baited with shrimp (Penaeus vannamei Boone 1931) that had been fermenting for 11–20 days... Using a hierarchical sampling design, four sampling sites were located within four 1ha-plots of undisturbed forest (Fig. 1) near YSRS. The distance between two neighboring plots was over 500 m and all sites were similar in terms of altitude (400– 450 m) and topography. At each site, three baited traps were set up at three different strata, understory (1.5 m), intermediate (10 m) and canopy (20–27 m)... All 48 traps (4 plots × 4 sampling points × 3 strata) were checked daily during the last 11 days of each month from April 2002 to April 2003"

Metadata
Sample number: 2306

Contributor: John Alroy

Enterer: John Alroy

Created: 2016-10-20 21:33:37

Modified: 2018-06-30 11:04:13

Abundance distribution
90 species
26 singletons
total count 474
extrapolated richness: 182.2
Fisher's α: 32.913
geometric series k: 0.9486
Hurlbert's PIE: 0.9251
Shannon's H: 3.5767
Good's u: 0.9453
Each square represents a species. Square sizes are proportional to counts.
Register
Doxocopa agathina agathina3
Doxocopa linda linda1
Doxocopa zunilda felderi1
Asterope markii hewitsoni4
Batesia hypochlora10
Biblis hyperia laticlavia3
Callicore cynosura cynosura2
Callicore hesperis1
Callicore pygas cyllene4
Catonephele acontius acontius7
Catonephele numilia numilia14
Catonephele salacia2
Diaethria clymena peruviana5
Eunica concordia2
Eunica marsolia fasula2
Eunica orphise1
Eunica sophonisba agele6
Hamadryas arinome arinome1
Hamadryas chloe chloe2
Marpesia berania berania3
Marpesia chiron marius3
Myscelia capenas octomaculata10
Nessaea hewitsonii hewitsonii2
Nessaea obrinus lesoudieri1
Nica flavilla sylvestris2
Panacea procilla divalis110
Panacea prola amazonica2
Peria lamis1
Pyrrhogyra amphiro amphiro3
Pyrrhogyra crameri nautaca6
Pyrrhogyra edocla lysanias3
Pyrrhogyra neaerea argina1
Pyrrhogyra otolais olivenca13
Temenis laothoe laothoe49
Temenis pulchra pallidior4
Vila emilia caecilia1
Agrias claudina lugens2
Anaeomorpha splendida1
Archaeoprepona demophon demophon1
Archaeoprepona demophoon andicola1
Archaeoprepona licomedes licomedes4
Archaeoprepona meander meander1
Fountainea eurypyle eurypyle3
Memphis acidalia memphis16
Memphis basilia drucei5
Memphis moruus morpheus1
Memphis philumena philumena1
Memphis polycarmes2
Prepona laertes demodice2
Prepona pheridamas1
Zaretis isidora6
Heliconius elevatus willmotti1
Heliconius hecale quitalena2
Heliconius melpomene malleti2
Heliconius numata euphrasius2
Laparus doris doris4
Adelpha attica attica3
Adelpha boeotia boeotia2
Adelpha capucinus capucinus7
Adelpha cocala cocala4
Adelpha cytherea cytherea1
Adelpha delinita delinita1
Adelpha erotia erotia3
Adelpha fabricia2
Adelpha iphiclus iphiclus4
Adelpha malea aethalia1
Adelpha melona leucocoma2
Adelpha mesentina7
Adelpha messana delphicola5
Adelpha plesaure phliassa2
Adelpha thesprotia5
Caligo idomeneus idomenides2
Catoblepia berecynthia midas3
Catoblepia soranus1
Morpho helenor theodorus4
Opsiphanes cassiae rubigatus2
Opsiphanes invirae intermedius23
Opsiphanes quiteria quaestor6
Colobura annulata6
Colobura dirce dirce5
Eresia pelonia callonia1
Siproeta stelenes meridionalis2
Tigridia acesta fulvescens5
Cissia penelope1
Cissia proba1
Hermeuptychia hermes10
Megeuptychia antonoe6
Pareuptychia hesionides1
Taygetis cleopatra2
Taygetis thamyra1