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=412 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=412SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=194SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=412 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centrolene' AND (junior_species='prosoblepon' OR junior_species='prosoblepon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Centrolene' AND (species='prosoblepon' OR species='prosoblepon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Centrolene' AND (species='prosoblepon' OR species='prosoblepon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Centrolene' AND (junior_species='prosoblepon' OR junior_species='prosoblepon')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='Centrolene' AND (species='prosoblepon' OR species='prosoblepon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyalinobatrachium' AND (junior_species='vireovittatum' OR junior_species='vireovittatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyalinobatrachium' AND (species='vireovittatum' OR species='vireovittatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyalinobatrachium' AND (species='vireovittatum' OR species='vireovittatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyalinobatrachium' AND (junior_species='vireovittatum' OR junior_species='vireovittatum')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='Hyalinobatrachium' AND (species='vireovittatum' OR species='vireovittatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colostethus' AND (junior_species='nubicola' OR junior_species='nubicola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colostethus' AND (species='nubicola' OR species='nubicola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colostethus' AND (species='nubicola' OR species='nubicola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colostethus' AND (junior_species='nubicola' OR junior_species='nubicola')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='Colostethus' AND (species='nubicola' OR species='nubicola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobates' AND (junior_species='speciosus' OR junior_species='speciosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrobates' AND (species='speciosus' OR species='speciosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrobates' AND (species='speciosus' OR species='speciosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrobates' AND (junior_species='speciosus' OR junior_species='speciosus')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='Dendrobates' AND (species='speciosus' OR species='speciosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agalychnis' AND (junior_species='spurrelli' OR junior_species='spurrellii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agalychnis' AND (species='spurrelli' OR species='spurrellii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agalychnis' AND (species='spurrelli' OR species='spurrellii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agalychnis' AND (junior_species='spurrelli' OR junior_species='spurrellii')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='Agalychnis' AND (species='spurrelli' OR species='spurrellii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='debilis' OR junior_species='debilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyla' AND (species='debilis' OR species='debilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyla' AND (species='debilis' OR species='debilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='debilis' OR junior_species='debilis')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='Hyla' AND (species='debilis' OR species='debilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='lancasteri' OR junior_species='lancasterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyla' AND (species='lancasteri' OR species='lancasterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyla' AND (species='lancasteri' OR species='lancasterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='lancasteri' OR junior_species='lancasterii')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='Hyla' AND (species='lancasteri' OR species='lancasterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='picadoi' OR junior_species='picadoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyla' AND (species='picadoi' OR species='picadoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyla' AND (species='picadoi' OR species='picadoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyla' AND (junior_species='picadoi' OR junior_species='picadoii')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='Hyla' AND (species='picadoi' OR species='picadoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='bransfordii' OR junior_species='bransfordi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='bransfordii' OR species='bransfordi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='bransfordii' OR species='bransfordi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='bransfordii' OR junior_species='bransfordi')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='Eleutherodactylus' AND (species='bransfordii' OR species='bransfordi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='caryophyllaceus' OR junior_species='caryophyllaceus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='caryophyllaceus' OR species='caryophyllaceus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='caryophyllaceus' OR species='caryophyllaceus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='caryophyllaceus' OR junior_species='caryophyllaceus')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='Eleutherodactylus' AND (species='caryophyllaceus' OR species='caryophyllaceus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='crassidigitus' OR junior_species='crassidigitus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='crassidigitus' OR species='crassidigitus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='crassidigitus' OR species='crassidigitus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='crassidigitus' OR junior_species='crassidigitus')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='Eleutherodactylus' AND (species='crassidigitus' OR species='crassidigitus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='cruentus' OR junior_species='cruentus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='cruentus' OR species='cruentus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='cruentus' OR species='cruentus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='cruentus' OR junior_species='cruentus')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='Eleutherodactylus' AND (species='cruentus' OR species='cruentus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='diastema' OR junior_species='diastema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='diastema' OR species='diastema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='diastema' OR species='diastema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='diastema' OR junior_species='diastema')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='Eleutherodactylus' AND (species='diastema' OR species='diastema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='emcelae' OR junior_species='emcelae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='emcelae' OR species='emcelae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='emcelae' OR species='emcelae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='emcelae' OR junior_species='emcelae')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='Eleutherodactylus' AND (species='emcelae' OR species='emcelae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='fitzingeri' OR junior_species='fitzingerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='fitzingeri' OR species='fitzingerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='fitzingeri' OR species='fitzingerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='fitzingeri' OR junior_species='fitzingerii')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='Eleutherodactylus' AND (species='fitzingeri' OR species='fitzingerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='melanosticus' OR junior_species='melanosticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='melanosticus' OR species='melanosticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='melanosticus' OR species='melanosticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='melanosticus' OR junior_species='melanosticus')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='Eleutherodactylus' AND (species='melanosticus' OR species='melanosticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='museosus' OR junior_species='museosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='museosus' OR species='museosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='museosus' OR species='museosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='museosus' OR junior_species='museosus')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='Eleutherodactylus' AND (species='museosus' OR species='museosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='pardalis' OR junior_species='pardalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='pardalis' OR species='pardalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='pardalis' OR species='pardalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='pardalis' OR junior_species='pardalis')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='Eleutherodactylus' AND (species='pardalis' OR species='pardalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='podiciferus' OR junior_species='podiciferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='podiciferus' OR species='podiciferus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='podiciferus' OR species='podiciferus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='podiciferus' OR junior_species='podiciferus')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='Eleutherodactylus' AND (species='podiciferus' OR species='podiciferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='ridens' OR junior_species='ridens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eleutherodactylus' AND (species='ridens' OR species='ridens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='ridens' OR species='ridens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' AND (junior_species='ridens' OR junior_species='ridens')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='Eleutherodactylus' AND (species='ridens' OR species='ridens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' 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='Eleutherodactylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eleutherodactylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eleutherodactylus' 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='Eleutherodactylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidoblepharis' AND (junior_species='xanthostigma' OR junior_species='xanthostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepidoblepharis' AND (species='xanthostigma' OR species='xanthostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepidoblepharis' AND (species='xanthostigma' OR species='xanthostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepidoblepharis' AND (junior_species='xanthostigma' OR junior_species='xanthostigma')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='Lepidoblepharis' AND (species='xanthostigma' OR species='xanthostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychoglossus' AND (junior_species='plicatus' OR junior_species='plicatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptychoglossus' AND (species='plicatus' OR species='plicatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptychoglossus' AND (species='plicatus' OR species='plicatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptychoglossus' AND (junior_species='plicatus' OR junior_species='plicatus')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='Ptychoglossus' AND (species='plicatus' OR species='plicatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='aquaticus' OR junior_species='aquaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='aquaticus' OR species='aquaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='aquaticus' OR species='aquaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='aquaticus' OR junior_species='aquaticus')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='Anolis' AND (species='aquaticus' OR species='aquaticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='biporcatus' OR junior_species='biporcatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='biporcatus' OR species='biporcatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='biporcatus' OR species='biporcatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='biporcatus' OR junior_species='biporcatus')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='Anolis' AND (species='biporcatus' OR species='biporcatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='casildae' OR junior_species='casildae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='casildae' OR species='casildae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='casildae' OR species='casildae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='casildae' OR junior_species='casildae')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='Anolis' AND (species='casildae' OR species='casildae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='exsul' OR junior_species='exsul')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='exsul' OR species='exsul') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='exsul' OR species='exsul')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='exsul' OR junior_species='exsul')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='Anolis' AND (species='exsul' OR species='exsul') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='humilis' OR junior_species='humilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='humilis' OR species='humilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='humilis' OR species='humilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='humilis' OR junior_species='humilis')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='Anolis' AND (species='humilis' OR species='humilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='limifrons' OR junior_species='limifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='limifrons' OR species='limifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='limifrons' OR species='limifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='limifrons' OR junior_species='limifrons')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='Anolis' AND (species='limifrons' OR species='limifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='pachypus' OR junior_species='pachypus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='pachypus' OR species='pachypus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='pachypus' OR species='pachypus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='pachypus' OR junior_species='pachypus')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='Anolis' AND (species='pachypus' OR species='pachypus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' 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='Anolis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' 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='Anolis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' 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='Anolis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' 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='Anolis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amastridium' AND (junior_species='veliferum' OR junior_species='veliferum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amastridium' AND (species='veliferum' OR species='veliferum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amastridium' AND (species='veliferum' OR species='veliferum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amastridium' AND (junior_species='veliferum' OR junior_species='veliferum')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='Amastridium' AND (species='veliferum' OR species='veliferum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironius' AND (junior_species='grandisquamis' OR junior_species='grandisquamis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chironius' AND (species='grandisquamis' OR species='grandisquamis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chironius' AND (species='grandisquamis' OR species='grandisquamis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chironius' AND (junior_species='grandisquamis' OR junior_species='grandisquamis')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='Chironius' AND (species='grandisquamis' OR species='grandisquamis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colubridae' 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='Colubridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colubridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colubridae' 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='Colubridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geophis' AND (junior_species='brachycephalus' OR junior_species='brachycephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geophis' AND (species='brachycephalus' OR species='brachycephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geophis' AND (species='brachycephalus' OR species='brachycephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geophis' AND (junior_species='brachycephalus' OR junior_species='brachycephalus')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='Geophis' AND (species='brachycephalus' OR species='brachycephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Imantodes' AND (junior_species='cenchoa' OR junior_species='cenchoa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Imantodes' AND (species='cenchoa' OR species='cenchoa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Imantodes' AND (species='cenchoa' OR species='cenchoa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Imantodes' AND (junior_species='cenchoa' OR junior_species='cenchoa')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='Imantodes' AND (species='cenchoa' OR species='cenchoa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='septentrionalis' OR junior_species='septentrionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodeira' AND (species='septentrionalis' OR species='septentrionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodeira' AND (species='septentrionalis' OR species='septentrionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodeira' AND (junior_species='septentrionalis' OR junior_species='septentrionalis')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='Leptodeira' AND (species='septentrionalis' OR species='septentrionalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='epinephalus' OR junior_species='epinephalus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Liophis' AND (species='epinephalus' OR species='epinephalus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Liophis' AND (species='epinephalus' OR species='epinephalus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Liophis' AND (junior_species='epinephalus' OR junior_species='epinephalus')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='Liophis' AND (species='epinephalus' OR species='epinephalus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='argus' OR junior_species='argus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sibon' AND (species='argus' OR species='argus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sibon' AND (species='argus' OR species='argus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='argus' OR junior_species='argus')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='Sibon' AND (species='argus' OR species='argus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='dimidiatus' OR junior_species='dimidiatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sibon' AND (species='dimidiatus' OR species='dimidiatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sibon' AND (species='dimidiatus' OR species='dimidiatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='dimidiatus' OR junior_species='dimidiatus')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='Sibon' AND (species='dimidiatus' OR species='dimidiatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='nebulatus' OR junior_species='nebulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sibon' AND (species='nebulatus' OR species='nebulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sibon' AND (species='nebulatus' OR species='nebulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sibon' AND (junior_species='nebulatus' OR junior_species='nebulatus')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='Sibon' AND (species='nebulatus' OR species='nebulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urotheca' AND (junior_species='decipiens' OR junior_species='decipiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urotheca' AND (species='decipiens' OR species='decipiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urotheca' AND (species='decipiens' OR species='decipiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urotheca' AND (junior_species='decipiens' OR junior_species='decipiens')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='Urotheca' AND (species='decipiens' OR species='decipiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachesis' AND (junior_species='stenophrys' OR junior_species='stenophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lachesis' AND (species='stenophrys' OR species='stenophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lachesis' AND (species='stenophrys' OR species='stenophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lachesis' AND (junior_species='stenophrys' OR junior_species='stenophrys')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='Lachesis' AND (species='stenophrys' OR species='stenophrys') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=412 The Ecological Register: Bosque Protector Palo Seco
Bosque Protector Palo Seco
Basic information
Sample name: Bosque Protector Palo Seco

Reference: U. Hofer and L.-F. Bersier. 2001. Herpetofaunal diversity and abundance in tropical upland forests of Cameroon and Panama. Biotropica 33(1):142-152 [ER 194]
Geography
Country: Panama

State: Bocas del Toro


Coordinate: 9.36° N, -78.80° W
Geography comments: "between 800 and 1600 m elevation"
coordinate based on San Blas Islands and Bayano Lake; latitude reported in text (8 47) is certainly wrong

•
Environment
Habitat: tropical/subtropical moist broadleaf forest

Substrate: ground surface

MAT: 20.6

MAP: 3000.0

Habitat comments: "primary forest"
climate data based on Lotzkat et al. (2012, Zootaxa); precip at least 3000 mm according to text and "approx. 3000 mm" according to

Methods
Life forms: lizards,snakes,frogs

Site length: 2610

Sampling methods: line transect,hand capture

Sample size: 237 individuals

Years: 1998

Sampling comments: transects were 430, 1360, and 820 m long
caecilians and plethodontids are intentionally omitted from the counts by the authors

Metadata
Sample number: 412

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-03-15 17:11:29

Modified: 2014-04-27 03:08:05

Abundance distribution
44 species
16 singletons
total count 237
extrapolated richness: 94.9
Fisher's α: 15.905
geometric series k: 0.9158
Hurlbert's PIE: 0.9228
Shannon's H: 3.0693
Good's u: 0.9327
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Centrolene prosoblepon3
Hyalinobatrachium vireovittatum3
Colostethus nubicola1
Dendrobates speciosus2
Agalychnis spurrelli3
Hyla debilis1
Hyla lancasteri1
Hyla picadoi1
Eleutherodactylus bransfordii4
Eleutherodactylus caryophyllaceus27
Eleutherodactylus crassidigitus2
Eleutherodactylus cruentus11
Eleutherodactylus diastema4
Eleutherodactylus emcelae1
Eleutherodactylus fitzingeri1
Eleutherodactylus melanosticus1
Eleutherodactylus museosus1
Eleutherodactylus pardalis6
Eleutherodactylus podiciferus3
Eleutherodactylus ridens1
Eleutherodactylus sp.5
Lepidoblepharis xanthostigma4
Ptychoglossus plicatus4
Anolis aquaticus13
Anolis biporcatus5
Anolis casildae3
Anolis exsul2
Anolis humilis44
Anolis limifrons9
Anolis pachypus25
Anolis sp. A1
Anolis sp. B1
Amastridium veliferum1
Chironius grandisquamis2
Colubridae indet.2
Geophis brachycephalus1
Imantodes cenchoa11
Leptodeira septentrionalis2
Liophis epinephalus1
Sibon argus3
Sibon dimidiatus17
Sibon nebulatus2
Urotheca decipiens1
Lachesis stenophrys1