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=1076 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1076SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=744SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1076 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='lathami' OR junior_species='lathamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Francolinus' AND (species='lathami' OR species='lathamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Francolinus' AND (species='lathami' OR species='lathamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='lathami' OR junior_species='lathamii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Francolinus' AND (species='lathami' OR species='lathamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='ahantensis' OR junior_species='ahantensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Francolinus' AND (species='ahantensis' OR species='ahantensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Francolinus' AND (species='ahantensis' OR species='ahantensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Francolinus' AND (junior_species='ahantensis' OR junior_species='ahantensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Francolinus' AND (species='ahantensis' OR species='ahantensis') 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='Streptopelia' AND (junior_species='semitorquata' OR junior_species='semitorquata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Streptopelia' AND (species='semitorquata' OR species='semitorquata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Streptopelia' AND (species='semitorquata' OR species='semitorquata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Streptopelia' AND (junior_species='semitorquata' OR junior_species='semitorquata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Streptopelia' AND (species='semitorquata' OR species='semitorquata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Treron' 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='Treron' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Treron' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Treron' 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='Treron' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='brehmeri' OR junior_species='brehmerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turtur' AND (species='brehmeri' OR species='brehmerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turtur' AND (species='brehmeri' OR species='brehmerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='brehmeri' OR junior_species='brehmerii')SELECT d.diet,d.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='brehmeri' OR species='brehmerii') 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='Corythaeola' AND (junior_species='cristata' OR junior_species='cristata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corythaeola' AND (species='cristata' OR species='cristata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corythaeola' AND (species='cristata' OR species='cristata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corythaeola' AND (junior_species='cristata' OR junior_species='cristata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Corythaeola' AND (species='cristata' OR species='cristata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tauraco' AND (junior_species='macrorhynchusf' OR junior_species='macrorhynchusf')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tauraco' AND (species='macrorhynchusf' OR species='macrorhynchusf') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tauraco' AND (species='macrorhynchusf' OR species='macrorhynchusf')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tauraco' AND (junior_species='macrorhynchusf' OR junior_species='macrorhynchusf')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tauraco' AND (species='macrorhynchusf' OR species='macrorhynchusf') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tauraco' AND (junior_species='persa' OR junior_species='persa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tauraco' AND (species='persa' OR species='persa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tauraco' AND (species='persa' OR species='persa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tauraco' AND (junior_species='persa' OR junior_species='persa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tauraco' AND (species='persa' OR species='persa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='leucogaster' OR junior_species='leucogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centropus' AND (species='leucogaster' OR species='leucogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centropus' AND (species='leucogaster' OR species='leucogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' AND (junior_species='leucogaster' OR junior_species='leucogaster')SELECT d.diet,d.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='leucogaster' OR species='leucogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' 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='Centropus' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centropus' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centropus' 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='Centropus' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='caprius' OR junior_species='caprius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='caprius' OR species='caprius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='caprius' OR species='caprius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='caprius' OR junior_species='caprius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chrysococcyx' AND (species='caprius' OR species='caprius') 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='Caprimulgus' AND (junior_species='pectoralis' OR junior_species='pectoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caprimulgus' AND (species='pectoralis' OR species='pectoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caprimulgus' AND (species='pectoralis' OR species='pectoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caprimulgus' AND (junior_species='pectoralis' OR junior_species='pectoralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caprimulgus' AND (species='pectoralis' OR species='pectoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apus' AND (junior_species='apus' OR junior_species='apus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apus' AND (species='apus' OR species='apus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apus' AND (species='apus' OR species='apus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apus' AND (junior_species='apus' OR junior_species='apus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apus' AND (species='apus' OR species='apus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='cassini' OR junior_species='cassinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetura' AND (species='cassini' OR species='cassinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetura' AND (species='cassini' OR species='cassinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='cassini' OR junior_species='cassinii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chaetura' AND (species='cassini' OR species='cassinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='ussheri' OR junior_species='ussherii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chaetura' AND (species='ussheri' OR species='ussherii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chaetura' AND (species='ussheri' OR species='ussherii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chaetura' AND (junior_species='ussheri' OR junior_species='ussherii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chaetura' AND (species='ussheri' OR species='ussherii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apaloderma' AND (junior_species='narina' OR junior_species='narina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apaloderma' AND (species='narina' OR species='narina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apaloderma' AND (species='narina' OR species='narina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apaloderma' AND (junior_species='narina' OR junior_species='narina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apaloderma' AND (species='narina' OR species='narina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' AND (junior_species='quadribrachys' OR junior_species='quadribrachys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcedo' AND (species='quadribrachys' OR species='quadribrachys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcedo' AND (species='quadribrachys' OR species='quadribrachys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' AND (junior_species='quadribrachys' OR junior_species='quadribrachys')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alcedo' AND (species='quadribrachys' OR species='quadribrachys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='lecontei' OR junior_species='leconteii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceyx' AND (species='lecontei' OR species='leconteii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceyx' AND (species='lecontei' OR species='leconteii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceyx' AND (junior_species='lecontei' OR junior_species='leconteii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ceyx' AND (species='lecontei' OR species='leconteii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='badia' OR junior_species='badia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Halcyon' AND (species='badia' OR species='badia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halcyon' AND (species='badia' OR species='badia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' AND (junior_species='badia' OR junior_species='badia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Halcyon' AND (species='badia' OR species='badia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='muelleri' OR junior_species='muellerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Merops' AND (species='muelleri' OR species='muellerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Merops' AND (species='muelleri' OR species='muellerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='muelleri' OR junior_species='muellerii')SELECT d.diet,d.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='muelleri' OR species='muellerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurystomus' 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='Eurystomus' AND (species='gularis' OR species='gularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurystomus' AND (species='gularis' OR species='gularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurystomus' 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='Eurystomus' AND (species='gularis' OR species='gularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoeniculus' AND (junior_species='bollei' OR junior_species='bolleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoeniculus' AND (species='bollei' OR species='bolleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoeniculus' AND (species='bollei' OR species='bolleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoeniculus' AND (junior_species='bollei' OR junior_species='bolleii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phoeniculus' AND (species='bollei' OR species='bolleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='camurus' OR junior_species='camurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tockus' AND (species='camurus' OR species='camurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tockus' AND (species='camurus' OR species='camurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='camurus' OR junior_species='camurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tockus' AND (species='camurus' OR species='camurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='fasciatus' OR junior_species='fasciatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tockus' AND (species='fasciatus' OR species='fasciatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tockus' AND (species='fasciatus' OR species='fasciatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='fasciatus' OR junior_species='fasciatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tockus' AND (species='fasciatus' OR species='fasciatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='hartlaubi' OR junior_species='hartlaubii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tockus' AND (species='hartlaubi' OR species='hartlaubii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tockus' AND (species='hartlaubi' OR species='hartlaubii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tockus' AND (junior_species='hartlaubi' OR junior_species='hartlaubii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tockus' AND (species='hartlaubi' OR species='hartlaubii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropicranus' AND (junior_species='albocristatus' OR junior_species='albocristatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tropicranus' AND (species='albocristatus' OR species='albocristatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tropicranus' AND (species='albocristatus' OR species='albocristatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tropicranus' AND (junior_species='albocristatus' OR junior_species='albocristatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tropicranus' AND (species='albocristatus' OR species='albocristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobucco' AND (junior_species='calvus' OR junior_species='calvus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnobucco' AND (species='calvus' OR species='calvus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnobucco' AND (species='calvus' OR species='calvus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobucco' AND (junior_species='calvus' OR junior_species='calvus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gymnobucco' AND (species='calvus' OR species='calvus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobucco' AND (junior_species='peli' OR junior_species='pelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnobucco' AND (species='peli' OR species='pelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnobucco' AND (species='peli' OR species='pelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnobucco' AND (junior_species='peli' OR junior_species='pelii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gymnobucco' AND (species='peli' OR species='pelii') 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='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='Pogoniulus' AND (junior_species='subsulphureus' OR junior_species='subsulphureus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pogoniulus' AND (species='subsulphureus' OR species='subsulphureus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pogoniulus' AND (species='subsulphureus' OR species='subsulphureus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pogoniulus' AND (junior_species='subsulphureus' OR junior_species='subsulphureus')SELECT d.diet,d.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='subsulphureus' OR species='subsulphureus') 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='Melichneutes' AND (junior_species='robustus' OR junior_species='robustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melichneutes' AND (species='robustus' OR species='robustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melichneutes' AND (species='robustus' OR species='robustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melichneutes' AND (junior_species='robustus' OR junior_species='robustus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melichneutes' AND (species='robustus' OR species='robustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodotiscus' AND (junior_species='insignis' OR junior_species='insignis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prodotiscus' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prodotiscus' AND (species='insignis' OR species='insignis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodotiscus' AND (junior_species='insignis' OR junior_species='insignis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prodotiscus' AND (species='insignis' OR species='insignis') 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='Mesopicos' AND (junior_species='pyrrhogaster' OR junior_species='pyrrhogaster')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesopicos' AND (species='pyrrhogaster' OR species='pyrrhogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesopicos' AND (species='pyrrhogaster' OR species='pyrrhogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesopicos' AND (junior_species='pyrrhogaster' OR junior_species='pyrrhogaster')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesopicos' AND (species='pyrrhogaster' OR species='pyrrhogaster') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smithornis' AND (junior_species='rufolateralis' OR junior_species='rufolateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Smithornis' AND (species='rufolateralis' OR species='rufolateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Smithornis' AND (species='rufolateralis' OR species='rufolateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smithornis' AND (junior_species='rufolateralis' OR junior_species='rufolateralis')SELECT d.diet,d.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='rufolateralis' OR species='rufolateralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitta' AND (species='angolensis' OR species='angolensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitta' AND (species='angolensis' OR species='angolensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' AND (junior_species='angolensis' OR junior_species='angolensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pitta' AND (species='angolensis' OR species='angolensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malaconotus' AND (junior_species='cruentus' OR junior_species='cruentus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malaconotus' AND (species='cruentus' OR species='cruentus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malaconotus' AND (species='cruentus' OR species='cruentus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malaconotus' AND (junior_species='cruentus' OR junior_species='cruentus')SELECT d.diet,d.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='cruentus' OR species='cruentus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionops' AND (junior_species='caniceps' OR junior_species='caniceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionops' AND (species='caniceps' OR species='caniceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prionops' AND (species='caniceps' OR species='caniceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionops' AND (junior_species='caniceps' OR junior_species='caniceps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prionops' AND (species='caniceps' OR species='caniceps') 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='Oriolus' AND (junior_species='nigripennis' OR junior_species='nigripennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oriolus' AND (species='nigripennis' OR species='nigripennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oriolus' AND (species='nigripennis' OR species='nigripennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oriolus' AND (junior_species='nigripennis' OR junior_species='nigripennis')SELECT d.diet,d.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='nigripennis' OR species='nigripennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coracina' AND (junior_species='azurea' OR junior_species='azurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coracina' AND (species='azurea' OR species='azurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coracina' AND (species='azurea' OR species='azurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coracina' AND (junior_species='azurea' OR junior_species='azurea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Coracina' AND (species='azurea' OR species='azurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picathartes' AND (junior_species='gymnocephalus' OR junior_species='gymnocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picathartes' AND (species='gymnocephalus' OR species='gymnocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picathartes' AND (species='gymnocephalus' OR species='gymnocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picathartes' AND (junior_species='gymnocephalus' OR junior_species='gymnocephalus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Picathartes' AND (species='gymnocephalus' OR species='gymnocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropadus' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropadus' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropadus' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT d.diet,d.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='gracilis' OR species='gracilis') 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='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='Bleda' AND (junior_species='eximius' OR junior_species='eximius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bleda' AND (species='eximius' OR species='eximius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bleda' AND (species='eximius' OR species='eximius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bleda' AND (junior_species='eximius' OR junior_species='eximius')SELECT d.diet,d.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='eximius' OR species='eximius') 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='Criniger' 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='Criniger' AND (species='barbatus' OR species='barbatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Criniger' AND (species='barbatus' OR species='barbatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Criniger' 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='Criniger' AND (species='barbatus' OR species='barbatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Criniger' AND (junior_species='calurus' OR junior_species='calurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Criniger' AND (species='calurus' OR species='calurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Criniger' AND (species='calurus' OR species='calurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Criniger' AND (junior_species='calurus' OR junior_species='calurus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Criniger' AND (species='calurus' OR species='calurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='icterinus' OR junior_species='icterinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllastrephus' AND (species='icterinus' OR species='icterinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllastrephus' AND (species='icterinus' OR species='icterinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllastrephus' AND (junior_species='icterinus' OR junior_species='icterinus')SELECT d.diet,d.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='icterinus' OR species='icterinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alethe' AND (junior_species='diademata' OR junior_species='diademata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alethe' AND (species='diademata' OR species='diademata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alethe' AND (species='diademata' OR species='diademata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alethe' AND (junior_species='diademata' OR junior_species='diademata')SELECT d.diet,d.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='diademata' OR species='diademata') 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='Stiphrornis' AND (junior_species='erythrothorax' OR junior_species='erythrothorax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stiphrornis' AND (species='erythrothorax' OR species='erythrothorax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stiphrornis' AND (species='erythrothorax' OR species='erythrothorax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stiphrornis' AND (junior_species='erythrothorax' OR junior_species='erythrothorax')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stiphrornis' AND (species='erythrothorax' OR species='erythrothorax') 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='Phyllanthus' AND (junior_species='atripennis' OR junior_species='atripennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllanthus' AND (species='atripennis' OR species='atripennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllanthus' AND (species='atripennis' OR species='atripennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllanthus' AND (junior_species='atripennis' OR junior_species='atripennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phyllanthus' AND (species='atripennis' OR species='atripennis') 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='Camaroptera' AND (junior_species='superciliaris' OR junior_species='superciliaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camaroptera' AND (species='superciliaris' OR species='superciliaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camaroptera' AND (species='superciliaris' OR species='superciliaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camaroptera' AND (junior_species='superciliaris' OR junior_species='superciliaris')SELECT d.diet,d.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='superciliaris' OR species='superciliaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artomyias' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artomyias' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artomyias' AND (species='fuliginosa' OR species='fuliginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artomyias' AND (junior_species='fuliginosa' OR junior_species='fuliginosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Artomyias' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraseria' AND (junior_species='cinerascens' OR junior_species='cinerascens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fraseria' AND (species='cinerascens' OR species='cinerascens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fraseria' AND (species='cinerascens' OR species='cinerascens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fraseria' AND (junior_species='cinerascens' OR junior_species='cinerascens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fraseria' AND (species='cinerascens' OR species='cinerascens') 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='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='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='Malimbus' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malimbus' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malimbus' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malimbus' AND (junior_species='nitens' OR junior_species='nitens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Malimbus' AND (species='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malimbus' AND (junior_species='rubricollis' OR junior_species='rubricollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malimbus' AND (species='rubricollis' OR species='rubricollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malimbus' AND (species='rubricollis' OR species='rubricollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malimbus' AND (junior_species='rubricollis' OR junior_species='rubricollis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Malimbus' AND (species='rubricollis' OR species='rubricollis') 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='Nigrita' 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='Nigrita' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nigrita' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nigrita' 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='Nigrita' AND (species='bicolor' OR species='bicolor') 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='Spermophaga' AND (junior_species='haematina' OR junior_species='haematina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophaga' AND (species='haematina' OR species='haematina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophaga' AND (species='haematina' OR species='haematina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophaga' AND (junior_species='haematina' OR junior_species='haematina')SELECT d.diet,d.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='haematina' OR species='haematina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1076 The Ecological Register: Shasha Forest Reserve (61 mm mesh)
Shasha Forest Reserve (61 mm mesh)
Basic information
Sample name: Shasha Forest Reserve (61 mm mesh)

Reference: A. I. Akinpelu. 2013. Mesh size and bird capture rates in shasha forest reserve, ile-ife, Nigeria. Cameroon Journal of Experimental Biology 9(1):27-33 [ER 744]
Geography
Country: Nigeria


Coordinate: 7° 5' N, 4° 30' E
Coordinate basis: stated in text as range

Geography comments: coordinate is midpoint of ranges given in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: forest reserve

Substrate: ground surface

Disturbance: selective logging

MAT: 25.5

MAP: 2080.0

Habitat comments: "tropical humid high forest.. The four study sites sampled four different vegetation types, with varying degrees of human disturbance, i.e. primary forest, closed-canopy tall trees, gallery forest and degraded secondary regrowth forest"
climate data based on Richards (1939)

Methods
Life forms: birds

Sites: 4

Sampling methods: mist nets

Sample size: 386 individuals

Years: 2010, 2011

Days: 23

Nets or traps: 8

Net or trap nights: 184

Sampling comments: eight "2 x 2.6m" nets (this might be an error for 12 x 2.6 m)
2190 net hours using 8 nets for 12 hours a day = 182.5 net days and 22.8125 days (rounded to 23)

Metadata
Sample number: 1076

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-22 20:46:58

Modified: 2014-08-22 10:46:58

Abundance distribution
73 species
24 singletons
total count 386
extrapolated richness: 143.8
Fisher's α: 26.641
geometric series k: 0.9497
Hurlbert's PIE: 0.9650
Shannon's H: 3.7605
Good's u: 0.9380
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Francolinus lathami5269 g omnivore
Francolinus ahantensis2608 g
Columba unicincta5423 g frugivore
Streptopelia semitorquata11176 g frugivore-granivore
Treron australis16229 g frugivore
Turtur brehmeri4116 g granivore
Turtur tympanistria98.6 g granivore-frugivore
Corythaeola cristata1965 g frugivore
Tauraco macrorhynchusf2
Tauraco persa2306 g frugivore
Centropus leucogaster5282 g carnivore
Centropus senegalensis2169 g carnivore-insectivore
Chrysococcyx caprius1329.3 g insectivore
Cuculus clamosus3 insectivore
Caprimulgus pectoralis1
Apus apus137.6 g insectivore
Chaetura cassini2
Chaetura ussheri1
Apaloderma narina165.0 g insectivore
Alcedo quadribrachys334.9 g carnivore
Ceyx lecontei1 insectivore
Halcyon badia257.9 g carnivore
Merops muelleri522.5 g insectivore
Eurystomus gularis196.3 g insectivore
Phoeniculus bollei354.6 g insectivore
Tockus camurus9111 g insectivore
Tockus fasciatus7278 g frugivore
Tockus hartlaubi22110 g insectivore
Tropicranus albocristatus3 carnivore
Gymnobucco calvus952.6 g frugivore
Gymnobucco peli11
Pogoniulus bilineatus13.4 g frugivore-insectivore
Pogoniulus scolopaceus2 omnivore
Pogoniulus subsulphureus510.5 g omnivore
Trachyphonus purpuratus176.1 g frugivore-insectivore
Melichneutes robustus154.2 g insectivore
Prodotiscus insignis110.4 g insectivore
Campethera caroli41 insectivore
Mesopicos pyrrhogaster25
Smithornis rufolateralis620.5 g insectivore
Pitta angolensis116.8 g insectivore
Malaconotus cruentus14 insectivore
Prionops caniceps8 insectivore
Oriolus brachyrhynchus1 insectivore
Oriolus nigripennis1 insectivore
Coracina azurea146.1 g insectivore
Picathartes gymnocephalus2196 g insectivore
Andropadus gracilis1420.9 g frugivore-insectivore
Andropadus latirostris226.2 g frugivore-insectivore
Baeopogon indicator547.8 g omnivore
Bleda eximius935.7 g
"Bleda eximia"
Bleda syndactylus545.3 g insectivore
"Bleda syndactyla"
Criniger barbatus144.4 g insectivore
Criniger calurus16.7 g insectivore
Phyllastrephus icterinus1620.3 g insectivore
Alethe diademata132.6 g insectivore
Neocossyphus poensis353.1 g insectivore
Stiphrornis erythrothorax115.6 g
Stizorhina fraseri2
Phyllanthus atripennis879.6 g insectivore
Camaroptera chloronota311.4 g insectivore
Camaroptera superciliaris49.7 g insectivore
Artomyias fuliginosa4
Fraseria cinerascens123.1 g insectivore
Terpsiphone rufiventer115.1 g insectivore
Cyanomitra cyanolaema116.8 g
"Nectarinia cyanolaema"
Cyanomitra olivacea12.8 g insectivore-nectarivore
"Nectarinia olivacea"
Malimbus nitens542.6 g insectivore
Malimbus rubricollis642.2 g frugivore-insectivore
Ploceus nigricollis527.1 g folivore-insectivore
Nigrita 'bicolor'2
Nigrita fusconota1 omnivore
Spermophaga haematina123.0 g omnivore