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=1144 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1144SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=797SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1144 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='striatus' OR junior_species='striatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Accipiter' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeligena' AND (junior_species='helianthea' OR junior_species='helianthea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeligena' AND (species='helianthea' OR species='helianthea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeligena' AND (species='helianthea' OR species='helianthea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeligena' AND (junior_species='helianthea' OR junior_species='helianthea')SELECT d.diet,d.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='helianthea' OR species='helianthea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocnemis' AND (junior_species='cupreoventris' OR junior_species='cupreoventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eriocnemis' AND (species='cupreoventris' OR species='cupreoventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriocnemis' AND (species='cupreoventris' OR species='cupreoventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocnemis' AND (junior_species='cupreoventris' OR junior_species='cupreoventris')SELECT d.diet,d.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='cupreoventris' OR species='cupreoventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocnemis' AND (junior_species='vestitus' OR junior_species='vestitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eriocnemis' AND (species='vestitus' OR species='vestitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriocnemis' AND (species='vestitus' OR species='vestitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriocnemis' AND (junior_species='vestitus' OR junior_species='vestitus')SELECT d.diet,d.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='vestitus' OR species='vestitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metallura' AND (junior_species='tyrianthina' OR junior_species='tyrianthina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metallura' AND (species='tyrianthina' OR species='tyrianthina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metallura' AND (species='tyrianthina' OR species='tyrianthina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metallura' AND (junior_species='tyrianthina' OR junior_species='tyrianthina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Metallura' AND (species='tyrianthina' OR species='tyrianthina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opisthoprora' AND (junior_species='euryptera' OR junior_species='euryptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Opisthoprora' AND (species='euryptera' OR species='euryptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Opisthoprora' AND (species='euryptera' OR species='euryptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Opisthoprora' AND (junior_species='euryptera' OR junior_species='euryptera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Opisthoprora' AND (species='euryptera' OR species='euryptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxypogon' AND (junior_species='guerinii' OR junior_species='guerini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxypogon' AND (species='guerinii' OR species='guerini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxypogon' AND (species='guerinii' OR species='guerini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxypogon' AND (junior_species='guerinii' OR junior_species='guerini')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxypogon' AND (species='guerinii' OR species='guerini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterophanes' AND (junior_species='cyanopterus' OR junior_species='cyanopterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterophanes' AND (species='cyanopterus' OR species='cyanopterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterophanes' AND (species='cyanopterus' OR species='cyanopterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterophanes' AND (junior_species='cyanopterus' OR junior_species='cyanopterus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterophanes' AND (species='cyanopterus' OR species='cyanopterus') 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='Piculus' AND (junior_species='rivolii' OR junior_species='rivoli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piculus' AND (species='rivolii' OR species='rivoli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piculus' AND (species='rivolii' OR species='rivoli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piculus' AND (junior_species='rivolii' OR junior_species='rivoli')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Piculus' AND (species='rivolii' OR species='rivoli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margarornis' AND (junior_species='squamiger' OR junior_species='squamiger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Margarornis' AND (species='squamiger' OR species='squamiger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Margarornis' AND (species='squamiger' OR species='squamiger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Margarornis' AND (junior_species='squamiger' OR junior_species='squamiger')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Margarornis' AND (species='squamiger' OR species='squamiger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphocolaptes' AND (junior_species='promeropirhynchus' OR junior_species='promeropirhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xiphocolaptes' AND (species='promeropirhynchus' OR species='promeropirhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xiphocolaptes' AND (species='promeropirhynchus' OR species='promeropirhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xiphocolaptes' AND (junior_species='promeropirhynchus' OR junior_species='promeropirhynchus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xiphocolaptes' AND (species='promeropirhynchus' OR species='promeropirhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecocerculus' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mecocerculus' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mecocerculus' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecocerculus' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mecocerculus' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' AND (junior_species='diadema' OR junior_species='diadema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochthoeca' AND (species='diadema' OR species='diadema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochthoeca' AND (species='diadema' OR species='diadema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' AND (junior_species='diadema' OR junior_species='diadema')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ochthoeca' AND (species='diadema' OR species='diadema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochthoeca' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochthoeca' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochthoeca' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ochthoeca' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhomyias' AND (junior_species='cinnamomeus' OR junior_species='cinnamomeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrrhomyias' AND (species='cinnamomeus' OR species='cinnamomeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrrhomyias' AND (species='cinnamomeus' OR species='cinnamomeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrrhomyias' AND (junior_species='cinnamomeus' OR junior_species='cinnamomeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrrhomyias' AND (species='cinnamomeus' OR species='cinnamomeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiochelidon' 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='Notiochelidon' AND (species='murina' OR species='murina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiochelidon' AND (species='murina' OR species='murina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiochelidon' 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='Notiochelidon' AND (species='murina' OR species='murina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnycerthia' AND (junior_species='unirufa' OR junior_species='unirufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnycerthia' AND (species='unirufa' OR species='unirufa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnycerthia' AND (species='unirufa' OR species='unirufa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnycerthia' AND (junior_species='unirufa' OR junior_species='unirufa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cinnycerthia' AND (species='unirufa' OR species='unirufa') 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='Basileuterus' AND (junior_species='nigrocristatus' OR junior_species='nigrocristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basileuterus' AND (species='nigrocristatus' OR species='nigrocristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basileuterus' AND (species='nigrocristatus' OR species='nigrocristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basileuterus' AND (junior_species='nigrocristatus' OR junior_species='nigrocristatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Basileuterus' AND (species='nigrocristatus' OR species='nigrocristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myioborus' AND (junior_species='ornatus' OR junior_species='ornatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myioborus' AND (species='ornatus' OR species='ornatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myioborus' AND (species='ornatus' OR species='ornatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myioborus' AND (junior_species='ornatus' OR junior_species='ornatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myioborus' AND (species='ornatus' OR species='ornatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisognathus' AND (junior_species='igniventris' OR junior_species='igniventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisognathus' AND (species='igniventris' OR species='igniventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anisognathus' AND (species='igniventris' OR species='igniventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anisognathus' AND (junior_species='igniventris' OR junior_species='igniventris')SELECT d.diet,d.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='igniventris' OR species='igniventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buthraupis' AND (junior_species='montana' OR junior_species='montana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buthraupis' AND (species='montana' OR species='montana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buthraupis' AND (species='montana' OR species='montana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buthraupis' AND (junior_species='montana' OR junior_species='montana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Buthraupis' AND (species='montana' OR species='montana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conirostrum' AND (junior_species='rufum' OR junior_species='rufum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conirostrum' AND (species='rufum' OR species='rufum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conirostrum' AND (species='rufum' OR species='rufum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conirostrum' AND (junior_species='rufum' OR junior_species='rufum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conirostrum' AND (species='rufum' OR species='rufum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conirostrum' AND (junior_species='sitticolor' OR junior_species='sitticolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conirostrum' AND (species='sitticolor' OR species='sitticolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conirostrum' AND (species='sitticolor' OR species='sitticolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conirostrum' AND (junior_species='sitticolor' OR junior_species='sitticolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conirostrum' AND (species='sitticolor' OR species='sitticolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='humeralis' OR junior_species='humeralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossa' AND (species='humeralis' OR species='humeralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossa' AND (species='humeralis' OR species='humeralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='humeralis' OR junior_species='humeralis')SELECT d.diet,d.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='humeralis' OR species='humeralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='lafresnayii' OR junior_species='lafresnayi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossa' AND (species='lafresnayii' OR species='lafresnayi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossa' AND (species='lafresnayii' OR species='lafresnayi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossa' AND (junior_species='lafresnayii' OR junior_species='lafresnayi')SELECT d.diet,d.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='lafresnayii' OR species='lafresnayi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossopis' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diglossopis' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossopis' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossopis' AND (junior_species='caerulescens' OR junior_species='caerulescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diglossopis' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossopis' 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='Diglossopis' AND (species='cyanea' OR species='cyanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diglossopis' AND (species='cyanea' OR species='cyanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diglossopis' 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='Diglossopis' AND (species='cyanea' OR species='cyanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dubusia' AND (junior_species='taeniata' OR junior_species='taeniata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dubusia' AND (species='taeniata' OR species='taeniata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dubusia' AND (species='taeniata' OR species='taeniata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dubusia' AND (junior_species='taeniata' OR junior_species='taeniata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dubusia' AND (species='taeniata' OR species='taeniata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemispingus' AND (junior_species='verticalis' OR junior_species='verticalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemispingus' AND (species='verticalis' OR species='verticalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemispingus' AND (species='verticalis' OR species='verticalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemispingus' AND (junior_species='verticalis' OR junior_species='verticalis')SELECT d.diet,d.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='verticalis' OR species='verticalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iridosornis' AND (junior_species='rufivertex' OR junior_species='rufivertex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iridosornis' AND (species='rufivertex' OR species='rufivertex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iridosornis' AND (species='rufivertex' OR species='rufivertex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iridosornis' AND (junior_species='rufivertex' OR junior_species='rufivertex')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Iridosornis' AND (species='rufivertex' OR species='rufivertex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' AND (junior_species='pallidinucha' OR junior_species='pallidinucha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atlapetes' AND (species='pallidinucha' OR species='pallidinucha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atlapetes' AND (species='pallidinucha' OR species='pallidinucha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atlapetes' AND (junior_species='pallidinucha' OR junior_species='pallidinucha')SELECT d.diet,d.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='pallidinucha' OR species='pallidinucha') 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='Buarremon' 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='Buarremon' AND (species='brunneinucha' OR species='brunneinucha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buarremon' AND (species='brunneinucha' OR species='brunneinucha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buarremon' 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='Buarremon' AND (species='brunneinucha' OR species='brunneinucha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catamenia' AND (junior_species='inornata' OR junior_species='inornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catamenia' AND (species='inornata' OR species='inornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catamenia' AND (species='inornata' OR species='inornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catamenia' AND (junior_species='inornata' OR junior_species='inornata')SELECT d.diet,d.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='inornata' OR species='inornata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonotrichia' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonotrichia' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='capensis' OR junior_species='capensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zonotrichia' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='psaltria' OR junior_species='psaltria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carduelis' AND (species='psaltria' OR species='psaltria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carduelis' AND (species='psaltria' OR species='psaltria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='psaltria' OR junior_species='psaltria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Carduelis' AND (species='psaltria' OR species='psaltria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacicus' AND (junior_species='chrysonotus' OR junior_species='chrysonotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cacicus' AND (species='chrysonotus' OR species='chrysonotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cacicus' AND (species='chrysonotus' OR species='chrysonotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cacicus' AND (junior_species='chrysonotus' OR junior_species='chrysonotus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cacicus' AND (species='chrysonotus' OR species='chrysonotus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1144 The Ecological Register: National Natural Park Chingaza
National Natural Park Chingaza
Basic information
Sample name: National Natural Park Chingaza

Reference: O. A. Rodriguez, H. Moya, and N. E. Matta. 2009. Avian blood parasites in the National Natural Park Chingaza: high Andes of Colombia. Hornero 24(1):1-6 [ER 797]
Geography
Country: Colombia


Coordinate: 4° 36' N, 73° 43' W
Coordinate basis: stated in text

Geography comments: "under the jurisdiction of Cundinamarca and Meta departments, covering ten municipalities"
coordinates and elevation are midpoints of values for three localities

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: national/state park

Substrate: ground surface

WMT: 14.2

CMT: 13.0

MAP: 1861.0

Habitat comments: there is a "distinct" dry season from November to March
CMT and WMT are for station 80222 (Bogotâ airport), which is at a considerably lower altitude and has lower MAP but will have to do

Methods
Life forms: birds

Sites: 3

Sampling methods: mist nets

Sample size: 136 individuals

Years: 2002, 2003

Sampling comments: no indication of collecting effort

Metadata
Sample number: 1144

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-09-02 12:52:40

Modified: 2014-09-02 02:52:40

Abundance distribution
40 species
16 singletons
total count 136
extrapolated richness: 95.1
Fisher's α: 19.098
geometric series k: 0.9346
Hurlbert's PIE: 0.9491
Shannon's H: 3.2898
Good's u: 0.8831
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Accipiter striatus19.7 g carnivore
Coeligena helianthea27.0 g
Eriocnemis cupreoventris45.3 g
Eriocnemis vestitus142.2 g
Metallura tyrianthina13.8 g nectarivore-insectivore
Opisthoprora euryptera2
Oxypogon guerinii14.8 g
Pterophanes cyanopterus210.2 g nectarivore-insectivore
Trogon personatus163.4 g frugivore-insectivore
Piculus rivolii3102 g insectivore
Margarornis squamiger617.3 g insectivore
Xiphocolaptes promeropirhynchus18.6 g insectivore
Mecocerculus leucophrys113.4 g insectivore
Ochthoeca diadema411.5 g insectivore
Ochthoeca sp.3
Pyrrhomyias cinnamomeus1 insectivore
Notiochelidon murina511.7 g insectivore
Cinnycerthia unirufa1129.4 g
Turdus fuscater12143 g insectivore-frugivore
Turdus serranus184.9 g frugivore-insectivore
Basileuterus nigrocristatus13.7 g insectivore
Myioborus ornatus111.7 g insectivore
Anisognathus igniventris234.0 g insectivore-frugivore
Buthraupis montana38.9 g frugivore
Conirostrum rufum211.0 g
Conirostrum sitticolor511.9 g insectivore-frugivore
Diglossa humeralis113.3 g
Diglossa lafresnayii1016.0 g
Diglossopis caerulescens114.6 g
Diglossopis cyanea617.4 g
Dubusia taeniata337.0 g frugivore
Hemispingus verticalis314.0 g
Iridosornis rufivertex123.0 g frugivore
Atlapetes pallidinucha236.1 g
Atlapetes schistaceus15.1 g
Buarremon brunneinucha16.4 g frugivore-insectivore
Catamenia inornata113.4 g frugivore
Zonotrichia capensis32.1 g granivore
Carduelis psaltria22.8 g nectarivore
Cacicus chrysonotus1 frugivore-insectivore