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=1121 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1121SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=777SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1121 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothoprocta' AND (junior_species='pentlandii' OR junior_species='pentlandi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nothoprocta' AND (species='pentlandii' OR species='pentlandi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nothoprocta' AND (species='pentlandii' OR species='pentlandi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothoprocta' AND (junior_species='pentlandii' OR junior_species='pentlandi')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='Nothoprocta' AND (species='pentlandii' OR species='pentlandi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patagioenas' AND (junior_species='fasciata' OR junior_species='fasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Patagioenas' AND (species='fasciata' OR species='fasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Patagioenas' AND (species='fasciata' OR species='fasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patagioenas' AND (junior_species='fasciata' OR junior_species='fasciata')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='Patagioenas' AND (species='fasciata' OR species='fasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='verreauxi' OR junior_species='verreauxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotila' AND (species='verreauxi' OR species='verreauxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotila' AND (species='verreauxi' OR species='verreauxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='verreauxi' OR junior_species='verreauxii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptotila' AND (species='verreauxi' OR species='verreauxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megascops' AND (junior_species='koepckeae' OR junior_species='koepckeae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megascops' AND (species='koepckeae' OR species='koepckeae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megascops' AND (species='koepckeae' OR species='koepckeae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megascops' AND (junior_species='koepckeae' OR junior_species='koepckeae')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='Megascops' AND (species='koepckeae' OR species='koepckeae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucidium' AND (junior_species='peruanum' OR junior_species='peruanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucidium' AND (species='peruanum' OR species='peruanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucidium' AND (species='peruanum' OR species='peruanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucidium' AND (junior_species='peruanum' OR junior_species='peruanum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glaucidium' AND (species='peruanum' OR species='peruanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colibri' AND (junior_species='coruscans' OR junior_species='coruscans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colibri' AND (species='coruscans' OR species='coruscans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colibri' AND (species='coruscans' OR species='coruscans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colibri' AND (junior_species='coruscans' OR junior_species='coruscans')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='Colibri' AND (species='coruscans' OR species='coruscans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliangelus' AND (junior_species='viola' OR junior_species='viola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliangelus' AND (species='viola' OR species='viola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliangelus' AND (species='viola' OR species='viola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliangelus' AND (junior_species='viola' OR junior_species='viola')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='Heliangelus' AND (species='viola' OR species='viola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyia' AND (junior_species='melanogenys' OR junior_species='melanogenys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelomyia' AND (species='melanogenys' OR species='melanogenys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyia' AND (species='melanogenys' OR species='melanogenys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyia' AND (junior_species='melanogenys' OR junior_species='melanogenys')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='Adelomyia' AND (species='melanogenys' OR species='melanogenys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lesbia' AND (junior_species='nuna' OR junior_species='nuna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lesbia' AND (species='nuna' OR species='nuna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lesbia' AND (species='nuna' OR species='nuna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lesbia' AND (junior_species='nuna' OR junior_species='nuna')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='Lesbia' AND (species='nuna' OR species='nuna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaeactis' AND (junior_species='cupripennis' OR junior_species='cupripennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglaeactis' AND (species='cupripennis' OR species='cupripennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglaeactis' AND (species='cupripennis' OR species='cupripennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglaeactis' AND (junior_species='cupripennis' OR junior_species='cupripennis')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='Aglaeactis' AND (species='cupripennis' OR species='cupripennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeligena' AND (junior_species='iris' OR junior_species='iris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeligena' AND (species='iris' OR species='iris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeligena' AND (species='iris' OR species='iris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeligena' AND (junior_species='iris' OR junior_species='iris')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='Coeligena' AND (species='iris' OR species='iris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lafresnaya' AND (junior_species='lafresnayi' OR junior_species='lafresnayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lafresnaya' AND (species='lafresnayi' OR species='lafresnayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lafresnaya' AND (species='lafresnayi' OR species='lafresnayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lafresnaya' AND (junior_species='lafresnayi' OR junior_species='lafresnayii')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='Lafresnaya' AND (species='lafresnayi' OR species='lafresnayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocercus' AND (junior_species='mulsant' OR junior_species='mulsant')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetocercus' AND (species='mulsant' OR species='mulsant') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetocercus' AND (species='mulsant' OR species='mulsant')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetocercus' AND (junior_species='mulsant' OR junior_species='mulsant')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='Chaetocercus' AND (species='mulsant' OR species='mulsant') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='amazilia' OR junior_species='amazilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amazilia' AND (species='amazilia' OR species='amazilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amazilia' AND (species='amazilia' OR species='amazilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='amazilia' OR junior_species='amazilia')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='Amazilia' AND (species='amazilia' OR species='amazilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='fumigatus' OR junior_species='fumigatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picoides' AND (species='fumigatus' OR species='fumigatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picoides' AND (species='fumigatus' OR species='fumigatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='fumigatus' OR junior_species='fumigatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Picoides' AND (species='fumigatus' OR species='fumigatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='atricollis' OR junior_species='atricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colaptes' AND (species='atricollis' OR species='atricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colaptes' AND (species='atricollis' OR species='atricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='atricollis' OR junior_species='atricollis')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='atricollis' OR species='atricollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bolborhynchus' AND (junior_species='orbygnesius' OR junior_species='orbygnesius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bolborhynchus' AND (species='orbygnesius' OR species='orbygnesius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bolborhynchus' AND (species='orbygnesius' OR species='orbygnesius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bolborhynchus' AND (junior_species='orbygnesius' OR junior_species='orbygnesius')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='Bolborhynchus' AND (species='orbygnesius' OR species='orbygnesius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grallaria' 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='Grallaria' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grallaria' AND (species='ruficapilla' OR species='ruficapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grallaria' 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='Grallaria' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scytalopus' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scytalopus' AND (species='unicolor' OR species='unicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scytalopus' AND (species='unicolor' OR species='unicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scytalopus' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scytalopus' AND (species='unicolor' OR species='unicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptasthenura' AND (junior_species='pileata' OR junior_species='pileata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptasthenura' AND (species='pileata' OR species='pileata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptasthenura' AND (species='pileata' OR species='pileata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptasthenura' AND (junior_species='pileata' OR junior_species='pileata')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='Leptasthenura' AND (species='pileata' OR species='pileata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cranioleuca' AND (junior_species='antisiensis' OR junior_species='antisiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cranioleuca' AND (species='antisiensis' OR species='antisiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cranioleuca' AND (species='antisiensis' OR species='antisiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cranioleuca' AND (junior_species='antisiensis' OR junior_species='antisiensis')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='Cranioleuca' AND (species='antisiensis' OR species='antisiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='azarae' OR junior_species='azarae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synallaxis' AND (species='azarae' OR species='azarae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synallaxis' AND (species='azarae' OR species='azarae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='azarae' OR junior_species='azarae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synallaxis' AND (species='azarae' OR species='azarae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomyias' AND (junior_species='uropygialis' OR junior_species='uropygialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllomyias' AND (species='uropygialis' OR species='uropygialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllomyias' AND (species='uropygialis' OR species='uropygialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllomyias' AND (junior_species='uropygialis' OR junior_species='uropygialis')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='Phyllomyias' AND (species='uropygialis' OR species='uropygialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='albiceps' OR junior_species='albiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='albiceps' OR species='albiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='albiceps' OR species='albiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='albiceps' OR junior_species='albiceps')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='Elaenia' AND (species='albiceps' OR species='albiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecocerculus' AND (junior_species='stictopterus' OR junior_species='stictopterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mecocerculus' AND (species='stictopterus' OR species='stictopterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mecocerculus' AND (species='stictopterus' OR species='stictopterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecocerculus' AND (junior_species='stictopterus' OR junior_species='stictopterus')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='Mecocerculus' AND (species='stictopterus' OR species='stictopterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecocerculus' 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='Mecocerculus' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mecocerculus' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecocerculus' 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='Mecocerculus' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anairetes' AND (junior_species='nigrocristatus' OR junior_species='nigrocristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anairetes' AND (species='nigrocristatus' OR species='nigrocristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anairetes' AND (species='nigrocristatus' OR species='nigrocristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anairetes' AND (junior_species='nigrocristatus' OR junior_species='nigrocristatus')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='Anairetes' AND (species='nigrocristatus' OR species='nigrocristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anairetes' AND (junior_species='flavirostris' OR junior_species='flavirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anairetes' AND (species='flavirostris' OR species='flavirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anairetes' AND (species='flavirostris' OR species='flavirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anairetes' AND (junior_species='flavirostris' OR junior_species='flavirostris')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='Anairetes' AND (species='flavirostris' OR species='flavirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeomyias' AND (junior_species='murina' OR junior_species='murina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaeomyias' AND (species='murina' OR species='murina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaeomyias' AND (species='murina' OR species='murina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeomyias' AND (junior_species='murina' OR junior_species='murina')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='Phaeomyias' AND (species='murina' OR species='murina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Contopus' AND (junior_species='cinereus' OR junior_species='cinereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Contopus' AND (species='cinereus' OR species='cinereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Contopus' AND (species='cinereus' OR species='cinereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Contopus' AND (junior_species='cinereus' OR junior_species='cinereus')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='cinereus' OR species='cinereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiotheretes' AND (junior_species='striaticollis' OR junior_species='striaticollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiotheretes' AND (species='striaticollis' OR species='striaticollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiotheretes' AND (species='striaticollis' OR species='striaticollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiotheretes' AND (junior_species='striaticollis' OR junior_species='striaticollis')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='Myiotheretes' AND (species='striaticollis' OR species='striaticollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' AND (junior_species='jelskii' OR junior_species='jelski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochthoeca' AND (species='jelskii' OR species='jelski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochthoeca' AND (species='jelskii' OR species='jelski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' AND (junior_species='jelskii' OR junior_species='jelski')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='Ochthoeca' AND (species='jelskii' OR species='jelski') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' AND (junior_species='piurae' OR junior_species='piurae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochthoeca' AND (species='piurae' OR species='piurae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochthoeca' AND (species='piurae' OR species='piurae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' AND (junior_species='piurae' OR junior_species='piurae')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='Ochthoeca' AND (species='piurae' OR species='piurae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' 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='Ochthoeca' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochthoeca' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' 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='Ochthoeca' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tuberculifer' OR junior_species='tuberculifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='tuberculifer' OR species='tuberculifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='tuberculifer' OR species='tuberculifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tuberculifer' OR junior_species='tuberculifer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiarchus' AND (species='tuberculifer' OR species='tuberculifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ampelion' AND (junior_species='rubrocristatus' OR junior_species='rubrocristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ampelion' AND (species='rubrocristatus' OR species='rubrocristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ampelion' AND (species='rubrocristatus' OR species='rubrocristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ampelion' AND (junior_species='rubrocristatus' OR junior_species='rubrocristatus')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='Ampelion' AND (species='rubrocristatus' OR species='rubrocristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclarhis' AND (junior_species='gujanensis' OR junior_species='gujanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclarhis' AND (species='gujanensis' OR species='gujanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclarhis' AND (species='gujanensis' OR species='gujanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclarhis' AND (junior_species='gujanensis' OR junior_species='gujanensis')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='Cyclarhis' AND (species='gujanensis' OR species='gujanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pygochelidon' AND (junior_species='cyanoleuca' OR junior_species='cyanoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pygochelidon' AND (species='cyanoleuca' OR species='cyanoleuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pygochelidon' AND (species='cyanoleuca' OR species='cyanoleuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pygochelidon' AND (junior_species='cyanoleuca' OR junior_species='cyanoleuca')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='Pygochelidon' AND (species='cyanoleuca' OR species='cyanoleuca') 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='Campylorhynchus' AND (junior_species='fasciatus' OR junior_species='fasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campylorhynchus' AND (species='fasciatus' OR species='fasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campylorhynchus' AND (species='fasciatus' OR species='fasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylorhynchus' AND (junior_species='fasciatus' OR junior_species='fasciatus')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='fasciatus' OR species='fasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinclus' AND (junior_species='leucocephalus' OR junior_species='leucocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinclus' AND (species='leucocephalus' OR species='leucocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinclus' AND (species='leucocephalus' OR species='leucocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinclus' AND (junior_species='leucocephalus' OR junior_species='leucocephalus')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='Cinclus' AND (species='leucocephalus' OR species='leucocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='fuscater' OR junior_species='fuscater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='fuscater' OR species='fuscater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='fuscater' OR species='fuscater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='fuscater' OR junior_species='fuscater')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='fuscater' OR species='fuscater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='fuscater' OR junior_species='fuscater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='fuscater' OR species='fuscater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='fuscater' OR species='fuscater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='fuscater' OR junior_species='fuscater')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='fuscater' OR species='fuscater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='chiguanco' OR junior_species='chiguanco')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='chiguanco' OR species='chiguanco') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='chiguanco' OR species='chiguanco')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='chiguanco' OR junior_species='chiguanco')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='chiguanco' OR species='chiguanco') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemispingus' AND (junior_species='melanotis' OR junior_species='melanotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemispingus' AND (species='melanotis' OR species='melanotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemispingus' AND (species='melanotis' OR species='melanotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemispingus' AND (junior_species='melanotis' OR junior_species='melanotis')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='Hemispingus' AND (species='melanotis' OR species='melanotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thlypopsis' AND (junior_species='ornata' OR junior_species='ornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thlypopsis' AND (species='ornata' OR species='ornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thlypopsis' AND (species='ornata' OR species='ornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thlypopsis' AND (junior_species='ornata' OR junior_species='ornata')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='Thlypopsis' AND (species='ornata' OR species='ornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='bonariensis' OR junior_species='bonariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thraupis' AND (species='bonariensis' OR species='bonariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thraupis' AND (species='bonariensis' OR species='bonariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='bonariensis' OR junior_species='bonariensis')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='Thraupis' AND (species='bonariensis' OR species='bonariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='vassorii' OR junior_species='vassori')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='vassorii' OR species='vassori') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='vassorii' OR species='vassori')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='vassorii' OR junior_species='vassori')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='Tangara' AND (species='vassorii' OR species='vassori') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conirostrum' AND (junior_species='cinereum' OR junior_species='cinereum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conirostrum' AND (species='cinereum' OR species='cinereum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conirostrum' AND (species='cinereum' OR species='cinereum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conirostrum' AND (junior_species='cinereum' OR junior_species='cinereum')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='Conirostrum' AND (species='cinereum' OR species='cinereum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='sittoides' OR junior_species='sittoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossa' AND (species='sittoides' OR species='sittoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossa' AND (species='sittoides' OR species='sittoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='sittoides' OR junior_species='sittoides')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='Diglossa' AND (species='sittoides' OR species='sittoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catamblyrhynchus' AND (junior_species='diadema' OR junior_species='diadema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catamblyrhynchus' AND (species='diadema' OR species='diadema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catamblyrhynchus' AND (species='diadema' OR species='diadema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catamblyrhynchus' AND (junior_species='diadema' OR junior_species='diadema')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='Catamblyrhynchus' AND (species='diadema' OR species='diadema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catamenia' AND (junior_species='analis' OR junior_species='analis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catamenia' AND (species='analis' OR species='analis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catamenia' AND (species='analis' OR species='analis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catamenia' AND (junior_species='analis' OR junior_species='analis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catamenia' AND (species='analis' OR species='analis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='aurantiirostris' OR junior_species='aurantiirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='aurantiirostris' OR species='aurantiirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='aurantiirostris' OR species='aurantiirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='aurantiirostris' OR junior_species='aurantiirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Saltator' AND (species='aurantiirostris' OR species='aurantiirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonotrichia' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonotrichia' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='capensis' OR junior_species='capensis')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='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='assimilis' OR junior_species='assimilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arremon' AND (species='assimilis' OR species='assimilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremon' AND (species='assimilis' OR species='assimilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='assimilis' OR junior_species='assimilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arremon' AND (species='assimilis' OR species='assimilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' AND (junior_species='latinuchus' OR junior_species='latinuchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atlapetes' AND (species='latinuchus' OR species='latinuchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atlapetes' AND (species='latinuchus' OR species='latinuchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' AND (junior_species='latinuchus' OR junior_species='latinuchus')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='Atlapetes' AND (species='latinuchus' OR species='latinuchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' AND (junior_species='seebohmi' OR junior_species='seebohmii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atlapetes' AND (species='seebohmi' OR species='seebohmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atlapetes' AND (species='seebohmi' OR species='seebohmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' AND (junior_species='seebohmi' OR junior_species='seebohmii')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='Atlapetes' AND (species='seebohmi' OR species='seebohmii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='flava' OR junior_species='flava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piranga' AND (species='flava' OR species='flava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piranga' AND (species='flava' OR species='flava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='flava' OR junior_species='flava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Piranga' AND (species='flava' OR species='flava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheucticus' AND (junior_species='chrysogaster' OR junior_species='chrysogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheucticus' AND (species='chrysogaster' OR species='chrysogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheucticus' AND (species='chrysogaster' OR species='chrysogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheucticus' AND (junior_species='chrysogaster' OR junior_species='chrysogaster')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='chrysogaster' OR species='chrysogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myioborus' AND (junior_species='miniatus' OR junior_species='miniatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myioborus' AND (species='miniatus' OR species='miniatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myioborus' AND (species='miniatus' OR species='miniatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myioborus' AND (junior_species='miniatus' OR junior_species='miniatus')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='Myioborus' AND (species='miniatus' OR species='miniatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='nigricristatus' OR junior_species='nigricristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='nigricristatus' OR species='nigricristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='nigricristatus' OR species='nigricristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='nigricristatus' OR junior_species='nigricristatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Basileuterus' AND (species='nigricristatus' OR species='nigricristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='trifasciatus' OR junior_species='trifasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='trifasciatus' OR species='trifasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='trifasciatus' OR species='trifasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='trifasciatus' OR junior_species='trifasciatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Basileuterus' AND (species='trifasciatus' OR species='trifasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dives' AND (junior_species='warszewiczi' OR junior_species='warszewiczii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dives' AND (species='warszewiczi' OR species='warszewiczii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dives' AND (species='warszewiczi' OR species='warszewiczii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dives' AND (junior_species='warszewiczi' OR junior_species='warszewiczii')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='Dives' AND (species='warszewiczi' OR species='warszewiczii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporagra' AND (junior_species='magellanica' OR junior_species='magellanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporagra' AND (species='magellanica' OR species='magellanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporagra' AND (species='magellanica' OR species='magellanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporagra' AND (junior_species='magellanica' OR junior_species='magellanica')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='Sporagra' AND (species='magellanica' OR species='magellanica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1121 The Ecological Register: Cachil Valley
Cachil Valley
Basic information
Sample name: Cachil Valley

Sample aka: Bosque Cachil

Reference: C. J. Schmitt, D. C. Schmitt, J. Tiravanti, F. Angulo, I. Franke, L. M. Vallejos, L. Pollack, and C. C. Witt. 2013. Avifauna of a relict Podocarpus forest in the Cachil Valley, north-west Peru. Cotinga 35:15-23 [ER 777]
Geography
Country: Peru


Coordinate: 7° 24' S, 78° 47' W
Coordinate basis: estimated from map

Geography comments: "at the southern border of Cajamarca directly adjacent to La Libertad"
elevation 2200 to 3200 m

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

WMT: 16.3

CMT: 14.6

MAP: 895.0

Habitat comments: "semi-humid scrub and forest, as well as a well-preserved humid forest relict"
climate data based on station 84472 (Cajamarca airport), which is at essentially the same elevation

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 582 individuals

Years: 2010

Net or trap nights: 196

Sampling comments: "Up to 13 mist-nets (12 × 2 m; 32–36 mm mesh diameter) were opened before daylight (usually by 05h00) and closed after dusk (usually after 18h00) daily" for a total of 2544 mist net hours (= approximately 196 mist net days)

Metadata
Sample number: 1121

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-29 11:21:43

Modified: 2014-08-29 01:21:43

Abundance distribution
64 species
8 singletons
total count 582
extrapolated richness: 91.5
Fisher's α: 18.349
geometric series k: 0.9376
Hurlbert's PIE: 0.9600
Shannon's H: 3.6318
Good's u: 0.9863
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Nothoprocta pentlandii318.4 g insectivore-frugivore
Patagioenas fasciata219.9 g
Leptotila verreauxi decolor311.6 g granivore-frugivore
Megascops koepckeae4
Glaucidium peruanum160.4 g
Colibri coruscans516.7 g nectarivore-insectivore
Heliangelus viola175.4 g
Adelomyia melanogenys maculata582.3 g nectarivore-insectivore
Lesbia nuna143.7 g nectarivore-insectivore
Aglaeactis cupripennis117.6 g
Coeligena iris eva436.9 g
Lafresnaya lafresnayi35.3 g nectarivore-insectivore
Chaetocercus mulsant53.9 g nectarivore-insectivore
Amazilia amazilia leucophoea14.3 g
Picoides fumigatus6 insectivore
Colaptes atricollis378.7 g
Bolborhynchus orbygnesius843.1 g frugivore
Grallaria ruficapilla59.2 g insectivore
Scytalopus unicolor718.5 g
Leptasthenura pileata cajabambae810.3 g
Cranioleuca antisiensis24.3 g
Synallaxis azarae elegantior516.9 g insectivore
Phyllomyias uropygialis19.4 g insectivore
Elaenia albiceps1415.5 g insectivore-frugivore
Mecocerculus stictopterus179.4 g
Mecocerculus leucophrys brunneomarginatus43.4 g insectivore
Anairetes nigrocristatus1
Anairetes flavirostris56.0 g insectivore
Phaeomyias murina inflava110.0 g insectivore
Contopus cinereus311.6 g insectivore
Myiotheretes striaticollis261.2 g insectivore
Ochthoeca jelskii1011.6 g
Ochthoeca piurae3
Ochthoeca leucophrys113.1 g insectivore
Myiarchus tuberculifer52.3 g insectivore-frugivore
Ampelion rubrocristatus1366.3 g frugivore
Cyclarhis gujanensis virenticeps928.8 g insectivore-frugivore
Pygochelidon cyanoleuca cyanoleuca59.7 g insectivore
Troglodytes aedon51.8 g insectivore
Campylorhynchus fasciatus530.0 g
Cinclus leucocephalus leucocephalus144.0 g insectivore
Catharus fuscater633.7 g
Turdus fuscater3143 g insectivore-frugivore
Turdus chiguanco193.3 g insectivore-frugivore
Hemispingus melanotis3116.0 g insectivore
Thlypopsis ornata812.0 g
Thraupis bonariensis636.0 g frugivore-insectivore
Tangara vassorii vassorii2318.0 g frugivore-insectivore
Conirostrum cinereum littorale108.8 g insectivore-frugivore
Diglossa sittoides39.0 g nectarivore
Catamblyrhynchus diadema214.9 g insectivore-frugivore
Catamenia analis912.0 g frugivore
Saltator aurantiirostris239.0 g frugivore
Zonotrichia capensis322.1 g granivore
Arremon assimilis3
Atlapetes latinuchus baroni92.8 g
Atlapetes seebohmi14
Piranga flava337.7 g frugivore-insectivore
Pheucticus chrysogaster655.8 g
Myioborus miniatus109.0 g insectivore
Basileuterus nigricristatus13
Basileuterus trifasciatus59.7 g
Dives warszewiczi273.3 g
Sporagra magellanica16