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=2922 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2922SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2746SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2922 ORDER BY register_no ASCSELECT 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='Glaucidium' AND (junior_species='cuculoides' OR junior_species='cuculoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucidium' AND (species='cuculoides' OR species='cuculoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucidium' AND (species='cuculoides' OR species='cuculoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucidium' AND (junior_species='cuculoides' OR junior_species='cuculoides')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='Glaucidium' AND (species='cuculoides' OR species='cuculoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpactes' AND (junior_species='erythrocephalus' OR junior_species='erythrocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpactes' AND (species='erythrocephalus' OR species='erythrocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpactes' AND (species='erythrocephalus' OR species='erythrocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpactes' AND (junior_species='erythrocephalus' OR junior_species='erythrocephalus')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='Harpactes' AND (species='erythrocephalus' OR species='erythrocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serilophus' AND (junior_species='lunatus' OR junior_species='lunatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Serilophus' AND (species='lunatus' OR species='lunatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serilophus' AND (species='lunatus' OR species='lunatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serilophus' AND (junior_species='lunatus' OR junior_species='lunatus')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='Serilophus' AND (species='lunatus' OR species='lunatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' 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='Pitta' AND (species='soror' OR species='soror') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pitta' AND (species='soror' OR species='soror')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pitta' 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='Pitta' AND (species='soror' OR species='soror') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alophoixus' AND (junior_species='pallidus' OR junior_species='pallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alophoixus' AND (species='pallidus' OR species='pallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alophoixus' AND (species='pallidus' OR species='pallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alophoixus' AND (junior_species='pallidus' OR junior_species='pallidus')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='Alophoixus' AND (species='pallidus' OR species='pallidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemixos' AND (junior_species='castanonotus' OR junior_species='castanonotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemixos' AND (species='castanonotus' OR species='castanonotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemixos' AND (species='castanonotus' OR species='castanonotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemixos' AND (junior_species='castanonotus' OR junior_species='castanonotus')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='Hemixos' AND (species='castanonotus' OR species='castanonotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicrurus' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicrurus' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='aeneus' OR junior_species='aeneus')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='Dicrurus' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='paradiseus' OR junior_species='paradiseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicrurus' AND (species='paradiseus' OR species='paradiseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicrurus' AND (species='paradiseus' OR species='paradiseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='paradiseus' OR junior_species='paradiseus')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='Dicrurus' AND (species='paradiseus' OR species='paradiseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissa' AND (junior_species='hypoleuca' OR junior_species='hypoleuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cissa' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cissa' AND (species='hypoleuca' OR species='hypoleuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cissa' AND (junior_species='hypoleuca' OR junior_species='hypoleuca')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='Cissa' AND (species='hypoleuca' OR species='hypoleuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='sibilans' OR junior_species='sibilans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Luscinia' AND (species='sibilans' OR species='sibilans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Luscinia' AND (species='sibilans' OR species='sibilans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='sibilans' OR junior_species='sibilans')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='Luscinia' AND (species='sibilans' OR species='sibilans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tarsiger' AND (junior_species='cyanurus' OR junior_species='cyanurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tarsiger' AND (species='cyanurus' OR species='cyanurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tarsiger' AND (species='cyanurus' OR species='cyanurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tarsiger' AND (junior_species='cyanurus' OR junior_species='cyanurus')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='Tarsiger' AND (species='cyanurus' OR species='cyanurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enicurus' AND (junior_species='leschenaulti' OR junior_species='leschenaultii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enicurus' AND (species='leschenaulti' OR species='leschenaultii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enicurus' AND (species='leschenaulti' OR species='leschenaultii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enicurus' AND (junior_species='leschenaulti' OR junior_species='leschenaultii')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='Enicurus' AND (species='leschenaulti' OR species='leschenaultii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='citrina' OR junior_species='citrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zoothera' AND (species='citrina' OR species='citrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zoothera' AND (species='citrina' OR species='citrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='citrina' OR junior_species='citrina')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='citrina' OR species='citrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='dauma' OR junior_species='dauma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zoothera' AND (species='dauma' OR species='dauma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zoothera' AND (species='dauma' OR species='dauma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zoothera' AND (junior_species='dauma' OR junior_species='dauma')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='dauma' OR species='dauma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='albicollis' OR junior_species='albicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhipidura' AND (species='albicollis' OR species='albicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhipidura' AND (species='albicollis' OR species='albicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhipidura' AND (junior_species='albicollis' OR junior_species='albicollis')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='albicollis' OR species='albicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' AND (junior_species='monileger' OR junior_species='monileger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garrulax' AND (species='monileger' OR species='monileger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garrulax' AND (species='monileger' OR species='monileger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' AND (junior_species='monileger' OR junior_species='monileger')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='Garrulax' AND (species='monileger' OR species='monileger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' 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='Garrulax' AND (species='pectoralis' OR species='pectoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garrulax' AND (species='pectoralis' OR species='pectoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' 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='Garrulax' AND (species='pectoralis' OR species='pectoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' AND (junior_species='maesi' OR junior_species='maesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garrulax' AND (species='maesi' OR species='maesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garrulax' AND (species='maesi' OR species='maesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' AND (junior_species='maesi' OR junior_species='maesii')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='Garrulax' AND (species='maesi' OR species='maesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' AND (junior_species='chinensis' OR junior_species='chinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garrulax' AND (species='chinensis' OR species='chinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garrulax' AND (species='chinensis' OR species='chinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' AND (junior_species='chinensis' OR junior_species='chinensis')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='Garrulax' AND (species='chinensis' OR species='chinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatorhinus' AND (junior_species='hypoleucos' OR junior_species='hypoleucos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pomatorhinus' AND (species='hypoleucos' OR species='hypoleucos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pomatorhinus' AND (species='hypoleucos' OR species='hypoleucos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatorhinus' AND (junior_species='hypoleucos' OR junior_species='hypoleucos')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='Pomatorhinus' AND (species='hypoleucos' OR species='hypoleucos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatorhinus' AND (junior_species='ruficollis' OR junior_species='ruficollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pomatorhinus' AND (species='ruficollis' OR species='ruficollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pomatorhinus' AND (species='ruficollis' OR species='ruficollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatorhinus' AND (junior_species='ruficollis' OR junior_species='ruficollis')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='Pomatorhinus' AND (species='ruficollis' OR species='ruficollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Napothera' AND (junior_species='epilepidota' OR junior_species='epilepidota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Napothera' AND (species='epilepidota' OR species='epilepidota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Napothera' AND (species='epilepidota' OR species='epilepidota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Napothera' AND (junior_species='epilepidota' OR junior_species='epilepidota')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='Napothera' AND (species='epilepidota' OR species='epilepidota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='ruficeps' OR junior_species='ruficeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stachyris' AND (species='ruficeps' OR species='ruficeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stachyris' AND (species='ruficeps' OR species='ruficeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='ruficeps' OR junior_species='ruficeps')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='Stachyris' AND (species='ruficeps' OR species='ruficeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='striolata' OR junior_species='striolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stachyris' AND (species='striolata' OR species='striolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stachyris' AND (species='striolata' OR species='striolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stachyris' AND (junior_species='striolata' OR junior_species='striolata')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='Stachyris' AND (species='striolata' OR species='striolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcippe' AND (junior_species='brunnea' OR junior_species='brunnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcippe' AND (species='brunnea' OR species='brunnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcippe' AND (species='brunnea' OR species='brunnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcippe' AND (junior_species='brunnea' OR junior_species='brunnea')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='Alcippe' AND (species='brunnea' OR species='brunnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcippe' AND (junior_species='morrisonia' OR junior_species='morrisonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcippe' AND (species='morrisonia' OR species='morrisonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcippe' AND (species='morrisonia' OR species='morrisonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcippe' AND (junior_species='morrisonia' OR junior_species='morrisonia')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='Alcippe' AND (species='morrisonia' OR species='morrisonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erpornis' AND (junior_species='zantholeuca' OR junior_species='zantholeuca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erpornis' AND (species='zantholeuca' OR species='zantholeuca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erpornis' AND (species='zantholeuca' OR species='zantholeuca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erpornis' AND (junior_species='zantholeuca' OR junior_species='zantholeuca')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='Erpornis' AND (species='zantholeuca' OR species='zantholeuca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradoxornis' AND (junior_species='gularis' OR junior_species='gularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paradoxornis' AND (species='gularis' OR species='gularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paradoxornis' AND (species='gularis' OR species='gularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradoxornis' AND (junior_species='gularis' OR junior_species='gularis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paradoxornis' AND (species='gularis' OR species='gularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='reguloides' OR junior_species='reguloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='reguloides' OR species='reguloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='reguloides' OR species='reguloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='reguloides' OR junior_species='reguloides')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='reguloides' OR species='reguloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='tenellipes' OR junior_species='tenellipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='tenellipes' OR species='tenellipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='tenellipes' OR species='tenellipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='tenellipes' OR junior_species='tenellipes')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='tenellipes' OR species='tenellipes') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2922 The Ecological Register: Jianfengling Forest Area (1000 m)
Jianfengling Forest Area (1000 m)
Basic information
Sample name: Jianfengling Forest Area (1000 m)

Reference: F.-S. Zou, G.-Z. Chen, Q.-F. Yang, and Y.-D. Li. 2012. Bird species richness along an elevational gradient in a forest at Jianfengling, Hainan Island, China. Zoological Studies 51(3):362-371 [ER 2746]
Geography
Country: China

State: Hainan


Coordinate: 18° 44' N, 108° 52' E
Coordinate basis: stated in text

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 24.5

MAP: 2100.0

Habitat comments: "tropical montane rainforest"
MAP range is 1600 to 2600 mm

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 189 individuals

Years: 2000 - 2002, 2004

Seasons: dry,wet or monsoon

Nets or traps: 10

Net or trap nights: 211

Sampling comments: "Mist-nets measuring 12 m long, 2.6 m high, and with a 36-mm mesh were used to capture birds. Birds were sampled at the 3 elevations in 8 separate periods, four of which were in the wet season (May 2000, June 2001, Oct. 2001, and Sept. 2004) and 4 in the dry season (Nov. 2000, Feb. 2001, Jan. 2002, and Mar. 2002)... Ten nets were simultaneously deployed at each site except at 200 m... Nets were opened... for 3 consecutive days from approximately 06:30 to 17:30"
2320 mist net hours (i.e., 211 mist net days)

Metadata
Sample number: 2922

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-04-25 16:43:58

Modified: 2020-05-29 10:23:39

Abundance distribution
31 species
10 singletons
total count 189
extrapolated richness: 62.5
Fisher's α: 10.542
geometric series k: 0.8744
Hurlbert's PIE: 0.8743
Shannon's H: 2.6645
Good's u: 0.9474
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Chalcophaps indica14.9 g frugivore
Glaucidium cuculoides3187 g carnivore
Harpactes erythrocephalus280.3 g insectivore
Serilophus lunatus2234.0 g insectivore
Pitta soror1114 g insectivore
Alophoixus pallidus1446.0 g frugivore
Hemixos castanonotus1 frugivore
Dicrurus aeneus3 insectivore
Dicrurus paradiseus2 insectivore
Cissa hypoleuca1 insectivore
Luscinia sibilans316.7 g insectivore
Tarsiger cyanurus63.6 g insectivore
Enicurus leschenaulti1233.8 g insectivore
Zoothera citrina153.3 g insectivore
Zoothera dauma213.2 g insectivore-frugivore
Rhipidura albicollis212.9 g insectivore
Garrulax monileger1 insectivore
Garrulax pectoralis3156 g omnivore
Garrulax maesi1 insectivore
Garrulax chinensis4 insectivore-granivore
Pomatorhinus hypoleucos175.6 g insectivore
Pomatorhinus ruficollis1233.1 g insectivore
Napothera epilepidota316.0 g insectivore
Stachyris ruficeps310.3 g insectivore
Stachyris striolata5 insectivore
Alcippe brunnea10 insectivore-granivore
Alcippe morrisonia563.9 g insectivore
Erpornis zantholeuca2 insectivore
Paradoxornis gularis1029.0 g insectivore
Phylloscopus reguloides1 insectivore
Phylloscopus tenellipes111.8 g insectivore