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=650 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=650SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=331SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=650 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='leda' OR species='leda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='phedima' OR junior_species='phedima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='phedima' OR species='phedima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='phedima' OR species='phedima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='phedima' OR junior_species='phedima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanitis' AND (species='phedima' OR species='phedima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='patna' OR junior_species='patna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='patna' OR species='patna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='patna' OR species='patna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='patna' OR junior_species='patna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elymnias' AND (species='patna' OR species='patna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='hypermnestra' OR junior_species='hypermnestra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='hypermnestra' OR species='hypermnestra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='hypermnestra' OR species='hypermnestra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='hypermnestra' OR junior_species='hypermnestra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elymnias' AND (species='hypermnestra' OR species='hypermnestra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='malelas' OR junior_species='malelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='malelas' OR species='malelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='malelas' OR species='malelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='malelas' OR junior_species='malelas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elymnias' AND (species='malelas' OR species='malelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penthema' AND (junior_species='michallati' OR junior_species='michallatii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Penthema' AND (species='michallati' OR species='michallatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Penthema' AND (species='michallati' OR species='michallatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Penthema' AND (junior_species='michallati' OR junior_species='michallatii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Penthema' AND (species='michallati' OR species='michallatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='confusa' OR junior_species='confusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='confusa' OR species='confusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='confusa' OR species='confusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='confusa' OR junior_species='confusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lethe' AND (species='confusa' OR species='confusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neope' AND (junior_species='muirheadi' OR junior_species='muirheadii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neope' AND (species='muirheadi' OR species='muirheadii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neope' AND (species='muirheadi' OR species='muirheadii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neope' AND (junior_species='muirheadi' OR junior_species='muirheadii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neope' AND (species='muirheadi' OR species='muirheadii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orsotriaena' AND (junior_species='medus' OR junior_species='medus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orsotriaena' AND (species='medus' OR species='medus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orsotriaena' AND (species='medus' OR species='medus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orsotriaena' AND (junior_species='medus' OR junior_species='medus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orsotriaena' AND (species='medus' OR species='medus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='inopia' OR junior_species='inopia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='inopia' OR species='inopia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='inopia' OR species='inopia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='inopia' OR junior_species='inopia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='inopia' OR species='inopia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='anaxias' OR junior_species='anaxias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='anaxias' OR species='anaxias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='anaxias' OR species='anaxias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='anaxias' OR junior_species='anaxias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='anaxias' OR species='anaxias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='gotama' OR junior_species='gotama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='gotama' OR species='gotama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='gotama' OR species='gotama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='gotama' OR junior_species='gotama')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='gotama' OR species='gotama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='perseus' OR junior_species='perseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='perseus' OR species='perseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='perseus' OR species='perseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='perseus' OR junior_species='perseus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='perseus' OR species='perseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mineus' OR junior_species='mineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='mineus' OR species='mineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='mineus' OR species='mineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mineus' OR junior_species='mineus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='mineus' OR species='mineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='perseoides' OR junior_species='perseoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='perseoides' OR species='perseoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='perseoides' OR species='perseoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='perseoides' OR junior_species='perseoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='perseoides' OR species='perseoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='intermedia' OR species='intermedia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='intermedia' OR species='intermedia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='intermedia' OR species='intermedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mucianus' OR junior_species='mucianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='mucianus' OR species='mucianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='mucianus' OR species='mucianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mucianus' OR junior_species='mucianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='mucianus' OR species='mucianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='sangaica' OR junior_species='sangaica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='sangaica' OR species='sangaica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='sangaica' OR species='sangaica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='sangaica' OR junior_species='sangaica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='sangaica' OR species='sangaica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='malsara' OR junior_species='malsara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='malsara' OR species='malsara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='malsara' OR species='malsara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='malsara' OR junior_species='malsara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='malsara' OR species='malsara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='annamitica' OR junior_species='annamitica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='annamitica' OR species='annamitica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='annamitica' OR species='annamitica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='annamitica' OR junior_species='annamitica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='annamitica' OR species='annamitica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='baldus' OR junior_species='baldus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='baldus' OR species='baldus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='baldus' OR species='baldus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='baldus' OR junior_species='baldus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ypthima' AND (species='baldus' OR species='baldus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='huebneri' OR junior_species='huebnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='huebneri' OR species='huebnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='huebneri' OR species='huebnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='huebneri' OR junior_species='huebnerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ypthima' AND (species='huebneri' OR species='huebnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zipaetis' AND (junior_species='unipupillata' OR junior_species='unipupillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zipaetis' AND (species='unipupillata' OR species='unipupillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zipaetis' AND (species='unipupillata' OR species='unipupillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zipaetis' AND (junior_species='unipupillata' OR junior_species='unipupillata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zipaetis' AND (species='unipupillata' OR species='unipupillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadne' AND (junior_species='ariadne' OR junior_species='ariadne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ariadne' AND (species='ariadne' OR species='ariadne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ariadne' AND (species='ariadne' OR species='ariadne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadne' AND (junior_species='ariadne' OR junior_species='ariadne')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ariadne' AND (species='ariadne' OR species='ariadne') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='almana' OR junior_species='almana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='almana' OR species='almana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='almana' OR species='almana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='almana' OR junior_species='almana')SELECT d.diet,d.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='almana' OR species='almana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='lemonias' OR junior_species='lemonias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='lemonias' OR species='lemonias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='lemonias' OR species='lemonias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='lemonias' OR junior_species='lemonias')SELECT d.diet,d.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='lemonias' OR species='lemonias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='bolina' OR junior_species='bolina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolimnas' AND (species='bolina' OR species='bolina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolimnas' AND (species='bolina' OR species='bolina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='bolina' OR junior_species='bolina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypolimnas' AND (species='bolina' OR species='bolina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='inachus' OR junior_species='inachus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kallima' AND (species='inachus' OR species='inachus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kallima' AND (species='inachus' OR species='inachus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='inachus' OR junior_species='inachus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kallima' AND (species='inachus' OR species='inachus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='hylas' OR species='hylas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='hylas' OR species='hylas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='hylas' OR junior_species='hylas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neptis' AND (species='hylas' OR species='hylas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantoporia' AND (junior_species='hordonia' OR junior_species='hordonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantoporia' AND (species='hordonia' OR species='hordonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantoporia' AND (species='hordonia' OR species='hordonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantoporia' AND (junior_species='hordonia' OR junior_species='hordonia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pantoporia' AND (species='hordonia' OR species='hordonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='niepelti' OR junior_species='niepeltii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tanaecia' AND (species='niepelti' OR species='niepeltii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tanaecia' AND (species='niepelti' OR species='niepeltii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='niepelti' OR junior_species='niepeltii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tanaecia' AND (species='niepelti' OR species='niepeltii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthalia' AND (junior_species='phemius' OR junior_species='phemius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euthalia' AND (species='phemius' OR species='phemius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euthalia' AND (species='phemius' OR species='phemius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthalia' AND (junior_species='phemius' OR junior_species='phemius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euthalia' AND (species='phemius' OR species='phemius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lexias' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lexias' AND (species='pardalis' OR species='pardalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lexias' AND (species='pardalis' OR species='pardalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lexias' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lexias' AND (species='pardalis' OR species='pardalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stibochiona' AND (junior_species='nicea' OR junior_species='nicea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stibochiona' AND (species='nicea' OR species='nicea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stibochiona' AND (species='nicea' OR species='nicea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stibochiona' AND (junior_species='nicea' OR junior_species='nicea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stibochiona' AND (species='nicea' OR species='nicea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rohana' AND (junior_species='tonkiniana' OR junior_species='tonkiniana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rohana' AND (species='tonkiniana' OR species='tonkiniana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rohana' AND (species='tonkiniana' OR species='tonkiniana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rohana' AND (junior_species='tonkiniana' OR junior_species='tonkiniana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rohana' AND (species='tonkiniana' OR species='tonkiniana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herona' AND (junior_species='marathus' OR junior_species='marathus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herona' AND (species='marathus' OR species='marathus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herona' AND (species='marathus' OR species='marathus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herona' AND (junior_species='marathus' OR junior_species='marathus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Herona' AND (species='marathus' OR species='marathus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='athamas' OR junior_species='athamas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyura' AND (species='athamas' OR species='athamas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyura' AND (species='athamas' OR species='athamas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyura' AND (junior_species='athamas' OR junior_species='athamas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polyura' AND (species='athamas' OR species='athamas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stichophthalama' AND (junior_species='suffusa' OR junior_species='suffusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stichophthalama' AND (species='suffusa' OR species='suffusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stichophthalama' AND (species='suffusa' OR species='suffusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stichophthalama' AND (junior_species='suffusa' OR junior_species='suffusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stichophthalama' AND (species='suffusa' OR species='suffusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stichophthalama' AND (junior_species='fruhstorferi' OR junior_species='fruhstorferii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stichophthalama' AND (species='fruhstorferi' OR species='fruhstorferii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stichophthalama' AND (species='fruhstorferi' OR species='fruhstorferii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stichophthalama' AND (junior_species='fruhstorferi' OR junior_species='fruhstorferii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stichophthalama' AND (species='fruhstorferi' OR species='fruhstorferii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thauria' AND (junior_species='lathyi' OR junior_species='lathyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thauria' AND (species='lathyi' OR species='lathyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thauria' AND (species='lathyi' OR species='lathyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thauria' AND (junior_species='lathyi' OR junior_species='lathyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thauria' AND (species='lathyi' OR species='lathyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='sondaica' OR junior_species='sondaica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discophora' AND (species='sondaica' OR species='sondaica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discophora' AND (species='sondaica' OR species='sondaica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='sondaica' OR junior_species='sondaica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discophora' AND (species='sondaica' OR species='sondaica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='deo' OR junior_species='deo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discophora' AND (species='deo' OR species='deo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discophora' AND (species='deo' OR species='deo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='deo' OR junior_species='deo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discophora' AND (species='deo' OR species='deo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zemeros' AND (junior_species='flegyas' OR junior_species='flegyas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zemeros' AND (species='flegyas' OR species='flegyas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zemeros' AND (species='flegyas' OR species='flegyas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zemeros' AND (junior_species='flegyas' OR junior_species='flegyas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zemeros' AND (species='flegyas' OR species='flegyas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosotas' AND (junior_species='nora' OR junior_species='nora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prosotas' AND (species='nora' OR species='nora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prosotas' AND (species='nora' OR species='nora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosotas' AND (junior_species='nora' OR junior_species='nora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prosotas' AND (species='nora' OR species='nora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthene' AND (junior_species='emolus' OR junior_species='emolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthene' AND (species='emolus' OR species='emolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthene' AND (species='emolus' OR species='emolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthene' AND (junior_species='emolus' OR junior_species='emolus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anthene' AND (species='emolus' OR species='emolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxura' AND (junior_species='athymnus' OR junior_species='athymnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxura' AND (species='athymnus' OR species='athymnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loxura' AND (species='athymnus' OR species='athymnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxura' AND (junior_species='athymnus' OR junior_species='athymnus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Loxura' AND (species='athymnus' OR species='athymnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yasoda' 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='Yasoda' AND (species='tripunctata' OR species='tripunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yasoda' AND (species='tripunctata' OR species='tripunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yasoda' 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='Yasoda' AND (species='tripunctata' OR species='tripunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='mulciber' OR junior_species='mulciber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='mulciber' OR species='mulciber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='mulciber' OR species='mulciber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='mulciber' OR junior_species='mulciber')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euploea' AND (species='mulciber' OR species='mulciber') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=650 The Ecological Register: Ba Be National Park (butterflies)
Ba Be National Park (butterflies)
Basic information
Sample name: Ba Be National Park (butterflies)

Reference: L. Hayes, D. J. Mann, A. L. Monastyrskii, and O. T. Lewis. 2009. Rapid assessments of tropical dung beetle and butterfly assemblages: contrasting trends along a forest disturbance gradient. Insect Conservation and Diversity 2:194-203 [ER 331]
Geography
Country: Vietnam

State: Bac Can


Coordinate: 22° 24' N, 105° 37' E
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

Disturbance: selective logging

MAT: 22.0

MAP: 1300.0

Habitat comments: "lowland evergreen forest" including "a range of forest disturbance levels"
there is a six-month dry season and the climate is "monsoon tropical"

Methods
Life forms: butterflies

Sites: 1

Site length: 1500

Sampling methods: line transect,baited,other traps

Sample size: 584 individuals

Years: 2005

Days: 28

Nets or traps: 15

Net or trap nights: 420

Sampling comments: "15 sampling points along a 1.5 km straight-line transect... Trapping took place on 28 days between 4 August and 5 September" and there was one trap per point
butterflies were caught "with Van Someron-Rydon traps... suspended 1-2 m above the ground" and "baited with fermenting bananas"

Metadata
Sample number: 650

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-29 22:24:05

Modified: 2015-10-01 10:07:22

Abundance distribution
48 species
13 singletons
total count 584
extrapolated richness: 83.1
Fisher's α: 12.390
geometric series k: 0.8952
Hurlbert's PIE: 0.8703
Shannon's H: 2.7713
Good's u: 0.9778
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Melanitis leda182
Melanitis phedima38
Elymnias patna7
Elymnias hypermnestra4
Elymnias malelas2
Penthema michallati6
Lethe confusa5
Neope muirheadi2
Orsotriaena medus61
Mycalesis inopia5
Mycalesis anaxias4
Mycalesis gotama2
Mycalesis perseus1
Mycalesis mineus48
Mycalesis perseoides34
Mycalesis intermedia24
Mycalesis mucianus13
Mycalesis sangaica3
Mycalesis malsara23
Mycalesis annamitica15
Ypthima baldus4
Ypthima huebneri1
Zipaetis unipupillata2
Ariadne ariadne5
Junonia almana1
Junonia lemonias2
Hypolimnas bolina1
Kallima inachus1
Neptis hylas9
Pantoporia hordonia3
Tanaecia niepelti1
Euthalia phemius1
Lexias pardalis1
Stibochiona nicea11
Rohana tonkiniana5
Herona marathus1
Polyura athamas7
Stichophthalama suffusa tonkiniana10
Stichophthalama fruhstorferi2
Thauria lathyi4
Discophora sondaica9
Discophora deo1
Zemeros flegyas12
Prosotas nora1
Anthene emolus5
Loxura athymnus1
Yasoda tripunctata3
Euploea mulciber1