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=2636 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2636SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2421SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2636 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' 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='Prolagus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prolagus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' 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='Prolagus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='oeningensis' OR junior_species='oeningensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prolagus' AND (species='oeningensis' OR species='oeningensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prolagus' AND (species='oeningensis' OR species='oeningensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='oeningensis' OR junior_species='oeningensis')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='Prolagus' AND (species='oeningensis' OR species='oeningensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagopsis' AND (junior_species='penai' OR junior_species='penaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagopsis' AND (species='penai' OR species='penaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagopsis' AND (species='penai' OR species='penaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagopsis' AND (junior_species='penai' OR junior_species='penaii')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='Lagopsis' AND (species='penai' OR species='penaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='collongensis' OR junior_species='collongensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megacricetodon' AND (species='collongensis' OR species='collongensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megacricetodon' AND (species='collongensis' OR species='collongensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='collongensis' OR junior_species='collongensis')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='Megacricetodon' AND (species='collongensis' OR species='collongensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='bizianensis' OR junior_species='bizianensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megacricetodon' AND (species='bizianensis' OR species='bizianensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megacricetodon' AND (species='bizianensis' OR species='bizianensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megacricetodon' AND (junior_species='bizianensis' OR junior_species='bizianensis')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='Megacricetodon' AND (species='bizianensis' OR species='bizianensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='mutilus' OR junior_species='mutilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='mutilus' OR species='mutilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='mutilus' OR species='mutilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='mutilus' OR junior_species='mutilus')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='Democricetodon' AND (species='mutilus' OR species='mutilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='gracilis' OR junior_species='gracilis')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='Democricetodon' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='romieviensis' OR junior_species='romieviensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='romieviensis' OR species='romieviensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='romieviensis' OR species='romieviensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='romieviensis' OR junior_species='romieviensis')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='Democricetodon' AND (species='romieviensis' OR species='romieviensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='latior' OR junior_species='latior')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumyarion' AND (species='latior' OR species='latior') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='latior' OR species='latior')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='latior' OR junior_species='latior')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='Eumyarion' AND (species='latior' OR species='latior') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissiodon' 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='Melissiodon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissiodon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissiodon' 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='Melissiodon' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miodyromys' AND (junior_species='biradiculus' OR junior_species='biradiculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miodyromys' AND (species='biradiculus' OR species='biradiculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miodyromys' AND (species='biradiculus' OR species='biradiculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miodyromys' AND (junior_species='biradiculus' OR junior_species='biradiculus')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='Miodyromys' AND (species='biradiculus' OR species='biradiculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodryomys' AND (junior_species='ibericus' OR junior_species='ibericus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudodryomys' AND (species='ibericus' OR species='ibericus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudodryomys' AND (species='ibericus' OR species='ibericus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudodryomys' AND (junior_species='ibericus' OR junior_species='ibericus')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='Pseudodryomys' AND (species='ibericus' OR species='ibericus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bransatoglis' AND (junior_species='cadeoti' OR junior_species='cadeotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bransatoglis' AND (species='cadeoti' OR species='cadeotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bransatoglis' AND (species='cadeoti' OR species='cadeotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bransatoglis' AND (junior_species='cadeoti' OR junior_species='cadeotii')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='Bransatoglis' AND (species='cadeoti' OR species='cadeotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ligerimys' AND (junior_species='florancei' OR junior_species='floranceii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ligerimys' AND (species='florancei' OR species='floranceii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ligerimys' AND (species='florancei' OR species='floranceii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ligerimys' AND (junior_species='florancei' OR junior_species='floranceii')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='Ligerimys' AND (species='florancei' OR species='floranceii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='rubricati' OR junior_species='rubricatii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteroxerus' AND (species='rubricati' OR species='rubricatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteroxerus' AND (species='rubricati' OR species='rubricatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='rubricati' OR junior_species='rubricatii')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='Heteroxerus' AND (species='rubricati' OR species='rubricatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='besana' OR junior_species='besana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophilinus' AND (species='besana' OR species='besana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophilinus' AND (species='besana' OR species='besana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='besana' OR junior_species='besana')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='Spermophilinus' AND (species='besana' OR species='besana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='fissurae' OR junior_species='fissurae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeosciurus' AND (species='fissurae' OR species='fissurae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeosciurus' AND (species='fissurae' OR species='fissurae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='fissurae' OR junior_species='fissurae')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='Palaeosciurus' AND (species='fissurae' OR species='fissurae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemicyon' 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='Hemicyon' AND (species='stehlini' OR species='stehlinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemicyon' AND (species='stehlini' OR species='stehlinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemicyon' 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='Hemicyon' AND (species='stehlini' OR species='stehlinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anchitherium' AND (junior_species='aurelianense' OR junior_species='aurelianense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anchitherium' AND (species='aurelianense' OR species='aurelianense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anchitherium' AND (species='aurelianense' OR species='aurelianense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anchitherium' AND (junior_species='aurelianense' OR junior_species='aurelianense')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='Anchitherium' AND (species='aurelianense' OR species='aurelianense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachypotherium' AND (junior_species='brachypus' OR junior_species='brachypus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachypotherium' AND (species='brachypus' OR species='brachypus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachypotherium' AND (species='brachypus' OR species='brachypus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachypotherium' AND (junior_species='brachypus' OR junior_species='brachypus')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='Brachypotherium' AND (species='brachypus' OR species='brachypus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosantorhinus' AND (junior_species='douvillei' OR junior_species='douvilleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prosantorhinus' AND (species='douvillei' OR species='douvilleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prosantorhinus' AND (species='douvillei' OR species='douvilleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosantorhinus' AND (junior_species='douvillei' OR junior_species='douvilleii')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='Prosantorhinus' AND (species='douvillei' OR species='douvilleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bunolistriodon' AND (junior_species='lockharti' OR junior_species='lockhartii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bunolistriodon' AND (species='lockharti' OR species='lockhartii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bunolistriodon' AND (species='lockharti' OR species='lockhartii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bunolistriodon' AND (junior_species='lockharti' OR junior_species='lockhartii')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='Bunolistriodon' AND (species='lockharti' OR species='lockhartii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorcatherium' AND (junior_species='guntianum' OR junior_species='guntianum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorcatherium' AND (species='guntianum' OR species='guntianum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorcatherium' AND (species='guntianum' OR species='guntianum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorcatherium' AND (junior_species='guntianum' OR junior_species='guntianum')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='Dorcatherium' AND (species='guntianum' OR species='guntianum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procervulus' AND (junior_species='dichotomus' OR junior_species='dichotomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procervulus' AND (species='dichotomus' OR species='dichotomus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Procervulus' AND (species='dichotomus' OR species='dichotomus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procervulus' AND (junior_species='dichotomus' OR junior_species='dichotomus')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='Procervulus' AND (species='dichotomus' OR species='dichotomus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2636 The Ecological Register: La Bastide
La Bastide
Basic information
Sample name: La Bastide

Reference: C. Bulot, L. Ginsburg, and D. Harêne. 2001. Mammifères fossiles du Miocène moyen (MN 4 b) de La Bastide et du Baradieu à Condom (Gers). Bulletin de la Société d'Histoire naturelle de Toulouse 137:69-85 [ER 2421]
Geography
Country: France


Coordinate: 43° 58' N, 0° 22' E
Coordinate basis: based on nearby landmark

Time interval: Early Miocene

Zone: MN4b

Age basis: zone

Geography comments: "á 5 km au NE de Condom" (coordinate based on Condom)

Environment
Substrate: ground surface

Habitat comments: "sables et argiles" (exact lithology unclear)

Methods
Life forms: carnivores,rodents,ungulates,other small mammals

Sample size: 220 specimens

Sampling comments: collection methods not discussed
counts of Prolagus are of p3s only

Metadata
Sample number: 2636

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-22 20:18:03

Modified: 2017-02-22 09:19:46

Abundance distribution
24 species
3 singletons
total count 220
extrapolated richness: 34.0
Fisher's α: 6.860
geometric series k: 0.8579
Hurlbert's PIE: 0.9083
Shannon's H: 2.7054
Good's u: 0.9864
Each square represents a species. Square sizes are proportional to counts.
Register