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=1164 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1164SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=815SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1164 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='smithi' OR junior_species='smithii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='smithi' OR species='smithii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='smithi' OR species='smithii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='smithi' OR junior_species='smithii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='smithi' OR species='smithii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallimoides' AND (junior_species='rumia' OR junior_species='rumia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kallimoides' AND (species='rumia' OR species='rumia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kallimoides' AND (species='rumia' OR species='rumia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallimoides' AND (junior_species='rumia' OR junior_species='rumia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kallimoides' AND (species='rumia' OR species='rumia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='fulvescens' OR junior_species='fulvescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='fulvescens' OR species='fulvescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='fulvescens' OR species='fulvescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='fulvescens' OR junior_species='fulvescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='fulvescens' OR species='fulvescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='chelys' OR junior_species='chelys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnophodes' AND (species='chelys' OR species='chelys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnophodes' AND (species='chelys' OR species='chelys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='chelys' OR junior_species='chelys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gnophodes' AND (species='chelys' OR species='chelys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='mollitia' OR junior_species='mollitia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='mollitia' OR species='mollitia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='mollitia' OR species='mollitia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='mollitia' OR junior_species='mollitia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='mollitia' OR species='mollitia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='dentatus' OR junior_species='dentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='dentatus' OR species='dentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='dentatus' OR species='dentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='dentatus' OR junior_species='dentatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='dentatus' OR species='dentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='stygia' OR junior_species='stygia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junonia' AND (species='stygia' OR species='stygia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junonia' AND (species='stygia' OR species='stygia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junonia' AND (junior_species='stygia' OR junior_species='stygia')SELECT d.diet,d.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='stygia' OR species='stygia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='mesogena' OR junior_species='mesogena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='mesogena' OR species='mesogena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='mesogena' OR species='mesogena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='mesogena' OR junior_species='mesogena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='mesogena' OR species='mesogena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='golo' OR junior_species='golo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='golo' OR species='golo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='golo' OR species='golo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='golo' OR junior_species='golo')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='golo' OR species='golo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='medon' OR junior_species='medon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='medon' OR species='medon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='medon' OR species='medon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='medon' OR junior_species='medon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='medon' OR species='medon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='graueri' OR junior_species='grauerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='graueri' OR species='grauerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='graueri' OR species='grauerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='graueri' OR junior_species='grauerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='graueri' OR species='grauerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='herminia' OR junior_species='herminia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymothoe' AND (species='herminia' OR species='herminia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymothoe' AND (species='herminia' OR species='herminia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='herminia' OR junior_species='herminia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymothoe' AND (species='herminia' OR species='herminia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sevenia' AND (junior_species='occidentalium' OR junior_species='occidentalium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sevenia' AND (species='occidentalium' OR species='occidentalium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sevenia' AND (species='occidentalium' OR species='occidentalium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sevenia' AND (junior_species='occidentalium' OR junior_species='occidentalium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sevenia' AND (species='occidentalium' OR species='occidentalium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harma' AND (junior_species='theobene' OR junior_species='theobene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harma' AND (species='theobene' OR species='theobene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harma' AND (species='theobene' OR species='theobene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harma' AND (junior_species='theobene' OR junior_species='theobene')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harma' AND (species='theobene' OR species='theobene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='mandanes' OR junior_species='mandanes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='mandanes' OR species='mandanes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='mandanes' OR species='mandanes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='mandanes' OR junior_species='mandanes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='mandanes' OR species='mandanes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurytela' AND (junior_species='hiarbas' OR junior_species='hiarbas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurytela' AND (species='hiarbas' OR species='hiarbas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurytela' AND (species='hiarbas' OR species='hiarbas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurytela' AND (junior_species='hiarbas' OR junior_species='hiarbas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurytela' AND (species='hiarbas' OR species='hiarbas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='auricruda' OR junior_species='auricruda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='auricruda' OR species='auricruda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='auricruda' OR species='auricruda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='auricruda' OR junior_species='auricruda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='auricruda' OR species='auricruda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='peitho' OR junior_species='peitho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropsis' AND (species='peitho' OR species='peitho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropsis' AND (species='peitho' OR species='peitho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropsis' AND (junior_species='peitho' OR junior_species='peitho')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteropsis' AND (species='peitho' OR species='peitho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptidopsis' AND (junior_species='ophione' OR junior_species='ophione')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptidopsis' AND (species='ophione' OR species='ophione') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptidopsis' AND (species='ophione' OR species='ophione')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptidopsis' AND (junior_species='ophione' OR junior_species='ophione')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neptidopsis' AND (species='ophione' OR species='ophione') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='lurida' OR junior_species='lurida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymothoe' AND (species='lurida' OR species='lurida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymothoe' AND (species='lurida' OR species='lurida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='lurida' OR junior_species='lurida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymothoe' AND (species='lurida' OR species='lurida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='preussi' OR junior_species='preussii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='preussi' OR species='preussii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='preussi' OR species='preussii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='preussi' OR junior_species='preussii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='preussi' OR species='preussii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='alacris' OR junior_species='alacris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='alacris' OR species='alacris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='alacris' OR species='alacris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='alacris' OR junior_species='alacris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='alacris' OR species='alacris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='christyi' OR junior_species='christyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='christyi' OR species='christyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='christyi' OR species='christyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='christyi' OR junior_species='christyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='christyi' OR species='christyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='tiridates' OR junior_species='tiridates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='tiridates' OR species='tiridates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='tiridates' OR species='tiridates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='tiridates' OR junior_species='tiridates')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='tiridates' OR species='tiridates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='imitans' OR junior_species='imitans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='imitans' OR species='imitans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='imitans' OR species='imitans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='imitans' OR junior_species='imitans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='imitans' OR species='imitans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bipunctatus' OR junior_species='bipunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='bipunctatus' OR species='bipunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='bipunctatus' OR species='bipunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bipunctatus' OR junior_species='bipunctatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='bipunctatus' OR species='bipunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aterica' AND (junior_species='galene' OR junior_species='galene')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aterica' AND (species='galene' OR species='galene') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aterica' AND (species='galene' OR species='galene')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aterica' AND (junior_species='galene' OR junior_species='galene')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aterica' AND (species='galene' OR species='galene') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnoptera' AND (junior_species='anticlea' OR junior_species='anticlea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lachnoptera' AND (species='anticlea' OR species='anticlea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lachnoptera' AND (species='anticlea' OR species='anticlea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachnoptera' AND (junior_species='anticlea' OR junior_species='anticlea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lachnoptera' AND (species='anticlea' OR species='anticlea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='buea' OR junior_species='buea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='buea' OR species='buea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='buea' OR species='buea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='buea' OR junior_species='buea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='buea' OR species='buea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='campinus' OR junior_species='campinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='campinus' OR species='campinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='campinus' OR species='campinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='campinus' OR junior_species='campinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='campinus' OR species='campinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='betsimena' OR junior_species='betsimena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnophodes' AND (species='betsimena' OR species='betsimena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnophodes' AND (species='betsimena' OR species='betsimena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='betsimena' OR junior_species='betsimena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gnophodes' AND (species='betsimena' OR species='betsimena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='pollux' OR junior_species='pollux')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='pollux' OR species='pollux') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='pollux' OR species='pollux')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='pollux' OR junior_species='pollux')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='pollux' OR species='pollux') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='uganda' OR junior_species='uganda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='uganda' OR species='uganda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='uganda' OR species='uganda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='uganda' OR junior_species='uganda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='uganda' OR species='uganda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='numenes' OR junior_species='numenes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='numenes' OR species='numenes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='numenes' OR species='numenes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='numenes' OR junior_species='numenes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='numenes' OR species='numenes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='edwardsi' OR junior_species='edwardsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='edwardsi' OR species='edwardsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='edwardsi' OR species='edwardsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='edwardsi' OR junior_species='edwardsii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='edwardsi' OR species='edwardsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='zaddachi' OR junior_species='zaddachii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaedra' AND (species='zaddachi' OR species='zaddachii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaedra' AND (species='zaddachi' OR species='zaddachii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaedra' AND (junior_species='zaddachi' OR junior_species='zaddachii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphaedra' AND (species='zaddachi' OR species='zaddachii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadne' AND (junior_species='pagenstecheri' OR junior_species='pagenstecherii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ariadne' AND (species='pagenstecheri' OR species='pagenstecherii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ariadne' AND (species='pagenstecheri' OR species='pagenstecherii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ariadne' AND (junior_species='pagenstecheri' OR junior_species='pagenstecherii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ariadne' AND (species='pagenstecheri' OR species='pagenstecherii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='new' OR junior_species='new')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnophodes' AND (species='new' OR species='new') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnophodes' AND (species='new' OR species='new')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnophodes' AND (junior_species='new' OR junior_species='new')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gnophodes' AND (species='new' OR species='new') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sevenia' AND (junior_species='boisduvali' OR junior_species='boisduvalii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sevenia' AND (species='boisduvali' OR species='boisduvalii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sevenia' AND (species='boisduvali' OR species='boisduvalii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sevenia' AND (junior_species='boisduvali' OR junior_species='boisduvalii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sevenia' AND (species='boisduvali' OR species='boisduvalii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='candiope' OR junior_species='candiope')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='candiope' OR species='candiope') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='candiope' OR species='candiope')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='candiope' OR junior_species='candiope')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='candiope' OR species='candiope') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='protoclea' OR junior_species='protoclea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='protoclea' OR species='protoclea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='protoclea' OR species='protoclea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='protoclea' OR junior_species='protoclea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='protoclea' OR species='protoclea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='cynthia' OR junior_species='cynthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='cynthia' OR species='cynthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='cynthia' OR species='cynthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='cynthia' OR junior_species='cynthia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='cynthia' OR species='cynthia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='ansorgei' OR junior_species='ansorgeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='ansorgei' OR species='ansorgeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='ansorgei' OR species='ansorgeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='ansorgei' OR junior_species='ansorgeii')SELECT d.diet,d.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='ansorgei' OR species='ansorgeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sebetus' OR junior_species='sebetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='sebetus' OR species='sebetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='sebetus' OR species='sebetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sebetus' OR junior_species='sebetus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='sebetus' OR species='sebetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sambulos' OR junior_species='sambulos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bicyclus' AND (species='sambulos' OR species='sambulos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='sambulos' OR species='sambulos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' AND (junior_species='sambulos' OR junior_species='sambulos')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bicyclus' AND (species='sambulos' OR species='sambulos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catuna' AND (junior_species='crithea' OR junior_species='crithea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catuna' AND (species='crithea' OR species='crithea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catuna' AND (species='crithea' OR species='crithea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catuna' AND (junior_species='crithea' OR junior_species='crithea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catuna' AND (species='crithea' OR species='crithea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='ceanis' OR junior_species='ceanis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymothoe' AND (species='ceanis' OR species='ceanis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymothoe' AND (species='ceanis' OR species='ceanis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymothoe' AND (junior_species='ceanis' OR junior_species='ceanis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymothoe' AND (species='ceanis' OR species='ceanis') 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='Protogoniomorpha' AND (junior_species='temora' OR junior_species='temora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protogoniomorpha' AND (species='temora' OR species='temora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protogoniomorpha' AND (species='temora' OR species='temora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protogoniomorpha' AND (junior_species='temora' OR junior_species='temora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protogoniomorpha' AND (species='temora' OR species='temora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' 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='Bicyclus' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bicyclus' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bicyclus' 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='Bicyclus' AND (species='vulgaris' OR species='vulgaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='etheocles' OR junior_species='etheocles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='etheocles' OR species='etheocles') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='etheocles' OR species='etheocles')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='etheocles' OR junior_species='etheocles')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charaxes' AND (species='etheocles' OR species='etheocles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protogoniomorpha' AND (junior_species='parhassus' OR junior_species='parhassus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protogoniomorpha' AND (species='parhassus' OR species='parhassus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protogoniomorpha' AND (species='parhassus' OR species='parhassus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protogoniomorpha' AND (junior_species='parhassus' OR junior_species='parhassus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protogoniomorpha' AND (species='parhassus' OR species='parhassus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxanthe' AND (junior_species='crossleyi' OR junior_species='crossleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euxanthe' AND (species='crossleyi' OR species='crossleyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euxanthe' AND (species='crossleyi' OR species='crossleyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxanthe' AND (junior_species='crossleyi' OR junior_species='crossleyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euxanthe' AND (species='crossleyi' OR species='crossleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphura' AND (junior_species='chalcis' OR junior_species='chalcis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euriphura' AND (species='chalcis' OR species='chalcis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euriphura' AND (species='chalcis' OR species='chalcis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euriphura' AND (junior_species='chalcis' OR junior_species='chalcis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euriphura' AND (species='chalcis' OR species='chalcis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apaturopsis' AND (junior_species='cleochares' OR junior_species='cleochares')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apaturopsis' AND (species='cleochares' OR species='cleochares') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apaturopsis' AND (species='cleochares' OR species='cleochares')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apaturopsis' AND (junior_species='cleochares' OR junior_species='cleochares')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apaturopsis' AND (species='cleochares' OR species='cleochares') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Babearia' AND (junior_species='cocalia' OR junior_species='cocalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Babearia' AND (species='cocalia' OR species='cocalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Babearia' AND (species='cocalia' OR species='cocalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Babearia' AND (junior_species='cocalia' OR junior_species='cocalia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Babearia' AND (species='cocalia' OR species='cocalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanta' AND (junior_species='phalanta' OR junior_species='phalanta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalanta' AND (species='phalanta' OR species='phalanta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalanta' AND (species='phalanta' OR species='phalanta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalanta' AND (junior_species='phalanta' OR junior_species='phalanta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phalanta' AND (species='phalanta' OR species='phalanta') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1164 The Ecological Register: Kibale National Park Compartment K31
Kibale National Park Compartment K31
Basic information
Sample name: Kibale National Park Compartment K31

Reference: M. Nyafwono, A. Valtonen, P. Nyeko, and H. Roininen. 2014. Butterfly community composition across a successional gradient in a human-disturbed Afro-tropical rain forest. Biotropica 46(2):210-218 [ER 815]
Geography
Country: Uganda


Coordinate: 0° 27' 0" N, 39° 25' 30" E
Coordinate basis: stated in text as range

Geography comments: elevation 1000 to 1600 m
coordinate is midpoint of ranges stated in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

MAT: 17.6

MAP: 1749.0

Habitat comments: "tropical rain forest"
daily min/max 14.9/20.2

Methods
Life forms: butterflies

Sampling methods: baited

Sample size: 2011 individuals

Years: 2011, 2012

Days: 36

Nets or traps: 10

Net or trap nights: 360

Sampling comments: ten "banana-baited white cylindrical butterfly traps" that were "sampled three times a month for 12 months"

Metadata
Sample number: 1164

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-09-21 20:30:47

Modified: 2014-09-21 10:30:47

Abundance distribution
57 species
7 singletons
total count 2011
extrapolated richness: 77.4
Fisher's α: 10.916
geometric series k: 0.8903
Hurlbert's PIE: 0.8447
Shannon's H: 2.5932
Good's u: 0.9965
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bicyclus smithi670
Kallimoides rumia320
Charaxes fulvescens128
Gnophodes chelys157
Bicyclus mollitia38
Bicyclus dentatus15
Junonia stygia11
Bicyclus mesogena134
Bicyclus golo39
Euphaedra medon17
Bicyclus graueri78
Cymothoe herminia17
Sevenia occidentalium16
Harma theobene17
Bicyclus mandanes31
Eurytela hiarbas7
Bicyclus auricruda26
Heteropsis peitho53
Neptidopsis ophione19
Cymothoe lurida19
Euphaedra preussi3
Euphaedra alacris18
Euphaedra christyi8
Charaxes tiridates13
Euphaedra imitans16
Charaxes bipunctatus13
Aterica galene3
Lachnoptera anticlea14
Bicyclus buea6
Bicyclus campinus5
Gnophodes betsimena11
Charaxes pollux14
Euphaedra uganda4
Charaxes numenes4
Euphaedra edwardsi6
Euphaedra zaddachi6
Ariadne pagenstecheri6
Gnophodes new3
Sevenia boisduvali2
Charaxes candiope4
Charaxes protoclea6
Charaxes cynthia3
Melanitis ansorgei2
Bicyclus sebetus3
Bicyclus sambulos4
Catuna crithea2
Cymothoe ceanis1
Melanitis leda5
Protogoniomorpha temora3
Bicyclus vulgaris3
Charaxes etheocles1
Protogoniomorpha parhassus2
Euxanthe crossleyi1
Euriphura chalcis1
Apaturopsis cleochares1
Babearia cocalia1
Phalanta phalanta1