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=1133 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1133SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=788SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1133 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropygia' AND (junior_species='nigrirostris' OR junior_species='nigrirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macropygia' AND (species='nigrirostris' OR species='nigrirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macropygia' AND (species='nigrirostris' OR species='nigrirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macropygia' AND (junior_species='nigrirostris' OR junior_species='nigrirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macropygia' AND (species='nigrirostris' OR species='nigrirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteromyias' AND (junior_species='albospecularis' OR junior_species='albospecularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteromyias' AND (species='albospecularis' OR species='albospecularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteromyias' AND (species='albospecularis' OR species='albospecularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteromyias' AND (junior_species='albospecularis' OR junior_species='albospecularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Heteromyias' AND (species='albospecularis' OR species='albospecularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diphyllodes' AND (junior_species='magnificus' OR junior_species='magnificus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diphyllodes' AND (species='magnificus' OR species='magnificus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diphyllodes' AND (species='magnificus' OR species='magnificus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diphyllodes' AND (junior_species='magnificus' OR junior_species='magnificus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diphyllodes' AND (species='magnificus' OR species='magnificus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblyornis' AND (junior_species='macgregoriae' OR junior_species='macgregoriae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amblyornis' AND (species='macgregoriae' OR species='macgregoriae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amblyornis' AND (species='macgregoriae' OR species='macgregoriae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amblyornis' AND (junior_species='macgregoriae' OR junior_species='macgregoriae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amblyornis' AND (species='macgregoriae' OR species='macgregoriae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melilestes' AND (junior_species='megarhynchus' OR junior_species='megarhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melilestes' AND (species='megarhynchus' OR species='megarhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melilestes' AND (species='megarhynchus' OR species='megarhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melilestes' AND (junior_species='megarhynchus' OR junior_species='megarhynchus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melilestes' AND (species='megarhynchus' OR species='megarhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedistoma' AND (junior_species='iliolophum' OR junior_species='iliolophum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oedistoma' AND (species='iliolophum' OR species='iliolophum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oedistoma' AND (species='iliolophum' OR species='iliolophum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oedistoma' AND (junior_species='iliolophum' OR junior_species='iliolophum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oedistoma' AND (species='iliolophum' OR species='iliolophum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myzomela' AND (junior_species='rosenbergii' OR junior_species='rosenbergi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myzomela' AND (species='rosenbergii' OR species='rosenbergi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myzomela' AND (species='rosenbergii' OR species='rosenbergi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myzomela' AND (junior_species='rosenbergii' OR junior_species='rosenbergi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Myzomela' AND (species='rosenbergii' OR species='rosenbergi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='analoga' OR junior_species='analoga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meliphaga' AND (species='analoga' OR species='analoga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meliphaga' AND (species='analoga' OR species='analoga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='analoga' OR junior_species='analoga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meliphaga' AND (species='analoga' OR species='analoga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melipotes' AND (junior_species='fumigatus' OR junior_species='fumigatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melipotes' AND (species='fumigatus' OR species='fumigatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melipotes' AND (species='fumigatus' OR species='fumigatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melipotes' AND (junior_species='fumigatus' OR junior_species='fumigatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melipotes' AND (species='fumigatus' OR species='fumigatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptiloprora' AND (junior_species='guisei' OR junior_species='guiseii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptiloprora' AND (species='guisei' OR species='guiseii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptiloprora' AND (species='guisei' OR species='guiseii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptiloprora' AND (junior_species='guisei' OR junior_species='guiseii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptiloprora' AND (species='guisei' OR species='guiseii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melidectes' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melidectes' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melidectes' AND (species='torquatus' OR species='torquatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melidectes' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melidectes' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='longicauda' OR junior_species='longicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanocharis' AND (species='longicauda' OR species='longicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanocharis' AND (species='longicauda' OR species='longicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='longicauda' OR junior_species='longicauda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanocharis' AND (species='longicauda' OR species='longicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='versteri' OR junior_species='versterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanocharis' AND (species='versteri' OR species='versterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanocharis' AND (species='versteri' OR species='versterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='versteri' OR junior_species='versterii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanocharis' AND (species='versteri' OR species='versterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='striativentris' OR junior_species='striativentris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanocharis' AND (species='striativentris' OR species='striativentris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanocharis' AND (species='striativentris' OR species='striativentris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanocharis' AND (junior_species='striativentris' OR junior_species='striativentris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanocharis' AND (species='striativentris' OR species='striativentris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhamphocharis' AND (junior_species='crassirostris' OR junior_species='crassirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhamphocharis' AND (species='crassirostris' OR species='crassirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhamphocharis' AND (species='crassirostris' OR species='crassirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhamphocharis' AND (junior_species='crassirostris' OR junior_species='crassirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhamphocharis' AND (species='crassirostris' OR species='crassirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='novaeguineae' OR junior_species='novaeguineae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='novaeguineae' OR species='novaeguineae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='novaeguineae' OR species='novaeguineae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='novaeguineae' OR junior_species='novaeguineae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zosterops' AND (species='novaeguineae' OR species='novaeguineae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrura' AND (junior_species='trichroa' OR junior_species='trichroa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrura' AND (species='trichroa' OR species='trichroa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrura' AND (species='trichroa' OR species='trichroa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrura' AND (junior_species='trichroa' OR junior_species='trichroa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrura' AND (species='trichroa' OR species='trichroa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrura' AND (junior_species='papuana' OR junior_species='papuana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrura' AND (species='papuana' OR species='papuana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrura' AND (species='papuana' OR species='papuana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrura' AND (junior_species='papuana' OR junior_species='papuana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrura' AND (species='papuana' OR species='papuana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilinopus' AND (junior_species='rivoli' OR junior_species='rivolii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilinopus' AND (species='rivoli' OR species='rivolii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilinopus' AND (species='rivoli' OR species='rivolii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilinopus' AND (junior_species='rivoli' OR junior_species='rivolii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptilinopus' AND (species='rivoli' OR species='rivolii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallicolumba' AND (junior_species='beccarii' OR junior_species='beccari')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallicolumba' AND (species='beccarii' OR species='beccari') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallicolumba' AND (species='beccarii' OR species='beccari')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallicolumba' AND (junior_species='beccarii' OR junior_species='beccari')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gallicolumba' AND (species='beccarii' OR species='beccari') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='meyerii' OR junior_species='meyeri')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='meyerii' OR species='meyeri') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='meyerii' OR species='meyeri')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='meyerii' OR junior_species='meyeri')SELECT d.diet,d.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='meyerii' OR species='meyeri') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amalocichla' AND (junior_species='incerta' OR junior_species='incerta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amalocichla' AND (species='incerta' OR species='incerta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amalocichla' AND (species='incerta' OR species='incerta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amalocichla' AND (junior_species='incerta' OR junior_species='incerta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amalocichla' AND (species='incerta' OR species='incerta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupetes' AND (junior_species='leucostictus' OR junior_species='leucostictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupetes' AND (species='leucostictus' OR species='leucostictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupetes' AND (species='leucostictus' OR species='leucostictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupetes' AND (junior_species='leucostictus' OR junior_species='leucostictus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eupetes' AND (species='leucostictus' OR species='leucostictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clytomyias' 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='Clytomyias' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clytomyias' AND (species='insignis' OR species='insignis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clytomyias' 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='Clytomyias' AND (species='insignis' OR species='insignis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='perspicillatus' OR junior_species='perspicillatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='perspicillatus' OR species='perspicillatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='perspicillatus' OR species='perspicillatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='perspicillatus' OR junior_species='perspicillatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sericornis' AND (species='perspicillatus' OR species='perspicillatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='papuensis' OR junior_species='papuensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='papuensis' OR species='papuensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='papuensis' OR species='papuensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='papuensis' OR junior_species='papuensis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sericornis' AND (species='papuensis' OR species='papuensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='nouhuysi' OR junior_species='nouhuysii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='nouhuysi' OR species='nouhuysii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='nouhuysi' OR species='nouhuysii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='nouhuysi' OR junior_species='nouhuysii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sericornis' AND (species='nouhuysi' OR species='nouhuysii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='trivirgatus' OR junior_species='trivirgatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='trivirgatus' OR species='trivirgatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='trivirgatus' OR species='trivirgatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='trivirgatus' OR junior_species='trivirgatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phylloscopus' AND (species='trivirgatus' OR species='trivirgatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='brachyrhyncha' OR junior_species='brachyrhyncha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='brachyrhyncha' OR species='brachyrhyncha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='brachyrhyncha' OR species='brachyrhyncha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='brachyrhyncha' OR junior_species='brachyrhyncha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhipidura' AND (species='brachyrhyncha' OR species='brachyrhyncha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='rufiventris' OR species='rufiventris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='rufiventris' OR species='rufiventris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='rufiventris' OR junior_species='rufiventris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhipidura' AND (species='rufiventris' OR species='rufiventris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugerygone' AND (junior_species='rubra' OR junior_species='rubra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eugerygone' AND (species='rubra' OR species='rubra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eugerygone' AND (species='rubra' OR species='rubra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eugerygone' AND (junior_species='rubra' OR junior_species='rubra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eugerygone' AND (species='rubra' OR species='rubra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microeca' AND (junior_species='papuana' OR junior_species='papuana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microeca' AND (species='papuana' OR species='papuana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microeca' AND (species='papuana' OR species='papuana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microeca' AND (junior_species='papuana' OR junior_species='papuana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Microeca' AND (species='papuana' OR species='papuana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tregellasia' AND (junior_species='leucops' OR junior_species='leucops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tregellasia' AND (species='leucops' OR species='leucops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tregellasia' AND (species='leucops' OR species='leucops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tregellasia' AND (junior_species='leucops' OR junior_species='leucops')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tregellasia' AND (species='leucops' OR species='leucops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peneothello' AND (junior_species='cyanus' OR junior_species='cyanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peneothello' AND (species='cyanus' OR species='cyanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peneothello' AND (species='cyanus' OR species='cyanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peneothello' AND (junior_species='cyanus' OR junior_species='cyanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peneothello' AND (species='cyanus' OR species='cyanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='leucostigma' OR junior_species='leucostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='leucostigma' OR species='leucostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='leucostigma' OR species='leucostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='leucostigma' OR junior_species='leucostigma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycephala' AND (species='leucostigma' OR species='leucostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='soror' OR junior_species='soror')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='soror' OR species='soror') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='soror' OR species='soror')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='soror' OR junior_species='soror')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycephala' AND (species='soror' OR species='soror') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='schlegelii' OR junior_species='schlegeli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='schlegelii' OR species='schlegeli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='schlegelii' OR species='schlegeli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='schlegelii' OR junior_species='schlegeli')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycephala' AND (species='schlegelii' OR species='schlegeli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='megarhyncha' OR junior_species='megarhyncha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colluricincla' AND (species='megarhyncha' OR species='megarhyncha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colluricincla' AND (species='megarhyncha' OR species='megarhyncha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='megarhyncha' OR junior_species='megarhyncha')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colluricincla' AND (species='megarhyncha' OR species='megarhyncha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitohui' AND (junior_species='dichrous' OR junior_species='dichrous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitohui' AND (species='dichrous' OR species='dichrous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitohui' AND (species='dichrous' OR species='dichrous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitohui' AND (junior_species='dichrous' OR junior_species='dichrous')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pitohui' AND (species='dichrous' OR species='dichrous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitohui' AND (junior_species='nigrescens' OR junior_species='nigrescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitohui' AND (species='nigrescens' OR species='nigrescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitohui' AND (species='nigrescens' OR species='nigrescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitohui' AND (junior_species='nigrescens' OR junior_species='nigrescens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pitohui' AND (species='nigrescens' OR species='nigrescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailuroedus' AND (junior_species='melanotis' OR junior_species='melanotis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ailuroedus' AND (species='melanotis' OR species='melanotis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ailuroedus' AND (species='melanotis' OR species='melanotis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailuroedus' AND (junior_species='melanotis' OR junior_species='melanotis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ailuroedus' AND (species='melanotis' OR species='melanotis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Climacteris' AND (junior_species='placens' OR junior_species='placens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Climacteris' AND (species='placens' OR species='placens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Climacteris' AND (species='placens' OR species='placens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Climacteris' AND (junior_species='placens' OR junior_species='placens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Climacteris' AND (species='placens' OR species='placens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxorhamphus' AND (junior_species='poliopterus' OR junior_species='poliopterus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Toxorhamphus' AND (species='poliopterus' OR species='poliopterus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Toxorhamphus' AND (species='poliopterus' OR species='poliopterus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Toxorhamphus' AND (junior_species='poliopterus' OR junior_species='poliopterus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Toxorhamphus' AND (species='poliopterus' OR species='poliopterus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreocharis' AND (junior_species='arfaki' OR junior_species='arfakii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreocharis' AND (species='arfaki' OR species='arfakii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreocharis' AND (species='arfaki' OR species='arfakii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreocharis' AND (junior_species='arfaki' OR junior_species='arfakii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oreocharis' AND (species='arfaki' OR species='arfakii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='atrifrons' OR junior_species='atrifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='atrifrons' OR species='atrifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='atrifrons' OR species='atrifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='atrifrons' OR junior_species='atrifrons')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zosterops' AND (species='atrifrons' OR species='atrifrons') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1133 The Ecological Register: Wau
Wau
Basic information
Sample name: Wau

Reference: H. I. Jones. 1985. Hematozoa from forest birds in Papua New Guinea. Journal of Wildlife Diseases 21(1):7-10 [ER 788]
Geography
Country: Papua New Guinea

State: Morobe


Coordinate: 7° 22' S, 146° 40' E
Coordinate basis: stated in text

Geography comments: "on Mt. Kaindi (2,362 m) and Mt. Missim (2,839) south and northeast of Wau" and specifically at four sites on Mt. Kaindi and one on Mt. Missim; altitude is the median of the values for the five sites

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 22.0

MAP: 1900.0

Habitat comments: montane forest; one site was in a "cultivated ground and coffee plantation" habitat
climate data are for Wau and are from Allison et al. (1993)

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 141 individuals

Years: 1981 - 1982

Days: 32

Sampling comments: number of nets unclear; nets were open for five hours a day

Metadata
Sample number: 1133

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-30 14:54:36

Modified: 2014-08-30 04:54:36

Abundance distribution
45 species
17 singletons
total count 141
extrapolated richness: 102.2
Fisher's α: 22.837
geometric series k: 0.9389
Hurlbert's PIE: 0.9599
Shannon's H: 3.4999
Good's u: 0.8800
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Macropygia nigrirostris190.1 g frugivore
Heteromyias albospecularis1
Diphyllodes magnificus2
Amblyornis macgregoriae5 frugivore-insectivore
Melilestes megarhynchus2 frugivore-insectivore
Oedistoma iliolophum1
Myzomela rosenbergii1
Meliphaga analoga8
Melipotes fumigatus3 frugivore
Ptiloprora guisei3
Melidectes torquatus1 nectarivore-invertivore
Melanocharis longicauda111.0 g
Melanocharis versteri711.9 g
Melanocharis striativentris716.1 g
Rhamphocharis crassirostris3 frugivore
Zosterops novaeguineae712.5 g omnivore
Erythrura trichroa314.0 g
Erythrura papuana319.4 g
Ptilinopus rivoli1149 g frugivore
Gallicolumba beccarii19.7 g
Chrysococcyx meyerii117.8 g insectivore
Amalocichla incerta132.7 g
Eupetes leucostictus2
Clytomyias insignis112.4 g
Sericornis perspicillatus29.0 g insectivore
Sericornis papuensis111.2 g
Sericornis nouhuysi517.1 g insectivore
Phylloscopus trivirgatus49.0 g insectivore
Rhipidura brachyrhyncha110.1 g
Rhipidura rufiventris112.0 g insectivore
Eugerygone rubra28.4 g
Microeca papuana414.4 g
Tregellasia leucops44.2 g insectivore
Peneothello cyanus426.9 g insectivore
Pachycephala leucostigma3
Pachycephala soror324.8 g insectivore
Pachycephala schlegelii522.7 g insectivore
Colluricincla megarhyncha75.7 g insectivore
Pitohui dichrous292.9 g insectivore
Pitohui nigrescens176.9 g
Ailuroedus melanotis1 invertivore-frugivore
Climacteris placens1
Toxorhamphus poliopterus1612.4 g nectarivore-invertivore
Oreocharis arfaki419.7 g
Zosterops atrifrons410.0 g