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=3719 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3719SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3350SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3719 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesechinus' AND (junior_species='wangi' OR junior_species='wangii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesechinus' AND (species='wangi' OR species='wangii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesechinus' AND (species='wangi' OR species='wangii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesechinus' AND (junior_species='wangi' OR junior_species='wangii')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='Mesechinus' AND (species='wangi' OR species='wangii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupaia' AND (junior_species='belangeri' OR junior_species='belangerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tupaia' AND (species='belangeri' OR species='belangerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tupaia' AND (species='belangeri' OR species='belangerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tupaia' AND (junior_species='belangeri' OR junior_species='belangerii')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='Tupaia' AND (species='belangeri' OR species='belangerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='arctoides' OR junior_species='arctoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaca' AND (species='arctoides' OR species='arctoides') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='arctoides' OR junior_species='arctoides')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='Macaca' AND (species='arctoides' OR species='arctoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='assamensis' OR junior_species='assamensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaca' AND (species='assamensis' OR species='assamensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='assamensis' OR junior_species='assamensis')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='Macaca' AND (species='assamensis' OR species='assamensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='mulatta' OR junior_species='mulatta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaca' AND (species='mulatta' OR species='mulatta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaca' AND (junior_species='mulatta' OR junior_species='mulatta')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='Macaca' AND (species='mulatta' OR species='mulatta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachypithecus' AND (junior_species='phayrei' OR junior_species='phayreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachypithecus' AND (species='phayrei' OR species='phayreii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachypithecus' AND (junior_species='phayrei' OR junior_species='phayreii')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='Trachypithecus' AND (species='phayrei' OR species='phayreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='thibetanus' OR junior_species='thibetanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='thibetanus' OR species='thibetanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='thibetanus' OR junior_species='thibetanus')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='Ursus' AND (species='thibetanus' OR species='thibetanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailurus' AND (junior_species='fulgens' OR junior_species='fulgens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ailurus' AND (species='fulgens' OR species='fulgens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ailurus' AND (junior_species='fulgens' OR junior_species='fulgens')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='Ailurus' AND (species='fulgens' OR species='fulgens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='flavigula' OR junior_species='flavigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Martes' AND (species='flavigula' OR species='flavigula') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='flavigula' OR junior_species='flavigula')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='Martes' AND (species='flavigula' OR species='flavigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='kathiah' OR junior_species='kathiah')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='kathiah' OR species='kathiah') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mustela' AND (species='kathiah' OR species='kathiah')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='kathiah' OR junior_species='kathiah')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='Mustela' AND (species='kathiah' OR species='kathiah') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='sibirica' OR junior_species='sibirica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='sibirica' OR species='sibirica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='sibirica' OR junior_species='sibirica')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='Mustela' AND (species='sibirica' OR species='sibirica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melogale' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melogale' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melogale' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melogale' AND (junior_species='sp.' OR junior_species='sp.')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='Melogale' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionodon' AND (junior_species='pardicolor' OR junior_species='pardicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionodon' AND (species='pardicolor' OR species='pardicolor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionodon' AND (junior_species='pardicolor' OR junior_species='pardicolor')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='Prionodon' AND (species='pardicolor' OR species='pardicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradoxurus' AND (junior_species='hermaphroditus' OR junior_species='hermaphroditus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paradoxurus' AND (species='hermaphroditus' OR species='hermaphroditus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradoxurus' AND (junior_species='hermaphroditus' OR junior_species='hermaphroditus')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='Paradoxurus' AND (species='hermaphroditus' OR species='hermaphroditus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paguma' AND (junior_species='larvata' OR junior_species='larvata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paguma' AND (species='larvata' OR species='larvata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paguma' AND (junior_species='larvata' OR junior_species='larvata')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='Paguma' AND (species='larvata' OR species='larvata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionailurus' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='bengalensis' OR junior_species='bengalensis')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='Prionailurus' AND (species='bengalensis' OR species='bengalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardofelis' AND (junior_species='marmorata' OR junior_species='marmorata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pardofelis' AND (species='marmorata' OR species='marmorata') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pardofelis' AND (junior_species='marmorata' OR junior_species='marmorata')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='Pardofelis' AND (species='marmorata' OR species='marmorata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')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='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moschus' AND (junior_species='berezovskii' OR junior_species='berezovski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moschus' AND (species='berezovskii' OR species='berezovski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moschus' AND (species='berezovskii' OR species='berezovski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moschus' AND (junior_species='berezovskii' OR junior_species='berezovski')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='Moschus' AND (species='berezovskii' OR species='berezovski') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphodus' AND (junior_species='cephalophus' OR junior_species='cephalophus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elaphodus' AND (species='cephalophus' OR species='cephalophus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elaphodus' AND (junior_species='cephalophus' OR junior_species='cephalophus')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='Elaphodus' AND (species='cephalophus' OR species='cephalophus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='vaginalis' OR junior_species='vaginalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='vaginalis' OR species='vaginalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muntiacus' AND (species='vaginalis' OR species='vaginalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='vaginalis' OR junior_species='vaginalis')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='Muntiacus' AND (species='vaginalis' OR species='vaginalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='gongshanensis' OR junior_species='gongshanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muntiacus' AND (species='gongshanensis' OR species='gongshanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muntiacus' AND (species='gongshanensis' OR species='gongshanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muntiacus' AND (junior_species='gongshanensis' OR junior_species='gongshanensis')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='Muntiacus' AND (species='gongshanensis' OR species='gongshanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naemorhedus' AND (junior_species='griseus' OR junior_species='griseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Naemorhedus' AND (species='griseus' OR species='griseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Naemorhedus' AND (species='griseus' OR species='griseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naemorhedus' AND (junior_species='griseus' OR junior_species='griseus')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='Naemorhedus' AND (species='griseus' OR species='griseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capricornis' AND (junior_species='rubidus' OR junior_species='rubidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capricornis' AND (species='rubidus' OR species='rubidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capricornis' AND (species='rubidus' OR species='rubidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capricornis' AND (junior_species='rubidus' OR junior_species='rubidus')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='Capricornis' AND (species='rubidus' OR species='rubidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capricornis' AND (junior_species='sumatraensis' OR junior_species='sumatraensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capricornis' AND (species='sumatraensis' OR species='sumatraensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capricornis' AND (species='sumatraensis' OR species='sumatraensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capricornis' AND (junior_species='sumatraensis' OR junior_species='sumatraensis')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='Capricornis' AND (species='sumatraensis' OR species='sumatraensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ratufa' AND (junior_species='bicolor' OR junior_species='bicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ratufa' AND (species='bicolor' OR species='bicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ratufa' AND (species='bicolor' OR species='bicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ratufa' AND (junior_species='bicolor' OR junior_species='bicolor')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='Ratufa' AND (species='bicolor' OR species='bicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atherurus' AND (junior_species='macrourus' OR junior_species='macrourus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atherurus' AND (species='macrourus' OR species='macrourus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atherurus' AND (species='macrourus' OR species='macrourus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atherurus' AND (junior_species='macrourus' OR junior_species='macrourus')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='Atherurus' AND (species='macrourus' OR species='macrourus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='brachyura' OR junior_species='brachyura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='brachyura' OR species='brachyura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hystrix' AND (species='brachyura' OR species='brachyura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='brachyura' OR junior_species='brachyura')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='Hystrix' AND (species='brachyura' OR species='brachyura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='forresti' OR junior_species='forrestii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochotona' AND (species='forresti' OR species='forrestii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotona' AND (species='forresti' OR species='forrestii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='forresti' OR junior_species='forrestii')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='Ochotona' AND (species='forresti' OR species='forrestii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3719 The Ecological Register: Tengchong Section
Tengchong Section
Basic information
Sample name: Tengchong Section

Sample aka: Gaoligongshan National Nature Reserve

Reference: F. Li, X.-Y. Huang, X.-C. Zhang, X.-X. Zhao, J.-H. Yang, and B. P. L. Chan. 2019. Mammals of Tengchong Section of Gaoligongshan National Nature Reserve in Yunnan Province, China. Journal of Threatened Taxa 11(11):14402-14414 [ER 3350]
Geography
Country: China

State: Yunnan


Coordinate: 25° 20' N, 98° 42' E
Coordinate basis: estimated from map

Geography comments: "the Tengchong Section of Gaoligongshan National Nature Reserve"
coordinate estimated from Fig. 1

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: nature reserve

Substrate: ground surface

Habitat comments: none given, but at these altitudes the forest is a mix of subtropical broad-leaf forest, temperate broad-leaf forest, and subalpine coniferous forest according to Wikipedia

Methods
Life forms: carnivores,primates,rodents,ungulates,other large mammals,other small mammals

Sampling methods: no design,automatic cameras

Sample size: 1869 captures or sightings

Years: 2014 - 2018

Net or trap nights: 14814

Camera type: digital

Cameras paired: no

Sampling comments: sampling was "between September 2014 and May 2018. The total number of camera trap stations was 147, and they covered elevations from 1,515 to 3,350m. Three models of infrared camera traps... were used" and deployed along "animal trails, salt licks, ridgelines, water sources, and underneath fruiting trees... Commercial lures (Hawbaker's Weasel and Marten Lure) were used at five camera trap stations as a trial"
there were clearly far fewer than 147 cameras because the study interval was four years but there were only 14,814 trap nights

Metadata
Sample number: 3719

Contributor: John Alroy

Enterer: John Alroy

Created: 2020-11-05 17:32:33

Modified: 2020-11-05 06:32:33

Abundance distribution
29 species
1 singleton
total count 1869
extrapolated richness: 33.3
Fisher's α: 4.872
geometric series k: 0.8187
Hurlbert's PIE: 0.9206
Shannon's H: 2.7998
Good's u: 0.9995
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Mesechinus wangi2
Tupaia belangeri48
Macaca arctoides13911 kg
Macaca assamensis2046.3 kg
Macaca mulatta188.0 kg folivore-frugivore
Trachypithecus phayrei196.6 kg
Ursus thibetanus2263 kg browser-frugivore
Ailurus fulgens435.8 kg browser
Martes flavigula1742.8 kg carnivore
Mustela kathiah2
Mustela sibirica2557 g carnivore-invertivore
Melogale sp.26
Prionodon pardicolor50827 g
Paradoxurus hermaphroditus72.4 kg frugivore-insectivore
Paguma larvata1004.0 kg frugivore-carnivore
Prionailurus bengalensis813.4 kg carnivore
Pardofelis marmorata563.7 kg carnivore
Sus scrofa5054 kg herbivore
Moschus berezovskii18
Elaphodus cephalophus5419 kg
Muntiacus vaginalis242
Muntiacus gongshanensis3
Naemorhedus griseus24
Capricornis rubidus4
Capricornis sumatraensis34
"Capricornis milneedwardsii"
Ratufa 'bicolor'49
Atherurus macrourus126
Hystrix brachyura271
Ochotona forresti1