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=190 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=190SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=77SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=190 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='chinense' OR junior_species='chinense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alangium' AND (species='chinense' OR species='chinense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alangium' AND (species='chinense' OR species='chinense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alangium' AND (junior_species='chinense' OR junior_species='chinense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alangium' AND (species='chinense' OR species='chinense') 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='Ilex' AND (junior_species='mitis' OR junior_species='mitis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ilex' AND (species='mitis' OR species='mitis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ilex' AND (species='mitis' OR species='mitis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ilex' AND (junior_species='mitis' OR junior_species='mitis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ilex' AND (species='mitis' OR species='mitis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyscias' 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='Polyscias' AND (species='fulva' OR species='fulva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyscias' AND (species='fulva' OR species='fulva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyscias' 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='Polyscias' AND (species='fulva' OR species='fulva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cassipourea' 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='Cassipourea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cassipourea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cassipourea' 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='Cassipourea' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ritchiea' AND (junior_species='albersii' OR junior_species='albersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ritchiea' AND (species='albersii' OR species='albersi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ritchiea' AND (species='albersii' OR species='albersi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ritchiea' AND (junior_species='albersii' OR junior_species='albersi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ritchiea' AND (species='albersii' OR species='albersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cassine' 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='Cassine' AND (species='aethiopica' OR species='aethiopica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cassine' AND (species='aethiopica' OR species='aethiopica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cassine' 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='Cassine' AND (species='aethiopica' OR species='aethiopica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' 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='Maytenus' AND (species='acuminata' OR species='acuminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maytenus' AND (species='acuminata' OR species='acuminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maytenus' 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='Maytenus' AND (species='acuminata' OR species='acuminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinari' 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='Parinari' AND (species='excelsa' OR species='excelsa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parinari' AND (species='excelsa' OR species='excelsa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parinari' 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='Parinari' AND (species='excelsa' OR species='excelsa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symphonia' AND (junior_species='globulifera' OR junior_species='globulifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Symphonia' AND (species='globulifera' OR species='globulifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Symphonia' AND (species='globulifera' OR species='globulifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Symphonia' AND (junior_species='globulifera' OR junior_species='globulifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Symphonia' AND (species='globulifera' OR species='globulifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathea' AND (junior_species='manniana' OR junior_species='manniana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyathea' AND (species='manniana' OR species='manniana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyathea' AND (species='manniana' OR species='manniana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyathea' AND (junior_species='manniana' OR junior_species='manniana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyathea' AND (species='manniana' OR species='manniana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alchornea' 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='Alchornea' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alchornea' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alchornea' 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='Alchornea' AND (species='sp.' OR species='sp.') 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='Croton' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Croton' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Croton' AND (species='sylvaticus' OR species='sylvaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Croton' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Croton' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drypetes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drypetes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drypetes' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drypetes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='kilimandscharica' OR junior_species='kilimandscharica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaranga' AND (species='kilimandscharica' OR species='kilimandscharica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaranga' AND (species='kilimandscharica' OR species='kilimandscharica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaranga' AND (junior_species='kilimandscharica' OR junior_species='kilimandscharica')SELECT d.diet,d.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='kilimandscharica' OR species='kilimandscharica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoboutonia' AND (junior_species='macrocalyx' OR junior_species='macrocalyx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoboutonia' AND (species='macrocalyx' OR species='macrocalyx') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoboutonia' AND (species='macrocalyx' OR species='macrocalyx')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoboutonia' AND (junior_species='macrocalyx' OR junior_species='macrocalyx')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neoboutonia' AND (species='macrocalyx' OR species='macrocalyx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margaritaria' AND (junior_species='discoidea' OR junior_species='discoidea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Margaritaria' AND (species='discoidea' OR species='discoidea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Margaritaria' AND (species='discoidea' OR species='discoidea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margaritaria' AND (junior_species='discoidea' OR junior_species='discoidea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Margaritaria' AND (species='discoidea' OR species='discoidea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harungana' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harungana' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harungana' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harungana' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Harungana' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='kenyensis' OR junior_species='kenyensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='kenyensis' OR species='kenyensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='kenyensis' OR species='kenyensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='kenyensis' OR junior_species='kenyensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ocotea' AND (species='kenyensis' OR species='kenyensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='usambarensis' OR junior_species='usambarensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocotea' AND (species='usambarensis' OR species='usambarensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='usambarensis' OR species='usambarensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' AND (junior_species='usambarensis' OR junior_species='usambarensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ocotea' AND (species='usambarensis' OR species='usambarensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Newtonia' AND (junior_species='buchananii' OR junior_species='buchanani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Newtonia' AND (species='buchananii' OR species='buchanani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Newtonia' AND (species='buchananii' OR species='buchanani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Newtonia' AND (junior_species='buchananii' OR junior_species='buchanani')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Newtonia' AND (species='buchananii' OR species='buchanani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocleista' AND (junior_species='zambesiaca' OR junior_species='zambesiaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthocleista' AND (species='zambesiaca' OR species='zambesiaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthocleista' AND (species='zambesiaca' OR species='zambesiaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocleista' AND (junior_species='zambesiaca' OR junior_species='zambesiaca')SELECT d.diet,d.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='zambesiaca' OR species='zambesiaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' 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='Memecylon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Memecylon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Memecylon' 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='Memecylon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='excelsum' OR junior_species='excelsum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Entandrophragma' AND (species='excelsum' OR species='excelsum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entandrophragma' AND (species='excelsum' OR species='excelsum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entandrophragma' AND (junior_species='excelsum' OR junior_species='excelsum')SELECT d.diet,d.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='excelsum' OR species='excelsum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xymalos' AND (junior_species='monospora' OR junior_species='monospora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xymalos' AND (species='monospora' OR species='monospora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xymalos' AND (species='monospora' OR species='monospora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xymalos' AND (junior_species='monospora' OR junior_species='monospora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xymalos' AND (species='monospora' OR species='monospora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='pilosula' OR junior_species='pilosula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficus' AND (species='pilosula' OR species='pilosula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficus' AND (species='pilosula' OR species='pilosula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficus' AND (junior_species='pilosula' OR junior_species='pilosula')SELECT d.diet,d.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='pilosula' OR species='pilosula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrianthus' AND (junior_species='holstii' OR junior_species='holsti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrianthus' AND (species='holstii' OR species='holsti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrianthus' AND (species='holstii' OR species='holsti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrianthus' AND (junior_species='holstii' OR junior_species='holsti')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrianthus' AND (species='holstii' OR species='holsti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maesa' AND (junior_species='lanceolata' OR junior_species='lanceolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maesa' AND (species='lanceolata' OR species='lanceolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maesa' AND (species='lanceolata' OR species='lanceolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maesa' AND (junior_species='lanceolata' OR junior_species='lanceolata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Maesa' AND (species='lanceolata' OR species='lanceolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rapanea' AND (junior_species='rhododendroides' OR junior_species='rhododendroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rapanea' AND (species='rhododendroides' OR species='rhododendroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rapanea' AND (species='rhododendroides' OR species='rhododendroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rapanea' AND (junior_species='rhododendroides' OR junior_species='rhododendroides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rapanea' AND (species='rhododendroides' OR species='rhododendroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cordatum' OR junior_species='cordatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syzygium' AND (species='cordatum' OR species='cordatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='cordatum' OR species='cordatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' AND (junior_species='cordatum' OR junior_species='cordatum')SELECT d.diet,d.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='cordatum' OR species='cordatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='guineense' OR species='guineense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syzygium' AND (species='guineense' OR species='guineense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syzygium' 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='Syzygium' AND (species='guineense' OR species='guineense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='scheffleri' OR junior_species='schefflerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Strombosia' AND (species='scheffleri' OR species='schefflerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Strombosia' AND (species='scheffleri' OR species='schefflerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Strombosia' AND (junior_species='scheffleri' OR junior_species='schefflerii')SELECT d.diet,d.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='scheffleri' OR species='schefflerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='hochstetteri' OR junior_species='hochstetterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Olea' AND (species='hochstetteri' OR species='hochstetterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Olea' AND (species='hochstetteri' OR species='hochstetterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olea' AND (junior_species='hochstetteri' OR junior_species='hochstetterii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Olea' AND (species='hochstetteri' OR species='hochstetterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olinia' AND (junior_species='usambarensis' OR junior_species='usambarensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Olinia' AND (species='usambarensis' OR species='usambarensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Olinia' AND (species='usambarensis' OR species='usambarensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Olinia' AND (junior_species='usambarensis' OR junior_species='usambarensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Olinia' AND (species='usambarensis' OR species='usambarensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pittosporum' AND (junior_species='spathicalyx' OR junior_species='spathicalyx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pittosporum' AND (species='spathicalyx' OR species='spathicalyx') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pittosporum' AND (species='spathicalyx' OR species='spathicalyx')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pittosporum' AND (junior_species='spathicalyx' OR junior_species='spathicalyx')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pittosporum' AND (species='spathicalyx' OR species='spathicalyx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podocarpus' AND (junior_species='milanjianus' OR junior_species='milanjianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podocarpus' AND (species='milanjianus' OR species='milanjianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podocarpus' AND (species='milanjianus' OR species='milanjianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podocarpus' AND (junior_species='milanjianus' OR junior_species='milanjianus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Podocarpus' AND (species='milanjianus' OR species='milanjianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faurea' AND (junior_species='saligna' OR junior_species='saligna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Faurea' AND (species='saligna' OR species='saligna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Faurea' AND (species='saligna' OR species='saligna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Faurea' AND (junior_species='saligna' OR junior_species='saligna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Faurea' AND (species='saligna' OR species='saligna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' 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='Prunus' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prunus' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prunus' 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='Prunus' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' 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='Canthium' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canthium' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canthium' 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='Canthium' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galiniera' AND (junior_species='coffeoides' OR junior_species='coffeoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galiniera' AND (species='coffeoides' OR species='coffeoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galiniera' AND (species='coffeoides' OR species='coffeoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galiniera' AND (junior_species='coffeoides' OR junior_species='coffeoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Galiniera' AND (species='coffeoides' OR species='coffeoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pavetta' 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='Pavetta' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pavetta' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pavetta' 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='Pavetta' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='megistosticta' OR junior_species='megistosticta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psychotria' AND (species='megistosticta' OR species='megistosticta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psychotria' AND (species='megistosticta' OR species='megistosticta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychotria' AND (junior_species='megistosticta' OR junior_species='megistosticta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Psychotria' AND (species='megistosticta' OR species='megistosticta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhytigynia' AND (junior_species='kigeziensis' OR junior_species='kigeziensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhytigynia' AND (species='kigeziensis' OR species='kigeziensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhytigynia' AND (species='kigeziensis' OR species='kigeziensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhytigynia' AND (junior_species='kigeziensis' OR junior_species='kigeziensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhytigynia' AND (species='kigeziensis' OR species='kigeziensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vepris' AND (junior_species='nobilis' OR junior_species='nobilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vepris' AND (species='nobilis' OR species='nobilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vepris' AND (species='nobilis' OR species='nobilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vepris' AND (junior_species='nobilis' OR junior_species='nobilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vepris' AND (species='nobilis' OR species='nobilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' 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='Zanthoxylum' AND (species='macrophylla' OR species='macrophylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zanthoxylum' AND (species='macrophylla' OR species='macrophylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanthoxylum' 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='Zanthoxylum' AND (species='macrophylla' OR species='macrophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='macrobotrys' OR junior_species='macrobotrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allophylus' AND (species='macrobotrys' OR species='macrobotrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophylus' AND (species='macrobotrys' OR species='macrobotrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophylus' AND (junior_species='macrobotrys' OR junior_species='macrobotrys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Allophylus' AND (species='macrobotrys' OR species='macrobotrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='gorungosanum' OR junior_species='gorungosanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysophyllum' AND (species='gorungosanum' OR species='gorungosanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysophyllum' AND (species='gorungosanum' OR species='gorungosanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysophyllum' AND (junior_species='gorungosanum' OR junior_species='gorungosanum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysophyllum' AND (species='gorungosanum' OR species='gorungosanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficalhoa' AND (junior_species='laurifolia' OR junior_species='laurifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficalhoa' AND (species='laurifolia' OR species='laurifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficalhoa' AND (species='laurifolia' OR species='laurifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficalhoa' AND (junior_species='laurifolia' OR junior_species='laurifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ficalhoa' AND (species='laurifolia' OR species='laurifolia') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=190 The Ecological Register: Bwindi (Plot A)
Bwindi (Plot A)
Basic information
Sample name: Bwindi (Plot A)

Sample aka: Bwindi Impenetrable Forest National Park (undisturbed area)

Reference: G. Eilu and J. Obua. 2005. Tree condition and natural regeneration in disturbed sites of Bwindi Impenetrable Forest National Park, south western Uganda. Tropical Ecology 46(1):99-111 [ER 77]
Geography
Country: Uganda

State: Kaunugu disctrict


Coordinate: -1.0° S, 29.5° E
Coordinate basis: stated in text as range

Geography comments: in the Kigezi highlands overlooking the western rift valley in south-western Uganda... the elevation ranges from 11660-2607 m above sea level

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

Disturbance: selective logging

WMT: 21.0

CMT: 13.5

MAP: 1650.0

Habitat comments: "The vegetation is classified as medium altitude moist evergreen forest and high altitude submontane forest" and the plot is "undisturbed forest with 5% removed" by pitsawing

Methods
Life forms: trees

Sites: 1

Site area: 1.2

Sampling methods: line transect

Sample size: 1352 individuals

Size min: 15

Sampling comments: "Four linear transects 1000 m long and running north, east, south and west were established in each site radiating from a point approximating the centre of the site. Four plots each measuring 25 m x 30 m were established at 225 m intervals on alternate sides of each transect. The total area sampled at each site was 1.2 ha giving a total sample area of 7.2 ha" (p. 101); counts may or may not include smaller size classes counted in nested subplots

Metadata
Sample number: 190

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-20 13:11:21

Modified: 2016-06-03 23:10:12

Abundance distribution
49 species
11 singletons
total count 1352
extrapolated richness: 74.6
Fisher's α: 9.964
geometric series k: 0.8814
Hurlbert's PIE: 0.8594
Shannon's H: 2.6210
Good's u: 0.9919
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Alangium chinense5
Tabernaemontana pachysiphon8
"Tabernaemontana holstii"
Ilex mitis2
Polyscias fulva2
Cassipourea sp.18
Ritchiea albersii1
Cassine aethiopica1
Maytenus acuminata1
Parinari excelsa9
Symphonia globulifera99
Cyathea manniana81
Alchornea sp.1
Bridelia micrantha3
Croton sylvaticus3
Drypetes sp.27
Macaranga kilimandscharica18
Neoboutonia macrocalyx5
Margaritaria discoidea4
"Phyllanthus discoideus"
Harungana madagascariensis3
Ocotea kenyensis3
Ocotea usambarensis1
Newtonia buchananii182
Anthocleista zambesiaca1
Memecylon sp.6
Entandrophragma excelsum20
Xymalos monospora7
Ficus pilosula1
Myrianthus holstii1
Maesa lanceolata9
Rapanea rhododendroides68
Syzygium cordatum18
Syzygium guineense13
Strombosia scheffleri88
Olea hochstetteri10
Olinia usambarensis30
Pittosporum spathicalyx2
Podocarpus milanjianus428
Faurea saligna5
Prunus africana1
Canthium sp.14
Galiniera coffeoides12
Pavetta sp.3
Psychotria megistosticta13
Rhytigynia kigeziensis1
Vepris nobilis21
Zanthoxylum macrophylla1
Allophylus macrobotrys4
Chrysophyllum gorungosanum83
Ficalhoa laurifolia15