Coordinate: 21° 45' 0" S, 46° 37' 30" W
altitude 1033 to 1493 m
climate data based on Queirolo and Granzinolli (2009)
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=1118 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1118SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=775SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1118 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='rufaxilla' OR junior_species='rufaxilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotila' AND (species='rufaxilla' OR species='rufaxilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotila' AND (species='rufaxilla' OR species='rufaxilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='rufaxilla' OR junior_species='rufaxilla')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='rufaxilla' OR species='rufaxilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scytalopus' AND (junior_species='novacapitalis' OR junior_species='novacapitalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scytalopus' AND (species='novacapitalis' OR species='novacapitalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scytalopus' AND (species='novacapitalis' OR species='novacapitalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scytalopus' AND (junior_species='novacapitalis' OR junior_species='novacapitalis')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='novacapitalis' OR species='novacapitalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' 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='Thamnophilus' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' 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='Thamnophilus' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysithamnus' AND (junior_species='mentalis' OR junior_species='mentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysithamnus' AND (species='mentalis' OR species='mentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysithamnus' AND (species='mentalis' OR species='mentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysithamnus' AND (junior_species='mentalis' OR junior_species='mentalis')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='Dysithamnus' AND (species='mentalis' OR species='mentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopophaga' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conopophaga' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conopophaga' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopophaga' AND (junior_species='lineata' OR junior_species='lineata')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='Conopophaga' AND (species='lineata' OR species='lineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lochmias' AND (junior_species='nematura' OR junior_species='nematura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lochmias' AND (species='nematura' OR species='nematura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lochmias' AND (species='nematura' OR species='nematura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lochmias' AND (junior_species='nematura' OR junior_species='nematura')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='Lochmias' AND (species='nematura' OR species='nematura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='dimidiatus' OR junior_species='dimidiatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philydor' AND (species='dimidiatus' OR species='dimidiatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philydor' AND (species='dimidiatus' OR species='dimidiatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='dimidiatus' OR junior_species='dimidiatus')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='Philydor' AND (species='dimidiatus' OR species='dimidiatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='obscura' OR junior_species='obscura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='obscura' OR species='obscura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='obscura' OR species='obscura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='obscura' OR junior_species='obscura')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='obscura' OR species='obscura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathrotriccus' AND (junior_species='euleri' OR junior_species='eulerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lathrotriccus' AND (species='euleri' OR species='eulerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lathrotriccus' AND (species='euleri' OR species='eulerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathrotriccus' AND (junior_species='euleri' OR junior_species='eulerii')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='Lathrotriccus' AND (species='euleri' OR species='eulerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='mystaceus' OR junior_species='mystaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrinchus' AND (species='mystaceus' OR species='mystaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyrinchus' AND (species='mystaceus' OR species='mystaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='mystaceus' OR junior_species='mystaceus')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='Platyrinchus' AND (species='mystaceus' OR species='mystaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopogon' AND (junior_species='amaurocephalus' OR junior_species='amaurocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopogon' AND (junior_species='amaurocephalus' OR junior_species='amaurocephalus')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='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscartes' AND (junior_species='ventralis' OR junior_species='ventralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscartes' AND (species='ventralis' OR species='ventralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscartes' AND (species='ventralis' OR species='ventralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscartes' AND (junior_species='ventralis' OR junior_species='ventralis')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='Phylloscartes' AND (species='ventralis' OR species='ventralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antilophia' AND (junior_species='galeata' OR junior_species='galeata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antilophia' AND (species='galeata' OR species='galeata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Antilophia' AND (species='galeata' OR species='galeata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antilophia' AND (junior_species='galeata' OR junior_species='galeata')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='Antilophia' AND (species='galeata' OR species='galeata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='subalaris' OR junior_species='subalaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='subalaris' OR species='subalaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='subalaris' OR species='subalaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='subalaris' OR junior_species='subalaris')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='subalaris' OR species='subalaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='culicivorus' OR junior_species='culicivorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='culicivorus' OR species='culicivorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='culicivorus' OR species='culicivorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='culicivorus' OR junior_species='culicivorus')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='culicivorus' OR species='culicivorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' 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='Basileuterus' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' 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='Basileuterus' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='leucoblepharus' OR junior_species='leucoblepharus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='leucoblepharus' OR species='leucoblepharus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='leucoblepharus' OR species='leucoblepharus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='leucoblepharus' OR junior_species='leucoblepharus')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='leucoblepharus' OR species='leucoblepharus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyphonus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyphonus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachyphonus' AND (species='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipraeidea' AND (junior_species='melanonota' OR junior_species='melanonota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipraeidea' AND (species='melanonota' OR species='melanonota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipraeidea' AND (species='melanonota' OR species='melanonota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipraeidea' AND (junior_species='melanonota' OR junior_species='melanonota')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='Pipraeidea' AND (species='melanonota' OR species='melanonota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tersina' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tersina' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tersina' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tersina' AND (junior_species='viridis' OR junior_species='viridis')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='Tersina' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' AND (junior_species='melacoryphus' OR junior_species='melacoryphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccyzus' AND (species='melacoryphus' OR species='melacoryphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccyzus' AND (species='melacoryphus' OR species='melacoryphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' AND (junior_species='melacoryphus' OR junior_species='melacoryphus')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='melacoryphus' OR species='melacoryphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalurania' AND (junior_species='furcata' OR junior_species='furcata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thalurania' AND (species='furcata' OR species='furcata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thalurania' AND (species='furcata' OR species='furcata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalurania' AND (junior_species='furcata' OR junior_species='furcata')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='Thalurania' AND (species='furcata' OR species='furcata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colibri' AND (junior_species='serrirostris' OR junior_species='serrirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colibri' AND (species='serrirostris' OR species='serrirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colibri' AND (species='serrirostris' OR species='serrirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colibri' AND (junior_species='serrirostris' OR junior_species='serrirostris')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='serrirostris' OR species='serrirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='pretrei' OR junior_species='pretreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='pretrei' OR species='pretreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='pretrei' OR species='pretreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='pretrei' OR junior_species='pretreii')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='Phaethornis' AND (species='pretrei' OR species='pretreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorostilbon' AND (junior_species='aureoventris' OR junior_species='aureoventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorostilbon' AND (species='aureoventris' OR species='aureoventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorostilbon' AND (species='aureoventris' OR species='aureoventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorostilbon' AND (junior_species='aureoventris' OR junior_species='aureoventris')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='Chlorostilbon' AND (species='aureoventris' OR species='aureoventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' 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='Chloroceryle' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroceryle' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' 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='Chloroceryle' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='cirratus' OR junior_species='cirratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picumnus' AND (species='cirratus' OR species='cirratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picumnus' AND (species='cirratus' OR species='cirratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='cirratus' OR junior_species='cirratus')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='Picumnus' AND (species='cirratus' OR species='cirratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='passerinus' OR junior_species='passerinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Veniliornis' AND (species='passerinus' OR species='passerinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Veniliornis' AND (species='passerinus' OR species='passerinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='passerinus' OR junior_species='passerinus')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='Veniliornis' AND (species='passerinus' OR species='passerinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='spixi' OR junior_species='spixii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synallaxis' AND (species='spixi' OR species='spixii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synallaxis' AND (species='spixi' OR species='spixii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='spixi' OR junior_species='spixii')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='spixi' OR species='spixii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phacellodomus' AND (junior_species='rufifrons' OR junior_species='rufifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phacellodomus' AND (species='rufifrons' OR species='rufifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phacellodomus' AND (species='rufifrons' OR species='rufifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phacellodomus' AND (junior_species='rufifrons' OR junior_species='rufifrons')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='Phacellodomus' AND (species='rufifrons' OR species='rufifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='ferox' OR junior_species='ferox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='ferox' OR species='ferox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='ferox' OR species='ferox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='ferox' OR junior_species='ferox')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='ferox' OR species='ferox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Todirostrum' 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='Todirostrum' AND (species='cinereum' OR species='cinereum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Todirostrum' AND (species='cinereum' OR species='cinereum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Todirostrum' 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='Todirostrum' AND (species='cinereum' OR species='cinereum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpophaga' AND (junior_species='subcristata' OR junior_species='subcristata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serpophaga' AND (species='subcristata' OR species='subcristata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serpophaga' AND (species='subcristata' OR species='subcristata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpophaga' AND (junior_species='subcristata' OR junior_species='subcristata')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='Serpophaga' AND (species='subcristata' OR species='subcristata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='flavogaster' OR junior_species='flavogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='flavogaster' OR species='flavogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='flavogaster' OR species='flavogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='flavogaster' OR junior_species='flavogaster')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='flavogaster' OR species='flavogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='leucomelas' OR junior_species='leucomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='leucomelas' OR species='leucomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='leucomelas' OR species='leucomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='leucomelas' OR junior_species='leucomelas')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='leucomelas' OR species='leucomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='sayaca' OR junior_species='sayaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thraupis' AND (species='sayaca' OR species='sayaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thraupis' AND (species='sayaca' OR species='sayaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='sayaca' OR junior_species='sayaca')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='sayaca' OR species='sayaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacnis' AND (junior_species='cayana' OR junior_species='cayana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dacnis' AND (species='cayana' OR species='cayana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dacnis' AND (species='cayana' OR species='cayana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dacnis' AND (junior_species='cayana' OR junior_species='cayana')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='Dacnis' AND (species='cayana' OR species='cayana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='similis' OR junior_species='similis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='similis' OR junior_species='similis')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='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupetomena' AND (junior_species='macroura' OR junior_species='macroura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupetomena' AND (species='macroura' OR species='macroura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupetomena' AND (species='macroura' OR species='macroura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupetomena' AND (junior_species='macroura' OR junior_species='macroura')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='Eupetomena' AND (species='macroura' OR species='macroura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='angustirostris' OR junior_species='angustirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidocolaptes' AND (species='angustirostris' OR species='angustirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidocolaptes' AND (species='angustirostris' OR species='angustirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='angustirostris' OR junior_species='angustirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lepidocolaptes' AND (species='angustirostris' OR species='angustirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiophobus' 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='Myiophobus' AND (species='fasciatus' OR species='fasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiophobus' AND (species='fasciatus' OR species='fasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiophobus' 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='Myiophobus' AND (species='fasciatus' OR species='fasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpophaga' AND (junior_species='nigricans' OR junior_species='nigricans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serpophaga' AND (species='nigricans' OR species='nigricans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serpophaga' AND (species='nigricans' OR species='nigricans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpophaga' AND (junior_species='nigricans' OR junior_species='nigricans')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='Serpophaga' AND (species='nigricans' OR species='nigricans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knipolegus' AND (junior_species='lophotes' OR junior_species='lophotes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Knipolegus' AND (species='lophotes' OR species='lophotes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Knipolegus' AND (species='lophotes' OR species='lophotes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Knipolegus' AND (junior_species='lophotes' OR junior_species='lophotes')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='Knipolegus' AND (species='lophotes' OR species='lophotes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culicivora' AND (junior_species='caudacuta' OR junior_species='caudacuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Culicivora' AND (species='caudacuta' OR species='caudacuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Culicivora' AND (species='caudacuta' OR species='caudacuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Culicivora' AND (junior_species='caudacuta' OR junior_species='caudacuta')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='Culicivora' AND (species='caudacuta' OR species='caudacuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='chiriquensis' OR junior_species='chiriquensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='chiriquensis' OR species='chiriquensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='chiriquensis' OR species='chiriquensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='chiriquensis' OR junior_species='chiriquensis')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='chiriquensis' OR species='chiriquensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alectrurus' AND (junior_species='tricolor' OR junior_species='tricolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alectrurus' AND (species='tricolor' OR species='tricolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alectrurus' AND (species='tricolor' OR species='tricolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alectrurus' AND (junior_species='tricolor' OR junior_species='tricolor')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='Alectrurus' AND (species='tricolor' OR species='tricolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannus' AND (junior_species='melancholicus' OR junior_species='melancholicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyrannus' AND (species='melancholicus' OR species='melancholicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyrannus' AND (species='melancholicus' OR species='melancholicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannus' AND (junior_species='melancholicus' OR junior_species='melancholicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tyrannus' AND (species='melancholicus' OR species='melancholicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' 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='Elaenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' 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='Elaenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' 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='Myiarchus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' 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='Myiarchus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stelgidopteryx' AND (junior_species='ruficollis' OR junior_species='ruficollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stelgidopteryx' AND (species='ruficollis' OR species='ruficollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stelgidopteryx' AND (species='ruficollis' OR species='ruficollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stelgidopteryx' AND (junior_species='ruficollis' OR junior_species='ruficollis')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='Stelgidopteryx' AND (species='ruficollis' OR species='ruficollis') 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='Schistochlamys' AND (junior_species='ruficapillus' OR junior_species='ruficapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schistochlamys' AND (species='ruficapillus' OR species='ruficapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schistochlamys' AND (species='ruficapillus' OR species='ruficapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schistochlamys' AND (junior_species='ruficapillus' OR junior_species='ruficapillus')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='Schistochlamys' AND (species='ruficapillus' OR species='ruficapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='cayana' OR junior_species='cayana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='cayana' OR species='cayana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='cayana' OR species='cayana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='cayana' OR junior_species='cayana')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='cayana' OR species='cayana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='aequinoctialis' OR junior_species='aequinoctialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geothlypis' AND (species='aequinoctialis' OR species='aequinoctialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geothlypis' AND (species='aequinoctialis' OR species='aequinoctialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geothlypis' AND (junior_species='aequinoctialis' OR junior_species='aequinoctialis')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='aequinoctialis' OR species='aequinoctialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberizoides' AND (junior_species='herbicola' OR junior_species='herbicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberizoides' AND (species='herbicola' OR species='herbicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberizoides' AND (species='herbicola' OR species='herbicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberizoides' AND (junior_species='herbicola' OR junior_species='herbicola')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='Emberizoides' AND (species='herbicola' OR species='herbicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Embernagra' AND (junior_species='platensis' OR junior_species='platensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Embernagra' AND (species='platensis' OR species='platensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Embernagra' AND (species='platensis' OR species='platensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Embernagra' AND (junior_species='platensis' OR junior_species='platensis')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='Embernagra' AND (species='platensis' OR species='platensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sicalis' AND (junior_species='citrina' OR junior_species='citrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sicalis' AND (species='citrina' OR species='citrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sicalis' AND (species='citrina' OR species='citrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sicalis' AND (junior_species='citrina' OR junior_species='citrina')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='Sicalis' AND (species='citrina' OR species='citrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Volatinia' AND (junior_species='jacarina' OR junior_species='jacarina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Volatinia' AND (species='jacarina' OR species='jacarina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Volatinia' AND (species='jacarina' OR species='jacarina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Volatinia' AND (junior_species='jacarina' OR junior_species='jacarina')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='Volatinia' AND (species='jacarina' OR species='jacarina') 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='Ammodramus' AND (junior_species='humeralis' OR junior_species='humeralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ammodramus' AND (species='humeralis' OR species='humeralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ammodramus' AND (species='humeralis' OR species='humeralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammodramus' AND (junior_species='humeralis' OR junior_species='humeralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ammodramus' AND (species='humeralis' OR species='humeralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='nigricollis' OR junior_species='nigricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='nigricollis' OR species='nigricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='nigricollis' OR species='nigricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='nigricollis' OR junior_species='nigricollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sporophila' AND (species='nigricollis' OR species='nigricollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' 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='Sporophila' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' 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='Sporophila' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='plumbea' OR junior_species='plumbea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='plumbea' OR species='plumbea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='plumbea' OR species='plumbea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='plumbea' OR junior_species='plumbea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sporophila' AND (species='plumbea' OR species='plumbea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porphyrospiza' 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='Porphyrospiza' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Porphyrospiza' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porphyrospiza' 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='Porphyrospiza' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' 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='Sporophila' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' 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='Sporophila' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnorimopsar' AND (junior_species='chopi' OR junior_species='chopii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gnorimopsar' AND (species='chopi' OR species='chopii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gnorimopsar' AND (species='chopi' OR species='chopii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gnorimopsar' AND (junior_species='chopi' OR junior_species='chopii')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='Gnorimopsar' AND (species='chopi' OR species='chopii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='magellanicus' OR junior_species='magellanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carduelis' AND (species='magellanicus' OR species='magellanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carduelis' AND (species='magellanicus' OR species='magellanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='magellanicus' OR junior_species='magellanicus')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='Carduelis' AND (species='magellanicus' OR species='magellanicus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1118