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=976 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=976SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=669SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=976 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='leda' OR species='leda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='leda' OR junior_species='leda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanitis' AND (species='leda' OR species='leda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neorina' AND (junior_species='lowii' OR junior_species='lowi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neorina' AND (species='lowii' OR species='lowi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neorina' AND (species='lowii' OR species='lowi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neorina' AND (junior_species='lowii' OR junior_species='lowi')SELECT d.diet,d.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='lowii' OR species='lowi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='dora' OR junior_species='dora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='dora' OR species='dora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='dora' OR species='dora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='dora' OR junior_species='dora')SELECT d.diet,d.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='dora' OR species='dora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='anapita' OR junior_species='anapita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='anapita' OR species='anapita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='anapita' OR species='anapita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='anapita' OR junior_species='anapita')SELECT d.diet,d.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='anapita' OR species='anapita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='patiana' OR junior_species='patiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='patiana' OR species='patiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='patiana' OR species='patiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='patiana' OR junior_species='patiana')SELECT d.diet,d.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='patiana' OR species='patiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='kina' OR junior_species='kina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='kina' OR species='kina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='kina' OR species='kina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='kina' OR junior_species='kina')SELECT d.diet,d.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='kina' OR species='kina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='dohertyi' OR junior_species='dohertyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='dohertyi' OR species='dohertyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='dohertyi' OR species='dohertyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='dohertyi' OR junior_species='dohertyii')SELECT d.diet,d.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='dohertyi' OR species='dohertyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mineus' OR junior_species='mineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='mineus' OR species='mineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='mineus' OR species='mineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='mineus' OR junior_species='mineus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mycalesis' AND (species='mineus' OR species='mineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='horsfieldi' OR species='horsfieldii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='horsfieldi' OR species='horsfieldii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='horsfieldi' OR junior_species='horsfieldii')SELECT d.diet,d.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='horsfieldi' OR species='horsfieldii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='orseis' OR junior_species='orseis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='orseis' OR species='orseis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='orseis' OR species='orseis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='orseis' OR junior_species='orseis')SELECT d.diet,d.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='orseis' OR species='orseis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='maianeas' OR junior_species='maianeas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='maianeas' OR species='maianeas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='maianeas' OR species='maianeas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='maianeas' OR junior_species='maianeas')SELECT d.diet,d.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='maianeas' OR species='maianeas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='oroatis' OR junior_species='oroatis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='oroatis' OR species='oroatis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='oroatis' OR species='oroatis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='oroatis' OR junior_species='oroatis')SELECT d.diet,d.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='oroatis' OR species='oroatis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erites' AND (junior_species='argentina' OR junior_species='argentina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erites' AND (species='argentina' OR species='argentina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erites' AND (species='argentina' OR species='argentina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erites' AND (junior_species='argentina' OR junior_species='argentina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erites' AND (species='argentina' OR species='argentina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erites' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erites' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erites' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erites' AND (junior_species='elegans' OR junior_species='elegans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erites' AND (species='elegans' OR species='elegans') 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='Faunis' AND (junior_species='stomphax' OR junior_species='stomphax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Faunis' AND (species='stomphax' OR species='stomphax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Faunis' AND (species='stomphax' OR species='stomphax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faunis' AND (junior_species='stomphax' OR junior_species='stomphax')SELECT d.diet,d.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='stomphax' OR species='stomphax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotaenia' AND (junior_species='busiris' OR junior_species='busiris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthotaenia' AND (species='busiris' OR species='busiris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthotaenia' AND (species='busiris' OR species='busiris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotaenia' AND (junior_species='busiris' OR junior_species='busiris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthotaenia' AND (species='busiris' OR species='busiris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathusia' AND (junior_species='phiddippus' OR junior_species='phiddippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amathusia' AND (species='phiddippus' OR species='phiddippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amathusia' AND (species='phiddippus' OR species='phiddippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathusia' AND (junior_species='phiddippus' OR junior_species='phiddippus')SELECT d.diet,d.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='phiddippus' OR species='phiddippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathuxidia' AND (junior_species='amythaon' OR junior_species='amythaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amathuxidia' AND (species='amythaon' OR species='amythaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amathuxidia' AND (species='amythaon' OR species='amythaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amathuxidia' AND (junior_species='amythaon' OR junior_species='amythaon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amathuxidia' AND (species='amythaon' OR species='amythaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zeuxidia' AND (junior_species='aurelius' OR junior_species='aurelius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zeuxidia' AND (species='aurelius' OR species='aurelius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zeuxidia' AND (species='aurelius' OR species='aurelius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zeuxidia' AND (junior_species='aurelius' OR junior_species='aurelius')SELECT d.diet,d.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='aurelius' OR species='aurelius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zeuxidia' AND (junior_species='amethystus' OR junior_species='amethystus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zeuxidia' AND (species='amethystus' OR species='amethystus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zeuxidia' AND (species='amethystus' OR species='amethystus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zeuxidia' AND (junior_species='amethystus' OR junior_species='amethystus')SELECT d.diet,d.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='amethystus' OR species='amethystus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zeuxidia' AND (junior_species='doubdledayi' OR junior_species='doubdledayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zeuxidia' AND (species='doubdledayi' OR species='doubdledayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zeuxidia' AND (species='doubdledayi' OR species='doubdledayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zeuxidia' AND (junior_species='doubdledayi' OR junior_species='doubdledayii')SELECT d.diet,d.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='doubdledayi' OR species='doubdledayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='necho' OR junior_species='necho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discophora' AND (species='necho' OR species='necho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discophora' AND (species='necho' OR species='necho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discophora' AND (junior_species='necho' OR junior_species='necho')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discophora' AND (species='necho' OR species='necho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupha' AND (junior_species='erymanthis' OR junior_species='erymanthis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupha' AND (species='erymanthis' OR species='erymanthis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupha' AND (species='erymanthis' OR species='erymanthis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupha' AND (junior_species='erymanthis' OR junior_species='erymanthis')SELECT d.diet,d.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='erymanthis' OR species='erymanthis') 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='Terinos' AND (junior_species='clarissa' OR junior_species='clarissa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terinos' AND (species='clarissa' OR species='clarissa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terinos' AND (species='clarissa' OR species='clarissa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terinos' AND (junior_species='clarissa' OR junior_species='clarissa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terinos' AND (species='clarissa' OR species='clarissa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='limborgi' OR junior_species='limborgii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kallima' AND (species='limborgi' OR species='limborgii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kallima' AND (species='limborgi' OR species='limborgii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kallima' AND (junior_species='limborgi' OR junior_species='limborgii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Kallima' AND (species='limborgi' OR species='limborgii') 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='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='Tanaecia' AND (junior_species='clathrata' OR junior_species='clathrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tanaecia' AND (species='clathrata' OR species='clathrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tanaecia' AND (species='clathrata' OR species='clathrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='clathrata' OR junior_species='clathrata')SELECT d.diet,d.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='clathrata' OR species='clathrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='aruna' OR junior_species='aruna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tanaecia' AND (species='aruna' OR species='aruna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tanaecia' AND (species='aruna' OR species='aruna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='aruna' OR junior_species='aruna')SELECT d.diet,d.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='aruna' OR species='aruna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dophla' AND (junior_species='evelina' OR junior_species='evelina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dophla' AND (species='evelina' OR species='evelina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dophla' AND (species='evelina' OR species='evelina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dophla' AND (junior_species='evelina' OR junior_species='evelina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dophla' AND (species='evelina' OR species='evelina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassarona' AND (junior_species='teuta' OR junior_species='teuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bassarona' AND (species='teuta' OR species='teuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bassarona' AND (species='teuta' OR species='teuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassarona' AND (junior_species='teuta' OR junior_species='teuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bassarona' AND (species='teuta' OR species='teuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassarona' AND (junior_species='dunya' OR junior_species='dunya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bassarona' AND (species='dunya' OR species='dunya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bassarona' AND (species='dunya' OR species='dunya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bassarona' AND (junior_species='dunya' OR junior_species='dunya')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bassarona' AND (species='dunya' OR species='dunya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lexias' AND (junior_species='dirtea' OR junior_species='dirtea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lexias' AND (species='dirtea' OR species='dirtea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lexias' AND (species='dirtea' OR species='dirtea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lexias' AND (junior_species='dirtea' OR junior_species='dirtea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lexias' AND (species='dirtea' OR species='dirtea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lexias' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lexias' AND (species='pardalis' OR species='pardalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lexias' AND (species='pardalis' OR species='pardalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lexias' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lexias' AND (species='pardalis' OR species='pardalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Dichorragia' AND (junior_species='nesimachus' OR junior_species='nesimachus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichorragia' AND (species='nesimachus' OR species='nesimachus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichorragia' AND (species='nesimachus' OR species='nesimachus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichorragia' AND (junior_species='nesimachus' OR junior_species='nesimachus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dichorragia' AND (species='nesimachus' OR species='nesimachus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prothoe' AND (junior_species='franck' OR junior_species='franck')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prothoe' AND (species='franck' OR species='franck') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prothoe' AND (species='franck' OR species='franck')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prothoe' AND (junior_species='franck' OR junior_species='franck')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prothoe' AND (species='franck' OR species='franck') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bernardus' OR junior_species='bernardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='bernardus' OR species='bernardus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='bernardus' OR species='bernardus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='bernardus' OR junior_species='bernardus')SELECT d.diet,d.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='bernardus' OR species='bernardus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='durnfordi' OR junior_species='durnfordii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charaxes' AND (species='durnfordi' OR species='durnfordii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charaxes' AND (species='durnfordi' OR species='durnfordii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charaxes' AND (junior_species='durnfordi' OR junior_species='durnfordii')SELECT d.diet,d.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='durnfordi' OR species='durnfordii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=976 The Ecological Register: Danum Valley Conservation Area (wet season, primary forest)
Danum Valley Conservation Area (wet season, primary forest)
Basic information
Sample name: Danum Valley Conservation Area (wet season, primary forest)

Reference: K. C. Hamer, J. K. Hill, N. Mustaffa, S. Benedick, T. N. Sherratt, V. K. Chey, and M. Maryati. 2005. Temporal variation in abundance and diversity of butterflies in Bornean rain forests: opposite impacts of logging recorded in different seasons. Journal of Tropical Ecology 21:417-425 [ER 669]
Geography
Country: Malaysia

State: Sabah


Coordinate: 5° 0' N, 117° 50' E
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 26.7

MAP: 2669.0

Habitat comments: "evergreen rain forest"

Methods
Life forms: butterflies

Site length: 4000

Sampling methods: line transect,baited

Sample size: 1019 individuals

Seasons: wet or monsoon

Nets or traps: 40

Net or trap nights: 5760

Sampling comments: 40 "traps baited with rotting banana" hung "at 100-m intervals along 4 km of transects" that were left out for "12 consecutive days per mo for 12 mo"
recaptures were excluded from counts

Metadata
Sample number: 976

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-06-27 21:25:30

Modified: 2020-05-29 10:14:26

Abundance distribution
41 species
9 singletons
total count 1019
extrapolated richness: 66.3
Fisher's α: 8.564
geometric series k: 0.8730
Hurlbert's PIE: 0.8911
Shannon's H: 2.6437
Good's u: 0.9912
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Melanitis leda15
Neorina lowii133
Lethe dora1
Mycalesis anapita21
Mycalesis patiana10
Mycalesis kina39
Mycalesis dohertyi37
Mycalesis mineus2
Mycalesis horsfieldi1
Mycalesis orseis74
Mycalesis maianeas51
Mycalesis oroatis229
Erites argentina1
Erites elegans7
Ragadia makuta144
Faunis stomphax1
Xanthotaenia busiris1
Amathusia phiddippus2
Amathuxidia amythaon2
Zeuxidia aurelius13
Zeuxidia amethystus3
Zeuxidia doubdledayi2
Discophora necho16
Cupha erymanthis1
Cirrochroa emalea2
Terinos clarissa1
Kallima limborgi3
Rhinopalpa polynice4
Athyma pravara2
Tanaecia clathrata1
Tanaecia aruna19
Dophla evelina20
Bassarona teuta14
Bassarona dunya79
Lexias dirtea2
Lexias pardalis2
Amnosia decora4
Dichorragia nesimachus2
Prothoe franck51
Charaxes bernardus6
Charaxes durnfordi1