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=3078 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3078SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2848SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3078 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombycilla' AND (junior_species='cedrorum' OR junior_species='cedrorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bombycilla' AND (species='cedrorum' OR species='cedrorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bombycilla' AND (species='cedrorum' OR species='cedrorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bombycilla' AND (junior_species='cedrorum' OR junior_species='cedrorum')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='Bombycilla' AND (species='cedrorum' OR species='cedrorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocitta' AND (junior_species='cristata' OR junior_species='cristata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanocitta' AND (species='cristata' OR species='cristata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanocitta' AND (species='cristata' OR species='cristata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocitta' AND (junior_species='cristata' OR junior_species='cristata')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='Cyanocitta' AND (species='cristata' OR species='cristata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perisoreus' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perisoreus' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perisoreus' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perisoreus' AND (junior_species='canadensis' OR junior_species='canadensis')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='Perisoreus' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' AND (junior_species='erythropthalmus' OR junior_species='erythropthalmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccyzus' AND (species='erythropthalmus' OR species='erythropthalmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccyzus' AND (species='erythropthalmus' OR species='erythropthalmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' AND (junior_species='erythropthalmus' OR junior_species='erythropthalmus')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='erythropthalmus' OR species='erythropthalmus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' AND (junior_species='purpureus' OR junior_species='purpureus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carpodacus' AND (species='purpureus' OR species='purpureus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carpodacus' AND (species='purpureus' OR species='purpureus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carpodacus' AND (junior_species='purpureus' OR junior_species='purpureus')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='purpureus' OR species='purpureus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperiphona' AND (junior_species='vespertina' OR junior_species='vespertina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hesperiphona' AND (species='vespertina' OR species='vespertina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hesperiphona' AND (species='vespertina' OR species='vespertina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hesperiphona' AND (junior_species='vespertina' OR junior_species='vespertina')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='Hesperiphona' AND (species='vespertina' OR species='vespertina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junco' AND (junior_species='hyemalis' OR junior_species='hyemalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junco' AND (species='hyemalis' OR species='hyemalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junco' AND (species='hyemalis' OR species='hyemalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junco' AND (junior_species='hyemalis' OR junior_species='hyemalis')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='Junco' AND (species='hyemalis' OR species='hyemalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melospiza' AND (junior_species='georgiana' OR junior_species='georgiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melospiza' AND (species='georgiana' OR species='georgiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melospiza' AND (species='georgiana' OR species='georgiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melospiza' AND (junior_species='georgiana' OR junior_species='georgiana')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='georgiana' OR species='georgiana') 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='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='Passerculus' AND (junior_species='sandwichensis' OR junior_species='sandwichensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passerculus' AND (species='sandwichensis' OR species='sandwichensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passerculus' AND (species='sandwichensis' OR species='sandwichensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerculus' AND (junior_species='sandwichensis' OR junior_species='sandwichensis')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='Passerculus' AND (species='sandwichensis' OR species='sandwichensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheucticus' 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='Pheucticus' AND (species='ludovicianus' OR species='ludovicianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheucticus' AND (species='ludovicianus' OR species='ludovicianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheucticus' 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='Pheucticus' AND (species='ludovicianus' OR species='ludovicianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pooecetes' AND (junior_species='gramineus' OR junior_species='gramineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pooecetes' AND (species='gramineus' OR species='gramineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pooecetes' AND (species='gramineus' OR species='gramineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pooecetes' AND (junior_species='gramineus' OR junior_species='gramineus')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='Pooecetes' AND (species='gramineus' OR species='gramineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spinus' AND (junior_species='tristis' OR junior_species='tristis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spinus' AND (species='tristis' OR species='tristis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spinus' AND (species='tristis' OR species='tristis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spinus' AND (junior_species='tristis' OR junior_species='tristis')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='Spinus' AND (species='tristis' OR species='tristis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizella' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spizella' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spizella' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizella' AND (junior_species='arborea' OR junior_species='arborea')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='arborea' OR species='arborea') 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='Zonotrichia' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonotrichia' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonotrichia' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zonotrichia' AND (species='albicollis' OR species='albicollis') 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='Hirundo' AND (junior_species='rustica' OR junior_species='rustica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='rustica' OR species='rustica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='rustica' OR species='rustica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='rustica' OR junior_species='rustica')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='Hirundo' AND (species='rustica' OR species='rustica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iridoprocne' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iridoprocne' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iridoprocne' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iridoprocne' AND (junior_species='bicolor' OR junior_species='bicolor')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='Iridoprocne' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agelaius' AND (junior_species='phoeniceus' OR junior_species='phoeniceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agelaius' AND (species='phoeniceus' OR species='phoeniceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agelaius' AND (species='phoeniceus' OR species='phoeniceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agelaius' AND (junior_species='phoeniceus' OR junior_species='phoeniceus')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='Agelaius' AND (species='phoeniceus' OR species='phoeniceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichonyx' AND (junior_species='oryzivoros' OR junior_species='oryzivoros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dolichonyx' AND (species='oryzivoros' OR species='oryzivoros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dolichonyx' AND (species='oryzivoros' OR species='oryzivoros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichonyx' AND (junior_species='oryzivoros' OR junior_species='oryzivoros')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='Dolichonyx' AND (species='oryzivoros' OR species='oryzivoros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molothrus' AND (junior_species='ater' OR junior_species='ater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molothrus' AND (species='ater' OR species='ater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Molothrus' AND (species='ater' OR species='ater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molothrus' AND (junior_species='ater' OR junior_species='ater')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='ater' OR species='ater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiscalus' AND (junior_species='quiscula' OR junior_species='quiscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quiscalus' AND (species='quiscula' OR species='quiscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quiscalus' AND (species='quiscula' OR species='quiscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quiscalus' AND (junior_species='quiscula' OR junior_species='quiscula')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='quiscula' OR species='quiscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dumetella' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dumetella' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dumetella' AND (species='carolinensis' OR species='carolinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dumetella' AND (junior_species='carolinensis' OR junior_species='carolinensis')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='Dumetella' AND (species='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='atricapillus' OR junior_species='atricapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecile' AND (species='atricapillus' OR species='atricapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecile' AND (species='atricapillus' OR species='atricapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='atricapillus' OR junior_species='atricapillus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poecile' AND (species='atricapillus' OR species='atricapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='hudsonicus' OR junior_species='hudsonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecile' AND (species='hudsonicus' OR species='hudsonicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecile' AND (species='hudsonicus' OR species='hudsonicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='hudsonicus' OR junior_species='hudsonicus')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='hudsonicus' OR species='hudsonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='castanea' OR junior_species='castanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='castanea' OR species='castanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='castanea' OR species='castanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='castanea' OR junior_species='castanea')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='castanea' OR species='castanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Setophaga' AND (species='caerulescens' OR species='caerulescens') 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='Setophaga' 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='Setophaga' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' 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='Setophaga' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='magnolia' OR junior_species='magnolia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='magnolia' OR species='magnolia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='magnolia' OR species='magnolia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='magnolia' OR junior_species='magnolia')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='magnolia' OR species='magnolia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='palmarum' OR junior_species='palmarum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='palmarum' OR species='palmarum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='palmarum' OR species='palmarum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='palmarum' OR junior_species='palmarum')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='palmarum' OR species='palmarum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='pensylvanica' OR junior_species='pensylvanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='pensylvanica' OR species='pensylvanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='pensylvanica' OR species='pensylvanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='pensylvanica' OR junior_species='pensylvanica')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='pensylvanica' OR species='pensylvanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='petechia' OR junior_species='petechia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='petechia' OR species='petechia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='petechia' OR species='petechia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='petechia' OR junior_species='petechia')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='petechia' OR species='petechia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='striata' OR junior_species='striata')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='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='tigrina' OR junior_species='tigrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='tigrina' OR species='tigrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='tigrina' OR species='tigrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='tigrina' OR junior_species='tigrina')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='tigrina' OR species='tigrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='virens' OR junior_species='virens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='virens' OR junior_species='virens')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='virens' OR species='virens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='trichas' OR junior_species='trichas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geothlypis' AND (species='trichas' OR species='trichas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geothlypis' AND (species='trichas' OR species='trichas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='trichas' OR junior_species='trichas')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='trichas' OR species='trichas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mniotilta' AND (junior_species='varia' OR junior_species='varia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mniotilta' AND (species='varia' OR species='varia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mniotilta' AND (species='varia' OR species='varia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mniotilta' AND (junior_species='varia' OR junior_species='varia')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='Mniotilta' AND (species='varia' OR species='varia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oporornis' AND (junior_species='philadelphia' OR junior_species='philadelphia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oporornis' AND (species='philadelphia' OR species='philadelphia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oporornis' AND (species='philadelphia' OR species='philadelphia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oporornis' AND (junior_species='philadelphia' OR junior_species='philadelphia')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='Oporornis' AND (species='philadelphia' OR species='philadelphia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parula' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parula' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parula' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parula' AND (junior_species='americana' OR junior_species='americana')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='Parula' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seiurus' AND (junior_species='aurocapilla' OR junior_species='aurocapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seiurus' AND (junior_species='aurocapilla' OR junior_species='aurocapilla')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='Seiurus' AND (species='aurocapilla' OR species='aurocapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkesia' AND (junior_species='noveboracensis' OR junior_species='noveboracensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkesia' AND (species='noveboracensis' OR species='noveboracensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkesia' AND (species='noveboracensis' OR species='noveboracensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkesia' AND (junior_species='noveboracensis' OR junior_species='noveboracensis')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='Parkesia' AND (species='noveboracensis' OR species='noveboracensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='ruticilla' OR junior_species='ruticilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='ruticilla' OR species='ruticilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='ruticilla' OR species='ruticilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='ruticilla' OR junior_species='ruticilla')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='ruticilla' OR species='ruticilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='peregrina' OR junior_species='peregrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leiothlypis' AND (species='peregrina' OR species='peregrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leiothlypis' AND (species='peregrina' OR species='peregrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='peregrina' OR junior_species='peregrina')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='peregrina' OR species='peregrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leiothlypis' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leiothlypis' AND (species='ruficapilla' OR species='ruficapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leiothlypis' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wilsonia' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wilsonia' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' AND (junior_species='canadensis' OR junior_species='canadensis')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='Wilsonia' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' 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='Wilsonia' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wilsonia' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' 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='Wilsonia' AND (species='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='auratus' OR junior_species='auratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colaptes' AND (species='auratus' OR species='auratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colaptes' AND (species='auratus' OR species='auratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='auratus' OR junior_species='auratus')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='Colaptes' AND (species='auratus' OR species='auratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocopos' AND (species='pubescens' OR species='pubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocopos' AND (species='pubescens' OR species='pubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' AND (junior_species='pubescens' OR junior_species='pubescens')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='Dendrocopos' AND (species='pubescens' OR species='pubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' AND (junior_species='villosus' OR junior_species='villosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocopos' AND (species='villosus' OR species='villosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocopos' AND (species='villosus' OR species='villosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocopos' AND (junior_species='villosus' OR junior_species='villosus')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='Dendrocopos' AND (species='villosus' OR species='villosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fulica' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fulica' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fulica' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fulica' AND (junior_species='americana' OR junior_species='americana')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='Fulica' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='semipalmata' OR junior_species='semipalmata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tringa' AND (species='semipalmata' OR species='semipalmata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tringa' AND (species='semipalmata' OR species='semipalmata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='semipalmata' OR junior_species='semipalmata')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='Tringa' AND (species='semipalmata' OR species='semipalmata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnus' AND (junior_species='vulgaris' OR junior_species='vulgaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sturnus' AND (species='vulgaris' OR species='vulgaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sturnus' AND (species='vulgaris' OR species='vulgaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sturnus' AND (junior_species='vulgaris' OR junior_species='vulgaris')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='Sturnus' AND (species='vulgaris' OR species='vulgaris') 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='Regulus' AND (junior_species='satrapa' OR junior_species='satrapa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Regulus' AND (species='satrapa' OR species='satrapa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Regulus' AND (species='satrapa' OR species='satrapa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='satrapa' OR junior_species='satrapa')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='satrapa' OR species='satrapa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archilochus' AND (junior_species='colubris' OR junior_species='colubris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archilochus' AND (species='colubris' OR species='colubris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archilochus' AND (species='colubris' OR species='colubris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archilochus' AND (junior_species='colubris' OR junior_species='colubris')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='colubris' OR species='colubris') 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='Catharus' AND (junior_species='ustulatus' OR junior_species='ustulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='ustulatus' OR species='ustulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='ustulatus' OR species='ustulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='ustulatus' OR junior_species='ustulatus')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='ustulatus' OR species='ustulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='migratorius' OR junior_species='migratorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='migratorius' OR species='migratorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='migratorius' OR species='migratorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='migratorius' OR junior_species='migratorius')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='migratorius' OR species='migratorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Contopus' AND (junior_species='virens' OR junior_species='virens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Contopus' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Contopus' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Contopus' AND (junior_species='virens' OR junior_species='virens')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='Contopus' AND (species='virens' OR species='virens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='flaviventris' OR junior_species='flaviventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='flaviventris' OR species='flaviventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='flaviventris' OR species='flaviventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='flaviventris' OR junior_species='flaviventris')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='flaviventris' OR species='flaviventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='minimus' OR junior_species='minimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='minimus' OR species='minimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='minimus' OR species='minimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='minimus' OR junior_species='minimus')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='minimus' OR species='minimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='trailii' OR junior_species='traili')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='trailii' OR species='traili') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='trailii' OR species='traili')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='trailii' OR junior_species='traili')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='trailii' OR species='traili') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nuttallornis' AND (junior_species='borealis' OR junior_species='borealis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nuttallornis' AND (species='borealis' OR species='borealis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nuttallornis' AND (species='borealis' OR species='borealis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nuttallornis' AND (junior_species='borealis' OR junior_species='borealis')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='Nuttallornis' AND (species='borealis' OR species='borealis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannus' AND (junior_species='tyrannus' OR junior_species='tyrannus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyrannus' AND (species='tyrannus' OR species='tyrannus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyrannus' AND (species='tyrannus' OR species='tyrannus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannus' AND (junior_species='tyrannus' OR junior_species='tyrannus')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='tyrannus' OR species='tyrannus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')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='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='solitarius' OR junior_species='solitarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='solitarius' OR species='solitarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='solitarius' OR species='solitarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='solitarius' OR junior_species='solitarius')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='solitarius' OR species='solitarius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3078 The Ecological Register: Tantramar Marshes
Tantramar Marshes
Basic information
Sample name: Tantramar Marshes

Reference: G. F. Bennett, M. Cameron, and E. White. 1975. Hematozoa of the passeriforms of the Tantramar Marshes, New Brunswick. Canadian Journal of Zoology 53:1432-1442 [ER 2848]
Geography
Country: Canada

State: New Brunswick


Coordinate: 45° 55' N, 64° 18' W
Coordinate basis: based on nearby landmark

Geography comments: "in the Tantramar Marsh area on the shores of Long Lake, near Jolicure"
coordinate is based on Tantramar Marshes

Environment
Habitat: temperate wetland

Protection: unprotected

Substrate: ground surface

Habitat comments: "The nets were set in alders (Alnus rugosa) fringing the lakeshore"

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 3075 individuals

Years: 1972 - 1974

Nets or traps: 12

Sampling comments: birds were "caught in Japanese mist nets... the nets were set in the identical locations... for each of the 3 years. Each net was set for 2 days each week in each site"
12 nets are shown in Fig. 1
sampling effort is unclear because the number of weeks is not indicated

Metadata
Sample number: 3078

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-08-21 19:31:43

Modified: 2018-08-21 09:31:43

Abundance distribution
70 species
9 singletons
total count 3075
extrapolated richness: 89.8
Fisher's α: 12.752
geometric series k: 0.9182
Hurlbert's PIE: 0.9504
Shannon's H: 3.3808
Good's u: 0.9971
Each square represents a species. Square sizes are proportional to counts.
Register
Bombycilla cedrorum930.6 g insectivore-frugivore
Cyanocitta cristata6 insectivore-granivore
Perisoreus canadensis1
Coccyzus erythropthalmus1050.9 g
Carpodacus purpureus8623.3 g granivore
Hesperiphona vespertina3
Junco hyemalis91.6 g insectivore-granivore
Melospiza georgiana13316.1 g insectivore-granivore
Melospiza lincolnii3816.6 g insectivore-granivore
Melospiza melodia3601.6 g insectivore-granivore
Passerculus sandwichensis651.7 g insectivore
Pheucticus ludovicianus1842.0 g insectivore-frugivore
Pooecetes gramineus526.5 g insectivore
Spinus tristis14
Spizella arborea418.6 g
Spizella passerina412.2 g insectivore-granivore
Zonotrichia albicollis22524.4 g insectivore-granivore
Zonotrichia leucophrys12.0 g insectivore-granivore
Hirundo rustica252.1 g insectivore
Iridoprocne 'bicolor'11
Agelaius phoeniceus18565.3 g insectivore-granivore
Dolichonyx oryzivoros30
Molothrus ater173.4 g insectivore-granivore
Quiscalus quiscula15120 g insectivore-granivore
Dumetella carolinensis4635.3 g insectivore-frugivore
Poecile atricapillus3010.8 g
"Parus atricapillus"
Poecile hudsonicus14
"Parus hudsonicus"
Setophaga castanea1
"Dendroica castanea"
Setophaga caerulescens1
"Dendroica caerulescens"
Setophaga coronata70
"Dendroica coronata"
Setophaga fusca11
"Dendroica fusca"
Setophaga magnolia47
"Dendroica magnolia"
Setophaga palmarum8
"Dendroica palmarum"
Setophaga pensylvanica33
"Dendroica pensylvanica"
Setophaga petechia204
"Dendroica petechia"
Setophaga striata21
"Dendroica striata"
Setophaga tigrina20
"Dendroica tigrina"
Setophaga virens2
"Dendroica virens"
Geothlypis trichas772.1 g insectivore
Mniotilta varia1910.9 g insectivore
Oporornis philadelphia312.0 g insectivore
Parula americana122.8 g insectivore
Seiurus aurocapilla118.8 g insectivore
"Seiurus aurocapillus"
Parkesia noveboracensis22 insectivore
"Seiurus noveboracensis"
Setophaga ruticilla2248.4 g insectivore
Leiothlypis peregrina143
"Vermivora peregrina"
Leiothlypis ruficapilla14
"Vermivora ruficapilla"
Wilsonia canadensis3910.3 g insectivore-frugivore
Wilsonia pusilla342.6 g insectivore-frugivore
Colaptes auratus511.3 g insectivore-frugivore
Dendrocopos pubescens8
Dendrocopos villosus1
Fulica americana1724 g
Tringa semipalmata114.4 g
"Catoptrophorus semipalmatus"
Sturnus vulgaris127.9 g insectivore
Regulus calendula66.5 g insectivore
Regulus satrapa16.3 g insectivore
Archilochus colubris22.9 g nectarivore
Catharus guttatus2130.1 g insectivore-frugivore
Catharus ustulatus18030.3 g insectivore-frugivore
Turdus migratorius14378.5 g insectivore-frugivore
Contopus virens413.9 g insectivore
Empidonax flaviventris1011.8 g insectivore
Empidonax minimus410.0 g insectivore
Empidonax trailii69 insectivore
Empidonax sp.147
Nuttallornis borealis6
Tyrannus tyrannus36.5 g insectivore
Vireo olivaceus792.6 g insectivore-frugivore
Vireo solitarius215.3 g insectivore-frugivore