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=2648 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2648SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2424SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2648 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='ambiguum' OR junior_species='ambiguum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiperatherium' AND (species='ambiguum' OR species='ambiguum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiperatherium' AND (species='ambiguum' OR species='ambiguum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='ambiguum' OR junior_species='ambiguum')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='Amphiperatherium' AND (species='ambiguum' OR species='ambiguum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saturninia' 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='Saturninia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saturninia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saturninia' 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='Saturninia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracus' 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='Tetracus' AND (species='nanus' OR species='nanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetracus' AND (species='nanus' OR species='nanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracus' 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='Tetracus' AND (species='nanus' OR species='nanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracus' 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='Tetracus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetracus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracus' 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='Tetracus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Echinosoricinae' 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='Echinosoricinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Echinosoricinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Echinosoricinae' 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='Echinosoricinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myxomygale' AND (junior_species='antiqua' OR junior_species='antiqua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myxomygale' AND (species='antiqua' OR species='antiqua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myxomygale' AND (species='antiqua' OR species='antiqua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myxomygale' AND (junior_species='antiqua' OR junior_species='antiqua')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='Myxomygale' AND (species='antiqua' OR species='antiqua') 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='Dimylidae' 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='Dimylidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dimylidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dimylidae' 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='Dimylidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterosoricidae' 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='Heterosoricidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterosoricidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterosoricidae' 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='Heterosoricidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterosoricidae' 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='Heterosoricidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterosoricidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterosoricidae' 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='Heterosoricidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Srinitium' AND (junior_species='marteli' OR junior_species='martelii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Srinitium' AND (species='marteli' OR species='martelii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Srinitium' AND (species='marteli' OR species='martelii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Srinitium' AND (junior_species='marteli' OR junior_species='martelii')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='Srinitium' AND (species='marteli' OR species='martelii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridomys' 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='Theridomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Theridomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Theridomys' 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='Theridomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciuromys' AND (junior_species='cayluxi' OR junior_species='cayluxii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciuromys' AND (species='cayluxi' OR species='cayluxii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sciuromys' AND (species='cayluxi' OR species='cayluxii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciuromys' AND (junior_species='cayluxi' OR junior_species='cayluxii')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='Sciuromys' AND (species='cayluxi' OR species='cayluxii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microsuevosciurus' AND (junior_species='minimus' OR junior_species='minimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microsuevosciurus' AND (species='minimus' OR species='minimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microsuevosciurus' AND (species='minimus' OR species='minimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microsuevosciurus' AND (junior_species='minimus' OR junior_species='minimus')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='Microsuevosciurus' AND (species='minimus' OR species='minimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suevosciurus' AND (junior_species='dehmi' OR junior_species='dehmii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Suevosciurus' AND (species='dehmi' OR species='dehmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Suevosciurus' AND (species='dehmi' OR species='dehmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suevosciurus' AND (junior_species='dehmi' OR junior_species='dehmii')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='Suevosciurus' AND (species='dehmi' OR species='dehmii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suevosciurus' AND (junior_species='fraasi' OR junior_species='fraasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Suevosciurus' AND (species='fraasi' OR species='fraasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Suevosciurus' AND (species='fraasi' OR species='fraasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suevosciurus' AND (junior_species='fraasi' OR junior_species='fraasii')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='Suevosciurus' AND (species='fraasi' OR species='fraasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suevosciurus' AND (junior_species='ehingensis' OR junior_species='ehingensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Suevosciurus' AND (species='ehingensis' OR species='ehingensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Suevosciurus' AND (species='ehingensis' OR species='ehingensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suevosciurus' AND (junior_species='ehingensis' OR junior_species='ehingensis')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='Suevosciurus' AND (species='ehingensis' OR species='ehingensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudosciurus' AND (junior_species='praecedens' OR junior_species='praecedens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudosciurus' AND (species='praecedens' OR species='praecedens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudosciurus' AND (species='praecedens' OR species='praecedens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudosciurus' AND (junior_species='praecedens' OR junior_species='praecedens')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='Pseudosciurus' AND (species='praecedens' OR species='praecedens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudosciurus' AND (junior_species='suevicus' OR junior_species='suevicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudosciurus' AND (species='suevicus' OR species='suevicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudosciurus' AND (species='suevicus' OR species='suevicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudosciurus' AND (junior_species='suevicus' OR junior_species='suevicus')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='Pseudosciurus' AND (species='suevicus' OR species='suevicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigonomys' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trigonomys' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trigonomys' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trigonomys' AND (junior_species='simplex' OR junior_species='simplex')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='Trigonomys' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracitellus' AND (junior_species='marmoreus' OR junior_species='marmoreus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paracitellus' AND (species='marmoreus' OR species='marmoreus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paracitellus' AND (species='marmoreus' OR species='marmoreus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracitellus' AND (junior_species='marmoreus' OR junior_species='marmoreus')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='Paracitellus' AND (species='marmoreus' OR species='marmoreus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiospermophilus' AND (junior_species='atavus' OR junior_species='atavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiospermophilus' AND (species='atavus' OR species='atavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiospermophilus' AND (species='atavus' OR species='atavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiospermophilus' AND (junior_species='atavus' OR junior_species='atavus')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='Plesiospermophilus' AND (species='atavus' OR species='atavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiospermophilus' AND (junior_species='angustidens' OR junior_species='angustidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiospermophilus' AND (species='angustidens' OR species='angustidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiospermophilus' AND (species='angustidens' OR species='angustidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiospermophilus' AND (junior_species='angustidens' OR junior_species='angustidens')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='Plesiospermophilus' AND (species='angustidens' OR species='angustidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligopetes' AND (junior_species='radialis' OR junior_species='radialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligopetes' AND (species='radialis' OR species='radialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligopetes' AND (species='radialis' OR species='radialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligopetes' AND (junior_species='radialis' OR junior_species='radialis')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='Oligopetes' AND (species='radialis' OR species='radialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligopetes' AND (junior_species='obtusus' OR junior_species='obtusus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligopetes' AND (species='obtusus' OR species='obtusus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligopetes' AND (species='obtusus' OR species='obtusus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligopetes' AND (junior_species='obtusus' OR junior_species='obtusus')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='Oligopetes' AND (species='obtusus' OR species='obtusus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliravus' AND (junior_species='tenuis' OR junior_species='tenuis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gliravus' AND (species='tenuis' OR species='tenuis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gliravus' AND (species='tenuis' OR species='tenuis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliravus' AND (junior_species='tenuis' OR junior_species='tenuis')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='Gliravus' AND (species='tenuis' OR species='tenuis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' 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='Microdyromys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' 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='Microdyromys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bransatoglis' AND (junior_species='fugax' OR junior_species='fugax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bransatoglis' AND (species='fugax' OR species='fugax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bransatoglis' AND (species='fugax' OR species='fugax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bransatoglis' AND (junior_species='fugax' OR junior_species='fugax')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='fugax' OR species='fugax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridyromys' 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='Peridyromys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peridyromys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridyromys' 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='Peridyromys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliridae' 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='Gliridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gliridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gliridae' 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='Gliridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='antiquus' OR junior_species='antiquus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomys' AND (species='antiquus' OR species='antiquus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomys' AND (species='antiquus' OR species='antiquus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='antiquus' OR junior_species='antiquus')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='Eomys' AND (species='antiquus' OR species='antiquus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='atavus' OR junior_species='atavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucricetodon' AND (species='atavus' OR species='atavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucricetodon' AND (species='atavus' OR species='atavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='atavus' OR junior_species='atavus')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='Eucricetodon' AND (species='atavus' OR species='atavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocricetodon' AND (junior_species='montalbanensis' OR junior_species='montalbanensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudocricetodon' AND (species='montalbanensis' OR species='montalbanensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocricetodon' AND (species='montalbanensis' OR species='montalbanensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocricetodon' AND (junior_species='montalbanensis' OR junior_species='montalbanensis')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='Pseudocricetodon' AND (species='montalbanensis' OR species='montalbanensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracricetodon' AND (junior_species='dehmi' OR junior_species='dehmii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paracricetodon' AND (species='dehmi' OR species='dehmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paracricetodon' AND (species='dehmi' OR species='dehmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracricetodon' AND (junior_species='dehmi' OR junior_species='dehmii')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='Paracricetodon' AND (species='dehmi' OR species='dehmii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustelictis' 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='Mustelictis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mustelictis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustelictis' 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='Mustelictis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustelidae' 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='Mustelidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mustelidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustelidae' 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='Mustelidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carnivora' 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='Carnivora' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carnivora' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carnivora' 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='Carnivora' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paroxacron' 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='Paroxacron' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paroxacron' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paroxacron' 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='Paroxacron' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagiolophus' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plagiolophus' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plagiolophus' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagiolophus' AND (junior_species='minor' OR junior_species='minor')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='Plagiolophus' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2648 The Ecological Register: Ehrenstein 8
Ehrenstein 8
Basic information
Sample name: Ehrenstein 8

Reference: R. Ziegler and E. P. J. Heizmann. 1991. Oligozäne Säugetierfaunen aus den Spatlenfüllungen von Lautern, Herllingen und Ehrenstein bei Ulm (Baden-Württemberg). Stuttgarter Beiträge zur Naturkunde. Serie B (Geologie und Paläontologie) 171:1-26 [ER 2424]
Geography
Country: Germany


Coordinate: 48° 26' N, 9° 53' E
Coordinate basis: based on nearby landmark

Time interval: Early Oligocene

Zone: MP22

Age basis: zone

Geography comments: in the "Weissjura-Steinbruch der Ulmer Weisskalkwerke K. Mühlen & Co., ca. 500 NE des Ortsausgangs von Blaustein, Ortsteil Ehrenstein... E der Strasse" (coordinate based on Blaustein)

•
Environment
Substrate: ground surface

Habitat comments: "in der Mitte der Ostwand an der tiefsten Sohle des Steinbruchs eine weitere, weniger reiche fossilführende Spalte" than Ehrenstein 7 (exactly lithology not discussed)

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

Sampling methods: screenwash

Sample size: 777 specimens

Years: 1989

Sampling comments: weight of sediment sample numbert discussed

Metadata
Sample number: 2648

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-24 19:02:56

Modified: 2017-02-24 08:02:56

Abundance distribution
39 species
16 singletons
total count 777
extrapolated richness: 87.7
Fisher's α: 8.649
geometric series k: 0.8559
Hurlbert's PIE: 0.6865
Shannon's H: 1.7489
Good's u: 0.9794
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Amphiperatherium ambiguum2
Saturninia sp. 28
Tetracus nanus17
Tetracus sp.1
questionably
Echinosoricinae indet.1
Myxomygale cf. antiqua5
Talpidae indet.1
Dimylidae indet.1
Heterosoricidae indet. 19
Heterosoricidae indet. 26
Srinitium cf. marteli2
Theridomys sp.18
Sciuromys cayluxi1
Microsuevosciurus ? minimus2
Suevosciurus dehmi222
Suevosciurus ? fraasi2
Suevosciurus ehingensis3
Pseudosciurus ? praecedens1
Pseudosciurus suevicus370
Trigonomys aff. simplex2
Paracitellus cf. marmoreus1
Plesiospermophilus aff. atavus2
Plesiospermophilus angustidens4
Oligopetes cf. radialis2
Oligopetes cf. obtusus1
Gliravus aff. tenuis6
Microdyromys sp.23
said to be new
Bransatoglis aff. fugax5
Peridyromys sp.1
Gliridae indet.1
Eomys cf. antiquus14
Eucricetodon atavus34
Pseudocricetodon cf. montalbanensis1
Paracricetodon aff. dehmi3
Mustelictis sp.1
Mustelidae indet.1
Carnivora indet.1
Paroxacron sp.1
Plagiolophus minor1