Coordinate: 48° 25' N, 9° 54' E
additional taxa other than Propalaeochoerus gergovianus (count not given) are not discussed; other small mammals are presumed to be present based on the composition of the other Herrlingen samples
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=2653 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2653SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2425SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2653 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='goti' OR junior_species='gotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeosciurus' AND (species='goti' OR species='gotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeosciurus' AND (species='goti' OR species='gotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='goti' OR junior_species='gotii')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='goti' OR species='gotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridyromys' AND (junior_species='murinus' OR junior_species='murinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peridyromys' AND (species='murinus' OR species='murinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peridyromys' AND (species='murinus' OR species='murinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridyromys' AND (junior_species='murinus' OR junior_species='murinus')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='murinus' OR species='murinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='legidensis' OR junior_species='legidensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microdyromys' AND (species='legidensis' OR species='legidensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='legidensis' OR species='legidensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='legidensis' OR junior_species='legidensis')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='legidensis' OR species='legidensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='glirulus' OR junior_species='glirulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirudinus' AND (species='glirulus' OR species='glirulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirudinus' AND (species='glirulus' OR species='glirulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='glirulus' OR junior_species='glirulus')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='Glirudinus' AND (species='glirulus' OR species='glirulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='reductus' OR junior_species='reductus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomys' AND (species='reductus' OR species='reductus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomys' AND (species='reductus' OR species='reductus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='reductus' OR junior_species='reductus')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='reductus' OR species='reductus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='huerzeleri' OR junior_species='huerzelerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomys' AND (species='huerzeleri' OR species='huerzelerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomys' AND (species='huerzeleri' OR species='huerzelerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomys' AND (junior_species='huerzeleri' OR junior_species='huerzelerii')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='huerzeleri' OR species='huerzelerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyodon' AND (junior_species='volkeri' OR junior_species='volkerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomyodon' AND (species='volkeri' OR species='volkerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomyodon' AND (species='volkeri' OR species='volkerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyodon' AND (junior_species='volkeri' OR junior_species='volkerii')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='Eomyodon' AND (species='volkeri' OR species='volkerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyodon' AND (junior_species='pusillus' OR junior_species='pusillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eomyodon' AND (species='pusillus' OR species='pusillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eomyodon' AND (species='pusillus' OR species='pusillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eomyodon' AND (junior_species='pusillus' OR junior_species='pusillus')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='Eomyodon' AND (species='pusillus' OR species='pusillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='dubius' OR junior_species='dubius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucricetodon' AND (species='dubius' OR species='dubius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucricetodon' AND (species='dubius' OR species='dubius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='dubius' OR junior_species='dubius')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='dubius' OR species='dubius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='liber' OR junior_species='liber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucricetodon' AND (species='liber' OR species='liber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucricetodon' AND (species='liber' OR species='liber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucricetodon' AND (junior_species='liber' OR junior_species='liber')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='liber' OR species='liber') 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='Adelomyarion' 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='Adelomyarion' AND (species='vireti' OR species='viretii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Adelomyarion' AND (species='vireti' OR species='viretii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Adelomyarion' 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='Adelomyarion' AND (species='vireti' OR species='viretii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissiodon' AND (junior_species='quercyi' OR junior_species='quercyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissiodon' AND (species='quercyi' OR species='quercyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissiodon' AND (species='quercyi' OR species='quercyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissiodon' AND (junior_species='quercyi' OR junior_species='quercyii')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='quercyi' OR species='quercyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiosminthus' AND (junior_species='conjunctus' OR junior_species='conjunctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiosminthus' AND (species='conjunctus' OR species='conjunctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiosminthus' AND (species='conjunctus' OR species='conjunctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiosminthus' AND (junior_species='conjunctus' OR junior_species='conjunctus')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='Plesiosminthus' AND (species='conjunctus' OR species='conjunctus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2653