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=1708 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1708SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1177SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1708 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' AND (junior_species='melacoryphus' OR junior_species='melacoryphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coccyzus' AND (species='melacoryphus' OR species='melacoryphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coccyzus' AND (species='melacoryphus' OR species='melacoryphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coccyzus' AND (junior_species='melacoryphus' OR junior_species='melacoryphus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coccyzus' AND (species='melacoryphus' OR species='melacoryphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysolampis' AND (junior_species='mosquitus' OR junior_species='mosquitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysolampis' AND (species='mosquitus' OR species='mosquitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysolampis' AND (species='mosquitus' OR species='mosquitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysolampis' AND (junior_species='mosquitus' OR junior_species='mosquitus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysolampis' AND (species='mosquitus' OR species='mosquitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorostilbon' AND (junior_species='mellisugus' OR junior_species='mellisugus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorostilbon' AND (species='mellisugus' OR species='mellisugus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorostilbon' AND (species='mellisugus' OR species='mellisugus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorostilbon' AND (junior_species='mellisugus' OR junior_species='mellisugus')SELECT d.diet,d.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='mellisugus' OR species='mellisugus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucippus' AND (junior_species='fallax' OR junior_species='fallax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucippus' AND (species='fallax' OR species='fallax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucippus' AND (species='fallax' OR species='fallax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucippus' AND (junior_species='fallax' OR junior_species='fallax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leucippus' AND (species='fallax' OR species='fallax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='tobaci' OR junior_species='tobacii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amazilia' AND (species='tobaci' OR species='tobacii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amazilia' AND (species='tobaci' OR species='tobacii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amazilia' AND (junior_species='tobaci' OR junior_species='tobacii')SELECT d.diet,d.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='tobaci' OR species='tobacii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galbula' AND (junior_species='ruficauda' OR junior_species='ruficauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galbula' AND (species='ruficauda' OR species='ruficauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galbula' AND (species='ruficauda' OR species='ruficauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galbula' AND (junior_species='ruficauda' OR junior_species='ruficauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Galbula' AND (species='ruficauda' OR species='ruficauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypnelus' 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='Hypnelus' AND (species='ruficollis' OR species='ruficollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypnelus' AND (species='ruficollis' OR species='ruficollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypnelus' 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='Hypnelus' AND (species='ruficollis' OR species='ruficollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanerpes' AND (junior_species='rubricapillus' OR junior_species='rubricapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanerpes' AND (species='rubricapillus' OR species='rubricapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanerpes' AND (species='rubricapillus' OR species='rubricapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanerpes' AND (junior_species='rubricapillus' OR junior_species='rubricapillus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanerpes' AND (species='rubricapillus' OR species='rubricapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendroplex' AND (junior_species='picus' OR junior_species='picus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendroplex' AND (species='picus' OR species='picus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendroplex' AND (species='picus' OR species='picus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendroplex' AND (junior_species='picus' OR junior_species='picus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendroplex' AND (species='picus' OR species='picus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Thamnophilus' AND (junior_species='doliatus' OR junior_species='doliatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thamnophilus' AND (species='doliatus' OR species='doliatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thamnophilus' AND (species='doliatus' OR species='doliatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thamnophilus' AND (junior_species='doliatus' OR junior_species='doliatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thamnophilus' AND (species='doliatus' OR species='doliatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicivora' AND (junior_species='grisea' OR junior_species='grisea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Formicivora' AND (species='grisea' OR species='grisea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Formicivora' AND (species='grisea' OR species='grisea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Formicivora' AND (junior_species='grisea' OR junior_species='grisea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Formicivora' AND (species='grisea' OR species='grisea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camptostoma' AND (junior_species='obsoletum' OR junior_species='obsoletum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camptostoma' AND (species='obsoletum' OR species='obsoletum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camptostoma' AND (species='obsoletum' OR species='obsoletum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camptostoma' AND (junior_species='obsoletum' OR junior_species='obsoletum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camptostoma' AND (species='obsoletum' OR species='obsoletum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tyrannulus' OR junior_species='tyrannulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiarchus' AND (junior_species='tyrannulus' OR junior_species='tyrannulus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiarchus' AND (species='tyrannulus' OR species='tyrannulus') 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='Idioptilon' AND (junior_species='margaritaceiventris' OR junior_species='margaritaceiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idioptilon' AND (species='margaritaceiventris' OR species='margaritaceiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idioptilon' AND (species='margaritaceiventris' OR species='margaritaceiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idioptilon' AND (junior_species='margaritaceiventris' OR junior_species='margaritaceiventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Idioptilon' AND (species='margaritaceiventris' OR species='margaritaceiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atalotriccus' AND (junior_species='pilaris' OR junior_species='pilaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atalotriccus' AND (species='pilaris' OR species='pilaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atalotriccus' AND (species='pilaris' OR species='pilaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atalotriccus' AND (junior_species='pilaris' OR junior_species='pilaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Atalotriccus' AND (species='pilaris' OR species='pilaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euscarthmus' AND (junior_species='meloryphus' OR junior_species='meloryphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euscarthmus' AND (species='meloryphus' OR species='meloryphus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euscarthmus' AND (species='meloryphus' OR species='meloryphus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euscarthmus' AND (junior_species='meloryphus' OR junior_species='meloryphus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euscarthmus' AND (species='meloryphus' OR species='meloryphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='parvirostris' OR junior_species='parvirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='parvirostris' OR species='parvirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='parvirostris' OR species='parvirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='parvirostris' OR junior_species='parvirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaenia' AND (species='parvirostris' OR species='parvirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='strepera' OR junior_species='strepera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaenia' AND (species='strepera' OR species='strepera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elaenia' AND (species='strepera' OR species='strepera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaenia' AND (junior_species='strepera' OR junior_species='strepera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Elaenia' AND (species='strepera' OR species='strepera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiopagis' AND (junior_species='viridicata' OR junior_species='viridicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myiopagis' AND (species='viridicata' OR species='viridicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myiopagis' AND (species='viridicata' OR species='viridicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myiopagis' AND (junior_species='viridicata' OR junior_species='viridicata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myiopagis' AND (species='viridicata' OR species='viridicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sublegatus' AND (junior_species='modestus' OR junior_species='modestus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sublegatus' AND (species='modestus' OR species='modestus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sublegatus' AND (species='modestus' OR species='modestus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sublegatus' AND (junior_species='modestus' OR junior_species='modestus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sublegatus' AND (species='modestus' OR species='modestus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeomyias' AND (junior_species='murina' OR junior_species='murina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaeomyias' AND (species='murina' OR species='murina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaeomyias' AND (species='murina' OR species='murina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaeomyias' AND (junior_species='murina' OR junior_species='murina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phaeomyias' AND (species='murina' OR species='murina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='aedon' OR junior_species='aedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Troglodytes' AND (species='aedon' OR species='aedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Troglodytes' AND (species='aedon' OR species='aedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Troglodytes' AND (junior_species='aedon' OR junior_species='aedon')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Troglodytes' AND (species='aedon' OR species='aedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimus' AND (junior_species='gilvus' OR junior_species='gilvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimus' AND (species='gilvus' OR species='gilvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimus' AND (species='gilvus' OR species='gilvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimus' AND (junior_species='gilvus' OR junior_species='gilvus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mimus' AND (species='gilvus' OR species='gilvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polioptila' AND (junior_species='plumbea' OR junior_species='plumbea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polioptila' AND (species='plumbea' OR species='plumbea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polioptila' AND (species='plumbea' OR species='plumbea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polioptila' AND (junior_species='plumbea' OR junior_species='plumbea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polioptila' AND (species='plumbea' OR species='plumbea') 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='Hylophilus' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylophilus' AND (species='flavipes' OR species='flavipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylophilus' AND (species='flavipes' OR species='flavipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylophilus' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hylophilus' AND (species='flavipes' OR species='flavipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icterus' AND (junior_species='nigrogularis' OR junior_species='nigrogularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Icterus' AND (species='nigrogularis' OR species='nigrogularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Icterus' AND (species='nigrogularis' OR species='nigrogularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Icterus' AND (junior_species='nigrogularis' OR junior_species='nigrogularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Icterus' AND (species='nigrogularis' OR species='nigrogularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parula' AND (junior_species='pitiayumi' OR junior_species='pitiayumii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parula' AND (species='pitiayumi' OR species='pitiayumii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parula' AND (species='pitiayumi' OR species='pitiayumii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parula' AND (junior_species='pitiayumi' OR junior_species='pitiayumii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parula' AND (species='pitiayumi' OR species='pitiayumii') 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='Euphonia' AND (junior_species='trinitatis' OR junior_species='trinitatis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphonia' AND (species='trinitatis' OR species='trinitatis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphonia' AND (species='trinitatis' OR species='trinitatis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphonia' AND (junior_species='trinitatis' OR junior_species='trinitatis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphonia' AND (species='trinitatis' OR species='trinitatis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='glaucocolpa' OR junior_species='glaucocolpa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thraupis' AND (species='glaucocolpa' OR species='glaucocolpa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thraupis' AND (species='glaucocolpa' OR species='glaucocolpa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='glaucocolpa' OR junior_species='glaucocolpa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thraupis' AND (species='glaucocolpa' OR species='glaucocolpa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='rufus' OR junior_species='rufus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyphonus' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyphonus' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyphonus' AND (junior_species='rufus' OR junior_species='rufus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tachyphonus' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='coerulescens' OR junior_species='coerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saltator' AND (species='coerulescens' OR species='coerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saltator' AND (species='coerulescens' OR species='coerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saltator' AND (junior_species='coerulescens' OR junior_species='coerulescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Saltator' AND (species='coerulescens' OR species='coerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardinalis' AND (junior_species='phoenicius' OR junior_species='phoenicius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cardinalis' AND (species='phoenicius' OR species='phoenicius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cardinalis' AND (species='phoenicius' OR species='phoenicius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cardinalis' AND (junior_species='phoenicius' OR junior_species='phoenicius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cardinalis' AND (species='phoenicius' OR species='phoenicius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryphospingus' AND (junior_species='pileatus' OR junior_species='pileatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coryphospingus' AND (species='pileatus' OR species='pileatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coryphospingus' AND (species='pileatus' OR species='pileatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coryphospingus' AND (junior_species='pileatus' OR junior_species='pileatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coryphospingus' AND (species='pileatus' OR species='pileatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiaris' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiaris' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiaris' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiaris' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tiaris' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='lineola' OR junior_species='lineola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sporophila' AND (species='lineola' OR species='lineola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sporophila' AND (species='lineola' OR species='lineola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sporophila' AND (junior_species='lineola' OR junior_species='lineola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sporophila' AND (species='lineola' OR species='lineola') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1708 The Ecological Register: Araya Peninsula (tropical thorn scrub)
Araya Peninsula (tropical thorn scrub)
Basic information
Sample name: Araya Peninsula (tropical thorn scrub)

Reference: B. Poulin, G. Lefebvre, and R. McNeil. 1993. Variations in bird abundance in tropical arid and semi-arid habitats. Ibis 135:432-441 [ER 1177]
Geography
Country: Venezuela

State: Sucre


Coordinate: 10° 39' N, 63° 42' W
Geography comments: "in the Guarapo region" (not clear what this means as there is no such place name)

•
Environment
Habitat: desert/xeric shrubland

Substrate: ground surface

MAT: 27.3

MAP: 430.0

Habitat comments: there is a "dry season from late November to mid-May"
MAP is stated on text; MAT is based on Pérez-Sânchez et al. (2013)

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 1386 individuals

Years: 1986, 1987

Days: 24

Nets or traps: 12

Net or trap nights: 288

Sampling comments: "12 mist-nets (3 x 14m, 32 mm mesh) were operated 5O m apart on a 3x 4 grid, for a 4-h period beginning at dawn twice monthly" over 12 months

Metadata
Sample number: 1708

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-09 21:02:39

Modified: 2015-09-27 07:36:10

Abundance distribution
39 species
9 singletons
total count 1386
extrapolated richness: 60.2
Fisher's α: 7.456
geometric series k: 0.8630
Hurlbert's PIE: 0.9063
Shannon's H: 2.7136
Good's u: 0.9935
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Coccyzus melacoryphus345.6 g frugivore-insectivore
Chrysolampis mosquitus23.9 g
Chlorostilbon mellisugus91.3 g nectarivore
Leucippus fallax436.0 g
Amazilia tobaci3 nectarivore-insectivore
Galbula ruficauda126.5 g insectivore
Hypnelus ruficollis349.8 g omnivore
Melanerpes rubricapillus555.9 g frugivore-insectivore
Dendroplex picus18 insectivore
"Xiphorhynchus picus"
Campylorhamphus trochilirostris140.8 g insectivore
Thamnophilus doliatus155.1 g insectivore
Formicivora grisea752.2 g insectivore
Camptostoma obsoletum28.1 g frugivore-insectivore
Myiarchus tyrannulus175.4 g insectivore-frugivore
Cnemotriccus fuscatus113.6 g insectivore
Idioptilon margaritaceiventris2
Atalotriccus pilaris21 insectivore
Euscarthmus meloryphus26.8 g insectivore
Elaenia parvirostris2813.8 g frugivore-insectivore
Elaenia strepera119.3 g insectivore-frugivore
Myiopagis viridicata12.3 g insectivore
Sublegatus modestus9814.0 g insectivore
Phaeomyias murina11910.0 g insectivore
Troglodytes aedon11.8 g insectivore
Mimus gilvus1476.8 g insectivore-frugivore
Polioptila plumbea446.1 g insectivore
Vireo olivaceus182.6 g insectivore-frugivore
Hylophilus flavipes733.3 g frugivore
Icterus nigrogularis140.2 g
Parula pitiayumi12.6 g insectivore
Coereba flaveola2701.3 g frugivore-insectivore
Euphonia trinitatis111.0 g frugivore
Thraupis glaucocolpa6831.6 g frugivore
Tachyphonus rufus1834.4 g frugivore-insectivore
Saltator coerulescens354.9 g insectivore-frugivore
Cardinalis phoenicius70
Coryphospingus pileatus1415.3 g granivore
Tiaris 'bicolor'185
Sporophila lineola29.8 g granivore