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=1123 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1123SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=779SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1123 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphispiza' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphispiza' AND (species='bilineata' OR species='bilineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphispiza' AND (species='bilineata' OR species='bilineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphispiza' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphispiza' AND (species='bilineata' OR species='bilineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Auriparus' AND (junior_species='flaviceps' OR junior_species='flaviceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Auriparus' AND (species='flaviceps' OR species='flaviceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Auriparus' AND (species='flaviceps' OR species='flaviceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Auriparus' AND (junior_species='flaviceps' OR junior_species='flaviceps')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='Auriparus' AND (species='flaviceps' OR species='flaviceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aimophila' AND (junior_species='ruficeps' OR junior_species='ruficeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aimophila' AND (species='ruficeps' OR species='ruficeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aimophila' AND (species='ruficeps' OR species='ruficeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aimophila' AND (junior_species='ruficeps' OR junior_species='ruficeps')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='ruficeps' OR species='ruficeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melozone' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melozone' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melozone' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melozone' AND (junior_species='fusca' OR junior_species='fusca')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melozone' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxostoma' AND (junior_species='crissale' OR junior_species='crissale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxostoma' AND (species='crissale' OR species='crissale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxostoma' AND (species='crissale' OR species='crissale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxostoma' AND (junior_species='crissale' OR junior_species='crissale')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='crissale' OR species='crissale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylorhynchus' AND (junior_species='brunneicapillus' OR junior_species='brunneicapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campylorhynchus' AND (species='brunneicapillus' OR species='brunneicapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campylorhynchus' AND (species='brunneicapillus' OR species='brunneicapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylorhynchus' AND (junior_species='brunneicapillus' OR junior_species='brunneicapillus')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='Campylorhynchus' AND (species='brunneicapillus' OR species='brunneicapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salpinctes' AND (junior_species='obsoletus' OR junior_species='obsoletus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salpinctes' AND (species='obsoletus' OR species='obsoletus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salpinctes' AND (species='obsoletus' OR species='obsoletus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salpinctes' AND (junior_species='obsoletus' OR junior_species='obsoletus')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='Salpinctes' AND (species='obsoletus' OR species='obsoletus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polioptila' AND (junior_species='melanura' OR junior_species='melanura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polioptila' AND (species='melanura' OR species='melanura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polioptila' AND (species='melanura' OR species='melanura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polioptila' AND (junior_species='melanura' OR junior_species='melanura')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='Polioptila' AND (species='melanura' OR species='melanura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' 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='Carpodacus' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpodacus' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' 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='Carpodacus' AND (species='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='ludovicianus' OR junior_species='ludovicianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='ludovicianus' OR species='ludovicianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='ludovicianus' OR species='ludovicianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='ludovicianus' OR junior_species='ludovicianus')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='Lanius' AND (species='ludovicianus' OR species='ludovicianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardinalis' AND (junior_species='sinuatus' OR junior_species='sinuatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cardinalis' AND (species='sinuatus' OR species='sinuatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardinalis' AND (species='sinuatus' OR species='sinuatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardinalis' AND (junior_species='sinuatus' OR junior_species='sinuatus')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='Cardinalis' AND (species='sinuatus' OR species='sinuatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonotrichia' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonotrichia' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='leucophrys' OR junior_species='leucophrys')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='Zonotrichia' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryomanes' AND (junior_species='bewickii' OR junior_species='bewicki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thryomanes' AND (species='bewickii' OR species='bewicki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thryomanes' AND (species='bewickii' OR species='bewicki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryomanes' AND (junior_species='bewickii' OR junior_species='bewicki')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='Thryomanes' AND (species='bewickii' OR species='bewicki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphispiza' AND (junior_species='belli' OR junior_species='bellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphispiza' AND (species='belli' OR species='bellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphispiza' AND (species='belli' OR species='bellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphispiza' AND (junior_species='belli' OR junior_species='bellii')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='Amphispiza' AND (species='belli' OR species='bellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipilo' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipilo' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipilo' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipilo' AND (junior_species='maculatus' OR junior_species='maculatus')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='Pipilo' AND (species='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimus' AND (junior_species='polyglottos' OR junior_species='polyglottos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimus' AND (species='polyglottos' OR species='polyglottos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimus' AND (species='polyglottos' OR species='polyglottos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimus' AND (junior_species='polyglottos' OR junior_species='polyglottos')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='Mimus' AND (species='polyglottos' OR species='polyglottos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreoscoptes' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreoscoptes' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreoscoptes' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreoscoptes' AND (junior_species='montanus' OR junior_species='montanus')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='Oreoscoptes' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melospiza' AND (junior_species='melodia' OR junior_species='melodia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melospiza' AND (species='melodia' OR species='melodia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melospiza' AND (species='melodia' OR species='melodia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melospiza' AND (junior_species='melodia' OR junior_species='melodia')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='Melospiza' AND (species='melodia' OR species='melodia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipilo' AND (junior_species='erythrophthalmus' OR junior_species='erythrophthalmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipilo' AND (species='erythrophthalmus' OR species='erythrophthalmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipilo' AND (species='erythrophthalmus' OR species='erythrophthalmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipilo' AND (junior_species='erythrophthalmus' OR junior_species='erythrophthalmus')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='Pipilo' AND (species='erythrophthalmus' OR species='erythrophthalmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='gambeli' OR junior_species='gambelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecile' AND (species='gambeli' OR species='gambelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecile' AND (species='gambeli' OR species='gambelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='gambeli' OR junior_species='gambelii')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='Poecile' AND (species='gambeli' OR species='gambelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipilo' AND (junior_species='chlorurus' OR junior_species='chlorurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipilo' AND (species='chlorurus' OR species='chlorurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipilo' AND (species='chlorurus' OR species='chlorurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipilo' AND (junior_species='chlorurus' OR junior_species='chlorurus')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='Pipilo' AND (species='chlorurus' OR species='chlorurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizella' AND (junior_species='breweri' OR junior_species='brewerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spizella' AND (species='breweri' OR species='brewerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spizella' AND (species='breweri' OR species='brewerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizella' AND (junior_species='breweri' OR junior_species='brewerii')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='Spizella' AND (species='breweri' OR species='brewerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardellina' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cardellina' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardellina' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardellina' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cardellina' AND (species='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='virginiae' OR junior_species='virginiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leiothlypis' AND (species='virginiae' OR species='virginiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leiothlypis' AND (species='virginiae' OR species='virginiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='virginiae' OR junior_species='virginiae')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='Leiothlypis' AND (species='virginiae' OR species='virginiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='calendula' OR junior_species='calendula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Regulus' AND (species='calendula' OR species='calendula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Regulus' AND (species='calendula' OR species='calendula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='calendula' OR junior_species='calendula')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='Regulus' AND (species='calendula' OR species='calendula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archilochus' AND (junior_species='alexandri' OR junior_species='alexandrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archilochus' AND (species='alexandri' OR species='alexandrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archilochus' AND (species='alexandri' OR species='alexandrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archilochus' AND (junior_species='alexandri' OR junior_species='alexandrii')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='Archilochus' AND (species='alexandri' OR species='alexandrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='tolmiei' OR junior_species='tolmieii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geothlypis' AND (species='tolmiei' OR species='tolmieii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geothlypis' AND (species='tolmiei' OR species='tolmieii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='tolmiei' OR junior_species='tolmieii')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='Geothlypis' AND (species='tolmiei' OR species='tolmieii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polioptila' AND (junior_species='caerulea' OR junior_species='caerulea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polioptila' AND (species='caerulea' OR species='caerulea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polioptila' AND (species='caerulea' OR species='caerulea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polioptila' AND (junior_species='caerulea' OR junior_species='caerulea')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='Polioptila' AND (species='caerulea' OR species='caerulea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='celata' OR junior_species='celata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leiothlypis' AND (species='celata' OR species='celata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leiothlypis' AND (species='celata' OR species='celata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='celata' OR junior_species='celata')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='Leiothlypis' AND (species='celata' OR species='celata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='guttatus' OR species='guttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='guttatus' OR species='guttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catharus' AND (species='guttatus' OR species='guttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='cinerascens' OR junior_species='cinerascens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='cinerascens' OR species='cinerascens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='cinerascens' OR species='cinerascens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='cinerascens' OR junior_species='cinerascens')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='cinerascens' OR species='cinerascens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='wrightii' OR junior_species='wrighti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='wrightii' OR species='wrighti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='wrightii' OR species='wrighti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='wrightii' OR junior_species='wrighti')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='wrightii' OR species='wrighti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizella' AND (junior_species='passerina' OR junior_species='passerina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spizella' AND (species='passerina' OR species='passerina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spizella' AND (species='passerina' OR species='passerina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizella' AND (junior_species='passerina' OR junior_species='passerina')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='Spizella' AND (species='passerina' OR species='passerina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='aedon' OR junior_species='aedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troglodytes' AND (species='aedon' OR species='aedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troglodytes' AND (species='aedon' OR species='aedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='aedon' OR junior_species='aedon')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='Troglodytes' AND (species='aedon' OR species='aedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='oberholseri' OR junior_species='oberholserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='oberholseri' OR species='oberholserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='oberholseri' OR species='oberholserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='oberholseri' OR junior_species='oberholserii')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='oberholseri' OR species='oberholserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melospiza' AND (junior_species='lincolnii' OR junior_species='lincolni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melospiza' AND (species='lincolnii' OR species='lincolni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melospiza' AND (species='lincolnii' OR species='lincolni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melospiza' AND (junior_species='lincolnii' OR junior_species='lincolni')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='Melospiza' AND (species='lincolnii' OR species='lincolni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannus' AND (junior_species='verticalis' OR junior_species='verticalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyrannus' AND (species='verticalis' OR species='verticalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyrannus' AND (species='verticalis' OR species='verticalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannus' AND (junior_species='verticalis' OR junior_species='verticalis')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='verticalis' OR species='verticalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Selasphorus' AND (junior_species='platycercus' OR junior_species='platycercus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Selasphorus' AND (species='platycercus' OR species='platycercus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Selasphorus' AND (species='platycercus' OR species='platycercus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Selasphorus' AND (junior_species='platycercus' OR junior_species='platycercus')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='Selasphorus' AND (species='platycercus' OR species='platycercus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='occidentalis' OR junior_species='occidentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='occidentalis' OR species='occidentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='occidentalis' OR species='occidentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='occidentalis' OR junior_species='occidentalis')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='occidentalis' OR species='occidentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='hammondii' OR junior_species='hammondi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='hammondii' OR species='hammondi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='hammondii' OR species='hammondi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='hammondii' OR junior_species='hammondi')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='hammondii' OR species='hammondi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sayornis' AND (junior_species='saya' OR junior_species='saya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sayornis' AND (species='saya' OR species='saya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sayornis' AND (species='saya' OR species='saya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sayornis' AND (junior_species='saya' OR junior_species='saya')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='Sayornis' AND (species='saya' OR species='saya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setaphaga' AND (junior_species='nigrescens' OR junior_species='nigrescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setaphaga' AND (species='nigrescens' OR species='nigrescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setaphaga' AND (species='nigrescens' OR species='nigrescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setaphaga' AND (junior_species='nigrescens' OR junior_species='nigrescens')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='Setaphaga' AND (species='nigrescens' OR species='nigrescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='plumbeus' OR junior_species='plumbeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='plumbeus' OR species='plumbeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='plumbeus' OR species='plumbeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='plumbeus' OR junior_species='plumbeus')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='plumbeus' OR species='plumbeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='gilvus' OR junior_species='gilvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='gilvus' OR species='gilvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='gilvus' OR species='gilvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='gilvus' OR junior_species='gilvus')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='gilvus' OR species='gilvus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1123 The Ecological Register: McGregor Range (arroyo)
McGregor Range (arroyo)
Basic information
Sample name: McGregor Range (arroyo)

Sample aka: Fort Bliss Military Reservation

Reference: J. M. Kozma, L. M. Burkett, and N. E. Mathews. 2012. Associations of small migratory and resident birds with two scrub habitats during late winter and spring in the northern Chihuahuan Desert, New Mexico. Southwestern Naturalist 57(1):31-38 [ER 779]
Geography
Country: United States

State: New Mexico


Coordinate: 31° 48' N, 106° 25' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Fort Bliss
elevation 1276 to 1512 m

•
Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

WMT: 28.2

CMT: 7.2

MAP: 229.0

Habitat comments: "desert shrubland"
MAP 203 to 254 mm; CMT and WMT based on station 72270 (El Paso International Airport)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 554 individuals

Years: 1993, 1994, 1996, 1997

Nets or traps: 4

Net or trap nights: 548

Sampling comments: four 2.6 x 6 m, 30 or 36 mm mesh mist nets used for four hours per day for a total of 2192.65 net hours = about 548 net days

Metadata
Sample number: 1123

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-29 14:43:54

Modified: 2014-08-29 04:43:54

Abundance distribution
44 species
5 singletons
total count 554
extrapolated richness: 60.9
Fisher's α: 11.228
geometric series k: 0.9106
Hurlbert's PIE: 0.9455
Shannon's H: 3.2330
Good's u: 0.9910
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Amphispiza bilineata5513.5 g insectivore-granivore
Auriparus flaviceps186.8 g
Aimophila ruficeps1919.3 g
Melozone fusca16
Toxostoma crissale962.7 g
Campylorhynchus brunneicapillus738.9 g
Salpinctes obsoletus22.5 g insectivore
Polioptila melanura45.2 g
Carpodacus mexicanus221.4 g granivore
Lanius ludovicianus2
Cardinalis sinuatus335.8 g
Zonotrichia leucophrys522.0 g insectivore-granivore
Thryomanes bewickii439.9 g
Amphispiza belli133.9 g insectivore-granivore
Pipilo maculatus96.4 g insectivore-granivore
Mimus polyglottos648.5 g insectivore
Oreoscoptes montanus344.2 g insectivore-frugivore
Melospiza melodia21.6 g insectivore-granivore
Pipilo erythrophthalmus141.3 g insectivore-granivore
Poecile gambeli13.3 g insectivore
Pipilo chlorurus5629.4 g insectivore-granivore
Spizella breweri2710.9 g insectivore-granivore
Cardellina pusilla41 insectivore
Leiothlypis virginiae22
"Oreothlypis virginiae"
Regulus calendula256.5 g insectivore
Archilochus alexandri153.2 g
Geothlypis tolmiei13
Polioptila caerulea85.8 g insectivore
Leiothlypis celata12
"Oreothlypis celata"
Catharus guttatus1130.1 g insectivore-frugivore
Myiarchus cinerascens528.2 g insectivore-frugivore
Empidonax wrightii912.3 g insectivore
Spizella passerina512.2 g insectivore-granivore
Troglodytes aedon81.8 g insectivore
Empidonax oberholseri710.4 g insectivore
Melospiza lincolnii616.6 g insectivore-granivore
Tyrannus verticalis439.6 g insectivore-frugivore
Selasphorus platycercus33.5 g nectarivore
Empidonax occidentalis311.6 g
Empidonax hammondii210.6 g insectivore
Sayornis saya220.9 g
Setaphaga nigrescens1
Vireo plumbeus116.4 g insectivore
Vireo gilvus13.4 g insectivore-frugivore