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=46 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=46SELECT 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=46 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='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='Baphia' 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='Baphia' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baphia' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baphia' 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='Baphia' AND (species='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barteria' AND (junior_species='fistulosa' OR junior_species='fistulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Barteria' AND (species='fistulosa' OR species='fistulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Barteria' AND (species='fistulosa' OR species='fistulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Barteria' AND (junior_species='fistulosa' OR junior_species='fistulosa')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='Barteria' AND (species='fistulosa' OR species='fistulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombax' AND (junior_species='buonopozense' OR junior_species='buonopozense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombax' AND (species='buonopozense' OR species='buonopozense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombax' AND (species='buonopozense' OR species='buonopozense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombax' AND (junior_species='buonopozense' OR junior_species='buonopozense')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='Bombax' AND (species='buonopozense' OR species='buonopozense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachystegia' AND (junior_species='eurycoma' OR junior_species='eurycoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachystegia' AND (species='eurycoma' OR species='eurycoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachystegia' AND (species='eurycoma' OR species='eurycoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachystegia' AND (junior_species='eurycoma' OR junior_species='eurycoma')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='Brachystegia' AND (species='eurycoma' OR species='eurycoma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bridelia' AND (junior_species='micrantha' OR junior_species='micrantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bridelia' AND (species='micrantha' OR species='micrantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bridelia' AND (species='micrantha' OR species='micrantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bridelia' AND (junior_species='micrantha' OR junior_species='micrantha')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='Bridelia' AND (species='micrantha' OR species='micrantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' AND (junior_species='glabriflorum' OR junior_species='glabriflorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthium' AND (species='glabriflorum' OR species='glabriflorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthium' AND (species='glabriflorum' OR species='glabriflorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' AND (junior_species='glabriflorum' OR junior_species='glabriflorum')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='glabriflorum' OR species='glabriflorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' AND (junior_species='vulgare' OR junior_species='vulgare')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canthium' AND (species='vulgare' OR species='vulgare') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthium' AND (species='vulgare' OR species='vulgare')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' AND (junior_species='vulgare' OR junior_species='vulgare')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='vulgare' OR species='vulgare') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='brownii' OR junior_species='browni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='brownii' OR species='browni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='brownii' OR species='browni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='brownii' OR junior_species='browni')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='brownii' OR species='browni') 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='acuminata' OR junior_species='acuminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cola' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cola' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='acuminata' OR junior_species='acuminata')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='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='millenii' OR junior_species='milleni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='millenii' OR species='milleni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='millenii' OR species='milleni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='millenii' OR junior_species='milleni')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='millenii' OR species='milleni') 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='Corynanthe' AND (junior_species='pachyceras' OR junior_species='pachyceras')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corynanthe' AND (species='pachyceras' OR species='pachyceras') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corynanthe' AND (species='pachyceras' OR species='pachyceras')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corynanthe' AND (junior_species='pachyceras' OR junior_species='pachyceras')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='pachyceras' OR species='pachyceras') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='guineense' OR junior_species='guineense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dialium' AND (species='guineense' OR species='guineense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialium' AND (species='guineense' OR species='guineense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' AND (junior_species='guineense' OR junior_species='guineense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dialium' AND (species='guineense' OR species='guineense') 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='crassiflora' OR junior_species='crassiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='crassiflora' OR species='crassiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='crassiflora' OR species='crassiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='crassiflora' OR junior_species='crassiflora')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='crassiflora' OR species='crassiflora') 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='Diospyros' AND (junior_species='undabunda' OR junior_species='undabunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='undabunda' OR species='undabunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='undabunda' OR species='undabunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='undabunda' OR junior_species='undabunda')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='undabunda' OR species='undabunda') 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='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='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='Entandrophragma' AND (junior_species='candollei' OR junior_species='candolleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Entandrophragma' AND (species='candollei' OR species='candolleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entandrophragma' AND (species='candollei' OR species='candolleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='candollei' OR junior_species='candolleii')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='candollei' OR species='candolleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrina' AND (junior_species='altissima' OR junior_species='altissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrina' AND (species='altissima' OR species='altissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrina' AND (species='altissima' OR species='altissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrina' AND (junior_species='altissima' OR junior_species='altissima')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='Erythrina' AND (species='altissima' OR species='altissima') 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='zanthoxyloides' OR junior_species='zanthoxyloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagara' AND (species='zanthoxyloides' OR species='zanthoxyloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagara' AND (species='zanthoxyloides' OR species='zanthoxyloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='zanthoxyloides' OR junior_species='zanthoxyloides')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='zanthoxyloides' OR species='zanthoxyloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='exasperata' OR junior_species='exasperata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='exasperata' OR species='exasperata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='exasperata' OR species='exasperata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='exasperata' OR junior_species='exasperata')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='exasperata' OR species='exasperata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Funtumia' 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='Funtumia' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Funtumia' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Funtumia' 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='Funtumia' AND (species='africana' OR species='africana') 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='Microcos' 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='Microcos' AND (species='coriacea' OR species='coriacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microcos' AND (species='coriacea' OR species='coriacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microcos' 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='Microcos' AND (species='coriacea' OR species='coriacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grewia' 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='Grewia' AND (species='welwitschii' OR species='welwitschi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grewia' AND (species='welwitschii' OR species='welwitschi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grewia' 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='Grewia' AND (species='welwitschii' OR species='welwitschi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hexalobus' 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='Hexalobus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hexalobus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hexalobus' 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='Hexalobus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holoptelea' AND (junior_species='grandis' OR junior_species='grandis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Holoptelea' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Holoptelea' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Holoptelea' AND (junior_species='grandis' OR junior_species='grandis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Holoptelea' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hunteria' AND (junior_species='umbellata' OR junior_species='umbellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hunteria' AND (species='umbellata' OR species='umbellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hunteria' AND (species='umbellata' OR species='umbellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hunteria' AND (junior_species='umbellata' OR junior_species='umbellata')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='Hunteria' AND (species='umbellata' OR species='umbellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylodendron' AND (junior_species='gabunense' OR junior_species='gabunense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylodendron' AND (species='gabunense' OR species='gabunense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylodendron' AND (species='gabunense' OR species='gabunense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylodendron' AND (junior_species='gabunense' OR junior_species='gabunense')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='Hylodendron' AND (species='gabunense' OR species='gabunense') 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='Maesopsis' AND (junior_species='eminii' OR junior_species='emini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maesopsis' AND (species='eminii' OR species='emini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maesopsis' AND (species='eminii' OR species='emini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maesopsis' AND (junior_species='eminii' OR junior_species='emini')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='Maesopsis' AND (species='eminii' OR species='emini') 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='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='Porterandia' AND (junior_species='cladantha' OR junior_species='cladantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Porterandia' AND (species='cladantha' OR species='cladantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Porterandia' AND (species='cladantha' OR species='cladantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porterandia' AND (junior_species='cladantha' OR junior_species='cladantha')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='Porterandia' AND (species='cladantha' OR species='cladantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' 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='Pterocarpus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterocarpus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' 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='Pterocarpus' AND (species='sp.' OR species='sp.') 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='Rauvolfia' AND (junior_species='vomitoria' OR junior_species='vomitoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rauvolfia' AND (species='vomitoria' OR species='vomitoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rauvolfia' AND (species='vomitoria' OR species='vomitoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rauvolfia' AND (junior_species='vomitoria' OR junior_species='vomitoria')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='Rauvolfia' AND (species='vomitoria' OR species='vomitoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ricinodendron' AND (junior_species='heudelotii' OR junior_species='heudeloti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ricinodendron' AND (species='heudelotii' OR species='heudeloti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ricinodendron' AND (species='heudelotii' OR species='heudeloti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ricinodendron' AND (junior_species='heudelotii' OR junior_species='heudeloti')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='Ricinodendron' AND (species='heudelotii' OR species='heudeloti') 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='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='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='Terminalia' AND (species='ivorensis' OR species='ivorensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='ivorensis' OR species='ivorensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' 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='Terminalia' AND (species='ivorensis' OR species='ivorensis') 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='Trichilia' AND (junior_species='mildbraedii' OR junior_species='mildbraedi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='mildbraedii' OR species='mildbraedi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='mildbraedii' OR species='mildbraedi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='mildbraedii' OR junior_species='mildbraedi')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='mildbraedii' OR species='mildbraedi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='quintasii' OR junior_species='quintasi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopia' AND (species='quintasii' OR species='quintasi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopia' AND (species='quintasii' OR species='quintasi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='quintasii' OR junior_species='quintasi')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='Xylopia' AND (species='quintasii' OR species='quintasi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tree' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tree' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tree' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tree' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tree' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=46 The Ecological Register: Omo Forest Reserve Control Plot
Omo Forest Reserve Control Plot
Basic information
Sample name: Omo Forest Reserve Control Plot

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

MAT: 25.8

MAP: 1577.0

Dry months: 3

Habitat comments: "mixed moist semi-evergreen rain forest"
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: 421 individuals

Years: 1981

Size min: 10

Basal area: 29.6

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

Metadata
Sample number: 46

Contributor: John Alroy

Enterer: John Alroy

Created: 2013-01-25 17:07:42

Modified: 2014-07-17 05:30:11

Abundance distribution
60 species
22 singletons
total count 421
extrapolated richness: 133.0
Fisher's α: 19.135
geometric series k: 0.9327
Hurlbert's PIE: 0.9281
Shannon's H: 3.1500
Good's u: 0.9479
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Aidia genipiflora3
Antiaris africana1
Baphia nitida1
Barteria fistulosa1
Bombax buonopozense1
Brachystegia eurycoma1
Bridelia micrantha1
Canthium glabriflorum2
Canthium vulgare1
Celtis brownii2
Celtis zenkeri15
Cleistopholis patens6
Cola acuminata1
Cordia millenii3
Cordia platythyrsa1
Corynanthe pachyceras2
Dialium guineense10
Diospyros alboflavescens53
Diospyros crassiflora2
Diospyros dendo61
Diospyros piscatoria21
Diospyros suaveolens17
Diospyros undabunda2
Discoglypremna caloneura5
Annickia chlorantha3
"Enantia chlorantha"
Entandrophragma angolense1
Entandrophragma candollei1
Erythrina altissima3
Erythrophleum suaveolens1
"Erythrophleum guineense"
Fagara zanthoxyloides2
Ficus exasperata1
Funtumia africana1
Funtumia elastica13
Microcos coriacea2
"Grewia coriacea"
Grewia welwitschii1
Hexalobus sp.2
Holoptelea grandis2
Hunteria umbellata2
Hylodendron gabunense4
"Hylodendron gabonensis"
Macaranga barteri4
Maesopsis eminii1
Musanga cecropioides33
Nauclea diderrichii3
Octolobus angustatus23
Corynanthe johimbe johimbe4
"Pausinystalia johimbe"
Picralima nitida20
Porterandia cladantha1
Pterocarpus sp.1
Pycnanthus angolensis3
Rauvolfia vomitoria2
Ricinodendron heudelotii2
Scottellia coriacea3
Sterculia rhinopetala3
Strombosia pustulata51
Tabernaemontana pachysiphon9
Terminalia ivorensis1
Terminalia superba1
Trichilia mildbraedii1
Xylopia quintasii1
"Xylopia quintassii"
Tree indet.2