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=1058 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1058SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=731SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1058 ORDER BY register_no ASCSELECT 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='Gerygone' AND (junior_species='palpebrosa' OR junior_species='palpebrosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerygone' AND (species='palpebrosa' OR species='palpebrosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerygone' AND (species='palpebrosa' OR species='palpebrosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerygone' AND (junior_species='palpebrosa' OR junior_species='palpebrosa')SELECT d.diet,d.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='palpebrosa' OR species='palpebrosa') 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='keri' OR junior_species='kerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='keri' OR species='kerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='keri' OR species='kerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='keri' OR junior_species='kerii')SELECT d.diet,d.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='keri' OR species='kerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='magnirostra' OR junior_species='magnirostra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sericornis' AND (species='magnirostra' OR species='magnirostra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sericornis' AND (species='magnirostra' OR species='magnirostra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sericornis' AND (junior_species='magnirostra' OR junior_species='magnirostra')SELECT d.diet,d.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='magnirostra' OR species='magnirostra') 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='Cormobates' AND (junior_species='leucophaea' OR junior_species='leucophaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cormobates' AND (species='leucophaea' OR species='leucophaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cormobates' AND (species='leucophaea' OR species='leucophaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cormobates' AND (junior_species='leucophaea' OR junior_species='leucophaea')SELECT d.diet,d.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='leucophaea' OR species='leucophaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcophaps' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcophaps' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcophaps' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcophaps' AND (junior_species='indica' OR junior_species='indica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chalcophaps' AND (species='indica' OR species='indica') 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='Lichenistomus' 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='Lichenistomus' AND (species='frenatus' OR species='frenatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lichenistomus' AND (species='frenatus' OR species='frenatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lichenistomus' 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='Lichenistomus' AND (species='frenatus' OR species='frenatus') 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='Xanthotis' AND (junior_species='macleayanus' OR junior_species='macleayanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthotis' AND (species='macleayanus' OR species='macleayanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthotis' AND (species='macleayanus' OR species='macleayanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthotis' AND (junior_species='macleayanus' OR junior_species='macleayanus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthotis' AND (species='macleayanus' OR species='macleayanus') 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='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='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='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='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='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='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='Heteromyias' AND (junior_species='cinereifrons' OR junior_species='cinereifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteromyias' AND (species='cinereifrons' OR species='cinereifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteromyias' AND (species='cinereifrons' OR species='cinereifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteromyias' AND (junior_species='cinereifrons' OR junior_species='cinereifrons')SELECT d.diet,d.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='cinereifrons' OR species='cinereifrons') 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='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='Rhipidura' AND (junior_species='albiscapa' OR junior_species='albiscapa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='albiscapa' OR species='albiscapa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='albiscapa' OR species='albiscapa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='albiscapa' OR junior_species='albiscapa')SELECT d.diet,d.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='albiscapa' OR species='albiscapa') 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='Zosterops' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zosterops' AND (species='lateralis' OR species='lateralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zosterops' AND (species='lateralis' OR species='lateralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zosterops' AND (junior_species='lateralis' OR junior_species='lateralis')SELECT d.diet,d.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='lateralis' OR species='lateralis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1058 The Ecological Register: Atherton Tableland
Atherton Tableland
Basic information
Sample name: Atherton Tableland

Reference: S. G. W. Laurance, D. Jones, D. Westcott, A. Mckeown, G. Harrington, and D. W. Hilbert. 2013. Habitat fragmentation and ecological traits influence the prevalence of avian blood parasites in a tropical rainforest landscape. PLOS One 8(10):e76227 [ER 731]
Geography
Country: Australia

State: Queensland


Coordinate: 17° 21' S, 145° 35' E
Coordinate basis: based on nearby landmark

Geography comments: sites are shown on a map as either between or east of Malanda and Tarzali (coordinate based on Malanda Falls)
elevation 600 to 900 m

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

WMT: 29.0

CMT: 16.0

MAP: 2500.0

Habitat comments: "tropical rainforest classified structurally as complex mesophyll vine forest"
combination of three forest fragments "of 20, 39 and 85 ha in area" that have been "isolated for ~50 years" plus three "continuous forest sites"

Methods
Life forms: birds

Sites: 6

Sampling methods: mist nets

Sample size: 299 individuals

Days: 12

Sampling comments: three habitat fragments and three sites in continuous forest
"Each site was netted for two consecutive days" in sequence
number and size of nets is not indicated

Metadata
Sample number: 1058

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-20 20:09:54

Modified: 2015-02-23 23:53:22

Abundance distribution
28 species
7 singletons
total count 299
extrapolated richness: 46.0
Fisher's α: 7.563
geometric series k: 0.8604
Hurlbert's PIE: 0.9074
Shannon's H: 2.7041
Good's u: 0.9767
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Gerygone mouki25.2 g insectivore
Gerygone palpebrosa17.4 g insectivore
Oreoscopus gutturalis220.0 g
Sericornis citreogularis224.2 g insectivore
Sericornis keri2712.0 g
Sericornis magnirostra39 insectivore
Psophodes olivaceus268.0 g insectivore
Cormobates leucophaea5 insectivore
Chalcophaps indica14.9 g frugivore
Acanthorhynchus tenuirostris3 omnivore
Lichenistomus frenatus1
Meliphaga lewinii12 frugivore
Xanthotis macleayanus3
Arses kaupi113.5 g
Machaerirhynchus flaviventer13.1 g
Monarcha melanopsis1522.7 g insectivore
Monarcha trivirgatus2212.7 g insectivore
Orthonyx spaldingii112.8 g
Colluricincla boweri2743.8 g
Colluricincla megarhyncha155.7 g insectivore
Pachycephala pectoralis101.6 g insectivore
Ptiloris victoriae5
Heteromyias cinereifrons5840.5 g
Tregellasia capito313.9 g insectivore
Ailuroedus melanotis6 invertivore-frugivore
Rhipidura albiscapa4 insectivore
Rhipidura rufifrons101.5 g insectivore
Zosterops lateralis11.9 g frugivore-omnivore