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=1113 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1113SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=770SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1113 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysococcyx' AND (species='lucidus' OR species='lucidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysococcyx' AND (species='lucidus' OR species='lucidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysococcyx' AND (junior_species='lucidus' OR junior_species='lucidus')SELECT d.diet,d.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='lucidus' OR species='lucidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcedo' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcedo' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcedo' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT d.diet,d.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='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanysiptera' AND (junior_species='sylvia' OR junior_species='sylvia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tanysiptera' AND (species='sylvia' OR species='sylvia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tanysiptera' AND (species='sylvia' OR species='sylvia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tanysiptera' AND (junior_species='sylvia' OR junior_species='sylvia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tanysiptera' AND (species='sylvia' OR species='sylvia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pitta' AND (species='versicolor' OR species='versicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitta' AND (species='versicolor' OR species='versicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' AND (junior_species='versicolor' OR junior_species='versicolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pitta' AND (species='versicolor' OR species='versicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cormobates' AND (junior_species='leucophaeus' OR junior_species='leucophaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cormobates' AND (species='leucophaeus' OR species='leucophaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cormobates' AND (species='leucophaeus' OR species='leucophaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cormobates' AND (junior_species='leucophaeus' OR junior_species='leucophaeus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cormobates' AND (species='leucophaeus' OR species='leucophaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreoscopus' AND (junior_species='gutturalis' OR junior_species='gutturalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreoscopus' AND (species='gutturalis' OR species='gutturalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreoscopus' AND (species='gutturalis' OR species='gutturalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreoscopus' AND (junior_species='gutturalis' OR junior_species='gutturalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oreoscopus' AND (species='gutturalis' OR species='gutturalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='citreogularis' OR junior_species='citreogularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='citreogularis' OR species='citreogularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='citreogularis' OR species='citreogularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='citreogularis' OR junior_species='citreogularis')SELECT d.diet,d.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='citreogularis' OR species='citreogularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='magnirostris' OR junior_species='magnirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='magnirostris' OR species='magnirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='magnirostris' OR species='magnirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='magnirostris' OR junior_species='magnirostris')SELECT d.diet,d.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='magnirostris' OR species='magnirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerygone' AND (junior_species='mouki' OR junior_species='moukii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerygone' AND (species='mouki' OR species='moukii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerygone' AND (species='mouki' OR species='moukii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerygone' AND (junior_species='mouki' OR junior_species='moukii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gerygone' AND (species='mouki' OR species='moukii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='katherina' OR junior_species='katherina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthiza' AND (species='katherina' OR species='katherina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthiza' AND (species='katherina' OR species='katherina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthiza' AND (junior_species='katherina' OR junior_species='katherina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acanthiza' AND (species='katherina' OR species='katherina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='lewinii' OR junior_species='lewini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meliphaga' AND (species='lewinii' OR species='lewini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meliphaga' AND (species='lewinii' OR species='lewini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meliphaga' AND (junior_species='lewinii' OR junior_species='lewini')SELECT d.diet,d.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='lewinii' OR species='lewini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lichenostomus' AND (junior_species='frenatus' OR junior_species='frenatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lichenostomus' AND (species='frenatus' OR species='frenatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lichenostomus' AND (species='frenatus' OR species='frenatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lichenostomus' AND (junior_species='frenatus' OR junior_species='frenatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lichenostomus' AND (species='frenatus' OR species='frenatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylidonyris' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylidonyris' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylidonyris' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylidonyris' AND (junior_species='nigra' OR junior_species='nigra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phylidonyris' AND (species='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthorhynchus' AND (junior_species='tenuirostris' OR junior_species='tenuirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthorhynchus' AND (species='tenuirostris' OR species='tenuirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthorhynchus' AND (species='tenuirostris' OR species='tenuirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthorhynchus' AND (junior_species='tenuirostris' OR junior_species='tenuirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acanthorhynchus' AND (species='tenuirostris' OR species='tenuirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tregellasia' AND (junior_species='capito' OR junior_species='capito')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tregellasia' AND (species='capito' OR species='capito') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tregellasia' AND (species='capito' OR species='capito')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tregellasia' AND (junior_species='capito' OR junior_species='capito')SELECT d.diet,d.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='capito' OR species='capito') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilodryas' AND (junior_species='albispecularis' OR junior_species='albispecularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecilodryas' AND (species='albispecularis' OR species='albispecularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecilodryas' AND (species='albispecularis' OR species='albispecularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecilodryas' AND (junior_species='albispecularis' OR junior_species='albispecularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poecilodryas' AND (species='albispecularis' OR species='albispecularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthonyx' AND (junior_species='spaldingii' OR junior_species='spaldingi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthonyx' AND (species='spaldingii' OR species='spaldingi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthonyx' AND (species='spaldingii' OR species='spaldingi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthonyx' AND (junior_species='spaldingii' OR junior_species='spaldingi')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthonyx' AND (species='spaldingii' OR species='spaldingi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psophodes' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psophodes' AND (species='olivaceus' OR species='olivaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psophodes' AND (species='olivaceus' OR species='olivaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psophodes' AND (junior_species='olivaceus' OR junior_species='olivaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Psophodes' AND (species='olivaceus' OR species='olivaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='pectoralis' OR junior_species='pectoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycephala' AND (species='pectoralis' OR species='pectoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycephala' AND (species='pectoralis' OR species='pectoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycephala' AND (junior_species='pectoralis' OR junior_species='pectoralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pachycephala' AND (species='pectoralis' OR species='pectoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='boweri' OR junior_species='bowerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colluricincla' AND (species='boweri' OR species='bowerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colluricincla' AND (species='boweri' OR species='bowerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colluricincla' AND (junior_species='boweri' OR junior_species='bowerii')SELECT d.diet,d.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='boweri' OR species='bowerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerirhynchus' AND (junior_species='flaviventer' OR junior_species='flaviventer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Machaerirhynchus' AND (species='flaviventer' OR species='flaviventer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Machaerirhynchus' AND (species='flaviventer' OR species='flaviventer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Machaerirhynchus' AND (junior_species='flaviventer' OR junior_species='flaviventer')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Machaerirhynchus' AND (species='flaviventer' OR species='flaviventer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' AND (junior_species='melanopsis' OR junior_species='melanopsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Monarcha' AND (species='melanopsis' OR species='melanopsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monarcha' AND (species='melanopsis' OR species='melanopsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' AND (junior_species='melanopsis' OR junior_species='melanopsis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Monarcha' AND (species='melanopsis' OR species='melanopsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' 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='Monarcha' AND (species='trivirgatus' OR species='trivirgatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Monarcha' AND (species='trivirgatus' OR species='trivirgatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Monarcha' 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='Monarcha' AND (species='trivirgatus' OR species='trivirgatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arses' AND (junior_species='kaupi' OR junior_species='kaupii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arses' AND (species='kaupi' OR species='kaupii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arses' AND (species='kaupi' OR species='kaupii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arses' AND (junior_species='kaupi' OR junior_species='kaupii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Arses' AND (species='kaupi' OR species='kaupii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='rufifrons' OR junior_species='rufifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='rufifrons' OR species='rufifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='rufifrons' OR species='rufifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='rufifrons' OR junior_species='rufifrons')SELECT d.diet,d.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='rufifrons' OR species='rufifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' 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='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' 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='Rhipidura' AND (species='fuliginosa' OR species='fuliginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptiloris' AND (junior_species='victoriae' OR junior_species='victoriae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptiloris' AND (species='victoriae' OR species='victoriae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptiloris' AND (species='victoriae' OR species='victoriae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptiloris' AND (junior_species='victoriae' OR junior_species='victoriae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptiloris' AND (species='victoriae' OR species='victoriae') 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='Scenopoeetes' AND (junior_species='dentirostris' OR junior_species='dentirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scenopoeetes' AND (species='dentirostris' OR species='dentirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scenopoeetes' AND (species='dentirostris' OR species='dentirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scenopoeetes' AND (junior_species='dentirostris' OR junior_species='dentirostris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scenopoeetes' AND (species='dentirostris' OR species='dentirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionodura' AND (junior_species='newtoniana' OR junior_species='newtoniana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionodura' AND (species='newtoniana' OR species='newtoniana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prionodura' AND (species='newtoniana' OR species='newtoniana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionodura' AND (junior_species='newtoniana' OR junior_species='newtoniana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Prionodura' AND (species='newtoniana' OR species='newtoniana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilonorhynchus' AND (junior_species='violaceus' OR junior_species='violaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilonorhynchus' AND (species='violaceus' OR species='violaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilonorhynchus' AND (species='violaceus' OR species='violaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilonorhynchus' AND (junior_species='violaceus' OR junior_species='violaceus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptilonorhynchus' AND (species='violaceus' OR species='violaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='hirundinaceum' OR junior_species='hirundinaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicaeum' AND (species='hirundinaceum' OR species='hirundinaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicaeum' AND (species='hirundinaceum' OR species='hirundinaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicaeum' AND (junior_species='hirundinaceum' OR junior_species='hirundinaceum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dicaeum' AND (species='hirundinaceum' OR species='hirundinaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='lunulata' OR junior_species='lunulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zoothera' AND (species='lunulata' OR species='lunulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zoothera' AND (species='lunulata' OR species='lunulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='lunulata' OR junior_species='lunulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zoothera' AND (species='lunulata' OR species='lunulata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1113 The Ecological Register: Paluma Range
Paluma Range
Basic information
Sample name: Paluma Range

Reference: C. B. Frith and D. W. Frith. 2005. A long-term bird banding study in upland tropical rainforest, Paluma Range, north-eastern Queensland with notes on breeding. Corella 29(2):25-48 [ER 770]
Geography
Country: Australia

State: Queensland


Coordinate: 19° 0' S, 146° 10' E
Coordinate basis: stated in text

Geography comments: "approximately 80 kilometres north of Townsville... seven kilometres from the township of Paluma"
elevation 850 to 950 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 23.2

CMT: 13.2

MAP: 2300.0

Habitat comments: "upland rainforest"
CMT and WMT are based on monthly mean min/max values given in text; MAP estimated from figure

Methods
Life forms: birds

Sites: 1

Sampling methods: mist nets

Sample size: 1120 individuals

Years: 1978 - 1990, 1995, 1997

Sampling comments: "two [contiguous] 50 hectare plots" with "most netting" carried out in site SA1 (11 net sites) and some in SA2 (four net sites); number of netting days is unclear and effort was variable from year to year

Metadata
Sample number: 1113

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-27 15:50:29

Modified: 2014-08-27 05:50:29

Abundance distribution
33 species
6 singletons
total count 1120
extrapolated richness: 45.1
Fisher's α: 6.378
geometric series k: 0.8400
Hurlbert's PIE: 0.8989
Shannon's H: 2.7068
Good's u: 0.9946
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Chrysococcyx lucidus14.9 g insectivore
Alcedo pusilla113.3 g
Tanysiptera sylvia149.6 g
Pitta versicolor38.9 g insectivore-invertivore
Cormobates leucophaeus1922.0 g insectivore
Oreoscopus gutturalis5820.0 g
Sericornis citreogularis1134.2 g insectivore
Sericornis magnirostris1309.8 g insectivore
Gerygone mouki85.2 g insectivore
Acanthiza katherina307.2 g
Meliphaga lewinii6 frugivore
Lichenostomus frenatus60
Phylidonyris nigra1 nectarivore
Acanthorhynchus tenuirostris22 omnivore
Tregellasia capito3213.9 g insectivore
Poecilodryas albispecularis265
Orthonyx spaldingii912.8 g
Psophodes olivaceus768.0 g insectivore
Pachycephala pectoralis281.6 g insectivore
Colluricincla boweri5743.8 g
Machaerirhynchus flaviventer33.1 g
Monarcha melanopsis322.7 g insectivore
Monarcha trivirgatus1912.7 g insectivore
Arses kaupi113.5 g
Rhipidura rufifrons631.5 g insectivore
Rhipidura fuliginosa642.7 g insectivore
Ptiloris victoriae5
Ailuroedus melanotis57 invertivore-frugivore
Scenopoeetes dentirostris23
Prionodura newtoniana22
Ptilonorhynchus violaceus2 frugivore
Dicaeum hirundinaceum19.3 g frugivore-omnivore
Zoothera lunulata6130 g insectivore