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=3114 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3114SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2901SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3114 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atrophaneura' AND (junior_species='coon' OR junior_species='coon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atrophaneura' AND (species='coon' OR species='coon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atrophaneura' AND (species='coon' OR species='coon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atrophaneura' AND (junior_species='coon' OR junior_species='coon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Atrophaneura' AND (species='coon' OR species='coon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atrophaneura' AND (junior_species='nox' OR junior_species='nox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atrophaneura' AND (species='nox' OR species='nox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atrophaneura' AND (species='nox' OR species='nox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atrophaneura' AND (junior_species='nox' OR junior_species='nox')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Atrophaneura' AND (species='nox' OR species='nox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atrophaneura' AND (junior_species='priapus' OR junior_species='priapus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atrophaneura' AND (species='priapus' OR species='priapus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atrophaneura' AND (species='priapus' OR species='priapus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atrophaneura' AND (junior_species='priapus' OR junior_species='priapus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Atrophaneura' AND (species='priapus' OR species='priapus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='sarpedon' OR junior_species='sarpedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='sarpedon' OR species='sarpedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='sarpedon' OR species='sarpedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='sarpedon' OR junior_species='sarpedon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Graphium' AND (species='sarpedon' OR species='sarpedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='acheron' OR junior_species='acheron')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='acheron' OR species='acheron') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='acheron' OR species='acheron')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='acheron' OR junior_species='acheron')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='acheron' OR species='acheron') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demolion' OR junior_species='demolion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='demolion' OR species='demolion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='demolion' OR species='demolion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='demolion' OR junior_species='demolion')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='demolion' OR species='demolion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='memnon' OR junior_species='memnon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='memnon' OR species='memnon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='memnon' OR species='memnon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='memnon' OR junior_species='memnon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Papilio' AND (species='memnon' OR species='memnon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='lyncida' OR junior_species='lyncida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Appias' AND (species='lyncida' OR species='lyncida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Appias' AND (species='lyncida' OR species='lyncida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='lyncida' OR junior_species='lyncida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Appias' AND (species='lyncida' OR species='lyncida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='cardena' OR junior_species='cardena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Appias' AND (species='cardena' OR species='cardena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Appias' AND (species='cardena' OR species='cardena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='cardena' OR junior_species='cardena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Appias' AND (species='cardena' OR species='cardena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='pomona' OR junior_species='pomona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsilia' AND (species='pomona' OR species='pomona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsilia' AND (species='pomona' OR species='pomona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='pomona' OR junior_species='pomona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catopsilia' AND (species='pomona' OR species='pomona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='pyranthe' OR junior_species='pyranthe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsilia' AND (species='pyranthe' OR species='pyranthe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsilia' AND (species='pyranthe' OR species='pyranthe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='pyranthe' OR junior_species='pyranthe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catopsilia' AND (species='pyranthe' OR species='pyranthe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='florella' OR junior_species='florella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsilia' AND (species='florella' OR species='florella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catopsilia' AND (species='florella' OR species='florella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catopsilia' AND (junior_species='florella' OR junior_species='florella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catopsilia' AND (species='florella' OR species='florella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepora' AND (junior_species='iudith' OR junior_species='iudith')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cepora' AND (species='iudith' OR species='iudith') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cepora' AND (species='iudith' OR species='iudith')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepora' AND (junior_species='iudith' OR junior_species='iudith')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cepora' AND (species='iudith' OR species='iudith') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='ada' OR junior_species='ada')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='ada' OR species='ada') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='ada' OR species='ada')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='ada' OR junior_species='ada')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurema' AND (species='ada' OR species='ada') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='andersonii' OR junior_species='andersoni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='andersonii' OR species='andersoni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='andersonii' OR species='andersoni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='andersonii' OR junior_species='andersoni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurema' AND (species='andersonii' OR species='andersoni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='belisama' OR junior_species='belisama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='belisama' OR species='belisama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='belisama' OR species='belisama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='belisama' OR junior_species='belisama')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Delias' AND (species='belisama' OR species='belisama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='descombesi' OR junior_species='descombesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='descombesi' OR species='descombesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='descombesi' OR species='descombesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='descombesi' OR junior_species='descombesii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Delias' AND (species='descombesi' OR species='descombesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='crithoe' OR junior_species='crithoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='crithoe' OR species='crithoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='crithoe' OR species='crithoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='crithoe' OR junior_species='crithoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Delias' AND (species='crithoe' OR species='crithoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='pasithoe' OR junior_species='pasithoe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='pasithoe' OR species='pasithoe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='pasithoe' OR species='pasithoe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='pasithoe' OR junior_species='pasithoe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Delias' AND (species='pasithoe' OR species='pasithoe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gandaca' AND (junior_species='harina' OR junior_species='harina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gandaca' AND (species='harina' OR species='harina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gandaca' AND (species='harina' OR species='harina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gandaca' AND (junior_species='harina' OR junior_species='harina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gandaca' AND (species='harina' OR species='harina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='cama' OR junior_species='cama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='cama' OR species='cama') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='cama' OR species='cama')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='cama' OR junior_species='cama')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Athyma' AND (species='cama' OR species='cama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='pravara' OR junior_species='pravara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='pravara' OR species='pravara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='pravara' OR species='pravara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='pravara' OR junior_species='pravara')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Athyma' AND (species='pravara' OR species='pravara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersonesia' AND (junior_species='peraka' OR junior_species='peraka')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chersonesia' AND (species='peraka' OR species='peraka') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chersonesia' AND (species='peraka' OR species='peraka')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chersonesia' AND (junior_species='peraka' OR junior_species='peraka')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chersonesia' AND (species='peraka' OR species='peraka') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cirrochroa' AND (junior_species='clagia' OR junior_species='clagia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cirrochroa' AND (species='clagia' OR species='clagia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cirrochroa' AND (species='clagia' OR species='clagia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cirrochroa' AND (junior_species='clagia' OR junior_species='clagia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cirrochroa' AND (species='clagia' OR species='clagia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cirrochroa' AND (junior_species='emalea' OR junior_species='emalea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cirrochroa' AND (species='emalea' OR species='emalea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cirrochroa' AND (species='emalea' OR species='emalea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cirrochroa' AND (junior_species='emalea' OR junior_species='emalea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cirrochroa' AND (species='emalea' OR species='emalea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupha' AND (junior_species='arias' OR junior_species='arias')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupha' AND (species='arias' OR species='arias') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupha' AND (species='arias' OR species='arias')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupha' AND (junior_species='arias' OR junior_species='arias')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cupha' AND (species='arias' OR species='arias') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynitia' AND (junior_species='iapsis' OR junior_species='iapsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynitia' AND (species='iapsis' OR species='iapsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynitia' AND (species='iapsis' OR species='iapsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynitia' AND (junior_species='iapsis' OR junior_species='iapsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cynitia' AND (species='iapsis' OR species='iapsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rohana' AND (junior_species='nakula' OR junior_species='nakula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rohana' AND (species='nakula' OR species='nakula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rohana' AND (species='nakula' OR species='nakula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rohana' AND (junior_species='nakula' OR junior_species='nakula')SELECT d.diet,d.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='nakula' OR species='nakula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbrenthia' AND (junior_species='anna' OR junior_species='anna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symbrenthia' AND (species='anna' OR species='anna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symbrenthia' AND (species='anna' OR species='anna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbrenthia' AND (junior_species='anna' OR junior_species='anna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Symbrenthia' AND (species='anna' OR species='anna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbrenthia' AND (junior_species='hypselis' OR junior_species='hypselis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symbrenthia' AND (species='hypselis' OR species='hypselis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symbrenthia' AND (species='hypselis' OR species='hypselis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symbrenthia' AND (junior_species='hypselis' OR junior_species='hypselis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Symbrenthia' AND (species='hypselis' OR species='hypselis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='trigerta' OR junior_species='trigerta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tanaecia' AND (species='trigerta' OR species='trigerta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tanaecia' AND (species='trigerta' OR species='trigerta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='trigerta' OR junior_species='trigerta')SELECT d.diet,d.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='trigerta' OR species='trigerta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='atlites' OR junior_species='atlites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='atlites' OR species='atlites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='atlites' OR species='atlites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='atlites' OR junior_species='atlites')SELECT d.diet,d.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='atlites' OR species='atlites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='hedonia' OR junior_species='hedonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='hedonia' OR species='hedonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='hedonia' OR species='hedonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='hedonia' OR junior_species='hedonia')SELECT d.diet,d.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='hedonia' OR species='hedonia') 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='Lasippa' AND (junior_species='heliodore' OR junior_species='heliodore')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasippa' AND (species='heliodore' OR species='heliodore') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasippa' AND (species='heliodore' OR species='heliodore')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasippa' AND (junior_species='heliodore' OR junior_species='heliodore')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasippa' AND (species='heliodore' OR species='heliodore') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasippa' AND (junior_species='tiga' OR junior_species='tiga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasippa' AND (species='tiga' OR species='tiga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasippa' AND (species='tiga' OR species='tiga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasippa' AND (junior_species='tiga' OR junior_species='tiga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasippa' AND (species='tiga' OR species='tiga') 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='Hypolimnas' AND (junior_species='misippus' OR junior_species='misippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypolimnas' AND (species='misippus' OR species='misippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypolimnas' AND (species='misippus' OR species='misippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypolimnas' AND (junior_species='misippus' OR junior_species='misippus')SELECT d.diet,d.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='misippus' OR species='misippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stibochiona' AND (junior_species='coresia' OR junior_species='coresia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stibochiona' AND (species='coresia' OR species='coresia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stibochiona' AND (species='coresia' OR species='coresia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stibochiona' AND (junior_species='coresia' OR junior_species='coresia')SELECT d.diet,d.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='coresia' OR species='coresia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthalia' AND (junior_species='monina' OR junior_species='monina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euthalia' AND (species='monina' OR species='monina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euthalia' AND (species='monina' OR species='monina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthalia' AND (junior_species='monina' OR junior_species='monina')SELECT d.diet,d.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='monina' OR species='monina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='nisea' OR junior_species='nisea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='nisea' OR species='nisea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='nisea' OR species='nisea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='nisea' OR junior_species='nisea')SELECT d.diet,d.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='nisea' OR species='nisea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Danaus' AND (species='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='climena' OR junior_species='climena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='climena' OR species='climena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='climena' OR species='climena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='climena' OR junior_species='climena')SELECT d.diet,d.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='climena' OR species='climena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='gamelia' OR junior_species='gamelia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euploea' AND (species='gamelia' OR species='gamelia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euploea' AND (species='gamelia' OR species='gamelia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euploea' AND (junior_species='gamelia' OR junior_species='gamelia')SELECT d.diet,d.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='gamelia' OR species='gamelia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='albata' OR junior_species='albata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parantica' AND (species='albata' OR species='albata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parantica' AND (species='albata' OR species='albata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='albata' OR junior_species='albata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parantica' AND (species='albata' OR species='albata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='casiphone' OR junior_species='casiphone')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='casiphone' OR species='casiphone') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='casiphone' OR species='casiphone')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='casiphone' OR junior_species='casiphone')SELECT d.diet,d.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='casiphone' OR species='casiphone') 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='nesaea' OR junior_species='nesaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='nesaea' OR species='nesaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='nesaea' OR species='nesaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='nesaea' OR junior_species='nesaea')SELECT d.diet,d.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='nesaea' OR species='nesaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='europa' OR junior_species='europa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='europa' OR species='europa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='europa' OR species='europa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='europa' OR junior_species='europa')SELECT d.diet,d.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='europa' OR species='europa') ORDER BY year,last_namesSELECT 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='zitenius' OR junior_species='zitenius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='zitenius' OR species='zitenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='zitenius' OR species='zitenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='zitenius' OR junior_species='zitenius')SELECT d.diet,d.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='zitenius' OR species='zitenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='sudra' OR junior_species='sudra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='sudra' OR species='sudra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='sudra' OR species='sudra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='sudra' OR junior_species='sudra')SELECT d.diet,d.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='sudra' OR species='sudra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='nigricans' OR junior_species='nigricans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='nigricans' OR species='nigricans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='nigricans' OR species='nigricans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='nigricans' OR junior_species='nigricans')SELECT d.diet,d.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='nigricans' OR species='nigricans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthopala' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arthopala' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arthopala' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arthopala' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arthopala' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosotas' AND (junior_species='dubiosa' OR junior_species='dubiosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prosotas' AND (species='dubiosa' OR species='dubiosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prosotas' AND (species='dubiosa' OR species='dubiosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosotas' AND (junior_species='dubiosa' OR junior_species='dubiosa')SELECT d.diet,d.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='dubiosa' OR species='dubiosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacalana' AND (junior_species='vidura' OR junior_species='vidura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacalana' AND (species='vidura' OR species='vidura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacalana' AND (species='vidura' OR species='vidura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacalana' AND (junior_species='vidura' OR junior_species='vidura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dacalana' AND (species='vidura' OR species='vidura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='angusta' OR junior_species='angusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nacaduba' AND (species='angusta' OR species='angusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nacaduba' AND (species='angusta' OR species='angusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='angusta' OR junior_species='angusta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nacaduba' AND (species='angusta' OR species='angusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='kurava' OR junior_species='kurava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nacaduba' AND (species='kurava' OR species='kurava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nacaduba' AND (species='kurava' OR species='kurava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='kurava' OR junior_species='kurava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nacaduba' AND (species='kurava' OR species='kurava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nacaduba' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nacaduba' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nacaduba' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nacaduba' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Surendra' AND (junior_species='vivarna' OR junior_species='vivarna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Surendra' AND (species='vivarna' OR species='vivarna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Surendra' AND (species='vivarna' OR species='vivarna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Surendra' AND (junior_species='vivarna' OR junior_species='vivarna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Surendra' AND (species='vivarna' OR species='vivarna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophorus' AND (junior_species='epicles' OR junior_species='epicles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliophorus' AND (species='epicles' OR species='epicles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliophorus' AND (species='epicles' OR species='epicles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliophorus' AND (junior_species='epicles' OR junior_species='epicles')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliophorus' AND (species='epicles' OR species='epicles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='alecto' OR junior_species='alecto')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='alecto' OR species='alecto') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='alecto' OR species='alecto')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='alecto' OR junior_species='alecto')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='alecto' OR species='alecto') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='celeno' OR junior_species='celeno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='celeno' OR species='celeno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='celeno' OR species='celeno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='celeno' OR junior_species='celeno')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='celeno' OR species='celeno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='cunilda' OR junior_species='cunilda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='cunilda' OR species='cunilda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='cunilda' OR species='cunilda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='cunilda' OR junior_species='cunilda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='cunilda' OR species='cunilda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='cyta' OR junior_species='cyta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='cyta' OR species='cyta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='cyta' OR species='cyta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='cyta' OR junior_species='cyta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='cyta' OR species='cyta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='pura' OR junior_species='pura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='pura' OR species='pura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='pura' OR species='pura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='pura' OR junior_species='pura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='pura' OR species='pura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poritia' AND (junior_species='eryconoides' OR junior_species='eryconoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poritia' AND (species='eryconoides' OR species='eryconoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poritia' AND (species='eryconoides' OR species='eryconoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poritia' AND (junior_species='eryconoides' OR junior_species='eryconoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poritia' AND (species='eryconoides' OR species='eryconoides') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3114 The Ecological Register: Baturaden Forest (tourist area)
Baturaden Forest (tourist area)
Basic information
Sample name: Baturaden Forest (tourist area)

Sample aka: Mount Slamet

Reference: I. Widhiono. 2015. Diversity of butterflies in four different forest types in Mount Slamet, Central Java, Indonesia. Biodiversitas 16(2):196-204 [ER 2901]
Geography
Country: Indonesia

State: Central Java


Coordinate: 7° 18' 31" S, 109° 13' 47" E
Coordinate basis: stated in text

Geography comments: "in Baturaden Forest, East Banyumas Forest Management Unit on the southern slope of Mount Slamet"
elevation 600 to 800 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: inhabited area

Protection: national/state forest

Substrate: ground surface

Disturbance: agriculture

MAP: 4500.0

Habitat comments: "tourist or recreational areas... Originally, TAs functioned as campgrounds, but at present, more than 50% of all TAs consist of open gardens with white exotic plant species"

Methods
Life forms: butterflies

Sampling methods: line transect,butterfly nets

Sample size: 3231 individuals

Years: 2009, 2010

Days: 56

Sampling comments: "surveying... was conducted from July 2009 to August 2010, following the Modified Pollard Walk Method with kite netting... Five permanent lines of transects (PLTs) (~ 0.5 km long and 5 m wide) were laid... Butterflies were captured... for four consecutive days. This process was repeated at 30-day intervals" (presumably 14 times) and specimens were collected

Metadata
Sample number: 3114

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-12-21 15:31:22

Modified: 2020-01-14 07:53:38

Abundance distribution
67 species
1 singleton
total count 3231
extrapolated richness: 74.1
Fisher's α: 11.958
geometric series k: 0.9174
Hurlbert's PIE: 0.9691
Shannon's H: 3.7422
Good's u: 0.9997
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Atrophaneura coon3
Atrophaneura nox2
Atrophaneura priapus6
Graphium sarpedon19
Papilio acheron6
Papilio demolion7
Papilio memnon23
Appias lyncida84
Appias cardena15
Catopsilia pomona134
Catopsilia pyranthe113
Catopsilia florella135
Cepora iudith112
Eurema ada98
Eurema andersonii129
Delias belisama68
Delias descombesi57
Delias crithoe90
Delias pasithoe3
Gandaca harina88
Athyma cama36
Athyma pravara57
Chersonesia peraka33
Cirrochroa clagia1
Cirrochroa emalea3
Cupha arias7
Cynitia iapsis8
Rohana nakula4
Symbrenthia anna104
Symbrenthia hypselis51
Tanaecia trigerta54
Junonia atlites27
Junonia hedonia23
Junonia almana93
Lasippa heliodore124
Lasippa tiga15
Hypolimnas bolina38
Hypolimnas misippus20
Stibochiona coresia17
Euthalia monina49
Neptis nisea66
Danaus vulgaris11
Euploea climena7
Euploea gamelia103
Parantica albata6
Elymnias casiphone16
Elymnias hypermnestra78
Elymnias nesaea22
Lethe europa62
Melanitis leda54
Melanitis zitenius47
Mycalesis sudra86
Ypthima nigricans296
Arthopala sp.17
Prosotas dubiosa21
Dacalana vidura2
Nacaduba angusta23
Nacaduba kurava69
Nacaduba sp.3
Surendra vivarna7
Heliophorus epicles44
Jamides alecto79
Jamides celeno20
Jamides cunilda5
Jamides cyta10
Jamides pura93
Poritia eryconoides28