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=1302 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1302SELECT 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=1302 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='Elymnias' AND (junior_species='panthera' OR junior_species='panthera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elymnias' AND (species='panthera' OR species='panthera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elymnias' AND (species='panthera' OR species='panthera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elymnias' AND (junior_species='panthera' OR junior_species='panthera')SELECT d.diet,d.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='panthera' OR species='panthera') 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='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='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='fusca' OR junior_species='fusca')SELECT d.diet,d.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='fusca' OR species='fusca') 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='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='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='Thaumantis' AND (junior_species='noureddin' OR junior_species='noureddin')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thaumantis' AND (species='noureddin' OR species='noureddin') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thaumantis' AND (species='noureddin' OR species='noureddin')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumantis' AND (junior_species='noureddin' OR junior_species='noureddin')SELECT d.diet,d.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='noureddin' OR species='noureddin') 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='Paduca' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paduca' AND (species='fasciata' OR species='fasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paduca' AND (species='fasciata' OR species='fasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paduca' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paduca' AND (species='fasciata' OR species='fasciata') 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='Athyma' AND (junior_species='reta' OR junior_species='reta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athyma' AND (species='reta' OR species='reta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athyma' AND (species='reta' OR species='reta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athyma' AND (junior_species='reta' OR junior_species='reta')SELECT d.diet,d.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='reta' OR species='reta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parthenos' AND (junior_species='sylvia' OR junior_species='sylvia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parthenos' AND (species='sylvia' OR species='sylvia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parthenos' AND (species='sylvia' OR species='sylvia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parthenos' AND (junior_species='sylvia' OR junior_species='sylvia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parthenos' AND (species='sylvia' OR species='sylvia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='pelea' OR junior_species='pelea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tanaecia' AND (species='pelea' OR species='pelea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tanaecia' AND (species='pelea' OR species='pelea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanaecia' AND (junior_species='pelea' OR junior_species='pelea')SELECT d.diet,d.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='pelea' OR species='pelea') 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='Euthalia' AND (junior_species='iapis' OR junior_species='iapis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euthalia' AND (species='iapis' OR species='iapis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euthalia' AND (species='iapis' OR species='iapis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthalia' AND (junior_species='iapis' OR junior_species='iapis')SELECT d.diet,d.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='iapis' OR species='iapis') 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='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='Agatasa' AND (junior_species='calydonia' OR junior_species='calydonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agatasa' AND (species='calydonia' OR species='calydonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agatasa' AND (species='calydonia' OR species='calydonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agatasa' AND (junior_species='calydonia' OR junior_species='calydonia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agatasa' AND (species='calydonia' OR species='calydonia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1302 The Ecological Register: Danum Valley Conservation Area (wet season, logged forest)
Danum Valley Conservation Area (wet season, logged forest)
Basic information
Sample name: Danum Valley Conservation Area (wet season, logged 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

Disturbance: selective logging

MAT: 26.7

MAP: 2669.0

Habitat comments: "evergreen rain forest" that was "selectively logged 10–12 y previously" and "all commercial stems > 0.6 m diameter were removed"

Methods
Life forms: butterflies

Site length: 4000

Sampling methods: line transect,baited

Sample size: 920 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: 1302

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-20 12:49:29

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

Abundance distribution
43 species
10 singletons
total count 920
extrapolated richness: 66.4
Fisher's α: 9.350
geometric series k: 0.8877
Hurlbert's PIE: 0.9096
Shannon's H: 2.8019
Good's u: 0.9891
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Melanitis leda33
Elymnias panthera2
Neorina lowii133
Mycalesis anapita60
Mycalesis patiana8
Mycalesis fusca3
Mycalesis kina27
Mycalesis dohertyi9
Mycalesis mineus1
Mycalesis horsfieldi5
Mycalesis orseis109
Mycalesis maianeas72
Mycalesis oroatis1
Erites elegans7
Ragadia makuta149
Xanthotaenia busiris2
Amathusia phiddippus6
Amathuxidia amythaon1
Zeuxidia aurelius9
Zeuxidia amethystus10
Zeuxidia doubdledayi7
Thaumantis noureddin1
Discophora necho21
Paduca fasciata4
Kallima limborgi7
Rhinopalpa polynice1
Athyma pravara1
Athyma reta1
Parthenos sylvia1
Tanaecia pelea1
Tanaecia clathrata1
Tanaecia aruna26
Euthalia iapis2
Euthalia monina3
Dophla evelina7
Bassarona teuta21
Bassarona dunya103
Lexias dirtea3
Lexias pardalis14
Amnosia decora10
Dichorragia nesimachus5
Prothoe franck30
Agatasa calydonia3