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=1371 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1371SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=912SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1371 ORDER BY register_no ASCSELECT 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='Leptotila' AND (junior_species='verreauxi' OR junior_species='verreauxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotila' AND (species='verreauxi' OR species='verreauxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotila' AND (species='verreauxi' OR species='verreauxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='verreauxi' OR junior_species='verreauxii')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='Leptotila' AND (species='verreauxi' OR species='verreauxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='eurynome' OR junior_species='eurynome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='eurynome' OR species='eurynome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='eurynome' OR species='eurynome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='eurynome' OR junior_species='eurynome')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='eurynome' OR species='eurynome') ORDER BY year,last_namesSELECT 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='Trogon' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogon' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogon' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='rufus' OR junior_species='rufus')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='Trogon' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='cirratus' OR junior_species='cirratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picumnus' AND (species='cirratus' OR species='cirratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picumnus' AND (species='cirratus' OR species='cirratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='cirratus' OR junior_species='cirratus')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='cirratus' OR species='cirratus') 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='Dysithamnus' AND (junior_species='mentalis' OR junior_species='mentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysithamnus' AND (species='mentalis' OR species='mentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysithamnus' AND (species='mentalis' OR species='mentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysithamnus' AND (junior_species='mentalis' OR junior_species='mentalis')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='Dysithamnus' AND (species='mentalis' OR species='mentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymophila' AND (junior_species='ochropyga' OR junior_species='ochropyga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymophila' AND (species='ochropyga' OR species='ochropyga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymophila' AND (species='ochropyga' OR species='ochropyga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymophila' AND (junior_species='ochropyga' OR junior_species='ochropyga')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='ochropyga' OR species='ochropyga') 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='Myrmeciza' AND (junior_species='squamosa' OR junior_species='squamosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmeciza' AND (species='squamosa' OR species='squamosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmeciza' AND (species='squamosa' OR species='squamosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeciza' AND (junior_species='squamosa' OR junior_species='squamosa')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='Myrmeciza' AND (species='squamosa' OR species='squamosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopophaga' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conopophaga' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conopophaga' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopophaga' AND (junior_species='lineata' OR junior_species='lineata')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='lineata' OR species='lineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaeza' AND (junior_species='campanisona' OR junior_species='campanisona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chamaeza' AND (species='campanisona' OR species='campanisona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chamaeza' AND (species='campanisona' OR species='campanisona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaeza' AND (junior_species='campanisona' OR junior_species='campanisona')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='Chamaeza' AND (species='campanisona' OR species='campanisona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='scansor' OR junior_species='scansor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclerurus' AND (species='scansor' OR species='scansor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerurus' AND (species='scansor' OR species='scansor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='scansor' OR junior_species='scansor')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='Sclerurus' AND (species='scansor' OR species='scansor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sittasomus' AND (junior_species='griseicapillus' OR junior_species='griseicapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sittasomus' AND (species='griseicapillus' OR species='griseicapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sittasomus' AND (species='griseicapillus' OR species='griseicapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sittasomus' AND (junior_species='griseicapillus' OR junior_species='griseicapillus')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='Sittasomus' AND (species='griseicapillus' OR species='griseicapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocolaptes' AND (junior_species='platyrostris' OR junior_species='platyrostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocolaptes' AND (species='platyrostris' OR species='platyrostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocolaptes' AND (species='platyrostris' OR species='platyrostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocolaptes' AND (junior_species='platyrostris' OR junior_species='platyrostris')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='Dendrocolaptes' AND (species='platyrostris' OR species='platyrostris') 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='Synallaxis' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synallaxis' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synallaxis' AND (species='ruficapilla' OR species='ruficapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')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='Synallaxis' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syndactyla' AND (junior_species='rufosuperciliata' OR junior_species='rufosuperciliata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syndactyla' AND (species='rufosuperciliata' OR species='rufosuperciliata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syndactyla' AND (species='rufosuperciliata' OR species='rufosuperciliata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syndactyla' AND (junior_species='rufosuperciliata' OR junior_species='rufosuperciliata')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='Syndactyla' AND (species='rufosuperciliata' OR species='rufosuperciliata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='atricapillus' OR junior_species='atricapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philydor' AND (species='atricapillus' OR species='atricapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philydor' AND (species='atricapillus' OR species='atricapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='atricapillus' OR junior_species='atricapillus')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='Philydor' AND (species='atricapillus' OR species='atricapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='rufum' OR junior_species='rufum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philydor' AND (species='rufum' OR species='rufum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philydor' AND (species='rufum' OR species='rufum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='rufum' OR junior_species='rufum')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='Philydor' AND (species='rufum' OR species='rufum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lochmias' AND (junior_species='nematura' OR junior_species='nematura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lochmias' AND (species='nematura' OR species='nematura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lochmias' AND (species='nematura' OR species='nematura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lochmias' AND (junior_species='nematura' OR junior_species='nematura')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='Lochmias' AND (species='nematura' OR species='nematura') 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='Mionectes' 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='Mionectes' AND (species='rufiventris' OR species='rufiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mionectes' AND (species='rufiventris' OR species='rufiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' 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='Mionectes' 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='Hemitriccus' AND (junior_species='diops' OR junior_species='diops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemitriccus' AND (species='diops' OR species='diops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemitriccus' AND (species='diops' OR species='diops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='diops' OR junior_species='diops')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='Hemitriccus' AND (species='diops' OR species='diops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='orbitatus' OR junior_species='orbitatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemitriccus' AND (species='orbitatus' OR species='orbitatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemitriccus' AND (species='orbitatus' OR species='orbitatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='orbitatus' OR junior_species='orbitatus')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='Hemitriccus' AND (species='orbitatus' OR species='orbitatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tolmomyias' AND (junior_species='sulphurescens' OR junior_species='sulphurescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tolmomyias' AND (species='sulphurescens' OR species='sulphurescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tolmomyias' AND (species='sulphurescens' OR species='sulphurescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tolmomyias' AND (junior_species='sulphurescens' OR junior_species='sulphurescens')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='Tolmomyias' AND (species='sulphurescens' OR species='sulphurescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='mystaceus' OR junior_species='mystaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrinchus' AND (species='mystaceus' OR species='mystaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyrinchus' AND (species='mystaceus' OR species='mystaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='mystaceus' OR junior_species='mystaceus')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='Platyrinchus' AND (species='mystaceus' OR species='mystaceus') 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='Cnemotriccus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemotriccus' AND (junior_species='fuscatus' OR junior_species='fuscatus')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='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attila' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Attila' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Attila' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attila' AND (junior_species='rufus' OR junior_species='rufus')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='Attila' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopelma' AND (junior_species='chrysolophum' OR junior_species='chrysolophum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neopelma' AND (species='chrysolophum' OR species='chrysolophum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neopelma' AND (species='chrysolophum' OR species='chrysolophum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopelma' AND (junior_species='chrysolophum' OR junior_species='chrysolophum')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='Neopelma' AND (species='chrysolophum' OR species='chrysolophum') 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='Schiffornis' AND (junior_species='virescens' OR junior_species='virescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schiffornis' AND (species='virescens' OR species='virescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schiffornis' AND (species='virescens' OR species='virescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='virescens' OR junior_species='virescens')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='virescens' OR species='virescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycichla' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platycichla' AND (species='flavipes' OR species='flavipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycichla' AND (species='flavipes' OR species='flavipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycichla' AND (junior_species='flavipes' OR junior_species='flavipes')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='Platycichla' AND (species='flavipes' OR species='flavipes') 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='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='albicollis' OR junior_species='albicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='albicollis' OR junior_species='albicollis')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='albicollis' OR species='albicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichothraupis' 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='Trichothraupis' AND (species='melanops' OR species='melanops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichothraupis' AND (species='melanops' OR species='melanops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichothraupis' 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='Trichothraupis' AND (species='melanops' OR species='melanops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habia' AND (junior_species='rubica' OR junior_species='rubica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Habia' AND (species='rubica' OR species='rubica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Habia' AND (species='rubica' OR species='rubica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habia' AND (junior_species='rubica' OR junior_species='rubica')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='Habia' AND (species='rubica' OR species='rubica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyphonus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyphonus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='coronatus' OR junior_species='coronatus')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='Tachyphonus' AND (species='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplospiza' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplospiza' AND (species='unicolor' OR species='unicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplospiza' AND (species='unicolor' OR species='unicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplospiza' AND (junior_species='unicolor' OR junior_species='unicolor')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='Haplospiza' AND (species='unicolor' OR species='unicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='similis' OR junior_species='similis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='similis' OR junior_species='similis')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='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='culicivorus' OR junior_species='culicivorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='culicivorus' OR species='culicivorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='culicivorus' OR species='culicivorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='culicivorus' OR junior_species='culicivorus')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='Basileuterus' AND (species='culicivorus' OR species='culicivorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='leucoblepharus' OR junior_species='leucoblepharus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='leucoblepharus' OR species='leucoblepharus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='leucoblepharus' OR species='leucoblepharus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='leucoblepharus' OR junior_species='leucoblepharus')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='Basileuterus' AND (species='leucoblepharus' OR species='leucoblepharus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1371 The Ecological Register: Reserva Florestal do Morro Grande
Reserva Florestal do Morro Grande
Basic information
Sample name: Reserva Florestal do Morro Grande

Reference: P. F. Develey and A. C. Martensen. 2006. As aves da Reserva Florestal do Morro Grande (Cotia, SP). Biota Neotropica 6(2):1-16 [ER 912]
Geography
Country: Brazil

State: Säo Paulo


Coordinate: 23° 43' 30" S, 46° 51' 0" W
Coordinate basis: stated in text as range

Geography comments: in the municipality of Cotia
coordinate is the midpoint of ranges stated in the text

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

WMT: 22.9

CMT: 15.7

MAP: 1661.0

Habitat comments: Atlantic Forest (presumed to be dry because the site is within the Säo Paulo metropolitan area and Säo Paulo receives a modest amount of rainfall)
secondary vegetation (one nearby 60 ha plot of primary vegetation was not sampled by mist netting)
climate data based on station 83781

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 636 captures or sightings

Nets or traps: 10

Net or trap nights: 358

Sampling comments: ten 12 x 2.5 m 36 mm mesh nets deployed six hours a day once a month over nine months for a total of 2147 net hours (= 358 net days)

Metadata
Sample number: 1371

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-24 14:09:52

Modified: 2015-09-27 06:34:27

Abundance distribution
46 species
6 singletons
total count 636
extrapolated richness: 64.2
Fisher's α: 11.384
geometric series k: 0.9082
Hurlbert's PIE: 0.9426
Shannon's H: 3.2112
Good's u: 0.9906
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Micrastur ruficollis4161 g carnivore-insectivore
Leptotila verreauxi111.6 g granivore-frugivore
Phaethornis eurynome195.3 g nectarivore
Thalurania glaucopis94.8 g nectarivore
Trogon rufus153.8 g insectivore-frugivore
Picumnus cirratus110.2 g insectivore
Thamnophilus caerulescens221.1 g insectivore
Dysithamnus mentalis152.4 g insectivore
Drymophila ochropyga110.5 g insectivore
Pyriglena leucoptera2428.8 g insectivore
Myrmeciza squamosa218.5 g insectivore
Conopophaga lineata185.5 g insectivore
Chamaeza campanisona39.1 g insectivore
Sclerurus scansor1836.9 g insectivore
Sittasomus griseicapillus422.6 g insectivore
Dendrocolaptes platyrostris361.7 g insectivore
Xiphorhynchus fuscus2921.8 g insectivore
Synallaxis ruficapilla313.8 g insectivore
Syndactyla rufosuperciliata525.6 g insectivore
Philydor atricapillus822.2 g insectivore
Philydor rufum425.0 g insectivore
Lochmias nematura122.0 g insectivore
Xenops minutus410.6 g frugivore-insectivore
Mionectes rufiventris413.3 g insectivore-frugivore
Leptopogon amaurocephalus311.7 g insectivore-frugivore
Hemitriccus diops1310.0 g insectivore
Hemitriccus orbitatus139.7 g insectivore
Tolmomyias sulphurescens214.3 g insectivore
Platyrinchus mystaceus349.7 g insectivore
Myiobius barbatus811.4 g frugivore-insectivore
Cnemotriccus fuscatus413.6 g insectivore
Attila rufus142.6 g insectivore
Neopelma chrysolophum7
Chiroxiphia caudata7625.6 g frugivore
Schiffornis virescens2625.6 g insectivore
Platycichla flavipes98.0 g frugivore-insectivore
Turdus rufiventris1366.8 g frugivore-insectivore
Turdus amaurochalinus357.9 g insectivore-frugivore
Turdus albicollis4954.0 g insectivore-frugivore
Trichothraupis melanops5224.3 g insectivore-frugivore
Habia rubica234.0 g insectivore-frugivore
Tachyphonus coronatus1129.3 g omnivore
Haplospiza unicolor915.9 g granivore
Saltator similis743.3 g insectivore-frugivore
Basileuterus culicivorus410.5 g insectivore-frugivore
Basileuterus leucoblepharus6915.1 g insectivore