Coordinate: 15° 40' S, 27° 15' E
climate data based on Wamulume et al. (2011, Physics and Chemistry of the Earth): CMT min/max 13/20, WMT min/max 21 30
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=538 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=538SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=266SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=538 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='chobiensis' OR junior_species='chobiensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygodactylus' AND (species='chobiensis' OR species='chobiensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygodactylus' AND (species='chobiensis' OR species='chobiensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='chobiensis' OR junior_species='chobiensis')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='Lygodactylus' AND (species='chobiensis' OR species='chobiensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' 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='Lygodactylus' AND (species='capensis' OR species='capensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygodactylus' AND (species='capensis' OR species='capensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' 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='Lygodactylus' AND (species='capensis' OR species='capensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaeleo' AND (junior_species='dilepis' OR junior_species='dilepis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chamaeleo' AND (species='dilepis' OR species='dilepis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chamaeleo' AND (species='dilepis' OR species='dilepis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chamaeleo' AND (junior_species='dilepis' OR junior_species='dilepis')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='Chamaeleo' AND (species='dilepis' OR species='dilepis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ichnotropis' AND (junior_species='squamulosa' OR junior_species='squamulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ichnotropis' AND (species='squamulosa' OR species='squamulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ichnotropis' AND (species='squamulosa' OR species='squamulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ichnotropis' AND (junior_species='squamulosa' OR junior_species='squamulosa')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='Ichnotropis' AND (species='squamulosa' OR species='squamulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panaspis' AND (junior_species='wahlbergii' OR junior_species='wahlbergi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panaspis' AND (species='wahlbergii' OR species='wahlbergi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panaspis' AND (species='wahlbergii' OR species='wahlbergi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panaspis' AND (junior_species='wahlbergii' OR junior_species='wahlbergi')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='Panaspis' AND (species='wahlbergii' OR species='wahlbergi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='striata' OR junior_species='striata')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='Mabuya' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='varia' OR junior_species='varia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mabuya' AND (species='varia' OR species='varia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mabuya' AND (species='varia' OR species='varia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mabuya' AND (junior_species='varia' OR junior_species='varia')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='Mabuya' AND (species='varia' OR species='varia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygosoma' AND (junior_species='sundevalli' OR junior_species='sundevallii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygosoma' AND (species='sundevalli' OR species='sundevallii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygosoma' AND (species='sundevalli' OR species='sundevallii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygosoma' AND (junior_species='sundevalli' OR junior_species='sundevallii')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='Lygosoma' AND (species='sundevalli' OR species='sundevallii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='hispida' OR junior_species='hispida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agama' AND (species='hispida' OR species='hispida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agama' AND (species='hispida' OR species='hispida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='hispida' OR junior_species='hispida')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='Agama' AND (species='hispida' OR species='hispida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='niloticus' OR junior_species='niloticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='niloticus' OR species='niloticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='niloticus' OR species='niloticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='niloticus' OR junior_species='niloticus')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='Varanus' AND (species='niloticus' OR species='niloticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vuranus' AND (junior_species='exanthematicus' OR junior_species='exanthematicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vuranus' AND (species='exanthematicus' OR species='exanthematicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vuranus' AND (species='exanthematicus' OR species='exanthematicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vuranus' AND (junior_species='exanthematicus' OR junior_species='exanthematicus')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='Vuranus' AND (species='exanthematicus' OR species='exanthematicus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=538