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=1056 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1056SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=729SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1056 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' AND (junior_species='olivacea' OR junior_species='olivacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanomitra' AND (species='olivacea' OR species='olivacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanomitra' AND (species='olivacea' OR species='olivacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' AND (junior_species='olivacea' OR junior_species='olivacea')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='Cyanomitra' AND (species='olivacea' OR species='olivacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alethe' AND (junior_species='poliocephala' OR junior_species='poliocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alethe' AND (species='poliocephala' OR species='poliocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alethe' AND (species='poliocephala' OR species='poliocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alethe' AND (junior_species='poliocephala' OR junior_species='poliocephala')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='Alethe' AND (species='poliocephala' OR species='poliocephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='latirostris' OR junior_species='latirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropadus' AND (species='latirostris' OR species='latirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropadus' AND (species='latirostris' OR species='latirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='latirostris' OR junior_species='latirostris')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='Andropadus' AND (species='latirostris' OR species='latirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bleda' AND (junior_species='syndactylus' OR junior_species='syndactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bleda' AND (species='syndactylus' OR species='syndactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bleda' AND (species='syndactylus' OR species='syndactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bleda' AND (junior_species='syndactylus' OR junior_species='syndactylus')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='Bleda' AND (species='syndactylus' OR species='syndactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocossyphus' AND (junior_species='poensis' OR junior_species='poensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neocossyphus' AND (species='poensis' OR species='poensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neocossyphus' AND (species='poensis' OR species='poensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neocossyphus' AND (junior_species='poensis' OR junior_species='poensis')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='Neocossyphus' AND (species='poensis' OR species='poensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sheppardia' AND (junior_species='aequatorialis' OR junior_species='aequatorialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sheppardia' AND (species='aequatorialis' OR species='aequatorialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sheppardia' AND (species='aequatorialis' OR species='aequatorialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sheppardia' AND (junior_species='aequatorialis' OR junior_species='aequatorialis')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='Sheppardia' AND (species='aequatorialis' OR species='aequatorialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylia' AND (junior_species='prasina' OR junior_species='prasina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylia' AND (species='prasina' OR species='prasina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylia' AND (species='prasina' OR species='prasina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylia' AND (junior_species='prasina' OR junior_species='prasina')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='Hylia' AND (species='prasina' OR species='prasina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='curvirostris' OR junior_species='curvirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropadus' AND (species='curvirostris' OR species='curvirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropadus' AND (species='curvirostris' OR species='curvirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='curvirostris' OR junior_species='curvirostris')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='Andropadus' AND (species='curvirostris' OR species='curvirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='virens' OR junior_species='virens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropadus' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropadus' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='virens' OR junior_species='virens')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='Andropadus' AND (species='virens' OR species='virens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Illadopsis' AND (junior_species='albipectus' OR junior_species='albipectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Illadopsis' AND (species='albipectus' OR species='albipectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Illadopsis' AND (species='albipectus' OR species='albipectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Illadopsis' AND (junior_species='albipectus' OR junior_species='albipectus')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='Illadopsis' AND (species='albipectus' OR species='albipectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cossypha' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cossypha' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='natalensis' OR junior_species='natalensis')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='Cossypha' AND (species='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophaga' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophaga' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophaga' AND (species='ruficapilla' OR species='ruficapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophaga' AND (junior_species='ruficapilla' OR junior_species='ruficapilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spermophaga' AND (species='ruficapilla' OR species='ruficapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='tympanistria' OR junior_species='tympanistria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turtur' AND (species='tympanistria' OR species='tympanistria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turtur' AND (species='tympanistria' OR species='tympanistria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='tympanistria' OR junior_species='tympanistria')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='Turtur' AND (species='tympanistria' OR species='tympanistria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='chloronota' OR junior_species='chloronota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camaroptera' AND (species='chloronota' OR species='chloronota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camaroptera' AND (species='chloronota' OR species='chloronota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='chloronota' OR junior_species='chloronota')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='Camaroptera' AND (species='chloronota' OR species='chloronota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='gracilirostris' OR junior_species='gracilirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropadus' AND (species='gracilirostris' OR species='gracilirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropadus' AND (species='gracilirostris' OR species='gracilirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='gracilirostris' OR junior_species='gracilirostris')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='Andropadus' AND (species='gracilirostris' OR species='gracilirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stizorhina' AND (junior_species='fraseri' OR junior_species='fraserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stizorhina' AND (species='fraseri' OR species='fraserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stizorhina' AND (species='fraseri' OR species='fraserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stizorhina' AND (junior_species='fraseri' OR junior_species='fraserii')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='Stizorhina' AND (species='fraseri' OR species='fraserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Illadopsis' AND (junior_species='fulvescens' OR junior_species='fulvescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Illadopsis' AND (species='fulvescens' OR species='fulvescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Illadopsis' AND (species='fulvescens' OR species='fulvescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Illadopsis' AND (junior_species='fulvescens' OR junior_species='fulvescens')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='Illadopsis' AND (species='fulvescens' OR species='fulvescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' 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='Muscicapa' AND (species='caerulescens' OR species='caerulescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscicapa' AND (species='caerulescens' OR species='caerulescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' 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='Muscicapa' AND (species='caerulescens' OR species='caerulescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyaphorophyia' AND (junior_species='castanea' OR junior_species='castanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dyaphorophyia' AND (species='castanea' OR species='castanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dyaphorophyia' AND (species='castanea' OR species='castanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyaphorophyia' AND (junior_species='castanea' OR junior_species='castanea')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='Dyaphorophyia' AND (species='castanea' OR species='castanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogoniulus' AND (junior_species='bilineatus' OR junior_species='bilineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogoniulus' AND (species='bilineatus' OR species='bilineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogoniulus' AND (species='bilineatus' OR species='bilineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogoniulus' AND (junior_species='bilineatus' OR junior_species='bilineatus')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='Pogoniulus' AND (species='bilineatus' OR species='bilineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='cyanocampter' OR junior_species='cyanocampter')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cossypha' AND (species='cyanocampter' OR species='cyanocampter') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cossypha' AND (species='cyanocampter' OR species='cyanocampter')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='cyanocampter' OR junior_species='cyanocampter')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='Cossypha' AND (species='cyanocampter' OR species='cyanocampter') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='rufiventer' OR junior_species='rufiventer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terpsiphone' AND (species='rufiventer' OR species='rufiventer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terpsiphone' AND (species='rufiventer' OR species='rufiventer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='rufiventer' OR junior_species='rufiventer')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='Terpsiphone' AND (species='rufiventer' OR species='rufiventer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercococcyx' AND (junior_species='mechowi' OR junior_species='mechowii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercococcyx' AND (species='mechowi' OR species='mechowii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercococcyx' AND (species='mechowi' OR species='mechowii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercococcyx' AND (junior_species='mechowi' OR junior_species='mechowii')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='Cercococcyx' AND (species='mechowi' OR species='mechowii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bathmocercus' 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='Bathmocercus' AND (species='rufus' OR species='rufus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bathmocercus' AND (species='rufus' OR species='rufus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bathmocercus' 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='Bathmocercus' AND (species='rufus' OR species='rufus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyaphorophyia' AND (junior_species='jamesoni' OR junior_species='jamesonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dyaphorophyia' AND (species='jamesoni' OR species='jamesonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dyaphorophyia' AND (species='jamesoni' OR species='jamesonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dyaphorophyia' AND (junior_species='jamesoni' OR junior_species='jamesonii')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='Dyaphorophyia' AND (species='jamesoni' OR species='jamesonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indicator' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Indicator' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Indicator' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indicator' AND (junior_species='minor' OR junior_species='minor')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='Indicator' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nicator' AND (junior_species='chloris' OR junior_species='chloris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nicator' AND (species='chloris' OR species='chloris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nicator' AND (species='chloris' OR species='chloris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nicator' AND (junior_species='chloris' OR junior_species='chloris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nicator' AND (species='chloris' OR species='chloris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columba' AND (junior_species='unicincta' OR junior_species='unicincta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Columba' AND (species='unicincta' OR species='unicincta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Columba' AND (species='unicincta' OR species='unicincta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Columba' AND (junior_species='unicincta' OR junior_species='unicincta')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='Columba' AND (species='unicincta' OR species='unicincta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ispidina' AND (junior_species='picta' OR junior_species='picta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ispidina' AND (species='picta' OR species='picta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ispidina' AND (species='picta' OR species='picta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ispidina' AND (junior_species='picta' OR junior_species='picta')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='Ispidina' AND (species='picta' OR species='picta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucidium' AND (junior_species='tephronotum' OR junior_species='tephronotum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucidium' AND (species='tephronotum' OR species='tephronotum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucidium' AND (species='tephronotum' OR species='tephronotum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucidium' AND (junior_species='tephronotum' OR junior_species='tephronotum')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='Glaucidium' AND (species='tephronotum' OR species='tephronotum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptospiza' AND (junior_species='reichenovii' OR junior_species='reichenovi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptospiza' AND (species='reichenovii' OR species='reichenovi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptospiza' AND (species='reichenovii' OR species='reichenovi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptospiza' AND (junior_species='reichenovii' OR junior_species='reichenovi')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='Cryptospiza' AND (species='reichenovii' OR species='reichenovi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camaroptera' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camaroptera' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='brachyura' OR junior_species='brachyura')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='Camaroptera' AND (species='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='nigerrimus' OR junior_species='nigerrimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='nigerrimus' OR species='nigerrimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='nigerrimus' OR species='nigerrimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='nigerrimus' OR junior_species='nigerrimus')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='Ploceus' AND (species='nigerrimus' OR species='nigerrimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='nigricollis' OR junior_species='nigricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='nigricollis' OR species='nigricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='nigricollis' OR species='nigricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='nigricollis' OR junior_species='nigricollis')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='Ploceus' AND (species='nigricollis' OR species='nigricollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='melanogaster' OR junior_species='melanogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='melanogaster' OR species='melanogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='melanogaster' OR species='melanogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='melanogaster' OR junior_species='melanogaster')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='Ploceus' AND (species='melanogaster' OR species='melanogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceuthmochares' AND (junior_species='aereus' OR junior_species='aereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceuthmochares' AND (species='aereus' OR species='aereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceuthmochares' AND (species='aereus' OR species='aereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceuthmochares' AND (junior_species='aereus' OR junior_species='aereus')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='Ceuthmochares' AND (species='aereus' OR species='aereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyphonus' AND (junior_species='purpuratus' OR junior_species='purpuratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachyphonus' AND (species='purpuratus' OR species='purpuratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachyphonus' AND (species='purpuratus' OR species='purpuratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachyphonus' AND (junior_species='purpuratus' OR junior_species='purpuratus')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='Trachyphonus' AND (species='purpuratus' OR species='purpuratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campethera' AND (junior_species='caroli' OR junior_species='carolii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campethera' AND (species='caroli' OR species='carolii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campethera' AND (species='caroli' OR species='carolii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campethera' AND (junior_species='caroli' OR junior_species='carolii')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='Campethera' AND (species='caroli' OR species='carolii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baeopogon' AND (junior_species='indicator' OR junior_species='indicator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Baeopogon' AND (species='indicator' OR species='indicator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Baeopogon' AND (species='indicator' OR species='indicator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Baeopogon' AND (junior_species='indicator' OR junior_species='indicator')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='Baeopogon' AND (species='indicator' OR species='indicator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' 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='Cyanomitra' AND (species='verticalis' OR species='verticalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanomitra' AND (species='verticalis' OR species='verticalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' 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='Cyanomitra' AND (species='verticalis' OR species='verticalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mandingoa' AND (junior_species='nitidula' OR junior_species='nitidula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mandingoa' AND (species='nitidula' OR species='nitidula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mandingoa' AND (species='nitidula' OR species='nitidula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mandingoa' AND (junior_species='nitidula' OR junior_species='nitidula')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='Mandingoa' AND (species='nitidula' OR species='nitidula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='clamosus' OR junior_species='clamosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuculus' AND (species='clamosus' OR species='clamosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cuculus' AND (species='clamosus' OR species='clamosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuculus' AND (junior_species='clamosus' OR junior_species='clamosus')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='Cuculus' AND (species='clamosus' OR species='clamosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropicos' AND (junior_species='elliottii' OR junior_species='elliotti')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropicos' AND (species='elliottii' OR species='elliotti') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropicos' AND (species='elliottii' OR species='elliotti')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropicos' AND (junior_species='elliottii' OR junior_species='elliotti')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='Dendropicos' AND (species='elliottii' OR species='elliotti') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' 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='Ploceus' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' 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='Ploceus' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parmoptila' AND (junior_species='woodhousei' OR junior_species='woodhouseii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parmoptila' AND (species='woodhousei' OR species='woodhouseii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parmoptila' AND (species='woodhousei' OR species='woodhouseii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parmoptila' AND (junior_species='woodhousei' OR junior_species='woodhouseii')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='Parmoptila' AND (species='woodhousei' OR species='woodhouseii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='jacksoni' OR junior_species='jacksonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apalis' AND (species='jacksoni' OR species='jacksonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apalis' AND (species='jacksoni' OR species='jacksonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='jacksoni' OR junior_species='jacksonii')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='Apalis' AND (species='jacksoni' OR species='jacksonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smithornis' 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='Smithornis' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Smithornis' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smithornis' 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='Smithornis' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' AND (junior_species='cyanolaema' OR junior_species='cyanolaema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanomitra' AND (species='cyanolaema' OR species='cyanolaema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanomitra' AND (species='cyanolaema' OR species='cyanolaema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanomitra' AND (junior_species='cyanolaema' OR junior_species='cyanolaema')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='Cyanomitra' AND (species='cyanolaema' OR species='cyanolaema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoalcippe' AND (junior_species='abyssinica' OR junior_species='abyssinica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoalcippe' AND (species='abyssinica' OR species='abyssinica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoalcippe' AND (species='abyssinica' OR species='abyssinica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoalcippe' AND (junior_species='abyssinica' OR junior_species='abyssinica')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='Pseudoalcippe' AND (species='abyssinica' OR species='abyssinica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='pelios' OR junior_species='pelios')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='pelios' OR species='pelios') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='pelios' OR species='pelios')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='pelios' OR junior_species='pelios')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='pelios' OR species='pelios') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='leucopogon' OR junior_species='leucopogon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prinia' AND (species='leucopogon' OR species='leucopogon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prinia' AND (species='leucopogon' OR species='leucopogon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='leucopogon' OR junior_species='leucopogon')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='Prinia' AND (species='leucopogon' OR species='leucopogon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='nonnula' OR junior_species='nonnula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Estrilda' AND (species='nonnula' OR species='nonnula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Estrilda' AND (species='nonnula' OR species='nonnula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='nonnula' OR junior_species='nonnula')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='Estrilda' AND (species='nonnula' OR species='nonnula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nigrita' AND (junior_species='canicapillus' OR junior_species='canicapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nigrita' AND (species='canicapillus' OR species='canicapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nigrita' AND (species='canicapillus' OR species='canicapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nigrita' AND (junior_species='canicapillus' OR junior_species='canicapillus')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='Nigrita' AND (species='canicapillus' OR species='canicapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='bairdii' OR junior_species='bairdi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prinia' AND (species='bairdii' OR species='bairdi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prinia' AND (species='bairdii' OR species='bairdi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='bairdii' OR junior_species='bairdi')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='Prinia' AND (species='bairdii' OR species='bairdi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laniarius' AND (junior_species='luehderi' OR junior_species='luehderii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laniarius' AND (species='luehderi' OR species='luehderii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laniarius' AND (species='luehderi' OR species='luehderii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laniarius' AND (junior_species='luehderi' OR junior_species='luehderii')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='Laniarius' AND (species='luehderi' OR species='luehderii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='Zosterops' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hedydipna' AND (junior_species='collaris' OR junior_species='collaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hedydipna' AND (species='collaris' OR species='collaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hedydipna' AND (species='collaris' OR species='collaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hedydipna' AND (junior_species='collaris' OR junior_species='collaris')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='Hedydipna' AND (species='collaris' OR species='collaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvietta' 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='Sylvietta' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvietta' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvietta' 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='Sylvietta' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='binotata' OR junior_species='binotata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apalis' AND (species='binotata' OR species='binotata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apalis' AND (species='binotata' OR species='binotata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='binotata' OR junior_species='binotata')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='Apalis' AND (species='binotata' OR species='binotata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesocharis' AND (junior_species='ansorgei' OR junior_species='ansorgeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesocharis' AND (species='ansorgei' OR species='ansorgeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nesocharis' AND (species='ansorgei' OR species='ansorgeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesocharis' AND (junior_species='ansorgei' OR junior_species='ansorgeii')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='Nesocharis' AND (species='ansorgei' OR species='ansorgeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='hypochloris' OR junior_species='hypochloris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllastrephus' AND (species='hypochloris' OR species='hypochloris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllastrephus' AND (species='hypochloris' OR species='hypochloris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='hypochloris' OR junior_species='hypochloris')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='Phyllastrephus' AND (species='hypochloris' OR species='hypochloris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campethera' AND (junior_species='nivosa' OR junior_species='nivosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campethera' AND (species='nivosa' OR species='nivosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campethera' AND (species='nivosa' OR species='nivosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campethera' AND (junior_species='nivosa' OR junior_species='nivosa')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='Campethera' AND (species='nivosa' OR species='nivosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='barbatus' OR junior_species='barbatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnonotus' AND (species='barbatus' OR species='barbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnonotus' AND (species='barbatus' OR species='barbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' AND (junior_species='barbatus' OR junior_species='barbatus')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='Pycnonotus' AND (species='barbatus' OR species='barbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='chloropygius' OR junior_species='chloropygius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnyris' AND (species='chloropygius' OR species='chloropygius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnyris' AND (species='chloropygius' OR species='chloropygius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='chloropygius' OR junior_species='chloropygius')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='Cinnyris' AND (species='chloropygius' OR species='chloropygius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogoniulus' AND (junior_species='scolopaceus' OR junior_species='scolopaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogoniulus' AND (species='scolopaceus' OR species='scolopaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogoniulus' AND (species='scolopaceus' OR species='scolopaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogoniulus' AND (junior_species='scolopaceus' OR junior_species='scolopaceus')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='Pogoniulus' AND (species='scolopaceus' OR species='scolopaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='chubbi' OR junior_species='chubbii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='chubbi' OR species='chubbii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='chubbi' OR species='chubbii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='chubbi' OR junior_species='chubbii')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='Cisticola' AND (species='chubbi' OR species='chubbii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='brachyrhynchus' OR junior_species='brachyrhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oriolus' AND (species='brachyrhynchus' OR species='brachyrhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oriolus' AND (species='brachyrhynchus' OR species='brachyrhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='brachyrhynchus' OR junior_species='brachyrhynchus')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='Oriolus' AND (species='brachyrhynchus' OR species='brachyrhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocichla' AND (junior_species='laetissima' OR junior_species='laetissima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocichla' AND (species='laetissima' OR species='laetissima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocichla' AND (species='laetissima' OR species='laetissima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocichla' AND (junior_species='laetissima' OR junior_species='laetissima')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='Chlorocichla' AND (species='laetissima' OR species='laetissima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nigrita' AND (junior_species='fusconota' OR junior_species='fusconota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nigrita' AND (species='fusconota' OR species='fusconota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nigrita' AND (species='fusconota' OR species='fusconota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nigrita' AND (junior_species='fusconota' OR junior_species='fusconota')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='Nigrita' AND (species='fusconota' OR species='fusconota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblyospiza' AND (junior_species='albifrons' OR junior_species='albifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblyospiza' AND (species='albifrons' OR species='albifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblyospiza' AND (species='albifrons' OR species='albifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblyospiza' AND (junior_species='albifrons' OR junior_species='albifrons')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='Amblyospiza' AND (species='albifrons' OR species='albifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terpsiphone' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terpsiphone' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='viridis' OR junior_species='viridis')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='Terpsiphone' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='gularis' OR junior_species='gularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Merops' AND (species='gularis' OR species='gularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Merops' AND (species='gularis' OR species='gularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='gularis' OR junior_species='gularis')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='Merops' AND (species='gularis' OR species='gularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplopelia' AND (junior_species='larvata' OR junior_species='larvata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aplopelia' AND (species='larvata' OR species='larvata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aplopelia' AND (species='larvata' OR species='larvata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplopelia' AND (junior_species='larvata' OR junior_species='larvata')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='Aplopelia' AND (species='larvata' OR species='larvata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trochocercus' AND (junior_species='albonotatus' OR junior_species='albonotatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trochocercus' AND (species='albonotatus' OR species='albonotatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trochocercus' AND (species='albonotatus' OR species='albonotatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trochocercus' AND (junior_species='albonotatus' OR junior_species='albonotatus')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='Trochocercus' AND (species='albonotatus' OR species='albonotatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eminia' AND (junior_species='lepida' OR junior_species='lepida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eminia' AND (species='lepida' OR species='lepida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eminia' AND (species='lepida' OR species='lepida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eminia' AND (junior_species='lepida' OR junior_species='lepida')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='Eminia' AND (species='lepida' OR species='lepida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='subflava' OR junior_species='subflava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prinia' AND (species='subflava' OR species='subflava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prinia' AND (species='subflava' OR species='subflava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prinia' AND (junior_species='subflava' OR junior_species='subflava')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prinia' AND (species='subflava' OR species='subflava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platysteira' 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='Platysteira' AND (species='cyanea' OR species='cyanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platysteira' AND (species='cyanea' OR species='cyanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platysteira' 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='Platysteira' AND (species='cyanea' OR species='cyanea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centropus' AND (species='superciliosus' OR species='superciliosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centropus' AND (species='superciliosus' OR species='superciliosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='superciliosus' OR junior_species='superciliosus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Centropus' AND (species='superciliosus' OR species='superciliosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melaniparus' AND (junior_species='funereus' OR junior_species='funereus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melaniparus' AND (species='funereus' OR species='funereus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melaniparus' AND (species='funereus' OR species='funereus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melaniparus' AND (junior_species='funereus' OR junior_species='funereus')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='Melaniparus' AND (species='funereus' OR species='funereus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tchagra' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tchagra' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tchagra' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tchagra' AND (junior_species='australis' OR junior_species='australis')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='Tchagra' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malaconotus' AND (junior_species='blanchoti' OR junior_species='blanchotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malaconotus' AND (species='blanchoti' OR species='blanchotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malaconotus' AND (species='blanchoti' OR species='blanchotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malaconotus' AND (junior_species='blanchoti' OR junior_species='blanchotii')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='Malaconotus' AND (species='blanchoti' OR species='blanchotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropicos' AND (junior_species='fuscescens' OR junior_species='fuscescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendropicos' AND (species='fuscescens' OR species='fuscescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendropicos' AND (species='fuscescens' OR species='fuscescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendropicos' AND (junior_species='fuscescens' OR junior_species='fuscescens')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='Dendropicos' AND (species='fuscescens' OR species='fuscescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='cucullata' OR junior_species='cucullata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lonchura' AND (species='cucullata' OR species='cucullata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchura' AND (species='cucullata' OR species='cucullata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' AND (junior_species='cucullata' OR junior_species='cucullata')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='Lonchura' AND (species='cucullata' OR species='cucullata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcomitra' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcomitra' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcomitra' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcomitra' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='Chalcomitra' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1056 The Ecological Register: Makerere University Biological Field Station (logged)
Makerere University Biological Field Station (logged)
Basic information
Sample name: Makerere University Biological Field Station (logged)

Sample aka: Kibale National Park

Reference: C. Dranzoa. 1998. The avifauna 23 years after logging in Kibale National park, Uganda. Biodiversity and Conservation 7:777-797 [ER 729]
Geography
Country: Uganda


Coordinate: 0° 27' 0" N, 30° 33' 30" E
Coordinate basis: stated in text as range

Geography comments: coordinate is the midpoint of ranges given in the text
altitude 1590 to 1110 meters

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Altered habitat: secondary forest

Protection: national/state park

Substrate: ground surface

WMT: 21.6

CMT: 19.9

MAP: 1500.0

Habitat comments: "moist evergreen tropical forest" logged in 1968 and 1969
climate data based on station 64387 (see sample 595)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 3811 individuals

Years: 1991 - 1993

Days: 56

Nets or traps: 11

Net or trap nights: 616

Sampling comments: a total of 120 m of 9.5 to 12.5 m nets (= about 11) were spread out for 12 hours a day for a total of 666 hours (= about 56 days)

Metadata
Sample number: 1056

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-20 14:01:40

Modified: 2014-08-20 04:01:40

Abundance distribution
84 species
20 singletons
total count 3811
extrapolated richness: 128.0
Fisher's α: 15.193
geometric series k: 0.9205
Hurlbert's PIE: 0.8957
Shannon's H: 2.9812
Good's u: 0.9948
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Cyanomitra olivacea5702.8 g insectivore-nectarivore
"Nectarinia olivacea"
Alethe poliocephala2585.3 g insectivore-carnivore
Andropadus latirostris96926.2 g frugivore-insectivore
Bleda syndactylus15645.3 g insectivore
"Bleda syndactyla"
Neocossyphus poensis4453.1 g insectivore
Sheppardia aequatorialis8916.8 g insectivore
Hylia prasina7514.1 g insectivore
Andropadus curvirostris14424.9 g frugivore
Andropadus virens1065.0 g frugivore-granivore
Illadopsis albipectus4830.6 g insectivore
Cossypha natalensis1434.1 g
Spermophaga ruficapilla8323.6 g granivore
Turtur tympanistria848.6 g granivore-frugivore
Camaroptera chloronota8011.4 g insectivore
Andropadus gracilirostris19430.7 g frugivore-insectivore
Stizorhina fraseri4
Illadopsis fulvescens4627.9 g insectivore
Muscicapa caerulescens2117.6 g insectivore
Dyaphorophyia castanea25 insectivore
Pogoniulus bilineatus323.4 g frugivore-insectivore
Cossypha cyanocampter10426.7 g insectivore
Terpsiphone rufiventer815.1 g insectivore
Cercococcyx mechowi1355.6 g insectivore
Bathmocercus rufus15616.6 g
Dyaphorophyia jamesoni52
Indicator minor628.2 g insectivore
Nicator chloris749.1 g insectivore
Columba unicincta10423 g frugivore
Ispidina picta13.8 g piscivore
Glaucidium tephronotum187.4 g carnivore
Cryptospiza reichenovii2312.4 g omnivore
Camaroptera brachyura301.6 g insectivore
Ploceus nigerrimus138.5 g omnivore
Ploceus nigricollis927.1 g folivore-insectivore
Ploceus melanogaster1522.4 g insectivore
Ceuthmochares aereus165.8 g insectivore
Trachyphonus purpuratus176.1 g frugivore-insectivore
"Trachylaemus purpuratus"
Campethera caroli1 insectivore
Baeopogon indicator147.8 g omnivore
Cyanomitra verticalis615.2 g insectivore-nectarivore
"Nectarinia verticalis"
Mandingoa nitidula199.6 g granivore-insectivore
Cuculus clamosus1 insectivore
Dendropicos elliottii1
Ploceus 'bicolor'11
Parmoptila woodhousei149.4 g
Apalis jacksoni18.7 g
Smithornis capensis923.2 g insectivore
Cyanomitra cyanolaema216.8 g
"Nectarinia cyanolaema"
Pseudoalcippe abyssinica1 insectivore
Turdus pelios165.4 g insectivore
Prinia leucopogon4211.7 g insectivore
Estrilda nonnula47.7 g folivore-insectivore
Nigrita canicapillus418.7 g frugivore-insectivore
"Nigrita canicapilla"
Prinia bairdii5913.4 g insectivore
Laniarius luehderi21 insectivore-carnivore
Zosterops senegalensis1810.9 g frugivore-insectivore
Hedydipna collaris182.6 g nectarivore
"Anthreptes collaris"
Sylvietta leucophrys1411.7 g insectivore
Apalis binotata128.2 g
Nesocharis ansorgei78.4 g
Phyllastrephus hypochloris625.6 g
Campethera nivosa637.8 g insectivore
Pycnonotus barbatus55.1 g frugivore-insectivore
Cinnyris chloropygius56.2 g
"Nectarinia chloropygia"
Pogoniulus scolopaceus4 omnivore
Cisticola chubbi417.5 g insectivore
Oriolus brachyrhynchus4 insectivore
Chlorocichla laetissima450.2 g frugivore
Nigrita fusconota3 omnivore
Amblyospiza albifrons33.7 g granivore
Terpsiphone viridis213.8 g insectivore
Merops gularis227.3 g insectivore
Aplopelia larvata2 granivore-frugivore
Trochocercus albonotatus2
Eminia lepida220.2 g insectivore
Prinia subflava29.0 g insectivore
Platysteira cyanea114.6 g insectivore
Centropus superciliosus112.6 g
Melaniparus funereus1
"Parus funereus"
Tchagra australis1 insectivore
Malaconotus blanchoti1 insectivore
Dendropicos fuscescens126.0 g insectivore
Lonchura cucullata13.0 g granivore
Chalcomitra senegalensis12.4 g insectivore-nectarivore
"Nectarinia senegalensis"