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=4130 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4130SELECT 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=4130 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='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='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')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='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' 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='Canis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' 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='Canis' AND (species='sp.' OR species='sp.') 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='Sorex' 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='Sorex' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sorex' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sorex' 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='Sorex' AND (species='sp.' OR species='sp.') 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='Talpa' 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='Talpa' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Talpa' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Talpa' 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='Talpa' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salamandra' AND (junior_species='salamandra' OR junior_species='salamandra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salamandra' AND (species='salamandra' OR species='salamandra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salamandra' AND (species='salamandra' OR species='salamandra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salamandra' AND (junior_species='salamandra' OR junior_species='salamandra')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='Salamandra' AND (species='salamandra' OR species='salamandra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scolopax' AND (junior_species='rusticola' OR junior_species='rusticola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scolopax' AND (species='rusticola' OR species='rusticola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scolopax' AND (species='rusticola' OR species='rusticola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scolopax' AND (junior_species='rusticola' OR junior_species='rusticola')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='Scolopax' AND (species='rusticola' OR species='rusticola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mugilidae' 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='Mugilidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mugilidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mugilidae' 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='Mugilidae' 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='Steromphala' AND (junior_species='cineraria' OR junior_species='cineraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Steromphala' AND (species='cineraria' OR species='cineraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Steromphala' AND (species='cineraria' OR species='cineraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Steromphala' AND (junior_species='cineraria' OR junior_species='cineraria')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='Steromphala' AND (species='cineraria' OR species='cineraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stramonita' AND (junior_species='haemastoma' OR junior_species='haemastoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stramonita' AND (species='haemastoma' OR species='haemastoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stramonita' AND (species='haemastoma' OR species='haemastoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stramonita' AND (junior_species='haemastoma' OR junior_species='haemastoma')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='Stramonita' AND (species='haemastoma' OR species='haemastoma') 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='Ostrea' AND (junior_species='edulis' OR junior_species='edulis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ostrea' AND (species='edulis' OR species='edulis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ostrea' AND (species='edulis' OR species='edulis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrea' AND (junior_species='edulis' OR junior_species='edulis')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='Ostrea' AND (species='edulis' OR species='edulis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scrobicularia' AND (junior_species='plana' OR junior_species='plana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scrobicularia' AND (species='plana' OR species='plana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scrobicularia' AND (species='plana' OR species='plana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scrobicularia' AND (junior_species='plana' OR junior_species='plana')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='Scrobicularia' AND (species='plana' OR species='plana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruditapes' AND (junior_species='decussatus' OR junior_species='decussatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ruditapes' AND (species='decussatus' OR species='decussatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ruditapes' AND (species='decussatus' OR species='decussatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ruditapes' AND (junior_species='decussatus' OR junior_species='decussatus')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='Ruditapes' AND (species='decussatus' OR species='decussatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pollicipes' AND (junior_species='pollicipes' OR junior_species='pollicipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pollicipes' AND (species='pollicipes' OR species='pollicipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pollicipes' AND (species='pollicipes' OR species='pollicipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pollicipes' AND (junior_species='pollicipes' OR junior_species='pollicipes')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='Pollicipes' AND (species='pollicipes' OR species='pollicipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriphia' AND (junior_species='verrucosa' OR junior_species='verrucosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eriphia' AND (species='verrucosa' OR species='verrucosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eriphia' AND (species='verrucosa' OR species='verrucosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eriphia' AND (junior_species='verrucosa' OR junior_species='verrucosa')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='Eriphia' AND (species='verrucosa' OR species='verrucosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perforatus' AND (junior_species='perforatus' OR junior_species='perforatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perforatus' AND (species='perforatus' OR species='perforatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perforatus' AND (species='perforatus' OR species='perforatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perforatus' AND (junior_species='perforatus' OR junior_species='perforatus')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='Perforatus' AND (species='perforatus' OR species='perforatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chthamalus' AND (junior_species='montagui' OR junior_species='montaguii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chthamalus' AND (species='montagui' OR species='montaguii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chthamalus' AND (species='montagui' OR species='montaguii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chthamalus' AND (junior_species='montagui' OR junior_species='montaguii')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='Chthamalus' AND (species='montagui' OR species='montaguii') 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='bicostulata' OR junior_species='bicostulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Obscurella' AND (species='bicostulata' OR species='bicostulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Obscurella' AND (species='bicostulata' OR species='bicostulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Obscurella' AND (junior_species='bicostulata' OR junior_species='bicostulata')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='bicostulata' OR species='bicostulata') 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='Pomatias' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pomatias' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pomatias' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pomatias' AND (junior_species='elegans' OR junior_species='elegans')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='Pomatias' AND (species='elegans' OR species='elegans') 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='Carychium' AND (junior_species='tridentatum' OR junior_species='tridentatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carychium' AND (species='tridentatum' OR species='tridentatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carychium' AND (species='tridentatum' OR species='tridentatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carychium' AND (junior_species='tridentatum' OR junior_species='tridentatum')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='Carychium' AND (species='tridentatum' OR species='tridentatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptazeca' AND (junior_species='subcylindrica' OR junior_species='subcylindrica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptazeca' AND (species='subcylindrica' OR species='subcylindrica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptazeca' AND (species='subcylindrica' OR species='subcylindrica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptazeca' AND (junior_species='subcylindrica' OR junior_species='subcylindrica')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='subcylindrica' OR species='subcylindrica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vallonia' AND (junior_species='excentrica' OR junior_species='excentrica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vallonia' AND (species='excentrica' OR species='excentrica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vallonia' AND (species='excentrica' OR species='excentrica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vallonia' AND (junior_species='excentrica' OR junior_species='excentrica')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='excentrica' OR species='excentrica') 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='Vitrina' AND (junior_species='pellucida' OR junior_species='pellucida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vitrina' AND (species='pellucida' OR species='pellucida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vitrina' AND (species='pellucida' OR species='pellucida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vitrina' AND (junior_species='pellucida' OR junior_species='pellucida')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='Vitrina' AND (species='pellucida' OR species='pellucida') 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='Elona' AND (junior_species='quimperiana' OR junior_species='quimperiana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elona' AND (species='quimperiana' OR species='quimperiana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elona' AND (species='quimperiana' OR species='quimperiana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elona' AND (junior_species='quimperiana' OR junior_species='quimperiana')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='Elona' AND (species='quimperiana' OR species='quimperiana') 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=4130 The Ecological Register: El Cierro Cave (Level B)
El Cierro Cave (Level B)
Basic information
Sample name: El Cierro Cave (Level B)

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: Reports 29:102138 [ER 3797]
Geography
Country: Spain

State: Asturias


Coordinate: 43° 27' 26" N, 5° 6' 20" W
Coordinate basis: stated in text

Time interval: Holocene

Section: 3797

Unit number: 1

Unit order: above to below

Max Ma: 0.00946

Min Ma: 0.00794

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 two dates from Level B range from 9460 to 7940 cal. BP.

•
Environment
Lithology: claystone

Taphonomic context: bird accumulation,cave,human accumulation,midden

Archaeology: stone tools

Habitat comments: "Levels D, C and B of El Cierro represent shell-midden deposits. Level B contains a few small and angular limestone pebbles. The upper part of Level B consists of loose sediment formed by brownish-black clay. 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: carnivores,rodents,ungulates,other small mammals,birds,salamanders,fishes,crustaceans,clams,snails,other invertebrates

Sampling methods: quarry,screenwash

Sample size: 3891 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 Mesolithic Level B was c. 5,000 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: 4130

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2023-02-27 11:29:32

Modified: 2023-04-28 03:28:18

Abundance distribution
44 species
15 singletons
total count 3891
extrapolated richness: 82.7
Fisher's α: 6.952
geometric series k: 0.8342
Hurlbert's PIE: 0.5829
Shannon's H: 1.4810
Good's u: 0.9961
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Cervus elaphus32104 kg
Capra pyrenaica2
Sus scrofa154 kg herbivore
Canis sp.1
Arvicola amphibius1
Sorex sp.1
"araneus-coronatus"
Sorex minutus1
Talpa sp.2
Salamandra salamandra2
Scolopax rusticola117.5 g insectivore
3 Aves indet.
Mugilidae indet.1
cf
Salmonidae indet.1
Anguilla anguilla1
Patella vulgata235
Patella depressa97
Patella ulyssiponensis114
also 1020 Patella sp.
Phorcus lineatus144
Steromphala cineraria2
"Gibbula cineraria"
Stramonita haemastoma1
Mytilus galloprovincialis570
Ostrea edulis6
Scrobicularia plana56
Ruditapes decussatus1
Pollicipes pollicipes3
Eriphia verrucosa6
Perforatus perforatus26
2 Balanidae indet.
Chthamalus montagui3
also 28 Chthamalus sp.
Paracentrotus lividus2425
Obscurella bicostulata36
Menkia horsti2
Pomatias elegans5
Iberozospeum schaufussi31
"Zospeum schaufussi" and "Zospeum suarezi"
Carychium tridentatum2
Cryptazeca subcylindrica4
Vallonia excentrica1
Clausilia bidentata5
Discus rotundatus1
Vitrea contracta4
Vitrina pellucida1
Zonites sp.17
Oestophorella buvinieri12
Helicella itala3
Elona quimperiana1
Cepaea nemoralis30