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=2591 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2591SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2397SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2591 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='minutum' OR junior_species='minutum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiperatherium' AND (species='minutum' OR species='minutum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiperatherium' AND (species='minutum' OR species='minutum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='minutum' OR junior_species='minutum')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='minutum' OR species='minutum') ORDER BY year,last_namesSELECT 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='Amphiperatherium' AND (junior_species='lamandini' OR junior_species='lamandinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphiperatherium' AND (species='lamandini' OR species='lamandinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphiperatherium' AND (species='lamandini' OR species='lamandinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphiperatherium' AND (junior_species='lamandini' OR junior_species='lamandinii')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='lamandini' OR species='lamandinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peratherium' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peratherium' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peratherium' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peratherium' AND (junior_species='elegans' OR junior_species='elegans')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='Peratherium' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Darbonetus' AND (junior_species='aubrelongensis' OR junior_species='aubrelongensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Darbonetus' AND (species='aubrelongensis' OR species='aubrelongensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Darbonetus' AND (species='aubrelongensis' OR species='aubrelongensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Darbonetus' AND (junior_species='aubrelongensis' OR junior_species='aubrelongensis')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='Darbonetus' AND (species='aubrelongensis' OR species='aubrelongensis') 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='Geotrypus' 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='Geotrypus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geotrypus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geotrypus' 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='Geotrypus' AND (species='sp.' OR species='sp.') 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='Stehlinia' 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='Stehlinia' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stehlinia' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stehlinia' 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='Stehlinia' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stehlinia' AND (junior_species='bonisi' OR junior_species='bonisii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stehlinia' AND (species='bonisi' OR species='bonisii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stehlinia' AND (species='bonisi' OR species='bonisii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stehlinia' AND (junior_species='bonisi' OR junior_species='bonisii')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='Stehlinia' AND (species='bonisi' OR species='bonisii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespertiliavus' 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='Vespertiliavus' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vespertiliavus' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vespertiliavus' 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='Vespertiliavus' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='morloti' OR junior_species='morlotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hipposideros' AND (species='morloti' OR species='morlotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hipposideros' AND (species='morloti' OR species='morlotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hipposideros' AND (junior_species='morloti' OR junior_species='morlotii')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='Hipposideros' AND (species='morloti' OR species='morlotii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeophyllophora' 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='Palaeophyllophora' AND (species='quercyi' OR species='quercyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeophyllophora' AND (species='quercyi' OR species='quercyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeophyllophora' 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='Palaeophyllophora' AND (species='quercyi' OR species='quercyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vaylatsia' AND (junior_species='prisca' OR junior_species='prisca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vaylatsia' AND (species='prisca' OR species='prisca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vaylatsia' AND (species='prisca' OR species='prisca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vaylatsia' AND (junior_species='prisca' OR junior_species='prisca')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='Vaylatsia' AND (species='prisca' OR species='prisca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mixopteryx' AND (junior_species='dubia' OR junior_species='dubia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mixopteryx' AND (species='dubia' OR species='dubia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mixopteryx' AND (species='dubia' OR species='dubia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mixopteryx' AND (junior_species='dubia' OR junior_species='dubia')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='Mixopteryx' AND (species='dubia' OR species='dubia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mixopteryx' AND (junior_species='weithoferi' OR junior_species='weithoferii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mixopteryx' AND (species='weithoferi' OR species='weithoferii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mixopteryx' AND (species='weithoferi' OR species='weithoferii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mixopteryx' AND (junior_species='weithoferi' OR junior_species='weithoferii')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='Mixopteryx' AND (species='weithoferi' OR species='weithoferii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenodon' AND (junior_species='leptorhynchus' OR junior_species='leptorhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyaenodon' AND (species='leptorhynchus' OR species='leptorhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyaenodon' AND (species='leptorhynchus' OR species='leptorhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenodon' AND (junior_species='leptorhynchus' OR junior_species='leptorhynchus')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='Hyaenodon' AND (species='leptorhynchus' OR species='leptorhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenodon' 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='Hyaenodon' AND (species='dubius' OR species='dubius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyaenodon' AND (species='dubius' OR species='dubius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenodon' 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='Hyaenodon' AND (species='dubius' OR species='dubius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphicynodon' AND (junior_species='leptorhynchus' OR junior_species='leptorhynchus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphicynodon' AND (species='leptorhynchus' OR species='leptorhynchus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphicynodon' AND (species='leptorhynchus' OR species='leptorhynchus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphicynodon' AND (junior_species='leptorhynchus' OR junior_species='leptorhynchus')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='Amphicynodon' AND (species='leptorhynchus' OR species='leptorhynchus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycynodon' AND (junior_species='borei' OR junior_species='boreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycynodon' AND (species='borei' OR species='boreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycynodon' AND (species='borei' OR species='boreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycynodon' AND (junior_species='borei' OR junior_species='boreii')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='Pachycynodon' AND (species='borei' OR species='boreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalogale' 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='Cephalogale' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cephalogale' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cephalogale' 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='Cephalogale' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynodictis' 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='Cynodictis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynodictis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynodictis' 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='Cynodictis' 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cainomeryx' 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='Cainomeryx' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cainomeryx' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cainomeryx' 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='Cainomeryx' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichobune' AND (junior_species='jehennei' OR junior_species='jehenneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichobune' AND (species='jehennei' OR species='jehenneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichobune' AND (species='jehennei' OR species='jehenneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichobune' AND (junior_species='jehennei' OR junior_species='jehenneii')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='Dichobune' AND (species='jehennei' OR species='jehenneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gelocus' AND (junior_species='villebramarensis' OR junior_species='villebramarensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gelocus' AND (species='villebramarensis' OR species='villebramarensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gelocus' AND (species='villebramarensis' OR species='villebramarensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gelocus' AND (junior_species='villebramarensis' OR junior_species='villebramarensis')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='Gelocus' AND (species='villebramarensis' OR species='villebramarensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blainvillimys' AND (junior_species='gregarius' OR junior_species='gregarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blainvillimys' AND (species='gregarius' OR species='gregarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blainvillimys' AND (species='gregarius' OR species='gregarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blainvillimys' AND (junior_species='gregarius' OR junior_species='gregarius')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='Blainvillimys' AND (species='gregarius' OR species='gregarius') 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='Pseudoltinomys' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoltinomys' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoltinomys' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoltinomys' AND (junior_species='major' OR junior_species='major')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='Pseudoltinomys' AND (species='major' OR species='major') 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='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='Lophallomys' 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='Lophallomys' AND (species='atavus' OR species='atavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophallomys' AND (species='atavus' OR species='atavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophallomys' 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='Lophallomys' AND (species='atavus' OR species='atavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atavocricetodon' 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='Atavocricetodon' AND (species='nanus' OR species='nanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atavocricetodon' AND (species='nanus' OR species='nanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atavocricetodon' 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='Atavocricetodon' AND (species='nanus' OR species='nanus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2591 The Ecological Register: Cavalé
Cavalé
Basic information
Sample name: Cavalé

Reference: M. Vianey-Liaud and B. Schmid. 2009. Diversité, datation et paléoenvironnement de la faune de mammifères oligocène de Cavalé (Quercy, SO France): contribution de l'analyse morphométrique des Theridomyinae (Mammalia, Rodentia). Geodiversitas 31(4):909-941 [ER 2397]
Geography
Country: France


Coordinate: 44° 24' N, 1° 39' E
Coordinate basis: based on nearby landmark

Time interval: Early Oligocene

Zone: MP22

Ma: 32

Geography comments: "dans un bois sur le terrain de la commune de Concots" (coordinate based on Concots)
MP22: thought by the author to be about 32 Ma, which is consistent with Walliser et al. (2016)

•
Environment
Substrate: ground surface

Lithology: claystone

Habitat comments: "remplissage karstique... une argile de teinte rouge située en placage sur les parois"

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

Sampling methods: screenwash

Sample size: 5047 specimens

Years: 2000

Sampling comments: "environ 600 kg de sédiment ont été traités par lavage – tamisage et tri"

Metadata
Sample number: 2591

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-18 13:41:23

Modified: 2017-02-18 02:49:52

Abundance distribution
33 species
7 singletons
total count 5047
extrapolated richness: 47.9
Fisher's α: 4.733
geometric series k: 0.7762
Hurlbert's PIE: 0.5482
Shannon's H: 1.4121
Good's u: 0.9986
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Amphiperatherium minutum30
Amphiperatherium ambiguum1
Amphiperatherium lamandini3
Peratherium elegans76
Darbonetus cf. aubrelongensis20
Tetracus nanus11
Geotrypus sp.1
Saturninia sp.2
Stehlinia gracilis13
Stehlinia bonisi3
Vespertiliavus gracilis57
Hipposideros (Pseudorhinolophus) morloti58
Palaeophyllophora quercyi72
Vaylatsia prisca36
Mixopteryx dubia26
Mixopteryx weithoferi5
Hyaenodon leptorhynchus1
Hyaenodon dubius1
Amphicynodon leptorhynchus3
Pachycynodon ? borei8
Cephalogale ? minor3
Cynodictis sp.1
aff
Plagiolophus minor3
Cainomeryx sp.550
probably includes specimens of Plesiomeryx sp. because this taxon is listed immediately afterwards with no count
Dichobune jehennei7
Gelocus cf. villebramarensis5
Blainvillimys gregarius3319
Sciuromys cayluxi268
Pseudoltinomys major227
Gliravus tenuis29
Palaeosciurus goti1
Lophallomys atavus1
Atavocricetodon aff. nanus206