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=3111 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3111SELECT 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=3111 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='helenus' OR junior_species='helenus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='helenus' OR species='helenus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='helenus' OR species='helenus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='helenus' OR junior_species='helenus')SELECT d.diet,d.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='helenus' OR species='helenus') 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='Papilio' AND (junior_species='paris' OR junior_species='paris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='paris' OR species='paris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='paris' OR species='paris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='paris' OR junior_species='paris')SELECT d.diet,d.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='paris' OR species='paris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='polytes' OR species='polytes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='polytes' OR species='polytes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='polytes' OR junior_species='polytes')SELECT d.diet,d.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='polytes' OR species='polytes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='paradoxa' OR junior_species='paradoxa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chilasa' AND (species='paradoxa' OR species='paradoxa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chilasa' AND (species='paradoxa' OR species='paradoxa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chilasa' AND (junior_species='paradoxa' OR junior_species='paradoxa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chilasa' AND (species='paradoxa' OR species='paradoxa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troides' AND (junior_species='helena' OR junior_species='helena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troides' AND (species='helena' OR species='helena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troides' AND (species='helena' OR species='helena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troides' AND (junior_species='helena' OR junior_species='helena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Troides' AND (species='helena' OR species='helena') 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='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='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='Delias' AND (junior_species='periboea' OR junior_species='periboea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Delias' AND (species='periboea' OR species='periboea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Delias' AND (species='periboea' OR species='periboea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Delias' AND (junior_species='periboea' OR junior_species='periboea')SELECT d.diet,d.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='periboea' OR species='periboea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='nina' OR junior_species='nina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptosia' AND (species='nina' OR species='nina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptosia' AND (species='nina' OR species='nina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='nina' OR junior_species='nina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptosia' AND (species='nina' OR species='nina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prioneris' AND (junior_species='autothisbe' OR junior_species='autothisbe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prioneris' AND (species='autothisbe' OR species='autothisbe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prioneris' AND (species='autothisbe' OR species='autothisbe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prioneris' AND (junior_species='autothisbe' OR junior_species='autothisbe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prioneris' AND (species='autothisbe' OR species='autothisbe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnosia' AND (junior_species='decora' OR junior_species='decora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amnosia' AND (species='decora' OR species='decora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amnosia' AND (species='decora' OR species='decora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnosia' AND (junior_species='decora' OR junior_species='decora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amnosia' AND (species='decora' OR species='decora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnosia' AND (junior_species='decora' OR junior_species='decora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amnosia' AND (species='decora' OR species='decora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amnosia' AND (species='decora' OR species='decora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnosia' AND (junior_species='decora' OR junior_species='decora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amnosia' AND (species='decora' OR species='decora') 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='Cethosia' AND (junior_species='munjava' OR junior_species='munjava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cethosia' AND (species='munjava' OR species='munjava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cethosia' AND (species='munjava' OR species='munjava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cethosia' AND (junior_species='munjava' OR junior_species='munjava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cethosia' AND (species='munjava' OR species='munjava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cethosia' AND (junior_species='penthesilea' OR junior_species='penthesilea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cethosia' AND (species='penthesilea' OR species='penthesilea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cethosia' AND (species='penthesilea' OR species='penthesilea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cethosia' AND (junior_species='penthesilea' OR junior_species='penthesilea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cethosia' AND (species='penthesilea' OR species='penthesilea') 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='Cyrestis' AND (junior_species='lutea' OR junior_species='lutea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyrestis' AND (species='lutea' OR species='lutea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyrestis' AND (species='lutea' OR species='lutea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyrestis' AND (junior_species='lutea' OR junior_species='lutea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyrestis' AND (species='lutea' OR species='lutea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaceura' AND (junior_species='osteria' OR junior_species='osteria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaceura' AND (species='osteria' OR species='osteria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaceura' AND (species='osteria' OR species='osteria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaceura' AND (junior_species='osteria' OR junior_species='osteria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulaceura' AND (species='osteria' OR species='osteria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinopalpa' AND (junior_species='polynice' OR junior_species='polynice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinopalpa' AND (species='polynice' OR species='polynice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinopalpa' AND (species='polynice' OR species='polynice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinopalpa' AND (junior_species='polynice' OR junior_species='polynice')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhinopalpa' AND (species='polynice' OR species='polynice') 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='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='orithya' OR junior_species='orithya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='orithya' OR species='orithya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='orithya' OR species='orithya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='orithya' OR junior_species='orithya')SELECT d.diet,d.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='orithya' OR species='orithya') 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='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='aspasia' OR junior_species='aspasia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Danaus' AND (species='aspasia' OR species='aspasia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Danaus' AND (species='aspasia' OR species='aspasia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Danaus' AND (junior_species='aspasia' OR junior_species='aspasia')SELECT d.diet,d.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='aspasia' OR species='aspasia') 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='Parantica' AND (junior_species='pseudomelaneus' OR junior_species='pseudomelaneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parantica' AND (species='pseudomelaneus' OR species='pseudomelaneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parantica' AND (species='pseudomelaneus' OR species='pseudomelaneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='pseudomelaneus' OR junior_species='pseudomelaneus')SELECT d.diet,d.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='pseudomelaneus' OR species='pseudomelaneus') 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='ceryx' OR junior_species='ceryx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='ceryx' OR species='ceryx') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='ceryx' OR species='ceryx')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='ceryx' OR junior_species='ceryx')SELECT d.diet,d.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='ceryx' OR species='ceryx') 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='Ragadia' AND (junior_species='makuta' OR junior_species='makuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ragadia' AND (species='makuta' OR species='makuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ragadia' AND (species='makuta' OR species='makuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ragadia' AND (junior_species='makuta' OR junior_species='makuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ragadia' AND (species='makuta' OR species='makuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neorina' AND (junior_species='krishna' OR junior_species='krishna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neorina' AND (species='krishna' OR species='krishna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neorina' AND (species='krishna' OR species='krishna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neorina' AND (junior_species='krishna' OR junior_species='krishna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neorina' AND (species='krishna' OR species='krishna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='kausambi' OR junior_species='kausambii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abisara' AND (species='kausambi' OR species='kausambii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abisara' AND (species='kausambi' OR species='kausambii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='kausambi' OR junior_species='kausambii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abisara' AND (species='kausambi' OR species='kausambii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='savitri' OR junior_species='savitrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abisara' AND (species='savitri' OR species='savitrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abisara' AND (species='savitri' OR species='savitrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abisara' AND (junior_species='savitri' OR junior_species='savitrii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abisara' AND (species='savitri' OR species='savitrii') 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='Faunis' AND (junior_species='canens' OR junior_species='canens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Faunis' AND (species='canens' OR species='canens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Faunis' AND (species='canens' OR species='canens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faunis' AND (junior_species='canens' OR junior_species='canens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Faunis' AND (species='canens' OR species='canens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumantis' AND (junior_species='odana' OR junior_species='odana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thaumantis' AND (species='odana' OR species='odana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thaumantis' AND (species='odana' OR species='odana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumantis' AND (junior_species='odana' OR junior_species='odana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thaumantis' AND (species='odana' OR species='odana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathusia' AND (junior_species='taenia' OR junior_species='taenia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amathusia' AND (species='taenia' OR species='taenia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amathusia' AND (species='taenia' OR species='taenia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathusia' AND (junior_species='taenia' OR junior_species='taenia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amathusia' AND (species='taenia' OR species='taenia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zeuxidia' AND (junior_species='luxerii' OR junior_species='luxeri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zeuxidia' AND (species='luxerii' OR species='luxeri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zeuxidia' AND (species='luxerii' OR species='luxeri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zeuxidia' AND (junior_species='luxerii' OR junior_species='luxeri')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zeuxidia' AND (species='luxerii' OR species='luxeri') 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='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='Stiboges' AND (junior_species='calycoides' OR junior_species='calycoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stiboges' AND (species='calycoides' OR species='calycoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stiboges' AND (species='calycoides' OR species='calycoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stiboges' AND (junior_species='calycoides' OR junior_species='calycoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stiboges' AND (species='calycoides' OR species='calycoides') 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 * FROM register WHERE sample_no=3111 The Ecological Register: Baturaden Forest (secondary forest)
Baturaden Forest (secondary forest)
Basic information
Sample name: Baturaden Forest (secondary forest)

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' 12" S, 109° 13' 1" 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: secondary forest

Protection: unprotected

Substrate: ground surface

MAP: 4500.0

Habitat comments: "tropical, rainforest-type vegetation"

Methods
Life forms: butterflies

Sampling methods: line transect,butterfly nets

Sample size: 1199 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: 3111

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-12-21 15:12:04

Modified: 2018-12-21 04:16:15

Abundance distribution
80 species
10 singletons
total count 1199
extrapolated richness: 112.7
Fisher's α: 19.300
geometric series k: 0.9421
Hurlbert's PIE: 0.9631
Shannon's H: 3.7020
Good's u: 0.9917
Each square represents a species. Square sizes are proportional to counts.
Register