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=1092 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1092SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=756SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1092 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenaida' AND (junior_species='asiatica' OR junior_species='asiatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zenaida' AND (species='asiatica' OR species='asiatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zenaida' AND (species='asiatica' OR species='asiatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenaida' AND (junior_species='asiatica' OR junior_species='asiatica')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='Zenaida' AND (species='asiatica' OR species='asiatica') 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='Glaucidium' AND (junior_species='brasilianum' OR junior_species='brasilianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucidium' AND (species='brasilianum' OR species='brasilianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucidium' AND (species='brasilianum' OR species='brasilianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucidium' AND (junior_species='brasilianum' OR junior_species='brasilianum')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='Glaucidium' AND (species='brasilianum' OR species='brasilianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='melanocephalus' OR junior_species='melanocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogon' AND (species='melanocephalus' OR species='melanocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogon' AND (species='melanocephalus' OR species='melanocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='melanocephalus' OR junior_species='melanocephalus')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='melanocephalus' OR species='melanocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' AND (junior_species='aenea' OR junior_species='aenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloroceryle' AND (species='aenea' OR species='aenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroceryle' AND (species='aenea' OR species='aenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' AND (junior_species='aenea' OR junior_species='aenea')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='Chloroceryle' AND (species='aenea' OR species='aenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanerpes' AND (junior_species='aurifrons' OR junior_species='aurifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanerpes' AND (species='aurifrons' OR species='aurifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanerpes' AND (species='aurifrons' OR species='aurifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanerpes' AND (junior_species='aurifrons' OR junior_species='aurifrons')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='Melanerpes' AND (species='aurifrons' OR species='aurifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='anabatina' OR junior_species='anabatina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocincla' AND (species='anabatina' OR species='anabatina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocincla' AND (species='anabatina' OR species='anabatina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='anabatina' OR junior_species='anabatina')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='anabatina' OR species='anabatina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphorhynchus' 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='Glyphorhynchus' AND (species='spirurus' OR species='spirurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glyphorhynchus' AND (species='spirurus' OR species='spirurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphorhynchus' 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='Glyphorhynchus' 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='flavigaster' OR junior_species='flavigaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphorhynchus' AND (species='flavigaster' OR species='flavigaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphorhynchus' AND (species='flavigaster' OR species='flavigaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='flavigaster' OR junior_species='flavigaster')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='flavigaster' OR species='flavigaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='souleyetii' OR junior_species='souleyeti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidocolaptes' AND (species='souleyetii' OR species='souleyeti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidocolaptes' AND (species='souleyetii' OR species='souleyeti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='souleyetii' OR junior_species='souleyeti')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='Lepidocolaptes' AND (species='souleyetii' OR species='souleyeti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='analis' OR junior_species='analis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicarius' AND (species='analis' OR species='analis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicarius' AND (species='analis' OR species='analis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='analis' OR junior_species='analis')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='analis' OR species='analis') 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='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='Onychorhynchus' 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='Onychorhynchus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychorhynchus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychorhynchus' 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='Onychorhynchus' AND (species='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attila' AND (junior_species='spadiceus' OR junior_species='spadiceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Attila' AND (species='spadiceus' OR species='spadiceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Attila' AND (species='spadiceus' OR species='spadiceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attila' AND (junior_species='spadiceus' OR junior_species='spadiceus')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='spadiceus' OR species='spadiceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tuberculifer' OR junior_species='tuberculifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='tuberculifer' OR species='tuberculifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='tuberculifer' OR species='tuberculifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tuberculifer' OR junior_species='tuberculifer')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='Myiarchus' AND (species='tuberculifer' OR species='tuberculifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tyrannulus' OR junior_species='tyrannulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tyrannulus' OR junior_species='tyrannulus')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='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryothorus' AND (junior_species='maculipectus' OR junior_species='maculipectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thryothorus' AND (species='maculipectus' OR species='maculipectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thryothorus' AND (species='maculipectus' OR species='maculipectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryothorus' AND (junior_species='maculipectus' OR junior_species='maculipectus')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='Thryothorus' AND (species='maculipectus' OR species='maculipectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='grayi' OR junior_species='grayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='grayi' OR species='grayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='grayi' OR species='grayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='grayi' OR junior_species='grayii')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='grayi' OR species='grayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='corvina' OR junior_species='corvina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='corvina' OR species='corvina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='corvina' OR species='corvina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='corvina' OR junior_species='corvina')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='Sporophila' AND (species='corvina' OR species='corvina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='torqueola' OR junior_species='torqueola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='torqueola' OR species='torqueola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='torqueola' OR species='torqueola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='torqueola' OR junior_species='torqueola')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='Sporophila' AND (species='torqueola' OR species='torqueola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='aurantiirostris' OR junior_species='aurantiirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arremon' AND (species='aurantiirostris' OR species='aurantiirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremon' AND (species='aurantiirostris' OR species='aurantiirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='aurantiirostris' OR junior_species='aurantiirostris')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='Arremon' AND (species='aurantiirostris' OR species='aurantiirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremonops' AND (junior_species='chloronotus' OR junior_species='chloronotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arremonops' AND (species='chloronotus' OR species='chloronotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremonops' AND (species='chloronotus' OR species='chloronotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremonops' AND (junior_species='chloronotus' OR junior_species='chloronotus')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='Arremonops' AND (species='chloronotus' OR species='chloronotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='atriceps' OR junior_species='atriceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='atriceps' OR species='atriceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='atriceps' OR species='atriceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='atriceps' OR junior_species='atriceps')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='atriceps' OR species='atriceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='coerulescens' OR junior_species='coerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='coerulescens' OR species='coerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='coerulescens' OR species='coerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='coerulescens' OR junior_species='coerulescens')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='coerulescens' OR species='coerulescens') 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='Passerina' AND (junior_species='cyanoides' OR junior_species='cyanoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passerina' AND (species='cyanoides' OR species='cyanoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passerina' AND (species='cyanoides' OR species='cyanoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='cyanoides' OR junior_species='cyanoides')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='Passerina' AND (species='cyanoides' OR species='cyanoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habia' AND (junior_species='fuscicauda' OR junior_species='fuscicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Habia' AND (species='fuscicauda' OR species='fuscicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Habia' AND (species='fuscicauda' OR species='fuscicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habia' AND (junior_species='fuscicauda' OR junior_species='fuscicauda')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='fuscicauda' OR species='fuscicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='hirundinacea' OR junior_species='hirundinacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='hirundinacea' OR species='hirundinacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='hirundinacea' OR species='hirundinacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='hirundinacea' OR junior_species='hirundinacea')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='hirundinacea' OR species='hirundinacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocorax' AND (junior_species='morio' OR junior_species='morio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanocorax' AND (species='morio' OR species='morio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanocorax' AND (species='morio' OR species='morio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocorax' AND (junior_species='morio' OR junior_species='morio')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='Cyanocorax' AND (species='morio' OR species='morio') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1092 The Ecological Register: Palenque National Park (control sites)
Palenque National Park (control sites)
Basic information
Sample name: Palenque National Park (control sites)

Reference: A. Ibarra-Macias, W. D. Robinson, and M. S. Gaines. 2011. Forest corridors facilitate movement of tropical forest birds after experimental translocations in a fragmented Neotropical landscape in Mexico. Journal of Tropical Ecology 27(5):547-556 [ER 756]
Geography
Country: Mexico

State: Chiapas


Coordinate: 18° 28' 58" N, 92° 3' 6" W
Coordinate basis: stated in text as range

Geography comments: coordinate is midpoint of ranges given in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: national/state park

Substrate: ground surface

MAT: 26.0

WMT: 29.0

CMT: 22.0

MAP: 2168.0

Habitat comments: "primary rain forest"

Methods
Life forms: birds

Sites: 10

Sampling methods: mist nets

Sample size: 143 individuals

Years: 2008, 2009

Days: 11

Nets or traps: 10

Net or trap nights: 110

Sampling comments: "up to 10 mist nets (12 × 2.5 m, 30-mm mesh size)" were used (assumed to actually be 10)
overall sampling effort was 34 days spread across three treatments (assumed to be 11 per treatment)

Metadata
Sample number: 1092

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-25 14:45:06

Modified: 2014-08-25 04:49:30

Abundance distribution
30 species
14 singletons
total count 143
extrapolated richness: 72.8
Fisher's α: 11.575
geometric series k: 0.8989
Hurlbert's PIE: 0.9223
Shannon's H: 2.8521
Good's u: 0.9024
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Zenaida asiatica1153 g granivore-frugivore
Leptotila verreauxi1211.6 g granivore-frugivore
Glaucidium brasilianum164.3 g carnivore-insectivore
Trogon melanocephalus285.1 g insectivore-frugivore
Chloroceryle aenea13.6 g piscivore
Melanerpes aurifrons385.4 g insectivore-frugivore
Dendrocincla anabatina137.4 g insectivore
Glyphorhynchus spirurus1 frugivore-insectivore
Xiphorhynchus flavigaster127.2 g insectivore
Lepidocolaptes souleyetii125.7 g insectivore
"Lepidocolaptes souleyetti"
Formicarius analis162.2 g insectivore
Mionectes oleagineus12.3 g insectivore-frugivore
Tolmomyias sulphurescens1214.3 g insectivore
Onychorhynchus coronatus614.0 g insectivore
Attila spadiceus139.1 g insectivore
Myiarchus tuberculifer32.3 g insectivore-frugivore
Myiarchus tyrannulus15.4 g insectivore-frugivore
Thryothorus maculipectus1316.2 g insectivore
Turdus grayi979.5 g insectivore-frugivore
Sporophila corvina13.1 g
"Sporophila aurita"
Sporophila torqueola3 granivore
Arremon aurantiirostris234.5 g frugivore-insectivore
Arremonops chloronotus1327.4 g
Saltator atriceps39.4 g insectivore-frugivore
Saltator coerulescens154.9 g insectivore-frugivore
Saltator maximus246.2 g frugivore-folivore
Passerina cyanoides1
Habia fuscicauda226.1 g insectivore-frugivore
Euphonia hirundinacea1214.0 g insectivore-frugivore
Cyanocorax morio1 omnivore