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=3007 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3007SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2785SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3007 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='bufo' OR junior_species='bufo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='bufo' OR species='bufo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='bufo' OR species='bufo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='bufo' OR junior_species='bufo')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='Bufo' AND (species='bufo' OR species='bufo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudepidalea' AND (junior_species='variabilis' OR junior_species='variabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudepidalea' AND (species='variabilis' OR species='variabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudepidalea' AND (species='variabilis' OR species='variabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudepidalea' AND (junior_species='variabilis' OR junior_species='variabilis')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='Pseudepidalea' AND (species='variabilis' OR species='variabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelophylax' AND (junior_species='bedriagae' OR junior_species='bedriagae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pelophylax' AND (species='bedriagae' OR species='bedriagae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelophylax' AND (species='bedriagae' OR species='bedriagae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelophylax' AND (junior_species='bedriagae' OR junior_species='bedriagae')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='Pelophylax' AND (species='bedriagae' OR species='bedriagae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mauremys' AND (junior_species='rivulata' OR junior_species='rivulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mauremys' AND (species='rivulata' OR species='rivulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mauremys' AND (species='rivulata' OR species='rivulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mauremys' AND (junior_species='rivulata' OR junior_species='rivulata')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='Mauremys' AND (species='rivulata' OR species='rivulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudo' AND (junior_species='graeca' OR junior_species='graeca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Testudo' AND (species='graeca' OR species='graeca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testudo' AND (species='graeca' OR species='graeca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudo' AND (junior_species='graeca' OR junior_species='graeca')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='Testudo' AND (species='graeca' OR species='graeca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laudakia' AND (junior_species='stellio' OR junior_species='stellio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laudakia' AND (species='stellio' OR species='stellio') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laudakia' AND (species='stellio' OR species='stellio')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laudakia' AND (junior_species='stellio' OR junior_species='stellio')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='Laudakia' AND (species='stellio' OR species='stellio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blanus' AND (junior_species='strauchi' OR junior_species='strauchii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blanus' AND (species='strauchi' OR species='strauchii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blanus' AND (species='strauchi' OR species='strauchii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blanus' AND (junior_species='strauchi' OR junior_species='strauchii')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='Blanus' AND (species='strauchi' OR species='strauchii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mediodactylus' AND (junior_species='kotschyi' OR junior_species='kotschyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mediodactylus' AND (species='kotschyi' OR species='kotschyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mediodactylus' AND (species='kotschyi' OR species='kotschyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mediodactylus' AND (junior_species='kotschyi' OR junior_species='kotschyii')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='Mediodactylus' AND (species='kotschyi' OR species='kotschyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='turcicus' OR junior_species='turcicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='turcicus' OR species='turcicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='turcicus' OR species='turcicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='turcicus' OR junior_species='turcicus')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='Hemidactylus' AND (species='turcicus' OR species='turcicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anatololacerta' AND (junior_species='oertzeni' OR junior_species='oertzenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anatololacerta' AND (species='oertzeni' OR species='oertzenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anatololacerta' AND (species='oertzeni' OR species='oertzenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anatololacerta' AND (junior_species='oertzeni' OR junior_species='oertzenii')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='Anatololacerta' AND (species='oertzeni' OR species='oertzenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='trilineata' OR junior_species='trilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacerta' AND (species='trilineata' OR species='trilineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacerta' AND (species='trilineata' OR species='trilineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='trilineata' OR junior_species='trilineata')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='Lacerta' AND (species='trilineata' OR species='trilineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophisops' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophisops' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophisops' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophisops' AND (junior_species='elegans' OR junior_species='elegans')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='Ophisops' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ablepharus' AND (junior_species='kitaibelii' OR junior_species='kitaibeli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ablepharus' AND (species='kitaibelii' OR species='kitaibeli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ablepharus' AND (species='kitaibelii' OR species='kitaibeli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ablepharus' AND (junior_species='kitaibelii' OR junior_species='kitaibeli')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='Ablepharus' AND (species='kitaibelii' OR species='kitaibeli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='aurata' OR junior_species='aurata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='aurata' OR species='aurata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='aurata' OR species='aurata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='aurata' OR junior_species='aurata')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='Trachylepis' AND (species='aurata' OR species='aurata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eryx' AND (junior_species='jaculus' OR junior_species='jaculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eryx' AND (species='jaculus' OR species='jaculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eryx' AND (species='jaculus' OR species='jaculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eryx' AND (junior_species='jaculus' OR junior_species='jaculus')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='Eryx' AND (species='jaculus' OR species='jaculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichophis' AND (junior_species='jugularis' OR junior_species='jugularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dolichophis' AND (species='jugularis' OR species='jugularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dolichophis' AND (species='jugularis' OR species='jugularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dolichophis' AND (junior_species='jugularis' OR junior_species='jugularis')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='Dolichophis' AND (species='jugularis' OR species='jugularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eirenis' AND (junior_species='modestus' OR junior_species='modestus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eirenis' AND (species='modestus' OR species='modestus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eirenis' AND (species='modestus' OR species='modestus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eirenis' AND (junior_species='modestus' OR junior_species='modestus')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='Eirenis' AND (species='modestus' OR species='modestus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemorrhois' AND (junior_species='nummifer' OR junior_species='nummifer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemorrhois' AND (species='nummifer' OR species='nummifer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemorrhois' AND (species='nummifer' OR species='nummifer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemorrhois' AND (junior_species='nummifer' OR junior_species='nummifer')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='Hemorrhois' AND (species='nummifer' OR species='nummifer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natrix' AND (junior_species='natrix' OR junior_species='natrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Natrix' AND (species='natrix' OR species='natrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Natrix' AND (species='natrix' OR species='natrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natrix' AND (junior_species='natrix' OR junior_species='natrix')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='Natrix' AND (species='natrix' OR species='natrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyceps' AND (junior_species='najadum' OR junior_species='najadum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platyceps' AND (species='najadum' OR species='najadum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platyceps' AND (species='najadum' OR species='najadum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platyceps' AND (junior_species='najadum' OR junior_species='najadum')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='Platyceps' AND (species='najadum' OR species='najadum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telescopus' AND (junior_species='fallax' OR junior_species='fallax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telescopus' AND (species='fallax' OR species='fallax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telescopus' AND (species='fallax' OR species='fallax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telescopus' AND (junior_species='fallax' OR junior_species='fallax')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='Telescopus' AND (species='fallax' OR species='fallax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Typhlops' AND (junior_species='vermicularis' OR junior_species='vermicularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Typhlops' AND (species='vermicularis' OR species='vermicularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Typhlops' AND (species='vermicularis' OR species='vermicularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Typhlops' AND (junior_species='vermicularis' OR junior_species='vermicularis')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='Typhlops' AND (species='vermicularis' OR species='vermicularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Montivipera' AND (junior_species='xanthina' OR junior_species='xanthina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Montivipera' AND (species='xanthina' OR species='xanthina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Montivipera' AND (species='xanthina' OR species='xanthina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Montivipera' AND (junior_species='xanthina' OR junior_species='xanthina')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='Montivipera' AND (species='xanthina' OR species='xanthina') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3007 The Ecological Register: Madran Mountain
Madran Mountain
Basic information
Sample name: Madran Mountain

Reference: S. Ozcan and N. Uzum. 2014. The herpetofauna of Madran Mountain (Aydin, Turkey. Turkish Journal of Zoology 38:108-113 [ER 2785]
Geography
Country: Turkey

State: Aydin


Coordinate: 37° 40' N, 28° 15' E
Coordinate basis: estimated from map

Environment
Habitat: Mediterranean woodland

Substrate: ground surface

Disturbance: agriculture,grazing

Habitat comments: "a typical Mediterranean climate with dry summers and mild and rainy winters" with "conversion of natural habitats into agricultural land... removal of natural vegetation and replacement with fruit trees" and "activity of livestock, especially goats"

Methods
Life forms: lizards,snakes,turtles,frogs

Sites: 7

Sampling methods: no design,hand capture

Sample size: 171 individuals

Years: 2011, 2012

Sampling comments: "Fieldworks were conducted in September 2011 and April and May 2012. Species were collected using different techniques according to habitat conditions... The study area was divided into 7 stations"

Metadata
Sample number: 3007

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-06-06 20:47:47

Modified: 2018-06-06 10:47:47

Abundance distribution
23 species
3 singletons
total count 171
extrapolated richness: 31.6
Fisher's α: 7.154
geometric series k: 0.8708
Hurlbert's PIE: 0.9352
Shannon's H: 2.9014
Good's u: 0.9825
Each square represents a species. Square sizes are proportional to counts.
Register