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=3608 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3608SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3264SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3608 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='talpacoti' OR junior_species='talpacotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Columbina' AND (species='talpacoti' OR species='talpacotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Columbina' AND (species='talpacoti' OR species='talpacotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columbina' AND (junior_species='talpacoti' OR junior_species='talpacotii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Columbina' AND (species='talpacoti' OR species='talpacotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotophaga' 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='Crotophaga' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotophaga' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotophaga' 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='Crotophaga' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Momotus' AND (junior_species='momota' OR junior_species='momota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Momotus' AND (species='momota' OR species='momota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Momotus' AND (species='momota' OR species='momota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Momotus' AND (junior_species='momota' OR junior_species='momota')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Momotus' AND (species='momota' OR species='momota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capito' AND (junior_species='auratus' OR junior_species='auratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capito' AND (species='auratus' OR species='auratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capito' AND (species='auratus' OR species='auratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capito' AND (junior_species='auratus' OR junior_species='auratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Capito' AND (species='auratus' OR species='auratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='schistogynus' OR junior_species='schistogynus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnomanes' AND (species='schistogynus' OR species='schistogynus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnomanes' AND (species='schistogynus' OR species='schistogynus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='schistogynus' OR junior_species='schistogynus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thamnomanes' AND (species='schistogynus' OR species='schistogynus') 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='Thamnophilus' AND (junior_species='schistaceus' OR junior_species='schistaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='schistaceus' OR species='schistaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='schistaceus' OR species='schistaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='schistaceus' OR junior_species='schistaceus')SELECT d.diet,d.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='schistaceus' OR species='schistaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmelastes' AND (junior_species='hyperythrus' OR junior_species='hyperythrus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmelastes' AND (species='hyperythrus' OR species='hyperythrus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmelastes' AND (species='hyperythrus' OR species='hyperythrus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmelastes' AND (junior_species='hyperythrus' OR junior_species='hyperythrus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmelastes' AND (species='hyperythrus' OR species='hyperythrus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciaphylax' AND (junior_species='hemimelaena' OR junior_species='hemimelaena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciaphylax' AND (species='hemimelaena' OR species='hemimelaena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciaphylax' AND (species='hemimelaena' OR species='hemimelaena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciaphylax' AND (junior_species='hemimelaena' OR junior_species='hemimelaena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sciaphylax' AND (species='hemimelaena' OR species='hemimelaena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phlegopsis' AND (junior_species='nigromaculata' OR junior_species='nigromaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phlegopsis' AND (species='nigromaculata' OR species='nigromaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phlegopsis' AND (species='nigromaculata' OR species='nigromaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phlegopsis' AND (junior_species='nigromaculata' OR junior_species='nigromaculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phlegopsis' AND (species='nigromaculata' OR species='nigromaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='rufigularis' OR junior_species='rufigularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclerurus' AND (species='rufigularis' OR species='rufigularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerurus' AND (species='rufigularis' OR species='rufigularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='rufigularis' OR junior_species='rufigularis')SELECT d.diet,d.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='rufigularis' OR species='rufigularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='merula' OR junior_species='merula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocincla' AND (species='merula' OR species='merula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocincla' AND (species='merula' OR species='merula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='merula' OR junior_species='merula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrocincla' AND (species='merula' OR species='merula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphorhynchus' AND (species='guttatus' OR species='guttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphorhynchus' AND (species='guttatus' OR species='guttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xiphorhynchus' AND (species='guttatus' OR species='guttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendroplex' AND (junior_species='picus' OR junior_species='picus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendroplex' AND (species='picus' OR species='picus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendroplex' AND (species='picus' OR species='picus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendroplex' AND (junior_species='picus' OR junior_species='picus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendroplex' AND (species='picus' OR species='picus') 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='Pipra' AND (junior_species='filicauda' OR junior_species='filicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='filicauda' OR species='filicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='filicauda' OR species='filicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='filicauda' OR junior_species='filicauda')SELECT d.diet,d.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='filicauda' OR species='filicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='fasciicauda' OR junior_species='fasciicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='fasciicauda' OR species='fasciicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='fasciicauda' OR species='fasciicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='fasciicauda' OR junior_species='fasciicauda')SELECT d.diet,d.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='fasciicauda' OR species='fasciicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaeropterus' AND (junior_species='pyrocephalus' OR junior_species='pyrocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machaeropterus' AND (species='pyrocephalus' OR species='pyrocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machaeropterus' AND (species='pyrocephalus' OR species='pyrocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaeropterus' AND (junior_species='pyrocephalus' OR junior_species='pyrocephalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Machaeropterus' AND (species='pyrocephalus' OR species='pyrocephalus') 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='Rhynchocyclus' 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='Rhynchocyclus' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchocyclus' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchocyclus' 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='Rhynchocyclus' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Todirostrum' AND (junior_species='maculatum' OR junior_species='maculatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Todirostrum' AND (species='maculatum' OR species='maculatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Todirostrum' AND (species='maculatum' OR species='maculatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Todirostrum' AND (junior_species='maculatum' OR junior_species='maculatum')SELECT d.diet,d.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='maculatum' OR species='maculatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiozetetes' 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='Myiozetetes' AND (species='similis' OR species='similis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiozetetes' AND (species='similis' OR species='similis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiozetetes' 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='Myiozetetes' AND (species='similis' OR species='similis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='alnorum' OR junior_species='alnorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='alnorum' OR species='alnorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='alnorum' OR species='alnorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='alnorum' OR junior_species='alnorum')SELECT d.diet,d.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='alnorum' OR species='alnorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheugopedius' AND (junior_species='genibarbis' OR junior_species='genibarbis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheugopedius' AND (species='genibarbis' OR species='genibarbis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheugopedius' AND (species='genibarbis' OR species='genibarbis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheugopedius' AND (junior_species='genibarbis' OR junior_species='genibarbis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheugopedius' AND (species='genibarbis' OR species='genibarbis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='hauxwelli' OR junior_species='hauxwellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='hauxwelli' OR species='hauxwellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='hauxwelli' OR species='hauxwellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='hauxwelli' OR junior_species='hauxwellii')SELECT d.diet,d.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='hauxwelli' OR species='hauxwellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='sanchezorum' OR junior_species='sanchezorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='sanchezorum' OR species='sanchezorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='sanchezorum' OR species='sanchezorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='sanchezorum' OR junior_species='sanchezorum')SELECT d.diet,d.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='sanchezorum' OR species='sanchezorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='ignobilis' OR junior_species='ignobilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='ignobilis' OR species='ignobilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='ignobilis' OR species='ignobilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='ignobilis' OR junior_species='ignobilis')SELECT d.diet,d.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='ignobilis' OR species='ignobilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphocelus' AND (junior_species='carbo' OR junior_species='carbo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphocelus' AND (species='carbo' OR species='carbo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphocelus' AND (species='carbo' OR species='carbo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphocelus' AND (junior_species='carbo' OR junior_species='carbo')SELECT d.diet,d.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='carbo' OR species='carbo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crypturellus' AND (junior_species='undulatus' OR junior_species='undulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crypturellus' AND (species='undulatus' OR species='undulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crypturellus' AND (species='undulatus' OR species='undulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crypturellus' AND (junior_species='undulatus' OR junior_species='undulatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crypturellus' AND (species='undulatus' OR species='undulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocygna' AND (junior_species='viduata' OR junior_species='viduata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocygna' AND (species='viduata' OR species='viduata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocygna' AND (species='viduata' OR species='viduata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocygna' AND (junior_species='viduata' OR junior_species='viduata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrocygna' AND (species='viduata' OR species='viduata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tigrisoma' AND (junior_species='lineatum' OR junior_species='lineatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tigrisoma' AND (species='lineatum' OR species='lineatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tigrisoma' AND (species='lineatum' OR species='lineatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tigrisoma' AND (junior_species='lineatum' OR junior_species='lineatum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tigrisoma' AND (species='lineatum' OR species='lineatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixobrychus' AND (junior_species='exilis' OR junior_species='exilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ixobrychus' AND (species='exilis' OR species='exilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ixobrychus' AND (species='exilis' OR species='exilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixobrychus' AND (junior_species='exilis' OR junior_species='exilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ixobrychus' AND (species='exilis' OR species='exilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Butorides' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Butorides' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Butorides' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Butorides' AND (junior_species='striata' OR junior_species='striata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Butorides' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pilherodius' AND (junior_species='pileatus' OR junior_species='pileatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pilherodius' AND (species='pileatus' OR species='pileatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pilherodius' AND (species='pileatus' OR species='pileatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pilherodius' AND (junior_species='pileatus' OR junior_species='pileatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pilherodius' AND (species='pileatus' OR species='pileatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rupornis' AND (junior_species='magnirostris' OR junior_species='magnirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rupornis' AND (species='magnirostris' OR species='magnirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rupornis' AND (species='magnirostris' OR species='magnirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rupornis' AND (junior_species='magnirostris' OR junior_species='magnirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rupornis' AND (species='magnirostris' OR species='magnirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aramu' AND (junior_species='guarauna' OR junior_species='guarauna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aramu' AND (species='guarauna' OR species='guarauna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aramu' AND (species='guarauna' OR species='guarauna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aramu' AND (junior_species='guarauna' OR junior_species='guarauna')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aramu' AND (species='guarauna' OR species='guarauna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porphyrio' AND (junior_species='martinicus' OR junior_species='martinicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Porphyrio' AND (species='martinicus' OR species='martinicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Porphyrio' AND (species='martinicus' OR species='martinicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Porphyrio' AND (junior_species='martinicus' OR junior_species='martinicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Porphyrio' AND (species='martinicus' OR species='martinicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanellus' AND (junior_species='chilensis' OR junior_species='chilensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanellus' AND (species='chilensis' OR species='chilensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanellus' AND (species='chilensis' OR species='chilensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanellus' AND (junior_species='chilensis' OR junior_species='chilensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vanellus' AND (species='chilensis' OR species='chilensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='solitaria' OR junior_species='solitaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tringa' AND (species='solitaria' OR species='solitaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tringa' AND (species='solitaria' OR species='solitaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='solitaria' OR junior_species='solitaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tringa' AND (species='solitaria' OR species='solitaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jacana' AND (junior_species='jacana' OR junior_species='jacana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jacana' AND (species='jacana' OR species='jacana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jacana' AND (species='jacana' OR species='jacana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jacana' AND (junior_species='jacana' OR junior_species='jacana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jacana' AND (species='jacana' OR species='jacana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='verreauxi' OR junior_species='verreauxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotila' AND (species='verreauxi' OR species='verreauxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotila' AND (species='verreauxi' OR species='verreauxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='verreauxi' OR junior_species='verreauxii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptotila' AND (species='verreauxi' OR species='verreauxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Leptotila' 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='Leptotila' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotila' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' 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='Leptotila' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='montana' OR junior_species='montana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geotrygon' AND (species='montana' OR species='montana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geotrygon' AND (species='montana' OR species='montana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='montana' OR junior_species='montana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Geotrygon' AND (species='montana' OR species='montana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccycua' AND (junior_species='minuta' OR junior_species='minuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccycua' AND (species='minuta' OR species='minuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccycua' AND (species='minuta' OR species='minuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccycua' AND (junior_species='minuta' OR junior_species='minuta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coccycua' AND (species='minuta' OR species='minuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotophaga' AND (junior_species='ani' OR junior_species='anii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotophaga' AND (species='ani' OR species='anii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotophaga' AND (species='ani' OR species='anii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotophaga' AND (junior_species='ani' OR junior_species='anii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crotophaga' AND (species='ani' OR species='anii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megascops' AND (junior_species='choliba' OR junior_species='choliba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megascops' AND (species='choliba' OR species='choliba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megascops' AND (species='choliba' OR species='choliba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megascops' AND (junior_species='choliba' OR junior_species='choliba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megascops' AND (species='choliba' OR species='choliba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydropsalis' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydropsalis' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydropsalis' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydropsalis' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hydropsalis' AND (species='albicollis' OR species='albicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetura' AND (species='meridionalis' OR species='meridionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetura' AND (species='meridionalis' OR species='meridionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chaetura' AND (species='meridionalis' OR species='meridionalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetura' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetura' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chaetura' AND (species='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachornis' AND (junior_species='squamata' OR junior_species='squamata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachornis' AND (species='squamata' OR species='squamata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachornis' AND (species='squamata' OR species='squamata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachornis' AND (junior_species='squamata' OR junior_species='squamata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachornis' AND (species='squamata' OR species='squamata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucis' AND (junior_species='hirsutus' OR junior_species='hirsutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucis' AND (species='hirsutus' OR species='hirsutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucis' AND (species='hirsutus' OR species='hirsutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucis' AND (junior_species='hirsutus' OR junior_species='hirsutus')SELECT d.diet,d.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='hirsutus' OR species='hirsutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='ruber' OR junior_species='ruber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='ruber' OR species='ruber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='ruber' OR species='ruber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='ruber' OR junior_species='ruber')SELECT d.diet,d.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='ruber' OR species='ruber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='hispidus' OR species='hispidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='hispidus' OR species='hispidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT d.diet,d.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='hispidus' OR species='hispidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthracothorax' 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='Anthracothorax' AND (species='nigricollis' OR species='nigricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthracothorax' AND (species='nigricollis' OR species='nigricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthracothorax' 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='Anthracothorax' AND (species='nigricollis' OR species='nigricollis') 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='Amazilia' AND (junior_species='lactea' OR junior_species='lactea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amazilia' AND (species='lactea' OR species='lactea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amazilia' AND (species='lactea' OR species='lactea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='lactea' OR junior_species='lactea')SELECT d.diet,d.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='lactea' OR species='lactea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' AND (junior_species='amazona' OR junior_species='amazona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloroceryle' AND (species='amazona' OR species='amazona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroceryle' AND (species='amazona' OR species='amazona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' AND (junior_species='amazona' OR junior_species='amazona')SELECT d.diet,d.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='amazona' OR species='amazona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' 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='Chloroceryle' AND (species='aenea' OR species='aenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroceryle' AND (species='aenea' OR species='aenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' 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='Chloroceryle' AND (species='aenea' OR species='aenea') 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='Chloroceryle' AND (junior_species='inda' OR junior_species='inda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloroceryle' AND (species='inda' OR species='inda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroceryle' AND (species='inda' OR species='inda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' AND (junior_species='inda' OR junior_species='inda')SELECT d.diet,d.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='inda' OR species='inda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bucco' AND (junior_species='macrodactylus' OR junior_species='macrodactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bucco' AND (species='macrodactylus' OR species='macrodactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bucco' AND (species='macrodactylus' OR species='macrodactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bucco' AND (junior_species='macrodactylus' OR junior_species='macrodactylus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bucco' AND (species='macrodactylus' OR species='macrodactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='nigrifrons' OR junior_species='nigrifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monasa' AND (species='nigrifrons' OR species='nigrifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monasa' AND (species='nigrifrons' OR species='nigrifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='nigrifrons' OR junior_species='nigrifrons')SELECT d.diet,d.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='nigrifrons' OR species='nigrifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picumnus' AND (species='rufiventris' OR species='rufiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picumnus' AND (species='rufiventris' OR species='rufiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT d.diet,d.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='rufiventris' OR species='rufiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Veniliornis' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Veniliornis' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='affinis' OR junior_species='affinis')SELECT d.diet,d.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='affinis' OR species='affinis') 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='Colaptes' AND (junior_species='punctigula' OR junior_species='punctigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colaptes' AND (species='punctigula' OR species='punctigula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colaptes' AND (species='punctigula' OR species='punctigula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='punctigula' OR junior_species='punctigula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colaptes' AND (species='punctigula' OR species='punctigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celeus' AND (junior_species='spectabilis' OR junior_species='spectabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celeus' AND (species='spectabilis' OR species='spectabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celeus' AND (species='spectabilis' OR species='spectabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celeus' AND (junior_species='spectabilis' OR junior_species='spectabilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celeus' AND (species='spectabilis' OR species='spectabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campephilus' AND (junior_species='melanoleucos' OR junior_species='melanoleucos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campephilus' AND (species='melanoleucos' OR species='melanoleucos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campephilus' AND (species='melanoleucos' OR species='melanoleucos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campephilus' AND (junior_species='melanoleucos' OR junior_species='melanoleucos')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Campephilus' AND (species='melanoleucos' OR species='melanoleucos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aratinga' AND (junior_species='weddellii' OR junior_species='weddelli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aratinga' AND (species='weddellii' OR species='weddelli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aratinga' AND (species='weddellii' OR species='weddelli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aratinga' AND (junior_species='weddellii' OR junior_species='weddelli')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aratinga' AND (species='weddellii' OR species='weddelli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brotogeris' AND (junior_species='sanctithomae' OR junior_species='sanctithomae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brotogeris' AND (species='sanctithomae' OR species='sanctithomae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brotogeris' AND (species='sanctithomae' OR species='sanctithomae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brotogeris' AND (junior_species='sanctithomae' OR junior_species='sanctithomae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Brotogeris' AND (species='sanctithomae' OR species='sanctithomae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='axillaris' OR junior_species='axillaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='axillaris' OR species='axillaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='axillaris' OR species='axillaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='axillaris' OR junior_species='axillaris')SELECT d.diet,d.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='axillaris' OR species='axillaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='murinus' OR junior_species='murinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='murinus' OR species='murinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='murinus' OR species='murinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='murinus' OR junior_species='murinus')SELECT d.diet,d.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='murinus' OR species='murinus') 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='Myrmelastes' AND (junior_species='schistaceus' OR junior_species='schistaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmelastes' AND (species='schistaceus' OR species='schistaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmelastes' AND (species='schistaceus' OR species='schistaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmelastes' AND (junior_species='schistaceus' OR junior_species='schistaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmelastes' AND (species='schistaceus' OR species='schistaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocnemis' AND (junior_species='subflava' OR junior_species='subflava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypocnemis' AND (species='subflava' OR species='subflava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypocnemis' AND (species='subflava' OR species='subflava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocnemis' AND (junior_species='subflava' OR junior_species='subflava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypocnemis' AND (species='subflava' OR species='subflava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocincla' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocincla' AND (species='fuliginosa' OR species='fuliginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocincla' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrocincla' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylorhamphus' AND (junior_species='trochilirostris' OR junior_species='trochilirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campylorhamphus' AND (species='trochilirostris' OR species='trochilirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campylorhamphus' AND (species='trochilirostris' OR species='trochilirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylorhamphus' AND (junior_species='trochilirostris' OR junior_species='trochilirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Campylorhamphus' AND (species='trochilirostris' OR species='trochilirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furnarius' AND (junior_species='leucopus' OR junior_species='leucopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Furnarius' AND (species='leucopus' OR species='leucopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Furnarius' AND (species='leucopus' OR species='leucopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furnarius' AND (junior_species='leucopus' OR junior_species='leucopus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Furnarius' AND (species='leucopus' OR species='leucopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopelma' AND (junior_species='sulphureiventer' OR junior_species='sulphureiventer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neopelma' AND (species='sulphureiventer' OR species='sulphureiventer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neopelma' AND (species='sulphureiventer' OR species='sulphureiventer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopelma' AND (junior_species='sulphureiventer' OR junior_species='sulphureiventer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neopelma' AND (species='sulphureiventer' OR species='sulphureiventer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythopis' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corythopis' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corythopis' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythopis' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corythopis' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='flammulatus' OR junior_species='flammulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemitriccus' AND (species='flammulatus' OR species='flammulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemitriccus' AND (species='flammulatus' OR species='flammulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='flammulatus' OR junior_species='flammulatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemitriccus' AND (species='flammulatus' OR species='flammulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='spectabilis' OR junior_species='spectabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='spectabilis' OR species='spectabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='spectabilis' OR species='spectabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='spectabilis' OR junior_species='spectabilis')SELECT d.diet,d.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='spectabilis' OR species='spectabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='parvirostris' OR junior_species='parvirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='parvirostris' OR species='parvirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='parvirostris' OR species='parvirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='parvirostris' OR junior_species='parvirostris')SELECT d.diet,d.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='parvirostris' OR species='parvirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannulus' AND (junior_species='elatus' OR junior_species='elatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyrannulus' AND (species='elatus' OR species='elatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyrannulus' AND (species='elatus' OR species='elatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannulus' AND (junior_species='elatus' OR junior_species='elatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tyrannulus' AND (species='elatus' OR species='elatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeomyias' AND (junior_species='murina' OR junior_species='murina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaeomyias' AND (species='murina' OR species='murina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaeomyias' AND (species='murina' OR species='murina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeomyias' AND (junior_species='murina' OR junior_species='murina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phaeomyias' AND (species='murina' OR species='murina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitangus' AND (junior_species='sulphuratus' OR junior_species='sulphuratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitangus' AND (species='sulphuratus' OR species='sulphuratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitangus' AND (species='sulphuratus' OR species='sulphuratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitangus' AND (junior_species='sulphuratus' OR junior_species='sulphuratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pitangus' AND (species='sulphuratus' OR species='sulphuratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philohydor' AND (junior_species='lictor' OR junior_species='lictor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philohydor' AND (species='lictor' OR species='lictor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philohydor' AND (species='lictor' OR species='lictor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philohydor' AND (junior_species='lictor' OR junior_species='lictor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Philohydor' AND (species='lictor' OR species='lictor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiodynastes' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiodynastes' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiodynastes' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiodynastes' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiodynastes' AND (species='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannopsis' AND (junior_species='sulphurea' OR junior_species='sulphurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyrannopsis' AND (species='sulphurea' OR species='sulphurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyrannopsis' AND (species='sulphurea' OR species='sulphurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyrannopsis' AND (junior_species='sulphurea' OR junior_species='sulphurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tyrannopsis' AND (species='sulphurea' OR species='sulphurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megarynchus' AND (junior_species='pitangua' OR junior_species='pitangua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megarynchus' AND (species='pitangua' OR species='pitangua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megarynchus' AND (species='pitangua' OR species='pitangua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megarynchus' AND (junior_species='pitangua' OR junior_species='pitangua')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Megarynchus' AND (species='pitangua' OR species='pitangua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiozetetes' AND (junior_species='cayanensis' OR junior_species='cayanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiozetetes' AND (species='cayanensis' OR species='cayanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiozetetes' AND (species='cayanensis' OR species='cayanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiozetetes' AND (junior_species='cayanensis' OR junior_species='cayanensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiozetetes' AND (species='cayanensis' OR species='cayanensis') 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='Pyrocephalus' AND (junior_species='rubinus' OR junior_species='rubinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrocephalus' AND (species='rubinus' OR species='rubinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrocephalus' AND (species='rubinus' OR species='rubinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrocephalus' AND (junior_species='rubinus' OR junior_species='rubinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrocephalus' AND (species='rubinus' OR species='rubinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemotriccus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemotriccus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclarhis' AND (junior_species='gujanensis' OR junior_species='gujanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclarhis' AND (species='gujanensis' OR species='gujanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclarhis' AND (species='gujanensis' OR species='gujanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclarhis' AND (junior_species='gujanensis' OR junior_species='gujanensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclarhis' AND (species='gujanensis' OR species='gujanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='chivi' OR junior_species='chivii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='chivi' OR species='chivii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='chivi' OR species='chivii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='chivi' OR junior_species='chivii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vireo' AND (species='chivi' OR species='chivii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='flavoviridis' OR junior_species='flavoviridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='flavoviridis' OR species='flavoviridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='flavoviridis' OR species='flavoviridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='flavoviridis' OR junior_species='flavoviridis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vireo' AND (species='flavoviridis' OR species='flavoviridis') 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='musculus' OR junior_species='musculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troglodytes' AND (species='musculus' OR species='musculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troglodytes' AND (species='musculus' OR species='musculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='musculus' OR junior_species='musculus')SELECT d.diet,d.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='musculus' OR species='musculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cantorchilus' AND (junior_species='leucotis' OR junior_species='leucotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cantorchilus' AND (species='leucotis' OR species='leucotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cantorchilus' AND (species='leucotis' OR species='leucotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cantorchilus' AND (junior_species='leucotis' OR junior_species='leucotis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cantorchilus' AND (species='leucotis' OR species='leucotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='amaurochalinus' OR junior_species='amaurochalinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='amaurochalinus' OR junior_species='amaurochalinus')SELECT d.diet,d.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='amaurochalinus' OR species='amaurochalinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacicus' AND (junior_species='cela' OR junior_species='cela')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacicus' AND (species='cela' OR species='cela') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacicus' AND (species='cela' OR species='cela')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacicus' AND (junior_species='cela' OR junior_species='cela')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cacicus' AND (species='cela' OR species='cela') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='mexicana' OR species='mexicana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='mexicana' OR species='mexicana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='mexicana' OR junior_species='mexicana')SELECT d.diet,d.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='mexicana' OR species='mexicana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='episcopus' OR junior_species='episcopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='episcopus' OR species='episcopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='episcopus' OR species='episcopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='episcopus' OR junior_species='episcopus')SELECT d.diet,d.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='episcopus' OR species='episcopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='palmarum' OR junior_species='palmarum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='palmarum' OR species='palmarum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='palmarum' OR species='palmarum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='palmarum' OR junior_species='palmarum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tangara' AND (species='palmarum' OR species='palmarum') 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='Sporophila' AND (junior_species='lineola' OR junior_species='lineola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='lineola' OR species='lineola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='lineola' OR species='lineola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='lineola' OR junior_species='lineola')SELECT d.diet,d.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='lineola' OR species='lineola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='castaneiventris' OR junior_species='castaneiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='castaneiventris' OR species='castaneiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='castaneiventris' OR species='castaneiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='castaneiventris' OR junior_species='castaneiventris')SELECT d.diet,d.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='castaneiventris' OR species='castaneiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT d.diet,d.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='angolensis' OR species='angolensis') 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='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='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='Saltator' AND (junior_species='azarae' OR junior_species='azarae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='azarae' OR species='azarae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='azarae' OR species='azarae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='azarae' OR junior_species='azarae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Saltator' AND (species='azarae' OR species='azarae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='chlorotica' OR junior_species='chlorotica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='chlorotica' OR species='chlorotica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='chlorotica' OR species='chlorotica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='chlorotica' OR junior_species='chlorotica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphonia' AND (species='chlorotica' OR species='chlorotica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammodramus' AND (junior_species='aurifrons' OR junior_species='aurifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ammodramus' AND (species='aurifrons' OR species='aurifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ammodramus' AND (species='aurifrons' OR species='aurifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammodramus' AND (junior_species='aurifrons' OR junior_species='aurifrons')SELECT d.diet,d.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='aurifrons' OR species='aurifrons') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3608 The Ecological Register: Federal University of Acre
Federal University of Acre
Basic information
Sample name: Federal University of Acre

Sample aka: Rio Branco

Reference: M. Amoędo-Lima, T. Fernandes-Martins, S. Muņoz-Leal, E. Guilherme, M. Ogrzewalska, and M. Bahia Labruna. 2018. Ticks and tick-associated spotted fever group Rickettsia from birds in the Southwestern Brazilian Amazon. Revista Colombiana de Ciencias Pecuarias 31(1):26-35 [ER 3264]
Geography
Country: Brazil

State: Acre


Coordinate: -9.95° S, -67.87° W
Coordinate basis: estimated from map

Geography comments: "in an Amazon forest fragment situated within the campus of the Federal University of Acre, located within the city of Rio Branco"

Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: inhabited area

Protection: unprotected

Substrate: ground surface

MAT: 26.1

MAP: 1951.0

Habitat comments: "The rainy season is long and spans from October through May, and a relatively short dry season covers the remaining four months of the year"
presumably within the large fragment immediately west of the campus, which is about 1.5 km across (very roughly 200 ha)

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 1322 captures or sightings

Years: 2013, 2014

Seasons: dry,wet or monsoon

Net or trap nights: 5531

Sampling comments: "Capture of birds was performed between February 2013 and August 2014... Birds were caught by mist nets (12 m long x 2 m height, 36 mm mesh with a total capture effort of 796,464 net-hours" (i.e., presuming 12 hour days, 796464 n-h/12 m/12 h = 5531 net days using very roughly 10 nets, if used every day)

Metadata
Sample number: 3608

Contributor: John Alroy

Enterer: John Alroy

Created: 2020-05-23 12:04:39

Modified: 2020-05-23 02:04:39

Abundance distribution
117 species
33 singletons
total count 1322
extrapolated richness: 205.3
Fisher's α: 30.979
geometric series k: 0.9554
Hurlbert's PIE: 0.9527
Shannon's H: 3.7611
Good's u: 0.9751
Each square represents a species. Square sizes are proportional to counts.
Register
Columbina talpacoti1996.8 g granivore
Crotophaga major1157 g
Momotus momota1810.6 g carnivore-insectivore
Capito auratus insperatus2 omnivore
Thamnomanes schistogynus1617.2 g
Thamnophilus doliatus65.1 g insectivore
Thamnophilus schistaceus220.3 g frugivore-insectivore
Myrmelastes hyperythrus8
Sciaphylax hemimelaena16 insectivore
Phlegopsis nigromaculata86.8 g insectivore
Sclerurus cf. rufigularis121.6 g insectivore
Dendrocincla merula53.8 g insectivore
Xiphorhynchus guttatus107.8 g frugivore-insectivore
Dendroplex picus20 insectivore
Xenops minutus210.6 g frugivore-insectivore
Pipra filicauda115.4 g frugivore
Pipra fasciicauda6915.9 g frugivore
Machaeropterus pyrocephalus209.7 g insectivore
Leptopogon amaurocephalus511.7 g insectivore-frugivore
Rhynchocyclus olivaceus7121.3 g insectivore
Todirostrum maculatum17.3 g
Myiozetetes similis3628.0 g insectivore-frugivore
Empidonax alnorum512.7 g insectivore
Pheugopedius genibarbis32 insectivore
Turdus hauxwelli1469.0 g omnivore
Turdus sanchezorum1
Turdus ignobilis11161.0 g
Ramphocelus carbo874.9 g frugivore
Crypturellus undulatus1513 g frugivore
Dendrocygna viduata1690 g
Tigrisoma lineatum1813 g piscivore
Ixobrychus exilis186.3 g
Butorides striata413.6 g piscivore
Pilherodius pileatus1530 g piscivore
Rupornis magnirostris2 insectivore-carnivore
Aramu guarauna1
Porphyrio martinicus5
Vanellus chilensis3327 g insectivore
Tringa solitaria648.4 g invertivore
Jacana jacana2787.5 g insectivore
Leptotila verreauxi1511.6 g granivore-frugivore
Leptotila rufaxilla13157 g granivore-frugivore
Leptotila sp.1
Geotrygon montana95.2 g granivore-frugivore
Coccycua minuta2 insectivore
Crotophaga ani314.8 g insectivore
Megascops choliba1132 g carnivore-insectivore
Hydropsalis albicollis2
Chaetura meridionalis1 insectivore
Chaetura brachyura118.3 g insectivore
Tachornis squamata283.4 g
Glaucis hirsutus182.0 g nectarivore
Phaethornis ruber62.4 g nectarivore
Phaethornis hispidus45.0 g nectarivore
Anthracothorax nigricollis17.0 g nectarivore
Thalurania furcata32.0 g nectarivore-insectivore
Amazilia lactea11 nectarivore
Chloroceryle amazona5121 g carnivore
Chloroceryle aenea43.6 g piscivore
Chloroceryle americana25.5 g carnivore
Chloroceryle inda152.1 g piscivore
Bucco macrodactylus425.0 g insectivore
Monasa nigrifrons980.7 g insectivore
Picumnus rufiventris321.0 g insectivore
Veniliornis affinis536.0 g insectivore
Veniliornis passerinus432.1 g insectivore
Colaptes punctigula464.0 g insectivore
Celeus spectabilis2114 g
Campephilus melanoleucos1256 g insectivore
Aratinga weddellii2108 g
Brotogeris sanctithomae359.0 g
Myrmotherula axillaris102.8 g frugivore-insectivore
Thamnophilus murinus319.3 g insectivore
Taraba major159.2 g insectivore
Myrmelastes schistaceus4
Hypocnemis subflava2 insectivore
Dendrocincla fuliginosa938.7 g insectivore
Campylorhamphus trochilirostris540.8 g insectivore
Furnarius leucopus154.8 g insectivore
Neopelma sulphureiventer918.0 g insectivore
Corythopis torquatus2 insectivore
Hemitriccus flammulatus610.0 g insectivore
Elaenia spectabilis527.3 g omnivore
Elaenia parvirostris1313.8 g frugivore-insectivore
Tyrannulus elatus17.0 g insectivore
Phaeomyias murina210.0 g insectivore
Pitangus sulphuratus224.2 g frugivore-insectivore
Philohydor lictor125.5 g omnivore
Myiodynastes maculatus243.2 g frugivore-insectivore
Tyrannopsis sulphurea153.6 g
Megarynchus pitangua18.0 g frugivore-insectivore
Myiozetetes cayanensis2425.9 g omnivore
Tyrannus melancholicus3937.4 g insectivore-frugivore
Pyrocephalus rubinus414.4 g insectivore
Cnemotriccus fuscatus113.6 g insectivore
Cyclarhis gujanensis128.8 g insectivore-frugivore
Vireo olivaceus22.6 g insectivore-frugivore
Vireo chivi5 omnivore
Vireo flavoviridis14.2 g insectivore-frugivore
Stelgidopteryx ruficollis1816.1 g insectivore
Troglodytes musculus13 insectivore
Cantorchilus leucotis16 insectivore
Turdus amaurochalinus157.9 g insectivore-frugivore
Cacicus cela4106 g omnivore
Tangara mexicana120.5 g frugivore
Tangara episcopus18
Tangara palmarum8
Volatinia jacarina23.2 g granivore
Sporophila lineola19.8 g granivore
Sporophila castaneiventris117.8 g
Sporophila angolensis1 granivore
Sporophila sp.1
Saltator maximus446.2 g frugivore-folivore
Saltator coerulescens454.9 g insectivore-frugivore
Saltator azarae2
Euphonia chlorotica111.0 g frugivore
Ammodramus aurifrons2317.8 g