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=1702 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1702SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1172SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1702 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='syrmatophorus' OR junior_species='syrmatophorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaethornis' AND (species='syrmatophorus' OR species='syrmatophorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaethornis' AND (species='syrmatophorus' OR species='syrmatophorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaethornis' AND (junior_species='syrmatophorus' OR junior_species='syrmatophorus')SELECT d.diet,d.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='syrmatophorus' OR species='syrmatophorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doryfera' AND (junior_species='ludovicae' OR junior_species='ludovicae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Doryfera' AND (species='ludovicae' OR species='ludovicae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Doryfera' AND (species='ludovicae' OR species='ludovicae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Doryfera' AND (junior_species='ludovicae' OR junior_species='ludovicae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Doryfera' AND (species='ludovicae' OR species='ludovicae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colibri' AND (junior_species='thalassinus' OR junior_species='thalassinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colibri' AND (species='thalassinus' OR species='thalassinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colibri' AND (species='thalassinus' OR species='thalassinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colibri' AND (junior_species='thalassinus' OR junior_species='thalassinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colibri' AND (species='thalassinus' OR species='thalassinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliangelus' AND (junior_species='exortis' OR junior_species='exortis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliangelus' AND (species='exortis' OR species='exortis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliangelus' AND (species='exortis' OR species='exortis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliangelus' AND (junior_species='exortis' OR junior_species='exortis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heliangelus' AND (species='exortis' OR species='exortis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyia' AND (junior_species='melanogenys' OR junior_species='melanogenys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Adelomyia' AND (species='melanogenys' OR species='melanogenys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyia' AND (species='melanogenys' OR species='melanogenys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyia' AND (junior_species='melanogenys' OR junior_species='melanogenys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Adelomyia' AND (species='melanogenys' OR species='melanogenys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocnemis' AND (junior_species='derbyi' OR junior_species='derbyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eriocnemis' AND (species='derbyi' OR species='derbyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriocnemis' AND (species='derbyi' OR species='derbyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocnemis' AND (junior_species='derbyi' OR junior_species='derbyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eriocnemis' AND (species='derbyi' OR species='derbyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeligena' AND (junior_species='torquata' OR junior_species='torquata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeligena' AND (species='torquata' OR species='torquata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeligena' AND (species='torquata' OR species='torquata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeligena' AND (junior_species='torquata' OR junior_species='torquata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coeligena' AND (species='torquata' OR species='torquata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lafresnaya' AND (junior_species='lafresnayi' OR junior_species='lafresnayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lafresnaya' AND (species='lafresnayi' OR species='lafresnayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lafresnaya' AND (species='lafresnayi' OR species='lafresnayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lafresnaya' AND (junior_species='lafresnayi' OR junior_species='lafresnayii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lafresnaya' AND (species='lafresnayi' OR species='lafresnayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ensifera' AND (junior_species='ensifera' OR junior_species='ensifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ensifera' AND (species='ensifera' OR species='ensifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ensifera' AND (species='ensifera' OR species='ensifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ensifera' AND (junior_species='ensifera' OR junior_species='ensifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ensifera' AND (species='ensifera' OR species='ensifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boissonneaua' 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='Boissonneaua' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boissonneaua' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boissonneaua' 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='Boissonneaua' AND (species='flavescens' OR species='flavescens') 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='Trogon' AND (junior_species='personatus' OR junior_species='personatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trogon' AND (species='personatus' OR species='personatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trogon' AND (species='personatus' OR species='personatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trogon' AND (junior_species='personatus' OR junior_species='personatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trogon' AND (species='personatus' OR species='personatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulacorhynchus' AND (junior_species='prasinus' OR junior_species='prasinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aulacorhynchus' AND (species='prasinus' OR species='prasinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aulacorhynchus' AND (species='prasinus' OR species='prasinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aulacorhynchus' AND (junior_species='prasinus' OR junior_species='prasinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aulacorhynchus' AND (species='prasinus' OR species='prasinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zimmerius' AND (junior_species='chrysops' OR junior_species='chrysops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zimmerius' AND (species='chrysops' OR species='chrysops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zimmerius' AND (species='chrysops' OR species='chrysops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zimmerius' AND (junior_species='chrysops' OR junior_species='chrysops')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zimmerius' AND (species='chrysops' OR species='chrysops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipreola' AND (junior_species='riefferii' OR junior_species='riefferi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipreola' AND (species='riefferii' OR species='riefferi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipreola' AND (species='riefferii' OR species='riefferi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipreola' AND (junior_species='riefferii' OR junior_species='riefferi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pipreola' AND (species='riefferii' OR species='riefferi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipreola' AND (junior_species='arcuata' OR junior_species='arcuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipreola' AND (species='arcuata' OR species='arcuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pipreola' AND (species='arcuata' OR species='arcuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipreola' AND (junior_species='arcuata' OR junior_species='arcuata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pipreola' AND (species='arcuata' OR species='arcuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myadestes' AND (junior_species='ralloides' OR junior_species='ralloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myadestes' AND (species='ralloides' OR species='ralloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myadestes' AND (species='ralloides' OR species='ralloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myadestes' AND (junior_species='ralloides' OR junior_species='ralloides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myadestes' AND (species='ralloides' OR species='ralloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='fuscater' OR junior_species='fuscater')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='fuscater' OR species='fuscater') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='fuscater' OR species='fuscater')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='fuscater' OR junior_species='fuscater')SELECT d.diet,d.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='fuscater' OR species='fuscater') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='serranus' OR junior_species='serranus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='serranus' OR species='serranus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='serranus' OR species='serranus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='serranus' OR junior_species='serranus')SELECT d.diet,d.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='serranus' OR species='serranus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemispingus' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemispingus' AND (species='frontalis' OR species='frontalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemispingus' AND (species='frontalis' OR species='frontalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemispingus' AND (junior_species='frontalis' OR junior_species='frontalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemispingus' AND (species='frontalis' OR species='frontalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='cyanocephala' OR junior_species='cyanocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thraupis' AND (species='cyanocephala' OR species='cyanocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thraupis' AND (species='cyanocephala' OR species='cyanocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thraupis' AND (junior_species='cyanocephala' OR junior_species='cyanocephala')SELECT d.diet,d.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='cyanocephala' OR species='cyanocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisognathus' AND (junior_species='lacrymosus' OR junior_species='lacrymosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisognathus' AND (species='lacrymosus' OR species='lacrymosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisognathus' AND (species='lacrymosus' OR species='lacrymosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisognathus' AND (junior_species='lacrymosus' OR junior_species='lacrymosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anisognathus' AND (species='lacrymosus' OR species='lacrymosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisognathus' AND (junior_species='somptuosus' OR junior_species='somptuosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisognathus' AND (species='somptuosus' OR species='somptuosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisognathus' AND (species='somptuosus' OR species='somptuosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisognathus' AND (junior_species='somptuosus' OR junior_species='somptuosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anisognathus' AND (species='somptuosus' OR species='somptuosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='vassorii' OR junior_species='vassori')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='vassorii' OR species='vassori') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='vassorii' OR species='vassori')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='vassorii' OR junior_species='vassori')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tangara' AND (species='vassorii' OR species='vassori') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='nigroviridis' OR junior_species='nigroviridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tangara' AND (species='nigroviridis' OR species='nigroviridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tangara' AND (species='nigroviridis' OR species='nigroviridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tangara' AND (junior_species='nigroviridis' OR junior_species='nigroviridis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tangara' AND (species='nigroviridis' OR species='nigroviridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='albilatera' OR junior_species='albilatera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossa' AND (species='albilatera' OR species='albilatera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossa' AND (species='albilatera' OR species='albilatera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='albilatera' OR junior_species='albilatera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diglossa' AND (species='albilatera' OR species='albilatera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='cyanea' OR junior_species='cyanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossa' AND (species='cyanea' OR species='cyanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossa' AND (species='cyanea' OR species='cyanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='cyanea' OR junior_species='cyanea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diglossa' AND (species='cyanea' OR species='cyanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catamenia' AND (junior_species='homochroa' OR junior_species='homochroa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catamenia' AND (species='homochroa' OR species='homochroa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catamenia' AND (species='homochroa' OR species='homochroa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catamenia' AND (junior_species='homochroa' OR junior_species='homochroa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catamenia' AND (species='homochroa' OR species='homochroa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='brunneinucha' OR junior_species='brunneinucha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arremon' AND (species='brunneinucha' OR species='brunneinucha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremon' AND (species='brunneinucha' OR species='brunneinucha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='brunneinucha' OR junior_species='brunneinucha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arremon' AND (species='brunneinucha' OR species='brunneinucha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arremon' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arremon' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arremon' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arremon' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' AND (junior_species='albinucha' OR junior_species='albinucha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atlapetes' AND (species='albinucha' OR species='albinucha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atlapetes' AND (species='albinucha' OR species='albinucha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' AND (junior_species='albinucha' OR junior_species='albinucha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Atlapetes' AND (species='albinucha' OR species='albinucha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' 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='Atlapetes' AND (species='schistaceus' OR species='schistaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atlapetes' AND (species='schistaceus' OR species='schistaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' 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='Atlapetes' AND (species='schistaceus' OR species='schistaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='flava' OR junior_species='flava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piranga' AND (species='flava' OR species='flava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piranga' AND (species='flava' OR species='flava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piranga' AND (junior_species='flava' OR junior_species='flava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Piranga' AND (species='flava' OR species='flava') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1702 The Ecological Register: Reserva Forestal Protectora Bosques de la CHEC (plantación de aliso)
Reserva Forestal Protectora Bosques de la CHEC (plantación de aliso)
Basic information
Sample name: Reserva Forestal Protectora Bosques de la CHEC (plantación de aliso)

Reference: L. F. Salazar-Ramírez, D. M. Pineda-Gómez, J. V. E. Varón, and G. J. Castaño-Villa. 2014. Riqueza y abundancia de aves frugívoras y nectarívoras en una plantación de aliso (Alnus acuminata) y un bosque secundario en los Andes centrales de Colombia. Boletin Cientifico del Centro de Museos 18(1):67-77 [ER 1172]
Geography
Country: Colombia


Coordinate: 5° 1' N, 75° 24' W
Coordinate basis: stated in text

Geography comments: "parte de la cuenca alta y media del río Chinchinâ, departamento de Caldas"
elevation 2400 to 3800 m

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: plantation

Protection: forest reserve

Substrate: ground surface

MAT: 13.0

MAP: 2500.0

Habitat comments: "en cuatro rodales de plantación de aliso"

Methods
Life forms: birds

Sites: 8

Sampling methods: no design,mist nets

Sample size: 193 individuals

Years: 2008, 2009

Nets or traps: 8

Net or trap nights: 285

Sampling comments: "En cada punto de captura se extendieron en línea cuatro redes de neblina (12 m x 2,5 m x 36 mm) durante 56 horas por mes (entre las 0600 y 1700 h), para un esfuerzo total de muestreo de 3.136 horas red-1 en cada hâbitat" (i.e., eight nets used once a month over seven months for 56 hours a month = about 285 net days)

Metadata
Sample number: 1702

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-07-09 16:09:52

Modified: 2015-07-09 06:09:52

Abundance distribution
33 species
12 singletons
total count 193
extrapolated richness: 69.7
Fisher's α: 11.449
geometric series k: 0.8849
Hurlbert's PIE: 0.8914
Shannon's H: 2.7611
Good's u: 0.9381
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Phaethornis syrmatophorus225.8 g nectarivore-insectivore
Doryfera ludovicae16.0 g nectarivore-insectivore
Colibri thalassinus25.9 g nectarivore-insectivore
Heliangelus exortis504.8 g nectarivore-insectivore
Adelomyia melanogenys212.3 g nectarivore-insectivore
Eriocnemis derbyi1
Coeligena torquata117.3 g nectarivore-insectivore
Lafresnaya lafresnayi25.3 g nectarivore-insectivore
Ensifera ensifera111.2 g nectarivore-insectivore
Boissonneaua flavescens38.2 g nectarivore-insectivore
Chlorostilbon mellisugus21.3 g nectarivore
Trogon personatus363.4 g frugivore-insectivore
Aulacorhynchus prasinus15.3 g granivore-frugivore
Zimmerius chrysops110.4 g frugivore
Pipreola riefferii149.3 g frugivore
Pipreola arcuata1118 g frugivore
Myadestes ralloides129.1 g frugivore
Turdus fuscater3143 g insectivore-frugivore
Turdus serranus184.9 g frugivore-insectivore
Hemispingus frontalis817.0 g frugivore-insectivore
Thraupis cyanocephala336.0 g frugivore-insectivore
Anisognathus lacrymosus231.0 g frugivore
Anisognathus somptuosus342.0 g frugivore-insectivore
Tangara vassorii918.0 g frugivore-insectivore
Tangara nigroviridis117.0 g frugivore-insectivore
Diglossa albilatera210.2 g frugivore-insectivore
Diglossa cyanea7 frugivore-insectivore
Catamenia homochroa112.2 g insectivore-frugivore
Arremon brunneinucha8
Arremon torquatus8
Atlapetes albinucha45.9 g frugivore-insectivore
Atlapetes schistaceus85.1 g
Piranga flava137.7 g frugivore-insectivore