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=3985 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3985SELECT 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=3985 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Soricidae' 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='Soricidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Soricidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Soricidae' 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='Soricidae' AND (species='indet.' OR species='indet.') 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='Herpestidae' 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='Herpestidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herpestidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpestidae' 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='Herpestidae' AND (species='indet.' OR species='indet.') 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='Panthera' AND (junior_species='pardus' OR junior_species='pardus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='pardus' OR species='pardus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='pardus' OR junior_species='pardus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Panthera' AND (species='pardus' OR species='pardus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='capensis' OR species='capensis') 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='Damaliscus' AND (junior_species='pygargus' OR junior_species='pygargus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Damaliscus' AND (species='pygargus' OR species='pygargus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Damaliscus' AND (junior_species='pygargus' OR junior_species='pygargus')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='Damaliscus' AND (species='pygargus' OR species='pygargus') 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='Hippotragus' AND (junior_species='equinus' OR junior_species='equinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippotragus' AND (species='equinus' OR species='equinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippotragus' AND (junior_species='equinus' OR junior_species='equinus')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='equinus' OR species='equinus') 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='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='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='irroratus' OR junior_species='irroratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otomys' AND (species='irroratus' OR species='irroratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otomys' AND (species='irroratus' OR species='irroratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' AND (junior_species='irroratus' OR junior_species='irroratus')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='irroratus' OR species='irroratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagomorpha' 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='Lagomorpha' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagomorpha' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagomorpha' 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='Lagomorpha' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aves' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aves' 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='Aves' 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='melanotus' OR junior_species='melanotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudocordylus' AND (species='melanotus' OR species='melanotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudocordylus' AND (species='melanotus' OR species='melanotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudocordylus' AND (junior_species='melanotus' OR junior_species='melanotus')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='melanotus' OR species='melanotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyxicephalus' AND (junior_species='adspersus' OR junior_species='adspersus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyxicephalus' AND (species='adspersus' OR species='adspersus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyxicephalus' AND (species='adspersus' OR species='adspersus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyxicephalus' AND (junior_species='adspersus' OR junior_species='adspersus')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='Pyxicephalus' AND (species='adspersus' OR species='adspersus') 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='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=3985 The Ecological Register: Sehonghong (RBL/CLBRF)
Sehonghong (RBL/CLBRF)
Basic information
Sample name: Sehonghong (RBL/CLBRF)

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: Late Pleistocene

Section: 3742

Unit number: 7

Unit order: above to below

Max Ma: 0.01247

Min Ma: 0.01241

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".
Two radiocarbon dates on Layers RBL/CLBRF range from 12,470 ± 100 BP to 12,410 ± 45 BP.

•
Environment
Lithology: ash

Taphonomic context: human accumulation,rock shelter

Archaeology: hearths,stone tools,other structures

Habitat comments: "The RBL/CLBRF (Red Brown Loam/Carbonaceous Loams Below Rock Fall) layers comprise brown, compost-like light loamy soils with high macroplant contents and ashy charcoal-rich loams. They contained several heavy red ochre-stained grindstones. Its lithic assemblage has been assigned to the Robberg Industry". Hearths are present throughout all of the Pleistocene layers, with one from Layers RBL/CLBRF having an "elaborate stone setting around it".
"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,rodents,ungulates,other large mammals,other small mammals,birds,lizards,frogs,fishes,clams

Sampling methods: quarry,screenwash

Sample size: 438 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".

Metadata
Sample number: 3985

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2022-08-25 16:07:26

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

Abundance distribution
31 species
6 singletons
total count 438
extrapolated richness: 48.0
Fisher's α: 7.619
geometric series k: 0.8513
Hurlbert's PIE: 0.8770
Shannon's H: 2.6044
Good's u: 0.9864
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Soricidae indet.7
"Shrew"
Canis cf. mesomelas17.9 kg carnivore
Herpestidae indet.4
Caracal caracal112 kg carnivore
Panthera pardus133 kg carnivore
also 1 Carnivora indet.
Equus capensis2
Equus quagga25279 kg grazer
Procavia capensis1252.8 kg browser
Phacochoerus africanus182 kg grazer-browser
also 1 Suidae indet.
Connochaetes gnou22 grazer
Alcelaphus buselaphus1143 kg grazer-browser
also 19 Alcelaphinae indet.
Damaliscus pygargus983 kg grazer-browser
Sylvicapra grimmia513 kg browser-grazer
Antidorcas marsupialis440 kg browser-grazer
Oreotragus oreotragus3 browser-grazer
Ourebia ourebi214 kg grazer-browser
Raphicerus campestris109.7 kg browser-grazer
Pelea capreolus1616 kg grazer
Hippotragus cf. leucophaeus1
Hippotragus equinus11246 kg grazer
also 1 Hippotragus sp.
Taurotragus oryx44393 kg browser-grazer
"Tragelaphus oryx"
Redunca fulvorufula229 kg
also 286 Bovidae indet.
Hystrix africaeaustralis1415 kg browser
Otomys cf. irroratus42
also 194 Otomys sp. and 58 Rodentia indet.
Lagomorpha indet.8
Aves indet.34
including 4 "Francolins"
Pseudocordylus melanotus2
also 2 Pseudocordylus sp. and 13 Lacertilia indet.
Pyxicephalus adspersus2
also 24 Anura indet.
Unio caffer3
also 52 Unionidae indet.
Labeobarbus aeneus31
also 166 Labeoninae indet.
Austroglanis sclateri5
also 6 Fish indet.