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=3656 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3656SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3291SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3656 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ansonia' AND (junior_species='glandulosa' OR junior_species='glandulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ansonia' AND (species='glandulosa' OR species='glandulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ansonia' AND (species='glandulosa' OR species='glandulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ansonia' AND (junior_species='glandulosa' OR junior_species='glandulosa')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='Ansonia' AND (species='glandulosa' OR species='glandulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ingerophrynus' AND (junior_species='divergens' OR junior_species='divergens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ingerophrynus' AND (species='divergens' OR species='divergens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ingerophrynus' AND (species='divergens' OR species='divergens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ingerophrynus' AND (junior_species='divergens' OR junior_species='divergens')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='Ingerophrynus' AND (species='divergens' OR species='divergens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ingerophrynus' AND (junior_species='quadriporcatus' OR junior_species='quadriporcatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ingerophrynus' AND (species='quadriporcatus' OR species='quadriporcatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ingerophrynus' AND (species='quadriporcatus' OR species='quadriporcatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ingerophrynus' AND (junior_species='quadriporcatus' OR junior_species='quadriporcatus')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='Ingerophrynus' AND (species='quadriporcatus' OR species='quadriporcatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='blythii' OR junior_species='blythi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='blythii' OR species='blythi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='blythii' OR species='blythi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='blythii' OR junior_species='blythi')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='Limnonectes' AND (species='blythii' OR species='blythi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='macrodon' OR junior_species='macrodon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='macrodon' OR species='macrodon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='macrodon' OR species='macrodon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='macrodon' OR junior_species='macrodon')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='Limnonectes' AND (species='macrodon' OR species='macrodon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='malesianus' OR junior_species='malesianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='malesianus' OR species='malesianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='malesianus' OR species='malesianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='malesianus' OR junior_species='malesianus')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='Limnonectes' AND (species='malesianus' OR species='malesianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='paramacrodon' OR junior_species='paramacrodon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='paramacrodon' OR species='paramacrodon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='paramacrodon' OR species='paramacrodon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='paramacrodon' OR junior_species='paramacrodon')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='Limnonectes' AND (species='paramacrodon' OR species='paramacrodon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occidozyga' AND (junior_species='sumatrana' OR junior_species='sumatrana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Occidozyga' AND (species='sumatrana' OR species='sumatrana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Occidozyga' AND (species='sumatrana' OR species='sumatrana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Occidozyga' AND (junior_species='sumatrana' OR junior_species='sumatrana')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='Occidozyga' AND (species='sumatrana' OR species='sumatrana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalophrynus' AND (junior_species='pleurostigma' OR junior_species='pleurostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kalophrynus' AND (species='pleurostigma' OR species='pleurostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kalophrynus' AND (species='pleurostigma' OR species='pleurostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kalophrynus' AND (junior_species='pleurostigma' OR junior_species='pleurostigma')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='Kalophrynus' AND (species='pleurostigma' OR species='pleurostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='berdmorei' OR junior_species='berdmoreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhyla' AND (species='berdmorei' OR species='berdmoreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhyla' AND (species='berdmorei' OR species='berdmoreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='berdmorei' OR junior_species='berdmoreii')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='Microhyla' AND (species='berdmorei' OR species='berdmoreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='butleri' OR junior_species='butlerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhyla' AND (species='butleri' OR species='butlerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhyla' AND (species='butleri' OR species='butlerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='butleri' OR junior_species='butlerii')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='Microhyla' AND (species='butleri' OR species='butlerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnirana' AND (junior_species='nicobariensis' OR junior_species='nicobariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amnirana' AND (species='nicobariensis' OR species='nicobariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amnirana' AND (species='nicobariensis' OR species='nicobariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amnirana' AND (junior_species='nicobariensis' OR junior_species='nicobariensis')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='Amnirana' AND (species='nicobariensis' OR species='nicobariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcorana' AND (junior_species='chalcnota' OR junior_species='chalcnota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcorana' AND (species='chalcnota' OR species='chalcnota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcorana' AND (species='chalcnota' OR species='chalcnota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcorana' AND (junior_species='chalcnota' OR junior_species='chalcnota')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='Chalcorana' AND (species='chalcnota' OR species='chalcnota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcorana' AND (junior_species='labialis' OR junior_species='labialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcorana' AND (species='labialis' OR species='labialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcorana' AND (species='labialis' OR species='labialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcorana' AND (junior_species='labialis' OR junior_species='labialis')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='Chalcorana' AND (species='labialis' OR species='labialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcorana' AND (junior_species='raniceps' OR junior_species='raniceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcorana' AND (species='raniceps' OR species='raniceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcorana' AND (species='raniceps' OR species='raniceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcorana' AND (junior_species='raniceps' OR junior_species='raniceps')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='Chalcorana' AND (species='raniceps' OR species='raniceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pulchrana' AND (junior_species='baramica' OR junior_species='baramica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pulchrana' AND (species='baramica' OR species='baramica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pulchrana' AND (species='baramica' OR species='baramica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pulchrana' AND (junior_species='baramica' OR junior_species='baramica')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='Pulchrana' AND (species='baramica' OR species='baramica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pulchrana' AND (junior_species='glandulosa' OR junior_species='glandulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pulchrana' AND (species='glandulosa' OR species='glandulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pulchrana' AND (species='glandulosa' OR species='glandulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pulchrana' AND (junior_species='glandulosa' OR junior_species='glandulosa')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='Pulchrana' AND (species='glandulosa' OR species='glandulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kurixalus' AND (junior_species='appendiculatus' OR junior_species='appendiculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kurixalus' AND (species='appendiculatus' OR species='appendiculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kurixalus' AND (species='appendiculatus' OR species='appendiculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kurixalus' AND (junior_species='appendiculatus' OR junior_species='appendiculatus')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='Kurixalus' AND (species='appendiculatus' OR species='appendiculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='colletti' OR junior_species='collettii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polypedates' AND (species='colletti' OR species='collettii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polypedates' AND (species='colletti' OR species='collettii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='colletti' OR junior_species='collettii')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='Polypedates' AND (species='colletti' OR species='collettii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='leucomystax' OR junior_species='leucomystax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polypedates' AND (species='leucomystax' OR species='leucomystax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polypedates' AND (species='leucomystax' OR species='leucomystax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='leucomystax' OR junior_species='leucomystax')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='Polypedates' AND (species='leucomystax' OR species='leucomystax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhacophorus' AND (junior_species='bengkuluensis' OR junior_species='bengkuluensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhacophorus' AND (species='bengkuluensis' OR species='bengkuluensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhacophorus' AND (species='bengkuluensis' OR species='bengkuluensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhacophorus' AND (junior_species='bengkuluensis' OR junior_species='bengkuluensis')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='Rhacophorus' AND (species='bengkuluensis' OR species='bengkuluensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaniotis' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphaniotis' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphaniotis' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphaniotis' AND (junior_species='fusca' OR junior_species='fusca')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='Aphaniotis' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='smithii' OR junior_species='smithi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gekko' AND (species='smithii' OR species='smithi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gekko' AND (species='smithii' OR species='smithi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gekko' AND (junior_species='smithii' OR junior_species='smithi')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='Gekko' AND (species='smithii' OR species='smithi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasia' AND (junior_species='olivacea' OR junior_species='olivacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasia' AND (species='olivacea' OR species='olivacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasia' AND (species='olivacea' OR species='olivacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasia' AND (junior_species='olivacea' OR junior_species='olivacea')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='Dasia' AND (species='olivacea' OR species='olivacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='multifasciata' OR junior_species='multifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eutropis' AND (species='multifasciata' OR species='multifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eutropis' AND (species='multifasciata' OR species='multifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='multifasciata' OR junior_species='multifasciata')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='Eutropis' AND (species='multifasciata' OR species='multifasciata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='rugifera' OR junior_species='rugifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eutropis' AND (species='rugifera' OR species='rugifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eutropis' AND (species='rugifera' OR species='rugifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutropis' AND (junior_species='rugifera' OR junior_species='rugifera')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='Eutropis' AND (species='rugifera' OR species='rugifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' 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='Sphenomorphus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphenomorphus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphenomorphus' 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='Sphenomorphus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3656 The Ecological Register: Collaborative Research Centre 990 (forest)
Collaborative Research Centre 990 (forest)
Basic information
Sample name: Collaborative Research Centre 990 (forest)

Reference: A. Paoletti, K. Darras, H. Jayanto, I. Grass, M. Kusrini, and T. Tscharntke. 2018. Amphibian and reptile communities of upland and riparian sites across Indonesian oil palm, rubber and forest. Global Ecology and Conservation 16(e00492):1-13 [ER 3291]
Geography
Country: Indonesia

State: Jambi


Coordinate: 2° 1' S, 103° 20' E
Coordinate basis: based on political unit

Geography comments: "in the regency of Batang Hari, province of Jambi"
Drescher et al. () indicate that the sites are spread over an area at least 50 km across covering much the regency, all of which is southwest of Jambi City
coordinate is based on Batang Hari

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Protection: unprotected

Substrate: ground surface

Disturbance: selective logging

Habitat comments: "upland and riparian lowland forest... Our forest sites are primary degraded forest because of past selective logging activities"

Methods
Life forms: lizards,frogs

Sampling methods: no design,pitfall traps,auditory,hand capture

Sample size: 307 individuals

Years: 2017

Sampling comments: "We collected data from April 4, 2017 until July 9, 2017 in 24 core plots... For each habitat, there were four square, replicate plots of 50 x 50 m, situated in different plantations... We coupled visual and aural surveys with pitfall traps... each plot was visited six times for 1 h by two herpetologists (AP and HJ), resulting in 12 person-hours of visual-aural surveys per plot, and 288 person-hours overall... We also set up four pitfall traps per plot, one in the centre of each of the four sections... they were active for approximately 36 h... we also mounted four pitfall traps in each plot, for a total of 192 trap installations"
animals "were temporarily captured" and detected by identifying calls
forest plots were sampled in June and July

Metadata
Sample number: 3656

Contributor: John Alroy

Enterer: John Alroy

Created: 2020-06-05 16:02:23

Modified: 2020-06-05 06:02:23

Abundance distribution
27 species
9 singletons
total count 307
extrapolated richness: 50.4
Fisher's α: 7.133
geometric series k: 0.8532
Hurlbert's PIE: 0.8776
Shannon's H: 2.4499
Good's u: 0.9707
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ansonia glandulosa1
Ingerophrynus divergens31
Ingerophrynus quadriporcatus1
Limnonectes blythii47
Limnonectes macrodon6
Limnonectes malesianus2
Limnonectes paramacrodon3
Occidozyga sumatrana55
Kalophrynus pleurostigma5
Microhyla berdmorei2
Microhyla butleri1
Amnirana nicobariensis4
Chalcorana chalcnota19
Chalcorana labialis2
Chalcorana raniceps8
Pulchrana baramica1
Pulchrana glandulosa4
Kurixalus appendiculatus62
Polypedates colletti27
Polypedates leucomystax4
Rhacophorus bengkuluensis1
Aphaniotis fusca1
Gekko smithii5
Dasia olivacea1
Eutropis multifasciata12
Eutropis rugifera1
Sphenomorphus sp. 11