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=2642 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2642SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2423SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2642 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='frequens' OR junior_species='frequens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiperatherium' AND (species='frequens' OR species='frequens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiperatherium' AND (species='frequens' OR species='frequens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='frequens' OR junior_species='frequens')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='frequens' OR species='frequens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='symeonidisi' OR junior_species='symeonidisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Galerix' AND (species='symeonidisi' OR species='symeonidisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Galerix' AND (species='symeonidisi' OR species='symeonidisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Galerix' AND (junior_species='symeonidisi' OR junior_species='symeonidisii')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='symeonidisi' OR species='symeonidisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmanella' AND (junior_species='engesseri' OR junior_species='engesserii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Desmanella' AND (species='engesseri' OR species='engesserii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Desmanella' AND (species='engesseri' OR species='engesserii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmanella' AND (junior_species='engesseri' OR junior_species='engesserii')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='engesseri' OR species='engesserii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proscapanus' AND (junior_species='intercedens-sansaniensis' OR junior_species='intercedens-sansaniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proscapanus' AND (species='intercedens-sansaniensis' OR species='intercedens-sansaniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proscapanus' AND (species='intercedens-sansaniensis' OR species='intercedens-sansaniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proscapanus' AND (junior_species='intercedens-sansaniensis' OR junior_species='intercedens-sansaniensis')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='Proscapanus' AND (species='intercedens-sansaniensis' OR species='intercedens-sansaniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scaptonyx' AND (junior_species='edwardsi' OR junior_species='edwardsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scaptonyx' AND (species='edwardsi' OR species='edwardsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scaptonyx' AND (species='edwardsi' OR species='edwardsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scaptonyx' AND (junior_species='edwardsi' OR junior_species='edwardsii')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='Scaptonyx' AND (species='edwardsi' OR species='edwardsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmanodon' 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='Desmanodon' AND (species='antiquus' OR species='antiquus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Desmanodon' AND (species='antiquus' OR species='antiquus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Desmanodon' 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='Desmanodon' AND (species='antiquus' OR species='antiquus') 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='Dinosorex' AND (junior_species='zapfei' OR junior_species='zapfeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinosorex' AND (species='zapfei' OR species='zapfeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinosorex' AND (species='zapfei' OR species='zapfeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinosorex' AND (junior_species='zapfei' OR junior_species='zapfeii')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='Dinosorex' AND (species='zapfei' OR species='zapfeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterosorex' AND (junior_species='neumayrianus' OR junior_species='neumayrianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heterosorex' AND (species='neumayrianus' OR species='neumayrianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterosorex' AND (species='neumayrianus' OR species='neumayrianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterosorex' AND (junior_species='neumayrianus' OR junior_species='neumayrianus')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='Heterosorex' AND (species='neumayrianus' OR species='neumayrianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' 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='Sorex' AND (species='dehmi' OR species='dehmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='dehmi' OR species='dehmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' 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='Sorex' AND (species='dehmi' OR species='dehmii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miosorex' AND (junior_species='grivensis' OR junior_species='grivensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miosorex' AND (species='grivensis' OR species='grivensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miosorex' AND (species='grivensis' OR species='grivensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miosorex' AND (junior_species='grivensis' OR junior_species='grivensis')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='Miosorex' AND (species='grivensis' OR species='grivensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnoecus' 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='Limnoecus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnoecus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnoecus' 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='Limnoecus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='sutteri' OR junior_species='sutterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeosciurus' AND (species='sutteri' OR species='sutterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeosciurus' AND (species='sutteri' OR species='sutterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeosciurus' AND (junior_species='sutteri' OR junior_species='sutterii')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='sutteri' OR species='sutterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='bredai' OR junior_species='bredaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spermophilinus' AND (species='bredai' OR species='bredaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spermophilinus' AND (species='bredai' OR species='bredaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spermophilinus' AND (junior_species='bredai' OR junior_species='bredaii')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='bredai' OR species='bredaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='huerzeleri-rubricati' OR junior_species='huerzeleri-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='huerzeleri-rubricati' OR species='huerzeleri-rubricatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteroxerus' AND (species='huerzeleri-rubricati' OR species='huerzeleri-rubricatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteroxerus' AND (junior_species='huerzeleri-rubricati' OR junior_species='huerzeleri-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='huerzeleri-rubricati' OR species='huerzeleri-rubricatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miopetaurista' 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='Miopetaurista' AND (species='dehmi' OR species='dehmii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miopetaurista' AND (species='dehmi' OR species='dehmii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miopetaurista' 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='Miopetaurista' AND (species='dehmi' OR species='dehmii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blackia' AND (junior_species='miocaenica' OR junior_species='miocaenica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blackia' AND (species='miocaenica' OR species='miocaenica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blackia' AND (species='miocaenica' OR species='miocaenica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blackia' AND (junior_species='miocaenica' OR junior_species='miocaenica')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='Blackia' AND (species='miocaenica' OR species='miocaenica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='modestus' OR junior_species='modestus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirudinus' AND (species='modestus' OR species='modestus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirudinus' AND (species='modestus' OR species='modestus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirudinus' AND (junior_species='modestus' OR junior_species='modestus')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='modestus' OR species='modestus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='praemurinus' OR junior_species='praemurinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microdyromys' AND (species='praemurinus' OR species='praemurinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microdyromys' AND (species='praemurinus' OR species='praemurinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microdyromys' AND (junior_species='praemurinus' OR junior_species='praemurinus')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='praemurinus' OR species='praemurinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirulus' AND (junior_species='diremptus' OR junior_species='diremptus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glirulus' AND (species='diremptus' OR species='diremptus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glirulus' AND (species='diremptus' OR species='diremptus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glirulus' AND (junior_species='diremptus' OR junior_species='diremptus')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='Glirulus' AND (species='diremptus' OR species='diremptus') 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='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='Miodyromys' AND (junior_species='aegercii' OR junior_species='aegerci')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miodyromys' AND (species='aegercii' OR species='aegerci') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miodyromys' AND (species='aegercii' OR species='aegerci')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miodyromys' AND (junior_species='aegercii' OR junior_species='aegerci')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='aegercii' OR species='aegerci') 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='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='Eumyarion' AND (junior_species='weinfurteri' OR junior_species='weinfurterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumyarion' AND (species='weinfurteri' OR species='weinfurterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumyarion' AND (species='weinfurteri' OR species='weinfurterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumyarion' AND (junior_species='weinfurteri' OR junior_species='weinfurterii')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='weinfurteri' OR species='weinfurterii') 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='Democricetodon' AND (junior_species='franconicus' OR junior_species='franconicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Democricetodon' AND (species='franconicus' OR species='franconicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Democricetodon' AND (species='franconicus' OR species='franconicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Democricetodon' AND (junior_species='franconicus' OR junior_species='franconicus')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='franconicus' OR species='franconicus') 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='Melissiodon' AND (junior_species='dominans' OR junior_species='dominans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melissiodon' AND (species='dominans' OR species='dominans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melissiodon' AND (species='dominans' OR species='dominans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melissiodon' AND (junior_species='dominans' OR junior_species='dominans')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='dominans' OR species='dominans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomalomys' 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='Anomalomys' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anomalomys' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomalomys' 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='Anomalomys' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychoprolagus' AND (junior_species='forsthartensis' OR junior_species='forsthartensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychoprolagus' AND (species='forsthartensis' OR species='forsthartensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychoprolagus' AND (species='forsthartensis' OR species='forsthartensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychoprolagus' AND (junior_species='forsthartensis' OR junior_species='forsthartensis')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='Ptychoprolagus' AND (species='forsthartensis' OR species='forsthartensis') ORDER BY year,last_namesSELECT 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 * FROM register WHERE sample_no=2642 The Ecological Register: Forsthart
Forsthart
Basic information
Sample name: Forsthart

Reference: R. Ziegler and V. Fahlbusch. 1986. Kleinsäuger-Faunen aus der basalen Oberen Süsswasser-Molasse Niederbayerns. Zitteliana 14:3-58 [ER 2423]
Geography
Country: Germany


Coordinate: 48° 38' N, 13° 2' E
Coordinate basis: based on nearby landmark

Time interval: Early Miocene

Zone: MN4b

Age basis: zone

Geography comments: "1 ikm WNW Kirche Forsthart, 12 km W Vilshofen" (coordinate based on Forsthart)

•
Environment
Substrate: ground surface

Lithology: marl

Habitat comments: "sandige, glimmerreiche, stark kalkhaltige Mergel mit gleichmåssiger Schichtung, mit vereinzelten gut gerundeten Quarzen bis 4 mm Durchmesser. Farbe hellgrau bis graublau... An der Basis der Grube birgt ein 50 cm breiter Horizont eine reiche Gastropodenfauna und verhåltnismåssig viele Vertebratenreste"

Methods
Life forms: rodents,other small mammals

Sampling methods: screenwash

Sample size: 885 specimens

Years: 1974, 1984

Sampling comments: "ca. 6 000 kg" was collected by F. Pfeil (year unclear) and "1974 ca. 500 kg; 1984: ca. 13 000 kg" by the Münchener Institut
Rhinolophidae indet. is also present

Metadata
Sample number: 2642

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-24 15:35:55

Modified: 2023-09-11 10:31:14

Abundance distribution
33 species
1 singleton
total count 885
extrapolated richness: 39.0
Fisher's α: 6.759
geometric series k: 0.8502
Hurlbert's PIE: 0.9204
Shannon's H: 2.9191
Good's u: 0.9989
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Amphiperatherium frequens erkersthofense28
Galerix symeonidisi37
Desmanella engesseri7
Proscapanus intercedens-sansaniensis12
Scaptonyx cf. edwardsi7
Desmanodon antiquus12
Plesiodimylus chantrei1
Dinosorex aff. zapfei2
Heterosorex neumayrianus6
aff subspecies subsequens
Sorex dehmi24
Miosorex aff. grivensis4
Limnoecus sp.2
Palaeosciurus sutteri21
new
Spermophilinus aff. bredai31
Heteroxerus huerzeleri-rubricati5
Miopetaurista cf. dehmi13
Blackia miocaenica3
Glirudinus modestus6
Microdyromys praemurinus24
Glirulus diremptus6
Bransatoglis cadeoti4
Pseudodryomys ibericus15
Miodyromys aegercii2
Peridyromys sp.17
Ligerimys florancei80
Eumyarion cf. weinfurteri53
Megacricetodon aff. collongensis60
Democricetodon aff. franconicus56
Democricetodon gracilis180
Melissiodon dominans51
Anomalomys minor15
Ptychoprolagus forsthartensis53
Prolagus sp. vasconiensis-oeningensis48