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=2943 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2943SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2757SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2943 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalurania' AND (junior_species='glaucopis' OR junior_species='glaucopis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thalurania' AND (species='glaucopis' OR species='glaucopis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thalurania' AND (species='glaucopis' OR species='glaucopis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalurania' AND (junior_species='glaucopis' OR junior_species='glaucopis')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='Thalurania' AND (species='glaucopis' OR species='glaucopis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='violacea' OR junior_species='violacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geotrygon' AND (species='violacea' OR species='violacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geotrygon' AND (species='violacea' OR species='violacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='violacea' OR junior_species='violacea')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='Geotrygon' AND (species='violacea' OR species='violacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='maximus' OR junior_species='maximus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='maximus' OR species='maximus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='maximus' OR species='maximus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='maximus' OR junior_species='maximus')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='Saltator' AND (species='maximus' OR species='maximus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopophaga' AND (junior_species='melanops' OR junior_species='melanops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conopophaga' AND (species='melanops' OR species='melanops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conopophaga' AND (species='melanops' OR species='melanops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopophaga' AND (junior_species='melanops' OR junior_species='melanops')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='Conopophaga' AND (species='melanops' OR species='melanops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='turdina' OR junior_species='turdina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocincla' AND (species='turdina' OR species='turdina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocincla' AND (species='turdina' OR species='turdina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='turdina' OR junior_species='turdina')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='Dendrocincla' AND (species='turdina' OR species='turdina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphorynchus' AND (junior_species='spirurus' OR junior_species='spirurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glyphorynchus' AND (species='spirurus' OR species='spirurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glyphorynchus' AND (species='spirurus' OR species='spirurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphorynchus' AND (junior_species='spirurus' OR junior_species='spirurus')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='Glyphorynchus' AND (species='spirurus' OR species='spirurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphorhynchus' AND (species='guttatus' OR species='guttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphorhynchus' AND (species='guttatus' OR species='guttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='guttatus' OR junior_species='guttatus')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='Xiphorhynchus' AND (species='guttatus' OR species='guttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='xanthogaster' OR junior_species='xanthogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='xanthogaster' OR species='xanthogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='xanthogaster' OR species='xanthogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='xanthogaster' OR junior_species='xanthogaster')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='Euphonia' AND (species='xanthogaster' OR species='xanthogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenops' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenops' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenops' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenops' AND (junior_species='minutus' OR junior_species='minutus')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='Xenops' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dixiphia' AND (junior_species='pipra' OR junior_species='pipra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dixiphia' AND (species='pipra' OR species='pipra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dixiphia' AND (species='pipra' OR species='pipra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dixiphia' AND (junior_species='pipra' OR junior_species='pipra')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='Dixiphia' AND (species='pipra' OR species='pipra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manacus' AND (junior_species='manacus' OR junior_species='manacus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manacus' AND (species='manacus' OR species='manacus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manacus' AND (species='manacus' OR species='manacus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manacus' AND (junior_species='manacus' OR junior_species='manacus')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='Manacus' AND (species='manacus' OR species='manacus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymophila' AND (junior_species='squamata' OR junior_species='squamata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymophila' AND (species='squamata' OR species='squamata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymophila' AND (species='squamata' OR species='squamata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymophila' AND (junior_species='squamata' OR junior_species='squamata')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='Drymophila' AND (species='squamata' OR species='squamata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='caesius' OR junior_species='caesius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnomanes' AND (species='caesius' OR species='caesius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnomanes' AND (species='caesius' OR species='caesius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='caesius' OR junior_species='caesius')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='Thamnomanes' AND (species='caesius' OR species='caesius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='leucomelas' OR junior_species='leucomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='leucomelas' OR species='leucomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='leucomelas' OR species='leucomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='leucomelas' OR junior_species='leucomelas')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='Turdus' AND (species='leucomelas' OR species='leucomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='flavogaster' OR junior_species='flavogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='flavogaster' OR species='flavogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='flavogaster' OR species='flavogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='flavogaster' OR junior_species='flavogaster')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='Elaenia' AND (species='flavogaster' OR species='flavogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='oleagineus' OR junior_species='oleagineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mionectes' AND (species='oleagineus' OR species='oleagineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mionectes' AND (species='oleagineus' OR species='oleagineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='oleagineus' OR junior_species='oleagineus')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='Mionectes' AND (species='oleagineus' OR species='oleagineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiobius' AND (junior_species='barbatus' OR junior_species='barbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiobius' AND (species='barbatus' OR species='barbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiobius' AND (species='barbatus' OR species='barbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiobius' AND (junior_species='barbatus' OR junior_species='barbatus')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='Myiobius' AND (species='barbatus' OR species='barbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Florisuga' 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='Florisuga' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Florisuga' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Florisuga' 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='Florisuga' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucis' AND (junior_species='dohrnii' OR junior_species='dohrni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucis' AND (species='dohrnii' OR species='dohrni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucis' AND (species='dohrnii' OR species='dohrni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucis' AND (junior_species='dohrnii' OR junior_species='dohrni')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='Glaucis' AND (species='dohrnii' OR species='dohrni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucis' AND (junior_species='hirsutus' OR junior_species='hirsutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucis' AND (species='hirsutus' OR species='hirsutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucis' AND (species='hirsutus' OR species='hirsutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucis' AND (junior_species='hirsutus' OR junior_species='hirsutus')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='Glaucis' AND (species='hirsutus' OR species='hirsutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='idaliae' OR junior_species='idaliae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='idaliae' OR species='idaliae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='idaliae' OR species='idaliae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='idaliae' OR junior_species='idaliae')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='Phaethornis' AND (species='idaliae' OR species='idaliae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='malaris' OR junior_species='malaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='malaris' OR species='malaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='malaris' OR species='malaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='malaris' OR junior_species='malaris')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='Phaethornis' AND (species='malaris' OR species='malaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Claravis' AND (junior_species='pretiosa' OR junior_species='pretiosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Claravis' AND (species='pretiosa' OR species='pretiosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Claravis' AND (species='pretiosa' OR species='pretiosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Claravis' AND (junior_species='pretiosa' OR junior_species='pretiosa')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='Claravis' AND (species='pretiosa' OR species='pretiosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrastur' AND (junior_species='ruficollis' OR junior_species='ruficollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrastur' AND (species='ruficollis' OR species='ruficollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrastur' AND (species='ruficollis' OR species='ruficollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrastur' AND (junior_species='ruficollis' OR junior_species='ruficollis')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='Micrastur' AND (species='ruficollis' OR species='ruficollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lipaugus' AND (junior_species='vociferans' OR junior_species='vociferans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lipaugus' AND (species='vociferans' OR species='vociferans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lipaugus' AND (species='vociferans' OR species='vociferans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lipaugus' AND (junior_species='vociferans' OR junior_species='vociferans')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='Lipaugus' AND (species='vociferans' OR species='vociferans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='fuscus' OR junior_species='fuscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphorhynchus' AND (species='fuscus' OR species='fuscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphorhynchus' AND (species='fuscus' OR species='fuscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='fuscus' OR junior_species='fuscus')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='Xiphorhynchus' AND (species='fuscus' OR species='fuscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='picus' OR junior_species='picus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphorhynchus' AND (species='picus' OR species='picus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphorhynchus' AND (species='picus' OR species='picus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='picus' OR junior_species='picus')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='Xiphorhynchus' AND (species='picus' OR species='picus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='colma' OR junior_species='colma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicarius' AND (species='colma' OR species='colma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicarius' AND (species='colma' OR species='colma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='colma' OR junior_species='colma')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='Formicarius' AND (species='colma' OR species='colma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='pectoralis' OR junior_species='pectoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='pectoralis' OR species='pectoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='pectoralis' OR species='pectoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='pectoralis' OR junior_species='pectoralis')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='Euphonia' AND (species='pectoralis' OR species='pectoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='violacea' OR junior_species='violacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='violacea' OR species='violacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='violacea' OR species='violacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='violacea' OR junior_species='violacea')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='Euphonia' AND (species='violacea' OR species='violacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='leucophthalmus' OR junior_species='leucophthalmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Automolus' AND (species='leucophthalmus' OR species='leucophthalmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Automolus' AND (species='leucophthalmus' OR species='leucophthalmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='leucophthalmus' OR junior_species='leucophthalmus')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='Automolus' AND (species='leucophthalmus' OR species='leucophthalmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroxiphia' AND (junior_species='caudata' OR junior_species='caudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chiroxiphia' AND (species='caudata' OR species='caudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chiroxiphia' AND (species='caudata' OR species='caudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroxiphia' AND (junior_species='caudata' OR junior_species='caudata')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='Chiroxiphia' AND (species='caudata' OR species='caudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaeropterus' AND (junior_species='regulus' OR junior_species='regulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machaeropterus' AND (species='regulus' OR species='regulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machaeropterus' AND (species='regulus' OR species='regulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaeropterus' AND (junior_species='regulus' OR junior_species='regulus')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='Machaeropterus' AND (species='regulus' OR species='regulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='rubrocapilla' OR junior_species='rubrocapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='rubrocapilla' OR species='rubrocapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='rubrocapilla' OR species='rubrocapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='rubrocapilla' OR junior_species='rubrocapilla')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='Pipra' AND (species='rubrocapilla' OR species='rubrocapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='axillaris' OR junior_species='axillaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='axillaris' OR species='axillaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='axillaris' OR species='axillaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='axillaris' OR junior_species='axillaris')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='Myrmotherula' AND (species='axillaris' OR species='axillaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='minor' OR junior_species='minor')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='Myrmotherula' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='urosticta' OR junior_species='urosticta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='urosticta' OR species='urosticta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='urosticta' OR species='urosticta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='urosticta' OR junior_species='urosticta')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='Myrmotherula' AND (species='urosticta' OR species='urosticta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyriglena' AND (junior_species='leucoptera' OR junior_species='leucoptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyriglena' AND (species='leucoptera' OR species='leucoptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyriglena' AND (species='leucoptera' OR species='leucoptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyriglena' AND (junior_species='leucoptera' OR junior_species='leucoptera')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='Pyriglena' AND (species='leucoptera' OR species='leucoptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='caerulescens' OR junior_species='caerulescens')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='Thamnophilus' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='pelzelni' OR junior_species='pelzelnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='pelzelni' OR species='pelzelnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='pelzelni' OR species='pelzelnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='pelzelni' OR junior_species='pelzelnii')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='Thamnophilus' AND (species='pelzelni' OR species='pelzelnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacnis' AND (junior_species='cayana' OR junior_species='cayana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacnis' AND (species='cayana' OR species='cayana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacnis' AND (species='cayana' OR species='cayana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacnis' AND (junior_species='cayana' OR junior_species='cayana')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='Dacnis' AND (species='cayana' OR species='cayana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='turdina' OR junior_species='turdina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schiffornis' AND (species='turdina' OR species='turdina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schiffornis' AND (species='turdina' OR species='turdina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='turdina' OR junior_species='turdina')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='Schiffornis' AND (species='turdina' OR species='turdina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='amaurochalinus' OR junior_species='amaurochalinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='amaurochalinus' OR junior_species='amaurochalinus')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='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='rufiventris' OR species='rufiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='rufiventris' OR species='rufiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='rufiventris' OR junior_species='rufiventris')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='Turdus' AND (species='rufiventris' OR species='rufiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopogon' AND (junior_species='amaurocephalus' OR junior_species='amaurocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopogon' AND (junior_species='amaurocephalus' OR junior_species='amaurocephalus')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='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='exilis' OR junior_species='exilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picumnus' AND (species='exilis' OR species='exilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picumnus' AND (species='exilis' OR species='exilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='exilis' OR junior_species='exilis')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='Picumnus' AND (species='exilis' OR species='exilis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2943 The Ecological Register: Serra do Condurù State Park
Serra do Condurù State Park
Basic information
Sample name: Serra do Condurù State Park

Reference: M. Ogrzewalska, A. Uezu, and M. B. Labruna. 2011. Ticks (Acari: Ixodidae) infesting wild birds in the Atlantic Forest in northeastern Brazil, with notes on rickettsial infection in ticks. Parasitology Research 108:665-670 [ER 2757]
Geography
Country: Brazil

State: Bahia


Coordinate: 14° 30' 16" S, 39° 6' 36" W
Coordinate basis: stated in text

Geography comments: "located among Ilhéus, Itacaré, and Uruçuca Municipalities"
coordinate is for Serra do Condurù State Park and is from Becknell et al. (2018, Biotropica)

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

Disturbance: hunting,selective logging

MAT: 24.0

MAP: 2000.0

Habitat comments: "Atlantic Forest... The Park is composed of a mosaic of forest patches in different stages of development... the park suffers from timber extraction and hunting"
climate data are for Serra do Condurù State Park and are from Becknell et al. (2018, Biotropica)

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 232 individuals

Days: 6

Nets or traps: 20

Net or trap nights: 120

Sampling comments: "Two bird captures were performed between 16 and 21 May, and between 14 and 18 June 2009. For this purpose, 20 mist nets (12 m longx2 m wide, 36 mm mesh) were displayed along human and animal trails within three forest areas (two work-days per area). In each area, mist nets were left open from 6:00 a.m. to 5:00 p.m. in the first day and from 6:00 a.m. to 12:00 p.m. on the second day" and birds "were marked by cutting head feathers in order to verify any recapture, which was not considered in the counting"

Metadata
Sample number: 2943

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-05-03 20:08:45

Modified: 2018-05-03 10:08:45

Abundance distribution
46 species
16 singletons
total count 232
extrapolated richness: 97.9
Fisher's α: 17.211
geometric series k: 0.9189
Hurlbert's PIE: 0.9252
Shannon's H: 3.1474
Good's u: 0.9314
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Thalurania glaucopis44.8 g nectarivore
Geotrygon violacea195.2 g granivore
Saltator maximus146.2 g frugivore-folivore
Conopophaga melanops920.1 g insectivore
Dendrocincla turdina439.0 g insectivore
Glyphorynchus spirurus2314.6 g insectivore
Xiphorhynchus guttatus27.8 g frugivore-insectivore
Euphonia xanthogaster113.0 g frugivore
Xenops minutus810.6 g frugivore-insectivore
Dixiphia pipra45
Manacus manacus26 frugivore
Drymophila squamata810.8 g insectivore
Thamnomanes caesius415.7 g frugivore-insectivore
Turdus leucomelas1169.1 g frugivore-insectivore
Elaenia flavogaster124.8 g insectivore-frugivore
Mionectes oleagineus32.3 g insectivore-frugivore
Myiobius barbatus911.4 g frugivore-insectivore
Florisuga fusca1 nectarivore
Glaucis dohrnii75.8 g
Glaucis hirsutus12.0 g nectarivore
Phaethornis idaliae12.6 g
Phaethornis malaris margarettae25.9 g nectarivore
"Phaethornis margarettae"
Claravis pretiosa168.2 g granivore-frugivore
Micrastur ruficollis2161 g carnivore-insectivore
Lipaugus vociferans28.3 g frugivore-insectivore
Xiphorhynchus fuscus221.8 g insectivore
Xiphorhynchus picus16.2 g insectivore
Formicarius colma147.0 g insectivore
Euphonia pectoralis414.4 g frugivore
Euphonia violacea215.0 g frugivore
Automolus leucophthalmus334.5 g insectivore
Chiroxiphia caudata525.6 g frugivore
Machaeropterus regulus109.6 g frugivore
Pipra rubrocapilla412.0 g frugivore
Myrmotherula axillaris22.8 g frugivore-insectivore
Myrmotherula minor16.4 g
Myrmotherula urosticta5
Pyriglena leucoptera228.8 g insectivore
Thamnophilus caerulescens121.1 g insectivore
Thamnophilus pelzelni120.9 g insectivore
Dacnis cayana113.0 g frugivore
Schiffornis turdina331.7 g insectivore
Turdus amaurochalinus257.9 g insectivore-frugivore
Turdus rufiventris366.8 g frugivore-insectivore
Leptopogon amaurocephalus111.7 g insectivore-frugivore
Picumnus exilis19.3 g