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=1116 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1116SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=773SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1116 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorostilbon' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorostilbon' AND (species='lucidus' OR species='lucidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorostilbon' AND (species='lucidus' OR species='lucidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorostilbon' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlorostilbon' AND (species='lucidus' OR species='lucidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalurania' AND (junior_species='glaucopis' OR junior_species='glaucopis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thalurania' AND (species='glaucopis' OR species='glaucopis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thalurania' AND (species='glaucopis' OR species='glaucopis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalurania' AND (junior_species='glaucopis' OR junior_species='glaucopis')SELECT d.diet,d.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='glaucopis' OR species='glaucopis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malacoptila' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malacoptila' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malacoptila' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malacoptila' AND (junior_species='striata' OR junior_species='striata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Malacoptila' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thamnophilus' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysithamnus' AND (junior_species='mentalis' OR junior_species='mentalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysithamnus' AND (species='mentalis' OR species='mentalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysithamnus' AND (species='mentalis' OR species='mentalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysithamnus' AND (junior_species='mentalis' OR junior_species='mentalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dysithamnus' AND (species='mentalis' OR species='mentalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyriglena' AND (junior_species='leucoptera' OR junior_species='leucoptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyriglena' AND (species='leucoptera' OR species='leucoptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyriglena' AND (species='leucoptera' OR species='leucoptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyriglena' AND (junior_species='leucoptera' OR junior_species='leucoptera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyriglena' AND (species='leucoptera' OR species='leucoptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeciza' AND (junior_species='squamosa' OR junior_species='squamosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmeciza' AND (species='squamosa' OR species='squamosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmeciza' AND (species='squamosa' OR species='squamosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmeciza' AND (junior_species='squamosa' OR junior_species='squamosa')SELECT d.diet,d.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='squamosa' OR species='squamosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopophaga' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conopophaga' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conopophaga' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conopophaga' AND (junior_species='lineata' OR junior_species='lineata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conopophaga' AND (species='lineata' OR species='lineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='scansor' OR junior_species='scansor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclerurus' AND (species='scansor' OR species='scansor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclerurus' AND (species='scansor' OR species='scansor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclerurus' AND (junior_species='scansor' OR junior_species='scansor')SELECT d.diet,d.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='scansor' OR species='scansor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sittasomus' AND (junior_species='griseicapillus' OR junior_species='griseicapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sittasomus' AND (species='griseicapillus' OR species='griseicapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sittasomus' AND (species='griseicapillus' OR species='griseicapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sittasomus' AND (junior_species='griseicapillus' OR junior_species='griseicapillus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sittasomus' AND (species='griseicapillus' OR species='griseicapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='squamatus' OR junior_species='squamatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidocolaptes' AND (species='squamatus' OR species='squamatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidocolaptes' AND (species='squamatus' OR species='squamatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidocolaptes' AND (junior_species='squamatus' OR junior_species='squamatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lepidocolaptes' AND (species='squamatus' OR species='squamatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synallaxis' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synallaxis' AND (species='ruficapilla' OR species='ruficapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Synallaxis' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anabacerthia' AND (junior_species='amaurotis' OR junior_species='amaurotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anabacerthia' AND (species='amaurotis' OR species='amaurotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anabacerthia' AND (species='amaurotis' OR species='amaurotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anabacerthia' AND (junior_species='amaurotis' OR junior_species='amaurotis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anabacerthia' AND (species='amaurotis' OR species='amaurotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='atricapillus' OR junior_species='atricapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philydor' AND (species='atricapillus' OR species='atricapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philydor' AND (species='atricapillus' OR species='atricapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philydor' AND (junior_species='atricapillus' OR junior_species='atricapillus')SELECT d.diet,d.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='atricapillus' OR species='atricapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='leucophthalmus' OR junior_species='leucophthalmus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Automolus' AND (species='leucophthalmus' OR species='leucophthalmus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Automolus' AND (species='leucophthalmus' OR species='leucophthalmus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='leucophthalmus' OR junior_species='leucophthalmus')SELECT d.diet,d.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='leucophthalmus' OR species='leucophthalmus') 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='Mionectes' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mionectes' AND (species='rufiventris' OR species='rufiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mionectes' AND (species='rufiventris' OR species='rufiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mionectes' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mionectes' AND (species='rufiventris' OR species='rufiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopogon' AND (junior_species='amaurocephalus' OR junior_species='amaurocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopogon' AND (junior_species='amaurocephalus' OR junior_species='amaurocephalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptopogon' AND (species='amaurocephalus' OR species='amaurocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tolmomyias' AND (junior_species='sulphurescens' OR junior_species='sulphurescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tolmomyias' AND (species='sulphurescens' OR species='sulphurescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tolmomyias' AND (species='sulphurescens' OR species='sulphurescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tolmomyias' AND (junior_species='sulphurescens' OR junior_species='sulphurescens')SELECT d.diet,d.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='sulphurescens' OR species='sulphurescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tolmomyias' AND (junior_species='poliocephalus' OR junior_species='poliocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tolmomyias' AND (species='poliocephalus' OR species='poliocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tolmomyias' AND (species='poliocephalus' OR species='poliocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tolmomyias' AND (junior_species='poliocephalus' OR junior_species='poliocephalus')SELECT d.diet,d.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='poliocephalus' OR species='poliocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='mystaceus' OR junior_species='mystaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyrinchus' AND (species='mystaceus' OR species='mystaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyrinchus' AND (species='mystaceus' OR species='mystaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyrinchus' AND (junior_species='mystaceus' OR junior_species='mystaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Platyrinchus' AND (species='mystaceus' OR species='mystaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroxiphia' AND (junior_species='caudata' OR junior_species='caudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chiroxiphia' AND (species='caudata' OR species='caudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chiroxiphia' AND (species='caudata' OR species='caudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chiroxiphia' AND (junior_species='caudata' OR junior_species='caudata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chiroxiphia' AND (species='caudata' OR species='caudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='virescens' OR junior_species='virescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schiffornis' AND (species='virescens' OR species='virescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schiffornis' AND (species='virescens' OR species='virescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schiffornis' AND (junior_species='virescens' OR junior_species='virescens')SELECT d.diet,d.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='virescens' OR species='virescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclarhis' AND (junior_species='gujanensis' OR junior_species='gujanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclarhis' AND (species='gujanensis' OR species='gujanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclarhis' AND (species='gujanensis' OR species='gujanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclarhis' AND (junior_species='gujanensis' OR junior_species='gujanensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclarhis' AND (species='gujanensis' OR species='gujanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='rufiventris' OR species='rufiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='rufiventris' OR species='rufiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Turdus' AND (species='rufiventris' OR species='rufiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='amaurochalinus' OR junior_species='amaurochalinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='amaurochalinus' OR junior_species='amaurochalinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Turdus' AND (species='amaurochalinus' OR species='amaurochalinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Trichothraupis' AND (junior_species='melanops' OR junior_species='melanops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichothraupis' AND (species='melanops' OR species='melanops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichothraupis' AND (species='melanops' OR species='melanops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichothraupis' AND (junior_species='melanops' OR junior_species='melanops')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichothraupis' AND (species='melanops' OR species='melanops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habia' AND (junior_species='rubica' OR junior_species='rubica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Habia' AND (species='rubica' OR species='rubica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Habia' AND (species='rubica' OR species='rubica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habia' AND (junior_species='rubica' OR junior_species='rubica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Habia' AND (species='rubica' OR species='rubica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyphonus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyphonus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachyphonus' AND (species='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipraeidea' AND (junior_species='melanonota' OR junior_species='melanonota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipraeidea' AND (species='melanonota' OR species='melanonota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipraeidea' AND (species='melanonota' OR species='melanonota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipraeidea' AND (junior_species='melanonota' OR junior_species='melanonota')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pipraeidea' AND (species='melanonota' OR species='melanonota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplospiza' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haplospiza' AND (species='unicolor' OR species='unicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Haplospiza' AND (species='unicolor' OR species='unicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Haplospiza' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Haplospiza' AND (species='unicolor' OR species='unicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryzoborus' 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='Oryzoborus' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oryzoborus' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryzoborus' 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='Oryzoborus' AND (species='angolensis' OR species='angolensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='culicivorus' OR junior_species='culicivorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='culicivorus' OR species='culicivorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='culicivorus' OR species='culicivorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='culicivorus' OR junior_species='culicivorus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Basileuterus' AND (species='culicivorus' OR species='culicivorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='leucoblepharus' OR junior_species='leucoblepharus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='leucoblepharus' OR species='leucoblepharus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='leucoblepharus' OR species='leucoblepharus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='leucoblepharus' OR junior_species='leucoblepharus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Basileuterus' AND (species='leucoblepharus' OR species='leucoblepharus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celeus' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celeus' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celeus' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celeus' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Celeus' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='cirratus' OR junior_species='cirratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picumnus' AND (species='cirratus' OR species='cirratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picumnus' AND (species='cirratus' OR species='cirratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='cirratus' OR junior_species='cirratus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Picumnus' AND (species='cirratus' OR species='cirratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='spilogaster' OR junior_species='spilogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Veniliornis' AND (species='spilogaster' OR species='spilogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Veniliornis' AND (species='spilogaster' OR species='spilogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='spilogaster' OR junior_species='spilogaster')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Veniliornis' AND (species='spilogaster' OR species='spilogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='violacea' OR junior_species='violacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geotrygon' AND (species='violacea' OR species='violacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geotrygon' AND (species='violacea' OR species='violacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrygon' AND (junior_species='violacea' OR junior_species='violacea')SELECT d.diet,d.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='violacea' OR species='violacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='verreauxi' OR junior_species='verreauxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotila' AND (species='verreauxi' OR species='verreauxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotila' AND (species='verreauxi' OR species='verreauxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotila' AND (junior_species='verreauxi' OR junior_species='verreauxii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptotila' AND (species='verreauxi' OR species='verreauxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amazilia' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amazilia' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT d.diet,d.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='versicolor' OR species='versicolor') 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='Florisuga' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Florisuga' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Florisuga' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Florisuga' AND (junior_species='fusca' OR junior_species='fusca')SELECT d.diet,d.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='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='eurynome' OR junior_species='eurynome')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='eurynome' OR species='eurynome') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='eurynome' OR species='eurynome')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='eurynome' OR junior_species='eurynome')SELECT d.diet,d.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='eurynome' OR species='eurynome') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='pretrei' OR junior_species='pretreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='pretrei' OR species='pretreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='pretrei' OR species='pretreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='pretrei' OR junior_species='pretreii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phaethornis' AND (species='pretrei' OR species='pretreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmotherula' AND (species='unicolor' OR species='unicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmotherula' AND (species='unicolor' OR species='unicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmotherula' AND (junior_species='unicolor' OR junior_species='unicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myrmotherula' AND (species='unicolor' OR species='unicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphocolaptes' 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='Xiphocolaptes' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphocolaptes' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphocolaptes' 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='Xiphocolaptes' AND (species='albicollis' OR species='albicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Synallaxis' AND (species='cinerea' OR species='cinerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Synallaxis' AND (species='cinerea' OR species='cinerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Synallaxis' AND (junior_species='cinerea' OR junior_species='cinerea')SELECT d.diet,d.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='cinerea' OR species='cinerea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lochmias' AND (junior_species='nematura' OR junior_species='nematura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lochmias' AND (species='nematura' OR species='nematura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lochmias' AND (species='nematura' OR species='nematura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lochmias' AND (junior_species='nematura' OR junior_species='nematura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lochmias' AND (species='nematura' OR species='nematura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemotriccus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemotriccus' AND (junior_species='fuscatus' OR junior_species='fuscatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cnemotriccus' AND (species='fuscatus' OR species='fuscatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='orbitatus' OR junior_species='orbitatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemitriccus' AND (species='orbitatus' OR species='orbitatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemitriccus' AND (species='orbitatus' OR species='orbitatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='orbitatus' OR junior_species='orbitatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemitriccus' AND (species='orbitatus' OR species='orbitatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathrotriccus' AND (junior_species='euleri' OR junior_species='eulerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lathrotriccus' AND (species='euleri' OR species='eulerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lathrotriccus' AND (species='euleri' OR species='eulerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathrotriccus' AND (junior_species='euleri' OR junior_species='eulerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lathrotriccus' AND (species='euleri' OR species='eulerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiodynastes' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiodynastes' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiodynastes' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiodynastes' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiodynastes' AND (species='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilotriccus' AND (junior_species='plumbeiceps' OR junior_species='plumbeiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecilotriccus' AND (species='plumbeiceps' OR species='plumbeiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecilotriccus' AND (species='plumbeiceps' OR species='plumbeiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilotriccus' AND (junior_species='plumbeiceps' OR junior_species='plumbeiceps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poecilotriccus' AND (species='plumbeiceps' OR species='plumbeiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vireo' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vireo' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Vireo' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Turdus' AND (junior_species='leucomelas' OR junior_species='leucomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='leucomelas' OR species='leucomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='leucomelas' OR species='leucomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='leucomelas' OR junior_species='leucomelas')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Turdus' AND (species='leucomelas' OR species='leucomelas') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1116 The Ecological Register: Säo Paulo Metropolitan Area
Säo Paulo Metropolitan Area
Basic information
Sample name: Säo Paulo Metropolitan Area

Reference: M. Ogrzewalska, D. G. Saraiva, J. Moraes-Filho, T. F. Martins, F. B. Costa, A. Pinter, and M. B. Labruna. 2012. Epidemiology of Brazilian spotted fever in the Atlantic Forest, state of São Paulo, Brazil. Parasitology 139:1283-1300 [ER 773]
Geography
Country: Brazil

State: Säo Paulo


Coordinate: 23° 33' S, 46° 38' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Säo Paulo
altitude 765 to 1000 m

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 18.0

WMT: 22.0

CMT: 14.0

MAP: 1400.0

Habitat comments: seven "forest areas" in multiple municipalities

Methods
Life forms: birds

Sites: 7

Sampling methods: mist nets

Sample size: 596 individuals

Days: 14

Nets or traps: 10

Net or trap nights: 140

Sampling comments: "10 mist nets (12 m long × 2 m wide, 36mm mesh)" used for 18 hours over two days in each area

Metadata
Sample number: 1116

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-28 20:35:22

Modified: 2014-08-28 10:35:22

Abundance distribution
57 species
16 singletons
total count 596
extrapolated richness: 92.4
Fisher's α: 15.513
geometric series k: 0.9298
Hurlbert's PIE: 0.9602
Shannon's H: 3.5021
Good's u: 0.9732
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Chlorostilbon lucidus3 nectarivore
Thalurania glaucopis294.8 g nectarivore
Malacoptila striata844.1 g insectivore
Thamnophilus caerulescens421.1 g insectivore
Dysithamnus mentalis282.4 g insectivore
Pyriglena leucoptera1828.8 g insectivore
Myrmeciza squamosa518.5 g insectivore
Conopophaga lineata285.5 g insectivore
Sclerurus scansor836.9 g insectivore
Sittasomus griseicapillus192.6 g insectivore
Lepidocolaptes squamatus1928.1 g insectivore
Synallaxis ruficapilla2613.8 g insectivore
Anabacerthia amaurotis419.2 g insectivore
Philydor atricapillus122.2 g insectivore
Automolus leucophthalmus1834.5 g insectivore
Xenops minutus410.6 g frugivore-insectivore
Mionectes rufiventris1013.3 g insectivore-frugivore
Leptopogon amaurocephalus1211.7 g insectivore-frugivore
Tolmomyias sulphurescens614.3 g insectivore
Tolmomyias poliocephalus110.8 g insectivore
Platyrinchus mystaceus379.7 g insectivore
Chiroxiphia caudata1925.6 g frugivore
Schiffornis virescens1625.6 g insectivore
Cyclarhis gujanensis228.8 g insectivore-frugivore
Turdus rufiventris3066.8 g frugivore-insectivore
Turdus amaurochalinus557.9 g insectivore-frugivore
Turdus albicollis954.0 g insectivore-frugivore
Trichothraupis melanops2924.3 g insectivore-frugivore
Habia rubica2434.0 g insectivore-frugivore
Tachyphonus coronatus1029.3 g omnivore
Pipraeidea melanonota121.0 g frugivore-insectivore
Haplospiza unicolor1115.9 g granivore
Oryzoborus (Sporophila) angolensis113.0 g granivore
Basileuterus culicivorus5910.5 g insectivore-frugivore
Basileuterus leucoblepharus2515.1 g insectivore
Celeus flavescens3139 g insectivore
Picumnus cirratus110.2 g insectivore
Veniliornis spilogaster140.3 g insectivore
Geotrygon violacea195.2 g granivore
Leptotila verreauxi411.6 g granivore-frugivore
Amazilia versicolor6 nectarivore
Phaethornis superciliosus146.3 g nectarivore-insectivore
Florisuga fusca1 nectarivore
Phaethornis eurynome95.3 g nectarivore
Phaethornis pretrei15.6 g nectarivore
Myrmotherula unicolor111.5 g insectivore
Xiphocolaptes albicollis1118 g insectivore
Synallaxis cinerea5
Lochmias nematura422.0 g insectivore
Cnemotriccus fuscatus113.6 g insectivore
Hemitriccus orbitatus49.7 g insectivore
Lathrotriccus euleri33.3 g insectivore
Myiodynastes maculatus143.2 g frugivore-insectivore
Poecilotriccus plumbeiceps1 insectivore
Vireo olivaceus12.6 g insectivore-frugivore
Coereba flaveola31.3 g frugivore-insectivore
Turdus leucomelas169.1 g frugivore-insectivore