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=79 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=79SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=44SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=79 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudospondias' AND (junior_species='microcarpa' OR junior_species='microcarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudospondias' AND (species='microcarpa' OR species='microcarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudospondias' AND (species='microcarpa' OR species='microcarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudospondias' AND (junior_species='microcarpa' OR junior_species='microcarpa')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='Pseudospondias' AND (species='microcarpa' OR species='microcarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorindeia' AND (junior_species='juglandifolia' OR junior_species='juglandifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorindeia' AND (species='juglandifolia' OR species='juglandifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorindeia' AND (species='juglandifolia' OR species='juglandifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorindeia' AND (junior_species='juglandifolia' OR junior_species='juglandifolia')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='Sorindeia' AND (species='juglandifolia' OR species='juglandifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoscypha' 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='Trichoscypha' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichoscypha' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoscypha' 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='Trichoscypha' AND (species='acuminata' OR species='acuminata') 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='Greenwayodendron' 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='Greenwayodendron' AND (species='suaveolens' OR species='suaveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Greenwayodendron' AND (species='suaveolens' OR species='suaveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Greenwayodendron' 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='Greenwayodendron' AND (species='suaveolens' OR species='suaveolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uvariastrum' AND (junior_species='pierreanum' OR junior_species='pierreanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uvariastrum' AND (species='pierreanum' OR species='pierreanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uvariastrum' AND (species='pierreanum' OR species='pierreanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uvariastrum' AND (junior_species='pierreanum' OR junior_species='pierreanum')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='Uvariastrum' AND (species='pierreanum' OR species='pierreanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='aethiopica' OR junior_species='aethiopica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopia' AND (species='aethiopica' OR species='aethiopica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopia' AND (species='aethiopica' OR species='aethiopica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='aethiopica' OR junior_species='aethiopica')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='aethiopica' OR species='aethiopica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='hypolampra' OR junior_species='hypolampra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopia' AND (species='hypolampra' OR species='hypolampra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopia' AND (species='hypolampra' OR species='hypolampra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='hypolampra' OR junior_species='hypolampra')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='hypolampra' OR species='hypolampra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='phloiodora' OR junior_species='phloiodora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopia' AND (species='phloiodora' OR species='phloiodora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopia' AND (species='phloiodora' OR species='phloiodora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopia' AND (junior_species='phloiodora' OR junior_species='phloiodora')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='phloiodora' OR species='phloiodora') 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='Newbouldia' AND (junior_species='laevis' OR junior_species='laevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Newbouldia' AND (species='laevis' OR species='laevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Newbouldia' AND (species='laevis' OR species='laevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Newbouldia' AND (junior_species='laevis' OR junior_species='laevis')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='Newbouldia' AND (species='laevis' OR species='laevis') 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='Aucoumea' AND (junior_species='klaineana' OR junior_species='klaineana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aucoumea' AND (species='klaineana' OR species='klaineana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aucoumea' AND (species='klaineana' OR species='klaineana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aucoumea' AND (junior_species='klaineana' OR junior_species='klaineana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aucoumea' AND (species='klaineana' OR species='klaineana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='schweinfurthii' OR junior_species='schweinfurthi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canarium' AND (species='schweinfurthii' OR species='schweinfurthi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canarium' AND (species='schweinfurthii' OR species='schweinfurthi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canarium' AND (junior_species='schweinfurthii' OR junior_species='schweinfurthi')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='Canarium' AND (species='schweinfurthii' OR species='schweinfurthi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='buettneri' OR junior_species='buettnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacryodes' AND (species='buettneri' OR species='buettnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacryodes' AND (species='buettneri' OR species='buettnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='buettneri' OR junior_species='buettnerii')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='Dacryodes' AND (species='buettneri' OR species='buettnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='normandii' OR junior_species='normandi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacryodes' AND (species='normandii' OR species='normandi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacryodes' AND (species='normandii' OR species='normandi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacryodes' AND (junior_species='normandii' OR junior_species='normandi')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='Dacryodes' AND (species='normandii' OR species='normandi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthonotha' 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='Anthonotha' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthonotha' AND (species='macrophylla' OR species='macrophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthonotha' 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='Anthonotha' AND (species='macrophylla' OR species='macrophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Berlinia' AND (junior_species='bracteosa' OR junior_species='bracteosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Berlinia' AND (species='bracteosa' OR species='bracteosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Berlinia' AND (species='bracteosa' OR species='bracteosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Berlinia' AND (junior_species='bracteosa' OR junior_species='bracteosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Berlinia' AND (species='bracteosa' OR species='bracteosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Detarium' AND (junior_species='macrocarpum' OR junior_species='macrocarpum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Detarium' AND (species='macrocarpum' OR species='macrocarpum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Detarium' AND (species='macrocarpum' OR species='macrocarpum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Detarium' AND (junior_species='macrocarpum' OR junior_species='macrocarpum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Detarium' AND (species='macrocarpum' OR species='macrocarpum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' 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='Dialium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dialium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dialium' 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='Dialium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Distemonanthus' AND (junior_species='benthamianus' OR junior_species='benthamianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Distemonanthus' AND (species='benthamianus' OR species='benthamianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Distemonanthus' AND (species='benthamianus' OR species='benthamianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Distemonanthus' AND (junior_species='benthamianus' OR junior_species='benthamianus')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='Distemonanthus' AND (species='benthamianus' OR species='benthamianus') 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='Julbernardia' AND (junior_species='brieyi' OR junior_species='brieyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Julbernardia' AND (species='brieyi' OR species='brieyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Julbernardia' AND (species='brieyi' OR species='brieyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Julbernardia' AND (junior_species='brieyi' OR junior_species='brieyii')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='Julbernardia' AND (species='brieyi' OR species='brieyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='fistuloides' OR junior_species='fistuloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Swartzia' AND (species='fistuloides' OR species='fistuloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Swartzia' AND (species='fistuloides' OR species='fistuloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Swartzia' AND (junior_species='fistuloides' OR junior_species='fistuloides')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='Swartzia' AND (species='fistuloides' OR species='fistuloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='congolensis' OR junior_species='congolensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euonymus' AND (species='congolensis' OR species='congolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euonymus' AND (species='congolensis' OR species='congolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euonymus' AND (junior_species='congolensis' OR junior_species='congolensis')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='Euonymus' AND (species='congolensis' OR species='congolensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maranthes' AND (junior_species='gabunensis' OR junior_species='gabunensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maranthes' AND (species='gabunensis' OR species='gabunensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maranthes' AND (species='gabunensis' OR species='gabunensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maranthes' AND (junior_species='gabunensis' OR junior_species='gabunensis')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='Maranthes' AND (species='gabunensis' OR species='gabunensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichapetalum' 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='Dichapetalum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichapetalum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichapetalum' 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='Dichapetalum' 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='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='mannii' OR junior_species='manni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='mannii' OR species='manni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='mannii' OR species='manni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='mannii' OR junior_species='manni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diospyros' AND (species='mannii' OR species='manni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='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='polystemon' OR junior_species='polystemon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='polystemon' OR species='polystemon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='polystemon' OR species='polystemon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='polystemon' OR junior_species='polystemon')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='polystemon' OR species='polystemon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='viridicans' OR junior_species='viridicans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diospyros' AND (species='viridicans' OR species='viridicans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diospyros' AND (species='viridicans' OR species='viridicans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diospyros' AND (junior_species='viridicans' OR junior_species='viridicans')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='viridicans' OR species='viridicans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='mannii' OR junior_species='manni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythroxylum' AND (species='mannii' OR species='manni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythroxylum' AND (species='mannii' OR species='manni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='mannii' OR junior_species='manni')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythroxylum' AND (species='mannii' OR species='manni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='laciniatum' OR junior_species='laciniatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antidesma' AND (species='laciniatum' OR species='laciniatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antidesma' AND (species='laciniatum' OR species='laciniatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidesma' AND (junior_species='laciniatum' OR junior_species='laciniatum')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='Antidesma' AND (species='laciniatum' OR species='laciniatum') 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='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='Plagiostyles' 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='Plagiostyles' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plagiostyles' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagiostyles' 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='Plagiostyles' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='ellipticum' OR junior_species='ellipticum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapium' AND (species='ellipticum' OR species='ellipticum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapium' AND (species='ellipticum' OR species='ellipticum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapium' AND (junior_species='ellipticum' OR junior_species='ellipticum')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='Sapium' AND (species='ellipticum' OR species='ellipticum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uapaca' 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='Uapaca' AND (species='heudelotii' OR species='heudeloti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uapaca' AND (species='heudelotii' OR species='heudeloti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uapaca' 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='Uapaca' AND (species='heudelotii' OR species='heudeloti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' 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='Casearia' AND (species='barteri' OR species='barterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='barteri' OR species='barterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' 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='Casearia' AND (species='barteri' OR species='barterii') 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='Pentadesma' AND (junior_species='butyracea' OR junior_species='butyracea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pentadesma' AND (species='butyracea' OR species='butyracea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pentadesma' AND (species='butyracea' OR species='butyracea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentadesma' AND (junior_species='butyracea' OR junior_species='butyracea')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='Pentadesma' AND (species='butyracea' OR species='butyracea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorospermum' AND (junior_species='tenuifolium' OR junior_species='tenuifolium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psorospermum' AND (species='tenuifolium' OR species='tenuifolium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psorospermum' AND (species='tenuifolium' OR species='tenuifolium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psorospermum' AND (junior_species='tenuifolium' OR junior_species='tenuifolium')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='Psorospermum' AND (species='tenuifolium' OR species='tenuifolium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desbordesia' AND (junior_species='glaucescens' OR junior_species='glaucescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desbordesia' AND (species='glaucescens' OR species='glaucescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Desbordesia' AND (species='glaucescens' OR species='glaucescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desbordesia' AND (junior_species='glaucescens' OR junior_species='glaucescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Desbordesia' AND (species='glaucescens' OR species='glaucescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Irvingia' AND (junior_species='gabonensis' OR junior_species='gabonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Irvingia' AND (species='gabonensis' OR species='gabonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Irvingia' AND (species='gabonensis' OR species='gabonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Irvingia' AND (junior_species='gabonensis' OR junior_species='gabonensis')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='Irvingia' AND (species='gabonensis' OR species='gabonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Irvingia' AND (junior_species='grandifolia' OR junior_species='grandifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Irvingia' AND (species='grandifolia' OR species='grandifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Irvingia' AND (species='grandifolia' OR species='grandifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Irvingia' AND (junior_species='grandifolia' OR junior_species='grandifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Irvingia' AND (species='grandifolia' OR species='grandifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Klainedoxa' AND (junior_species='gabonensis' OR junior_species='gabonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Klainedoxa' AND (species='gabonensis' OR species='gabonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Klainedoxa' AND (species='gabonensis' OR species='gabonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Klainedoxa' AND (junior_species='gabonensis' OR junior_species='gabonensis')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='Klainedoxa' AND (species='gabonensis' OR species='gabonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Klainedoxa' AND (junior_species='trilesii' OR junior_species='trilesi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Klainedoxa' AND (species='trilesii' OR species='trilesi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Klainedoxa' AND (species='trilesii' OR species='trilesi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Klainedoxa' AND (junior_species='trilesii' OR junior_species='trilesi')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='Klainedoxa' AND (species='trilesii' OR species='trilesi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='fulva' OR junior_species='fulva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Beilschmiedia' AND (species='fulva' OR species='fulva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Beilschmiedia' AND (species='fulva' OR species='fulva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Beilschmiedia' AND (junior_species='fulva' OR junior_species='fulva')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='Beilschmiedia' AND (species='fulva' OR species='fulva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypodaphnis' 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='Hypodaphnis' AND (species='zenkeri' OR species='zenkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypodaphnis' AND (species='zenkeri' OR species='zenkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypodaphnis' 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='Hypodaphnis' AND (species='zenkeri' OR species='zenkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocleista' 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='Anthocleista' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthocleista' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocleista' 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='Anthocleista' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testulea' AND (junior_species='gabonensis' OR junior_species='gabonensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Testulea' AND (species='gabonensis' OR species='gabonensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testulea' AND (species='gabonensis' OR species='gabonensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testulea' AND (junior_species='gabonensis' OR junior_species='gabonensis')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='Testulea' AND (species='gabonensis' OR species='gabonensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='prieuriana' OR junior_species='prieuriana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='prieuriana' OR species='prieuriana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='prieuriana' OR species='prieuriana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='prieuriana' OR junior_species='prieuriana')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='prieuriana' OR species='prieuriana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkia' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkia' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='bicolor' OR junior_species='bicolor')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='Parkia' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='filicoidea' OR junior_species='filicoidea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkia' AND (species='filicoidea' OR species='filicoidea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkia' AND (species='filicoidea' OR species='filicoidea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='filicoidea' OR junior_species='filicoidea')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='Parkia' AND (species='filicoidea' OR species='filicoidea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentaclethra' AND (junior_species='eetveldeana' OR junior_species='eetveldeana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pentaclethra' AND (species='eetveldeana' OR species='eetveldeana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pentaclethra' AND (species='eetveldeana' OR species='eetveldeana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentaclethra' AND (junior_species='eetveldeana' OR junior_species='eetveldeana')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='Pentaclethra' AND (species='eetveldeana' OR species='eetveldeana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentaclethra' 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='Pentaclethra' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pentaclethra' AND (species='macrophylla' OR species='macrophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pentaclethra' 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='Pentaclethra' AND (species='macrophylla' OR species='macrophylla') 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='Tetrapleura' AND (junior_species='tetraptera' OR junior_species='tetraptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrapleura' AND (species='tetraptera' OR species='tetraptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrapleura' AND (species='tetraptera' OR species='tetraptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrapleura' AND (junior_species='tetraptera' OR junior_species='tetraptera')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='Tetrapleura' AND (species='tetraptera' OR species='tetraptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorophora' AND (junior_species='excelsa' OR junior_species='excelsa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorophora' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorophora' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorophora' AND (junior_species='excelsa' OR junior_species='excelsa')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='Chlorophora' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='dicranostyla' OR junior_species='dicranostyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='dicranostyla' OR species='dicranostyla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='dicranostyla' OR species='dicranostyla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='dicranostyla' OR junior_species='dicranostyla')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='dicranostyla' OR species='dicranostyla') 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='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophira' AND (junior_species='alata' OR junior_species='alata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophira' AND (species='alata' OR species='alata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophira' AND (species='alata' OR species='alata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophira' AND (junior_species='alata' OR junior_species='alata')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='Lophira' AND (species='alata' OR species='alata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' AND (junior_species='parvifolia' OR junior_species='parvifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heisteria' AND (species='parvifolia' OR species='parvifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heisteria' AND (species='parvifolia' OR species='parvifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heisteria' AND (junior_species='parvifolia' OR junior_species='parvifolia')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='Heisteria' AND (species='parvifolia' OR species='parvifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ongokea' AND (junior_species='gore' OR junior_species='gore')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ongokea' AND (species='gore' OR species='gore') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ongokea' AND (species='gore' OR species='gore')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ongokea' AND (junior_species='gore' OR junior_species='gore')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='Ongokea' AND (species='gore' OR species='gore') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeis' AND (junior_species='guineensis' OR junior_species='guineensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaeis' AND (species='guineensis' OR species='guineensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaeis' AND (species='guineensis' OR species='guineensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaeis' AND (junior_species='guineensis' OR junior_species='guineensis')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='Elaeis' AND (species='guineensis' OR species='guineensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Millettia' AND (junior_species='sanagana' OR junior_species='sanagana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Millettia' AND (species='sanagana' OR species='sanagana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Millettia' AND (species='sanagana' OR species='sanagana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Millettia' AND (junior_species='sanagana' OR junior_species='sanagana')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='Millettia' AND (species='sanagana' OR species='sanagana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' 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='Pterocarpus' AND (species='soyauxii' OR species='soyauxi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterocarpus' AND (species='soyauxii' OR species='soyauxi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' 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='Pterocarpus' AND (species='soyauxii' OR species='soyauxi') 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='Coryanthe' AND (junior_species='mayumbensis' OR junior_species='mayumbensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coryanthe' AND (species='mayumbensis' OR species='mayumbensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coryanthe' AND (species='mayumbensis' OR species='mayumbensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryanthe' AND (junior_species='mayumbensis' OR junior_species='mayumbensis')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='Coryanthe' AND (species='mayumbensis' OR species='mayumbensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mitragyna' AND (junior_species='ciliata' OR junior_species='ciliata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mitragyna' AND (species='ciliata' OR species='ciliata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mitragyna' AND (species='ciliata' OR species='ciliata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mitragyna' AND (junior_species='ciliata' OR junior_species='ciliata')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='Mitragyna' AND (species='ciliata' OR species='ciliata') 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='Pauridiantha' AND (junior_species='efferata' OR junior_species='efferata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pauridiantha' AND (species='efferata' OR species='efferata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pauridiantha' AND (species='efferata' OR species='efferata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pauridiantha' AND (junior_species='efferata' OR junior_species='efferata')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='Pauridiantha' AND (species='efferata' OR species='efferata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pauridiantha' AND (junior_species='floribunda' OR junior_species='floribunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pauridiantha' AND (species='floribunda' OR species='floribunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pauridiantha' AND (species='floribunda' OR species='floribunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pauridiantha' AND (junior_species='floribunda' OR junior_species='floribunda')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='Pauridiantha' AND (species='floribunda' OR species='floribunda') 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='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='Rubiaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rubiaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rubiaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rubiaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rubiaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocoelum' AND (junior_species='panisculatum' OR junior_species='panisculatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eriocoelum' AND (species='panisculatum' OR species='panisculatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriocoelum' AND (species='panisculatum' OR species='panisculatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocoelum' AND (junior_species='panisculatum' OR junior_species='panisculatum')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='Eriocoelum' AND (species='panisculatum' OR species='panisculatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocoelum' AND (junior_species='macrocarpum' OR junior_species='macrocarpum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eriocoelum' AND (species='macrocarpum' OR species='macrocarpum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriocoelum' AND (species='macrocarpum' OR species='macrocarpum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocoelum' AND (junior_species='macrocarpum' OR junior_species='macrocarpum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eriocoelum' AND (species='macrocarpum' OR species='macrocarpum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocoelum' 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='Eriocoelum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriocoelum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocoelum' 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='Eriocoelum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocoelum' 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='Eriocoelum' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriocoelum' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocoelum' 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='Eriocoelum' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ganophyllum' AND (junior_species='giganteum' OR junior_species='giganteum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ganophyllum' AND (species='giganteum' OR species='giganteum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ganophyllum' AND (species='giganteum' OR species='giganteum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ganophyllum' AND (junior_species='giganteum' OR junior_species='giganteum')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='Ganophyllum' AND (species='giganteum' OR species='giganteum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecaniodiscus' AND (junior_species='cupanioides' OR junior_species='cupanioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lecaniodiscus' AND (species='cupanioides' OR species='cupanioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lecaniodiscus' AND (species='cupanioides' OR species='cupanioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lecaniodiscus' AND (junior_species='cupanioides' OR junior_species='cupanioides')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='Lecaniodiscus' AND (species='cupanioides' OR species='cupanioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Letestua' AND (junior_species='durissima' OR junior_species='durissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Letestua' AND (species='durissima' OR species='durissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Letestua' AND (species='durissima' OR species='durissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Letestua' AND (junior_species='durissima' OR junior_species='durissima')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='Letestua' AND (species='durissima' OR species='durissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapotaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapotaceae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapotaceae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapotaceae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sapotaceae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='lizae' OR junior_species='lizae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cola' AND (species='lizae' OR species='lizae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cola' AND (species='lizae' OR species='lizae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cola' AND (junior_species='lizae' OR junior_species='lizae')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='lizae' OR species='lizae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='tragacantha' OR junior_species='tragacantha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sterculia' AND (species='tragacantha' OR species='tragacantha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sterculia' AND (species='tragacantha' OR species='tragacantha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sterculia' AND (junior_species='tragacantha' OR junior_species='tragacantha')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='tragacantha' OR species='tragacantha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duboscia' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Duboscia' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Duboscia' AND (species='macrocarpa' OR species='macrocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duboscia' AND (junior_species='macrocarpa' OR junior_species='macrocarpa')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='Duboscia' AND (species='macrocarpa' OR species='macrocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='tessmannii' OR junior_species='tessmanni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='tessmannii' OR species='tessmanni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='tessmannii' OR species='tessmanni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='tessmannii' OR junior_species='tessmanni')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='tessmannii' OR species='tessmanni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Family' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Family' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Family' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Family' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Family' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Family' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Family' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Family' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Family' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Family' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Family' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Family' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Family' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Family' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Family' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=79 The Ecological Register: Lopé Reserve Site 1
Lopé Reserve Site 1
Basic information
Sample name: Lopé Reserve Site 1

Sample aka: Lopé National Park

Reference: L. J. T. White. 1992. Vegetation history and logging disturbance: effects on rain forest in the Lope Reserve, Gabon (with special emphasis on elephants and apes). University of Edinburgh [ER 44]
Geography
Country: Gabon


Coordinate: 0° 10' S, 11° 35' E
Coordinate basis: stated in text

Geography comments: coordinate and altitude range of 100 to 200 m for the reserve are based on Voysey et al. (1999, Journal of Tropical Ecology)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

Disturbance: selective logging

WMT: 28.0

CMT: 23.6

MAP: 1532.0

Habitat comments: "Consistently low rainfall in July and August constitutes a "major dry season", which is a feature of the annual cycle, although the timing of its onset and its duration varies between years; December to February are generally relatively dry months, but no distinct second dry season can be defined" (p. 11)
"The forest had been logged once, 20-25 years previously, for one tree species, Aucoumea klaineana which was extracted at an intensity of about one tree" per ha
climate data are for the reserve and are from Tutin et al. (1991, Journal of Tropical Ecology)

Methods
Life forms: trees

Sites: 1

Site length: 5000

Site width: 1

Sampling methods: line transect

Sample size: 1039 individuals

Years: 1989-1991

Size min: 10

Basal area: 21.4051

Sampling comments: basal area for the top 10 species is 169.1 per 5 ha and this makes up 79% of the total; sites are 0.5 ha, so the total is divided by 10

Metadata
Sample number: 79

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-02-13 12:48:15

Modified: 2017-11-11 07:40:13

Abundance distribution
93 species
17 singletons
total count 1039
extrapolated richness: 150.5
Fisher's α: 24.722
geometric series k: 0.9451
Hurlbert's PIE: 0.9270
Shannon's H: 3.4345
Good's u: 0.9837
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Pseudospondias microcarpa1
Sorindeia cf. juglandifolia2
Trichoscypha acuminata11
Annickia chlorantha4
"Enantia chlorantha"
Greenwayodendron suaveolens gabonica2
"Polyalthia suaveolens gabonica"
Uvariastrum pierreanum5
Xylopia aethiopica21
Xylopia hypolampra16
Xylopia phloiodora3
"Xylopia phloidora"
Xylopia quintasii38
Newbouldia laevis5
Ceiba pentandra1
Aucoumea klaineana180
Canarium schweinfurthii2
Dacryodes buettneri24
Dacryodes normandii3
Anthonotha macrophylla6
Berlinia bracteosa10
Detarium macrocarpum2
Dialium sp. nov.7
Distemonanthus benthamianus7
Hylodendron gabunense18
"Hylodendron gabunensis"
Julbernardia brieyi1
Swartzia fistuloides6
Euonymus congolensis3
Maranthes gabunensis3
Dichapetalum sp.9
Diospyros dendo29
Diospyros mannii2
Diospyros piscatoria1
Diospyros polystemon38
Diospyros viridicans2
Erythroxylum mannii1
Antidesma laciniatum2
Discoglypremna caloneura3
Maprounea membranacea17
Plagiostyles africana4
Sapium ellipticum2
Uapaca heudelotii3
Casearia barteri5
Scottellia coriacea8
Pentadesma butyracea1
Psorospermum tenuifolium2
Desbordesia glaucescens5
Irvingia gabonensis8
Irvingia grandifolia4
Klainedoxa gabonensis17
Klainedoxa trilesii2
Beilschmiedia fulva2
Hypodaphnis zenkeri18
Anthocleista sp. 12
Testulea gabonensis3
Trichilia cf. prieuriana16
"Trichilia cf. prieureana"
Parkia 'bicolor'2
Parkia filicoidea2
Pentaclethra eetveldeana18
Pentaclethra macrophylla21
Piptadeniastrum africanum10
Tetrapleura tetraptera2
Chlorophora excelsa3
Ficus cf. dicranostyla1
Pycnanthus angolensis12
Syzygium sp. 11
Lophira alata83
Heisteria parvifolia4
Ongokea gore6
Elaeis guineensis5
Millettia sanagana1
Pterocarpus soyauxii22
Barteria fistulosa12
Coryanthe mayumbensis13
Mitragyna ciliata4
"Mitragyna ciliate"
Nauclea diderrichii2
Pauridiantha efferata7
Pauridiantha floribunda5
Corynanthe johimbe1
"Pausinystalia johimbe"
Porterandia cladantha5
Rubiaceae indet. 12
Eriocoelum panisculatum1
Eriocoelum macrocarpum4
Eriocoelum sp. 11
Eriocoelum sp. 31
Ganophyllum giganteum9
Lecaniodiscus cupanioides4
Letestua durissima1
Sapotaceae indet. 21
Cola lizae173
Sterculia tragacantha2
Duboscia macrocarpa2
Celtis tessmannii4
Family indet. 41
Family indet. 63
Family indet. 71