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=3140 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3140SELECT 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=3140 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporia' AND (junior_species='crataegi' OR junior_species='crataegii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporia' AND (species='crataegi' OR species='crataegii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporia' AND (species='crataegi' OR species='crataegii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporia' AND (junior_species='crataegi' OR junior_species='crataegii')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='Aporia' AND (species='crataegi' OR species='crataegii') ORDER BY year,last_namesSELECT 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='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='Pieris' AND (junior_species='brassicae' OR junior_species='brassicae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='brassicae' OR species='brassicae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='brassicae' OR species='brassicae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='brassicae' OR junior_species='brassicae')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='brassicae' OR species='brassicae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='saadi' OR junior_species='saadii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='saadi' OR species='saadii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='saadi' OR species='saadii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='saadi' OR junior_species='saadii')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='saadi' OR species='saadii') 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='Maniola' AND (junior_species='telmessia' OR junior_species='telmessia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maniola' AND (species='telmessia' OR species='telmessia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maniola' AND (species='telmessia' OR species='telmessia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maniola' AND (junior_species='telmessia' OR junior_species='telmessia')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='Maniola' AND (species='telmessia' OR species='telmessia') 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='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='Polyommatus' AND (junior_species='agestis' OR junior_species='agestis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='agestis' OR species='agestis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='agestis' OR species='agestis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='agestis' OR junior_species='agestis')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='Polyommatus' AND (species='agestis' OR species='agestis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='icarus' OR junior_species='icarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='icarus' OR species='icarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='icarus' OR species='icarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='icarus' OR junior_species='icarus')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='Polyommatus' AND (species='icarus' OR species='icarus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='lineolus' OR junior_species='lineolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thymelicus' AND (species='lineolus' OR species='lineolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thymelicus' AND (species='lineolus' OR species='lineolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='lineolus' OR junior_species='lineolus')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='lineolus' OR species='lineolus') 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=3140 The Ecological Register: Kirdirek
Kirdirek
Basic information
Sample name: Kirdirek

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° 40' 24" N, 40° 44' 26" E
Coordinate basis: stated in text

Environment
Habitat: temperate savanna

Protection: unknown

Substrate: ground surface

Habitat comments: "Steppe area"

Methods
Life forms: butterflies

Sampling methods: no design,butterfly nets

Sample size: 176 individuals

Years: 2017

Days: 1

Seasons: spring

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

Metadata
Sample number: 3140

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-12-31 08:18:44

Modified: 2018-12-30 21:46:39

Abundance distribution
15 species
0 singletons
total count 176
extrapolated richness: 16.9
Fisher's α: 3.920
geometric series k: 0.8548
Hurlbert's PIE: 0.9051
Shannon's H: 2.5430
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
Register