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=3957 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3957SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3724SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3957 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='timidus' OR junior_species='timidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='timidus' OR species='timidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='timidus' OR species='timidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='timidus' OR junior_species='timidus')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='Lepus' AND (species='timidus' OR species='timidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gulo' AND (junior_species='gulo' OR junior_species='gulo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gulo' AND (species='gulo' OR species='gulo') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gulo' AND (junior_species='gulo' OR junior_species='gulo')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='Gulo' AND (species='gulo' OR species='gulo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='lagopus' OR junior_species='lagopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='lagopus' OR species='lagopus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='lagopus' OR junior_species='lagopus')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='Vulpes' AND (species='lagopus' OR species='lagopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' AND (junior_species='priscus' OR junior_species='priscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bison' AND (species='priscus' OR species='priscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bison' AND (species='priscus' OR species='priscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' AND (junior_species='priscus' OR junior_species='priscus')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='Bison' AND (species='priscus' OR species='priscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammuthus' 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='Mammuthus' AND (species='primigenius' OR species='primigenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mammuthus' AND (species='primigenius' OR species='primigenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammuthus' 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='Mammuthus' AND (species='primigenius' OR species='primigenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='hyperborea' OR junior_species='hyperborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochotona' AND (species='hyperborea' OR species='hyperborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotona' AND (species='hyperborea' OR species='hyperborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='hyperborea' OR junior_species='hyperborea')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='Ochotona' AND (species='hyperborea' OR species='hyperborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='pusilla' OR junior_species='pusilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochotona' AND (species='pusilla' OR species='pusilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotona' AND (species='pusilla' OR species='pusilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotona' AND (junior_species='pusilla' OR junior_species='pusilla')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='Ochotona' AND (species='pusilla' OR species='pusilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutamias' AND (junior_species='sibiricus' OR junior_species='sibiricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eutamias' AND (species='sibiricus' OR species='sibiricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eutamias' AND (species='sibiricus' OR species='sibiricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eutamias' AND (junior_species='sibiricus' OR junior_species='sibiricus')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='Eutamias' AND (species='sibiricus' OR species='sibiricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocitellus' AND (junior_species='undulatus' OR junior_species='undulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urocitellus' AND (species='undulatus' OR species='undulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urocitellus' AND (species='undulatus' OR species='undulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocitellus' AND (junior_species='undulatus' OR junior_species='undulatus')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='Urocitellus' AND (species='undulatus' OR species='undulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='rutilus' OR junior_species='rutilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='rutilus' OR species='rutilus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='rutilus' OR junior_species='rutilus')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='Myodes' AND (species='rutilus' OR species='rutilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='rufocanus' OR junior_species='rufocanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myodes' AND (species='rufocanus' OR species='rufocanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myodes' AND (species='rufocanus' OR species='rufocanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myodes' AND (junior_species='rufocanus' OR junior_species='rufocanus')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='Myodes' AND (species='rufocanus' OR species='rufocanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemmus' AND (junior_species='sibiricus' OR junior_species='sibiricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lemmus' AND (species='sibiricus' OR species='sibiricus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemmus' AND (junior_species='sibiricus' OR junior_species='sibiricus')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='Lemmus' AND (species='sibiricus' OR species='sibiricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemmus' AND (junior_species='amurensis' OR junior_species='amurensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lemmus' AND (species='amurensis' OR species='amurensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lemmus' AND (species='amurensis' OR species='amurensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemmus' AND (junior_species='amurensis' OR junior_species='amurensis')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='Lemmus' AND (species='amurensis' OR species='amurensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myopus' AND (junior_species='schisticolor' OR junior_species='schisticolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myopus' AND (species='schisticolor' OR species='schisticolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myopus' AND (species='schisticolor' OR species='schisticolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myopus' AND (junior_species='schisticolor' OR junior_species='schisticolor')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='Myopus' AND (species='schisticolor' OR species='schisticolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrostonyx' 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='Dicrostonyx' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dicrostonyx' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrostonyx' 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='Dicrostonyx' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alticola' 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='Alticola' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alticola' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alticola' 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='Alticola' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagurus' AND (junior_species='lagurus' OR junior_species='lagurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagurus' AND (species='lagurus' OR species='lagurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagurus' AND (species='lagurus' OR species='lagurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagurus' AND (junior_species='lagurus' OR junior_species='lagurus')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='Lagurus' AND (species='lagurus' OR species='lagurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocranius' AND (junior_species='gregalis' OR junior_species='gregalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenocranius' AND (species='gregalis' OR species='gregalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenocranius' AND (species='gregalis' OR species='gregalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocranius' AND (junior_species='gregalis' OR junior_species='gregalis')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='Stenocranius' AND (species='gregalis' OR species='gregalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='arvalis' OR junior_species='arvalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='arvalis' OR species='arvalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='arvalis' OR species='arvalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='arvalis' OR junior_species='arvalis')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='Microtus' AND (species='arvalis' OR species='arvalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='middendorffi' OR junior_species='middendorffii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alexandromys' AND (species='middendorffi' OR species='middendorffii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alexandromys' AND (species='middendorffi' OR species='middendorffii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='middendorffi' OR junior_species='middendorffii')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='Alexandromys' AND (species='middendorffi' OR species='middendorffii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='agrestis' OR junior_species='agrestis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='agrestis' OR species='agrestis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='agrestis' OR species='agrestis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='agrestis' OR junior_species='agrestis')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='Microtus' AND (species='agrestis' OR species='agrestis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')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='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagopus' AND (junior_species='lagopus' OR junior_species='lagopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagopus' AND (species='lagopus' OR species='lagopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagopus' AND (species='lagopus' OR species='lagopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagopus' AND (junior_species='lagopus' OR junior_species='lagopus')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='Lagopus' AND (species='lagopus' OR species='lagopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallinago' AND (junior_species='megala' OR junior_species='megala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallinago' AND (species='megala' OR species='megala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallinago' AND (species='megala' OR species='megala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallinago' AND (junior_species='megala' OR junior_species='megala')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='Gallinago' AND (species='megala' OR species='megala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='citrinella' OR junior_species='citrinella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Emberiza' AND (species='citrinella' OR species='citrinella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Emberiza' AND (species='citrinella' OR species='citrinella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Emberiza' AND (junior_species='citrinella' OR junior_species='citrinella')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='Emberiza' AND (species='citrinella' OR species='citrinella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Succinella' AND (junior_species='oblonga' OR junior_species='oblonga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Succinella' AND (species='oblonga' OR species='oblonga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Succinella' AND (species='oblonga' OR species='oblonga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Succinella' AND (junior_species='oblonga' OR junior_species='oblonga')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='Succinella' AND (species='oblonga' OR species='oblonga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vallonia' AND (junior_species='tenuilabris' OR junior_species='tenuilabris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vallonia' AND (species='tenuilabris' OR species='tenuilabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vallonia' AND (species='tenuilabris' OR species='tenuilabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vallonia' AND (junior_species='tenuilabris' OR junior_species='tenuilabris')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='Vallonia' AND (species='tenuilabris' OR species='tenuilabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vallonia' AND (junior_species='pulchella' OR junior_species='pulchella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vallonia' AND (species='pulchella' OR species='pulchella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vallonia' AND (species='pulchella' OR species='pulchella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vallonia' AND (junior_species='pulchella' OR junior_species='pulchella')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='Vallonia' AND (species='pulchella' OR species='pulchella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pupilla' AND (junior_species='muscorum' OR junior_species='muscorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pupilla' AND (species='muscorum' OR species='muscorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pupilla' AND (species='muscorum' OR species='muscorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pupilla' AND (junior_species='muscorum' OR junior_species='muscorum')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='Pupilla' AND (species='muscorum' OR species='muscorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vertigo' AND (junior_species='alpestris' OR junior_species='alpestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vertigo' AND (species='alpestris' OR species='alpestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vertigo' AND (species='alpestris' OR species='alpestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vertigo' AND (junior_species='alpestris' OR junior_species='alpestris')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='Vertigo' AND (species='alpestris' OR species='alpestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vertigo' AND (junior_species='modesta' OR junior_species='modesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vertigo' AND (species='modesta' OR species='modesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vertigo' AND (species='modesta' OR species='modesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vertigo' AND (junior_species='modesta' OR junior_species='modesta')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='Vertigo' AND (species='modesta' OR species='modesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyraulus' AND (junior_species='laevis' OR junior_species='laevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gyraulus' AND (species='laevis' OR species='laevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gyraulus' AND (species='laevis' OR species='laevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gyraulus' AND (junior_species='laevis' OR junior_species='laevis')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='Gyraulus' AND (species='laevis' OR species='laevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippeutis' AND (junior_species='complanatus' OR junior_species='complanatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippeutis' AND (species='complanatus' OR species='complanatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippeutis' AND (species='complanatus' OR species='complanatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippeutis' AND (junior_species='complanatus' OR junior_species='complanatus')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='Hippeutis' AND (species='complanatus' OR species='complanatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limacidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limacidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limacidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limacidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Limacidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3957 The Ecological Register: Bol'shoj Naryn (Paleosol Layers)
Bol'shoj Naryn (Paleosol Layers)
Basic information
Sample name: Bol'shoj Naryn (Paleosol Layers)

Reference: T. Sato, F. Khenzykhenova, A. Simakova, G. Danukalova, E. Morosova, K. Yoshida, D. Kunikita, H. Kato, K. Suzuki, E. Lipnina, G. Medvedev, and N. Martynovich. 2014. Paleoenvironment of the Fore-Baikal region in the Karginian interstadial: Results of the interdisciplinary studies of the Bol'shoj Naryn site. Quaternary International 333:146-155 [ER 3724]
Geography
Country: Russia

State: Irkutsk Oblast


Coordinate: 53° 33' 17" N, 103° 34' 7" E
Coordinate basis: stated in text

Time interval: Late Pleistocene

Max Ma: 0.03146

Min Ma: 0.02523

Age basis: radiocarbon (uncalibrated)

Geography comments: "The Bol'shoj Naryn site is located at 53°N and 103°E on the southern coast of the Bratsk Reservoir and further along the abrupt right bank of the Angara River. The hills enclosing the cultural layers previously formed the left bank of the Osa River".
Several charcoal samples taken from the paleosol layers give radiocarbon ages ranging from 25,230 ± 110 BP (upper layers) to 31,460 ± 340 BP (lower layers).

•
Environment
Lithology: not described

Taphonomic context: human accumulation,paleosol

Archaeology: bone tools,stone tools

Habitat comments: "The general structure of the strata at Bol'shoj Naryn is almost the same everywhere on the site: sandy loess deposits dated to the Sartan glacial stage occur immediately under the modern soil and go down to a depth of 1–2 m; they are underlain by high viscosity paleosol layers up to 1 m thick developed during the Karginian Interstadial".
"The paleosol layers contain numerous stone tools and animal fossils. The number of stone tools and flakes excavated from the paleosol layers amounts to more than 10,000 items, mostly consisting of blades, scrapers and core tools made of quartz. A small number of bone and antler tools were also collected".

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

Sampling methods: quarry,screenwash

Sample size: 2989 specimens

Years: 2004 - 2011

Sampling comments: "The survey area was chosen near the hills, where the finds occurred closely to each other on both sides of a small river with steep banks".
"All the artifacts and animal remains recovered from the paleosol layers were meticulously documented. During the 2010 and 2011 excavations, small mammal remains were collected from paleosol layers 5 cm thick each using water sieving through 1 mm mesh".
"The number of faunal remains totalled 2464 mollusc shells, 111 birds and over 10,800 mammals".

Metadata
Sample number: 3957

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-08-04 12:14:24

Modified: 2022-08-04 05:47:02

Abundance distribution
36 species
10 singletons
total count 2989
extrapolated richness: 59.3
Fisher's α: 5.756
geometric series k: 0.8146
Hurlbert's PIE: 0.7054
Shannon's H: 1.6931
Good's u: 0.9967
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Lepus timidus11
Gulo gulo113 kg
Vulpes lagopus13.3 kg
"Alopex lagopus"
Cervidae indet.9
Bison cf. priscus24
Equus sp.94
Mammuthus primigenius1
Ochotona cf. hyperborea15
Ochotona cf. pusilla12
also 63 Ochotona sp.
Eutamias sibiricus1
Urocitellus undulatus1
"Spermophilus undulatus"
Myodes rutilus319.5 g
"Clethrionomys rutilus"
Myodes rufocanus29
"Clethrionomys rufocanus"; also 9 Myodes sp. "Clethrionomys sp."
Lemmus sibiricus1543.7 g
Lemmus amurensis5
Myopus schisticolor44
Dicrostonyx sp.1
Alticola sp.2
Lagurus lagurus9
also 3 Lagurus sp.
Stenocranius gregalis114
"Microtus gregalis"
Microtus cf. arvalis35
Alexandromys cf. middendorffi67
"Microtus cf. middendorffii" and "Microtus cf. hyperboreus"
Microtus cf. agrestis2
also 203 "Microtus" sp. and 8 Microtinae/Arvicolinae indet.
Alexandromys oeconomus2136.5 g
"Microtus oeconomus"
Lagopus lagopus58.8 g
Gallinago cf. megala1121 g
Emberiza cf. citrinella229.7 g
also 1 Emberiza sp. and 104 Aves indet.
Succinella oblonga910
Vallonia tenuilabris233
Vallonia pulchella2
Pupilla muscorum1310
Vertigo alpestris3
Vertigo cf. modesta1
Gyraulus laevis1
Hippeutis complanatus1
Limacidae indet.3