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)
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 International333: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.