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=1321 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1321SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=884SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1321 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Koruthaialos' AND (junior_species='rubecula' OR junior_species='rubecula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Koruthaialos' AND (species='rubecula' OR species='rubecula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Koruthaialos' AND (species='rubecula' OR species='rubecula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Koruthaialos' AND (junior_species='rubecula' OR junior_species='rubecula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Koruthaialos' AND (species='rubecula' OR species='rubecula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='sari' OR junior_species='sarii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='sari' OR species='sarii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='sari' OR species='sarii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='sari' OR junior_species='sarii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurema' AND (species='sari' OR species='sarii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotinus' AND (junior_species='leogoron' OR junior_species='leogoron')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allotinus' AND (species='leogoron' OR species='leogoron') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allotinus' AND (species='leogoron' OR species='leogoron')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allotinus' AND (junior_species='leogoron' OR junior_species='leogoron')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Allotinus' AND (species='leogoron' OR species='leogoron') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='atosia' OR junior_species='atosia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arhopala' AND (species='atosia' OR species='atosia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arhopala' AND (species='atosia' OR species='atosia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='atosia' OR junior_species='atosia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arhopala' AND (species='atosia' OR species='atosia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='avatha' OR junior_species='avatha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arhopala' AND (species='avatha' OR species='avatha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arhopala' AND (species='avatha' OR species='avatha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='avatha' OR junior_species='avatha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arhopala' AND (species='avatha' OR species='avatha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='democritus' OR junior_species='democritus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arhopala' AND (species='democritus' OR species='democritus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arhopala' AND (species='democritus' OR species='democritus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='democritus' OR junior_species='democritus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arhopala' AND (species='democritus' OR species='democritus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='denta' OR junior_species='denta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arhopala' AND (species='denta' OR species='denta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arhopala' AND (species='denta' OR species='denta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='denta' OR junior_species='denta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arhopala' AND (species='denta' OR species='denta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='elopura' OR junior_species='elopura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arhopala' AND (species='elopura' OR species='elopura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arhopala' AND (species='elopura' OR species='elopura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='elopura' OR junior_species='elopura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arhopala' AND (species='elopura' OR species='elopura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='epimuta' OR junior_species='epimuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arhopala' AND (species='epimuta' OR species='epimuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arhopala' AND (species='epimuta' OR species='epimuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='epimuta' OR junior_species='epimuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arhopala' AND (species='epimuta' OR species='epimuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='puseudomuta' OR junior_species='puseudomuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arhopala' AND (species='puseudomuta' OR species='puseudomuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arhopala' AND (species='puseudomuta' OR species='puseudomuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arhopala' AND (junior_species='puseudomuta' OR junior_species='puseudomuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arhopala' AND (species='puseudomuta' OR species='puseudomuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drupadia' AND (junior_species='niasica' OR junior_species='niasica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drupadia' AND (species='niasica' OR species='niasica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drupadia' AND (species='niasica' OR species='niasica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drupadia' AND (junior_species='niasica' OR junior_species='niasica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drupadia' AND (species='niasica' OR species='niasica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drupadia' AND (junior_species='theda' OR junior_species='theda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drupadia' AND (species='theda' OR species='theda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drupadia' AND (species='theda' OR species='theda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drupadia' AND (junior_species='theda' OR junior_species='theda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drupadia' AND (species='theda' OR species='theda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='caeruleus' OR species='caeruleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='caeruleus' OR species='caeruleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='caeruleus' OR species='caeruleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='pura' OR junior_species='pura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='pura' OR species='pura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='pura' OR species='pura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='pura' OR junior_species='pura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='pura' OR species='pura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ionolyce' AND (junior_species='helicon' OR junior_species='helicon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ionolyce' AND (species='helicon' OR species='helicon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ionolyce' AND (species='helicon' OR species='helicon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ionolyce' AND (junior_species='helicon' OR junior_species='helicon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ionolyce' AND (species='helicon' OR species='helicon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idea' AND (junior_species='stolli' OR junior_species='stollii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idea' AND (species='stolli' OR species='stollii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idea' AND (species='stolli' OR species='stollii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idea' AND (junior_species='stolli' OR junior_species='stollii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Idea' AND (species='stolli' OR species='stollii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='aspasia' OR junior_species='aspasia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parantica' AND (species='aspasia' OR species='aspasia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parantica' AND (species='aspasia' OR species='aspasia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='aspasia' OR junior_species='aspasia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parantica' AND (species='aspasia' OR species='aspasia') 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='Coelites' AND (junior_species='epiminthia' OR junior_species='epiminthia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coelites' AND (species='epiminthia' OR species='epiminthia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelites' AND (species='epiminthia' OR species='epiminthia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelites' AND (junior_species='epiminthia' OR junior_species='epiminthia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coelites' AND (species='epiminthia' OR species='epiminthia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelites' AND (junior_species='euptychioides' OR junior_species='euptychioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coelites' AND (species='euptychioides' OR species='euptychioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelites' AND (species='euptychioides' OR species='euptychioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelites' AND (junior_species='euptychioides' OR junior_species='euptychioides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coelites' AND (species='euptychioides' OR species='euptychioides') 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='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='Thaumantes' AND (junior_species='odona' OR junior_species='odona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thaumantes' AND (species='odona' OR species='odona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thaumantes' AND (species='odona' OR species='odona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thaumantes' AND (junior_species='odona' OR junior_species='odona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thaumantes' AND (species='odona' OR species='odona') 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='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='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='Cynitia' AND (junior_species='cocytina' OR junior_species='cocytina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynitia' AND (species='cocytina' OR species='cocytina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynitia' AND (species='cocytina' OR species='cocytina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynitia' AND (junior_species='cocytina' OR junior_species='cocytina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cynitia' AND (species='cocytina' OR species='cocytina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynitia' AND (junior_species='godarti' OR junior_species='godartii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynitia' AND (species='godarti' OR species='godartii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynitia' AND (species='godarti' OR species='godartii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynitia' AND (junior_species='godarti' OR junior_species='godartii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cynitia' AND (species='godarti' OR species='godartii') 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='Eulaceura' AND (junior_species='osteria' OR junior_species='osteria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulaceura' AND (species='osteria' OR species='osteria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulaceura' AND (species='osteria' OR species='osteria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulaceura' AND (junior_species='osteria' OR junior_species='osteria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulaceura' AND (species='osteria' OR species='osteria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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 * FROM register WHERE sample_no=1321 The Ecological Register: Sungai Wain Protection Forest (unburned core area)
Sungai Wain Protection Forest (unburned core area)
Basic information
Sample name: Sungai Wain Protection Forest (unburned core area)

Reference: K. Matsumoto, W. A. Noerdjito, and K. Fukuyama. 2015. Restoration of butterflies in Acacia mangium plantations established on degraded grasslands in East Kalimantan. Journal of Tropical Forest Science 27(1):47-59 [ER 884]
Geography
Country: Indonesia

State: East Kalimantan


Coordinate: 1° 16' S, 116° 50' E
Coordinate basis: based on nearby landmark

Geography comments: "near Balikpapan" (basis of coordinate)

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: forest reserve

Substrate: ground surface

MAT: 26.5

MAP: 2968.0

Habitat comments: "dipterocarp forests"
climate data are for Sungai Wain Protection Forest and are from Fredriksson and Wich (2006, Biol J Linn Soc)

Methods
Life forms: butterflies

Site length: 1200

Sampling methods: line transect,butterfly nets

Sample size: 69 individuals

Years: 2004, 2005

Days: 8

Sampling comments: eight 45 minute "hand-netting" samples

Metadata
Sample number: 1321

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-21 12:09:20

Modified: 2016-12-13 10:29:29

Abundance distribution
31 species
17 singletons
total count 69
extrapolated richness: 103.0
Fisher's α: 21.646
geometric series k: 0.9232
Hurlbert's PIE: 0.9397
Shannon's H: 3.1357
Good's u: 0.7553
Each square represents a species. Square sizes are proportional to counts.
Register