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=221 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=221SELECT 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=221 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='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='Garcinia' AND (junior_species='kola' OR junior_species='kola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='kola' OR species='kola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='kola' OR species='kola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='kola' OR junior_species='kola')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='kola' OR species='kola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='mannii' OR junior_species='manni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garcinia' AND (species='mannii' OR species='manni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garcinia' AND (species='mannii' OR species='manni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garcinia' AND (junior_species='mannii' OR junior_species='manni')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='mannii' OR species='manni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='grandifolia' OR junior_species='grandifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='grandifolia' OR species='grandifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='grandifolia' OR species='grandifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='grandifolia' OR junior_species='grandifolia')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='grandifolia' OR species='grandifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='simulans' OR junior_species='simulans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='simulans' OR species='simulans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='simulans' OR species='simulans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='simulans' OR junior_species='simulans')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='simulans' OR species='simulans') 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='Diospyros' 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='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' 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='Diospyros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discoglypremna' AND (junior_species='caloneura' OR junior_species='caloneura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discoglypremna' AND (species='caloneura' OR species='caloneura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discoglypremna' AND (species='caloneura' OR species='caloneura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discoglypremna' AND (junior_species='caloneura' OR junior_species='caloneura')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='Discoglypremna' AND (species='caloneura' OR species='caloneura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='paxii' OR junior_species='paxi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drypetes' AND (species='paxii' OR species='paxi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='paxii' OR species='paxi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='paxii' OR junior_species='paxi')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='paxii' OR species='paxi') 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='Mareyopsis' 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='Mareyopsis' AND (species='longifolia' OR species='longifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mareyopsis' AND (species='longifolia' OR species='longifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mareyopsis' 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='Mareyopsis' AND (species='longifolia' OR species='longifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalium' AND (junior_species='stipulaceum' OR junior_species='stipulaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homalium' AND (species='stipulaceum' OR species='stipulaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homalium' AND (species='stipulaceum' OR species='stipulaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homalium' AND (junior_species='stipulaceum' OR junior_species='stipulaceum')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='Homalium' AND (species='stipulaceum' OR species='stipulaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oncoba' AND (junior_species='mannii' OR junior_species='manni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oncoba' AND (species='mannii' OR species='manni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oncoba' AND (species='mannii' OR species='manni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oncoba' AND (junior_species='mannii' OR junior_species='manni')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='Oncoba' AND (species='mannii' OR species='manni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flacourtiaceae' 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='Flacourtiaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Flacourtiaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Flacourtiaceae' 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='Flacourtiaceae' AND (species='indet.' OR species='indet.') 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='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='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='Entandrophragma' AND (junior_species='angolense' OR junior_species='angolense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Entandrophragma' AND (species='angolense' OR species='angolense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entandrophragma' AND (species='angolense' OR species='angolense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='angolense' OR junior_species='angolense')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='Entandrophragma' AND (species='angolense' OR species='angolense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='gilgiana' OR junior_species='gilgiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='gilgiana' OR species='gilgiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='gilgiana' OR species='gilgiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='gilgiana' OR junior_species='gilgiana')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='Trichilia' AND (species='gilgiana' OR species='gilgiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bersama' AND (junior_species='abyssinica' OR junior_species='abyssinica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bersama' AND (species='abyssinica' OR species='abyssinica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bersama' AND (species='abyssinica' OR species='abyssinica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bersama' AND (junior_species='abyssinica' OR junior_species='abyssinica')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='Bersama' AND (species='abyssinica' OR species='abyssinica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilepisium' AND (junior_species='madagascariense' OR junior_species='madagascariense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trilepisium' AND (species='madagascariense' OR species='madagascariense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trilepisium' AND (species='madagascariense' OR species='madagascariense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilepisium' AND (junior_species='madagascariense' OR junior_species='madagascariense')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='Trilepisium' AND (species='madagascariense' OR species='madagascariense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardisia' 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='Ardisia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ardisia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ardisia' 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='Ardisia' 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='grandifolia' OR junior_species='grandifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strombosia' AND (species='grandifolia' OR species='grandifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strombosia' AND (species='grandifolia' OR species='grandifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='grandifolia' OR junior_species='grandifolia')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='grandifolia' OR species='grandifolia') 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='Aulacocalyx' AND (junior_species='caudata' OR junior_species='caudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aulacocalyx' AND (species='caudata' OR species='caudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aulacocalyx' AND (species='caudata' OR species='caudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulacocalyx' AND (junior_species='caudata' OR junior_species='caudata')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='Aulacocalyx' AND (species='caudata' OR species='caudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericanthe' 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='Sericanthe' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericanthe' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericanthe' 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='Sericanthe' AND (species='sp.' OR species='sp.') 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='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='Chrysophyllum' AND (junior_species='delevoyi' OR junior_species='delevoyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='delevoyi' OR species='delevoyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='delevoyi' OR species='delevoyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='delevoyi' OR junior_species='delevoyii')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='Chrysophyllum' AND (species='delevoyi' OR species='delevoyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' 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='Chrysophyllum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' 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='Chrysophyllum' AND (species='sp.' OR species='sp.') 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='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='Rhaptopetalum' 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='Rhaptopetalum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhaptopetalum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhaptopetalum' 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='Rhaptopetalum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='verticillata' OR junior_species='verticillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cola' AND (species='verticillata' OR species='verticillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cola' AND (species='verticillata' OR species='verticillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='verticillata' OR junior_species='verticillata')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='Cola' AND (species='verticillata' OR species='verticillata') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Family' 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='Family' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Family' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Family' 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='Family' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=221 The Ecological Register: Mount Cameroon (P4)
Mount Cameroon (P4)
Basic information
Sample name: Mount Cameroon (P4)

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: 117 individuals

Years: 1989, 1991, 1995

Size min: 10

Basal area: 25.4

Metadata
Sample number: 221

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-22 12:46:58

Modified: 2017-10-12 03:13:55

Abundance distribution
43 species
26 singletons
total count 117
extrapolated richness: 149.3
Fisher's α: 24.539
geometric series k: 0.9348
Hurlbert's PIE: 0.9398
Shannon's H: 3.2655
Good's u: 0.7781
Each square represents a species. Square sizes are proportional to counts.
Register