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=1046 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1046SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=723SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1046 ORDER BY register_no ASCSELECT 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='Pycnonotus' 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='Pycnonotus' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnonotus' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' 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='Pycnonotus' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' 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='Pycnonotus' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnonotus' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnonotus' 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='Pycnonotus' AND (species='virens' OR species='virens') 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='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='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='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='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='Euplectes' AND (junior_species='afer' OR junior_species='afer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplectes' AND (species='afer' OR species='afer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplectes' AND (species='afer' OR species='afer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='afer' OR junior_species='afer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euplectes' AND (species='afer' OR species='afer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='ardens' OR junior_species='ardens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplectes' AND (species='ardens' OR species='ardens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplectes' AND (species='ardens' OR species='ardens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='ardens' OR junior_species='ardens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euplectes' AND (species='ardens' OR species='ardens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='macrourus' OR junior_species='macrourus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplectes' AND (species='macrourus' OR species='macrourus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplectes' AND (species='macrourus' OR species='macrourus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplectes' AND (junior_species='macrourus' OR junior_species='macrourus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euplectes' AND (species='macrourus' OR species='macrourus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='aurantius' OR junior_species='aurantius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ploceus' AND (species='aurantius' OR species='aurantius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ploceus' AND (species='aurantius' OR species='aurantius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ploceus' AND (junior_species='aurantius' OR junior_species='aurantius')SELECT d.diet,d.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='aurantius' OR species='aurantius') 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='Quelea' AND (junior_species='erythrops' OR junior_species='erythrops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quelea' AND (species='erythrops' OR species='erythrops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quelea' AND (species='erythrops' OR species='erythrops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quelea' AND (junior_species='erythrops' OR junior_species='erythrops')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Quelea' AND (species='erythrops' OR species='erythrops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='astrild' OR junior_species='astrild')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Estrilda' AND (species='astrild' OR species='astrild') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Estrilda' AND (species='astrild' OR species='astrild')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='astrild' OR junior_species='astrild')SELECT d.diet,d.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='astrild' OR species='astrild') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='atricapilla' OR junior_species='atricapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Estrilda' AND (species='atricapilla' OR species='atricapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Estrilda' AND (species='atricapilla' OR species='atricapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='atricapilla' OR junior_species='atricapilla')SELECT d.diet,d.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='atricapilla' OR species='atricapilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypargos' AND (junior_species='nitidulus' OR junior_species='nitidulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypargos' AND (species='nitidulus' OR species='nitidulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypargos' AND (species='nitidulus' OR species='nitidulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypargos' AND (junior_species='nitidulus' OR junior_species='nitidulus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypargos' AND (species='nitidulus' OR species='nitidulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' 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='Lonchura' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lonchura' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lonchura' 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='Lonchura' AND (species='bicolor' OR species='bicolor') 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='Pyrenestes' AND (junior_species='ostrinus' OR junior_species='ostrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrenestes' AND (species='ostrinus' OR species='ostrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrenestes' AND (species='ostrinus' OR species='ostrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrenestes' AND (junior_species='ostrinus' OR junior_species='ostrinus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pyrenestes' AND (species='ostrinus' OR species='ostrinus') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrodipteryx' AND (junior_species='vexillarius' OR junior_species='vexillarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrodipteryx' AND (species='vexillarius' OR species='vexillarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrodipteryx' AND (species='vexillarius' OR species='vexillarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrodipteryx' AND (junior_species='vexillarius' OR junior_species='vexillarius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macrodipteryx' AND (species='vexillarius' OR species='vexillarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='afer' OR junior_species='afer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turtur' AND (species='afer' OR species='afer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turtur' AND (species='afer' OR species='afer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turtur' AND (junior_species='afer' OR junior_species='afer')SELECT d.diet,d.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='afer' OR species='afer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' 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='Alcedo' AND (species='leucogaster' OR species='leucogaster') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcedo' AND (species='leucogaster' OR species='leucogaster')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' 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='Alcedo' AND (species='leucogaster' OR species='leucogaster') 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='Halcyon' 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='Halcyon' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Halcyon' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Halcyon' 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='Halcyon' AND (species='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='variegatus' OR junior_species='variegatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Merops' AND (species='variegatus' OR species='variegatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Merops' AND (species='variegatus' OR species='variegatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Merops' AND (junior_species='variegatus' OR junior_species='variegatus')SELECT d.diet,d.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='variegatus' OR species='variegatus') 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='Chrysococcyx' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT d.diet,d.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='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='klaas' OR junior_species='klaas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='klaas' OR species='klaas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='klaas' OR species='klaas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='klaas' OR junior_species='klaas')SELECT d.diet,d.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='klaas' OR species='klaas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amandava' 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='Amandava' AND (species='subflava' OR species='subflava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amandava' AND (species='subflava' OR species='subflava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amandava' 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='Amandava' AND (species='subflava' OR species='subflava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='melpoda' OR junior_species='melpoda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Estrilda' AND (species='melpoda' OR species='melpoda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Estrilda' AND (species='melpoda' OR species='melpoda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Estrilda' AND (junior_species='melpoda' OR junior_species='melpoda')SELECT d.diet,d.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='melpoda' OR species='melpoda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='mozambicus' OR junior_species='mozambicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serinus' AND (species='mozambicus' OR species='mozambicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serinus' AND (species='mozambicus' OR species='mozambicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serinus' AND (junior_species='mozambicus' OR junior_species='mozambicus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Serinus' AND (species='mozambicus' OR species='mozambicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='semirufa' OR junior_species='semirufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hirundo' AND (species='semirufa' OR species='semirufa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='semirufa' OR species='semirufa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' AND (junior_species='semirufa' OR junior_species='semirufa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hirundo' AND (species='semirufa' OR species='semirufa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' 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='Hirundo' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hirundo' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hirundo' 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='Hirundo' AND (species='senegalensis' OR species='senegalensis') 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='Cossypha' AND (junior_species='niveicapilla' OR junior_species='niveicapilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cossypha' AND (species='niveicapilla' OR species='niveicapilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cossypha' AND (species='niveicapilla' OR species='niveicapilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cossypha' AND (junior_species='niveicapilla' OR junior_species='niveicapilla')SELECT d.diet,d.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='niveicapilla' OR species='niveicapilla') 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='Muscicapa' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscicapa' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscicapa' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='striata' OR junior_species='striata')SELECT d.diet,d.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='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myioparus' AND (junior_species='plumbeus' OR junior_species='plumbeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myioparus' AND (species='plumbeus' OR species='plumbeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myioparus' AND (species='plumbeus' OR species='plumbeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myioparus' AND (junior_species='plumbeus' OR junior_species='plumbeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myioparus' AND (species='plumbeus' OR species='plumbeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platysteira' 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='Platysteira' AND (species='castanea' OR species='castanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platysteira' AND (species='castanea' OR species='castanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platysteira' 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='Platysteira' AND (species='castanea' OR species='castanea') 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='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='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='Acrocephalus' AND (junior_species='rufescens' OR junior_species='rufescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acrocephalus' AND (species='rufescens' OR species='rufescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acrocephalus' AND (species='rufescens' OR species='rufescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acrocephalus' AND (junior_species='rufescens' OR junior_species='rufescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acrocephalus' AND (species='rufescens' OR species='rufescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='sharpii' OR junior_species='sharpi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apalis' AND (species='sharpii' OR species='sharpi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apalis' AND (species='sharpii' OR species='sharpi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apalis' AND (junior_species='sharpii' OR junior_species='sharpi')SELECT d.diet,d.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='sharpii' OR species='sharpi') 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='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='Cisticola' AND (junior_species='erythrops' OR junior_species='erythrops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='erythrops' OR species='erythrops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='erythrops' OR species='erythrops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='erythrops' OR junior_species='erythrops')SELECT d.diet,d.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='erythrops' OR species='erythrops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='galactotes' OR junior_species='galactotes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cisticola' AND (species='galactotes' OR species='galactotes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cisticola' AND (species='galactotes' OR species='galactotes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cisticola' AND (junior_species='galactotes' OR junior_species='galactotes')SELECT d.diet,d.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='galactotes' OR species='galactotes') 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='Sylvietta' 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='Sylvietta' AND (species='virens' OR species='virens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sylvietta' AND (species='virens' OR species='virens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvietta' 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='Sylvietta' AND (species='virens' OR species='virens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='batesi' OR junior_species='batesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnyris' AND (species='batesi' OR species='batesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnyris' AND (species='batesi' OR species='batesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='batesi' OR junior_species='batesii')SELECT d.diet,d.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='batesi' OR species='batesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cinnyris' AND (species='cupreus' OR species='cupreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cinnyris' AND (species='cupreus' OR species='cupreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cinnyris' AND (junior_species='cupreus' OR junior_species='cupreus')SELECT d.diet,d.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='cupreus' OR species='cupreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anabathmis' AND (junior_species='reichenbachii' OR junior_species='reichenbachi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anabathmis' AND (species='reichenbachii' OR species='reichenbachi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anabathmis' AND (species='reichenbachii' OR species='reichenbachi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anabathmis' AND (junior_species='reichenbachii' OR junior_species='reichenbachi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anabathmis' AND (species='reichenbachii' OR species='reichenbachi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocichia' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocichia' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocichia' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocichia' AND (junior_species='simplex' OR junior_species='simplex')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chlorocichia' AND (species='simplex' OR species='simplex') 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='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='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='Lamprotornis' AND (junior_species='splendidus' OR junior_species='splendidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lamprotornis' AND (species='splendidus' OR species='splendidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lamprotornis' AND (species='splendidus' OR species='splendidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lamprotornis' AND (junior_species='splendidus' OR junior_species='splendidus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lamprotornis' AND (species='splendidus' OR species='splendidus') 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='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 * FROM register WHERE sample_no=1046 The Ecological Register: Nyong River
Nyong River
Basic information
Sample name: Nyong River

Reference: C. E. Kirkpatrick and T. B. Smith. 1988. Blood parasites of birds in Cameroon. Journal of Parasitology 74(6):1009-1013 [ER 723]
Geography
Country: Cameroon


Coordinate: 3° 14' N, 12° 11' E
Coordinate basis: stated in text

Geography comments: "130 km southeast of Yaoundé"

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 25.0

CMT: 21.7

MAP: 1381.0

Habitat comments: "seasonally flooded swamp forest"
climate data based on station 64950 (Yaoundé airport)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 333 individuals

Years: 1986

Metadata
Sample number: 1046

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-17 15:37:33

Modified: 2014-08-17 05:37:33

Abundance distribution
65 species
20 singletons
total count 333
extrapolated richness: 126.1
Fisher's α: 24.118
geometric series k: 0.9451
Hurlbert's PIE: 0.9593
Shannon's H: 3.6411
Good's u: 0.9401
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Turtur tympanistria38.6 g granivore-frugivore
Pycnonotus gracilis8
Pycnonotus virens37
Hylia prasina114.1 g insectivore
Prinia bairdii513.4 g insectivore
Hedydipna collaris22.6 g nectarivore
"Anthreptes collaris"
Cinnyris chloropygius36.2 g
"Nectarinia chloropygia"
Cyanomitra olivacea92.8 g insectivore-nectarivore
"Nectarinia olivacea"
Euplectes afer1414.7 g
Euplectes ardens64.8 g granivore
Euplectes macrourus525.1 g granivore
Ploceus aurantius2023.0 g insectivore
Ploceus nigerrimus938.5 g omnivore
Ploceus nigricollis327.1 g folivore-insectivore
Quelea erythrops1121.1 g granivore
Estrilda astrild122.0 g granivore
Estrilda atricapilla57.8 g
Hypargos nitidulus2
Lonchura 'bicolor'7
Lonchura cucullata33.0 g granivore
Pyrenestes ostrinus324.9 g
Spermophaga haematina1123.0 g omnivore
Macrodipteryx vexillarius167.7 g
Turtur afer265.6 g granivore
Alcedo leucogaster114.5 g carnivore
Ispidina picta123.8 g piscivore
"Ceyx pictus"
Halcyon senegalensis2 carnivore
Merops variegatus622.5 g
Chrysococcyx caprius229.3 g insectivore
Chrysococcyx cupreus137.7 g insectivore
Chrysococcyx klaas126.2 g insectivore
Amandava subflava87.3 g granivore
Estrilda melpoda37.6 g granivore
Serinus mozambicus13.6 g granivore
Hirundo semirufa330.1 g
Hirundo senegalensis147.4 g
Artomyias fuliginosa1
Cossypha niveicapilla136.7 g insectivore
Fraseria cinerascens123.1 g insectivore
Muscicapa striata215.9 g insectivore
Myioparus plumbeus112.8 g
Platysteira castanea314.3 g
Platysteira cyanea314.6 g insectivore
Terpsiphone rufiventer115.1 g insectivore
Terpsiphone viridis113.8 g insectivore
Acrocephalus rufescens223.9 g
Apalis sharpii19.1 g insectivore
Camaroptera brachyura121.6 g insectivore
Camaroptera superciliaris39.7 g insectivore
Cisticola erythrops115.7 g insectivore
Cisticola galactotes72.2 g
Prinia leucopogon611.7 g insectivore
Sylvietta virens68.4 g insectivore
Cinnyris batesi36.3 g
"Nectarinia batesi"
Cinnyris cupreus13.1 g nectarivore
"Nectarinia cuprea"
Anabathmis reichenbachii111.4 g
"Nectarinia reichenbachii"
Chlorocichia simplex2
Nicator chloris149.1 g insectivore
Andropadus latirostris326.2 g frugivore-insectivore
Pycnonotus barbatus15.1 g frugivore-insectivore
Lamprotornis splendidus1
Pogoniulus bilineatus63.4 g frugivore-insectivore
Pogoniulus scolopaceus5 omnivore
Pogoniulus subsulphureus210.5 g omnivore
Campethera caroli3 insectivore