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=3143 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3143SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2951SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3143 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='crocea' OR junior_species='crocea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='crocea' OR species='crocea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='crocea' OR species='crocea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='crocea' OR junior_species='crocea')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='Colias' AND (species='crocea' OR species='crocea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='ergane' OR junior_species='ergane')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='ergane' OR species='ergane') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='ergane' OR species='ergane')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='ergane' OR junior_species='ergane')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='Pieris' AND (species='ergane' OR species='ergane') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='mannii' OR junior_species='manni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='mannii' OR species='manni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='mannii' OR species='manni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='mannii' OR junior_species='manni')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='Pieris' AND (species='mannii' OR species='manni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='pseudorapae' OR junior_species='pseudorapae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='pseudorapae' OR species='pseudorapae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='pseudorapae' OR species='pseudorapae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='pseudorapae' OR junior_species='pseudorapae')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='Pieris' AND (species='pseudorapae' OR species='pseudorapae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='rapae' OR species='rapae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='rapae' OR species='rapae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')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='Pieris' AND (species='rapae' OR species='rapae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='pamphilus' OR junior_species='pamphilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='pamphilus' OR species='pamphilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='pamphilus' OR species='pamphilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='pamphilus' OR junior_species='pamphilus')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='Coenonympha' AND (species='pamphilus' OR species='pamphilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyponephele' AND (junior_species='lycaon' OR junior_species='lycaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyponephele' AND (species='lycaon' OR species='lycaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyponephele' AND (species='lycaon' OR species='lycaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyponephele' AND (junior_species='lycaon' OR junior_species='lycaon')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='Hyponephele' AND (species='lycaon' OR species='lycaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kirinia' AND (junior_species='roxelana' OR junior_species='roxelana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kirinia' AND (species='roxelana' OR species='roxelana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kirinia' AND (species='roxelana' OR species='roxelana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kirinia' AND (junior_species='roxelana' OR junior_species='roxelana')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='Kirinia' AND (species='roxelana' OR species='roxelana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiommata' AND (junior_species='megera' OR junior_species='megera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiommata' AND (species='megera' OR species='megera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiommata' AND (species='megera' OR species='megera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiommata' AND (junior_species='megera' OR junior_species='megera')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='Lasiommata' AND (species='megera' OR species='megera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanargia' AND (junior_species='grumi' OR junior_species='grumii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanargia' AND (species='grumi' OR species='grumii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanargia' AND (species='grumi' OR species='grumii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanargia' AND (junior_species='grumi' OR junior_species='grumii')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='Melanargia' AND (species='grumi' OR species='grumii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pararge' AND (junior_species='aegeria' OR junior_species='aegeria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pararge' AND (species='aegeria' OR species='aegeria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pararge' AND (species='aegeria' OR species='aegeria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pararge' AND (junior_species='aegeria' OR junior_species='aegeria')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='Pararge' AND (species='aegeria' OR species='aegeria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argynnis' AND (junior_species='pandora' OR junior_species='pandora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argynnis' AND (species='pandora' OR species='pandora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argynnis' AND (species='pandora' OR species='pandora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argynnis' AND (junior_species='pandora' OR junior_species='pandora')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='Argynnis' AND (species='pandora' OR species='pandora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='cardui' OR junior_species='carduii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='cardui' OR species='carduii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='cardui' OR junior_species='carduii')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='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='phlaeas' OR junior_species='phlaeas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='phlaeas' OR species='phlaeas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='phlaeas' OR species='phlaeas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='phlaeas' OR junior_species='phlaeas')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='Lycaena' AND (species='phlaeas' OR species='phlaeas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eogenes' AND (junior_species='alcides' OR junior_species='alcides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eogenes' AND (species='alcides' OR species='alcides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eogenes' AND (species='alcides' OR species='alcides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eogenes' AND (junior_species='alcides' OR junior_species='alcides')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='Eogenes' AND (species='alcides' OR species='alcides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='sylvestris' OR junior_species='sylvestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thymelicus' AND (species='sylvestris' OR species='sylvestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thymelicus' AND (species='sylvestris' OR species='sylvestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='sylvestris' OR junior_species='sylvestris')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='Thymelicus' AND (species='sylvestris' OR species='sylvestris') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3143 The Ecological Register: Senocak Road
Senocak Road
Basic information
Sample name: Senocak Road

Reference: E. Seven and C. Yildiz. 2018. On the butterflies of Savur District (Mardin Province, southeastern Turkey). Sakarya University Journal of Science 22(6):1907-1916 [ER 2951]
Geography
Country: Turkey

State: Mardin


Coordinate: 37° 38' 17" N, 40° 41' 35" E
Coordinate basis: stated in text

Geography comments: "Senocak road 4 km E"

Environment
Habitat: temperate savanna

Protection: unknown

Substrate: ground surface

Habitat comments: "Steppe area with sparse oaks"

Methods
Life forms: butterflies

Sampling methods: no design,butterfly nets

Sample size: 129 individuals

Years: 2017

Days: 1

Seasons: summer

Sampling comments: specimens "were caught with the aid of insect nets" on "13.06.2017" and preserved

Metadata
Sample number: 3143

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-12-31 08:36:27

Modified: 2018-12-30 21:36:27

Abundance distribution
16 species
0 singletons
total count 129
extrapolated richness: 19.2
Fisher's α: 4.811
geometric series k: 0.8908
Hurlbert's PIE: 0.9177
Shannon's H: 2.6254
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register