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=237 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=237SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=96SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=237 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinodaphne' AND (junior_species='obovata' OR junior_species='obovata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Actinodaphne' AND (species='obovata' OR species='obovata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Actinodaphne' AND (species='obovata' OR species='obovata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Actinodaphne' AND (junior_species='obovata' OR junior_species='obovata')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='Actinodaphne' AND (species='obovata' OR species='obovata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseodaphnopsis' AND (junior_species='petiolaris' OR junior_species='petiolaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alseodaphnopsis' AND (species='petiolaris' OR species='petiolaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alseodaphnopsis' AND (species='petiolaris' OR species='petiolaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alseodaphnopsis' AND (junior_species='petiolaris' OR junior_species='petiolaris')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='Alseodaphnopsis' AND (species='petiolaris' OR species='petiolaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicarpa' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicarpa' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicarpa' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicarpa' AND (junior_species='arborea' OR junior_species='arborea')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='Callicarpa' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castanopsis' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castanopsis' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' AND (junior_species='indica' OR junior_species='indica')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='Castanopsis' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' AND (junior_species='tribuloides' OR junior_species='tribuloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castanopsis' AND (species='tribuloides' OR species='tribuloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castanopsis' AND (species='tribuloides' OR species='tribuloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castanopsis' AND (junior_species='tribuloides' OR junior_species='tribuloides')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='Castanopsis' AND (species='tribuloides' OR species='tribuloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='australis' OR junior_species='australis')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='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='glaucescens' OR junior_species='glaucescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='glaucescens' OR species='glaucescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='glaucescens' OR species='glaucescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='glaucescens' OR junior_species='glaucescens')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='Cinnamomum' AND (species='glaucescens' OR species='glaucescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='obtusifoluim' OR junior_species='obtusifoluim')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='obtusifoluim' OR species='obtusifoluim') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='obtusifoluim' OR species='obtusifoluim')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='obtusifoluim' OR junior_species='obtusifoluim')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='Cinnamomum' AND (species='obtusifoluim' OR species='obtusifoluim') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='zeylanicum' OR junior_species='zeylanicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnamomum' AND (species='zeylanicum' OR species='zeylanicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnamomum' AND (species='zeylanicum' OR species='zeylanicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnamomum' AND (junior_species='zeylanicum' OR junior_species='zeylanicum')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='Cinnamomum' AND (species='zeylanicum' OR species='zeylanicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='toposia' OR junior_species='toposia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='toposia' OR species='toposia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='toposia' OR species='toposia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='toposia' OR junior_species='toposia')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='toposia' OR species='toposia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drimycarpus' AND (junior_species='racemosus' OR junior_species='racemosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drimycarpus' AND (species='racemosus' OR species='racemosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drimycarpus' AND (species='racemosus' OR species='racemosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drimycarpus' AND (junior_species='racemosus' OR junior_species='racemosus')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='racemosus' OR species='racemosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='macrocarpum' OR junior_species='macrocarpum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysoxylum' AND (species='macrocarpum' OR species='macrocarpum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='macrocarpum' OR species='macrocarpum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='macrocarpum' OR junior_species='macrocarpum')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='macrocarpum' OR species='macrocarpum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='excelsum' OR junior_species='excelsum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysoxylum' AND (species='excelsum' OR species='excelsum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysoxylum' AND (species='excelsum' OR species='excelsum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysoxylum' AND (junior_species='excelsum' OR junior_species='excelsum')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='excelsum' OR species='excelsum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='tectorius' OR junior_species='tectorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeocarpus' AND (species='tectorius' OR species='tectorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeocarpus' AND (species='tectorius' OR species='tectorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeocarpus' AND (junior_species='tectorius' OR junior_species='tectorius')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='Elaeocarpus' AND (species='tectorius' OR species='tectorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Engelhardia' AND (junior_species='spicata' OR junior_species='spicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Engelhardia' AND (species='spicata' OR species='spicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Engelhardia' AND (species='spicata' OR species='spicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Engelhardia' AND (junior_species='spicata' OR junior_species='spicata')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='Engelhardia' AND (species='spicata' OR species='spicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriobotrya' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eriobotrya' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriobotrya' AND (species='bengalensis' OR species='bengalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriobotrya' AND (junior_species='bengalensis' OR junior_species='bengalensis')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='Eriobotrya' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='cumini' OR junior_species='cuminii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='cumini' OR species='cuminii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='cumini' OR species='cuminii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='cumini' OR junior_species='cuminii')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='cumini' OR species='cuminii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='morella' OR junior_species='morella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='morella' OR species='morella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='morella' OR species='morella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='morella' OR junior_species='morella')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='morella' OR species='morella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='robusta' OR junior_species='robusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicia' AND (species='robusta' OR species='robusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicia' AND (species='robusta' OR species='robusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicia' AND (junior_species='robusta' OR junior_species='robusta')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='Helicia' AND (species='robusta' OR species='robusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='godajam' OR junior_species='godajam')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ilex' AND (species='godajam' OR species='godajam') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ilex' AND (species='godajam' OR species='godajam')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='godajam' OR junior_species='godajam')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='Ilex' AND (species='godajam' OR species='godajam') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leea' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leea' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leea' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leea' AND (junior_species='indica' OR junior_species='indica')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='Leea' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='polyantha' OR junior_species='polyantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='polyantha' OR species='polyantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='polyantha' OR species='polyantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='polyantha' OR junior_species='polyantha')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='polyantha' OR species='polyantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='semecarpifolia' OR junior_species='semecarpifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Litsea' AND (species='semecarpifolia' OR species='semecarpifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Litsea' AND (species='semecarpifolia' OR species='semecarpifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Litsea' AND (junior_species='semecarpifolia' OR junior_species='semecarpifolia')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='semecarpifolia' OR species='semecarpifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='indica' OR junior_species='indica')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='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='linifolia' OR junior_species='linifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myristica' AND (species='linifolia' OR species='linifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myristica' AND (species='linifolia' OR species='linifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myristica' AND (junior_species='linifolia' OR junior_species='linifolia')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='linifolia' OR species='linifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebe' AND (junior_species='attenuata' OR junior_species='attenuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoebe' AND (species='attenuata' OR species='attenuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoebe' AND (species='attenuata' OR species='attenuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoebe' AND (junior_species='attenuata' OR junior_species='attenuata')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='attenuata' OR species='attenuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='xylocarpa' OR junior_species='xylocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quercus' AND (species='xylocarpa' OR species='xylocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quercus' AND (species='xylocarpa' OR species='xylocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quercus' AND (junior_species='xylocarpa' OR junior_species='xylocarpa')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='Quercus' AND (species='xylocarpa' OR species='xylocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balakata' AND (junior_species='baccata' OR junior_species='baccata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Balakata' AND (species='baccata' OR species='baccata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Balakata' AND (species='baccata' OR species='baccata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balakata' AND (junior_species='baccata' OR junior_species='baccata')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='Balakata' AND (species='baccata' OR species='baccata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schima' AND (junior_species='wallichii' OR junior_species='wallichi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schima' AND (species='wallichii' OR species='wallichi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schima' AND (species='wallichii' OR species='wallichi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schima' AND (junior_species='wallichii' OR junior_species='wallichi')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='Schima' AND (species='wallichii' OR species='wallichi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='polysperma' OR junior_species='polysperma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Styrax' AND (species='polysperma' OR species='polysperma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Styrax' AND (species='polysperma' OR species='polysperma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='polysperma' OR junior_species='polysperma')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='Styrax' AND (species='polysperma' OR species='polysperma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='serrulatus' OR junior_species='serrulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Styrax' AND (species='serrulatus' OR species='serrulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Styrax' AND (species='serrulatus' OR species='serrulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Styrax' AND (junior_species='serrulatus' OR junior_species='serrulatus')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='Styrax' AND (species='serrulatus' OR species='serrulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wendlandia' AND (junior_species='grandis' OR junior_species='grandis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wendlandia' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wendlandia' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wendlandia' AND (junior_species='grandis' OR junior_species='grandis')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='Wendlandia' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=237 The Ecological Register: Zobawk
Zobawk
Basic information
Sample name: Zobawk

Reference: Lalfakawma, U. K. Sahoo, S. Roy, K. Vanlalhriatpuia, and P. C. Vanalalhluna. 2009. Community composition and tree population structure in undisturbed and disturbed tropical semi-evergreen forest stands of north-east India. Applied Ecology and Environmental Research 7(4):303-318 [ER 96]
Geography
Country: India

State: Mizoram


Coordinate: 22° 47' 30" N, 92° 47' 50" E
Coordinate basis: stated in text

Geography comments: "in Lunglei District, Mizoram"
altitude is for "near Thualthu... 22º46' 17" N, 92º56' 27" E" and is from Lokeshwor and Vishwanath (2013, Ichthyol Res)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: fragment

Substrate: ground surface

WMT: 26.5

CMT: 15.5

MAP: 4076.0

Dry months: 4

Habitat comments: "about 25 years old natural forest stand" of tropical semi-evergreen forest preserved "from any type of anthropogenic interruption in the natural forest growth except negligible non timber forest products collection... Each of the selected forest stands covers an area of more than about 25 ha of land"

Methods
Life forms: trees

Sites: 50

Site area: 0.5

Sampling methods: quadrat

Sample size: 155 individuals

Years: 2002-2003

Size min: 10

Sampling comments: 50 quadrats of 10 x 10 m sizes, for tree (≥10 cm dbh.) (p. 304). Total site area=0.5 ha. However, results are given in Nº/ha. Thus, n= ( Nº/ha.)*0.5.
JA: authors appear to have screwed up and calculated per 0.2 ha figures, so I have recomputed the counts

Metadata
Sample number: 237

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-25 11:38:56

Modified: 2017-11-10 23:31:03

Abundance distribution
32 species
5 singletons
total count 155
extrapolated richness: 52.1
Fisher's α: 12.238
geometric series k: 0.9110
Hurlbert's PIE: 0.9474
Shannon's H: 3.1734
Good's u: 0.9683
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Actinodaphne obovata3
Alseodaphnopsis petiolaris8
"Alseodaphne petiolaris"
Callicarpa arborea2
Castanopsis indica2
Castanopsis tribuloides18
Celtis australis3
Cinnamomum glaucescens14
Cinnamomum obtusifoluim9
Cinnamomum zeylanicum6
Diospyros toposia1
Drimycarpus racemosus1
Dysoxylum macrocarpum6
Dysoxylum excelsum2
"Dysoxylum procera"
Elaeocarpus tectorius8
"Elaeocarpus robusta"
Engelhardia spicata3
Eriobotrya bengalensis2
Eugenia cumini1
Garcinia morella1
Helicia robusta5
Ilex godajam4
Leea indica1
Litsea polyantha2
Litsea semecarpifolia3
Macaranga indica7
Myristica linifolia4
Phoebe attenuata2
Quercus xylocarpa8
Balakata baccata11
"Sapium baccatum"
Schima wallichii7
Styrax polysperma6
Styrax serrulatus3
"Styrax serrulatum"
Wendlandia grandis2