Coordinate: 1° 16' S, 116° 50' E
climate data are for Sungai Wain Protection Forest and are from Fredriksson and Wich (2006, Biol J Linn Soc)
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=1322 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1322SELECT 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=1322 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taractrocera' AND (junior_species='ardonia' OR junior_species='ardonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taractrocera' AND (species='ardonia' OR species='ardonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taractrocera' AND (species='ardonia' OR species='ardonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taractrocera' AND (junior_species='ardonia' OR junior_species='ardonia')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='Taractrocera' AND (species='ardonia' OR species='ardonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potanthus' AND (junior_species='hetaerus' OR junior_species='hetaerus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potanthus' AND (species='hetaerus' OR species='hetaerus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Potanthus' AND (species='hetaerus' OR species='hetaerus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potanthus' AND (junior_species='hetaerus' OR junior_species='hetaerus')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='Potanthus' AND (species='hetaerus' OR species='hetaerus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polytrermis' AND (junior_species='lubricans' OR junior_species='lubricans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polytrermis' AND (species='lubricans' OR species='lubricans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polytrermis' AND (species='lubricans' OR species='lubricans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polytrermis' AND (junior_species='lubricans' OR junior_species='lubricans')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='Polytrermis' AND (species='lubricans' OR species='lubricans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='hecabe' OR species='hecabe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='hecabe' OR species='hecabe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='hecabe' OR junior_species='hecabe')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='hecabe' OR species='hecabe') 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='Leptosia' AND (junior_species='nina' OR junior_species='nina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptosia' AND (species='nina' OR species='nina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptosia' AND (species='nina' OR species='nina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptosia' AND (junior_species='nina' OR junior_species='nina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptosia' AND (species='nina' OR species='nina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='olferna' OR junior_species='olferna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Appias' AND (species='olferna' OR species='olferna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Appias' AND (species='olferna' OR species='olferna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Appias' AND (junior_species='olferna' OR junior_species='olferna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Appias' AND (species='olferna' OR species='olferna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='celeno' OR junior_species='celeno')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jamides' AND (species='celeno' OR species='celeno') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jamides' AND (species='celeno' OR species='celeno')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='celeno' OR junior_species='celeno')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jamides' AND (species='celeno' OR species='celeno') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jamides' AND (junior_species='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='Anosia' AND (junior_species='melanippus' OR junior_species='melanippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anosia' AND (species='melanippus' OR species='melanippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anosia' AND (species='melanippus' OR species='melanippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anosia' AND (junior_species='melanippus' OR junior_species='melanippus')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='Anosia' AND (species='melanippus' OR species='melanippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ideopsis' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ideopsis' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ideopsis' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ideopsis' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ideopsis' AND (species='vulgaris' OR species='vulgaris') 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='Parantica' AND (junior_species='agleoides' OR junior_species='agleoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parantica' AND (species='agleoides' OR species='agleoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parantica' AND (species='agleoides' OR species='agleoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parantica' AND (junior_species='agleoides' OR junior_species='agleoides')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='agleoides' OR species='agleoides') 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='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='perseus' OR junior_species='perseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mycalesis' AND (species='perseus' OR species='perseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mycalesis' AND (species='perseus' OR species='perseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mycalesis' AND (junior_species='perseus' OR junior_species='perseus')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='perseus' OR species='perseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orsotriaena' AND (junior_species='medus' OR junior_species='medus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orsotriaena' AND (species='medus' OR species='medus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orsotriaena' AND (species='medus' OR species='medus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orsotriaena' AND (junior_species='medus' OR junior_species='medus')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='Orsotriaena' AND (species='medus' OR species='medus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='pandocus' OR junior_species='pandocus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='pandocus' OR species='pandocus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='pandocus' OR species='pandocus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='pandocus' OR junior_species='pandocus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ypthima' AND (species='pandocus' OR species='pandocus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1322