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=742 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=742SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=399SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=742 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='parnellii' OR junior_species='parnelli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pteronotus' AND (species='parnellii' OR species='parnelli') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='parnellii' OR junior_species='parnelli')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pteronotus' AND (species='parnellii' OR species='parnelli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='brevicauda' OR junior_species='brevicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carollia' AND (species='brevicauda' OR species='brevicauda') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='brevicauda' OR junior_species='brevicauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carollia' AND (species='brevicauda' OR species='brevicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnira' AND (junior_species='lilium' OR junior_species='lilium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnira' AND (species='lilium' OR species='lilium') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnira' AND (junior_species='lilium' OR junior_species='lilium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sturnira' AND (species='lilium' OR species='lilium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artibeus' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='phaeotis' OR junior_species='phaeotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='phaeotis' OR species='phaeotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='phaeotis' OR junior_species='phaeotis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artibeus' AND (species='phaeotis' OR species='phaeotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyrodes' AND (junior_species='caraccioli' OR junior_species='caracciolii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vampyrodes' AND (species='caraccioli' OR species='caracciolii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyrodes' AND (junior_species='caraccioli' OR junior_species='caracciolii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vampyrodes' AND (species='caraccioli' OR species='caracciolii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='toltecus' OR junior_species='toltecus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='toltecus' OR species='toltecus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='toltecus' OR junior_species='toltecus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artibeus' AND (species='toltecus' OR species='toltecus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='soricina' OR junior_species='soricina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glossophaga' AND (species='soricina' OR species='soricina') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glossophaga' AND (junior_species='soricina' OR junior_species='soricina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glossophaga' AND (species='soricina' OR species='soricina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choeroniscus' AND (junior_species='godmani' OR junior_species='godmanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Choeroniscus' AND (species='godmani' OR species='godmanii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choeroniscus' AND (junior_species='godmani' OR junior_species='godmanii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Choeroniscus' AND (species='godmani' OR species='godmanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='helleri' OR junior_species='hellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrrhinus' AND (species='helleri' OR species='hellerii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrrhinus' AND (junior_species='helleri' OR junior_species='hellerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platyrrhinus' AND (species='helleri' OR species='hellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='lituratus' OR junior_species='lituratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='lituratus' OR species='lituratus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='lituratus' OR junior_species='lituratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artibeus' AND (species='lituratus' OR species='lituratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmodus' AND (junior_species='rotundus' OR junior_species='rotundus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmodus' AND (species='rotundus' OR species='rotundus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmodus' AND (junior_species='rotundus' OR junior_species='rotundus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Desmodus' AND (species='rotundus' OR species='rotundus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='perspicillata' OR junior_species='perspicillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carollia' AND (species='perspicillata' OR species='perspicillata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carollia' AND (junior_species='perspicillata' OR junior_species='perspicillata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carollia' AND (species='perspicillata' OR species='perspicillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mormoops' AND (junior_species='megalophylla' OR junior_species='megalophylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mormoops' AND (species='megalophylla' OR species='megalophylla') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mormoops' AND (junior_species='megalophylla' OR junior_species='megalophylla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mormoops' AND (species='megalophylla' OR species='megalophylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllostomus' AND (junior_species='discolor' OR junior_species='discolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllostomus' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllostomus' AND (junior_species='discolor' OR junior_species='discolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phyllostomus' AND (species='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='bilobatum' OR junior_species='bilobatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uroderma' AND (species='bilobatum' OR species='bilobatum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uroderma' AND (junior_species='bilobatum' OR junior_species='bilobatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Uroderma' AND (species='bilobatum' OR species='bilobatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnira' AND (junior_species='ludovici' OR junior_species='ludovicii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnira' AND (species='ludovici' OR species='ludovicii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnira' AND (junior_species='ludovici' OR junior_species='ludovicii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sturnira' AND (species='ludovici' OR species='ludovicii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyressa' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vampyressa' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyressa' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vampyressa' AND (species='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='davyi' OR junior_species='davyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pteronotus' AND (species='davyi' OR species='davyii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pteronotus' AND (junior_species='davyi' OR junior_species='davyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pteronotus' AND (species='davyi' OR species='davyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='watsoni' OR junior_species='watsonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artibeus' AND (species='watsoni' OR species='watsonii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artibeus' AND (junior_species='watsoni' OR junior_species='watsonii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artibeus' AND (species='watsoni' OR species='watsonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroderma' AND (junior_species='villosum' OR junior_species='villosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chiroderma' AND (species='villosum' OR species='villosum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroderma' AND (junior_species='villosum' OR junior_species='villosum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chiroderma' AND (species='villosum' OR species='villosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saccopteryx' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saccopteryx' AND (species='bilineata' OR species='bilineata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saccopteryx' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Saccopteryx' AND (species='bilineata' OR species='bilineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampronycteris' AND (junior_species='brachyotis' OR junior_species='brachyotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampronycteris' AND (species='brachyotis' OR species='brachyotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampronycteris' AND (junior_species='brachyotis' OR junior_species='brachyotis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lampronycteris' AND (species='brachyotis' OR species='brachyotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimon' AND (junior_species='bennettii' OR junior_species='bennetti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimon' AND (species='bennettii' OR species='bennetti') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimon' AND (junior_species='bennettii' OR junior_species='bennetti')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mimon' AND (species='bennettii' OR species='bennetti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauerus' AND (junior_species='dubiaquercus' OR junior_species='dubiaquercus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bauerus' AND (species='dubiaquercus' OR species='dubiaquercus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bauerus' AND (junior_species='dubiaquercus' OR junior_species='dubiaquercus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bauerus' AND (species='dubiaquercus' OR species='dubiaquercus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyrum' AND (junior_species='spectrum' OR junior_species='spectrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vampyrum' AND (species='spectrum' OR species='spectrum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vampyrum' AND (junior_species='spectrum' OR junior_species='spectrum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vampyrum' AND (species='spectrum' OR species='spectrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centurio' AND (junior_species='senex' OR junior_species='senex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centurio' AND (species='senex' OR species='senex') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centurio' AND (junior_species='senex' OR junior_species='senex')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centurio' AND (species='senex' OR species='senex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natalus' AND (junior_species='stramineus' OR junior_species='stramineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Natalus' AND (species='stramineus' OR species='stramineus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natalus' AND (junior_species='stramineus' OR junior_species='stramineus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Natalus' AND (species='stramineus' OR species='stramineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachops' AND (junior_species='cirrhosus' OR junior_species='cirrhosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachops' AND (species='cirrhosus' OR species='cirrhosus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachops' AND (junior_species='cirrhosus' OR junior_species='cirrhosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachops' AND (species='cirrhosus' OR species='cirrhosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micronycteris' AND (junior_species='megalotis' OR junior_species='megalotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micronycteris' AND (species='megalotis' OR species='megalotis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micronycteris' AND (junior_species='megalotis' OR junior_species='megalotis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micronycteris' AND (species='megalotis' OR species='megalotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyroptera' AND (junior_species='tricolor' OR junior_species='tricolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thyroptera' AND (species='tricolor' OR species='tricolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyroptera' AND (junior_species='tricolor' OR junior_species='tricolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thyroptera' AND (species='tricolor' OR species='tricolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diclidurus' AND (junior_species='albus' OR junior_species='albus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diclidurus' AND (species='albus' OR species='albus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diclidurus' AND (junior_species='albus' OR junior_species='albus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diclidurus' AND (species='albus' OR species='albus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylonycteris' AND (junior_species='underwoodi' OR junior_species='underwoodii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylonycteris' AND (species='underwoodi' OR species='underwoodii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylonycteris' AND (junior_species='underwoodi' OR junior_species='underwoodii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylonycteris' AND (species='underwoodi' OR species='underwoodii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptonycteris' AND (junior_species='nivalis' OR junior_species='nivalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptonycteris' AND (species='nivalis' OR species='nivalis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptonycteris' AND (junior_species='nivalis' OR junior_species='nivalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptonycteris' AND (species='nivalis' OR species='nivalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphonycteris' AND (junior_species='sylvestris' OR junior_species='sylvestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glyphonycteris' AND (species='sylvestris' OR species='sylvestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glyphonycteris' AND (species='sylvestris' OR species='sylvestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphonycteris' AND (junior_species='sylvestris' OR junior_species='sylvestris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glyphonycteris' AND (species='sylvestris' OR species='sylvestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctilio' AND (junior_species='leporinus' OR junior_species='leporinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctilio' AND (species='leporinus' OR species='leporinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctilio' AND (junior_species='leporinus' OR junior_species='leporinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctilio' AND (species='leporinus' OR species='leporinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophostoma' AND (junior_species='brasiliense' OR junior_species='brasiliense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophostoma' AND (species='brasiliense' OR species='brasiliense') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophostoma' AND (junior_species='brasiliense' OR junior_species='brasiliense')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lophostoma' AND (species='brasiliense' OR species='brasiliense') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=742 The Ecological Register: Los Tuxtlas Biological Research Station (forest fragment bats)
Los Tuxtlas Biological Research Station (forest fragment bats)
Basic information
Sample name: Los Tuxtlas Biological Research Station (forest fragment bats)

Reference: A. Estrada and R. Coates-Estrada. 2001. Species composition and reproductive phenology of bats in a tropical landscape at Los Tuxtlas, Mexico. Journal of Tropical Ecology 17:627-646 [ER 399]
Geography
Country: Mexico

State: Veracruz


Coordinate: 18° 25' N, 95° 0' W
Coordinate basis: stated in text

Geography comments: elevation from zero to 300 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: fragment

Protection: biosphere reserve

Substrate: ground surface

MAT: 27.0

MAP: 4900.0

Habitat comments: "A 90-km 2 landscape, originally occupied by rain forest, consisted of forest fragments and natural corridors of vegetation surrounded by pasturelands"
forest fragments ranged "in area from 1 to 200 ha (median = 18 ha, average = 35±39 ha)"

Methods
Life forms: bats

Sites: 52

Sampling methods: no design,mist nets

Sample size: 2098 individuals

Years: 1996 - 1998

Net or trap nights: 208

Sampling comments: site count is of forest fragments
208 sample nights and 1040 net hours

Metadata
Sample number: 742

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-04 17:36:46

Modified: 2020-06-05 06:47:32

Abundance distribution
37 species
2 singletons
total count 2098
extrapolated richness: 45.8
Fisher's α: 6.381
geometric series k: 0.8424
Hurlbert's PIE: 0.8823
Shannon's H: 2.5729
Good's u: 0.9990
Each square represents a species. Square sizes are proportional to counts.
Register
Pteronotus parnellii36319.1 g insectivore
Carollia brevicauda48017.4 g frugivore
Sturnira lilium25118.7 g frugivore
Artibeus jamaicensis18548.0 g frugivore
Artibeus phaeotis15513.1 g frugivore
"Dermanura phaeotis"
Vampyrodes caraccioli2336.0 g frugivore
Artibeus toltecus9616.3 g frugivore
"Dermanura tolteca"
Glossophaga soricina9710.5 g frugivore-nectarivore
Choeroniscus godmani619.9 g nectarivore
Platyrrhinus helleri4715.6 g frugivore
Artibeus lituratus5768.5 g frugivore
Desmodus rotundus4133.5 g sanguinivore
Carollia perspicillata3619.6 g frugivore
Mormoops megalophylla2415.1 g insectivore
Phyllostomus discolor1940.3 g nectarivore-frugivore
Uroderma bilobatum2318.1 g frugivore
Sturnira ludovici2125.0 g frugivore
Vampyressa pusilla149.0 g frugivore
Pteronotus davyi88.1 g insectivore
Artibeus watsoni1412.2 g frugivore
"Dermanura watsoni"
Chiroderma villosum1123.4 g frugivore
Saccopteryx bilineata77.9 g insectivore
Lampronycteris brachyotis512.0 g insectivore-carnivore
"Micronycteris brachyotis"
Mimon bennettii1431.1 g insectivore
Bauerus dubiaquercus1115.7 g insectivore
"Antrozous dubiaquercus"
Vampyrum spectrum2169 g insectivore-carnivore
Centurio senex619.0 g frugivore
Natalus stramineus55.3 g insectivore
Trachops cirrhosus731.4 g insectivore-carnivore
Micronycteris megalotis16.4 g insectivore-carnivore
Thyroptera tricolor34.3 g insectivore
Diclidurus albus218.3 g insectivore
Hylonycteris underwoodi27.8 g nectarivore
Leptonycteris nivalis123.0 g nectarivore
Glyphonycteris sylvestris2 insectivore-carnivore
"Micronycteris sylvestris"
Noctilio leporinus263.3 g insectivore-piscivore
Lophostoma brasiliense210.2 g insectivore-carnivore
"Tonatia brasiliense"