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=167 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=167SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=62SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=167 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gluta' AND (junior_species='renghas' OR junior_species='renghas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gluta' AND (species='renghas' OR species='renghas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gluta' AND (species='renghas' OR species='renghas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gluta' AND (junior_species='renghas' OR junior_species='renghas')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='Gluta' AND (species='renghas' OR species='renghas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='palembanica' OR junior_species='palembanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Shorea' AND (species='palembanica' OR species='palembanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shorea' AND (species='palembanica' OR species='palembanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shorea' AND (junior_species='palembanica' OR junior_species='palembanica')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='palembanica' OR species='palembanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinarium' AND (junior_species='corymbosum' OR junior_species='corymbosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parinarium' AND (species='corymbosum' OR species='corymbosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parinarium' AND (species='corymbosum' OR species='corymbosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinarium' AND (junior_species='corymbosum' OR junior_species='corymbosum')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='Parinarium' AND (species='corymbosum' OR species='corymbosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sandoricum' AND (junior_species='emarginatum' OR junior_species='emarginatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sandoricum' AND (species='emarginatum' OR species='emarginatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sandoricum' AND (species='emarginatum' OR species='emarginatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sandoricum' AND (junior_species='emarginatum' OR junior_species='emarginatum')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='Sandoricum' AND (species='emarginatum' OR species='emarginatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sexangulata' OR junior_species='sexangulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='sexangulata' OR species='sexangulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='sexangulata' OR species='sexangulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='sexangulata' OR junior_species='sexangulata')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='Eugenia' AND (species='sexangulata' OR species='sexangulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='celebica' OR junior_species='celebica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='celebica' OR species='celebica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='celebica' OR species='celebica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='celebica' OR junior_species='celebica')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='celebica' OR species='celebica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Horsfieldia' AND (junior_species='crassifolia' OR junior_species='crassifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Horsfieldia' AND (species='crassifolia' OR species='crassifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Horsfieldia' AND (species='crassifolia' OR species='crassifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Horsfieldia' AND (junior_species='crassifolia' OR junior_species='crassifolia')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='Horsfieldia' AND (species='crassifolia' OR species='crassifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='gracilipes' OR junior_species='gracilipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='gracilipes' OR species='gracilipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='gracilipes' OR species='gracilipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='gracilipes' OR junior_species='gracilipes')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='gracilipes' OR species='gracilipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='spatulata' OR junior_species='spatulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alstonia' AND (species='spatulata' OR species='spatulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alstonia' AND (species='spatulata' OR species='spatulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='spatulata' OR junior_species='spatulata')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='Alstonia' AND (species='spatulata' OR species='spatulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='longipetiolata' OR junior_species='longipetiolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mangifera' AND (species='longipetiolata' OR species='longipetiolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mangifera' AND (species='longipetiolata' OR species='longipetiolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mangifera' AND (junior_species='longipetiolata' OR junior_species='longipetiolata')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='Mangifera' AND (species='longipetiolata' OR species='longipetiolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramerista' AND (junior_species='glabra' OR junior_species='glabra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetramerista' AND (species='glabra' OR species='glabra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetramerista' AND (species='glabra' OR species='glabra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetramerista' AND (junior_species='glabra' OR junior_species='glabra')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='Tetramerista' AND (species='glabra' OR species='glabra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dillenia' AND (junior_species='puchella' OR junior_species='puchella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dillenia' AND (species='puchella' OR species='puchella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dillenia' AND (species='puchella' OR species='puchella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dillenia' AND (junior_species='puchella' OR junior_species='puchella')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='Dillenia' AND (species='puchella' OR species='puchella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='dioica' OR junior_species='dioica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='dioica' OR species='dioica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='dioica' OR species='dioica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='dioica' OR junior_species='dioica')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='dioica' OR species='dioica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebe' AND (junior_species='lanceolata' OR junior_species='lanceolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebe' AND (species='lanceolata' OR species='lanceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebe' AND (species='lanceolata' OR species='lanceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebe' AND (junior_species='lanceolata' OR junior_species='lanceolata')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='Phoebe' AND (species='lanceolata' OR species='lanceolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='diversifolia' OR junior_species='diversifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptocarya' AND (species='diversifolia' OR species='diversifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptocarya' AND (species='diversifolia' OR species='diversifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptocarya' AND (junior_species='diversifolia' OR junior_species='diversifolia')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='Cryptocarya' AND (species='diversifolia' OR species='diversifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tree' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tree' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tree' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tree' AND (junior_species='indet.' OR junior_species='indet.')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='Tree' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' 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='Myristica' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' 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='Myristica' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campnosperma' AND (junior_species='coriaceum' OR junior_species='coriaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campnosperma' AND (species='coriaceum' OR species='coriaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campnosperma' AND (species='coriaceum' OR species='coriaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campnosperma' AND (junior_species='coriaceum' OR junior_species='coriaceum')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='Campnosperma' AND (species='coriaceum' OR species='coriaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='oblongata' OR junior_species='oblongata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='oblongata' OR species='oblongata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='oblongata' OR species='oblongata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='oblongata' OR junior_species='oblongata')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='Sterculia' AND (species='oblongata' OR species='oblongata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platea' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platea' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platea' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platea' AND (junior_species='excelsa' OR junior_species='excelsa')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='Platea' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icacinaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Icacinaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Icacinaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icacinaceae' AND (junior_species='indet.' OR junior_species='indet.')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='Icacinaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='rubiginosa' OR junior_species='rubiginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='rubiginosa' OR species='rubiginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='rubiginosa' OR species='rubiginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='rubiginosa' OR junior_species='rubiginosa')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='Sterculia' AND (species='rubiginosa' OR species='rubiginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adina' AND (junior_species='minutiflora' OR junior_species='minutiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adina' AND (species='minutiflora' OR species='minutiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adina' AND (species='minutiflora' OR species='minutiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adina' AND (junior_species='minutiflora' OR junior_species='minutiflora')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='Adina' AND (species='minutiflora' OR species='minutiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rubiaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rubiaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rubiaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rubiaceae' AND (junior_species='indet.' OR junior_species='indet.')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='Rubiaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='xyllophylla' OR junior_species='xyllophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='xyllophylla' OR species='xyllophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='xyllophylla' OR species='xyllophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='xyllophylla' OR junior_species='xyllophylla')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='xyllophylla' OR species='xyllophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moraceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moraceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moraceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moraceae' AND (junior_species='indet.' OR junior_species='indet.')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='Moraceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='diepenhorstii' OR junior_species='diepenhorsti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='diepenhorstii' OR species='diepenhorsti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='diepenhorstii' OR species='diepenhorsti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='diepenhorstii' OR junior_species='diepenhorsti')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='Macaranga' AND (species='diepenhorstii' OR species='diepenhorsti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gardenia' AND (junior_species='anysophylla' OR junior_species='anysophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gardenia' AND (species='anysophylla' OR species='anysophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gardenia' AND (species='anysophylla' OR species='anysophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gardenia' AND (junior_species='anysophylla' OR junior_species='anysophylla')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='Gardenia' AND (species='anysophylla' OR species='anysophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='patens' OR junior_species='patens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialium' AND (species='patens' OR species='patens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialium' AND (species='patens' OR species='patens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='patens' OR junior_species='patens')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='Dialium' AND (species='patens' OR species='patens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' 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='Dysoxylum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' 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='Dysoxylum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meliaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meliaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliaceae' AND (junior_species='indet.' OR junior_species='indet.')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='Meliaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='lineata' OR junior_species='lineata')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='Eugenia' AND (species='lineata' OR species='lineata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=167 The Ecological Register: Suaq Balimbing Research Station
Suaq Balimbing Research Station
Basic information
Sample name: Suaq Balimbing Research Station

Sample aka: Gunung Leuser National Park

Reference: Purwaningsih and R. Yusuf. 2000. Vegetation analysis of Suaq Balimbing peat swamp forest, Gunung Leuser National Park-South Aceh. In Proceedings of the International Symposium on Tropical Peatlands (eds. T. Iwakuma, T. Inoue, T. Kohyama, M. Osaki, H. Simbolon, H. Tachibana, H. Takaha), pp. 274-228 [ER 62]
Geography
Country: Indonesia

State: Sumatra


Coordinate: 3° 4' N, 97° 25' E
Coordinate basis: stated in text

Geography comments: altitude 15 to 20 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

MAP: 3400.0

Habitat comments: MAP is for Suaq Balimbing and is from van Schaik (1999, Primates)

Methods
Life forms: trees

Sites: 1

Site length: 160

Site width: 100

Sampling methods: quadrat

Sample size: 1289 individuals

Size min: 10

Basal area: 44.3

Metadata
Sample number: 167

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-08 15:59:14

Modified: 2017-11-12 02:10:37

Abundance distribution
32 species
9 singletons
total count 1289
extrapolated richness: 53.1
Fisher's α: 5.944
geometric series k: 0.8284
Hurlbert's PIE: 0.8825
Shannon's H: 2.5158
Good's u: 0.9930
Each square represents a species. Square sizes are proportional to counts.
Register