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=44 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=44SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=10SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=44 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aidia' AND (junior_species='genipiflora' OR junior_species='genipiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aidia' AND (species='genipiflora' OR species='genipiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aidia' AND (species='genipiflora' OR species='genipiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aidia' AND (junior_species='genipiflora' OR junior_species='genipiflora')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='Aidia' AND (species='genipiflora' OR species='genipiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocleista' AND (junior_species='nobilis' OR junior_species='nobilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthocleista' AND (species='nobilis' OR species='nobilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthocleista' AND (species='nobilis' OR species='nobilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocleista' AND (junior_species='nobilis' OR junior_species='nobilis')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='Anthocleista' AND (species='nobilis' OR species='nobilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antiaris' 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='Antiaris' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antiaris' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antiaris' 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='Antiaris' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchholzia' AND (junior_species='coriacea' OR junior_species='coriacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buchholzia' AND (species='coriacea' OR species='coriacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buchholzia' AND (species='coriacea' OR species='coriacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buchholzia' AND (junior_species='coriacea' OR junior_species='coriacea')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='Buchholzia' AND (species='coriacea' OR species='coriacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' AND (junior_species='subcordaturn' OR junior_species='subcordaturn')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthium' AND (species='subcordaturn' OR species='subcordaturn') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthium' AND (species='subcordaturn' OR species='subcordaturn')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' AND (junior_species='subcordaturn' OR junior_species='subcordaturn')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='Canthium' AND (species='subcordaturn' OR species='subcordaturn') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Keayodendron' AND (junior_species='bridelioides' OR junior_species='bridelioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Keayodendron' AND (species='bridelioides' OR species='bridelioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Keayodendron' AND (species='bridelioides' OR species='bridelioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Keayodendron' AND (junior_species='bridelioides' OR junior_species='bridelioides')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='Keayodendron' AND (species='bridelioides' OR species='bridelioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceiba' AND (junior_species='pentandra' OR junior_species='pentandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceiba' AND (species='pentandra' OR species='pentandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceiba' AND (species='pentandra' OR species='pentandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceiba' AND (junior_species='pentandra' OR junior_species='pentandra')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='Ceiba' AND (species='pentandra' OR species='pentandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='soyauxii' OR junior_species='soyauxi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='soyauxii' OR species='soyauxi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='soyauxii' OR species='soyauxi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='soyauxii' OR junior_species='soyauxi')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='soyauxii' OR species='soyauxi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' 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='Celtis' AND (species='zenkeri' OR species='zenkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='zenkeri' OR species='zenkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' 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='Celtis' AND (species='zenkeri' OR species='zenkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleistopholis' 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='Cleistopholis' AND (species='patens' OR species='patens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cleistopholis' AND (species='patens' OR species='patens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cleistopholis' 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='Cleistopholis' AND (species='patens' OR species='patens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='cordifolia' OR junior_species='cordifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cola' AND (species='cordifolia' OR species='cordifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cola' AND (species='cordifolia' OR species='cordifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='cordifolia' OR junior_species='cordifolia')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='cordifolia' OR species='cordifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='platythyrsa' OR junior_species='platythyrsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='platythyrsa' OR species='platythyrsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='platythyrsa' OR species='platythyrsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='platythyrsa' OR junior_species='platythyrsa')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='Cordia' AND (species='platythyrsa' OR species='platythyrsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' 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='Cordia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' 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='Cordia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='alboflavescens' OR junior_species='alboflavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='alboflavescens' OR species='alboflavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='alboflavescens' OR species='alboflavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='alboflavescens' OR junior_species='alboflavescens')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='alboflavescens' OR species='alboflavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='dendo' OR junior_species='dendo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='dendo' OR species='dendo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='dendo' OR species='dendo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='dendo' OR junior_species='dendo')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='dendo' OR species='dendo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='piscatoria' OR junior_species='piscatoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='piscatoria' OR species='piscatoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='piscatoria' OR species='piscatoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='piscatoria' OR junior_species='piscatoria')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='piscatoria' OR species='piscatoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='suaveolens' OR junior_species='suaveolens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='suaveolens' OR species='suaveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='suaveolens' OR species='suaveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='suaveolens' OR junior_species='suaveolens')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='suaveolens' OR species='suaveolens') 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='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='Annickia' AND (junior_species='chlorantha' OR junior_species='chlorantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Annickia' AND (species='chlorantha' OR species='chlorantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Annickia' AND (species='chlorantha' OR species='chlorantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Annickia' AND (junior_species='chlorantha' OR junior_species='chlorantha')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='Annickia' AND (species='chlorantha' OR species='chlorantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='cylindricum' OR junior_species='cylindricum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Entandrophragma' AND (species='cylindricum' OR species='cylindricum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entandrophragma' AND (species='cylindricum' OR species='cylindricum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='cylindricum' OR junior_species='cylindricum')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='cylindricum' OR species='cylindricum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrophleum' AND (junior_species='suaveolens' OR junior_species='suaveolens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrophleum' AND (species='suaveolens' OR species='suaveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrophleum' AND (species='suaveolens' OR species='suaveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrophleum' AND (junior_species='suaveolens' OR junior_species='suaveolens')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='Erythrophleum' AND (species='suaveolens' OR species='suaveolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='macrophylla' OR junior_species='macrophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagara' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagara' AND (species='macrophylla' OR species='macrophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='macrophylla' OR junior_species='macrophylla')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='Fagara' AND (species='macrophylla' OR species='macrophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' 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='Ficus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' 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='Ficus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Funtumia' AND (junior_species='elastica' OR junior_species='elastica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Funtumia' AND (species='elastica' OR species='elastica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Funtumia' AND (species='elastica' OR species='elastica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Funtumia' AND (junior_species='elastica' OR junior_species='elastica')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='Funtumia' AND (species='elastica' OR species='elastica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grewia' 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='Grewia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grewia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grewia' 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='Grewia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isolona' AND (junior_species='leonensis' OR junior_species='leonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Isolona' AND (species='leonensis' OR species='leonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Isolona' AND (species='leonensis' OR species='leonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isolona' AND (junior_species='leonensis' OR junior_species='leonensis')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='Isolona' AND (species='leonensis' OR species='leonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Khaya' AND (junior_species='ivorensis' OR junior_species='ivorensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Khaya' AND (species='ivorensis' OR species='ivorensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Khaya' AND (species='ivorensis' OR species='ivorensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Khaya' AND (junior_species='ivorensis' OR junior_species='ivorensis')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='Khaya' AND (species='ivorensis' OR species='ivorensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kigelia' 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='Kigelia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kigelia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kigelia' 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='Kigelia' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lovoa' AND (junior_species='trichilioides' OR junior_species='trichilioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lovoa' AND (species='trichilioides' OR species='trichilioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lovoa' AND (species='trichilioides' OR species='trichilioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lovoa' AND (junior_species='trichilioides' OR junior_species='trichilioides')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='Lovoa' AND (species='trichilioides' OR species='trichilioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='barteri' OR junior_species='barterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='barteri' OR species='barterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='barteri' OR species='barterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='barteri' OR junior_species='barterii')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='barteri' OR species='barterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maprounea' AND (junior_species='membranacea' OR junior_species='membranacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maprounea' AND (species='membranacea' OR species='membranacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maprounea' AND (species='membranacea' OR species='membranacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maprounea' AND (junior_species='membranacea' OR junior_species='membranacea')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='Maprounea' AND (species='membranacea' OR species='membranacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='polyanthemos' OR junior_species='polyanthemos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Memecylon' AND (species='polyanthemos' OR species='polyanthemos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memecylon' AND (species='polyanthemos' OR species='polyanthemos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' AND (junior_species='polyanthemos' OR junior_species='polyanthemos')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='Memecylon' AND (species='polyanthemos' OR species='polyanthemos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Musanga' AND (junior_species='cecropioides' OR junior_species='cecropioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Musanga' AND (species='cecropioides' OR species='cecropioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Musanga' AND (species='cecropioides' OR species='cecropioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Musanga' AND (junior_species='cecropioides' OR junior_species='cecropioides')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='Musanga' AND (species='cecropioides' OR species='cecropioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nauclea' AND (junior_species='diderrichii' OR junior_species='diderrichi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nauclea' AND (species='diderrichii' OR species='diderrichi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nauclea' AND (species='diderrichii' OR species='diderrichi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nauclea' AND (junior_species='diderrichii' OR junior_species='diderrichi')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='Nauclea' AND (species='diderrichii' OR species='diderrichi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octolobus' AND (junior_species='angustatus' OR junior_species='angustatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Octolobus' AND (species='angustatus' OR species='angustatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Octolobus' AND (species='angustatus' OR species='angustatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Octolobus' AND (junior_species='angustatus' OR junior_species='angustatus')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='Octolobus' AND (species='angustatus' OR species='angustatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corynanthe' AND (junior_species='johimbe' OR junior_species='johimbe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corynanthe' AND (species='johimbe' OR species='johimbe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corynanthe' AND (species='johimbe' OR species='johimbe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corynanthe' AND (junior_species='johimbe' OR junior_species='johimbe')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='Corynanthe' AND (species='johimbe' OR species='johimbe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margaritaria' AND (junior_species='discoidea' OR junior_species='discoidea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Margaritaria' AND (species='discoidea' OR species='discoidea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Margaritaria' AND (species='discoidea' OR species='discoidea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margaritaria' AND (junior_species='discoidea' OR junior_species='discoidea')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='Margaritaria' AND (species='discoidea' OR species='discoidea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picralima' AND (junior_species='nitida' OR junior_species='nitida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picralima' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picralima' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picralima' AND (junior_species='nitida' OR junior_species='nitida')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='Picralima' AND (species='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piptadeniastrum' AND (junior_species='africanum' OR junior_species='africanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piptadeniastrum' AND (species='africanum' OR species='africanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piptadeniastrum' AND (species='africanum' OR species='africanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piptadeniastrum' AND (junior_species='africanum' OR junior_species='africanum')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='Piptadeniastrum' AND (species='africanum' OR species='africanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnanthus' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnanthus' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnanthus' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnanthus' AND (junior_species='angolensis' OR junior_species='angolensis')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='Pycnanthus' AND (species='angolensis' OR species='angolensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='welwitschii' OR junior_species='welwitschi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rinorea' AND (species='welwitschii' OR species='welwitschi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rinorea' AND (species='welwitschii' OR species='welwitschi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rinorea' AND (junior_species='welwitschii' OR junior_species='welwitschi')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='welwitschii' OR species='welwitschi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rothmannia' AND (junior_species='whitfieldii' OR junior_species='whitfieldi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rothmannia' AND (species='whitfieldii' OR species='whitfieldi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rothmannia' AND (species='whitfieldii' OR species='whitfieldi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rothmannia' AND (junior_species='whitfieldii' OR junior_species='whitfieldi')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='Rothmannia' AND (species='whitfieldii' OR species='whitfieldi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scottellia' AND (junior_species='coriacea' OR junior_species='coriacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scottellia' AND (species='coriacea' OR species='coriacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scottellia' AND (species='coriacea' OR species='coriacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scottellia' AND (junior_species='coriacea' OR junior_species='coriacea')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='Scottellia' AND (species='coriacea' OR species='coriacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staudtia' AND (junior_species='kamerunensis' OR junior_species='kamerunensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Staudtia' AND (species='kamerunensis' OR species='kamerunensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Staudtia' AND (species='kamerunensis' OR species='kamerunensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Staudtia' AND (junior_species='kamerunensis' OR junior_species='kamerunensis')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='Staudtia' AND (species='kamerunensis' OR species='kamerunensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='rhinopetala' OR junior_species='rhinopetala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='rhinopetala' OR species='rhinopetala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='rhinopetala' OR species='rhinopetala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='rhinopetala' OR junior_species='rhinopetala')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='rhinopetala' OR species='rhinopetala') 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='Tabernaemontana' AND (junior_species='pachysiphon' OR junior_species='pachysiphon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabernaemontana' AND (species='pachysiphon' OR species='pachysiphon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabernaemontana' AND (species='pachysiphon' OR species='pachysiphon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabernaemontana' AND (junior_species='pachysiphon' OR junior_species='pachysiphon')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='pachysiphon' OR species='pachysiphon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='superba' OR junior_species='superba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='superba' OR species='superba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='superba' OR species='superba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='superba' OR junior_species='superba')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='Terminalia' AND (species='superba' OR species='superba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrorchidium' AND (junior_species='didymostemon' OR junior_species='didymostemon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrorchidium' AND (species='didymostemon' OR species='didymostemon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrorchidium' AND (species='didymostemon' OR species='didymostemon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrorchidium' AND (junior_species='didymostemon' OR junior_species='didymostemon')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='Tetrorchidium' AND (species='didymostemon' OR species='didymostemon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' 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='Trichilia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' 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='Trichilia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=44 The Ecological Register: Omo Forest Reserve Plot A
Omo Forest Reserve Plot A
Basic information
Sample name: Omo Forest Reserve Plot A

Reference: D. U. U. Okali and B. A. Ola-Adams. 1987. Tree population changes in treated rain forest at Omo Forest Reserve, south-western Nigeria. Journal of Tropical Ecology 3(4):291-313 [ER 10]
Geography
Country: Nigeria


Coordinate: 6° 50' 0" N, 4° 29' 30" E
Coordinate basis: stated in text

Geography comments: shown as a few km NNW of Akilla on map

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: forest reserve

Substrate: ground surface

Disturbance: selective logging

MAT: 25.8

MAP: 1577.0

Dry months: 3

Habitat comments: "mixed moist semi-evergreen rain forest" that was selectively logged in 1952
precip < 40 mm/mo in December, January, and February (warm months)

Methods
Life forms: trees

Sites: 3

Site area: 0.75

Sampling methods: quadrat

Sample size: 2282 individuals

Years: 1952

Size min: 10

Basal area: 25.9

Sampling comments: three 50 x 50 m quadrats
1981 data only (see p. 312)

Metadata
Sample number: 44

Contributor: John Alroy

Enterer: John Alroy

Created: 2013-01-25 17:00:11

Modified: 2014-07-17 05:31:43

Abundance distribution
51 species
11 singletons
total count 2282
extrapolated richness: 77.8
Fisher's α: 9.253
geometric series k: 0.8768
Hurlbert's PIE: 0.8483
Shannon's H: 2.4604
Good's u: 0.9952
Each square represents a species. Square sizes are proportional to counts.
Register