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=220 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=220SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=88SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=220 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoscypha' 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='Trichoscypha' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichoscypha' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoscypha' 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='Trichoscypha' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monodora' AND (junior_species='tenuifolia' OR junior_species='tenuifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monodora' AND (species='tenuifolia' OR species='tenuifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monodora' AND (species='tenuifolia' OR species='tenuifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monodora' AND (junior_species='tenuifolia' OR junior_species='tenuifolia')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='Monodora' AND (species='tenuifolia' OR species='tenuifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyceratocarpus' AND (junior_species='parviflorus' OR junior_species='parviflorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyceratocarpus' AND (species='parviflorus' OR species='parviflorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyceratocarpus' AND (species='parviflorus' OR species='parviflorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyceratocarpus' AND (junior_species='parviflorus' OR junior_species='parviflorus')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='Polyceratocarpus' AND (species='parviflorus' OR species='parviflorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uvariodendron' AND (junior_species='connivens' OR junior_species='connivens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uvariodendron' AND (species='connivens' OR species='connivens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uvariodendron' AND (species='connivens' OR species='connivens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uvariodendron' AND (junior_species='connivens' OR junior_species='connivens')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='Uvariodendron' AND (species='connivens' OR species='connivens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uvariopsis' AND (junior_species='congulana' OR junior_species='congulana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uvariopsis' AND (species='congulana' OR species='congulana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uvariopsis' AND (species='congulana' OR species='congulana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uvariopsis' AND (junior_species='congulana' OR junior_species='congulana')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='Uvariopsis' AND (species='congulana' OR species='congulana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='boonei' OR junior_species='booneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alstonia' AND (species='boonei' OR species='booneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alstonia' AND (species='boonei' OR species='booneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alstonia' AND (junior_species='boonei' OR junior_species='booneii')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='boonei' OR species='booneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='crassa' OR junior_species='crassa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabernaemontana' AND (species='crassa' OR species='crassa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabernaemontana' AND (species='crassa' OR species='crassa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='crassa' OR junior_species='crassa')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='Tabernaemontana' AND (species='crassa' OR species='crassa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dactyladenia' AND (junior_species='staudtii' OR junior_species='staudti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dactyladenia' AND (species='staudtii' OR species='staudti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dactyladenia' AND (species='staudtii' OR species='staudti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dactyladenia' AND (junior_species='staudtii' OR junior_species='staudti')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='Dactyladenia' AND (species='staudtii' OR species='staudti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='zenkeri' OR junior_species='zenkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='zenkeri' OR species='zenkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='zenkeri' OR species='zenkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='zenkeri' OR junior_species='zenkerii')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='zenkeri' OR species='zenkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='preussii' OR junior_species='preussi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drypetes' AND (species='preussii' OR species='preussi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='preussii' OR species='preussi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='preussii' OR junior_species='preussi')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='Drypetes' AND (species='preussii' OR species='preussi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' 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='Drypetes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' 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='Drypetes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leeuwenbergia' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leeuwenbergia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leeuwenbergia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leeuwenbergia' AND (junior_species='africana' OR junior_species='africana')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='Leeuwenbergia' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='longifolia' OR junior_species='longifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='longifolia' OR species='longifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='longifolia' OR species='longifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='longifolia' OR junior_species='longifolia')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='longifolia' OR species='longifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baikiaea' AND (junior_species='insignis' OR junior_species='insignis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baikiaea' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baikiaea' AND (species='insignis' OR species='insignis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baikiaea' AND (junior_species='insignis' OR junior_species='insignis')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='Baikiaea' AND (species='insignis' OR species='insignis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baphia' 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='Baphia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baphia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baphia' 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='Baphia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Berlinia' 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='Berlinia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Berlinia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Berlinia' 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='Berlinia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Berlinia' AND (junior_species='bracteosa' OR junior_species='bracteosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Berlinia' AND (species='bracteosa' OR species='bracteosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Berlinia' AND (species='bracteosa' OR species='bracteosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Berlinia' AND (junior_species='bracteosa' OR junior_species='bracteosa')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='Berlinia' AND (species='bracteosa' OR species='bracteosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caesalpinoidea' 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='Caesalpinoidea' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caesalpinoidea' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caesalpinoidea' 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='Caesalpinoidea' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenostegia' AND (junior_species='afzelii' OR junior_species='afzeli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hymenostegia' AND (species='afzelii' OR species='afzeli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hymenostegia' AND (species='afzelii' OR species='afzeli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenostegia' AND (junior_species='afzelii' OR junior_species='afzeli')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='Hymenostegia' AND (species='afzelii' OR species='afzeli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lebruniodendron' 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='Lebruniodendron' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lebruniodendron' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lebruniodendron' 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='Lebruniodendron' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='mucuso' OR junior_species='mucuso')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='mucuso' OR species='mucuso') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='mucuso' OR species='mucuso')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='mucuso' OR junior_species='mucuso')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='mucuso' OR species='mucuso') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelocaryon' AND (junior_species='preussii' OR junior_species='preussi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coelocaryon' AND (species='preussii' OR species='preussi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelocaryon' AND (species='preussii' OR species='preussi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelocaryon' AND (junior_species='preussii' OR junior_species='preussi')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='Coelocaryon' AND (species='preussii' OR species='preussi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' 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='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' 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='Eugenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diogoa' AND (junior_species='zenkeri' OR junior_species='zenkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diogoa' AND (species='zenkeri' OR species='zenkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diogoa' AND (species='zenkeri' OR species='zenkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diogoa' AND (junior_species='zenkeri' OR junior_species='zenkerii')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='Diogoa' AND (species='zenkeri' OR species='zenkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='pustulata' OR junior_species='pustulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strombosia' AND (species='pustulata' OR species='pustulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strombosia' AND (species='pustulata' OR species='pustulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='pustulata' OR junior_species='pustulata')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='Strombosia' AND (species='pustulata' OR species='pustulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopyxis' AND (junior_species='klaineana' OR junior_species='klaineana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anopyxis' AND (species='klaineana' OR species='klaineana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anopyxis' AND (species='klaineana' OR species='klaineana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anopyxis' AND (junior_species='klaineana' OR junior_species='klaineana')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='Anopyxis' AND (species='klaineana' OR species='klaineana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapotaceae' 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='Sapotaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapotaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapotaceae' 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='Sapotaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Verbena' 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='Verbena' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Verbena' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Verbena' 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='Verbena' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='oblongifolia' OR junior_species='oblongifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rinorea' AND (species='oblongifolia' OR species='oblongifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rinorea' AND (species='oblongifolia' OR species='oblongifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='oblongifolia' OR junior_species='oblongifolia')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='Rinorea' AND (species='oblongifolia' OR species='oblongifolia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=220 The Ecological Register: Mount Cameroon (P3)
Mount Cameroon (P3)
Basic information
Sample name: Mount Cameroon (P3)

Reference: J. Proctor, I. D. Edwards, R. W. Payton, and L. Nagy. 2007. Zonation of forest vegetation and soils of Mount Cameroon, West Africa. Plant Ecology 192(2):251-269 [ER 88]
Geography
Country: Cameroon


Coordinate: 4° 13' N, 9° 10' E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Mount Cameroon

Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAP: 4500.0

Habitat comments: lowland rain forest

Methods
Life forms: trees

Sites: 1

Site area: 0.25

Site length: 50

Site width: 50

Sampling methods: quadrat

Sample size: 105 individuals

Years: 1989, 1991, 1995

Size min: 10

Basal area: 38.04

Metadata
Sample number: 220

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-22 12:40:16

Modified: 2017-10-12 03:14:02

Abundance distribution
29 species
15 singletons
total count 105
extrapolated richness: 83.9
Fisher's α: 13.249
geometric series k: 0.8836
Hurlbert's PIE: 0.8697
Shannon's H: 2.6674
Good's u: 0.8579
Each square represents a species. Square sizes are proportional to counts.
Register