Coordinate: 0° 27' 0" N, 30° 33' 30" E
altitude 1590 to 1110 meters
climate data based on station 64387 (see sample 595)
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