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=1637 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1637SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1117SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1637 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bouea' AND (junior_species='oppositifolia' OR junior_species='oppositifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bouea' AND (species='oppositifolia' OR species='oppositifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bouea' AND (species='oppositifolia' OR species='oppositifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bouea' AND (junior_species='oppositifolia' OR junior_species='oppositifolia')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='Bouea' AND (species='oppositifolia' OR species='oppositifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='arborescens' OR junior_species='arborescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buchanania' AND (species='arborescens' OR species='arborescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buchanania' AND (species='arborescens' OR species='arborescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='arborescens' OR junior_species='arborescens')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='Buchanania' AND (species='arborescens' OR species='arborescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='sessilifolia' OR junior_species='sessilifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buchanania' AND (species='sessilifolia' OR species='sessilifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buchanania' AND (species='sessilifolia' OR species='sessilifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchanania' AND (junior_species='sessilifolia' OR junior_species='sessilifolia')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='Buchanania' AND (species='sessilifolia' OR species='sessilifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='sp.' OR junior_species='sp.')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='Canarium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drimycarpus' AND (junior_species='luridus' OR junior_species='luridus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drimycarpus' AND (species='luridus' OR species='luridus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drimycarpus' AND (species='luridus' OR species='luridus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drimycarpus' AND (junior_species='luridus' OR junior_species='luridus')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='Drimycarpus' AND (species='luridus' OR species='luridus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanochyla' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanochyla' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanochyla' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanochyla' AND (junior_species='sp.' OR junior_species='sp.')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='Melanochyla' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmos' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmos' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Desmos' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmos' AND (junior_species='sp.' OR junior_species='sp.')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='Desmos' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goniothalamus' AND (junior_species='ridleyiii' OR junior_species='ridleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Goniothalamus' AND (species='ridleyiii' OR species='ridleyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Goniothalamus' AND (species='ridleyiii' OR species='ridleyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goniothalamus' AND (junior_species='ridleyiii' OR junior_species='ridleyii')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='Goniothalamus' AND (species='ridleyiii' OR species='ridleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monocarpia' AND (junior_species='marginalis' OR junior_species='marginalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monocarpia' AND (species='marginalis' OR species='marginalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monocarpia' AND (species='marginalis' OR species='marginalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monocarpia' AND (junior_species='marginalis' OR junior_species='marginalis')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='Monocarpia' AND (species='marginalis' OR species='marginalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyalthia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyalthia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyalthia' AND (junior_species='sp.' OR junior_species='sp.')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='Polyalthia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='sp.' OR junior_species='sp.')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='Xylopia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Santiria' AND (junior_species='laevigata' OR junior_species='laevigata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Santiria' AND (species='laevigata' OR species='laevigata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Santiria' AND (species='laevigata' OR species='laevigata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Santiria' AND (junior_species='laevigata' OR junior_species='laevigata')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='Santiria' AND (species='laevigata' OR species='laevigata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='euginiifolia' OR junior_species='euginiifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='euginiifolia' OR species='euginiifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='euginiifolia' OR species='euginiifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='euginiifolia' OR junior_species='euginiifolia')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='Garcinia' AND (species='euginiifolia' OR species='euginiifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='hombroiniana' OR junior_species='hombroiniana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='hombroiniana' OR species='hombroiniana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='hombroiniana' OR species='hombroiniana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='hombroiniana' OR junior_species='hombroiniana')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='Garcinia' AND (species='hombroiniana' OR species='hombroiniana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesua' AND (junior_species='ferrea' OR junior_species='ferrea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesua' AND (species='ferrea' OR species='ferrea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesua' AND (species='ferrea' OR species='ferrea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesua' AND (junior_species='ferrea' OR junior_species='ferrea')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='Mesua' AND (species='ferrea' OR species='ferrea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='megarawan' OR junior_species='megarawan')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hopea' AND (species='megarawan' OR species='megarawan') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hopea' AND (species='megarawan' OR species='megarawan')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hopea' AND (junior_species='megarawan' OR junior_species='megarawan')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='Hopea' AND (species='megarawan' OR species='megarawan') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='collina' OR junior_species='collina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Shorea' AND (species='collina' OR species='collina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='collina' OR species='collina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='collina' OR junior_species='collina')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='Shorea' AND (species='collina' OR species='collina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='materialis' OR junior_species='materialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Shorea' AND (species='materialis' OR species='materialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='materialis' OR species='materialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='materialis' OR junior_species='materialis')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='Shorea' AND (species='materialis' OR species='materialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatica' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vatica' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vatica' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vatica' AND (junior_species='sp.' OR junior_species='sp.')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='Vatica' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='ferrea' OR junior_species='ferrea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='ferrea' OR species='ferrea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='ferrea' OR species='ferrea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='ferrea' OR junior_species='ferrea')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='Diospyros' AND (species='ferrea' OR species='ferrea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='cuneatum' OR junior_species='cuneatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythroxylum' AND (species='cuneatum' OR species='cuneatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythroxylum' AND (species='cuneatum' OR species='cuneatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='cuneatum' OR junior_species='cuneatum')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='Erythroxylum' AND (species='cuneatum' OR species='cuneatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleistanthus' AND (junior_species='sumatranus' OR junior_species='sumatranus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cleistanthus' AND (species='sumatranus' OR species='sumatranus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cleistanthus' AND (species='sumatranus' OR species='sumatranus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleistanthus' AND (junior_species='sumatranus' OR junior_species='sumatranus')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='Cleistanthus' AND (species='sumatranus' OR species='sumatranus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='laevifolius' OR junior_species='laevifolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Croton' AND (species='laevifolius' OR species='laevifolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='laevifolius' OR species='laevifolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='laevifolius' OR junior_species='laevifolius')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='Croton' AND (species='laevifolius' OR species='laevifolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pimelodendron' AND (junior_species='griffithianum' OR junior_species='griffithianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pimelodendron' AND (species='griffithianum' OR species='griffithianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pimelodendron' AND (species='griffithianum' OR species='griffithianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pimelodendron' AND (junior_species='griffithianum' OR junior_species='griffithianum')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='Pimelodendron' AND (species='griffithianum' OR species='griffithianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sindora' AND (junior_species='velutina' OR junior_species='velutina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sindora' AND (species='velutina' OR species='velutina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sindora' AND (species='velutina' OR species='velutina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sindora' AND (junior_species='velutina' OR junior_species='velutina')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='Sindora' AND (species='velutina' OR species='velutina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithocarpus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithocarpus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithocarpus' AND (junior_species='sp.' OR junior_species='sp.')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='Lithocarpus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stemonurus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stemonurus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stemonurus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stemonurus' AND (junior_species='sp.' OR junior_species='sp.')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='Stemonurus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseodaphne' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alseodaphne' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alseodaphne' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseodaphne' AND (junior_species='sp.' OR junior_species='sp.')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='Alseodaphne' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beilschmiedia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Beilschmiedia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='sp.' OR junior_species='sp.')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='Beilschmiedia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='sp.' OR junior_species='sp.')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='Litsea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barringtonia' AND (junior_species='acutangula' OR junior_species='acutangula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Barringtonia' AND (species='acutangula' OR species='acutangula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Barringtonia' AND (species='acutangula' OR species='acutangula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barringtonia' AND (junior_species='acutangula' OR junior_species='acutangula')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='Barringtonia' AND (species='acutangula' OR species='acutangula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglaia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglaia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaia' AND (junior_species='sp.' OR junior_species='sp.')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='Aglaia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chisocheton' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chisocheton' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chisocheton' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chisocheton' AND (junior_species='sp.' OR junior_species='sp.')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='Chisocheton' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='cauliflorum' OR junior_species='cauliflorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysoxylum' AND (species='cauliflorum' OR species='cauliflorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='cauliflorum' OR species='cauliflorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='cauliflorum' OR junior_species='cauliflorum')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='Dysoxylum' AND (species='cauliflorum' OR species='cauliflorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='pseudolaurina' OR junior_species='pseudolaurina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Knema' AND (species='pseudolaurina' OR species='pseudolaurina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Knema' AND (species='pseudolaurina' OR species='pseudolaurina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knema' AND (junior_species='pseudolaurina' OR junior_species='pseudolaurina')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='Knema' AND (species='pseudolaurina' OR species='pseudolaurina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='gigantea' OR junior_species='gigantea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='gigantea' OR species='gigantea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='gigantea' OR species='gigantea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='gigantea' OR junior_species='gigantea')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='gigantea' OR species='gigantea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='grande' OR junior_species='grande')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='grande' OR species='grande') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='grande' OR species='grande')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='grande' OR junior_species='grande')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='Syzygium' AND (species='grande' OR species='grande') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthophyllum' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthophyllum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthophyllum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthophyllum' AND (junior_species='sp.' OR junior_species='sp.')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='Xanthophyllum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maclurodendron' AND (junior_species='porteri' OR junior_species='porterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maclurodendron' AND (species='porteri' OR species='porterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maclurodendron' AND (species='porteri' OR species='porterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maclurodendron' AND (junior_species='porteri' OR junior_species='porterii')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='Maclurodendron' AND (species='porteri' OR species='porterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scleropyrum' AND (junior_species='pentandrum' OR junior_species='pentandrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scleropyrum' AND (species='pentandrum' OR species='pentandrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scleropyrum' AND (species='pentandrum' OR species='pentandrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scleropyrum' AND (junior_species='pentandrum' OR junior_species='pentandrum')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='Scleropyrum' AND (species='pentandrum' OR species='pentandrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerospermum' AND (junior_species='noronhianum' OR junior_species='noronhianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xerospermum' AND (species='noronhianum' OR species='noronhianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xerospermum' AND (species='noronhianum' OR species='noronhianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerospermum' AND (junior_species='noronhianum' OR junior_species='noronhianum')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='Xerospermum' AND (species='noronhianum' OR species='noronhianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madhuca' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Madhuca' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Madhuca' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Madhuca' AND (junior_species='sp.' OR junior_species='sp.')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='Madhuca' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaquium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaquium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaquium' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='pinnata' OR junior_species='pinnata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitex' AND (species='pinnata' OR species='pinnata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitex' AND (species='pinnata' OR species='pinnata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='pinnata' OR junior_species='pinnata')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='Vitex' AND (species='pinnata' OR species='pinnata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1637 The Ecological Register: Jambu Bongkok Forest Reserve
Jambu Bongkok Forest Reserve
Basic information
Sample name: Jambu Bongkok Forest Reserve

Reference: M. S. Jamilah, A. G. Nur-Faiezah, A. Siti Kehirah, M. N. Siti Mariam, and M. S. Razali. 2014. Woody plants on dune landscape of Terengganu, Peninsular Malaysia. Journal of Tropical Forest Science 26(2):267-274 [ER 1117]
Geography
Country: Malaysia

State: Terengganu


Coordinate: 4° 54' N, 103° 22' E
Coordinate basis: stated in text

Geography comments: altitude range of 3 to 12 m is for the Jambu Bongkok Virgin Jungle Reserve at 4º 55' N, 103º 21' E and is from Syuharni et al. (2014, Emir. J. Food Agric.)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: forest reserve

Substrate: ground surface

WMT: 27.6

CMT: 25.1

MAP: 3311.0

Habitat comments: "lowland mixed dipterocarp forest" in a dune landscape
climate data based on station 486570 (Pahang airport)

Methods
Life forms: trees

Sites: 1

Site length: 100

Site width: 50

Sample size: 451 individuals

Size min: 5

Metadata
Sample number: 1637

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-06-14 15:03:23

Modified: 2017-11-10 02:13:09

Abundance distribution
44 species
12 singletons
total count 451
extrapolated richness: 76.7
Fisher's α: 12.062
geometric series k: 0.8993
Hurlbert's PIE: 0.9155
Shannon's H: 2.9698
Good's u: 0.9734
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bouea oppositifolia5
Buchanania arborescens2
Buchanania sessilifolia2
Canarium sp.1
Drimycarpus luridus1
Melanochyla sp.7
Desmos sp.1
Goniothalamus ridleyiii6
Monocarpia marginalis16
Polyalthia sp.3
Xylopia sp.1
Santiria laevigata4
Garcinia euginiifolia3
Garcinia hombroiniana2
Mesua ferrea10
Hopea megarawan40
Shorea collina4
Shorea materialis96
Vatica sp.1
Diospyros ferrea30
Erythroxylum cuneatum1
Cleistanthus sumatranus21
Croton laevifolius3
Pimelodendron griffithianum1
Sindora velutina1
Lithocarpus sp.1
Stemonurus sp.1
Alseodaphne sp.2
Beilschmiedia sp.3
Litsea sp.12
Barringtonia acutangula23
Aglaia sp.18
Chisocheton sp.2
Dysoxylum cauliflorum4
Knema pseudolaurina47
Myristica gigantea3
Syzygium grande13
Xanthophyllum sp.8
Maclurodendron porteri1
Scleropyrum pentandrum1
Xerospermum noronhianum26
Madhuca sp.5
Palaquium sp.3
Vitex pinnata16