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=4310 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4310SELECT 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=4310 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='Rana' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rana' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rana' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='sp.' OR junior_species='sp.')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='Rana' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguis' AND (junior_species='fragilis' OR junior_species='fragilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anguis' AND (species='fragilis' OR species='fragilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anguis' AND (species='fragilis' OR species='fragilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguis' AND (junior_species='fragilis' OR junior_species='fragilis')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='Anguis' AND (species='fragilis' OR species='fragilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacerta' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacerta' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='sp.' OR junior_species='sp.')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='sp.' OR species='sp.') ORDER BY year,last_namesSELECT 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='Allocricetus' AND (junior_species='bursae' OR junior_species='bursae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allocricetus' AND (species='bursae' OR species='bursae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allocricetus' AND (species='bursae' OR species='bursae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allocricetus' AND (junior_species='bursae' OR junior_species='bursae')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='Allocricetus' AND (species='bursae' OR species='bursae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allocricetus' AND (junior_species='ehiki' OR junior_species='ehikii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allocricetus' AND (species='ehiki' OR species='ehikii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allocricetus' AND (species='ehiki' OR species='ehikii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allocricetus' AND (junior_species='ehiki' OR junior_species='ehikii')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='Allocricetus' AND (species='ehiki' OR species='ehikii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='hintonianus' OR junior_species='hintonianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='hintonianus' OR species='hintonianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myodes' AND (species='hintonianus' OR species='hintonianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='hintonianus' OR junior_species='hintonianus')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='Myodes' AND (species='hintonianus' OR species='hintonianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagurus' AND (junior_species='ternopolitanus' OR junior_species='ternopolitanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prolagurus' AND (species='ternopolitanus' OR species='ternopolitanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prolagurus' AND (species='ternopolitanus' OR species='ternopolitanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagurus' AND (junior_species='ternopolitanus' OR junior_species='ternopolitanus')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='Prolagurus' AND (species='ternopolitanus' OR species='ternopolitanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='deucalion' OR junior_species='deucalion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='deucalion' OR species='deucalion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='deucalion' OR species='deucalion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='deucalion' OR junior_species='deucalion')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='Microtus' AND (species='deucalion' OR species='deucalion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliomys' AND (junior_species='episcopalis' OR junior_species='episcopalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pliomys' AND (species='episcopalis' OR species='episcopalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pliomys' AND (species='episcopalis' OR species='episcopalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliomys' AND (junior_species='episcopalis' OR junior_species='episcopalis')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='Pliomys' AND (species='episcopalis' OR species='episcopalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ungaromys' AND (junior_species='nanus' OR junior_species='nanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ungaromys' AND (species='nanus' OR species='nanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ungaromys' AND (species='nanus' OR species='nanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ungaromys' AND (junior_species='nanus' OR junior_species='nanus')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='Ungaromys' AND (species='nanus' OR species='nanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sicista' AND (junior_species='praeloriger' OR junior_species='praeloriger')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sicista' AND (species='praeloriger' OR species='praeloriger') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sicista' AND (species='praeloriger' OR species='praeloriger')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sicista' AND (junior_species='praeloriger' OR junior_species='praeloriger')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='Sicista' AND (species='praeloriger' OR species='praeloriger') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gulo' AND (junior_species='schlosseri' OR junior_species='schlosserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gulo' AND (species='schlosseri' OR species='schlosserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gulo' AND (species='schlosseri' OR species='schlosserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gulo' AND (junior_species='schlosseri' OR junior_species='schlosserii')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='Gulo' AND (species='schlosseri' OR species='schlosserii') 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 * FROM register WHERE sample_no=4310 The Ecological Register: Zabia Cave (Layer 12)
Zabia Cave (Layer 12)
Basic information
Sample name: Zabia Cave (Layer 12)

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 International 243: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: 12

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: siliciclastic (mixed)

Taphonomic context: cave

Habitat comments: "Brown cave loams with large damaged limestone fragments, dripstone fragments, and calcite crystals"

Information on accumulation is not provided

Methods
Life forms: carnivores,rodents,other small mammals,lizards,frogs

Sample size: 36 specimens

Sampling comments: Collecting methods not indicated

Multiple insectivores are listed with no counts

Metadata
Sample number: 4310

Contributor: Jack Nesbitt

Enterer: Jack Nesbitt

Created: 2023-06-26 11:00:09

Modified: 2023-06-26 01:00:09

Abundance distribution
15 species
8 singletons
total count 36
extrapolated richness: 47.2
Fisher's α: 9.655
geometric series k: 0.8799
Hurlbert's PIE: 0.8873
Shannon's H: 2.4237
Good's u: 0.7824
Each square represents a species. Square sizes are proportional to counts.
Register