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=1765 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1765SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1225SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1765 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrastur' 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='Micrastur' AND (species='ruficollis' OR species='ruficollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrastur' AND (species='ruficollis' OR species='ruficollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrastur' 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='Micrastur' AND (species='ruficollis' OR species='ruficollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrastur' AND (junior_species='gilvicollis' OR junior_species='gilvicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrastur' AND (species='gilvicollis' OR species='gilvicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrastur' AND (species='gilvicollis' OR species='gilvicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrastur' AND (junior_species='gilvicollis' OR junior_species='gilvicollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micrastur' AND (species='gilvicollis' OR species='gilvicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrastur' AND (junior_species='mirandollei' OR junior_species='mirandolleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrastur' AND (species='mirandollei' OR species='mirandolleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrastur' AND (species='mirandollei' OR species='mirandolleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrastur' AND (junior_species='mirandollei' OR junior_species='mirandolleii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Micrastur' AND (species='mirandollei' OR species='mirandolleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontophorus' 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='Odontophorus' AND (species='gujanensis' OR species='gujanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontophorus' AND (species='gujanensis' OR species='gujanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontophorus' 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='Odontophorus' AND (species='gujanensis' OR species='gujanensis') 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='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='Dromococcyx' AND (junior_species='pavoninus' OR junior_species='pavoninus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dromococcyx' AND (species='pavoninus' OR species='pavoninus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dromococcyx' AND (species='pavoninus' OR species='pavoninus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dromococcyx' AND (junior_species='pavoninus' OR junior_species='pavoninus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dromococcyx' AND (species='pavoninus' OR species='pavoninus') 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='superciliosus' OR junior_species='superciliosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='superciliosus' OR species='superciliosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='superciliosus' OR species='superciliosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phaethornis' AND (species='superciliosus' OR species='superciliosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Campylopterus' AND (junior_species='largipennis' OR junior_species='largipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campylopterus' AND (species='largipennis' OR species='largipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campylopterus' AND (species='largipennis' OR species='largipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylopterus' AND (junior_species='largipennis' OR junior_species='largipennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Campylopterus' AND (species='largipennis' OR species='largipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Florisuga' AND (junior_species='mellivora' OR junior_species='mellivora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Florisuga' AND (species='mellivora' OR species='mellivora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Florisuga' AND (species='mellivora' OR species='mellivora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Florisuga' AND (junior_species='mellivora' OR junior_species='mellivora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Florisuga' AND (species='mellivora' OR species='mellivora') 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='Hylocharis' AND (junior_species='sapphirina' OR junior_species='sapphirina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylocharis' AND (species='sapphirina' OR species='sapphirina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylocharis' AND (species='sapphirina' OR species='sapphirina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylocharis' AND (junior_species='sapphirina' OR junior_species='sapphirina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylocharis' AND (species='sapphirina' OR species='sapphirina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='chionopectus' OR junior_species='chionopectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amazilia' AND (species='chionopectus' OR species='chionopectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amazilia' AND (species='chionopectus' OR species='chionopectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='chionopectus' OR junior_species='chionopectus')SELECT d.diet,d.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='chionopectus' OR species='chionopectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliothryx' AND (junior_species='aurita' OR junior_species='aurita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliothryx' AND (species='aurita' OR species='aurita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliothryx' AND (species='aurita' OR species='aurita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliothryx' AND (junior_species='aurita' OR junior_species='aurita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliothryx' AND (species='aurita' OR species='aurita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogon' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogon' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='rufus' OR junior_species='rufus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trogon' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT 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='Chloroceryle' AND (junior_species='aenae' OR junior_species='aenae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloroceryle' AND (species='aenae' OR species='aenae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroceryle' AND (species='aenae' OR species='aenae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroceryle' AND (junior_species='aenae' OR junior_species='aenae')SELECT d.diet,d.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='aenae' OR species='aenae') 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='Galbula' AND (junior_species='albirostris' OR junior_species='albirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galbula' AND (species='albirostris' OR species='albirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galbula' AND (species='albirostris' OR species='albirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galbula' AND (junior_species='albirostris' OR junior_species='albirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Galbula' AND (species='albirostris' OR species='albirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bucco' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bucco' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bucco' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bucco' AND (junior_species='capensis' OR junior_species='capensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Bucco' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='atra' OR junior_species='atra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monasa' AND (species='atra' OR species='atra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monasa' AND (species='atra' OR species='atra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='atra' OR junior_species='atra')SELECT d.diet,d.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='atra' OR species='atra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capito' AND (junior_species='niger' OR junior_species='niger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capito' AND (species='niger' OR species='niger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capito' AND (species='niger' OR species='niger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capito' AND (junior_species='niger' OR junior_species='niger')SELECT d.diet,d.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='niger' OR species='niger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphastos' AND (junior_species='vitellinus' OR junior_species='vitellinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphastos' AND (species='vitellinus' OR species='vitellinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphastos' AND (species='vitellinus' OR species='vitellinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphastos' AND (junior_species='vitellinus' OR junior_species='vitellinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ramphastos' AND (species='vitellinus' OR species='vitellinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' 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='Picumnus' AND (species='exilis' OR species='exilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picumnus' AND (species='exilis' OR species='exilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' 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='Picumnus' AND (species='exilis' OR species='exilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryocopus' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dryocopus' AND (species='lineatus' OR species='lineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dryocopus' AND (species='lineatus' OR species='lineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dryocopus' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dryocopus' AND (species='lineatus' OR species='lineatus') 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='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='Glyphorynchus' AND (junior_species='spirurus' OR junior_species='spirurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glyphorynchus' AND (species='spirurus' OR species='spirurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glyphorynchus' AND (species='spirurus' OR species='spirurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphorynchus' AND (junior_species='spirurus' OR junior_species='spirurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Glyphorynchus' AND (species='spirurus' OR species='spirurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='pardalotus' OR junior_species='pardalotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphorhynchus' AND (species='pardalotus' OR species='pardalotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphorhynchus' AND (species='pardalotus' OR species='pardalotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphorhynchus' AND (junior_species='pardalotus' OR junior_species='pardalotus')SELECT d.diet,d.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='pardalotus' OR species='pardalotus') 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='Dendrocolaptes' AND (junior_species='certhia' OR junior_species='certhia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocolaptes' AND (species='certhia' OR species='certhia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocolaptes' AND (species='certhia' OR species='certhia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocolaptes' AND (junior_species='certhia' OR junior_species='certhia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrocolaptes' AND (species='certhia' OR species='certhia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylorhamphus' AND (junior_species='procurvoides' OR junior_species='procurvoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campylorhamphus' AND (species='procurvoides' OR species='procurvoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campylorhamphus' AND (species='procurvoides' OR species='procurvoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylorhamphus' AND (junior_species='procurvoides' OR junior_species='procurvoides')SELECT d.diet,d.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='procurvoides' OR species='procurvoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='rutilans' OR junior_species='rutilans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synallaxis' AND (species='rutilans' OR species='rutilans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synallaxis' AND (species='rutilans' OR species='rutilans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='rutilans' OR junior_species='rutilans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synallaxis' AND (species='rutilans' OR species='rutilans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='pyrrhodes' OR junior_species='pyrrhodes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philydor' AND (species='pyrrhodes' OR species='pyrrhodes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philydor' AND (species='pyrrhodes' OR species='pyrrhodes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='pyrrhodes' OR junior_species='pyrrhodes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Philydor' AND (species='pyrrhodes' OR species='pyrrhodes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='ruficaudatus' OR junior_species='ruficaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philydor' AND (species='ruficaudatus' OR species='ruficaudatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philydor' AND (species='ruficaudatus' OR species='ruficaudatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='ruficaudatus' OR junior_species='ruficaudatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Philydor' AND (species='ruficaudatus' OR species='ruficaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='infuscatus' OR junior_species='infuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Automolus' AND (species='infuscatus' OR species='infuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Automolus' AND (species='infuscatus' OR species='infuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='infuscatus' OR junior_species='infuscatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Automolus' AND (species='infuscatus' OR species='infuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='ochrolaemus' OR junior_species='ochrolaemus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Automolus' AND (species='ochrolaemus' OR species='ochrolaemus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Automolus' AND (species='ochrolaemus' OR species='ochrolaemus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='ochrolaemus' OR junior_species='ochrolaemus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Automolus' AND (species='ochrolaemus' OR species='ochrolaemus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Sclerurus' AND (junior_species='caudacutus' OR junior_species='caudacutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclerurus' AND (species='caudacutus' OR species='caudacutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerurus' AND (species='caudacutus' OR species='caudacutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='caudacutus' OR junior_species='caudacutus')SELECT d.diet,d.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='caudacutus' OR species='caudacutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' 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='Sclerurus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerurus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' 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='Sclerurus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Frederickena' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Frederickena' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Frederickena' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Frederickena' AND (junior_species='viridis' OR junior_species='viridis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Frederickena' AND (species='viridis' OR species='viridis') 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='Thamnophilus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT d.diet,d.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='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='amazonicus' OR junior_species='amazonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='amazonicus' OR species='amazonicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='amazonicus' OR species='amazonicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='amazonicus' OR junior_species='amazonicus')SELECT d.diet,d.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='amazonicus' OR species='amazonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='ardesiacus' OR junior_species='ardesiacus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnomanes' AND (species='ardesiacus' OR species='ardesiacus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnomanes' AND (species='ardesiacus' OR species='ardesiacus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='ardesiacus' OR junior_species='ardesiacus')SELECT d.diet,d.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='ardesiacus' OR species='ardesiacus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='caesius' OR junior_species='caesius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnomanes' AND (species='caesius' OR species='caesius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnomanes' AND (species='caesius' OR species='caesius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='caesius' OR junior_species='caesius')SELECT d.diet,d.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='caesius' OR species='caesius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='guttata' OR junior_species='guttata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='guttata' OR species='guttata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='guttata' OR species='guttata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='guttata' OR junior_species='guttata')SELECT d.diet,d.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='guttata' OR species='guttata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='gutturalis' OR junior_species='gutturalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='gutturalis' OR species='gutturalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='gutturalis' OR species='gutturalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='gutturalis' OR junior_species='gutturalis')SELECT d.diet,d.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='gutturalis' OR species='gutturalis') 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='Myrmotherula' AND (junior_species='longipennis' OR junior_species='longipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='longipennis' OR species='longipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='longipennis' OR species='longipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='longipennis' OR junior_species='longipennis')SELECT d.diet,d.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='longipennis' OR species='longipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='menetriesii' OR junior_species='menetriesi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='menetriesii' OR species='menetriesi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='menetriesii' OR species='menetriesi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='menetriesii' OR junior_species='menetriesi')SELECT d.diet,d.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='menetriesii' OR species='menetriesi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercomacra' AND (junior_species='tyrannina' OR junior_species='tyrannina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercomacra' AND (species='tyrannina' OR species='tyrannina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercomacra' AND (species='tyrannina' OR species='tyrannina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercomacra' AND (junior_species='tyrannina' OR junior_species='tyrannina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cercomacra' AND (species='tyrannina' OR species='tyrannina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmoborus' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmoborus' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmoborus' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmoborus' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmoborus' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schistocichla' AND (junior_species='leucostigma' OR junior_species='leucostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schistocichla' AND (species='leucostigma' OR species='leucostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schistocichla' AND (species='leucostigma' OR species='leucostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schistocichla' AND (junior_species='leucostigma' OR junior_species='leucostigma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Schistocichla' AND (species='leucostigma' OR species='leucostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeciza' AND (junior_species='longipes' OR junior_species='longipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmeciza' AND (species='longipes' OR species='longipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmeciza' AND (species='longipes' OR species='longipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeciza' AND (junior_species='longipes' OR junior_species='longipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmeciza' AND (species='longipes' OR species='longipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeciza' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmeciza' AND (species='ferruginea' OR species='ferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmeciza' AND (species='ferruginea' OR species='ferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeciza' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmeciza' AND (species='ferruginea' OR species='ferruginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithys' AND (junior_species='albifrons' OR junior_species='albifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pithys' AND (species='albifrons' OR species='albifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pithys' AND (species='albifrons' OR species='albifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pithys' AND (junior_species='albifrons' OR junior_species='albifrons')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pithys' AND (species='albifrons' OR species='albifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopithys' AND (junior_species='rufigula' OR junior_species='rufigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnopithys' AND (species='rufigula' OR species='rufigula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnopithys' AND (species='rufigula' OR species='rufigula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopithys' AND (junior_species='rufigula' OR junior_species='rufigula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gymnopithys' AND (species='rufigula' OR species='rufigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Willisornis' AND (junior_species='poecilinotus' OR junior_species='poecilinotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Willisornis' AND (species='poecilinotus' OR species='poecilinotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Willisornis' AND (species='poecilinotus' OR species='poecilinotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Willisornis' AND (junior_species='poecilinotus' OR junior_species='poecilinotus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Willisornis' AND (species='poecilinotus' OR species='poecilinotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmornis' AND (junior_species='torquata' OR junior_species='torquata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmornis' AND (species='torquata' OR species='torquata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmornis' AND (species='torquata' OR species='torquata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmornis' AND (junior_species='torquata' OR junior_species='torquata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmornis' AND (species='torquata' OR species='torquata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='colma' OR junior_species='colma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicarius' AND (species='colma' OR species='colma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicarius' AND (species='colma' OR species='colma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='colma' OR junior_species='colma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Formicarius' AND (species='colma' OR species='colma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='analis' OR junior_species='analis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicarius' AND (species='analis' OR species='analis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicarius' AND (species='analis' OR species='analis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicarius' AND (junior_species='analis' OR junior_species='analis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Formicarius' AND (species='analis' OR species='analis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylopezus' AND (junior_species='macularius' OR junior_species='macularius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylopezus' AND (species='macularius' OR species='macularius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylopezus' AND (species='macularius' OR species='macularius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylopezus' AND (junior_species='macularius' OR junior_species='macularius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylopezus' AND (species='macularius' OR species='macularius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmothera' AND (junior_species='campanisona' OR junior_species='campanisona')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmothera' AND (species='campanisona' OR species='campanisona') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmothera' AND (species='campanisona' OR species='campanisona')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmothera' AND (junior_species='campanisona' OR junior_species='campanisona')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmothera' AND (species='campanisona' OR species='campanisona') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lipaugus' AND (junior_species='vociferans' OR junior_species='vociferans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lipaugus' AND (species='vociferans' OR species='vociferans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lipaugus' AND (species='vociferans' OR species='vociferans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lipaugus' AND (junior_species='vociferans' OR junior_species='vociferans')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lipaugus' AND (species='vociferans' OR species='vociferans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laniocera' AND (junior_species='hypopyrrha' OR junior_species='hypopyrrha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laniocera' AND (species='hypopyrrha' OR species='hypopyrrha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laniocera' AND (species='hypopyrrha' OR species='hypopyrrha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laniocera' AND (junior_species='hypopyrrha' OR junior_species='hypopyrrha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Laniocera' AND (species='hypopyrrha' OR species='hypopyrrha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='erythrocephala' OR junior_species='erythrocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='erythrocephala' OR species='erythrocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='erythrocephala' OR species='erythrocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='erythrocephala' OR junior_species='erythrocephala')SELECT d.diet,d.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='erythrocephala' OR species='erythrocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='pipra' OR junior_species='pipra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='pipra' OR species='pipra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='pipra' OR species='pipra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='pipra' OR junior_species='pipra')SELECT d.diet,d.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='pipra' OR species='pipra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='coronata' OR junior_species='coronata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='coronata' OR species='coronata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='coronata' OR species='coronata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='coronata' OR junior_species='coronata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pipra' AND (species='coronata' OR species='coronata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corapipo' AND (junior_species='gutturalis' OR junior_species='gutturalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corapipo' AND (species='gutturalis' OR species='gutturalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corapipo' AND (species='gutturalis' OR species='gutturalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corapipo' AND (junior_species='gutturalis' OR junior_species='gutturalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corapipo' AND (species='gutturalis' OR species='gutturalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piprites' AND (junior_species='chloris' OR junior_species='chloris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piprites' AND (species='chloris' OR species='chloris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piprites' AND (species='chloris' OR species='chloris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piprites' AND (junior_species='chloris' OR junior_species='chloris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Piprites' AND (species='chloris' OR species='chloris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='turdina' OR junior_species='turdina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schiffornis' AND (species='turdina' OR species='turdina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schiffornis' AND (species='turdina' OR species='turdina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='turdina' OR junior_species='turdina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Schiffornis' AND (species='turdina' OR species='turdina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attila' AND (junior_species='spadiceus' OR junior_species='spadiceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Attila' AND (species='spadiceus' OR species='spadiceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Attila' AND (species='spadiceus' OR species='spadiceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attila' AND (junior_species='spadiceus' OR junior_species='spadiceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Attila' AND (species='spadiceus' OR species='spadiceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attila' AND (junior_species='cinnamomeus' OR junior_species='cinnamomeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Attila' AND (species='cinnamomeus' OR species='cinnamomeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Attila' AND (species='cinnamomeus' OR species='cinnamomeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Attila' AND (junior_species='cinnamomeus' OR junior_species='cinnamomeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Attila' AND (species='cinnamomeus' OR species='cinnamomeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhytipterna' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhytipterna' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhytipterna' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhytipterna' AND (junior_species='simplex' OR junior_species='simplex')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhytipterna' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathotriccus' AND (junior_species='euleri' OR junior_species='eulerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lathotriccus' AND (species='euleri' OR species='eulerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lathotriccus' AND (species='euleri' OR species='eulerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathotriccus' AND (junior_species='euleri' OR junior_species='eulerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lathotriccus' AND (species='euleri' OR species='eulerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terenotriccus' AND (junior_species='erythrurus' OR junior_species='erythrurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terenotriccus' AND (species='erythrurus' OR species='erythrurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terenotriccus' AND (species='erythrurus' OR species='erythrurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terenotriccus' AND (junior_species='erythrurus' OR junior_species='erythrurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terenotriccus' AND (species='erythrurus' OR species='erythrurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiobius' AND (junior_species='barbatus' OR junior_species='barbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiobius' AND (species='barbatus' OR species='barbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiobius' AND (species='barbatus' OR species='barbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiobius' AND (junior_species='barbatus' OR junior_species='barbatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiobius' AND (species='barbatus' OR species='barbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychorhynchus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychorhynchus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychorhynchus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychorhynchus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Onychorhynchus' AND (species='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrinchus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyrinchus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platyrinchus' AND (species='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='saturatus' OR junior_species='saturatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrinchus' AND (species='saturatus' OR species='saturatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyrinchus' AND (species='saturatus' OR species='saturatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='saturatus' OR junior_species='saturatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platyrinchus' AND (species='saturatus' OR species='saturatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tolmomyias' 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='Tolmomyias' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tolmomyias' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tolmomyias' 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='Tolmomyias' AND (species='sp.' OR species='sp.') 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='Ramphotrigon' AND (junior_species='ruficauda' OR junior_species='ruficauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphotrigon' AND (species='ruficauda' OR species='ruficauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphotrigon' AND (species='ruficauda' OR species='ruficauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphotrigon' AND (junior_species='ruficauda' OR junior_species='ruficauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ramphotrigon' AND (species='ruficauda' OR species='ruficauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colopyeryx' AND (junior_species='galeatus' OR junior_species='galeatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colopyeryx' AND (species='galeatus' OR species='galeatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colopyeryx' AND (species='galeatus' OR species='galeatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colopyeryx' AND (junior_species='galeatus' OR junior_species='galeatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colopyeryx' AND (species='galeatus' OR species='galeatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiornis' AND (junior_species='ecaudatus' OR junior_species='ecaudatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiornis' AND (species='ecaudatus' OR species='ecaudatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiornis' AND (species='ecaudatus' OR species='ecaudatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiornis' AND (junior_species='ecaudatus' OR junior_species='ecaudatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiornis' AND (species='ecaudatus' OR species='ecaudatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiopagis' AND (junior_species='viridicata' OR junior_species='viridicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiopagis' AND (species='viridicata' OR species='viridicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiopagis' AND (species='viridicata' OR species='viridicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiopagis' AND (junior_species='viridicata' OR junior_species='viridicata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiopagis' AND (species='viridicata' OR species='viridicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zimmerius' AND (junior_species='gracilipes' OR junior_species='gracilipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zimmerius' AND (species='gracilipes' OR species='gracilipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zimmerius' AND (species='gracilipes' OR species='gracilipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zimmerius' AND (junior_species='gracilipes' OR junior_species='gracilipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zimmerius' AND (species='gracilipes' OR species='gracilipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ornithion' AND (junior_species='inerme' OR junior_species='inerme')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ornithion' AND (species='inerme' OR species='inerme') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ornithion' AND (species='inerme' OR species='inerme')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ornithion' AND (junior_species='inerme' OR junior_species='inerme')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ornithion' AND (species='inerme' OR species='inerme') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='oleagineus' OR junior_species='oleagineus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mionectes' AND (species='oleagineus' OR species='oleagineus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mionectes' AND (species='oleagineus' OR species='oleagineus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='oleagineus' OR junior_species='oleagineus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mionectes' AND (species='oleagineus' OR species='oleagineus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='macconnelli' OR junior_species='macconnellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mionectes' AND (species='macconnelli' OR species='macconnellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mionectes' AND (species='macconnelli' OR species='macconnellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='macconnelli' OR junior_species='macconnellii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mionectes' AND (species='macconnelli' OR species='macconnellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythopis' AND (junior_species='torquata' OR junior_species='torquata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corythopis' AND (species='torquata' OR species='torquata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corythopis' AND (species='torquata' OR species='torquata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythopis' AND (junior_species='torquata' OR junior_species='torquata')SELECT d.diet,d.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='torquata' OR species='torquata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocorax' AND (junior_species='cayanus' OR junior_species='cayanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanocorax' AND (species='cayanus' OR species='cayanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanocorax' AND (species='cayanus' OR species='cayanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocorax' AND (junior_species='cayanus' OR junior_species='cayanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyanocorax' AND (species='cayanus' OR species='cayanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryothorus' AND (junior_species='coraya' OR junior_species='coraya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thryothorus' AND (species='coraya' OR species='coraya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thryothorus' AND (species='coraya' OR species='coraya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thryothorus' AND (junior_species='coraya' OR junior_species='coraya')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thryothorus' AND (species='coraya' OR species='coraya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henicorhina' AND (junior_species='leucosticta' OR junior_species='leucosticta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Henicorhina' AND (species='leucosticta' OR species='leucosticta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Henicorhina' AND (species='leucosticta' OR species='leucosticta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Henicorhina' AND (junior_species='leucosticta' OR junior_species='leucosticta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Henicorhina' AND (species='leucosticta' OR species='leucosticta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphorhinus' AND (junior_species='aradus' OR junior_species='aradus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyphorhinus' AND (species='aradus' OR species='aradus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyphorhinus' AND (species='aradus' OR species='aradus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyphorhinus' AND (junior_species='aradus' OR junior_species='aradus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyphorhinus' AND (species='aradus' OR species='aradus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='fumigatus' OR junior_species='fumigatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='fumigatus' OR species='fumigatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='fumigatus' OR species='fumigatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='fumigatus' OR junior_species='fumigatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Turdus' AND (species='fumigatus' OR species='fumigatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' 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='Turdus' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' 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='Turdus' AND (species='albicollis' OR species='albicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphocaenus' AND (junior_species='melanurus' OR junior_species='melanurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ramphocaenus' AND (species='melanurus' OR species='melanurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ramphocaenus' AND (species='melanurus' OR species='melanurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ramphocaenus' AND (junior_species='melanurus' OR junior_species='melanurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ramphocaenus' AND (species='melanurus' OR species='melanurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophilus' AND (junior_species='ochraceiceps' OR junior_species='ochraceiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylophilus' AND (species='ochraceiceps' OR species='ochraceiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylophilus' AND (species='ochraceiceps' OR species='ochraceiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophilus' AND (junior_species='ochraceiceps' OR junior_species='ochraceiceps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylophilus' AND (species='ochraceiceps' OR species='ochraceiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='rivularis' OR junior_species='rivularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='rivularis' OR species='rivularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='rivularis' OR species='rivularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='rivularis' OR junior_species='rivularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Basileuterus' AND (species='rivularis' OR species='rivularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coereba' AND (junior_species='flaveola' OR junior_species='flaveola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coereba' AND (species='flaveola' OR species='flaveola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coereba' AND (species='flaveola' OR species='flaveola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coereba' AND (junior_species='flaveola' OR junior_species='flaveola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coereba' AND (species='flaveola' OR species='flaveola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanerpes' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanerpes' AND (species='caeruleus' OR species='caeruleus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanerpes' AND (species='caeruleus' OR species='caeruleus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanerpes' AND (junior_species='caeruleus' OR junior_species='caeruleus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyanerpes' AND (species='caeruleus' OR species='caeruleus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanio' AND (junior_species='fulvus' OR junior_species='fulvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanio' AND (species='fulvus' OR species='fulvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanio' AND (species='fulvus' OR species='fulvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanio' AND (junior_species='fulvus' OR junior_species='fulvus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lanio' AND (species='fulvus' OR species='fulvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='luctuosus' OR junior_species='luctuosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyphonus' AND (species='luctuosus' OR species='luctuosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyphonus' AND (species='luctuosus' OR species='luctuosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='luctuosus' OR junior_species='luctuosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachyphonus' AND (species='luctuosus' OR species='luctuosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocompsa' AND (junior_species='cyanoides' OR junior_species='cyanoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanocompsa' AND (species='cyanoides' OR species='cyanoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanocompsa' AND (species='cyanoides' OR species='cyanoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocompsa' AND (junior_species='cyanoides' OR junior_species='cyanoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyanocompsa' AND (species='cyanoides' OR species='cyanoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitylus' AND (junior_species='grossus' OR junior_species='grossus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitylus' AND (species='grossus' OR species='grossus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitylus' AND (species='grossus' OR species='grossus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitylus' AND (junior_species='grossus' OR junior_species='grossus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pitylus' AND (species='grossus' OR species='grossus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='taciturnus' OR junior_species='taciturnus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arremon' AND (species='taciturnus' OR species='taciturnus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremon' AND (species='taciturnus' OR species='taciturnus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='taciturnus' OR junior_species='taciturnus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arremon' AND (species='taciturnus' OR species='taciturnus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orzyoborus' 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='Orzyoborus' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orzyoborus' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orzyoborus' 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='Orzyoborus' AND (species='angolensis' OR species='angolensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1765 The Ecological Register: Imataca Forest Reserve Unit 5
Imataca Forest Reserve Unit 5
Basic information
Sample name: Imataca Forest Reserve Unit 5

Reference: D. Mason. 1996. Responses of Venezuelan understory birds to selective logging, enrichment strips, and vine cutting. Biotropica 28(3):296-309 [ER 1225]
Geography
Country: Venezuela


Coordinate: 7° 45' 0" N, 61° 7' 30" W
Coordinate basis: stated in text as range

Geography comments: coordinate is the midpoint of ranges stated in the text
elevation 140 to 240 m

Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: forest reserve

Substrate: ground surface

Disturbance: selective logging

MAT: 26.0

WMT: 27.1

CMT: 24.4

MAP: 1631.0

Habitat comments: "humid evergreen tropical forest... logging in the concession is selective"; six sites were unlogged and the other eight were recently logged
"most of the rainfall" occurs "between April and December"
MAP stated in text; MAT, CMT, and WMT are based on Delgado et al. (2005, "A conceptual model of biocomplexity in the upper Botanamo River Basin")

Methods
Life forms: birds

Sites: 14

Sampling methods: no design,mist nets

Sample size: 2443 individuals

Years: 1992, 1993

Days: 112

Sampling comments: "Plots were sampled twice for two days each year" (meaning 2 x 2 x 2 x 14 = 112 days) but the number of nets is not indicated

Metadata
Sample number: 1765

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-09-17 20:06:26

Modified: 2015-09-27 07:46:16

Abundance distribution
111 species
20 singletons
total count 2443
extrapolated richness: 159.4
Fisher's α: 23.949
geometric series k: 0.9526
Hurlbert's PIE: 0.9704
Shannon's H: 3.9367
Good's u: 0.9918
Each square represents a species. Square sizes are proportional to counts.
Register
Micrastur ruficollis1161 g carnivore-insectivore
Micrastur gilvicollis5209 g carnivore-insectivore
Micrastur mirandollei2549 g carnivore
Odontophorus gujanensis2331 g frugivore
Leptotila rufaxilla11157 g granivore-frugivore
Geotrygon montana125.2 g granivore-frugivore
Dromococcyx pavoninus146.4 g
Glaucis hirsutus122.0 g nectarivore
"Glaucis hirsuta"
Phaethornis superciliosus956.3 g nectarivore-insectivore
Phaethornis ruber62.4 g nectarivore
Campylopterus largipennis158.3 g nectarivore
Florisuga mellivora37.4 g nectarivore-insectivore
Thalurania furcata182.0 g nectarivore-insectivore
Hylocharis sapphirina14.4 g nectarivore
Amazilia chionopectus5
Heliothryx aurita2 nectarivore
Trogon rufus253.8 g insectivore-frugivore
Chloroceryle inda152.1 g piscivore
Chloroceryle aenae3
Momotus momota410.6 g carnivore-insectivore
Galbula albirostris3322.1 g insectivore
Bucco capensis454.0 g insectivore
Monasa atra190.4 g omnivore
Capito niger13.9 g insectivore-frugivore
Ramphastos vitellinus1363 g omnivore
Picumnus exilis59.3 g
Dryocopus lineatus1194 g insectivore
Dendrocincla fuliginosa1338.7 g insectivore
Dendrocincla merula53.8 g insectivore
Glyphorynchus spirurus21014.6 g insectivore
Xiphorhynchus pardalotus3137.0 g insectivore
Xiphorhynchus guttatus217.8 g frugivore-insectivore
Dendrocolaptes certhia468.7 g insectivore
Campylorhamphus procurvoides633.5 g frugivore-insectivore
Synallaxis rutilans2016.7 g insectivore
Philydor pyrrhodes1430.5 g insectivore
Philydor ruficaudatus2 insectivore
Automolus infuscatus3732.9 g frugivore-insectivore
Automolus ochrolaemus3140.2 g insectivore
Xenops minutus2710.6 g frugivore-insectivore
Sclerurus caudacutus76.1 g insectivore
Sclerurus sp.17
"mexicanus + rufigularis"
Frederickena viridis576.0 g insectivore
Thamnophilus murinus1519.3 g insectivore
Thamnophilus punctatus3019.4 g insectivore
Thamnophilus amazonicus14.2 g
Thamnomanes ardesiacus3617.7 g insectivore
Thamnomanes caesius4615.7 g frugivore-insectivore
Myrmotherula guttata5711.0 g insectivore
Myrmotherula gutturalis239.2 g insectivore
Myrmotherula axillaris372.8 g frugivore-insectivore
Myrmotherula longipennis159.4 g frugivore-insectivore
Myrmotherula menetriesii128.6 g frugivore-insectivore
Cercomacra tyrannina3516.3 g insectivore
Myrmoborus leucophrys5521.5 g insectivore
Schistocichla leucostigma7 insectivore
Myrmeciza longipes627.9 g insectivore
Myrmeciza ferruginea1226.1 g insectivore
Pithys albifrons1294.3 g insectivore
Gymnopithys rufigula13929.1 g insectivore
Willisornis poecilinotus64 insectivore
"Hylophylax poecilonota"
Myrmornis torquata1646.7 g insectivore
Formicarius colma2547.0 g insectivore
Formicarius analis1162.2 g insectivore
Hylopezus macularius144.2 g insectivore
Myrmothera campanisona447.0 g insectivore
Lipaugus vociferans28.3 g frugivore-insectivore
Laniocera hypopyrrha1
Pipra erythrocephala11812.8 g frugivore
Pipra pipra8410.3 g frugivore
Pipra coronata18.0 g insectivore-frugivore
Corapipo gutturalis18.2 g frugivore
Piprites chloris216.0 g insectivore
Schiffornis turdina6431.7 g insectivore
"Schiffornis turdinus"
Attila spadiceus739.1 g insectivore
Attila cinnamomeus138.8 g insectivore
Rhytipterna simplex131.8 g insectivore
Lathotriccus euleri12
Terenotriccus erythrurus257.4 g insectivore
Myiobius barbatus5011.4 g frugivore-insectivore
Onychorhynchus coronatus2314.0 g insectivore
Platyrinchus coronatus183.0 g insectivore
Platyrinchus saturatus2310.7 g insectivore
Tolmomyias sp.1
Rhynchocyclus olivaceus921.3 g insectivore
Ramphotrigon ruficauda218.4 g insectivore
Colopyeryx galeatus7
Myiornis ecaudatus12.1 g insectivore
Myiopagis viridicata12.3 g insectivore
Zimmerius gracilipes27.6 g omnivore
Ornithion inerme27.0 g insectivore
Mionectes oleagineus602.3 g insectivore-frugivore
"Mionectes oleaginea"
Mionectes macconnelli4513.5 g insectivore-frugivore
Corythopis torquata3214.3 g insectivore
Cyanocorax cayanus2
Thryothorus coraya717.2 g frugivore-insectivore
Henicorhina leucosticta2214.8 g insectivore
Cyphorhinus aradus55 insectivore
Turdus fumigatus48.4 g frugivore-insectivore
Turdus albicollis5454.0 g insectivore-frugivore
Ramphocaenus melanurus29.7 g frugivore-insectivore
Hylophilus ochraceiceps1811.6 g insectivore
Basileuterus rivularis2713.5 g insectivore
Coereba flaveola21.3 g frugivore-insectivore
Cyanerpes caeruleus712.0 g nectarivore
Lanio fulvus124.0 g insectivore
Tachyphonus luctuosus213.0 g insectivore-frugivore
Cyanocompsa cyanoides4932.5 g frugivore-insectivore
Pitylus grossus7 frugivore-insectivore
Arremon taciturnus11524.8 g insectivore-frugivore
Orzyoborus angolensis1