Coordinate: 14° 8' N, 121° 14' E
plots ranged in elevation from 400 to 410 m
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=3055 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3055SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2814SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3055 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ahernia' AND (junior_species='glandulosa' OR junior_species='glandulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ahernia' AND (species='glandulosa' OR species='glandulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ahernia' AND (species='glandulosa' OR species='glandulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ahernia' AND (junior_species='glandulosa' OR junior_species='glandulosa')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='Ahernia' AND (species='glandulosa' OR species='glandulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='longiflorum' OR junior_species='longiflorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alangium' AND (species='longiflorum' OR species='longiflorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alangium' AND (species='longiflorum' OR species='longiflorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='longiflorum' OR junior_species='longiflorum')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='Alangium' AND (species='longiflorum' OR species='longiflorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='luzonica' OR junior_species='luzonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='luzonica' OR species='luzonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='luzonica' OR species='luzonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='luzonica' OR junior_species='luzonica')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='Celtis' AND (species='luzonica' OR species='luzonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocnide' AND (junior_species='meyeniana' OR junior_species='meyeniana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocnide' AND (species='meyeniana' OR species='meyeniana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocnide' AND (species='meyeniana' OR species='meyeniana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocnide' AND (junior_species='meyeniana' OR junior_species='meyeniana')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='Dendrocnide' AND (species='meyeniana' OR species='meyeniana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodiscus' AND (junior_species='paniculatus' OR junior_species='paniculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplodiscus' AND (species='paniculatus' OR species='paniculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplodiscus' AND (species='paniculatus' OR species='paniculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplodiscus' AND (junior_species='paniculatus' OR junior_species='paniculatus')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='Diplodiscus' AND (species='paniculatus' OR species='paniculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dracontomelon' AND (junior_species='dao' OR junior_species='dao')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dracontomelon' AND (species='dao' OR species='dao') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dracontomelon' AND (species='dao' OR species='dao')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dracontomelon' AND (junior_species='dao' OR junior_species='dao')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='Dracontomelon' AND (species='dao' OR species='dao') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='congesta' OR junior_species='congesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='congesta' OR species='congesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='congesta' OR species='congesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='congesta' OR junior_species='congesta')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='Ficus' AND (species='congesta' OR species='congesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='variegata' OR junior_species='variegata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='variegata' OR species='variegata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='variegata' OR species='variegata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='variegata' OR junior_species='variegata')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='Ficus' AND (species='variegata' OR species='variegata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptospermum' AND (junior_species='falvescens' OR junior_species='falvescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptospermum' AND (species='falvescens' OR species='falvescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptospermum' AND (species='falvescens' OR species='falvescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptospermum' AND (junior_species='falvescens' OR junior_species='falvescens')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='Leptospermum' AND (species='falvescens' OR species='falvescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leukosyke' AND (junior_species='capitellata' OR junior_species='capitellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leukosyke' AND (species='capitellata' OR species='capitellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leukosyke' AND (species='capitellata' OR species='capitellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leukosyke' AND (junior_species='capitellata' OR junior_species='capitellata')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='Leukosyke' AND (species='capitellata' OR species='capitellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='philippinensis' OR junior_species='philippinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='philippinensis' OR species='philippinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='philippinensis' OR species='philippinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='philippinensis' OR junior_species='philippinensis')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='Myristica' AND (species='philippinensis' OR species='philippinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='foxworthyi' OR junior_species='foxworthyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaquium' AND (species='foxworthyi' OR species='foxworthyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaquium' AND (species='foxworthyi' OR species='foxworthyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='foxworthyi' OR junior_species='foxworthyii')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='Palaquium' AND (species='foxworthyi' OR species='foxworthyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocymbium' AND (junior_species='tinctorium' OR junior_species='tinctorium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterocymbium' AND (species='tinctorium' OR species='tinctorium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterocymbium' AND (species='tinctorium' OR species='tinctorium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocymbium' AND (junior_species='tinctorium' OR junior_species='tinctorium')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='Pterocymbium' AND (species='tinctorium' OR species='tinctorium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semecarpus' AND (junior_species='cuneiformis' OR junior_species='cuneiformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Semecarpus' AND (species='cuneiformis' OR species='cuneiformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Semecarpus' AND (species='cuneiformis' OR species='cuneiformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semecarpus' AND (junior_species='cuneiformis' OR junior_species='cuneiformis')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='Semecarpus' AND (species='cuneiformis' OR species='cuneiformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swietenia' AND (junior_species='macrophylla' OR junior_species='macrophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swietenia' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swietenia' AND (species='macrophylla' OR species='macrophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swietenia' AND (junior_species='macrophylla' OR junior_species='macrophylla')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='Swietenia' AND (species='macrophylla' OR species='macrophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='foetidissima' OR junior_species='foetidissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='foetidissima' OR species='foetidissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='foetidissima' OR species='foetidissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='foetidissima' OR junior_species='foetidissima')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='Terminalia' AND (species='foetidissima' OR species='foetidissima') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3055