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=408 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=408SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=192SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=408 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amietophrynus' AND (junior_species='gutturalis' OR junior_species='gutturalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amietophrynus' AND (species='gutturalis' OR species='gutturalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amietophrynus' AND (species='gutturalis' OR species='gutturalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amietophrynus' AND (junior_species='gutturalis' OR junior_species='gutturalis')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='Amietophrynus' AND (species='gutturalis' OR species='gutturalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemisus' AND (junior_species='marmoratus' OR junior_species='marmoratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemisus' AND (species='marmoratus' OR species='marmoratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemisus' AND (species='marmoratus' OR species='marmoratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemisus' AND (junior_species='marmoratus' OR junior_species='marmoratus')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='Hemisus' AND (species='marmoratus' OR species='marmoratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopelis' AND (junior_species='flavomaculatus' OR junior_species='flavomaculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptopelis' AND (species='flavomaculatus' OR species='flavomaculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptopelis' AND (species='flavomaculatus' OR species='flavomaculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptopelis' AND (junior_species='flavomaculatus' OR junior_species='flavomaculatus')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='Leptopelis' AND (species='flavomaculatus' OR species='flavomaculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='glandicolor' OR junior_species='glandicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyperolius' AND (species='glandicolor' OR species='glandicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyperolius' AND (species='glandicolor' OR species='glandicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='glandicolor' OR junior_species='glandicolor')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='Hyperolius' AND (species='glandicolor' OR species='glandicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='puncticulatus' OR junior_species='puncticulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyperolius' AND (species='puncticulatus' OR species='puncticulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyperolius' AND (species='puncticulatus' OR species='puncticulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='puncticulatus' OR junior_species='puncticulatus')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='Hyperolius' AND (species='puncticulatus' OR species='puncticulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='tuberilinguis' OR junior_species='tuberilinguis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyperolius' AND (species='tuberilinguis' OR species='tuberilinguis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyperolius' AND (species='tuberilinguis' OR species='tuberilinguis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyperolius' AND (junior_species='tuberilinguis' OR junior_species='tuberilinguis')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='Hyperolius' AND (species='tuberilinguis' OR species='tuberilinguis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='anchietae' OR junior_species='anchietae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychadena' AND (species='anchietae' OR species='anchietae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychadena' AND (species='anchietae' OR species='anchietae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='anchietae' OR junior_species='anchietae')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='Ptychadena' AND (species='anchietae' OR species='anchietae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='mascareniensis' OR junior_species='mascareniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychadena' AND (species='mascareniensis' OR species='mascareniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychadena' AND (species='mascareniensis' OR species='mascareniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychadena' AND (junior_species='mascareniensis' OR junior_species='mascareniensis')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='Ptychadena' AND (species='mascareniensis' OR species='mascareniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='acridoides' OR junior_species='acridoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phrynobatrachus' AND (species='acridoides' OR species='acridoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phrynobatrachus' AND (species='acridoides' OR species='acridoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phrynobatrachus' AND (junior_species='acridoides' OR junior_species='acridoides')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='Phrynobatrachus' AND (species='acridoides' OR species='acridoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='luteopicturatus' OR junior_species='luteopicturatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygodactylus' AND (species='luteopicturatus' OR species='luteopicturatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygodactylus' AND (species='luteopicturatus' OR species='luteopicturatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='luteopicturatus' OR junior_species='luteopicturatus')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='luteopicturatus' OR species='luteopicturatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='platycephalus' OR junior_species='platycephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='platycephalus' OR species='platycephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='platycephalus' OR species='platycephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='platycephalus' OR junior_species='platycephalus')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='Hemidactylus' AND (species='platycephalus' OR species='platycephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mabouia' OR junior_species='mabouia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='mabouia' OR species='mabouia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='mabouia' OR species='mabouia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='mabouia' OR junior_species='mabouia')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='Hemidactylus' AND (species='mabouia' OR species='mabouia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='squamulatus' OR junior_species='squamulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='squamulatus' OR species='squamulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='squamulatus' OR species='squamulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='squamulatus' OR junior_species='squamulatus')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='Hemidactylus' AND (species='squamulatus' OR species='squamulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemaspis' AND (junior_species='africana' OR junior_species='africana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnemaspis' AND (species='africana' OR species='africana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnemaspis' AND (species='africana' OR species='africana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnemaspis' AND (junior_species='africana' OR junior_species='africana')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='Cnemaspis' AND (species='africana' OR species='africana') 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='Melanoseps' AND (junior_species='loveridgei' OR junior_species='loveridgeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanoseps' AND (species='loveridgei' OR species='loveridgeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanoseps' AND (species='loveridgei' OR species='loveridgeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanoseps' AND (junior_species='loveridgei' OR junior_species='loveridgeii')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='Melanoseps' AND (species='loveridgei' OR species='loveridgeii') 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='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='Trachylepis' AND (junior_species='maculilabris' OR junior_species='maculilabris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='maculilabris' OR species='maculilabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='maculilabris' OR species='maculilabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='maculilabris' OR junior_species='maculilabris')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='Trachylepis' AND (species='maculilabris' OR species='maculilabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' 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='Trachylepis' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' 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='Trachylepis' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latastia' AND (junior_species='longicaudata' OR junior_species='longicaudata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Latastia' AND (species='longicaudata' OR species='longicaudata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Latastia' AND (species='longicaudata' OR species='longicaudata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latastia' AND (junior_species='longicaudata' OR junior_species='longicaudata')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='Latastia' AND (species='longicaudata' OR species='longicaudata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='lionotus' OR junior_species='lionotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agama' AND (species='lionotus' OR species='lionotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agama' AND (species='lionotus' OR species='lionotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agama' AND (junior_species='lionotus' OR junior_species='lionotus')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='lionotus' OR species='lionotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerrhosaurus' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerrhosaurus' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerrhosaurus' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerrhosaurus' AND (junior_species='major' OR junior_species='major')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='Gerrhosaurus' AND (species='major' OR species='major') 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='Leptotyphlops' AND (junior_species='scutifrons' OR junior_species='scutifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptotyphlops' AND (species='scutifrons' OR species='scutifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptotyphlops' AND (species='scutifrons' OR species='scutifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptotyphlops' AND (junior_species='scutifrons' OR junior_species='scutifrons')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='Leptotyphlops' AND (species='scutifrons' OR species='scutifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycophidion' AND (junior_species='capense' OR junior_species='capense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycophidion' AND (species='capense' OR species='capense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycophidion' AND (species='capense' OR species='capense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycophidion' AND (junior_species='capense' OR junior_species='capense')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='Lycophidion' AND (species='capense' OR species='capense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='battersbyi' OR junior_species='battersbyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philothamnus' AND (species='battersbyi' OR species='battersbyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philothamnus' AND (species='battersbyi' OR species='battersbyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='battersbyi' OR junior_species='battersbyii')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='Philothamnus' AND (species='battersbyi' OR species='battersbyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thelotornis' AND (junior_species='mossambicanus' OR junior_species='mossambicanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thelotornis' AND (species='mossambicanus' OR species='mossambicanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thelotornis' AND (species='mossambicanus' OR species='mossambicanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thelotornis' AND (junior_species='mossambicanus' OR junior_species='mossambicanus')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='Thelotornis' AND (species='mossambicanus' OR species='mossambicanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypeltis' AND (junior_species='medici' OR junior_species='medicii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasypeltis' AND (species='medici' OR species='medicii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasypeltis' AND (species='medici' OR species='medicii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasypeltis' AND (junior_species='medici' OR junior_species='medicii')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='Dasypeltis' AND (species='medici' OR species='medicii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendroaspis' AND (junior_species='angusticeps' OR junior_species='angusticeps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendroaspis' AND (species='angusticeps' OR species='angusticeps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendroaspis' AND (species='angusticeps' OR species='angusticeps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendroaspis' AND (junior_species='angusticeps' OR junior_species='angusticeps')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='Dendroaspis' AND (species='angusticeps' OR species='angusticeps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocodylus' 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='Crocodylus' AND (species='niloticus' OR species='niloticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocodylus' AND (species='niloticus' OR species='niloticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocodylus' 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='Crocodylus' AND (species='niloticus' OR species='niloticus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=408 The Ecological Register: Kitobo Forest (2007)
Kitobo Forest (2007)
Basic information
Sample name: Kitobo Forest (2007)

Reference: P. K. Malonza, B. A. Bwong, and V. Muchai. 2011. Kitobo Forest of Kenya, a unique hotspot of herpetofaunal diversity. Acta Herpetologica 6(2):149-160 [ER 192]
Geography
Country: Kenya


Coordinate: 3° 26' S, 37° 37' E
Coordinate basis: stated in text

Geography comments: coordinate given in text

Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

MAT: 22.0

MAP: 530.0

Habitat comments: "evergreen indigenous forest surrounded by arid lands of Acacia bushes"

Methods
Life forms: lizards,snakes,other reptiles,frogs

Sampling methods: timed,drift fences,pitfall traps,hand capture

Sample size: 163 individuals

Years: 2007

Sampling comments: time species counts plus drift fences plus pitfall traps

Metadata
Sample number: 408

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-15 09:10:11

Modified: 2014-03-19 23:03:36

Abundance distribution
31 species
9 singletons
total count 163
extrapolated richness: 58.8
Fisher's α: 11.346
geometric series k: 0.9065
Hurlbert's PIE: 0.9352
Shannon's H: 2.9980
Good's u: 0.9453
Each square represents a species. Square sizes are proportional to counts.
Register