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=999 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=999SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=690SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=999 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='inca' OR junior_species='inca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Columbina' AND (species='inca' OR species='inca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Columbina' AND (species='inca' OR species='inca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='inca' OR junior_species='inca')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='Columbina' AND (species='inca' OR species='inca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centurus' AND (junior_species='hypopolius' OR junior_species='hypopolius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centurus' AND (species='hypopolius' OR species='hypopolius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centurus' AND (species='hypopolius' OR species='hypopolius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centurus' AND (junior_species='hypopolius' OR junior_species='hypopolius')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='Centurus' AND (species='hypopolius' OR species='hypopolius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icterus' AND (junior_species='wagleri' OR junior_species='waglerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Icterus' AND (species='wagleri' OR species='waglerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Icterus' AND (species='wagleri' OR species='waglerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icterus' AND (junior_species='wagleri' OR junior_species='waglerii')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='Icterus' AND (species='wagleri' OR species='waglerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiodynastes' AND (junior_species='luteiventris' OR junior_species='luteiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiodynastes' AND (species='luteiventris' OR species='luteiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiodynastes' AND (species='luteiventris' OR species='luteiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiodynastes' AND (junior_species='luteiventris' OR junior_species='luteiventris')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='Myiodynastes' AND (species='luteiventris' OR species='luteiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passerina' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passerina' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='versicolor' OR junior_species='versicolor')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='versicolor' OR species='versicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icterus' AND (junior_species='pustulatus' OR junior_species='pustulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Icterus' AND (species='pustulatus' OR species='pustulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Icterus' AND (species='pustulatus' OR species='pustulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icterus' AND (junior_species='pustulatus' OR junior_species='pustulatus')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='Icterus' AND (species='pustulatus' OR species='pustulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='rufopalliatus' OR junior_species='rufopalliatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='rufopalliatus' OR species='rufopalliatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='rufopalliatus' OR species='rufopalliatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='rufopalliatus' OR junior_species='rufopalliatus')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='rufopalliatus' OR species='rufopalliatus') 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='Aimophila' AND (junior_species='humeralis' OR junior_species='humeralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aimophila' AND (species='humeralis' OR species='humeralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aimophila' AND (species='humeralis' OR species='humeralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aimophila' AND (junior_species='humeralis' OR junior_species='humeralis')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='Aimophila' AND (species='humeralis' OR species='humeralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='scalaris' OR junior_species='scalaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picoides' AND (species='scalaris' OR species='scalaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picoides' AND (species='scalaris' OR species='scalaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='scalaris' OR junior_species='scalaris')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='Picoides' AND (species='scalaris' OR species='scalaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheucticus' AND (junior_species='chrysopeplus' OR junior_species='chrysopeplus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheucticus' AND (species='chrysopeplus' OR species='chrysopeplus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheucticus' AND (species='chrysopeplus' OR species='chrysopeplus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheucticus' AND (junior_species='chrysopeplus' OR junior_species='chrysopeplus')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='Pheucticus' AND (species='chrysopeplus' OR species='chrysopeplus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aimophila' AND (junior_species='ruficauda' OR junior_species='ruficauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aimophila' AND (species='ruficauda' OR species='ruficauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aimophila' AND (species='ruficauda' OR species='ruficauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aimophila' AND (junior_species='ruficauda' OR junior_species='ruficauda')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='Aimophila' AND (species='ruficauda' OR species='ruficauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molothrus' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molothrus' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Molothrus' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molothrus' AND (junior_species='aeneus' OR junior_species='aeneus')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='Molothrus' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centurus' AND (junior_species='chrysogenys' OR junior_species='chrysogenys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centurus' AND (species='chrysogenys' OR species='chrysogenys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centurus' AND (species='chrysogenys' OR species='chrysogenys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centurus' AND (junior_species='chrysogenys' OR junior_species='chrysogenys')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='Centurus' AND (species='chrysogenys' OR species='chrysogenys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' 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='Coccyzus' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccyzus' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' 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='Coccyzus' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenotriccus' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenotriccus' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenotriccus' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenotriccus' AND (junior_species='mexicanus' OR junior_species='mexicanus')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='Xenotriccus' AND (species='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='leclancherii' OR junior_species='leclancheri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passerina' AND (species='leclancherii' OR species='leclancheri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passerina' AND (species='leclancherii' OR species='leclancheri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='leclancherii' OR junior_species='leclancheri')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='leclancherii' OR species='leclancheri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Momotus' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Momotus' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Momotus' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Momotus' AND (junior_species='mexicanus' OR junior_species='mexicanus')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='Momotus' AND (species='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogon' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogon' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='mexicanus' OR junior_species='mexicanus')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='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='hypochryseus' OR junior_species='hypochryseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='hypochryseus' OR species='hypochryseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='hypochryseus' OR species='hypochryseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='hypochryseus' OR junior_species='hypochryseus')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='Vireo' AND (species='hypochryseus' OR species='hypochryseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannus' AND (junior_species='melancholicus' OR junior_species='melancholicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyrannus' AND (species='melancholicus' OR species='melancholicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyrannus' AND (species='melancholicus' OR species='melancholicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannus' AND (junior_species='melancholicus' OR junior_species='melancholicus')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='Tyrannus' AND (species='melancholicus' OR species='melancholicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiscalus' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quiscalus' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quiscalus' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiscalus' AND (junior_species='mexicanus' OR junior_species='mexicanus')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='Quiscalus' AND (species='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='coronata' OR junior_species='coronata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='coronata' OR species='coronata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='coronata' OR species='coronata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='coronata' OR junior_species='coronata')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='Setophaga' AND (species='coronata' OR species='coronata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='minuta' OR junior_species='minuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Columbina' AND (species='minuta' OR species='minuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Columbina' AND (species='minuta' OR species='minuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='minuta' OR junior_species='minuta')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='Columbina' AND (species='minuta' OR species='minuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='elegantissima' OR junior_species='elegantissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='elegantissima' OR species='elegantissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='elegantissima' OR species='elegantissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='elegantissima' OR junior_species='elegantissima')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='elegantissima' OR species='elegantissima') 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='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='Piranga' AND (junior_species='ludoviciana' OR junior_species='ludoviciana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piranga' AND (species='ludoviciana' OR species='ludoviciana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piranga' AND (species='ludoviciana' OR species='ludoviciana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='ludoviciana' OR junior_species='ludoviciana')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='Piranga' AND (species='ludoviciana' OR species='ludoviciana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='traillii' OR junior_species='trailli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='traillii' OR species='trailli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='traillii' OR species='trailli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='traillii' OR junior_species='trailli')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='Empidonax' AND (species='traillii' OR species='trailli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrocephalus' AND (junior_species='rubinus' OR junior_species='rubinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrocephalus' AND (species='rubinus' OR species='rubinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrocephalus' AND (species='rubinus' OR species='rubinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrocephalus' AND (junior_species='rubinus' OR junior_species='rubinus')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='Pyrocephalus' AND (species='rubinus' OR species='rubinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxostoma' AND (junior_species='curvirostre' OR junior_species='curvirostre')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxostoma' AND (species='curvirostre' OR species='curvirostre') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxostoma' AND (species='curvirostre' OR species='curvirostre')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxostoma' AND (junior_species='curvirostre' OR junior_species='curvirostre')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='Toxostoma' AND (species='curvirostre' OR species='curvirostre') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=999 The Ecological Register: Sierra de Huautla Biosphere Reserve (birds)
Sierra de Huautla Biosphere Reserve (birds)
Basic information
Sample name: Sierra de Huautla Biosphere Reserve (birds)

Reference: C. Martínez-Garza, M. Osorio-Beristain, D. Valenzuela-Galván, and A. Nicolás-Medina. 2011. Intra and inter-annual variation in seed rain in a secondary dry tropical forest excluded from chronic disturbance. Forest Ecology and Management 262:2207-2218 [ER 690]
Geography
Country: Mexico

State: Morelos


Coordinate: 18° 27' 15" N, 98° 29' 47" W
Coordinate basis: stated in text

Geography comments: coordinate based on ranges stated in text

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: secondary forest

Protection: biosphere reserve

Substrate: ground surface

Disturbance: grazing

MAT: 24.5

MAP: 818.0

Methods
Life forms: birds

Sampling methods: quadrat,visual

Sample size: 369 individuals

Years: 2006

Sampling comments: counts were apparently NOT in the same eight 50 x 50 m plots censused for trees because they were recorded "in a particular radio of distance (from the point)" (number of points not stated); counts were visual but of individuals, not sightings

Metadata
Sample number: 999

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-07-06 11:26:02

Modified: 2017-04-17 04:29:29

Abundance distribution
31 species
3 singletons
total count 369
extrapolated richness: 44.3
Fisher's α: 8.062
geometric series k: 0.8719
Hurlbert's PIE: 0.9184
Shannon's H: 2.8414
Good's u: 0.9920
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Columbina inca6147.5 g granivore
Centurus hypopolius16
Icterus wagleri441.8 g insectivore-frugivore
Myiodynastes luteiventris2246.9 g insectivore-frugivore
Passerina versicolor2013.0 g granivore-insectivore
Icterus pustulatus426.0 g insectivore-frugivore
Turdus rufopalliatus178.6 g
Myiarchus tyrannulus145.4 g insectivore-frugivore
Aimophila humeralis2223.9 g
Picoides scalaris55.8 g insectivore
Pheucticus chrysopeplus1877.6 g insectivore-frugivore
Aimophila ruficauda5028.2 g
Molothrus aeneus1668.9 g granivore-insectivore
Centurus chrysogenys12
Coccyzus minor263.9 g carnivore-insectivore
Xenotriccus mexicanus213.8 g
Passerina leclancherii414.0 g
Momotus mexicanus275.7 g carnivore-insectivore
Trogon mexicanus771.0 g
Vireo hypochryseus112.2 g
Tyrannus melancholicus237.4 g insectivore-frugivore
Quiscalus mexicanus1222 g omnivore
Setophaga coronata2
"Dendroica coronata"
Columbina minuta95.7 g granivore
Euphonia elegantissima315.0 g insectivore-frugivore
Leptotila verreauxi211.6 g granivore-frugivore
Sporophila torqueola1 granivore
Piranga ludoviciana328.1 g insectivore-frugivore
Empidonax traillii213.1 g insectivore-frugivore
Pyrocephalus rubinus314.4 g insectivore
Toxostoma curvirostre49.0 g