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=560 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=560SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=280SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=560 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='albilabris' OR junior_species='albilabris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='albilabris' OR species='albilabris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='albilabris' OR species='albilabris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='albilabris' OR junior_species='albilabris')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='Boophis' AND (species='albilabris' OR species='albilabris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='boehmei' OR junior_species='boehmeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='boehmei' OR species='boehmeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='boehmei' OR species='boehmeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='boehmei' OR junior_species='boehmeii')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='Boophis' AND (species='boehmei' OR species='boehmeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='burgeri' OR junior_species='burgerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='burgeri' OR species='burgerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='burgeri' OR species='burgerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='burgeri' OR junior_species='burgerii')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='Boophis' AND (species='burgeri' OR species='burgerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='elenae' OR junior_species='elenae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='elenae' OR species='elenae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='elenae' OR species='elenae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='elenae' OR junior_species='elenae')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='Boophis' AND (species='elenae' OR species='elenae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='liami' OR junior_species='liamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='liami' OR species='liamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='liami' OR species='liamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='liami' OR junior_species='liamii')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='Boophis' AND (species='liami' OR species='liamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='lichenoides' OR junior_species='lichenoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='lichenoides' OR species='lichenoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='lichenoides' OR species='lichenoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='lichenoides' OR junior_species='lichenoides')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='Boophis' AND (species='lichenoides' OR species='lichenoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='luteus' OR junior_species='luteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='luteus' OR species='luteus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='luteus' OR species='luteus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='luteus' OR junior_species='luteus')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='Boophis' AND (species='luteus' OR species='luteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='madagascariensis' OR species='madagascariensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='madagascariensis' OR junior_species='madagascariensis')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='Boophis' AND (species='madagascariensis' OR species='madagascariensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='marojezensis' OR junior_species='marojezensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='marojezensis' OR species='marojezensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='marojezensis' OR species='marojezensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='marojezensis' OR junior_species='marojezensis')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='Boophis' AND (species='marojezensis' OR species='marojezensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='picturatus' OR junior_species='picturatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='picturatus' OR species='picturatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='picturatus' OR species='picturatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='picturatus' OR junior_species='picturatus')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='Boophis' AND (species='picturatus' OR species='picturatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='pyrrhus' OR junior_species='pyrrhus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='pyrrhus' OR species='pyrrhus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='pyrrhus' OR species='pyrrhus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='pyrrhus' OR junior_species='pyrrhus')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='Boophis' AND (species='pyrrhus' OR species='pyrrhus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='reticulatus' OR junior_species='reticulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='reticulatus' OR species='reticulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='reticulatus' OR species='reticulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='reticulatus' OR junior_species='reticulatus')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='Boophis' AND (species='reticulatus' OR species='reticulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='rufioculis' OR junior_species='rufioculis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='rufioculis' OR species='rufioculis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='rufioculis' OR species='rufioculis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='rufioculis' OR junior_species='rufioculis')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='Boophis' AND (species='rufioculis' OR species='rufioculis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='sibilans' OR junior_species='sibilans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='sibilans' OR species='sibilans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='sibilans' OR species='sibilans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='sibilans' OR junior_species='sibilans')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='Boophis' AND (species='sibilans' OR species='sibilans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='tasymena' OR junior_species='tasymena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='tasymena' OR species='tasymena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='tasymena' OR species='tasymena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='tasymena' OR junior_species='tasymena')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='Boophis' AND (species='tasymena' OR species='tasymena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gephyromantis' 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='Gephyromantis' AND (species='asper' OR species='asper') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gephyromantis' AND (species='asper' OR species='asper')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gephyromantis' 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='Gephyromantis' AND (species='asper' OR species='asper') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guibemantis' AND (junior_species='tornieri' OR junior_species='tornierii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Guibemantis' AND (species='tornieri' OR species='tornierii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Guibemantis' AND (species='tornieri' OR species='tornierii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Guibemantis' AND (junior_species='tornieri' OR junior_species='tornierii')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='Guibemantis' AND (species='tornieri' OR species='tornierii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='aerumnalis' OR junior_species='aerumnalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='aerumnalis' OR species='aerumnalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='aerumnalis' OR species='aerumnalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='aerumnalis' OR junior_species='aerumnalis')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='Mantidactylus' AND (species='aerumnalis' OR species='aerumnalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='albofrenatus' OR junior_species='albofrenatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='albofrenatus' OR species='albofrenatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='albofrenatus' OR species='albofrenatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='albofrenatus' OR junior_species='albofrenatus')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='Mantidactylus' AND (species='albofrenatus' OR species='albofrenatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='argenteus' OR junior_species='argenteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='argenteus' OR species='argenteus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='argenteus' OR species='argenteus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='argenteus' OR junior_species='argenteus')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='Mantidactylus' AND (species='argenteus' OR species='argenteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='betsileanus' OR junior_species='betsileanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='betsileanus' OR species='betsileanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='betsileanus' OR species='betsileanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='betsileanus' OR junior_species='betsileanus')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='Mantidactylus' AND (species='betsileanus' OR species='betsileanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='femoralis' OR junior_species='femoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='femoralis' OR species='femoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='femoralis' OR species='femoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='femoralis' OR junior_species='femoralis')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='Mantidactylus' AND (species='femoralis' OR species='femoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='melanopleura' OR junior_species='melanopleura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='melanopleura' OR species='melanopleura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='melanopleura' OR species='melanopleura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='melanopleura' OR junior_species='melanopleura')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='Mantidactylus' AND (species='melanopleura' OR species='melanopleura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='mocquardi' OR junior_species='mocquardii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='mocquardi' OR species='mocquardii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='mocquardi' OR species='mocquardii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='mocquardi' OR junior_species='mocquardii')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='Mantidactylus' AND (species='mocquardi' OR species='mocquardii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='opiparis' OR junior_species='opiparis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='opiparis' OR species='opiparis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='opiparis' OR species='opiparis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='opiparis' OR junior_species='opiparis')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='Mantidactylus' AND (species='opiparis' OR species='opiparis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='tricinctus' OR junior_species='tricinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='tricinctus' OR species='tricinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='tricinctus' OR species='tricinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='tricinctus' OR junior_species='tricinctus')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='Mantidactylus' AND (species='tricinctus' OR species='tricinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='zolitschka' OR junior_species='zolitschka')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='zolitschka' OR species='zolitschka') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='zolitschka' OR species='zolitschka')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='zolitschka' OR junior_species='zolitschka')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='Mantidactylus' AND (species='zolitschka' OR species='zolitschka') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spinomantis' AND (junior_species='aglavei' OR junior_species='aglaveii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spinomantis' AND (species='aglavei' OR species='aglaveii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spinomantis' AND (species='aglavei' OR species='aglaveii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spinomantis' AND (junior_species='aglavei' OR junior_species='aglaveii')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='Spinomantis' AND (species='aglavei' OR species='aglaveii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=560<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<title>
The Ecological Register: An'Ala (tadpoles)
</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;">An'Ala (tadpoles) </div>







<div class="panelHeader">Basic information</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Sample name</b>: An'Ala (tadpoles)</div><br>



<div class="comment"><span class="field"><b>Reference:</b></span> <span class="value">M. Vences, Y. Chiari, M. Teschke, R.-D. Randrianiaina, L. Raharivololoniaina, P. Bora, D. R. Vieites,  and F. Glaw. 2008. Which frogs are out there? A preliminary evaluation of survey techniques and identification reliability of Malagasy amphibians. <i>Monografie del Museo Regionale di Scienze Naturali Amphibians of Madagascar di Torino</i> <b>45</b>:233-252 [ER 280]</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>: Madagascar</div><br>

<br>
<span class="not_comment"><span class="field">Coordinate:</span> <span class="value">-18.91926&deg; S, 48.487961&deg; E</span></span>
<br>
<div class="comment"><b>Coordinate basis</b>: stated in text</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: -37px; left: -208px; 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 moist broadleaf forest</div><br>



<div class="comment"><b>Substrate</b>: water edge</div><br>





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




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


<div class="comment"><b>Habitat comments</b>: "largely undisturbed mid-altitude rainforest"<br>
climate data are based on M&#233;nard et al. (2010, PNAS) and are for Moramanga (altitude 900 m)</div><br>

</div>

<div class="panelHeader">Methods</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Life forms</b>: frogs</div><br>






<div class="comment"><b>Sampling methods</b>: no design,hand capture</div><br>

<div class="comment"><b>Sample size</b>: 141 individuals</div><br>













</div>

<div class="panelHeader">Metadata</div>
<div class="panelHeaderRight"></div>
<div class="panel panelFloat myPanel">
<div class="comment"><b>Sample number</b>: 560</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-25 20:44:59</div><br>

<div class="comment"><b>Modified</b>: 2014-04-26 01:29: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: 118.057564994719; height: 118.057564994719; background-color: hsl(0,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 225.467338734953; top: 235.467338734953; width: 114.532661265047; height: 114.532661265047; background-color: hsl(12.8571428571429,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 0; top: 246.761654273382; width: 103.238345726618; height: 103.238345726618; background-color: hsl(25.7142857142857,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 236.761654273382; top: 10; width: 103.238345726618; height: 103.238345726618; background-color: hsl(38.5714285714286,80%,50%); opacity: 0.5;"></div><div style="position: absolute; left: 101.240665593953; top: 162.859838457262; width: 85.8994959487849; height: 85.8994959487849; background-color: hsl(51.4285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 201.601796060245; top: 67.4113824918992; width: 80.9868214478563; height: 80.9868214478563; background-color: hsl(64.2857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 80.5541926681582; top: 248.982787580029; width: 80.9868214478563; height: 80.9868214478563; background-color: hsl(77.1428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 247.383783510307; top: 111.859981814264; width: 75.7562346754284; height: 75.7562346754284; background-color: hsl(90,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 107.562628051212; top: 10; width: 70.1366447455979; height: 70.1366447455979; background-color: hsl(102.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 0.589415233203726; top: 162.4658388136; width: 70.1366447455979; height: 70.1366447455979; background-color: hsl(115.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 155.816016773926; top: 279.870688267525; width: 64.0257040581503; height: 64.0257040581503; background-color: hsl(128.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 61.9015823724255; top: 128.928918119225; width: 64.0257040581503; height: 64.0257040581503; background-color: hsl(141.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 188.324051884489; top: 19.1022772208133; width: 57.2663306325233; height: 57.2663306325233; background-color: hsl(154.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 280.606138983926; top: 170.234555952276; width: 57.2663306325233; height: 57.2663306325233; background-color: hsl(167.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 129.822603595452; top: 79.6368120796267; width: 49.5940971092841; height: 49.5940971092841; background-color: hsl(180,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 57.0631207130828; top: 206.97022495517; width: 40.4934107239281; height: 40.4934107239281; background-color: hsl(192.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 0; top: 98.3617597966031; width: 40.4934107239281; height: 40.4934107239281; background-color: hsl(205.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 159.876647319018; top: 44.0575272173195; width: 40.4934107239281; height: 40.4934107239281; background-color: hsl(218.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 239.814970978527; top: 186.905410927678; width: 40.4934107239281; height: 40.4934107239281; background-color: hsl(231.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 305.698836426992; top: 94.2594754866901; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(244.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 311.366834683738; top: 214.97144641428; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(257.142857142857,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 148.525126012804; top: 275.327431878074; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(270,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 26.3938445096028; top: 135.505424609972; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(282.857142857143,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 176.038630925736; top: 235.59442097592; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(295.714285714286,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 33.2722207378359; top: 115.638919158895; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(308.571428571429,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 0; top: 225.661168250382; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(321.428571428571,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 162.841708670935; top: 110.672292796126; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(334.285714285714,80%,50%); opacity: 0.5;"></div>
<div style="position: absolute; left: 29.9729901741355; top: 223.177855068997; width: 28.6331653162616; height: 28.6331653162616; background-color: hsl(347.142857142857,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>28 species</div>
<div>9 singletons</div>
<div>total count 141</div>
<div>extrapolated richness: 53.5</div>
<div>Fisher's &alpha;: 10.485</div>
<div>geometric series <i>k</i>: 0.9004</div>
<div>Hurlbert's PIE: 0.9327</div>
<div>Shannon's H: 2.9388</div>
<div>Good's <i>u</i>: 0.9366</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="560">
</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="560">
<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="560">
<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=Boophis&amp;species=albilabris"><i>Boophis</i> <i>albilabris</i></a></td><td class="countCell first">2</td><td class="countCell first"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Boophis&amp;species=boehmei"><i>Boophis</i> <i>boehmei</i></a></td><td class="countCell notFirst">9</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Boophis&amp;species=burgeri"><i>Boophis</i> <i>burgeri</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=Boophis&amp;species=elenae"><i>Boophis</i> <i>elenae</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=Boophis&amp;species=liami"><i>Boophis</i> <i>liami</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=Boophis&amp;species=lichenoides"><i>Boophis</i> <i>lichenoides</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=Boophis&amp;species=luteus"><i>Boophis</i> <i>luteus</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=Boophis&amp;species=madagascariensis"><i>Boophis</i> <i>madagascariensis</i></a></td><td class="countCell notFirst">5</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Boophis&amp;species=marojezensis"><i>Boophis</i> <i>marojezensis</i></a></td><td class="countCell notFirst">7</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Boophis&amp;species=picturatus"><i>Boophis</i> <i>picturatus</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=Boophis&amp;species=pyrrhus"><i>Boophis</i> <i>pyrrhus</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=Boophis&amp;species=reticulatus"><i>Boophis</i> <i>reticulatus</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=Boophis&amp;species=rufioculis"><i>Boophis</i> <i>rufioculis</i></a></td><td class="countCell notFirst">17</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Boophis&amp;species=sibilans"><i>Boophis</i> <i>sibilans</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=Boophis&amp;species=tasymena"><i>Boophis</i> <i>tasymena</i></a></td><td class="countCell notFirst">6</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Gephyromantis&amp;species=asper"><i>Gephyromantis</i> <i>asper</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=Guibemantis&amp;species=tornieri"><i>Guibemantis</i> <i>tornieri</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=Mantidactylus&amp;species=aerumnalis"><i>Mantidactylus</i> <i>aerumnalis</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=Mantidactylus&amp;species=albofrenatus"><i>Mantidactylus</i> <i>albofrenatus</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=Mantidactylus&amp;species=argenteus"><i>Mantidactylus</i> <i>argenteus</i></a></td><td class="countCell notFirst">6</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Mantidactylus&amp;species=betsileanus"><i>Mantidactylus</i> <i>betsileanus</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=Mantidactylus&amp;species=femoralis"><i>Mantidactylus</i> <i>femoralis</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=Mantidactylus&amp;species=melanopleura"><i>Mantidactylus</i> <i>melanopleura</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=Mantidactylus&amp;species=mocquardi"><i>Mantidactylus</i> aff. <i>mocquardi</i></a></td><td class="countCell notFirst">5</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Mantidactylus&amp;species=opiparis"><i>Mantidactylus</i> <i>opiparis</i></a></td><td class="countCell notFirst">16</td><td class="countCell notFirst"></td></tr>
<tr><td class="notFirst"><a href="?a=taxonPage&amp;genus=Mantidactylus&amp;species=tricinctus"><i>Mantidactylus</i> aff. <i>tricinctus</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=Mantidactylus&amp;species=zolitschka"><i>Mantidactylus</i> <i>zolitschka</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=Spinomantis&amp;species=aglavei"><i>Spinomantis</i> <i>aglavei</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>