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=2925 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2925SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2747SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2925 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='innominatus' OR junior_species='innominatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picumnus' AND (species='innominatus' OR species='innominatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picumnus' AND (species='innominatus' OR species='innominatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picumnus' AND (junior_species='innominatus' OR junior_species='innominatus')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='Picumnus' AND (species='innominatus' OR species='innominatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='spilocephalus' OR junior_species='spilocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otus' AND (species='spilocephalus' OR species='spilocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otus' AND (species='spilocephalus' OR species='spilocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='spilocephalus' OR junior_species='spilocephalus')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='Otus' AND (species='spilocephalus' OR species='spilocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='bakkamoena' OR junior_species='bakkamoena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otus' AND (species='bakkamoena' OR species='bakkamoena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otus' AND (species='bakkamoena' OR species='bakkamoena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otus' AND (junior_species='bakkamoena' OR junior_species='bakkamoena')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='Otus' AND (species='bakkamoena' OR species='bakkamoena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucidium' AND (junior_species='brodiei' OR junior_species='brodieii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glaucidium' AND (species='brodiei' OR species='brodieii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glaucidium' AND (species='brodiei' OR species='brodieii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glaucidium' AND (junior_species='brodiei' OR junior_species='brodieii')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='brodiei' OR species='brodieii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='soloensis' OR junior_species='soloensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='soloensis' OR species='soloensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='soloensis' OR species='soloensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='soloensis' OR junior_species='soloensis')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='Accipiter' AND (species='soloensis' OR species='soloensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='virgatus' OR junior_species='virgatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='virgatus' OR species='virgatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='virgatus' OR species='virgatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='virgatus' OR junior_species='virgatus')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='Accipiter' AND (species='virgatus' OR species='virgatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='tigrinus' OR junior_species='tigrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanius' AND (species='tigrinus' OR species='tigrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanius' AND (species='tigrinus' OR species='tigrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanius' AND (junior_species='tigrinus' OR junior_species='tigrinus')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='Lanius' AND (species='tigrinus' OR species='tigrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocitta' AND (junior_species='formosae' OR junior_species='formosae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrocitta' AND (species='formosae' OR species='formosae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrocitta' AND (species='formosae' OR species='formosae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrocitta' AND (junior_species='formosae' OR junior_species='formosae')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='Dendrocitta' AND (species='formosae' OR species='formosae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pericrocotus' AND (junior_species='solaris' OR junior_species='solaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pericrocotus' AND (species='solaris' OR species='solaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pericrocotus' AND (species='solaris' OR species='solaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pericrocotus' AND (junior_species='solaris' OR junior_species='solaris')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='Pericrocotus' AND (species='solaris' OR species='solaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='hottentottus' OR junior_species='hottentottus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicrurus' AND (species='hottentottus' OR species='hottentottus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicrurus' AND (species='hottentottus' OR species='hottentottus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrurus' AND (junior_species='hottentottus' OR junior_species='hottentottus')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='hottentottus' OR species='hottentottus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='paradisi' OR junior_species='paradisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terpsiphone' AND (species='paradisi' OR species='paradisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terpsiphone' AND (species='paradisi' OR species='paradisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terpsiphone' AND (junior_species='paradisi' OR junior_species='paradisii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Terpsiphone' AND (species='paradisi' OR species='paradisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='dauurica' OR junior_species='dauurica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscicapa' AND (species='dauurica' OR species='dauurica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscicapa' AND (species='dauurica' OR species='dauurica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscicapa' AND (junior_species='dauurica' OR junior_species='dauurica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Muscicapa' AND (species='dauurica' OR species='dauurica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='zanthopygia' OR junior_species='zanthopygia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficedula' AND (species='zanthopygia' OR species='zanthopygia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficedula' AND (species='zanthopygia' OR species='zanthopygia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficedula' AND (junior_species='zanthopygia' OR junior_species='zanthopygia')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='Ficedula' AND (species='zanthopygia' OR species='zanthopygia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyornis' AND (junior_species='hainanus' OR junior_species='hainanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyornis' AND (species='hainanus' OR species='hainanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyornis' AND (species='hainanus' OR species='hainanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyornis' AND (junior_species='hainanus' OR junior_species='hainanus')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='Cyornis' AND (species='hainanus' OR species='hainanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='cyane' OR junior_species='cyane')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Luscinia' AND (species='cyane' OR species='cyane') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Luscinia' AND (species='cyane' OR species='cyane')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Luscinia' AND (junior_species='cyane' OR junior_species='cyane')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='cyane' OR species='cyane') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='fuliginosus' OR junior_species='fuliginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phoenicurus' AND (species='fuliginosus' OR species='fuliginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phoenicurus' AND (species='fuliginosus' OR species='fuliginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phoenicurus' AND (junior_species='fuliginosus' OR junior_species='fuliginosus')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='Phoenicurus' AND (species='fuliginosus' OR species='fuliginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enicurus' AND (junior_species='scouleri' OR junior_species='scoulerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enicurus' AND (species='scouleri' OR species='scoulerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enicurus' AND (species='scouleri' OR species='scoulerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enicurus' AND (junior_species='scouleri' OR junior_species='scoulerii')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='scouleri' OR species='scoulerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enicurus' AND (junior_species='schistaceus' OR junior_species='schistaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enicurus' AND (species='schistaceus' OR species='schistaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enicurus' AND (species='schistaceus' OR species='schistaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enicurus' AND (junior_species='schistaceus' OR junior_species='schistaceus')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='schistaceus' OR species='schistaceus') 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='Enicurus' AND (junior_species='maculatus' OR junior_species='maculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enicurus' AND (species='maculatus' OR species='maculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enicurus' AND (species='maculatus' OR species='maculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enicurus' AND (junior_species='maculatus' OR junior_species='maculatus')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='maculatus' OR species='maculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizixos' AND (junior_species='semitorques' OR junior_species='semitorques')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spizixos' AND (species='semitorques' OR species='semitorques') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spizixos' AND (species='semitorques' OR species='semitorques')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizixos' AND (junior_species='semitorques' OR junior_species='semitorques')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='Spizixos' AND (species='semitorques' OR species='semitorques') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixos' AND (junior_species='mcclellandii' OR junior_species='mcclellandi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ixos' AND (species='mcclellandii' OR species='mcclellandi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ixos' AND (species='mcclellandii' OR species='mcclellandi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ixos' AND (junior_species='mcclellandii' OR junior_species='mcclellandi')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='Ixos' AND (species='mcclellandii' OR species='mcclellandi') 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='Hypsipetes' AND (junior_species='leucocephalus' OR junior_species='leucocephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsipetes' AND (species='leucocephalus' OR species='leucocephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsipetes' AND (species='leucocephalus' OR species='leucocephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsipetes' AND (junior_species='leucocephalus' OR junior_species='leucocephalus')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='Hypsipetes' AND (species='leucocephalus' OR species='leucocephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='borealis' OR junior_species='borealis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='borealis' OR species='borealis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='borealis' OR species='borealis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='borealis' OR junior_species='borealis')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='borealis' OR species='borealis') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='coronatus' OR junior_species='coronatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='coronatus' OR species='coronatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='coronatus' OR species='coronatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='coronatus' OR junior_species='coronatus')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='coronatus' OR species='coronatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='davisoni' OR junior_species='davisonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phylloscopus' AND (species='davisoni' OR species='davisonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phylloscopus' AND (species='davisoni' OR species='davisonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phylloscopus' AND (junior_species='davisoni' OR junior_species='davisonii')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='davisoni' OR species='davisonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seicercus' AND (junior_species='castaniceps' OR junior_species='castaniceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Seicercus' AND (species='castaniceps' OR species='castaniceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Seicercus' AND (species='castaniceps' OR species='castaniceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Seicercus' AND (junior_species='castaniceps' OR junior_species='castaniceps')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='Seicercus' AND (species='castaniceps' OR species='castaniceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abroscopus' AND (junior_species='albogularis' OR junior_species='albogularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abroscopus' AND (species='albogularis' OR species='albogularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abroscopus' AND (species='albogularis' OR species='albogularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abroscopus' AND (junior_species='albogularis' OR junior_species='albogularis')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='Abroscopus' AND (species='albogularis' OR species='albogularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' AND (junior_species='cineraceus' OR junior_species='cineraceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Garrulax' AND (species='cineraceus' OR species='cineraceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Garrulax' AND (species='cineraceus' OR species='cineraceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Garrulax' AND (junior_species='cineraceus' OR junior_species='cineraceus')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='cineraceus' OR species='cineraceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatorhinus' AND (junior_species='erythrocnemis' OR junior_species='erythrocnemis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pomatorhinus' AND (species='erythrocnemis' OR species='erythrocnemis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pomatorhinus' AND (species='erythrocnemis' OR species='erythrocnemis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatorhinus' AND (junior_species='erythrocnemis' OR junior_species='erythrocnemis')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='erythrocnemis' OR species='erythrocnemis') 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='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='Leiothrix' AND (junior_species='lutea' OR junior_species='lutea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leiothrix' AND (species='lutea' OR species='lutea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leiothrix' AND (species='lutea' OR species='lutea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothrix' AND (junior_species='lutea' OR junior_species='lutea')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='Leiothrix' AND (species='lutea' OR species='lutea') 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='Yuhina' AND (junior_species='castaniceps' OR junior_species='castaniceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yuhina' AND (species='castaniceps' OR species='castaniceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yuhina' AND (species='castaniceps' OR species='castaniceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yuhina' AND (junior_species='castaniceps' OR junior_species='castaniceps')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='Yuhina' AND (species='castaniceps' OR species='castaniceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yuhina' AND (junior_species='nigrimenta' OR junior_species='nigrimenta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Yuhina' AND (species='nigrimenta' OR species='nigrimenta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Yuhina' AND (species='nigrimenta' OR species='nigrimenta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Yuhina' AND (junior_species='nigrimenta' OR junior_species='nigrimenta')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='Yuhina' AND (species='nigrimenta' OR species='nigrimenta') 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='Dendronanthus' AND (junior_species='indicus' OR junior_species='indicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendronanthus' AND (species='indicus' OR species='indicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendronanthus' AND (species='indicus' OR species='indicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendronanthus' AND (junior_species='indicus' OR junior_species='indicus')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='Dendronanthus' AND (species='indicus' OR species='indicus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2925 The Ecological Register: Shunhuang Shan Nature Reserve
Shunhuang Shan Nature Reserve
Basic information
Sample name: Shunhuang Shan Nature Reserve

Reference: O. Komar, B. W. Benz, and G. Chen. 2005. Late summer ornithological inventories of Mt. Shunhuang and Mt. Dawei in Hunan, China. Zoological Research 26(1):31-39 [ER 2747]
Geography
Country: China

State: Hunan


Coordinate: 26° 25' N, 111° 2' E
Coordinate basis: stated in text as range

Geography comments: "in Dongan and Xinning counties, southwest of Hunan"
elevation range 500 to 950 m

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Protection: nature reserve

Substrate: ground surface

Disturbance: agriculture,grazing,selective logging

Habitat comments: "extensive stands of bamboo interspersed with coniferous pine forest and semideciduous broadleaf forest... considerable disturbance was evident, including limited rice cultivation, selective bamboo harvesting, and grazing. Homesteads and small temples were scattered throughout the zone, as were long paved trails used by tourists"

Methods
Life forms: birds

Sampling methods: no design,mist nets

Sample size: 221 individuals

Years: 2002

Net or trap nights: 148

Sampling comments: sampling was from 21 August to 3 September 2002
"Birds were captured in mist nets (20 - 36 mm mesh, 6 - 12 m long). A variable number of nets were used, up to 34 at any one time... They were left open all day and night (daylight hours were approximately 06:15 - 19:15)... Netting effort was 3,560 net-hours... short nets counted proportionally compared with 12 m nets" (approximate number of net days is 3560/24 = 148)

Metadata
Sample number: 2925

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-04-25 17:49:11

Modified: 2018-04-25 07:49:11

Abundance distribution
41 species
15 singletons
total count 221
extrapolated richness: 90.8
Fisher's α: 14.815
geometric series k: 0.8977
Hurlbert's PIE: 0.8595
Shannon's H: 2.7827
Good's u: 0.9325
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Picumnus innominatus210.2 g insectivore
Otus spilocephalus167.5 g
Otus bakkamoena14.8 g carnivore
Glaucidium brodiei456.0 g insectivore
Accipiter soloensis6150 g carnivore
Accipiter virgatus110.6 g carnivore
Lanius tigrinus1
Dendrocitta formosae1 omnivore
Pericrocotus solaris514.5 g insectivore-frugivore
Dicrurus hottentottus18 insectivore
Terpsiphone paradisi24.5 g insectivore
Muscicapa dauurica29.8 g insectivore
Ficedula zanthopygia33.6 g
Cyornis hainanus1 insectivore
Luscinia cyane514.8 g
Phoenicurus fuliginosus2
"Rhyacornis fuliginosus"
Enicurus scouleri317.8 g
Enicurus schistaceus331.0 g
Enicurus leschenaulti133.8 g insectivore
Enicurus maculatus1 insectivore
Spizixos semitorques239.0 g
Ixos mcclellandii432.5 g
Hemixos castanonotus12 frugivore
Hypsipetes leucocephalus1 frugivore-insectivore
Phylloscopus borealis33.3 g insectivore
Phylloscopus tenellipes211.8 g insectivore
Phylloscopus coronatus210.1 g
Phylloscopus davisoni16.4 g
Seicercus castaniceps15.3 g
Abroscopus albogularis1 insectivore
Garrulax cineraceus1
Pomatorhinus erythrocnemis1
Pomatorhinus ruficollis633.1 g insectivore
Stachyris ruficeps510.3 g insectivore
Leiothrix lutea221.3 g
Alcippe brunnea4 insectivore-granivore
Alcippe morrisonia753.9 g insectivore
Yuhina castaniceps1011.8 g
Yuhina nigrimenta69.5 g
Paradoxornis gularis1829.0 g insectivore
Dendronanthus indicus116.4 g