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=3981 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3981SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3742SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3981 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papio' AND (junior_species='hamadryas' OR junior_species='hamadryas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papio' AND (species='hamadryas' OR species='hamadryas') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papio' AND (junior_species='hamadryas' OR junior_species='hamadryas')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='Papio' AND (species='hamadryas' OR species='hamadryas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='chama' OR junior_species='chama')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='chama' OR species='chama') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='chama' OR junior_species='chama')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='chama' OR species='chama') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mesomelas' OR junior_species='mesomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='mesomelas' OR species='mesomelas') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='mesomelas' OR junior_species='mesomelas')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='mesomelas' OR species='mesomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suricata' AND (junior_species='suricatta' OR junior_species='suricatta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Suricata' AND (species='suricatta' OR species='suricatta') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Suricata' AND (junior_species='suricatta' OR junior_species='suricatta')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='Suricata' AND (species='suricatta' OR species='suricatta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proteles' AND (junior_species='cristatus' OR junior_species='cristatus')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='Proteles' AND (species='cristatus' OR species='cristatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proteles' AND (junior_species='cristatus' OR junior_species='cristatus')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='Proteles' AND (species='cristatus' OR species='cristatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caracal' AND (junior_species='caracal' OR junior_species='caracal')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caracal' AND (species='caracal' OR species='caracal') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caracal' AND (junior_species='caracal' OR junior_species='caracal')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='Caracal' AND (species='caracal' OR species='caracal') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lybica' OR junior_species='lybica')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='Felis' AND (species='lybica' OR species='lybica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felis' AND (species='lybica' OR species='lybica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lybica' OR junior_species='lybica')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='Felis' AND (species='lybica' OR species='lybica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='quagga' OR junior_species='quagga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='quagga' OR species='quagga') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='quagga' OR junior_species='quagga')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='quagga' OR species='quagga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procavia' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procavia' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procavia' AND (junior_species='capensis' OR junior_species='capensis')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='Procavia' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phacochoerus' AND (junior_species='africanus' OR junior_species='africanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phacochoerus' AND (species='africanus' OR species='africanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phacochoerus' AND (junior_species='africanus' OR junior_species='africanus')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='Phacochoerus' AND (species='africanus' OR species='africanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Connochaetes' AND (junior_species='gnou' OR junior_species='gnou')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Connochaetes' AND (species='gnou' OR species='gnou') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Connochaetes' AND (species='gnou' OR species='gnou')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Connochaetes' AND (junior_species='gnou' OR junior_species='gnou')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='Connochaetes' AND (species='gnou' OR species='gnou') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcelaphus' AND (junior_species='buselaphus' OR junior_species='buselaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcelaphus' AND (species='buselaphus' OR species='buselaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcelaphus' AND (junior_species='buselaphus' OR junior_species='buselaphus')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='Alcelaphus' AND (species='buselaphus' OR species='buselaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvicapra' AND (junior_species='grimmia' OR junior_species='grimmia')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='Sylvicapra' AND (species='grimmia' OR species='grimmia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidorcas' AND (junior_species='marsupialis' OR junior_species='marsupialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Antidorcas' AND (species='marsupialis' OR species='marsupialis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Antidorcas' AND (junior_species='marsupialis' OR junior_species='marsupialis')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='Antidorcas' AND (species='marsupialis' OR species='marsupialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreotragus' AND (junior_species='oreotragus' OR junior_species='oreotragus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreotragus' AND (species='oreotragus' OR species='oreotragus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreotragus' AND (species='oreotragus' OR species='oreotragus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreotragus' AND (junior_species='oreotragus' OR junior_species='oreotragus')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='Oreotragus' AND (species='oreotragus' OR species='oreotragus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ourebia' AND (junior_species='ourebi' OR junior_species='ourebii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ourebia' AND (species='ourebi' OR species='ourebii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ourebia' AND (junior_species='ourebi' OR junior_species='ourebii')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='Ourebia' AND (species='ourebi' OR species='ourebii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Raphicerus' AND (junior_species='campestris' OR junior_species='campestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Raphicerus' AND (species='campestris' OR species='campestris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Raphicerus' AND (junior_species='campestris' OR junior_species='campestris')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='Raphicerus' AND (species='campestris' OR species='campestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelea' 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='Pelea' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pelea' 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='Pelea' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippotragus' AND (junior_species='leucophaeus' OR junior_species='leucophaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippotragus' AND (species='leucophaeus' OR species='leucophaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippotragus' AND (species='leucophaeus' OR species='leucophaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippotragus' AND (junior_species='leucophaeus' OR junior_species='leucophaeus')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='Hippotragus' AND (species='leucophaeus' OR species='leucophaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taurotragus' AND (junior_species='oryx' OR junior_species='oryx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taurotragus' AND (species='oryx' OR species='oryx') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taurotragus' AND (junior_species='oryx' OR junior_species='oryx')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='Taurotragus' AND (species='oryx' OR species='oryx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Redunca' AND (junior_species='arundinum' OR junior_species='arundinum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Redunca' AND (species='arundinum' OR species='arundinum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Redunca' AND (species='arundinum' OR species='arundinum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Redunca' AND (junior_species='arundinum' OR junior_species='arundinum')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='Redunca' AND (species='arundinum' OR species='arundinum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Redunca' AND (junior_species='fulvorufula' OR junior_species='fulvorufula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Redunca' AND (species='fulvorufula' OR species='fulvorufula') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Redunca' AND (junior_species='fulvorufula' OR junior_species='fulvorufula')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='Redunca' AND (species='fulvorufula' OR species='fulvorufula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedetes' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pedetes' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pedetes' AND (junior_species='capensis' OR junior_species='capensis')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='Pedetes' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='africaeaustralis' OR junior_species='africaeaustralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hystrix' AND (species='africaeaustralis' OR species='africaeaustralis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hystrix' AND (junior_species='africaeaustralis' OR junior_species='africaeaustralis')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='Hystrix' AND (species='africaeaustralis' OR species='africaeaustralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' 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='Otomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' 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='Otomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptomys' 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='Cryptomys' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptomys' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptomys' 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='Cryptomys' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pronolagus' 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='Pronolagus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pronolagus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pronolagus' 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='Pronolagus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='saxatilis' OR junior_species='saxatilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='saxatilis' OR species='saxatilis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='saxatilis' OR junior_species='saxatilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lepus' AND (species='saxatilis' OR species='saxatilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Struthio' AND (junior_species='camelus' OR junior_species='camelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Struthio' AND (species='camelus' OR species='camelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Struthio' AND (species='camelus' OR species='camelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Struthio' AND (junior_species='camelus' OR junior_species='camelus')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='Struthio' AND (species='camelus' OR species='camelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scleroptila' AND (junior_species='afra' OR junior_species='afra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scleroptila' AND (species='afra' OR species='afra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scleroptila' AND (species='afra' OR species='afra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scleroptila' AND (junior_species='afra' OR junior_species='afra')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='Scleroptila' AND (species='afra' OR species='afra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudinidae' 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='Testudinidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testudinidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudinidae' 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='Testudinidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpentes' 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='Serpentes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Serpentes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Serpentes' 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='Serpentes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocordylus' 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='Pseudocordylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocordylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocordylus' 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='Pseudocordylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anura' 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='Anura' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anura' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anura' 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='Anura' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achatina' 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='Achatina' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Achatina' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achatina' 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='Achatina' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Unio' AND (junior_species='caffer' OR junior_species='caffer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Unio' AND (species='caffer' OR species='caffer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Unio' AND (species='caffer' OR species='caffer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Unio' AND (junior_species='caffer' OR junior_species='caffer')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='Unio' AND (species='caffer' OR species='caffer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labeobarbus' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Labeobarbus' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Labeobarbus' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labeobarbus' AND (junior_species='aeneus' OR junior_species='aeneus')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='Labeobarbus' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labeo' AND (junior_species='capensis' OR junior_species='capensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Labeo' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Labeo' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Labeo' AND (junior_species='capensis' OR junior_species='capensis')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='Labeo' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austroglanis' AND (junior_species='sclateri' OR junior_species='sclaterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Austroglanis' AND (species='sclateri' OR species='sclaterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Austroglanis' AND (species='sclateri' OR species='sclaterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Austroglanis' AND (junior_species='sclateri' OR junior_species='sclaterii')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='Austroglanis' AND (species='sclateri' OR species='sclaterii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3981 The Ecological Register: Sehonghong (ALP)
Sehonghong (ALP)
Basic information
Sample name: Sehonghong (ALP)

Reference: I. Plug and P. Mitchell. 2008. Sehonghong: hunter-gatherer utilization of animal resources in the highlands of Lesotho. Annals of the Transvaal Museum 45:31-53 [ER 3742]
Geography
Country: Lesotho

State: Thaba-Tseka


Coordinate: 29° 46' S, 28° 47' E
Coordinate basis: stated in text

Time interval: Holocene

Section: 3742

Unit number: 3

Unit order: above to below

Max Ma: 0.00729

Min Ma: 0.00701

Age basis: radiocarbon (uncalibrated)

Geography comments: "Sehonghong is a large rock-shelter on the banks of the Sehonghong River, close to its confluence with the Senqu (Orange/Gariep) in the Thaba Tseka District of the highlands of Lesotho. The site lies at an elevation of 1800 m above sea level".
"Layer ALP produced four highly similar radiocarbon dates ranging from 7290 ± 80 BP to 7010 ± 70 BP, with a mean value of 7150 BP".

•
Environment
Lithology: ash

Taphonomic context: human accumulation,rock shelter

Archaeology: hearths,stone tools,other structures

Habitat comments: "Layer ALP (Ashy Loam with Plants) consists of a series of predominantly reddish-brown or black ashy loams, many of which contain partly humified plant remains. It contained one pit and two shallow hearths, along with a ‘later Oakhurst’ lithic assemblage, featuring many retouched tools".
"While not all of the animal remains in the deposit would have been accumulated by people, the intense degree of fragmentation and burning that characterizes the Sehonghong assemblages strongly suggests that people were responsible for acquiring almost all of the faunal remains".

Methods
Life forms: carnivores,primates,rodents,ungulates,other large mammals,other small mammals,birds,lizards,snakes,turtles,frogs,fishes,clams,snails

Sampling methods: quarry,screenwash

Sample size: 1287 specimens

Sampled by: P. Mitchell

Years: 1992

Sampling comments: "The primary excavation of the site was conducted by P. Mitchell in 1992. All sediment removed from the deposits was dry-sieved through a 1.5 mm mesh".
For Layer ALP, "188 buckets of deposit were removed in 39 units".

Metadata
Sample number: 3981

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-08-25 13:25:17

Modified: 2023-05-30 01:41:18

Abundance distribution
39 species
8 singletons
total count 1287
extrapolated richness: 57.5
Fisher's α: 7.589
geometric series k: 0.8671
Hurlbert's PIE: 0.9010
Shannon's H: 2.6831
Good's u: 0.9938
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Papio hamadryas12312 kg
Vulpes chama12.7 kg carnivore-frugivore
Canis mesomelas47.9 kg carnivore
Suricata suricatta1663 g invertivore-carnivore
also 6 Herpestidae indet.
Proteles cristatus19.1 kg insectivore
Caracal caracal612 kg carnivore
Felis lybica2
"Felis silvestris"; also 1 Felis sp. and 7 Carnivora indet.
Equus quagga30279 kg grazer
Procavia capensis2252.8 kg browser
Phacochoerus africanus482 kg grazer-browser
Connochaetes gnou44 grazer
Alcelaphus buselaphus13143 kg grazer-browser
also 2 Alcelaphinae indet.
Sylvicapra grimmia313 kg browser-grazer
Antidorcas marsupialis440 kg browser-grazer
Oreotragus oreotragus115 browser-grazer
Ourebia ourebi414 kg grazer-browser
Raphicerus campestris379.7 kg browser-grazer
Pelea capreolus10716 kg grazer
Hippotragus cf. leucophaeus1
Taurotragus oryx32393 kg browser-grazer
"Tragelaphus oryx"
Redunca arundinum1 grazer
Redunca fulvorufula729 kg
also 817 Bovidae indet.
Pedetes capensis22.4 kg
Hystrix africaeaustralis1515 kg browser
Otomys sp.59
Cryptomys sp.3
also 62 Rodentia indet.
Pronolagus sp.1
Lepus saxatilis292.0 kg
also 3 Lepus sp. and 81 Lagomorpha indet.
Struthio camelus1111 kg grazer-browser
Scleroptila cf. afra3
"Scleroptila cf. africanus"; also 62 Aves indet.
Testudinidae indet.1
"Tortoise"
Serpentes indet.16
Pseudocordylus sp.2
also 16 Lacertilia indet.
Anura indet.22
"Frog/toad"
Achatina sp.105
also 16 Gastropoda indet.: including 1 "Bulinus/Succinea"
Unio caffer9
also 33 Unionidae indet.
Labeobarbus aeneus226
Labeo capensis13
also 472 Labeoninae indet.
Austroglanis sclateri15