Coordinate: 10° 52' N, 3° 6' W
habitats included "(i) woodland savanna; (ii) tree savanna; (iii) shrub savanna; and (iv) gallery forest" and five plots were located in each one
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=2730 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2730SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2459SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2730 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vachellia' AND (junior_species='sieberiana' OR junior_species='sieberiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vachellia' AND (species='sieberiana' OR species='sieberiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vachellia' AND (species='sieberiana' OR species='sieberiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vachellia' AND (junior_species='sieberiana' OR junior_species='sieberiana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vachellia' AND (species='sieberiana' OR species='sieberiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='leiocarpa' OR junior_species='leiocarpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='leiocarpa' OR species='leiocarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='leiocarpa' OR species='leiocarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='leiocarpa' OR junior_species='leiocarpa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terminalia' AND (species='leiocarpa' OR species='leiocarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bridelia' AND (junior_species='scleroneura' OR junior_species='scleroneura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bridelia' AND (species='scleroneura' OR species='scleroneura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bridelia' AND (species='scleroneura' OR species='scleroneura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bridelia' AND (junior_species='scleroneura' OR junior_species='scleroneura')SELECT d.diet,d.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='scleroneura' OR species='scleroneura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='adenogonium' OR junior_species='adenogonium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Combretum' AND (species='adenogonium' OR species='adenogonium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Combretum' AND (species='adenogonium' OR species='adenogonium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='adenogonium' OR junior_species='adenogonium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Combretum' AND (species='adenogonium' OR species='adenogonium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='collinum' OR junior_species='collinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Combretum' AND (species='collinum' OR species='collinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Combretum' AND (species='collinum' OR species='collinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='collinum' OR junior_species='collinum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Combretum' AND (species='collinum' OR species='collinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='fragrans' OR junior_species='fragrans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Combretum' AND (species='fragrans' OR species='fragrans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Combretum' AND (species='fragrans' OR species='fragrans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='fragrans' OR junior_species='fragrans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Combretum' AND (species='fragrans' OR species='fragrans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='glutinosum' OR junior_species='glutinosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Combretum' AND (species='glutinosum' OR species='glutinosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Combretum' AND (species='glutinosum' OR species='glutinosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='glutinosum' OR junior_species='glutinosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Combretum' AND (species='glutinosum' OR species='glutinosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daniellia' AND (junior_species='oliveri' OR junior_species='oliverii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Daniellia' AND (species='oliveri' OR species='oliverii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Daniellia' AND (species='oliveri' OR species='oliverii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daniellia' AND (junior_species='oliveri' OR junior_species='oliverii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Daniellia' AND (species='oliveri' OR species='oliverii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entada' 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='Entada' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entada' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entada' 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='Entada' AND (species='africana' OR species='africana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gardenia' AND (junior_species='erubescens' OR junior_species='erubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gardenia' AND (species='erubescens' OR species='erubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gardenia' AND (species='erubescens' OR species='erubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gardenia' AND (junior_species='erubescens' OR junior_species='erubescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gardenia' AND (species='erubescens' OR species='erubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gardenia' AND (junior_species='ternifolia' OR junior_species='ternifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gardenia' AND (species='ternifolia' OR species='ternifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gardenia' AND (species='ternifolia' OR species='ternifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gardenia' AND (junior_species='ternifolia' OR junior_species='ternifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gardenia' AND (species='ternifolia' OR species='ternifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lannea' 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='Lannea' AND (species='microcarpa' OR species='microcarpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lannea' AND (species='microcarpa' OR species='microcarpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lannea' 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='Lannea' AND (species='microcarpa' OR species='microcarpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mitragyna' AND (junior_species='inermis' OR junior_species='inermis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mitragyna' AND (species='inermis' OR species='inermis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mitragyna' AND (species='inermis' OR species='inermis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mitragyna' AND (junior_species='inermis' OR junior_species='inermis')SELECT d.diet,d.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='inermis' OR species='inermis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='biglobosa' OR junior_species='biglobosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkia' AND (species='biglobosa' OR species='biglobosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkia' AND (species='biglobosa' OR species='biglobosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkia' AND (junior_species='biglobosa' OR junior_species='biglobosa')SELECT d.diet,d.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='biglobosa' OR species='biglobosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pericopsis' AND (junior_species='laxiflora' OR junior_species='laxiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pericopsis' AND (species='laxiflora' OR species='laxiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pericopsis' AND (species='laxiflora' OR species='laxiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pericopsis' AND (junior_species='laxiflora' OR junior_species='laxiflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pericopsis' AND (species='laxiflora' OR species='laxiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piliostigma' AND (junior_species='thonningii' OR junior_species='thonningi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piliostigma' AND (species='thonningii' OR species='thonningi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piliostigma' AND (species='thonningii' OR species='thonningi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piliostigma' AND (junior_species='thonningii' OR junior_species='thonningi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Piliostigma' AND (species='thonningii' OR species='thonningi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocedrela' AND (junior_species='kotschyi' OR junior_species='kotschyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudocedrela' AND (species='kotschyi' OR species='kotschyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocedrela' AND (species='kotschyi' OR species='kotschyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocedrela' AND (junior_species='kotschyi' OR junior_species='kotschyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudocedrela' AND (species='kotschyi' OR species='kotschyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' AND (junior_species='erinaceus' OR junior_species='erinaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterocarpus' AND (species='erinaceus' OR species='erinaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterocarpus' AND (species='erinaceus' OR species='erinaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterocarpus' AND (junior_species='erinaceus' OR junior_species='erinaceus')SELECT d.diet,d.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='erinaceus' OR species='erinaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stereospermum' AND (junior_species='kunthianum' OR junior_species='kunthianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stereospermum' AND (species='kunthianum' OR species='kunthianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stereospermum' AND (species='kunthianum' OR species='kunthianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stereospermum' AND (junior_species='kunthianum' OR junior_species='kunthianum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stereospermum' AND (species='kunthianum' OR species='kunthianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='laxiflora' OR junior_species='laxiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='laxiflora' OR species='laxiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='laxiflora' OR species='laxiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='laxiflora' OR junior_species='laxiflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terminalia' AND (species='laxiflora' OR species='laxiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='macroptera' OR junior_species='macroptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terminalia' AND (species='macroptera' OR species='macroptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terminalia' AND (species='macroptera' OR species='macroptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terminalia' AND (junior_species='macroptera' OR junior_species='macroptera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terminalia' AND (species='macroptera' OR species='macroptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitellaria' AND (junior_species='paradoxa' OR junior_species='paradoxa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitellaria' AND (species='paradoxa' OR species='paradoxa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitellaria' AND (species='paradoxa' OR species='paradoxa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitellaria' AND (junior_species='paradoxa' OR junior_species='paradoxa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vitellaria' AND (species='paradoxa' OR species='paradoxa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ximenia' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ximenia' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ximenia' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ximenia' AND (junior_species='americana' OR junior_species='americana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ximenia' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2730