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=232 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=232SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=94SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=232 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='vera' OR junior_species='vera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='vera' OR species='vera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='vera' OR species='vera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='vera' OR junior_species='vera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Inga' AND (species='vera' OR species='vera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='heptaphylla' OR junior_species='heptaphylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabebuia' AND (species='heptaphylla' OR species='heptaphylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabebuia' AND (species='heptaphylla' OR species='heptaphylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='heptaphylla' OR junior_species='heptaphylla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tabebuia' AND (species='heptaphylla' OR species='heptaphylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' 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='Ocotea' AND (species='suaveolens' OR species='suaveolens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocotea' AND (species='suaveolens' OR species='suaveolens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocotea' 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='Ocotea' AND (species='suaveolens' OR species='suaveolens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicteres' AND (junior_species='lhotzkyana' OR junior_species='lhotzkyana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicteres' AND (species='lhotzkyana' OR species='lhotzkyana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicteres' AND (species='lhotzkyana' OR species='lhotzkyana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicteres' AND (junior_species='lhotzkyana' OR junior_species='lhotzkyana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helicteres' AND (species='lhotzkyana' OR species='lhotzkyana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='cymosa' OR junior_species='cymosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitex' AND (species='cymosa' OR species='cymosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitex' AND (species='cymosa' OR species='cymosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitex' AND (junior_species='cymosa' OR junior_species='cymosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vitex' AND (species='cymosa' OR species='cymosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='pachystachya' OR junior_species='pachystachya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cecropia' AND (species='pachystachya' OR species='pachystachya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cecropia' AND (species='pachystachya' OR species='pachystachya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cecropia' AND (junior_species='pachystachya' OR junior_species='pachystachya')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cecropia' AND (species='pachystachya' OR species='pachystachya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='ramiflora' OR junior_species='ramiflora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='ramiflora' OR species='ramiflora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='ramiflora' OR species='ramiflora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='ramiflora' OR junior_species='ramiflora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pouteria' AND (species='ramiflora' OR species='ramiflora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrina' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrina' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrina' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrina' AND (junior_species='fusca' OR junior_species='fusca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrina' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attalea' AND (junior_species='phalerata' OR junior_species='phalerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Attalea' AND (species='phalerata' OR species='phalerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Attalea' AND (species='phalerata' OR species='phalerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attalea' AND (junior_species='phalerata' OR junior_species='phalerata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Attalea' AND (species='phalerata' OR species='phalerata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='aculeata' OR junior_species='aculeata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='aculeata' OR species='aculeata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='aculeata' OR species='aculeata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='aculeata' OR junior_species='aculeata')SELECT d.diet,d.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='aculeata' OR species='aculeata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='anguifugum' OR junior_species='anguifugum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythroxylum' AND (species='anguifugum' OR species='anguifugum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythroxylum' AND (species='anguifugum' OR species='anguifugum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythroxylum' AND (junior_species='anguifugum' OR junior_species='anguifugum')SELECT d.diet,d.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='anguifugum' OR species='anguifugum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cassia' AND (junior_species='grandis' OR junior_species='grandis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cassia' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cassia' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cassia' AND (junior_species='grandis' OR junior_species='grandis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cassia' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='niopoides' OR junior_species='niopoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albizia' AND (species='niopoides' OR species='niopoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Albizia' AND (species='niopoides' OR species='niopoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albizia' AND (junior_species='niopoides' OR junior_species='niopoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Albizia' AND (species='niopoides' OR species='niopoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alibertia' AND (junior_species='edulis' OR junior_species='edulis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alibertia' AND (species='edulis' OR species='edulis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alibertia' AND (species='edulis' OR species='edulis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alibertia' AND (junior_species='edulis' OR junior_species='edulis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alibertia' AND (species='edulis' OR species='edulis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='glomerata' OR junior_species='glomerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pouteria' AND (species='glomerata' OR species='glomerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pouteria' AND (species='glomerata' OR species='glomerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pouteria' AND (junior_species='glomerata' OR junior_species='glomerata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pouteria' AND (species='glomerata' OR species='glomerata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vochysia' AND (junior_species='divergens' OR junior_species='divergens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vochysia' AND (species='divergens' OR species='divergens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vochysia' AND (species='divergens' OR species='divergens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vochysia' AND (junior_species='divergens' OR junior_species='divergens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vochysia' AND (species='divergens' OR species='divergens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Genipa' 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='Genipa' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Genipa' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Genipa' 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='Genipa' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copernicia' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Copernicia' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Copernicia' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Copernicia' AND (junior_species='alba' OR junior_species='alba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Copernicia' AND (species='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='stellatotomentosa' OR junior_species='stellatotomentosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichilia' AND (species='stellatotomentosa' OR species='stellatotomentosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichilia' AND (species='stellatotomentosa' OR species='stellatotomentosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichilia' AND (junior_species='stellatotomentosa' OR junior_species='stellatotomentosa')SELECT d.diet,d.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='stellatotomentosa' OR species='stellatotomentosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celtis' AND (species='pubescens' OR species='pubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celtis' AND (species='pubescens' OR species='pubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celtis' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT d.diet,d.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='pubescens' OR species='pubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triplaris' 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='Triplaris' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triplaris' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triplaris' 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='Triplaris' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andira' 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='Andira' AND (species='inermis' OR species='inermis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andira' AND (species='inermis' OR species='inermis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andira' 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='Andira' AND (species='inermis' OR species='inermis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='laxum' OR junior_species='laxum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Combretum' AND (species='laxum' OR species='laxum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Combretum' AND (species='laxum' OR species='laxum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Combretum' AND (junior_species='laxum' OR junior_species='laxum')SELECT d.diet,d.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='laxum' OR species='laxum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='aurea' OR junior_species='aurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tabebuia' AND (species='aurea' OR species='aurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tabebuia' AND (species='aurea' OR species='aurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tabebuia' AND (junior_species='aurea' OR junior_species='aurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tabebuia' AND (species='aurea' OR species='aurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Banara' AND (junior_species='arguta' OR junior_species='arguta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Banara' AND (species='arguta' OR species='arguta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Banara' AND (species='arguta' OR species='arguta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Banara' AND (junior_species='arguta' OR junior_species='arguta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Banara' AND (species='arguta' OR species='arguta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='castaneifolia' OR junior_species='castaneifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cupania' AND (species='castaneifolia' OR species='castaneifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cupania' AND (species='castaneifolia' OR species='castaneifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cupania' AND (junior_species='castaneifolia' OR junior_species='castaneifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cupania' AND (species='castaneifolia' OR species='castaneifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campomanesia' AND (junior_species='eugenioides' OR junior_species='eugenioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campomanesia' AND (species='eugenioides' OR species='eugenioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campomanesia' AND (species='eugenioides' OR species='eugenioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campomanesia' AND (junior_species='eugenioides' OR junior_species='eugenioides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Campomanesia' AND (species='eugenioides' OR species='eugenioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygia' AND (junior_species='inaequalis' OR junior_species='inaequalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygia' AND (species='inaequalis' OR species='inaequalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygia' AND (species='inaequalis' OR species='inaequalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygia' AND (junior_species='inaequalis' OR junior_species='inaequalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zygia' AND (species='inaequalis' OR species='inaequalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chomelia' 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='Chomelia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chomelia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chomelia' 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='Chomelia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='decandra' OR junior_species='decandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Casearia' AND (species='decandra' OR species='decandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Casearia' AND (species='decandra' OR species='decandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Casearia' AND (junior_species='decandra' OR junior_species='decandra')SELECT d.diet,d.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='decandra' OR species='decandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenaea' AND (junior_species='courbaril' OR junior_species='courbaril')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hymenaea' AND (species='courbaril' OR species='courbaril') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hymenaea' AND (species='courbaril' OR species='courbaril')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenaea' AND (junior_species='courbaril' OR junior_species='courbaril')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hymenaea' AND (species='courbaril' OR species='courbaril') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='florida' OR junior_species='florida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugenia' AND (species='florida' OR species='florida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugenia' AND (species='florida' OR species='florida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugenia' AND (junior_species='florida' OR junior_species='florida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugenia' AND (species='florida' OR species='florida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guazuma' AND (junior_species='ulmifolia' OR junior_species='ulmifolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guazuma' AND (species='ulmifolia' OR species='ulmifolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guazuma' AND (species='ulmifolia' OR species='ulmifolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guazuma' AND (junior_species='ulmifolia' OR junior_species='ulmifolia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Guazuma' AND (species='ulmifolia' OR species='ulmifolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' 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='Ruprechtia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ruprechtia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruprechtia' 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='Ruprechtia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tocoyena' AND (junior_species='formosa' OR junior_species='formosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tocoyena' AND (species='formosa' OR species='formosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tocoyena' AND (species='formosa' OR species='formosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tocoyena' AND (junior_species='formosa' OR junior_species='formosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tocoyena' AND (species='formosa' OR species='formosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duguetia' 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='Duguetia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Duguetia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Duguetia' 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='Duguetia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maclura' AND (junior_species='tinctoria' OR junior_species='tinctoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maclura' AND (species='tinctoria' OR species='tinctoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maclura' AND (species='tinctoria' OR species='tinctoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maclura' AND (junior_species='tinctoria' OR junior_species='tinctoria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Maclura' AND (species='tinctoria' OR species='tinctoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salacia' AND (junior_species='elliptica' OR junior_species='elliptica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salacia' AND (species='elliptica' OR species='elliptica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salacia' AND (species='elliptica' OR species='elliptica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salacia' AND (junior_species='elliptica' OR junior_species='elliptica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Salacia' AND (species='elliptica' OR species='elliptica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neea' AND (junior_species='hermaphrodita' OR junior_species='hermaphrodita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neea' AND (species='hermaphrodita' OR species='hermaphrodita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neea' AND (species='hermaphrodita' OR species='hermaphrodita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neea' AND (junior_species='hermaphrodita' OR junior_species='hermaphrodita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neea' AND (species='hermaphrodita' OR species='hermaphrodita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='glabrata' OR junior_species='glabrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordia' AND (species='glabrata' OR species='glabrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordia' AND (species='glabrata' OR species='glabrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordia' AND (junior_species='glabrata' OR junior_species='glabrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cordia' AND (species='glabrata' OR species='glabrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='uruguensis' OR junior_species='uruguensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inga' AND (species='uruguensis' OR species='uruguensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inga' AND (species='uruguensis' OR species='uruguensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inga' AND (junior_species='uruguensis' OR junior_species='uruguensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Inga' AND (species='uruguensis' OR species='uruguensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='hassleriana' OR junior_species='hassleriana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagara' AND (species='hassleriana' OR species='hassleriana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagara' AND (species='hassleriana' OR species='hassleriana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagara' AND (junior_species='hassleriana' OR junior_species='hassleriana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fagara' AND (species='hassleriana' OR species='hassleriana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rollinia' 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='Rollinia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rollinia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rollinia' 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='Rollinia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccoloba' AND (junior_species='ochreolata' OR junior_species='ochreolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccoloba' AND (species='ochreolata' OR species='ochreolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccoloba' AND (species='ochreolata' OR species='ochreolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccoloba' AND (junior_species='ochreolata' OR junior_species='ochreolata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coccoloba' AND (species='ochreolata' OR species='ochreolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mouriri' AND (species='guianensis' OR species='guianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mouriri' AND (species='guianensis' OR species='guianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mouriri' AND (junior_species='guianensis' OR junior_species='guianensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mouriri' AND (species='guianensis' OR species='guianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capparis' AND (junior_species='speciosa' OR junior_species='speciosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capparis' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capparis' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capparis' AND (junior_species='speciosa' OR junior_species='speciosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Capparis' AND (species='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=232 The Ecological Register: Lower Miranda River
Lower Miranda River
Basic information
Sample name: Lower Miranda River

Reference: F. Wittmann, B. T. Zorzi, F. A. Tambelini Tizianel, M. V. Santiago Urquiza, R. Rodrigues Faria, N. Machado e Sousa, E. de Souza Módena, R. Macedo Gamarra, and A. L. Martins Rosa. 2008. Tree species composition, structure, and aboveground wood biomass of a riparian forest of the lower Miranda River, southern Pantanal, Brazil. Folia Geobotanica 43(4):397-411 [ER 94]
Geography
Country: Brazil

State: Mato Grosso do Sul


Coordinate: 19° 34' S, 57° 1' W
Coordinate basis: stated in text

Geography comments: "on the lower Miranda river... near the field station of the Universidade Federal de Mato Grosso do Sul (UFMS), southeastern Pantanal"
altitude is for 19º37'35'' S, 57º00'48'' W and is from Pivari et al (2008, Acta Botanica Brasilica)

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

WMT: 27.0

CMT: 21.0

MAP: 1090.0

Dry months: 5

Habitat comments: "seasonally inundated riparian forest" (presumably dry forest)

Methods
Life forms: trees

Sites: 16

Site area: 1

Sample size: 498 individuals

Years: 2007

Size min: 10

Basal area: 47.8

Sampling comments: Sixteen 25×25 m (625 m2) plots in riparian forests of the Miranda river were established in April 2007, totaling an inventoried area of 1 ha (p. 400)

Metadata
Sample number: 232

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-03-25 10:42:53

Modified: 2017-11-10 23:45:58

Abundance distribution
46 species
17 singletons
total count 498
extrapolated richness: 94.6
Fisher's α: 12.365
geometric series k: 0.9055
Hurlbert's PIE: 0.9017
Shannon's H: 2.7709
Good's u: 0.9659
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Inga vera87
Tabebuia heptaphylla53
Ocotea suaveolens51
Helicteres lhotzkyana4
Vitex cymosa16
Cecropia pachystachya73
Pouteria ramiflora5
Erythrina fusca1
Attalea phalerata7
Casearia aculeata2
Erythroxylum anguifugum23
Cassia grandis2
Albizia niopoides4
Alibertia edulis15
Pouteria glomerata14
Vochysia divergens2
Genipa americana66
Copernicia alba4
Trichilia stellatotomentosa2
Celtis pubescens9
Triplaris americana1
Andira inermis8
Combretum laxum1
Tabebuia aurea8
Banara arguta6
Cupania castaneifolia1
Campomanesia eugenioides1
Zygia inaequalis1
Chomelia sp.3
Casearia decandra1
Hymenaea courbaril5
Eugenia florida3
Guazuma ulmifolia1
Ruprechtia sp.2
Tocoyena formosa2
Duguetia sp.3
Maclura tinctoria2
Salacia elliptica1
Neea hermaphrodita1
Cordia glabrata1
Inga uruguensis1
Fagara hassleriana1
Rollinia sp.1
Coccoloba ochreolata1
Mouriri guianensis1
Capparis speciosa1