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=3144 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3144SELECT 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=3144 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='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='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='Pontia' AND (junior_species='edusa' OR junior_species='edusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pontia' AND (species='edusa' OR species='edusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pontia' AND (species='edusa' OR species='edusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pontia' AND (junior_species='edusa' OR junior_species='edusa')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='Pontia' AND (species='edusa' OR species='edusa') 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='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='Plebejus' AND (junior_species='zephyrinus' OR junior_species='zephyrinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plebejus' AND (species='zephyrinus' OR species='zephyrinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plebejus' AND (species='zephyrinus' OR species='zephyrinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='zephyrinus' OR junior_species='zephyrinus')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='Plebejus' AND (species='zephyrinus' OR species='zephyrinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carcharodus' AND (junior_species='lavatherae' OR junior_species='lavatherae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carcharodus' AND (species='lavatherae' OR species='lavatherae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carcharodus' AND (species='lavatherae' OR species='lavatherae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carcharodus' AND (junior_species='lavatherae' OR junior_species='lavatherae')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='Carcharodus' AND (species='lavatherae' OR species='lavatherae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carcharodus' AND (junior_species='alceae' OR junior_species='alceae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carcharodus' AND (species='alceae' OR species='alceae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carcharodus' AND (species='alceae' OR species='alceae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carcharodus' AND (junior_species='alceae' OR junior_species='alceae')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='Carcharodus' AND (species='alceae' OR species='alceae') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3144 The Ecological Register: Cinarönü Road
Cinarönü Road
Basic information
Sample name: Cinarönü 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° 35' 52" N, 40° 40' 38" E
Coordinate basis: stated in text

Geography comments: "Cinarönü road 3 km NW"

•
Environment
Habitat: temperate savanna

Protection: unknown

Substrate: ground surface

Habitat comments: "Moorland area"

Methods
Life forms: butterflies

Sampling methods: no design,butterfly nets

Sample size: 109 individuals

Years: 2017

Days: 2

Seasons: summer

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

Metadata
Sample number: 3144

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-12-31 08:42:07

Modified: 2018-12-30 21:42:07

Abundance distribution
13 species
0 singletons
total count 109
extrapolated richness: 15.5
Fisher's α: 3.848
geometric series k: 0.8327
Hurlbert's PIE: 0.9017
Shannon's H: 2.4369
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Colias crocea5
Pieris mannii7
Pieris rapae6
Pontia edusa10
Coenonympha pamphilus14
Hyponephele lycaon18
Kirinia roxelana7
Melanargia grumi14
Pararge aegeria8
Argynnis pandora5
Plebejus zephyrinus8
Carcharodus lavatherae2
Carcharodus alceae5