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=2673 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2673SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2435SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2673 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progonomys' AND (junior_species='cathalai' OR junior_species='cathalaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Progonomys' AND (species='cathalai' OR species='cathalaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Progonomys' AND (species='cathalai' OR species='cathalaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progonomys' AND (junior_species='cathalai' OR junior_species='cathalaii')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='Progonomys' AND (species='cathalai' OR species='cathalaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hispanomys' AND (junior_species='mediterraneus' OR junior_species='mediterraneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hispanomys' AND (species='mediterraneus' OR species='mediterraneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hispanomys' AND (species='mediterraneus' OR species='mediterraneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hispanomys' AND (junior_species='mediterraneus' OR junior_species='mediterraneus')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='Hispanomys' AND (species='mediterraneus' OR species='mediterraneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rotundomys' AND (junior_species='montisrotundi' OR junior_species='montisrotundii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rotundomys' AND (species='montisrotundi' OR species='montisrotundii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rotundomys' AND (species='montisrotundi' OR species='montisrotundii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rotundomys' AND (junior_species='montisrotundi' OR junior_species='montisrotundii')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='Rotundomys' AND (species='montisrotundi' OR species='montisrotundii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomalomys' AND (junior_species='gaillardi' OR junior_species='gaillardii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anomalomys' AND (species='gaillardi' OR species='gaillardii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anomalomys' AND (species='gaillardi' OR species='gaillardii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomalomys' AND (junior_species='gaillardi' OR junior_species='gaillardii')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='Anomalomys' AND (species='gaillardi' OR species='gaillardii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyops' AND (junior_species='catalaunicus' OR junior_species='catalaunicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomyops' AND (species='catalaunicus' OR species='catalaunicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomyops' AND (species='catalaunicus' OR species='catalaunicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyops' AND (junior_species='catalaunicus' OR junior_species='catalaunicus')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='Eomyops' AND (species='catalaunicus' OR species='catalaunicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='hispanicus' OR junior_species='hispanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscardinus' AND (species='hispanicus' OR species='hispanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscardinus' AND (species='hispanicus' OR species='hispanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='hispanicus' OR junior_species='hispanicus')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='Muscardinus' AND (species='hispanicus' OR species='hispanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='heintzi' OR junior_species='heintzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muscardinus' AND (species='heintzi' OR species='heintzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muscardinus' AND (species='heintzi' OR species='heintzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muscardinus' AND (junior_species='heintzi' OR junior_species='heintzii')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='Muscardinus' AND (species='heintzi' OR species='heintzii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='truci' OR junior_species='trucii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eliomys' AND (species='truci' OR species='trucii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eliomys' AND (species='truci' OR species='trucii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='truci' OR junior_species='trucii')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='Eliomys' AND (species='truci' OR species='trucii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petenya' 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='Petenya' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petenya' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petenya' 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='Petenya' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anourosorex' AND (junior_species='kormosi' OR junior_species='kormosii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anourosorex' AND (species='kormosi' OR species='kormosii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anourosorex' AND (species='kormosi' OR species='kormosii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anourosorex' AND (junior_species='kormosi' OR junior_species='kormosii')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='Anourosorex' AND (species='kormosi' OR species='kormosii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomyinae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neomyinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neomyinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomyinae' AND (junior_species='indet.' OR junior_species='indet.')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='Neomyinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petenyiella' AND (junior_species='repenningi' OR junior_species='repenningii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Petenyiella' AND (species='repenningi' OR species='repenningii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Petenyiella' AND (species='repenningi' OR species='repenningii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Petenyiella' AND (junior_species='repenningi' OR junior_species='repenningii')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='Petenyiella' AND (species='repenningi' OR species='repenningii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Soricidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Soricidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Soricidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Soricidae' AND (junior_species='indet.' OR junior_species='indet.')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='Soricidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmanella' AND (junior_species='stehlini' OR junior_species='stehlinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmanella' AND (species='stehlini' OR species='stehlinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Desmanella' AND (species='stehlini' OR species='stehlinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmanella' AND (junior_species='stehlini' OR junior_species='stehlinii')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='Desmanella' AND (species='stehlini' OR species='stehlinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Talpidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talpidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpidae' AND (junior_species='indet.' OR junior_species='indet.')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='Talpidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='socialis' OR junior_species='socialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galerix' AND (species='socialis' OR species='socialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galerix' AND (species='socialis' OR species='socialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='socialis' OR junior_species='socialis')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='Galerix' AND (species='socialis' OR species='socialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanthanotherium' AND (junior_species='sanmigueli' OR junior_species='sanmiguelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lanthanotherium' AND (species='sanmigueli' OR species='sanmiguelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lanthanotherium' AND (species='sanmigueli' OR species='sanmiguelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lanthanotherium' AND (junior_species='sanmigueli' OR junior_species='sanmiguelii')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='Lanthanotherium' AND (species='sanmigueli' OR species='sanmiguelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Postpalerinaceus' AND (junior_species='vireti' OR junior_species='viretii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Postpalerinaceus' AND (species='vireti' OR species='viretii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Postpalerinaceus' AND (species='vireti' OR species='viretii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Postpalerinaceus' AND (junior_species='vireti' OR junior_species='viretii')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='Postpalerinaceus' AND (species='vireti' OR species='viretii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiodimylus' AND (junior_species='chantrei' OR junior_species='chantreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiodimylus' AND (species='chantrei' OR species='chantreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiodimylus' AND (species='chantrei' OR species='chantreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiodimylus' AND (junior_species='chantrei' OR junior_species='chantreii')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='Plesiodimylus' AND (species='chantrei' OR species='chantreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molossidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Molossidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Molossidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Molossidae' AND (junior_species='indet.' OR junior_species='indet.')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='Molossidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespertilionidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vespertilionidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vespertilionidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespertilionidae' AND (junior_species='indet.' OR junior_species='indet.')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='Vespertilionidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespertilionidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vespertilionidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vespertilionidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespertilionidae' AND (junior_species='indet.' OR junior_species='indet.')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='Vespertilionidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2673 The Ecological Register: Montredon (niveau supérieur)
Montredon (niveau supérieur)
Basic information
Sample name: Montredon (niveau supérieur)

Reference: J.-P. Aguilar. 1982. Contributions à l'étude des micromammifères du gisement Miocène supérieur de Montredon (Hérault). 2- Les rongeurs. Palaeovertebrata 12(3):81-117 [ER 2435]
Geography
Country: France


Coordinate: 43° 20' N, 2° 54' E
Coordinate basis: based on nearby landmark

Time interval: Late Miocene

Zone: MN10

Age basis: zone

Geography comments: "sur la commune de Montouliers... á quelques 300 mètres de la limite avec le département de l'Aude" (Aguilar and Crochet 1982: coordinate based on Montouliers)
"un niveau situé une dizaine de mètres au-dessus" of the original Depéret quarry, "et dénommé niveau supérieur"
"Tortonien (zone D 2)" (not meaning the Spanish zone D); MN10 according to multiple sources

•
Environment
Substrate: ground surface

Habitat comments: lithology not discussed

Methods
Life forms: bats,rodents,other small mammals

Sampling methods: screenwash

Sample size: 1490 specimens

Years: 1977

Sampling comments: most or all of the material appears to have been collected in 1977 using "lavages du sédiment"
Heteroxerus cf. grivensis and Spermophilinus cf. bredai are listed but not described and might be from the lower level
insectivore list is from Crochet and Green (1982) and bat list is from Sigé (1982)
there is no discussion of whether large mammals are present in the upper level

Metadata
Sample number: 2673

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-03-05 15:34:49

Modified: 2017-03-05 04:40:48

Abundance distribution
22 species
4 singletons
total count 1490
extrapolated richness: 32.1
Fisher's α: 3.660
geometric series k: 0.7221
Hurlbert's PIE: 0.5690
Shannon's H: 1.3563
Good's u: 0.9973
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Progonomys cathalai276
Hispanomys mediterraneus44
new: count excludes 6 teeth from the "niveau Depéret"
Rotundomys montisrotundi932
Anomalomys gaillardi11
Eomyops catalaunicus2
Muscardinus hispanicus6
Muscardinus heintzi38
new
Eliomys cf. truci2
Petenya sp.3
Anourosorex kormosi20
Neomyinae indet.9
Petenyiella ? repenningi7
Soricidae indet.1
Desmanella cf. stehlini16
Talpidae indet.1
Galerix aff. socialis81
Lanthanotherium sanmigueli21
Postpalerinaceus vireti4
two specimens in the Basel collection are also listed, but might not pertain to this sample
Plesiodimylus chantrei12
Molossidae indet.1
cf this family
Vespertilionidae indet. 12
Vespertilionidae indet. 21