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=3035 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3035SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2800SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3035 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Threnetes' AND (junior_species='leucurus' OR junior_species='leucurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Threnetes' AND (species='leucurus' OR species='leucurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Threnetes' AND (species='leucurus' OR species='leucurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Threnetes' AND (junior_species='leucurus' OR junior_species='leucurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Threnetes' AND (species='leucurus' OR species='leucurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='ruber' OR junior_species='ruber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='ruber' OR species='ruber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='ruber' OR species='ruber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='ruber' OR junior_species='ruber')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phaethornis' AND (species='ruber' OR species='ruber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='hispidus' OR species='hispidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='hispidus' OR species='hispidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='hispidus' OR junior_species='hispidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phaethornis' AND (species='hispidus' OR species='hispidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='malaris' OR junior_species='malaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='malaris' OR species='malaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='malaris' OR species='malaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='malaris' OR junior_species='malaris')SELECT d.diet,d.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='malaris' OR species='malaris') 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='Electron' AND (junior_species='platyrhynchum' OR junior_species='platyrhynchum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Electron' AND (species='platyrhynchum' OR species='platyrhynchum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Electron' AND (species='platyrhynchum' OR species='platyrhynchum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Electron' AND (junior_species='platyrhynchum' OR junior_species='platyrhynchum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Electron' AND (species='platyrhynchum' OR species='platyrhynchum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='nigrifrons' OR junior_species='nigrifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monasa' AND (species='nigrifrons' OR species='nigrifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monasa' AND (species='nigrifrons' OR species='nigrifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='nigrifrons' OR junior_species='nigrifrons')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monasa' AND (species='nigrifrons' OR species='nigrifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='morphoeus' OR junior_species='morphoeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monasa' AND (species='morphoeus' OR species='morphoeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monasa' AND (species='morphoeus' OR species='morphoeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monasa' AND (junior_species='morphoeus' OR junior_species='morphoeus')SELECT d.diet,d.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='morphoeus' OR species='morphoeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Veniliornis' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Veniliornis' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='affinis' OR junior_species='affinis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Veniliornis' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='passerinus' OR junior_species='passerinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Veniliornis' AND (species='passerinus' OR species='passerinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Veniliornis' AND (species='passerinus' OR species='passerinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Veniliornis' AND (junior_species='passerinus' OR junior_species='passerinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Veniliornis' AND (species='passerinus' OR species='passerinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Microrhopias' AND (junior_species='quixensis' OR junior_species='quixensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microrhopias' AND (species='quixensis' OR species='quixensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microrhopias' AND (species='quixensis' OR species='quixensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microrhopias' AND (junior_species='quixensis' OR junior_species='quixensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microrhopias' AND (species='quixensis' OR species='quixensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epinecrophylla' AND (junior_species='ornata' OR junior_species='ornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epinecrophylla' AND (species='ornata' OR species='ornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epinecrophylla' AND (species='ornata' OR species='ornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epinecrophylla' AND (junior_species='ornata' OR junior_species='ornata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epinecrophylla' AND (species='ornata' OR species='ornata') 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='Isleria' AND (junior_species='hauxwelli' OR junior_species='hauxwellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Isleria' AND (species='hauxwelli' OR species='hauxwellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Isleria' AND (species='hauxwelli' OR species='hauxwellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Isleria' AND (junior_species='hauxwelli' OR junior_species='hauxwellii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Isleria' AND (species='hauxwelli' OR species='hauxwellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='schistogynus' OR junior_species='schistogynus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnomanes' AND (species='schistogynus' OR species='schistogynus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnomanes' AND (species='schistogynus' OR species='schistogynus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnomanes' AND (junior_species='schistogynus' OR junior_species='schistogynus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thamnomanes' AND (species='schistogynus' OR species='schistogynus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='schistaceus' OR junior_species='schistaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='schistaceus' OR species='schistaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='schistaceus' OR species='schistaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='schistaceus' OR junior_species='schistaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thamnophilus' AND (species='schistaceus' OR species='schistaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='aethiops' OR junior_species='aethiops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='aethiops' OR species='aethiops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='aethiops' OR species='aethiops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='aethiops' OR junior_species='aethiops')SELECT d.diet,d.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='aethiops' OR species='aethiops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclateria' AND (junior_species='naevia' OR junior_species='naevia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sclateria' AND (species='naevia' OR species='naevia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sclateria' AND (species='naevia' OR species='naevia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sclateria' AND (junior_species='naevia' OR junior_species='naevia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sclateria' AND (species='naevia' OR species='naevia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmoborus' AND (junior_species='myotherinus' OR junior_species='myotherinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myrmoborus' AND (species='myotherinus' OR species='myotherinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myrmoborus' AND (species='myotherinus' OR species='myotherinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myrmoborus' AND (junior_species='myotherinus' OR junior_species='myotherinus')SELECT d.diet,d.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='myotherinus' OR species='myotherinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciaphylax' AND (junior_species='hemimelaena' OR junior_species='hemimelaena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciaphylax' AND (species='hemimelaena' OR species='hemimelaena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciaphylax' AND (species='hemimelaena' OR species='hemimelaena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciaphylax' AND (junior_species='hemimelaena' OR junior_species='hemimelaena')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sciaphylax' AND (species='hemimelaena' OR species='hemimelaena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocnemis' AND (junior_species='subflava' OR junior_species='subflava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypocnemis' AND (species='subflava' OR species='subflava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypocnemis' AND (species='subflava' OR species='subflava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocnemis' AND (junior_species='subflava' OR junior_species='subflava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypocnemis' AND (species='subflava' OR species='subflava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocnemis' AND (junior_species='peruviana' OR junior_species='peruviana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypocnemis' AND (species='peruviana' OR species='peruviana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypocnemis' AND (species='peruviana' OR species='peruviana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypocnemis' AND (junior_species='peruviana' OR junior_species='peruviana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypocnemis' AND (species='peruviana' OR species='peruviana') 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='Phlegopsis' AND (junior_species='nigromaculata' OR junior_species='nigromaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phlegopsis' AND (species='nigromaculata' OR species='nigromaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phlegopsis' AND (species='nigromaculata' OR species='nigromaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phlegopsis' AND (junior_species='nigromaculata' OR junior_species='nigromaculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phlegopsis' AND (species='nigromaculata' OR species='nigromaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopithys' AND (junior_species='salvini' OR junior_species='salvinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnopithys' AND (species='salvini' OR species='salvinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnopithys' AND (species='salvini' OR species='salvinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnopithys' AND (junior_species='salvini' OR junior_species='salvinii')SELECT d.diet,d.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='salvini' OR species='salvinii') 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='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='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='Campylorhamphus' AND (junior_species='trochilirostris' OR junior_species='trochilirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campylorhamphus' AND (species='trochilirostris' OR species='trochilirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campylorhamphus' AND (species='trochilirostris' OR species='trochilirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campylorhamphus' AND (junior_species='trochilirostris' OR junior_species='trochilirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Campylorhamphus' AND (species='trochilirostris' OR species='trochilirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='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='Automolus' AND (junior_species='rufipileatus' OR junior_species='rufipileatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Automolus' AND (species='rufipileatus' OR species='rufipileatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Automolus' AND (species='rufipileatus' OR species='rufipileatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Automolus' AND (junior_species='rufipileatus' OR junior_species='rufipileatus')SELECT d.diet,d.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='rufipileatus' OR species='rufipileatus') 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='Anabacerthia' AND (junior_species='ruficaudata' OR junior_species='ruficaudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anabacerthia' AND (species='ruficaudata' OR species='ruficaudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anabacerthia' AND (species='ruficaudata' OR species='ruficaudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anabacerthia' AND (junior_species='ruficaudata' OR junior_species='ruficaudata')SELECT d.diet,d.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='ruficaudata' OR species='ruficaudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='fasciicauda' OR junior_species='fasciicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipra' AND (species='fasciicauda' OR species='fasciicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipra' AND (species='fasciicauda' OR species='fasciicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipra' AND (junior_species='fasciicauda' OR junior_species='fasciicauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pipra' AND (species='fasciicauda' OR species='fasciicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratopipra' AND (junior_species='rubrocapilla' OR junior_species='rubrocapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratopipra' AND (species='rubrocapilla' OR species='rubrocapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratopipra' AND (species='rubrocapilla' OR species='rubrocapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratopipra' AND (junior_species='rubrocapilla' OR junior_species='rubrocapilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceratopipra' AND (species='rubrocapilla' OR species='rubrocapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidothrix' 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='Lepidothrix' AND (species='coronata' OR species='coronata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidothrix' AND (species='coronata' OR species='coronata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidothrix' 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='Lepidothrix' AND (species='coronata' OR species='coronata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaeropterus' AND (junior_species='pyrocephalus' OR junior_species='pyrocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machaeropterus' AND (species='pyrocephalus' OR species='pyrocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machaeropterus' AND (species='pyrocephalus' OR species='pyrocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaeropterus' AND (junior_species='pyrocephalus' OR junior_species='pyrocephalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Machaeropterus' AND (species='pyrocephalus' OR species='pyrocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='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='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='Hemitriccus' AND (junior_species='flammulatus' OR junior_species='flammulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemitriccus' AND (species='flammulatus' OR species='flammulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemitriccus' AND (species='flammulatus' OR species='flammulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemitriccus' AND (junior_species='flammulatus' OR junior_species='flammulatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemitriccus' AND (species='flammulatus' OR species='flammulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophotriccus' AND (junior_species='eulophotes' OR junior_species='eulophotes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophotriccus' AND (species='eulophotes' OR species='eulophotes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophotriccus' AND (species='eulophotes' OR species='eulophotes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophotriccus' AND (junior_species='eulophotes' OR junior_species='eulophotes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lophotriccus' AND (species='eulophotes' OR species='eulophotes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiothlypis' AND (junior_species='fulvicauda' OR junior_species='fulvicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiothlypis' AND (species='fulvicauda' OR species='fulvicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiothlypis' AND (species='fulvicauda' OR species='fulvicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiothlypis' AND (junior_species='fulvicauda' OR junior_species='fulvicauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiothlypis' AND (species='fulvicauda' OR species='fulvicauda') 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 * FROM register WHERE sample_no=3035 The Ecological Register: AC2
AC2
Basic information
Sample name: AC2

Reference: T. L. da Silva, E. L. Marques, and E. Guilherme. 2015. Recuperation of the terra firme forest understory bird fauna eight years after a wildfire in eastern Acre, Brazil. International Journal of Ecology 2015(324048):1-12 [ER 2800]
Geography
Country: Brazil

State: Acre


Coordinate: 9° 45' 40" S, 67° 39' 53" W
Coordinate basis: stated in text

Geography comments: "in eastern Acre"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: fragment

Protection: unprotected

Substrate: ground surface

MAT: 26.0

MAP: 1875.0

Habitat comments: "humid equatorial... The driest month is June, with rainfall of 32 mm, while the wettest is February, at 299 mm... The study fragments are composed of open rainforest with a predominance of bamboo set in a matrix of cattle pasture" and this fragment is 1700 ha
MAP 1750 to 2000

Methods
Life forms: birds

Sampling methods: line transect,mist nets

Sample size: 102 individuals

Years: 2013

Days: 4

Seasons: dry

Nets or traps: 20

Net or trap nights: 80

Sampling comments: "The bird fauna was surveyed in the dry season, between April and November 2013, using 20 mist nets (12 m x 2.5 m; 36 mm mesh), set along trails of 120 m in length. Four transects were established within each burned site and four at each control site. The transects were 500 m apart and were located at least 50 m from the forest margin, in order to avoid possible edge effects. The nets were set between 06:30 h and 13:30 h on two consecutive days... A standard sampling effort of 560 net hours was implemented at each site. The birds captured were identified to species and marked with metallic bands" (560 net hours / 7 hours = 80 net days)
counts are of individuals

Metadata
Sample number: 3035

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-07-07 16:14:46

Modified: 2020-06-05 09:20:49

Abundance distribution
47 species
25 singletons
total count 102
extrapolated richness: 158.4
Fisher's α: 33.790
geometric series k: 0.9492
Hurlbert's PIE: 0.9600
Shannon's H: 3.5517
Good's u: 0.7568
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Threnetes leucurus1 nectarivore
Phaethornis ruber12.4 g nectarivore
Phaethornis hispidus35.0 g nectarivore
Phaethornis malaris35.9 g nectarivore
Thalurania furcata22.0 g nectarivore-insectivore
Electron platyrhynchum173.0 g frugivore-insectivore
Monasa nigrifrons180.7 g insectivore
Monasa morphoeus18.5 g carnivore-insectivore
Veniliornis affinis136.0 g insectivore
Veniliornis passerinus132.1 g insectivore
Micrastur ruficollis1161 g carnivore-insectivore
Microrhopias quixensis17.9 g insectivore
Epinecrophylla ornata1 insectivore
Myrmotherula axillaris52.8 g frugivore-insectivore
Isleria hauxwelli2
Thamnomanes schistogynus317.2 g
Thamnophilus schistaceus120.3 g frugivore-insectivore
Thamnophilus aethiops325.7 g frugivore-insectivore
Sclateria naevia124.6 g insectivore
Myrmoborus myotherinus318.8 g insectivore
Sciaphylax hemimelaena9 insectivore
Hypocnemis subflava1 insectivore
Hypocnemis peruviana1
Willisornis poecilinotus2 insectivore
Phlegopsis nigromaculata46.8 g insectivore
Gymnopithys salvini525.9 g
Formicarius colma147.0 g insectivore
Sclerurus caudacutus16.1 g insectivore
Dendrocincla fuliginosa238.7 g insectivore
Dendrocincla merula53.8 g insectivore
Campylorhamphus trochilirostris140.8 g insectivore
Xenops minutus210.6 g frugivore-insectivore
Myrmothera campanisona147.0 g insectivore
Automolus rufipileatus234.8 g insectivore
Automolus ochrolaemus340.2 g insectivore
Anabacerthia ruficaudata1 insectivore
Pipra fasciicauda1115.9 g frugivore
Ceratopipra rubrocapilla2 frugivore
Lepidothrix coronata2 frugivore
Machaeropterus pyrocephalus29.7 g insectivore
Piprites chloris116.0 g insectivore
Mionectes oleagineus12.3 g insectivore-frugivore
Leptopogon amaurocephalus111.7 g insectivore-frugivore
Hemitriccus flammulatus210.0 g insectivore
Lophotriccus eulophotes16.0 g insectivore
Myiothlypis fulvicauda1 insectivore
Habia rubica134.0 g insectivore-frugivore