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=584 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=584SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=289SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=584 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basiliscus' AND (junior_species='vittatus' OR junior_species='vittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Basiliscus' AND (species='vittatus' OR species='vittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Basiliscus' AND (species='vittatus' OR species='vittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Basiliscus' AND (junior_species='vittatus' OR junior_species='vittatus')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='Basiliscus' AND (species='vittatus' OR species='vittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coleonyx' AND (junior_species='elegans' OR junior_species='elegans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coleonyx' AND (species='elegans' OR species='elegans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coleonyx' AND (species='elegans' OR species='elegans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coleonyx' AND (junior_species='elegans' OR junior_species='elegans')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='Coleonyx' AND (species='elegans' OR species='elegans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='frenatus' OR junior_species='frenatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemidactylus' AND (species='frenatus' OR species='frenatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemidactylus' AND (species='frenatus' OR species='frenatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemidactylus' AND (junior_species='frenatus' OR junior_species='frenatus')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='frenatus' OR species='frenatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaerodactylus' AND (junior_species='glaucus' OR junior_species='glaucus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaerodactylus' AND (species='glaucus' OR species='glaucus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaerodactylus' AND (species='glaucus' OR species='glaucus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaerodactylus' AND (junior_species='glaucus' OR junior_species='glaucus')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='Sphaerodactylus' AND (species='glaucus' OR species='glaucus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thecadactylus' AND (junior_species='rapicaudus' OR junior_species='rapicaudus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thecadactylus' AND (species='rapicaudus' OR species='rapicaudus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thecadactylus' AND (species='rapicaudus' OR species='rapicaudus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thecadactylus' AND (junior_species='rapicaudus' OR junior_species='rapicaudus')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='Thecadactylus' AND (species='rapicaudus' OR species='rapicaudus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='chrysostictus' OR junior_species='chrysostictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sceloporus' AND (species='chrysostictus' OR species='chrysostictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sceloporus' AND (species='chrysostictus' OR species='chrysostictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sceloporus' AND (junior_species='chrysostictus' OR junior_species='chrysostictus')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='Sceloporus' AND (species='chrysostictus' OR species='chrysostictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='lemurinus' OR junior_species='lemurinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='lemurinus' OR species='lemurinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='lemurinus' OR species='lemurinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='lemurinus' OR junior_species='lemurinus')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='lemurinus' OR species='lemurinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='rodriguezi' OR junior_species='rodriguezii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='rodriguezi' OR species='rodriguezii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='rodriguezi' OR species='rodriguezii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='rodriguezi' OR junior_species='rodriguezii')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='rodriguezi' OR species='rodriguezii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='sericeus' OR junior_species='sericeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='sericeus' OR species='sericeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='sericeus' OR species='sericeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='sericeus' OR junior_species='sericeus')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='sericeus' OR species='sericeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='tropidonotus' OR junior_species='tropidonotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='tropidonotus' OR species='tropidonotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='tropidonotus' OR species='tropidonotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='tropidonotus' OR junior_species='tropidonotus')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='tropidonotus' OR species='tropidonotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plestiodon' AND (junior_species='schwartzei' OR junior_species='schwartzeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plestiodon' AND (species='schwartzei' OR species='schwartzeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plestiodon' AND (species='schwartzei' OR species='schwartzeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plestiodon' AND (junior_species='schwartzei' OR junior_species='schwartzeii')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='Plestiodon' AND (species='schwartzei' OR species='schwartzeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='cherriei' OR junior_species='cherrieii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scincella' AND (species='cherriei' OR species='cherrieii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scincella' AND (species='cherriei' OR species='cherrieii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scincella' AND (junior_species='cherriei' OR junior_species='cherrieii')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='Scincella' AND (species='cherriei' OR species='cherrieii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='undulata' OR junior_species='undulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameiva' AND (species='undulata' OR species='undulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameiva' AND (species='undulata' OR species='undulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameiva' AND (junior_species='undulata' OR junior_species='undulata')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='Ameiva' AND (species='undulata' OR species='undulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coniophanes' AND (junior_species='imperialis' OR junior_species='imperialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coniophanes' AND (species='imperialis' OR species='imperialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coniophanes' AND (species='imperialis' OR species='imperialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coniophanes' AND (junior_species='imperialis' OR junior_species='imperialis')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='Coniophanes' AND (species='imperialis' OR species='imperialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymarchon' AND (junior_species='melanurus' OR junior_species='melanurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymarchon' AND (species='melanurus' OR species='melanurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymarchon' AND (species='melanurus' OR species='melanurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymarchon' AND (junior_species='melanurus' OR junior_species='melanurus')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='Drymarchon' AND (species='melanurus' OR species='melanurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymobius' AND (junior_species='margaritiferus' OR junior_species='margaritiferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymobius' AND (species='margaritiferus' OR species='margaritiferus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymobius' AND (species='margaritiferus' OR species='margaritiferus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymobius' AND (junior_species='margaritiferus' OR junior_species='margaritiferus')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='Drymobius' AND (species='margaritiferus' OR species='margaritiferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficimia' AND (junior_species='publia' OR junior_species='publia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ficimia' AND (species='publia' OR species='publia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ficimia' AND (species='publia' OR species='publia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ficimia' AND (junior_species='publia' OR junior_species='publia')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='Ficimia' AND (species='publia' OR species='publia') 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='Leptophis' AND (junior_species='ahaetulla' OR junior_species='ahaetulla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptophis' AND (species='ahaetulla' OR species='ahaetulla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptophis' AND (species='ahaetulla' OR species='ahaetulla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptophis' AND (junior_species='ahaetulla' OR junior_species='ahaetulla')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='Leptophis' AND (species='ahaetulla' OR species='ahaetulla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxybelis' AND (junior_species='fulgidus' OR junior_species='fulgidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxybelis' AND (species='fulgidus' OR species='fulgidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxybelis' AND (species='fulgidus' OR species='fulgidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxybelis' AND (junior_species='fulgidus' OR junior_species='fulgidus')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='Oxybelis' AND (species='fulgidus' OR species='fulgidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseustes' AND (junior_species='poecilonotus' OR junior_species='poecilonotus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseustes' AND (species='poecilonotus' OR species='poecilonotus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseustes' AND (species='poecilonotus' OR species='poecilonotus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseustes' AND (junior_species='poecilonotus' OR junior_species='poecilonotus')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='Pseustes' AND (species='poecilonotus' OR species='poecilonotus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilotes' AND (junior_species='pullatus' OR junior_species='pullatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilotes' AND (species='pullatus' OR species='pullatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilotes' AND (species='pullatus' OR species='pullatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilotes' AND (junior_species='pullatus' OR junior_species='pullatus')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='Spilotes' AND (species='pullatus' OR species='pullatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='schistosa' OR junior_species='schistosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tantilla' AND (species='schistosa' OR species='schistosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tantilla' AND (species='schistosa' OR species='schistosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tantilla' AND (junior_species='schistosa' OR junior_species='schistosa')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='Tantilla' AND (species='schistosa' OR species='schistosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='asper' OR junior_species='asper')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bothrops' AND (species='asper' OR species='asper') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bothrops' AND (species='asper' OR species='asper')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bothrops' AND (junior_species='asper' OR junior_species='asper')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='Bothrops' AND (species='asper' OR species='asper') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='tzabcan' OR junior_species='tzabcan')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crotalus' AND (species='tzabcan' OR species='tzabcan') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='tzabcan' OR species='tzabcan')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' AND (junior_species='tzabcan' OR junior_species='tzabcan')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='Crotalus' AND (species='tzabcan' OR species='tzabcan') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinoclemmys' AND (junior_species='areolata' OR junior_species='areolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinoclemmys' AND (species='areolata' OR species='areolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinoclemmys' AND (species='areolata' OR species='areolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinoclemmys' AND (junior_species='areolata' OR junior_species='areolata')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='Rhinoclemmys' AND (species='areolata' OR species='areolata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=584<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>
The Ecological Register: Caobas Ejido (mature forest)
</title>

<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">

<link rel="stylesheet" type="text/css" href="/html/eco.css">
<link rel="icon" href="/html/huntsman-ico.tiff" type="image/x-icon">
<link rel="shortcut icon" href="/html/huntsman-ico.tiff" type="image/x-icon">

<meta name="keywords" content="ecology, biodiversity, species diversity, abundance distributions, database">
<meta name="description" content="">

</head>

<body>

<div id="banner">

<div style="position: relative; top: 4px; left: 4px;">
<a class="bannerLink" href="?page=home" style="color: White;">
<img alt="huntsman spider" src="/images/huntsman.jpg" height="50" style="border: 0;">
</a>
</div>

<div style="position: relative; top: -38px; margin-left: 60px; margin-bottom: -82px; font-family: Palatino, Garamond, serif; font-size: 2.5em; color: FireBrick;">
<a class="bannerLink" href="?page=home">
<span class="bannerLink">
<img src="/images/SlabTallX_logo.png" style="height: 44px; margin-top: -4px; border: 0;">
</span>
</a>
</div>

<div style="position: relative; overflow: hidden; height: 58px; width: 28em; top: -8px; margin-left: 32em;">

</div>

</div>

<div id="navBar">

<div class="navBarLink">
  <a href="/?a=sampleSearch">Samples</a>
</div>
<div class="navBarLink">
  <a href="/?a=taxonSearch">Species</a>
</div>
<div class="navBarLink">
  <a href="/?page=search_refs">References</a>
</div>
<div class="navBarLink bannerLink">
<form method="POST" action="" onSubmit="return checkName(0,2);">
<input type="hidden" name="a" value="quickSearch">
<input type="text" id="quick_search" name="quick_search" value="Quick search" onFocus="document.getElementById('quick_search').value ='';" onBlur="document.getElementById('quick_search').value ='Quick search';" style="position: relative; width: 7em; padding-left: 0.2em; font-family: Palatino, Garamond, serif; font-size: 1em; background: White; color: FireBrick; border: 0px; margin: 0em; padding: 0em;">
</form>
</div>
<div class="navBarLink">
<a href="?a=downloadForm">Download</a>
</div>
<div class="navBarLink">
<a href="?a=sampleSearch&amp;goal=compare">Compare</a>
</div>
<div class="navBarLink">
<a href="?a=cluster&amp;life_form=bats&amp;clusters=3&amp;level=both">Biogeography</a>
</div>
<div class="navBarLink">
<a href="?page=FAQ">FAQ</a>
</div>
<div class="navBarLink">
<a class="bannerLink" href="/?a=loginForm">Log in</a>
</div>

</div>



<div id="mainPanel">

<style>
<!--
.myPanel	{
	width: 95%;
}
.not_comment	{
	float: left;
	clear: none;
	white-space: nowrap;
}
.comment	{
	float: left;
	clear: left;
	margin-left: 1em;
	text-indent: -1em;
	line-height: 1em;
}
.field	{
	margin-right: 0.2em;
}
.value	{
	margin-right: 1.5em;
	padding-left: 0.25em;
}
.first	{
	padding-top: 0.5em;
	padding-bottom: 0.5em;
}
.notFirst	{
	padding-top: 0.5em;
	padding-bottom: 0.5em;
	border-top: 1px solid LightGray;
}
.countCell	{
	padding-left: 3em;
}
.commentCell	{
	padding-left: 1em;
	padding-bottom: 1em;
	line-height: 0.5em;
}

-->
</style>

<div class="panel" style="width: 93%; margin-top: 1em; line-height: 1.5em;">

<div class="title" style="text-align: center; margin-top: 0.5em;">Caobas Ejido (mature forest) </div>







<div class="panelHeader">Basic information</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Sample name</b>: Caobas Ejido (mature forest)</div><br>



<div class="comment"><span class="field"><b>Reference:</b></span> <span class="value">V. H. Luja, S. Herrando-Pérez, D. González-Solís,  and L. Luiselli. 2008. Secondary rain forests are not havens for reptile species in tropical Mexico. <i>Biotropica</i> <b>40</b>(6):747-757 [ER 289]</span></div>

</div>

<div class="panelHeader">Geography</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div style="float: left; clear: none; width: 50%;">
<div class="comment"><b>Country</b>: Mexico</div><br>

<div class="comment"><b>State</b>: Quintana Roo</div><br>
<br>
<span class="not_comment"><span class="field">Coordinate:</span> <span class="value">18&deg; 26' 39" N, 89&deg; 6' 15" W</span></span>
<br>
<div class="comment"><b>Coordinate basis</b>: stated in text</div><br>












<div class="comment"><b>Geography comments</b>: "in the municipality of Othon P. Blanco"</div><br>

</div>

<div style="position: relative; float: left; clear: right; margin-left: 2em; height: 180px; width: 270px; overflow: hidden;">
<img src="images/large_world_map.png" style="position: absolute; bottom: -141px; left: -1px; height: 360px;">
<div style="position: absolute; bottom: 80px; left: 125px;"><span style="font-size: 30px; color: DodgerBlue;">&bull;</span></div>
</div>

</div>

<div class="panelHeader">Environment</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Habitat</b>: tropical/subtropical dry broadleaf forest</div><br>



<div class="comment"><b>Substrate</b>: ground surface</div><br>





<div class="comment"><b>MAT</b>: 26.0</div><br>




<div class="comment"><b>MAP</b>: 1200.0</div><br>


<div class="comment"><b>Habitat comments</b>: "medium- saturated semievergreen forest"</div><br>

</div>

<div class="panelHeader">Methods</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Life forms</b>: lizards,snakes,turtles</div><br>


<div class="comment"><b>Sites</b>: 36</div><br>

<div class="comment"><b>Site area</b>: 16.2</div><br>



<div class="comment"><b>Sampling methods</b>: belt transect,visual</div><br>

<div class="comment"><b>Sample size</b>: 338 captures or sightings</div><br>


<div class="comment"><b>Years</b>: 2004</div><br>










<div class="comment"><b>Sampling comments</b>: 36 500 x 9 m transects<br>
apparently all visual sightings and few or no hand captures</div><br>

</div>

<div class="panelHeader">Metadata</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Sample number</b>: 584</div><br>

<div class="comment"><b>Contributor</b>: John Alroy</div><br>

<div class="comment"><b>Enterer</b>: John Alroy</div><br>


<div class="comment"><b>Created</b>: 2014-03-26 20:22:51</div><br>

<div class="comment"><b>Modified</b>: 2014-03-26 09:22:51</div><br>

</div>

<div style="float: left; clear: none; display: block;">
<div class="panelHeader">Abundance distribution</div>
<div class="panelHeaderRight"></div>

<div class="panel panelFloat myPanel" style="height: 360px;">
<div style="position: absolute; float: left; clear: none; margin-top: 10px; width: 300px;">
<div style="position: absolute; left: 0; top: 10; width: 221.922743633932; height: 221.922743633932; background-color: hsl(0,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 179.841055279561; top: 189.841055279561; width: 160.158944720439; height: 160.158944720439; background-color: hsl(13.3333333333333,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 0; top: 255.700966641711; width: 94.299033358289; height: 94.299033358289; background-color: hsl(26.6666666666667,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 255.251852405436; top: 10; width: 84.7481475945643; height: 84.7481475945643; background-color: hsl(40,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 109.58219387059; top: 236.362749218551; width: 78.4615384615385; height: 78.4615384615385; background-color: hsl(53.3333333333333,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 258.863497801848; top: 109.457016251169; width: 66.6794859469826; height: 66.6794859469826; background-color: hsl(66.6666666666667,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 46.8969640399888; top: 220.244533458484; width: 52.3076923076923; height: 52.3076923076923; background-color: hsl(80,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 188.031843127423; top: 50.6060329335882; width: 36.9871239389886; height: 36.9871239389886; background-color: hsl(93.3333333333333,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 87.2468080764149; top: 263.759004253727; width: 32.0317889440877; height: 32.0317889440877; background-color: hsl(106.666666666667,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 205.615456802186; top: 128.871554890841; width: 32.0317889440877; height: 32.0317889440877; background-color: hsl(120,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 97.7387525601916; top: 234.36680160452; width: 26.1538461538462; height: 26.1538461538462; background-color: hsl(133.333333333333,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 212.330914741634; top: 115.644939263798; width: 26.1538461538462; height: 26.1538461538462; background-color: hsl(146.666666666667,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 99.6269958323556; top: 281.603542508257; width: 26.1538461538462; height: 26.1538461538462; background-color: hsl(160,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 213.275036377716; top: 68.093193319372; width: 26.1538461538462; height: 26.1538461538462; background-color: hsl(173.333333333333,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 43.5110667867368; top: 202.508135121224; width: 26.1538461538462; height: 26.1538461538462; background-color: hsl(186.666666666667,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 256.070074388992; top: 99.7156060221507; width: 26.1538461538462; height: 26.1538461538462; background-color: hsl(200,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 125.32671774821; top: 222.14948356479; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(213.333333333333,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 228.039968381732; top: 56.1022851526371; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(226.666666666667,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 305.074906356873; top: 198.427752083945; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(240,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 321.506438030506; top: 99.5904855495989; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(253.333333333333,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 156.129828522879; top: 220.171852282426; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(266.666666666667,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 243.441523769066; top: 110.462535648839; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(280,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 117.097371392159; top: 225.607877332046; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(293.333333333333,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 22.3392571094795; top: 56.9668835944512; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(306.666666666667,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 0; top: 14.8066351600524; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(320,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 248.06491426144; top: 10; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(333.333333333333,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 310.0811428268; top: 175.376609507626; width: 18.4935619694943; height: 18.4935619694943; background-color: hsl(346.666666666667,80%,50%); opacity: 0.5;"></div>

</div>
<div style="float: left; clear: none; margin-top: 20px; margin-left: 300px; width: 20em; padding-left: 6em;">
<div>
<div>27 species</div>
<div>11 singletons</div>
<div>total count 338</div>
<div>extrapolated richness: 62.2</div>
<div>Fisher's &alpha;: 6.903</div>
<div>geometric series <i>k</i>: 0.8260</div>
<div>Hurlbert's PIE: 0.7533</div>
<div>Shannon's H: 1.9456</div>
<div>Good's <i>u</i>: 0.9676</div>
</div>
</div>

</div>

<div style="float: left; clear: both; padding-left: 1em; font-size: 0.9em;">
<i>Each square represents a species. Square sizes are proportional to counts.</i>
</div>

<div style="float: left; clear: both; padding-left: 2em; margin-bottom: 2em;">

<form method="POST" action="">
<input type="hidden" name="a" value="showMatches">
<input type="hidden" name="sample_no" value="584">
</form>
<div class="mockLink" style="float: left; clear: left;" onClick="document.forms[1].submit();">&bull; Find matching samples</div>


<form method="POST" action="">
<input type="hidden" name="a" value="mapMatches">
<input type="hidden" name="sample_no" value="584">
<div class="mockLink" style="float: left; clear: right;" onClick="document.forms[2].submit();">&bull; Map matching samples</div>
</form>


<form method="POST" action="">
<input type="hidden" name="a" value="statsPage">
<input type="hidden" name="sample" value="584">
<div class="mockLink" style="float: left; clear: none;" onClick="document.forms[3].submit();">&bull; Extrapolate richness estimates</div>
</form>
</div>

</div>

<div class="panelHeader">Register</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<table style="border-collapse: collapse; font-size: 0.95em;">
<tr><td class="first"><a href="?a=taxonPage&amp;genus=Basiliscus&amp;species=vittatus"><i>Basiliscus</i> <i>vittatus</i></a></td><td class="countCell first">26</td><td class="countCell first"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Coleonyx&amp;species=elegans"><i>Coleonyx</i> <i>elegans</i></a></td><td class="countCell notFirst">3</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Hemidactylus&amp;species=frenatus"><i>Hemidactylus</i> <i>frenatus</i></a></td><td class="countCell notFirst">3</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Sphaerodactylus&amp;species=glaucus"><i>Sphaerodactylus</i> <i>glaucus</i></a></td><td class="countCell notFirst">4</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Thecadactylus&amp;species=rapicaudus"><i>Thecadactylus</i> <i>rapicaudus</i></a></td><td class="countCell notFirst">8</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Sceloporus&amp;species=chrysostictus"><i>Sceloporus</i> <i>chrysostictus</i></a></td><td class="countCell notFirst">18</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Anolis&amp;species=lemurinus"><i>Anolis</i> <i>lemurinus</i></a></td><td class="countCell notFirst">21</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Anolis&amp;species=rodriguezi"><i>Anolis</i> <i>rodriguezi</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Anolis&amp;species=sericeus"><i>Anolis</i> <i>sericeus</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Anolis&amp;species=tropidonotus"><i>Anolis</i> <i>tropidonotus</i></a></td><td class="countCell notFirst">144</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Plestiodon&amp;species=schwartzei"><i>Plestiodon</i> <i>schwartzei</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Scincella&amp;species=cherriei"><i>Scincella</i> <i>cherriei</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Ameiva&amp;species=undulata"><i>Ameiva</i> <i>undulata</i></a></td><td class="countCell notFirst">75</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Coniophanes&amp;species=imperialis"><i>Coniophanes</i> <i>imperialis</i></a></td><td class="countCell notFirst">13</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Drymarchon&amp;species=melanurus"><i>Drymarchon</i> <i>melanurus</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Drymobius&amp;species=margaritiferus"><i>Drymobius</i> <i>margaritiferus</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Ficimia&amp;species=publia"><i>Ficimia</i> <i>publia</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Imantodes&amp;species=cenchoa"><i>Imantodes</i> <i>cenchoa</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Leptodeira&amp;species=septentrionalis"><i>Leptodeira</i> <i>septentrionalis</i></a></td><td class="countCell notFirst">2</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Leptophis&amp;species=ahaetulla"><i>Leptophis</i> <i>ahaetulla</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Oxybelis&amp;species=fulgidus"><i>Oxybelis</i> <i>fulgidus</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Pseustes&amp;species=poecilonotus"><i>Pseustes</i> <i>poecilonotus</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Spilotes&amp;species=pullatus"><i>Spilotes</i> <i>pullatus</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Tantilla&amp;species=schistosa"><i>Tantilla</i> <i>schistosa</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Bothrops&amp;species=asper"><i>Bothrops</i> <i>asper</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Crotalus&amp;species=tzabcan"><i>Crotalus</i> <i>tzabcan</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Rhinoclemmys&amp;species=areolata"><i>Rhinoclemmys</i> <i>areolata</i></a></td><td class="countCell notFirst">1</td><td class="countCell notFirst"></td></tr>

</table>
</div>

</div>

<div style="clear: both; margin-left: auto; margin-right: auto; width: 100%; padding-top: 0.5em; padding-bottom: 0.5em; border-top: 1px solid WhiteSmoke; text-align: center; font-size: 1.2em;">


</div>

</div>

</body>
</html>