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=1384 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1384SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=921SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1384 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='corvina' OR junior_species='corvina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='corvina' OR species='corvina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='corvina' OR species='corvina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='corvina' OR junior_species='corvina')SELECT d.diet,d.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='corvina' OR species='corvina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manacus' AND (junior_species='candei' OR junior_species='candeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Manacus' AND (species='candei' OR species='candeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Manacus' AND (species='candei' OR species='candeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Manacus' AND (junior_species='candei' OR junior_species='candeii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Manacus' AND (species='candei' OR species='candeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphocelus' AND (junior_species='passerinii' OR junior_species='passerini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphocelus' AND (species='passerinii' OR species='passerini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphocelus' AND (species='passerinii' OR species='passerini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphocelus' AND (junior_species='passerinii' OR junior_species='passerini')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ramphocelus' AND (species='passerinii' OR species='passerini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='oleagineus' OR junior_species='oleagineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mionectes' AND (species='oleagineus' OR species='oleagineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mionectes' AND (species='oleagineus' OR species='oleagineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='oleagineus' OR junior_species='oleagineus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mionectes' AND (species='oleagineus' OR species='oleagineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='superciliosus' OR species='superciliosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='superciliosus' OR species='superciliosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT d.diet,d.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='superciliosus' OR species='superciliosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocharis' AND (junior_species='eliciae' OR junior_species='eliciae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylocharis' AND (species='eliciae' OR species='eliciae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylocharis' AND (species='eliciae' OR species='eliciae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocharis' AND (junior_species='eliciae' OR junior_species='eliciae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylocharis' AND (species='eliciae' OR species='eliciae') 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='Saltator' AND (junior_species='maximus' OR junior_species='maximus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='maximus' OR species='maximus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='maximus' OR species='maximus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='maximus' OR junior_species='maximus')SELECT d.diet,d.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='maximus' OR species='maximus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiaris' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiaris' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiaris' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiaris' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tiaris' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocompsa' AND (junior_species='cyanoides' OR junior_species='cyanoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanocompsa' AND (species='cyanoides' OR species='cyanoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanocompsa' AND (species='cyanoides' OR species='cyanoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocompsa' AND (junior_species='cyanoides' OR junior_species='cyanoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyanocompsa' AND (species='cyanoides' OR species='cyanoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryzoborus' AND (junior_species='funereus' OR junior_species='funereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryzoborus' AND (species='funereus' OR species='funereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oryzoborus' AND (species='funereus' OR species='funereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryzoborus' AND (junior_species='funereus' OR junior_species='funereus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oryzoborus' AND (species='funereus' OR species='funereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' 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='Pipra' AND (species='mentalis' OR species='mentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='mentalis' OR species='mentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' 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='Pipra' AND (species='mentalis' OR species='mentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='longuemareus' OR junior_species='longuemareus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='longuemareus' OR species='longuemareus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='longuemareus' OR species='longuemareus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='longuemareus' OR junior_species='longuemareus')SELECT d.diet,d.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='longuemareus' OR species='longuemareus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' 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='Arremon' AND (species='aurantiirostris' OR species='aurantiirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremon' AND (species='aurantiirostris' OR species='aurantiirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' 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='Arremon' AND (species='aurantiirostris' OR species='aurantiirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habia' AND (junior_species='fuscicauda' OR junior_species='fuscicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Habia' AND (species='fuscicauda' OR species='fuscicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Habia' AND (species='fuscicauda' OR species='fuscicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habia' AND (junior_species='fuscicauda' OR junior_species='fuscicauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Habia' AND (species='fuscicauda' OR species='fuscicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='ochrolaemus' OR junior_species='ochrolaemus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Automolus' AND (species='ochrolaemus' OR species='ochrolaemus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Automolus' AND (species='ochrolaemus' OR species='ochrolaemus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='ochrolaemus' OR junior_species='ochrolaemus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Automolus' AND (species='ochrolaemus' OR species='ochrolaemus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphorhynchus' AND (junior_species='spirurus' OR junior_species='spirurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glyphorhynchus' AND (species='spirurus' OR species='spirurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glyphorhynchus' AND (species='spirurus' OR species='spirurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphorhynchus' AND (junior_species='spirurus' OR junior_species='spirurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glyphorhynchus' AND (species='spirurus' OR species='spirurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Threnetes' AND (junior_species='ruckeri' OR junior_species='ruckerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Threnetes' AND (species='ruckeri' OR species='ruckerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Threnetes' AND (species='ruckeri' OR species='ruckerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Threnetes' AND (junior_species='ruckeri' OR junior_species='ruckerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Threnetes' AND (species='ruckeri' OR species='ruckerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucometis' AND (junior_species='penicillata' OR junior_species='penicillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucometis' AND (species='penicillata' OR species='penicillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucometis' AND (species='penicillata' OR species='penicillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucometis' AND (junior_species='penicillata' OR junior_species='penicillata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eucometis' AND (species='penicillata' OR species='penicillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocichla' AND (junior_species='mustelina' OR junior_species='mustelina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylocichla' AND (species='mustelina' OR species='mustelina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylocichla' AND (species='mustelina' OR species='mustelina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocichla' AND (junior_species='mustelina' OR junior_species='mustelina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylocichla' AND (species='mustelina' OR species='mustelina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oncostoma' AND (junior_species='cinereigulare' OR junior_species='cinereigulare')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oncostoma' AND (species='cinereigulare' OR species='cinereigulare') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oncostoma' AND (species='cinereigulare' OR species='cinereigulare')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oncostoma' AND (junior_species='cinereigulare' OR junior_species='cinereigulare')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oncostoma' AND (species='cinereigulare' OR species='cinereigulare') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremonops' AND (junior_species='conirostris' OR junior_species='conirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arremonops' AND (species='conirostris' OR species='conirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremonops' AND (species='conirostris' OR species='conirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremonops' AND (junior_species='conirostris' OR junior_species='conirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arremonops' AND (species='conirostris' OR species='conirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='cyanea' OR junior_species='cyanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passerina' AND (species='cyanea' OR species='cyanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passerina' AND (species='cyanea' OR species='cyanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerina' AND (junior_species='cyanea' OR junior_species='cyanea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Passerina' AND (species='cyanea' OR species='cyanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corapipo' AND (junior_species='leucorrhoa' OR junior_species='leucorrhoa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corapipo' AND (species='leucorrhoa' OR species='leucorrhoa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corapipo' AND (species='leucorrhoa' OR species='leucorrhoa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corapipo' AND (junior_species='leucorrhoa' OR junior_species='leucorrhoa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corapipo' AND (species='leucorrhoa' OR species='leucorrhoa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seiurus' AND (junior_species='aurocapilla' OR junior_species='aurocapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seiurus' AND (junior_species='aurocapilla' OR junior_species='aurocapilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Seiurus' AND (species='aurocapilla' OR species='aurocapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='grayi' OR junior_species='grayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='grayi' OR species='grayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='grayi' OR species='grayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='grayi' OR junior_species='grayii')SELECT d.diet,d.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='grayi' OR species='grayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oporornis' AND (junior_species='formosus' OR junior_species='formosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oporornis' AND (species='formosus' OR species='formosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oporornis' AND (species='formosus' OR species='formosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oporornis' AND (junior_species='formosus' OR junior_species='formosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oporornis' AND (species='formosus' OR species='formosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' 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='Platyrinchus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyrinchus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' 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='Platyrinchus' AND (species='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucis' AND (junior_species='aenea' OR junior_species='aenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucis' AND (species='aenea' OR species='aenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucis' AND (species='aenea' OR species='aenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucis' AND (junior_species='aenea' OR junior_species='aenea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glaucis' AND (species='aenea' OR species='aenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='cancrominus' OR junior_species='cancrominus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrinchus' AND (species='cancrominus' OR species='cancrominus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyrinchus' AND (species='cancrominus' OR species='cancrominus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='cancrominus' OR junior_species='cancrominus')SELECT d.diet,d.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='cancrominus' OR species='cancrominus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='pensylvanica' OR junior_species='pensylvanica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='pensylvanica' OR species='pensylvanica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='pensylvanica' OR species='pensylvanica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='pensylvanica' OR junior_species='pensylvanica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Setophaga' AND (species='pensylvanica' OR species='pensylvanica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terenotriccus' AND (junior_species='erythrurus' OR junior_species='erythrurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terenotriccus' AND (species='erythrurus' OR species='erythrurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terenotriccus' AND (species='erythrurus' OR species='erythrurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terenotriccus' AND (junior_species='erythrurus' OR junior_species='erythrurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terenotriccus' AND (species='erythrurus' OR species='erythrurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphocaenus' AND (junior_species='melanurus' OR junior_species='melanurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphocaenus' AND (species='melanurus' OR species='melanurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphocaenus' AND (species='melanurus' OR species='melanurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphocaenus' AND (junior_species='melanurus' OR junior_species='melanurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ramphocaenus' AND (species='melanurus' OR species='melanurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercomacra' AND (junior_species='tyrannina' OR junior_species='tyrannina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercomacra' AND (species='tyrannina' OR species='tyrannina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercomacra' AND (species='tyrannina' OR species='tyrannina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercomacra' AND (junior_species='tyrannina' OR junior_species='tyrannina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cercomacra' AND (species='tyrannina' OR species='tyrannina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophylax' AND (junior_species='naevioides' OR junior_species='naevioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylophylax' AND (species='naevioides' OR species='naevioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylophylax' AND (species='naevioides' OR species='naevioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophylax' AND (junior_species='naevioides' OR junior_species='naevioides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylophylax' AND (species='naevioides' OR species='naevioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeochroa' AND (junior_species='cuvierii' OR junior_species='cuvieri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaeochroa' AND (species='cuvierii' OR species='cuvieri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaeochroa' AND (species='cuvierii' OR species='cuvieri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeochroa' AND (junior_species='cuvierii' OR junior_species='cuvieri')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phaeochroa' AND (species='cuvierii' OR species='cuvieri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wilsonia' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wilsonia' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Wilsonia' AND (species='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopithys' AND (junior_species='leucaspis' OR junior_species='leucaspis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnopithys' AND (species='leucaspis' OR species='leucaspis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnopithys' AND (species='leucaspis' OR species='leucaspis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopithys' AND (junior_species='leucaspis' OR junior_species='leucaspis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gymnopithys' AND (species='leucaspis' OR species='leucaspis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helmitheros' AND (junior_species='vermivorum' OR junior_species='vermivorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helmitheros' AND (species='vermivorum' OR species='vermivorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helmitheros' AND (species='vermivorum' OR species='vermivorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helmitheros' AND (junior_species='vermivorum' OR junior_species='vermivorum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helmitheros' AND (species='vermivorum' OR species='vermivorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henicorhina' AND (junior_species='leucosticta' OR junior_species='leucosticta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Henicorhina' AND (species='leucosticta' OR species='leucosticta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Henicorhina' AND (species='leucosticta' OR species='leucosticta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henicorhina' AND (junior_species='leucosticta' OR junior_species='leucosticta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Henicorhina' AND (species='leucosticta' OR species='leucosticta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychorhynchus' 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='Onychorhynchus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychorhynchus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychorhynchus' 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='Onychorhynchus' AND (species='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' 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='Wilsonia' AND (species='citrina' OR species='citrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wilsonia' AND (species='citrina' OR species='citrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' 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='Wilsonia' AND (species='citrina' OR species='citrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guiraca' AND (junior_species='caerulea' OR junior_species='caerulea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guiraca' AND (species='caerulea' OR species='caerulea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guiraca' AND (species='caerulea' OR species='caerulea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guiraca' AND (junior_species='caerulea' OR junior_species='caerulea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Guiraca' AND (species='caerulea' OR species='caerulea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microrhopias' AND (junior_species='quixensis' OR junior_species='quixensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microrhopias' AND (species='quixensis' OR species='quixensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microrhopias' AND (species='quixensis' OR species='quixensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microrhopias' AND (junior_species='quixensis' OR junior_species='quixensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microrhopias' AND (species='quixensis' OR species='quixensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='schisticolor' OR junior_species='schisticolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='schisticolor' OR species='schisticolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='schisticolor' OR species='schisticolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='schisticolor' OR junior_species='schisticolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmotherula' AND (species='schisticolor' OR species='schisticolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='doliatus' OR junior_species='doliatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='doliatus' OR species='doliatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='doliatus' OR species='doliatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='doliatus' OR junior_species='doliatus')SELECT d.diet,d.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='doliatus' OR species='doliatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryothraustes' AND (junior_species='poliogaster' OR junior_species='poliogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caryothraustes' AND (species='poliogaster' OR species='poliogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caryothraustes' AND (species='poliogaster' OR species='poliogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caryothraustes' AND (junior_species='poliogaster' OR junior_species='poliogaster')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caryothraustes' AND (species='poliogaster' OR species='poliogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='frantzii' OR junior_species='frantzi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='frantzii' OR species='frantzi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='frantzii' OR species='frantzi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='frantzii' OR junior_species='frantzi')SELECT d.diet,d.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='frantzii' OR species='frantzi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalurania' AND (junior_species='colombica' OR junior_species='colombica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thalurania' AND (species='colombica' OR species='colombica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thalurania' AND (species='colombica' OR species='colombica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalurania' AND (junior_species='colombica' OR junior_species='colombica')SELECT d.diet,d.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='colombica' OR species='colombica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenops' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenops' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenops' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenops' AND (junior_species='minutus' OR junior_species='minutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xenops' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='candida' OR junior_species='candida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amazilia' AND (species='candida' OR species='candida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amazilia' AND (species='candida' OR species='candida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='candida' OR junior_species='candida')SELECT d.diet,d.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='candida' OR species='candida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiobius' AND (junior_species='sulphureipygius' OR junior_species='sulphureipygius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiobius' AND (species='sulphureipygius' OR species='sulphureipygius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiobius' AND (species='sulphureipygius' OR species='sulphureipygius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiobius' AND (junior_species='sulphureipygius' OR junior_species='sulphureipygius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiobius' AND (species='sulphureipygius' OR species='sulphureipygius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='ruticilla' OR junior_species='ruticilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='ruticilla' OR species='ruticilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='ruticilla' OR species='ruticilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='ruticilla' OR junior_species='ruticilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Setophaga' AND (species='ruticilla' OR species='ruticilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='rubiginosus' OR junior_species='rubiginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Automolus' AND (species='rubiginosus' OR species='rubiginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Automolus' AND (species='rubiginosus' OR species='rubiginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='rubiginosus' OR junior_species='rubiginosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Automolus' AND (species='rubiginosus' OR species='rubiginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnocichla' AND (junior_species='nudiceps' OR junior_species='nudiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnocichla' AND (species='nudiceps' OR species='nudiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnocichla' AND (species='nudiceps' OR species='nudiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnocichla' AND (junior_species='nudiceps' OR junior_species='nudiceps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gymnocichla' AND (species='nudiceps' OR species='nudiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryothorus' AND (junior_species='maculipectus' OR junior_species='maculipectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thryothorus' AND (species='maculipectus' OR species='maculipectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thryothorus' AND (species='maculipectus' OR species='maculipectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryothorus' AND (junior_species='maculipectus' OR junior_species='maculipectus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thryothorus' AND (species='maculipectus' OR species='maculipectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vermivora' AND (junior_species='chrysoptera' OR junior_species='chrysoptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vermivora' AND (species='chrysoptera' OR species='chrysoptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vermivora' AND (species='chrysoptera' OR species='chrysoptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vermivora' AND (junior_species='chrysoptera' OR junior_species='chrysoptera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vermivora' AND (species='chrysoptera' OR species='chrysoptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblycercus' AND (junior_species='holosericeus' OR junior_species='holosericeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblycercus' AND (species='holosericeus' OR species='holosericeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblycercus' AND (species='holosericeus' OR species='holosericeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblycercus' AND (junior_species='holosericeus' OR junior_species='holosericeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amblycercus' AND (species='holosericeus' OR species='holosericeus') 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='Baryphthengus' AND (junior_species='martii' OR junior_species='marti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baryphthengus' AND (species='martii' OR species='marti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baryphthengus' AND (species='martii' OR species='marti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baryphthengus' AND (junior_species='martii' OR junior_species='marti')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Baryphthengus' AND (species='martii' OR species='marti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='flaviventris' OR junior_species='flaviventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='flaviventris' OR species='flaviventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='flaviventris' OR species='flaviventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='flaviventris' OR junior_species='flaviventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Empidonax' AND (species='flaviventris' OR species='flaviventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henicorhina' 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='Henicorhina' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Henicorhina' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henicorhina' 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='Henicorhina' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icteria' AND (junior_species='virens' OR junior_species='virens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Icteria' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Icteria' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icteria' AND (junior_species='virens' OR junior_species='virens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Icteria' AND (species='virens' OR species='virens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='souleyetii' OR junior_species='souleyeti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidocolaptes' AND (species='souleyetii' OR species='souleyeti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidocolaptes' AND (species='souleyetii' OR species='souleyeti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='souleyetii' OR junior_species='souleyeti')SELECT d.diet,d.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='souleyetii' OR species='souleyeti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='morpheus' OR junior_species='morpheus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monasa' AND (species='morpheus' OR species='morpheus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monasa' AND (species='morpheus' OR species='morpheus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='morpheus' OR junior_species='morpheus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monasa' AND (species='morpheus' OR species='morpheus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='rubra' OR junior_species='rubra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piranga' AND (species='rubra' OR species='rubra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piranga' AND (species='rubra' OR species='rubra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='rubra' OR junior_species='rubra')SELECT d.diet,d.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='rubra' OR species='rubra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='coerulescens' OR junior_species='coerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='coerulescens' OR species='coerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='coerulescens' OR species='coerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='coerulescens' OR junior_species='coerulescens')SELECT d.diet,d.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='coerulescens' OR species='coerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='turdina' OR junior_species='turdina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schiffornis' AND (species='turdina' OR species='turdina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schiffornis' AND (species='turdina' OR species='turdina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='turdina' OR junior_species='turdina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Schiffornis' AND (species='turdina' OR species='turdina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclerurus' AND (species='mexicanus' OR species='mexicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerurus' AND (species='mexicanus' OR species='mexicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='mexicanus' OR junior_species='mexicanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sclerurus' AND (species='mexicanus' OR species='mexicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkesia' AND (junior_species='motacilla' OR junior_species='motacilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkesia' AND (species='motacilla' OR species='motacilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkesia' AND (species='motacilla' OR species='motacilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkesia' AND (junior_species='motacilla' OR junior_species='motacilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parkesia' AND (species='motacilla' OR species='motacilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='luctuosus' OR junior_species='luctuosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyphonus' AND (species='luctuosus' OR species='luctuosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyphonus' AND (species='luctuosus' OR species='luctuosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='luctuosus' OR junior_species='luctuosus')SELECT d.diet,d.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='luctuosus' OR species='luctuosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taraba' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taraba' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Taraba' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taraba' AND (junior_species='major' OR junior_species='major')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Taraba' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogon' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogon' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='rufus' OR junior_species='rufus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trogon' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1384 The Ecological Register: Siuna (birds, secondary forest)
Siuna (birds, secondary forest)
Basic information
Sample name: Siuna (birds, secondary forest)

Reference: D. I. King, M. D. Hernandez-Mayorga, R. Trubey, R. Raudales, and J. H. Rappole. 2007. An evaluation of the contribution of cultivated allspice (Pimenta Dioca) to vertebrate biodiversity conservation in Nicaragua. Biodiversity and Conservation 16:1299-1320 [ER 921]
Geography
Country: Nicaragua


Coordinate: 13° 40' N, 85° 50' W
Coordinate basis: stated in text

Geography comments: elevation 170 to 600 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Substrate: ground surface

MAT: 24.4

WMT: 26.9

CMT: 21.8

MAP: 2274.0

Habitat comments: "tropical moist and wet forest... Secondary forest had most of the original canopy removed, and had shorter, smaller trees and denser understory than primary forest"
climate data are from Denevan (1961), with MAT/CMT/WMT based on Somoto and MAP based on El Tuma

Methods
Life forms: birds

Sites: 5

Site area: 25

Sampling methods: quadrat,mist nets

Sample size: 375 individuals

Years: 2003, 2004

Sampling comments: "Ten 12 m x 3 m, 32 mm denier mist nets were deployed in each site 50 m apart in a grid pattern approximately 200 m ยท 250 m. Each site was sampled for 250 net hours"

Metadata
Sample number: 1384

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-25 12:02:33

Modified: 2015-09-27 07:17:40

Abundance distribution
73 species
26 singletons
total count 375
extrapolated richness: 152.3
Fisher's α: 27.047
geometric series k: 0.9488
Hurlbert's PIE: 0.9611
Shannon's H: 3.6992
Good's u: 0.9308
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Sporophila corvina133.1 g
"Sporophila aurita"
Manacus candei4418.8 g frugivore
Ramphocelus passerinii1432.0 g frugivore-insectivore
Mionectes oleagineus252.3 g insectivore-frugivore
Phaethornis superciliosus246.3 g nectarivore-insectivore
Hylocharis eliciae113.6 g nectarivore
Volatinia jacarina23.2 g granivore
Saltator maximus1246.2 g frugivore-folivore
Tiaris olivaceus1 granivore
"Tiaris olivacea"
Cyanocompsa cyanoides1732.5 g frugivore-insectivore
Oryzoborus funereus212.3 g granivore
Pipra mentalis715.0 g frugivore
Phaethornis longuemareus153.0 g nectarivore-insectivore
Arremon aurantiirostris1534.5 g frugivore-insectivore
Habia fuscicauda86.1 g insectivore-frugivore
Automolus ochrolaemus1040.2 g insectivore
Glyphorhynchus spirurus3 frugivore-insectivore
Threnetes ruckeri125.2 g nectarivore-insectivore
Eucometis penicillata727.0 g insectivore-frugivore
Hylocichla mustelina847.8 g insectivore-frugivore
Oncostoma cinereigulare76.4 g insectivore
Arremonops conirostris35.4 g frugivore-insectivore
Passerina cyanea115.0 g granivore-insectivore
Corapipo leucorrhoa510.7 g frugivore
Seiurus aurocapilla818.8 g insectivore
"Seiurus aurocapillus"
Turdus grayi479.5 g insectivore-frugivore
Oporornis formosus714.0 g insectivore
Platyrinchus coronatus13.0 g insectivore
Glaucis aenea2 nectarivore-insectivore
Platyrinchus cancrominus59.2 g insectivore
Setophaga pensylvanica1
"Dendroica pensylvanica"
Terenotriccus erythrurus27.4 g insectivore
Ramphocaenus melanurus59.7 g frugivore-insectivore
Cercomacra tyrannina316.3 g insectivore
Hylophylax naevioides217.8 g insectivore
Phaeochroa cuvierii38.9 g
Wilsonia pusilla42.6 g insectivore-frugivore
Gymnopithys leucaspis44.9 g insectivore
Helmitheros vermivorum413.2 g insectivore
"Helmitheros vermivorus"
Henicorhina leucosticta214.8 g insectivore
Onychorhynchus coronatus414.0 g insectivore
Wilsonia citrina310.8 g insectivore
Guiraca caerulea1 nectarivore
Microrhopias quixensis17.9 g insectivore
Myrmotherula schisticolor49.6 g insectivore
Thamnophilus doliatus25.1 g insectivore
Caryothraustes poliogaster241.8 g frugivore-insectivore
Elaenia frantzii319.6 g frugivore
Thalurania colombica14.5 g nectarivore-insectivore
Xenops minutus110.6 g frugivore-insectivore
Amazilia candida1 nectarivore
Myiobius sulphureipygius111.9 g insectivore
Setophaga ruticilla18.4 g insectivore
Automolus rubiginosus339.8 g insectivore
Gymnocichla nudiceps330.5 g insectivore
Thryothorus maculipectus216.2 g insectivore
Vermivora chrysoptera18.9 g insectivore
Amblycercus holosericeus27.3 g insectivore-frugivore
Platyrinchus mystaceus29.7 g insectivore
Baryphthengus martii113.3 g omnivore
Empidonax flaviventris111.8 g insectivore
Henicorhina leucophrys12.5 g insectivore
Icteria virens124.4 g insectivore
Lepidocolaptes souleyetii125.7 g insectivore
"Lepidocolaptes souleyetti"
Monasa morpheus1 insectivore
Piranga rubra15.5 g insectivore-frugivore
Saltator coerulescens154.9 g insectivore-frugivore
Schiffornis turdina131.7 g insectivore
"Schiffornis turdinus"
Sclerurus mexicanus125.1 g insectivore
Parkesia motacilla1 insectivore
"Seiurus motacilla"
Tachyphonus luctuosus113.0 g insectivore-frugivore
Taraba major159.2 g insectivore
Trogon rufus153.8 g insectivore-frugivore