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=4132 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4132SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3797SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4132 ORDER BY register_no ASCSELECT 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='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='Capra' AND (junior_species='pyrenaica' OR junior_species='pyrenaica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capra' AND (species='pyrenaica' OR species='pyrenaica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capra' AND (species='pyrenaica' OR species='pyrenaica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='pyrenaica' OR junior_species='pyrenaica')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='pyrenaica' OR species='pyrenaica') 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='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='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='Arvicola' AND (junior_species='amphibius' OR junior_species='amphibius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicola' AND (species='amphibius' OR species='amphibius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arvicola' AND (species='amphibius' OR species='amphibius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='amphibius' OR junior_species='amphibius')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='amphibius' OR species='amphibius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passeriformes' 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='Passeriformes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passeriformes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passeriformes' 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='Passeriformes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salmonidae' 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='Salmonidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salmonidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salmonidae' 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='Salmonidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguilla' AND (junior_species='anguilla' OR junior_species='anguilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anguilla' AND (species='anguilla' OR species='anguilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anguilla' AND (species='anguilla' OR species='anguilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguilla' AND (junior_species='anguilla' OR junior_species='anguilla')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='Anguilla' AND (species='anguilla' OR species='anguilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patella' AND (junior_species='vulgata' OR junior_species='vulgata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Patella' AND (species='vulgata' OR species='vulgata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Patella' AND (species='vulgata' OR species='vulgata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patella' AND (junior_species='vulgata' OR junior_species='vulgata')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='Patella' AND (species='vulgata' OR species='vulgata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patella' AND (junior_species='depressa' OR junior_species='depressa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Patella' AND (species='depressa' OR species='depressa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Patella' AND (species='depressa' OR species='depressa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patella' AND (junior_species='depressa' OR junior_species='depressa')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='Patella' AND (species='depressa' OR species='depressa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patella' AND (junior_species='ulyssiponensis' OR junior_species='ulyssiponensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Patella' AND (species='ulyssiponensis' OR species='ulyssiponensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Patella' AND (species='ulyssiponensis' OR species='ulyssiponensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Patella' AND (junior_species='ulyssiponensis' OR junior_species='ulyssiponensis')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='Patella' AND (species='ulyssiponensis' OR species='ulyssiponensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phorcus' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phorcus' AND (species='lineatus' OR species='lineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phorcus' AND (species='lineatus' OR species='lineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phorcus' AND (junior_species='lineatus' OR junior_species='lineatus')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='Phorcus' AND (species='lineatus' OR species='lineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Littorina' AND (junior_species='littorea' OR junior_species='littorea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Littorina' AND (species='littorea' OR species='littorea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Littorina' AND (species='littorea' OR species='littorea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Littorina' AND (junior_species='littorea' OR junior_species='littorea')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='Littorina' AND (species='littorea' OR species='littorea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gibbula' 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='Gibbula' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gibbula' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gibbula' 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='Gibbula' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mytilus' AND (junior_species='galloprovincialis' OR junior_species='galloprovincialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mytilus' AND (species='galloprovincialis' OR species='galloprovincialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mytilus' AND (species='galloprovincialis' OR species='galloprovincialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mytilus' AND (junior_species='galloprovincialis' OR junior_species='galloprovincialis')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='Mytilus' AND (species='galloprovincialis' OR species='galloprovincialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balanus' AND (junior_species='crenatus' OR junior_species='crenatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Balanus' AND (species='crenatus' OR species='crenatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Balanus' AND (species='crenatus' OR species='crenatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Balanus' AND (junior_species='crenatus' OR junior_species='crenatus')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='Balanus' AND (species='crenatus' OR species='crenatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semibalanus' AND (junior_species='balanoides' OR junior_species='balanoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Semibalanus' AND (species='balanoides' OR species='balanoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Semibalanus' AND (species='balanoides' OR species='balanoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semibalanus' AND (junior_species='balanoides' OR junior_species='balanoides')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='Semibalanus' AND (species='balanoides' OR species='balanoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracentrotus' AND (junior_species='lividus' OR junior_species='lividus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paracentrotus' AND (species='lividus' OR species='lividus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paracentrotus' AND (species='lividus' OR species='lividus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracentrotus' AND (junior_species='lividus' OR junior_species='lividus')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='Paracentrotus' AND (species='lividus' OR species='lividus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Obscurella' AND (junior_species='hidalgoi' OR junior_species='hidalgoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Obscurella' AND (species='hidalgoi' OR species='hidalgoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Obscurella' AND (species='hidalgoi' OR species='hidalgoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Obscurella' AND (junior_species='hidalgoi' OR junior_species='hidalgoii')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='Obscurella' AND (species='hidalgoi' OR species='hidalgoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menkia' AND (junior_species='horsti' OR junior_species='horstii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Menkia' AND (species='horsti' OR species='horstii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Menkia' AND (species='horsti' OR species='horstii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Menkia' AND (junior_species='horsti' OR junior_species='horstii')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='Menkia' AND (species='horsti' OR species='horstii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iberozospeum' AND (junior_species='schaufussi' OR junior_species='schaufussii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Iberozospeum' AND (species='schaufussi' OR species='schaufussii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Iberozospeum' AND (species='schaufussi' OR species='schaufussii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Iberozospeum' AND (junior_species='schaufussi' OR junior_species='schaufussii')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='Iberozospeum' AND (species='schaufussi' OR species='schaufussii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azeca' AND (junior_species='goodalli' OR junior_species='goodallii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Azeca' AND (species='goodalli' OR species='goodallii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Azeca' AND (species='goodalli' OR species='goodallii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azeca' AND (junior_species='goodalli' OR junior_species='goodallii')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='Azeca' AND (species='goodalli' OR species='goodallii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cochlicopa' AND (junior_species='lubricella' OR junior_species='lubricella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cochlicopa' AND (species='lubricella' OR species='lubricella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cochlicopa' AND (species='lubricella' OR species='lubricella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cochlicopa' AND (junior_species='lubricella' OR junior_species='lubricella')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='Cochlicopa' AND (species='lubricella' OR species='lubricella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptazeca' AND (junior_species='monodonta' OR junior_species='monodonta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptazeca' AND (species='monodonta' OR species='monodonta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptazeca' AND (species='monodonta' OR species='monodonta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptazeca' AND (junior_species='monodonta' OR junior_species='monodonta')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='Cryptazeca' AND (species='monodonta' OR species='monodonta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lauria' AND (junior_species='cylindracea' OR junior_species='cylindracea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lauria' AND (species='cylindracea' OR species='cylindracea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lauria' AND (species='cylindracea' OR species='cylindracea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lauria' AND (junior_species='cylindracea' OR junior_species='cylindracea')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='Lauria' AND (species='cylindracea' OR species='cylindracea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clausilia' AND (junior_species='bidentata' OR junior_species='bidentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clausilia' AND (species='bidentata' OR species='bidentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clausilia' AND (species='bidentata' OR species='bidentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clausilia' AND (junior_species='bidentata' OR junior_species='bidentata')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='Clausilia' AND (species='bidentata' OR species='bidentata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discus' AND (junior_species='rotundatus' OR junior_species='rotundatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discus' AND (species='rotundatus' OR species='rotundatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discus' AND (species='rotundatus' OR species='rotundatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discus' AND (junior_species='rotundatus' OR junior_species='rotundatus')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='Discus' AND (species='rotundatus' OR species='rotundatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitrea' AND (junior_species='contracta' OR junior_species='contracta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitrea' AND (species='contracta' OR species='contracta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitrea' AND (species='contracta' OR species='contracta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitrea' AND (junior_species='contracta' OR junior_species='contracta')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='Vitrea' AND (species='contracta' OR species='contracta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonites' 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='Zonites' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonites' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonites' 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='Zonites' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oestophorella' AND (junior_species='buvinieri' OR junior_species='buvinierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oestophorella' AND (species='buvinieri' OR species='buvinierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oestophorella' AND (species='buvinieri' OR species='buvinierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oestophorella' AND (junior_species='buvinieri' OR junior_species='buvinierii')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='Oestophorella' AND (species='buvinieri' OR species='buvinierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicella' AND (junior_species='itala' OR junior_species='itala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicella' AND (species='itala' OR species='itala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicella' AND (species='itala' OR species='itala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicella' AND (junior_species='itala' OR junior_species='itala')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='Helicella' AND (species='itala' OR species='itala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepaea' AND (junior_species='nemoralis' OR junior_species='nemoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cepaea' AND (species='nemoralis' OR species='nemoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cepaea' AND (species='nemoralis' OR species='nemoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cepaea' AND (junior_species='nemoralis' OR junior_species='nemoralis')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='Cepaea' AND (species='nemoralis' OR species='nemoralis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4132
The Ecological Register: El Cierro Cave (Level C/D)
Reference:E. Alvarez-Fernandez, J. Bécares, J. F. J. Pardo, A. Agirre-Uribesalgo, D. Alvarez-Alonso, M. T. Aparicio, I. Barrera-Mellado, P. Carral, R. P. Carriol, M. Cubas, M. Cueto, K. Douka, M. Elorza, M. J. Fernández-Gómez, S. Gabriel, N. García-Ibaibarriaga, M. J. Iriarte-Chiapusso, C. Llave, A. Maestro, S. Martín-Jarque, R. Portero, Suárez-Bilbao, Tarriño, and Teira. 2020. Palaeoenvironmental and chronological context of human occupations at El Cierro cave (northern Spain) during the transition from the late Upper Pleistocene to the early Holocene. Journal of Archaeological Science: Reports29:102138 [ER 3797]
Geography
Country: Spain
State: Asturias
Coordinate:43° 27' 26" N, 5° 6' 20" W
Coordinate basis: stated in text
Time interval: Late Pleistocene
Section: 3797
Unit number: 3
Unit order: above to below
Max Ma: 0.01319
Min Ma: 0.0126
Age basis: radiocarbon (calibrated)
Geography comments: "El Cierro Cave (Fresnu, Ribadesella, Asturias) is located in the north-central region of Iberia, at 83 m above sea level, about 2 km from the coast and 3.5 km from the mouth of the River Sella".
"A total of eight AMS radiocarbon dates have been obtained from the transitional levels at El Cierro". The five dates from Levels C-D range from 13,190 to 12,600 cal. BP.
Habitat comments: "Levels D, C and B of El Cierro represent shell-midden deposits. Level C is a whitish shell-midden, with abundant osseous remains of vertebrates and invertebrate shells joined by calcium carbonate with zones containing very little matrix and others where it is more abundant. Level D is a carbonated deposit that laterally displays dark detritic material cemented with carbonates".
"A total of 104 lithic remains has been recorded; 85 in the Azilian (Levels C-D) and 19 in the Mesolithic period (Level B). The assemblage is primarily human accumulated, with the small vertebrate remains having derived through natural deaths or by predation and deposition by owls or diurnal birds of prey".
Methods
Life forms: rodents,ungulates,birds,fishes,crustaceans,clams,snails,other invertebrates
Sampling methods: quarry,screenwash
Sample size: 6566 specimens
Years: 1977 - 1979, 2014 - 2016
Sampling comments: "Current research restarted in 2014 to study the remains found in the 1970s, and re-sample the "shell-midden" deposits (Levels D, C and B). The fauna and archaeological materials surveyed includes both those excavated between 1977 and 1979, and from the 2014 to 2016 fieldwork".
"The volume sampled for the Azilian Level C/D was c. 2,500 cm3 in the latter seasons. As the levels were rich in carbonates, the concretion containing the remains was broken up and the sediment was floated in water and then sieved through screens down to a 0.4 mm mesh size".
Metadata
Sample number: 4132
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2023-02-27 11:54:24
Modified: 2023-04-28 03:28:59
Abundance distribution
34 species
8 singletons
total count 6566
extrapolated richness: 56.1
Fisher's α: 4.693
geometric series k: 0.7687
Hurlbert's PIE: 0.1912
Shannon's H: 0.5246
Good's u: 0.9988
Each square represents a species. Square sizes are proportional to counts.