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=409 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=409SELECT 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=409 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='scheffleri' OR junior_species='schefflerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygodactylus' AND (species='scheffleri' OR species='schefflerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygodactylus' AND (species='scheffleri' OR species='schefflerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygodactylus' AND (junior_species='scheffleri' OR junior_species='schefflerii')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='scheffleri' OR species='schefflerii') 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='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='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='Trachylepis' AND (junior_species='planifrons' OR junior_species='planifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='planifrons' OR species='planifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='planifrons' OR species='planifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='planifrons' OR junior_species='planifrons')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='planifrons' OR species='planifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='brevicollis' OR junior_species='brevicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachylepis' AND (species='brevicollis' OR species='brevicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachylepis' AND (species='brevicollis' OR species='brevicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachylepis' AND (junior_species='brevicollis' OR junior_species='brevicollis')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='brevicollis' OR species='brevicollis') 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='Gerrhosaurus' AND (junior_species='flavigularis' OR junior_species='flavigularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gerrhosaurus' AND (species='flavigularis' OR species='flavigularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gerrhosaurus' AND (species='flavigularis' OR species='flavigularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gerrhosaurus' AND (junior_species='flavigularis' OR junior_species='flavigularis')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='flavigularis' OR species='flavigularis') 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='Varanus' AND (junior_species='albigularis' OR junior_species='albigularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Varanus' AND (species='albigularis' OR species='albigularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Varanus' AND (species='albigularis' OR species='albigularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Varanus' AND (junior_species='albigularis' OR junior_species='albigularis')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='albigularis' OR species='albigularis') 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='Philothamnus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philothamnus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philothamnus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philothamnus' AND (junior_species='punctatus' OR junior_species='punctatus')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='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosymna' AND (junior_species='stuhlmanni' OR junior_species='stuhlmannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prosymna' AND (species='stuhlmanni' OR species='stuhlmannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prosymna' AND (species='stuhlmanni' OR species='stuhlmannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prosymna' AND (junior_species='stuhlmanni' OR junior_species='stuhlmannii')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='Prosymna' AND (species='stuhlmanni' OR species='stuhlmannii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=409 The Ecological Register: Kitobo Forest (2009)
Kitobo Forest (2009)
Basic information
Sample name: Kitobo Forest (2009)

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: 348 individuals

Years: 2009

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

Metadata
Sample number: 409

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-15 09:30:04

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

Abundance distribution
29 species
6 singletons
total count 348
extrapolated richness: 45.6
Fisher's α: 7.521
geometric series k: 0.8575
Hurlbert's PIE: 0.8956
Shannon's H: 2.6477
Good's u: 0.9828
Each square represents a species. Square sizes are proportional to counts.
Register