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=2506 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2506SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2342SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2506 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetotherium' AND (junior_species='youngi' OR junior_species='youngii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herpetotherium' AND (species='youngi' OR species='youngii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herpetotherium' AND (species='youngi' OR species='youngii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetotherium' AND (junior_species='youngi' OR junior_species='youngii')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='Herpetotherium' AND (species='youngi' OR species='youngii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centetodon' AND (junior_species='divaricatus' OR junior_species='divaricatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centetodon' AND (species='divaricatus' OR species='divaricatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centetodon' AND (species='divaricatus' OR species='divaricatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centetodon' AND (junior_species='divaricatus' OR junior_species='divaricatus')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='Centetodon' AND (species='divaricatus' OR species='divaricatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Domnina' 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='Domnina' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Domnina' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Domnina' 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='Domnina' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scalopoides' 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='Scalopoides' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scalopoides' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scalopoides' 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='Scalopoides' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mystipterus' 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='Mystipterus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mystipterus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mystipterus' 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='Mystipterus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proscalops' AND (junior_species='secundus' OR junior_species='secundus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proscalops' AND (species='secundus' OR species='secundus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proscalops' AND (species='secundus' OR species='secundus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proscalops' AND (junior_species='secundus' OR junior_species='secundus')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='Proscalops' AND (species='secundus' OR species='secundus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocajila' 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='Ocajila' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocajila' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocajila' 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='Ocajila' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphechinus' 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='Amphechinus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphechinus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphechinus' 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='Amphechinus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parvericius' AND (junior_species='voorhiesi' OR junior_species='voorhiesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parvericius' AND (species='voorhiesi' OR species='voorhiesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parvericius' AND (species='voorhiesi' OR species='voorhiesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parvericius' AND (junior_species='voorhiesi' OR junior_species='voorhiesii')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='Parvericius' AND (species='voorhiesi' OR species='voorhiesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alwoodia' AND (junior_species='harkseni' OR junior_species='harksenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alwoodia' AND (species='harkseni' OR species='harksenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alwoodia' AND (species='harkseni' OR species='harksenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alwoodia' AND (junior_species='harkseni' OR junior_species='harksenii')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='Alwoodia' AND (species='harkseni' OR species='harksenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parallomys' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parallomys' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parallomys' AND (species='americanus' OR species='americanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parallomys' AND (junior_species='americanus' OR junior_species='americanus')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='Parallomys' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Promylagaulus' AND (junior_species='riggsi' OR junior_species='riggsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Promylagaulus' AND (species='riggsi' OR species='riggsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Promylagaulus' AND (species='riggsi' OR species='riggsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Promylagaulus' AND (junior_species='riggsi' OR junior_species='riggsii')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='Promylagaulus' AND (species='riggsi' OR species='riggsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilaccogaulus' AND (junior_species='ovatus' OR junior_species='ovatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trilaccogaulus' AND (species='ovatus' OR species='ovatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trilaccogaulus' AND (species='ovatus' OR species='ovatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trilaccogaulus' AND (junior_species='ovatus' OR junior_species='ovatus')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='Trilaccogaulus' AND (species='ovatus' OR species='ovatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protosciurus' 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='Protosciurus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protosciurus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protosciurus' 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='Protosciurus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nototamias' AND (junior_species='quadratus' OR junior_species='quadratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nototamias' AND (species='quadratus' OR species='quadratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nototamias' AND (species='quadratus' OR species='quadratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nototamias' AND (junior_species='quadratus' OR junior_species='quadratus')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='Nototamias' AND (species='quadratus' OR species='quadratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeocastor' AND (junior_species='simplicidens' OR junior_species='simplicidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeocastor' AND (species='simplicidens' OR species='simplicidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palaeocastor' AND (species='simplicidens' OR species='simplicidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palaeocastor' AND (junior_species='simplicidens' OR junior_species='simplicidens')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='Palaeocastor' AND (species='simplicidens' OR species='simplicidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hitonkala' AND (junior_species='macdonaldtau' OR junior_species='macdonaldtau')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hitonkala' AND (species='macdonaldtau' OR species='macdonaldtau') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hitonkala' AND (species='macdonaldtau' OR species='macdonaldtau')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hitonkala' AND (junior_species='macdonaldtau' OR junior_species='macdonaldtau')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='Hitonkala' AND (species='macdonaldtau' OR species='macdonaldtau') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proheteromys' 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='Proheteromys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proheteromys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proheteromys' 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='Proheteromys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sanctimus' AND (junior_species='stuartae' OR junior_species='stuartae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sanctimus' AND (species='stuartae' OR species='stuartae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sanctimus' AND (species='stuartae' OR species='stuartae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sanctimus' AND (junior_species='stuartae' OR junior_species='stuartae')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='Sanctimus' AND (species='stuartae' OR species='stuartae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Florentiamys' 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='Florentiamys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Florentiamys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Florentiamys' 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='Florentiamys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entoptychus' AND (junior_species='grandiplanus' OR junior_species='grandiplanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Entoptychus' AND (species='grandiplanus' OR species='grandiplanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Entoptychus' AND (species='grandiplanus' OR species='grandiplanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Entoptychus' AND (junior_species='grandiplanus' OR junior_species='grandiplanus')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='Entoptychus' AND (species='grandiplanus' OR species='grandiplanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gregorymys' AND (junior_species='formosus' OR junior_species='formosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gregorymys' AND (species='formosus' OR species='formosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gregorymys' AND (species='formosus' OR species='formosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gregorymys' AND (junior_species='formosus' OR junior_species='formosus')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='Gregorymys' AND (species='formosus' OR species='formosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arikareeomys' AND (junior_species='skinneri' OR junior_species='skinnerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arikareeomys' AND (species='skinneri' OR species='skinnerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arikareeomys' AND (species='skinneri' OR species='skinnerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arikareeomys' AND (junior_species='skinneri' OR junior_species='skinnerii')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='Arikareeomys' AND (species='skinneri' OR species='skinnerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudotheridomys' 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='Pseudotheridomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudotheridomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudotheridomys' 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='Pseudotheridomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leidymys' AND (junior_species='cerasus' OR junior_species='cerasus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leidymys' AND (species='cerasus' OR species='cerasus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leidymys' AND (species='cerasus' OR species='cerasus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leidymys' AND (junior_species='cerasus' OR junior_species='cerasus')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='Leidymys' AND (species='cerasus' OR species='cerasus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paciculus' AND (junior_species='nebraskensis' OR junior_species='nebraskensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paciculus' AND (species='nebraskensis' OR species='nebraskensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paciculus' AND (species='nebraskensis' OR species='nebraskensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paciculus' AND (junior_species='nebraskensis' OR junior_species='nebraskensis')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='Paciculus' AND (species='nebraskensis' OR species='nebraskensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiosminthus' AND (junior_species='clivosus' OR junior_species='clivosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiosminthus' AND (species='clivosus' OR species='clivosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiosminthus' AND (species='clivosus' OR species='clivosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiosminthus' AND (junior_species='clivosus' OR junior_species='clivosus')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='clivosus' OR species='clivosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gripholagomys' AND (junior_species='lavocati' OR junior_species='lavocatii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gripholagomys' AND (species='lavocati' OR species='lavocatii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gripholagomys' AND (species='lavocati' OR species='lavocatii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gripholagomys' AND (junior_species='lavocati' OR junior_species='lavocatii')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='Gripholagomys' AND (species='lavocati' OR species='lavocatii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeolagus' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archaeolagus' AND (species='primigenius' OR species='primigenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archaeolagus' AND (species='primigenius' OR species='primigenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archaeolagus' AND (junior_species='primigenius' OR junior_species='primigenius')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='Archaeolagus' AND (species='primigenius' OR species='primigenius') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2506 The Ecological Register: McCann Canyon
McCann Canyon
Basic information
Sample name: McCann Canyon

Sample aka: UNSM Cr-117; UNSM Cr-125

Reference: W. W. Korth. 1992. Fossil small mammals from the Harrison Formation (late Arikareean: earliest Miocene), Cherry County, Nebraska. Annals of Carnegie Museum 61(2):69-131 [ER 2342]
Geography
Country: United States

State: Nebraska


Coordinate: 42° 47' N, 100° 58' W
Coordinate basis: stated in text

Formation: Harrison

Time interval: Early Miocene

Ma: 23.9

Geography comments: UNSM Cr-125 is in the "NW 1/4, sec. 33, T33N, R31W"
"early Miocene or late Arikareean"
2008 AEO age estimate

Environment
Substrate: ground surface

Lithology: sandstone

Habitat comments: "poorly sorted channel sand containing sandstone pebbles"

Methods
Life forms: rodents,other small mammals

Sampling methods: screenwash

Sample size: 713 specimens

Years: 1981 - 1986

Metadata
Sample number: 2506

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-13 11:50:36

Modified: 2017-02-13 00:50:36

Abundance distribution
29 species
7 singletons
total count 713
extrapolated richness: 46.1
Fisher's α: 6.075
geometric series k: 0.8053
Hurlbert's PIE: 0.6168
Shannon's H: 1.7011
Good's u: 0.9902
Each square represents a species. Square sizes are proportional to counts.
Register