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=4385 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4385SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3974SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4385 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ichthyosaura' 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='Ichthyosaura' AND (species='alpestris' OR species='alpestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ichthyosaura' AND (species='alpestris' OR species='alpestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ichthyosaura' 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='Ichthyosaura' AND (species='alpestris' OR species='alpestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelodytes' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pelodytes' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pelodytes' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelodytes' AND (junior_species='punctatus' OR junior_species='punctatus')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='Pelodytes' AND (species='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='bufo' OR junior_species='bufo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='bufo' OR species='bufo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='bufo' OR species='bufo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='bufo' OR junior_species='bufo')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='Bufo' AND (species='bufo' OR species='bufo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='calamita' OR junior_species='calamita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bufo' AND (species='calamita' OR species='calamita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bufo' AND (species='calamita' OR species='calamita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bufo' AND (junior_species='calamita' OR junior_species='calamita')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='Bufo' AND (species='calamita' OR species='calamita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='temporaria' OR junior_species='temporaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rana' AND (species='temporaria' OR species='temporaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rana' AND (species='temporaria' OR species='temporaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rana' AND (junior_species='temporaria' OR junior_species='temporaria')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='Rana' AND (species='temporaria' OR species='temporaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='viridis' OR junior_species='viridis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacerta' AND (species='viridis' OR species='viridis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacerta' AND (species='viridis' OR species='viridis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacerta' AND (junior_species='viridis' OR junior_species='viridis')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='Lacerta' AND (species='viridis' OR species='viridis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguis' AND (junior_species='fragilis' OR junior_species='fragilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anguis' AND (species='fragilis' OR species='fragilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anguis' AND (species='fragilis' OR species='fragilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguis' AND (junior_species='fragilis' OR junior_species='fragilis')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='Anguis' AND (species='fragilis' OR species='fragilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='austriaca' OR junior_species='austriaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coronella' AND (species='austriaca' OR species='austriaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coronella' AND (species='austriaca' OR species='austriaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='austriaca' OR junior_species='austriaca')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='Coronella' AND (species='austriaca' OR species='austriaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='girondica' OR junior_species='girondica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coronella' AND (species='girondica' OR species='girondica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coronella' AND (species='girondica' OR species='girondica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coronella' AND (junior_species='girondica' OR junior_species='girondica')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='Coronella' AND (species='girondica' OR species='girondica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zamenis' AND (junior_species='scalaris' OR junior_species='scalaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zamenis' AND (species='scalaris' OR species='scalaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zamenis' AND (species='scalaris' OR species='scalaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zamenis' AND (junior_species='scalaris' OR junior_species='scalaris')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='Zamenis' AND (species='scalaris' OR species='scalaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coluber' AND (junior_species='viridiflavus' OR junior_species='viridiflavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coluber' AND (species='viridiflavus' OR species='viridiflavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coluber' AND (species='viridiflavus' OR species='viridiflavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coluber' AND (junior_species='viridiflavus' OR junior_species='viridiflavus')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='Coluber' AND (species='viridiflavus' OR species='viridiflavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' 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='Vipera' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vipera' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vipera' 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='Vipera' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')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='vulpes' OR species='vulpes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='spelaea' OR junior_species='spelaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='spelaea' OR species='spelaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panthera' AND (species='spelaea' OR species='spelaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='spelaea' OR junior_species='spelaea')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='Panthera' AND (species='spelaea' OR species='spelaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='pardus' OR species='pardus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')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='Panthera' AND (species='pardus' OR species='pardus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='pardinus' OR junior_species='pardinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='pardinus' OR species='pardinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='pardinus' OR junior_species='pardinus')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='Lynx' AND (species='pardinus' OR species='pardinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='arctos' OR species='arctos') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='arctos' OR junior_species='arctos')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='Ursus' AND (species='arctos' OR species='arctos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='meles' OR species='meles') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')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='Meles' AND (species='meles' OR species='meles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')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='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dama' AND (junior_species='dama' OR junior_species='dama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dama' AND (species='dama' OR species='dama') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dama' AND (junior_species='dama' OR junior_species='dama')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='Dama' AND (species='dama' OR species='dama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='capreolus' OR junior_species='capreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='capreolus' OR junior_species='capreolus')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='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaloceros' AND (junior_species='giganteus' OR junior_species='giganteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megaloceros' AND (species='giganteus' OR species='giganteus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megaloceros' AND (species='giganteus' OR species='giganteus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaloceros' AND (junior_species='giganteus' OR junior_species='giganteus')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='Megaloceros' AND (species='giganteus' OR species='giganteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='ibex' OR junior_species='ibex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capra' AND (species='ibex' OR species='ibex') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='ibex' OR junior_species='ibex')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='Capra' AND (species='ibex' OR species='ibex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='primigenius' OR species='primigenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bos' AND (species='primigenius' OR species='primigenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Bos' AND (species='primigenius' OR species='primigenius') 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='Rupicapra' AND (junior_species='rupicapra' OR junior_species='rupicapra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rupicapra' AND (species='rupicapra' OR species='rupicapra') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rupicapra' AND (junior_species='rupicapra' OR junior_species='rupicapra')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='Rupicapra' AND (species='rupicapra' OR species='rupicapra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='hemitoechus' OR junior_species='hemitoechus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stephanorhinus' AND (species='hemitoechus' OR species='hemitoechus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stephanorhinus' AND (species='hemitoechus' OR species='hemitoechus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='hemitoechus' OR junior_species='hemitoechus')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='Stephanorhinus' AND (species='hemitoechus' OR species='hemitoechus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='ferus' OR species='ferus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')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='ferus' OR species='ferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpa' AND (junior_species='europaea' OR junior_species='europaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Talpa' AND (species='europaea' OR species='europaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talpa' AND (species='europaea' OR species='europaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpa' AND (junior_species='europaea' OR junior_species='europaea')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='Talpa' AND (species='europaea' OR species='europaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='minutus' OR junior_species='minutus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sorex' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='gr.' OR junior_species='gr.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sorex' AND (species='gr.' OR species='gr.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='gr.' OR species='gr.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' AND (junior_species='gr.' OR junior_species='gr.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sorex' AND (species='gr.' OR species='gr.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='schreibersii' OR junior_species='schreibersi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miniopterus' AND (species='schreibersii' OR species='schreibersi') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miniopterus' AND (junior_species='schreibersii' OR junior_species='schreibersi')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='Miniopterus' AND (species='schreibersii' OR species='schreibersi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='gr.' OR junior_species='gr.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='gr.' OR species='gr.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Myotis' AND (species='gr.' OR species='gr.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='gr.' OR junior_species='gr.')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='Myotis' AND (species='gr.' OR species='gr.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='nattereri' OR junior_species='nattererii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Myotis' AND (species='nattereri' OR species='nattererii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Myotis' AND (junior_species='nattereri' OR junior_species='nattererii')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='Myotis' AND (species='nattereri' OR species='nattererii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipistrellus' AND (junior_species='pipistrellus' OR junior_species='pipistrellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pipistrellus' AND (species='pipistrellus' OR species='pipistrellus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pipistrellus' AND (junior_species='pipistrellus' OR junior_species='pipistrellus')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='Pipistrellus' AND (species='pipistrellus' OR species='pipistrellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='quercinus' OR junior_species='quercinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eliomys' AND (species='quercinus' OR species='quercinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eliomys' AND (species='quercinus' OR species='quercinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='quercinus' OR junior_species='quercinus')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='Eliomys' AND (species='quercinus' OR species='quercinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' AND (junior_species='glis' OR junior_species='glis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glis' AND (species='glis' OR species='glis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glis' AND (species='glis' OR species='glis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glis' AND (junior_species='glis' OR junior_species='glis')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='Glis' AND (species='glis' OR species='glis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetus' AND (junior_species='cricetus' OR junior_species='cricetus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cricetus' AND (species='cricetus' OR species='cricetus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cricetus' AND (species='cricetus' OR species='cricetus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cricetus' AND (junior_species='cricetus' OR junior_species='cricetus')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='Cricetus' AND (species='cricetus' OR species='cricetus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apodemus' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='sylvaticus' OR species='sylvaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')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='Apodemus' AND (species='sylvaticus' OR species='sylvaticus') 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='Microtus' AND (junior_species='multiplex' OR junior_species='multiplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='multiplex' OR species='multiplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='multiplex' OR species='multiplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='multiplex' OR junior_species='multiplex')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='multiplex' OR species='multiplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='cantiana' OR junior_species='cantiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicola' AND (species='cantiana' OR species='cantiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arvicola' AND (species='cantiana' OR species='cantiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='cantiana' OR junior_species='cantiana')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='Arvicola' AND (species='cantiana' OR species='cantiana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliomys' AND (junior_species='boronensis' OR junior_species='boronensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pliomys' AND (species='boronensis' OR species='boronensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pliomys' AND (species='boronensis' OR species='boronensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliomys' AND (junior_species='boronensis' OR junior_species='boronensis')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='Pliomys' AND (species='boronensis' OR species='boronensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliomys' AND (junior_species='lenki' OR junior_species='lenkii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pliomys' AND (species='lenki' OR species='lenkii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pliomys' AND (species='lenki' OR species='lenkii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pliomys' AND (junior_species='lenki' OR junior_species='lenkii')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='Pliomys' AND (species='lenki' OR species='lenkii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='marmota' OR junior_species='marmota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmota' AND (species='marmota' OR species='marmota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marmota' AND (species='marmota' OR species='marmota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='marmota' OR junior_species='marmota')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='Marmota' AND (species='marmota' OR species='marmota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryctolagus' AND (junior_species='cuniculus' OR junior_species='cuniculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryctolagus' AND (species='cuniculus' OR species='cuniculus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryctolagus' AND (junior_species='cuniculus' OR junior_species='cuniculus')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='Oryctolagus' AND (species='cuniculus' OR species='cuniculus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4385 The Ecological Register: Lazaret (C II supérieur UA 13-17)
Lazaret (C II supérieur UA 13-17)
Basic information
Sample name: Lazaret (C II supérieur UA 13-17)

Reference: C. Hanquet, P. Valensi, S. Bailon, E. Desclaux, K. El Guennouni, T. Roger, and H. De Lumley. 2010. Caractérisation du climat et de labiodiversité au Pléistocène moyen final, d'après les faunes de vertébrés de la grotte du Lazaret (Nice, France). Quaternaire 21(3):215-226 [ER 3974]
Geography
Country: France


Coordinate: 43° 41' 25" N, 7° 17' 42" E
Coordinate basis: stated in text

Time interval: Middle Pleistocene

Max Ma: 0.165

Min Ma: 0.131

Age basis: ESR

Geography comments: coordinate is given by Michel et al. (2008, Quaternary Geochronology)
assigned to MIS 6 based on biochronology
UA 13-17 is a group of five occupation levels within the upper part of stratigraphic sub-unit C II
upper C II has mean ESR ages on dental enamel of 131 ± 7 (early uptake) and 165 ± 9 ka (late uptake)

•
Environment
Lithology: claystone

Taphonomic context: cave

Archaeology: stone tools

Habitat comments: the C complex is "composed of red colluvial sandy clays... as well as blocks and rocks detached from the cave walls" (Michel et al. 2008)
the entire C sequence is interpreted as a "Homo erectus" or pre-Neanderthal occupation based on a final Acheulian-age lithic industry rich in bifaces, but accumulation agents per se are not discussed

Methods
Life forms: bats,carnivores,rodents,ungulates,other small mammals,lizards,snakes,frogs,salamanders

Sampling methods: quarry,screenwash

Sample size: 14370 specimens

Years: 1950 - 1965, 1967

Sampling comments: microvertebrates were recovered by wet screening with sieve siezes from 5 to 0.8 mm
excavations were "by F.C.E. Octobon between 1950 and 1965 and by H. de Lumley since 1967"
hominid fossil are present somewhere in the section, but are not included in the data table
there are 30,000 fossils of 130 bird species in the section, but they are omitted from the table

Metadata
Sample number: 4385

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-12-02 20:21:32

Modified: 2023-12-02 09:21:32

Abundance distribution
47 species
13 singletons
total count 14370
extrapolated richness: 77.8
Fisher's α: 6.046
geometric series k: 0.8154
Hurlbert's PIE: 0.3055
Shannon's H: 0.8623
Good's u: 0.9991
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Ichthyosaura cf. alpestris1
"Triturus cf. alpestris"
Pelodytes punctatus59
Bufo bufo151
Bufo calamita106
Rana temporaria92
Lacerta cf. viridis2
plus 38 Lacertidae including some number of cf. Podarcis
Anguis fragilis20
Coronella cf. austriaca3
plus 14 Colubridae
Coronella cf. girondica3
Zamenis cf. scalaris3
"Elaphe cf. scalaris": plus 4 Elaphe
Coluber viridiflavus1
Vipera sp.199
including V. aspis and V. cf. ursinii
Canis lupus5643 kg carnivore
Vulpes vulpes55.3 kg carnivore-insectivore
Panthera spelaea2
"Panthera (Leo) spelaea"
Panthera pardus933 kg carnivore
Lynx pardinus spelaeus1811 kg
"Lynx spelaea"
Ursus arctos1156 kg frugivore-carnivore
Meles meles111 kg invertivore-herbivore
Cervus elaphus725104 kg
Dama dama162 kg
Capreolus capreolus522 kg browser
Megaloceros giganteus3
Capra ibex9137 kg
Bos primigenius6
Bison priscus1
plus 45 Bos or Bison
Rupicapra rupicapra327 kg browser-grazer
Stephanorhinus hemitoechus2
Equus ferus6422 kg
"Equus caballus cf. taubachensis"
Talpa europaea44
Sorex minutus1
Sorex gr. araneus/coronatus1
Miniopterus schreibersii112.4 g insectivore
Myotis gr. myotis/blythi1
Myotis nattereri16.4 g
Pipistrellus pipistrellus14.4 g insectivore
Eliomys quercinus18
Glis glis5
Cricetus cricetus2
Apodemus sylvaticus213
Microtus agrestis438
Microtus (Terricola) multiplex45
Arvicola cantiana68
Pliomys boronensis14
Pliomys lenki2
Marmota marmota1
Oryctolagus cuniculus119392.5 kg browser-grazer