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=4303 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4303SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2372SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4303 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='zabiensis' OR junior_species='zabiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochotona' AND (species='zabiensis' OR species='zabiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotona' AND (species='zabiensis' OR species='zabiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='zabiensis' OR junior_species='zabiensis')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='Ochotona' AND (species='zabiensis' OR species='zabiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='vetus' OR junior_species='vetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Martes' AND (species='vetus' OR species='vetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Martes' AND (species='vetus' OR species='vetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='vetus' OR junior_species='vetus')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='Martes' AND (species='vetus' OR species='vetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='putorius' OR junior_species='putorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='putorius' OR species='putorius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='putorius' OR junior_species='putorius')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='Mustela' AND (species='putorius' OR species='putorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vormela' AND (junior_species='petenyii' OR junior_species='petenyi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vormela' AND (species='petenyii' OR species='petenyi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vormela' AND (species='petenyii' OR species='petenyi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vormela' AND (junior_species='petenyii' OR junior_species='petenyi')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='Vormela' AND (species='petenyii' OR species='petenyi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lunensis' OR junior_species='lunensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Felis' AND (species='lunensis' OR species='lunensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felis' AND (species='lunensis' OR species='lunensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lunensis' OR junior_species='lunensis')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='Felis' AND (species='lunensis' OR species='lunensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4303
Reference:A. Nadachowski, K. Stefaniak, A. Szynkiewicz, A. Marciszak, P. Socha, P. Schick, and C. August. 2011. Biostratigraphic importance of the Early Pleistocene fauna from Zabia Cave (Poland) in Central Europe. Quaternary International243:204-218 [ER 2372]
Geography
Country: Poland
State: Silesian Voivodeship
Coordinate:50.573612° N, 19.519722° E
Coordinate basis: stated in text
Time interval: Early Pleistocene
Zone: MNQ18/19
Unit number: 20
Unit order: below to above
Max Ma: 1.7
Min Ma: 1.3
Age basis: zone
Geography comments: Zabia Cave is located on the NE slope of Sulmów Hill near the town of Podlesice
It is dated to middle Early Pleistocene (Early Biharian, Zone MNQ 18-19), roughly 1.7 Ma - 1.3 Ma based on Fig. 12
•
Environment
Substrate: ground surface
Lithology: siltstone
Taphonomic context: cave
Habitat comments: "Thin layer of grey silts"
Information on accumulation is not provided
Methods
Life forms: carnivores,other small mammals
Sample size: 10 specimens
Sampling comments: Collecting methods not indicated
Metadata
Sample number: 4303
Contributor: Jack Nesbitt
Enterer: Jack Nesbitt
Created: 2023-06-23 13:32:26
Modified: 2023-06-23 05:29:13
Abundance distribution
5 species
2 singletons
total count 10
extrapolated richness: 14.3
Fisher's α: 3.980
geometric series k: 0.7071
Hurlbert's PIE: 0.7111
Shannon's H: 1.4708
Good's u: 0.8364
Each square represents a species. Square sizes are proportional to counts.