Coordinate: 21° 14' 32" S, 47° 27' 55" E
climate data are based on Ménard et al. (2010, PNAS) and are for Farafangana
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=556 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=556SELECT 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=556 ORDER BY register_no ASCSELECT 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='goudoti' OR junior_species='goudotii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='goudoti' OR species='goudotii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='goudoti' OR species='goudotii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='goudoti' OR junior_species='goudotii')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='goudoti' OR species='goudotii') 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='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='majori' OR junior_species='majorii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boophis' AND (species='majori' OR species='majorii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boophis' AND (species='majori' OR species='majorii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boophis' AND (junior_species='majori' OR junior_species='majorii')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='majori' OR species='majorii') 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='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='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='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='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='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='lugubris' OR junior_species='lugubris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='lugubris' OR species='lugubris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='lugubris' OR species='lugubris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='lugubris' OR junior_species='lugubris')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='lugubris' OR species='lugubris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='majori' OR junior_species='majorii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mantidactylus' AND (species='majori' OR species='majorii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mantidactylus' AND (species='majori' OR species='majorii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mantidactylus' AND (junior_species='majori' OR junior_species='majorii')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='majori' OR species='majorii') 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 * FROM register WHERE sample_no=556