Coordinate: 12° 34' S, 70° 6' W
climate data based on station 84658 (Puerto Maldonado)
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=446 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=446SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=215SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=446 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamptophryne' AND (junior_species='boliviana' OR junior_species='boliviana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hamptophryne' AND (species='boliviana' OR species='boliviana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hamptophryne' AND (species='boliviana' OR species='boliviana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hamptophryne' AND (junior_species='boliviana' OR junior_species='boliviana')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='Hamptophryne' AND (species='boliviana' OR species='boliviana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='reichlei' OR junior_species='reichleii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='reichlei' OR species='reichleii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='reichlei' OR species='reichleii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='reichlei' OR junior_species='reichleii')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='Pristimantis' AND (species='reichlei' OR species='reichleii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptodactylus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptodactylus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptodactylus' AND (junior_species='sp.' OR junior_species='sp.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Leptodactylus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='buccinator' OR junior_species='buccinator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='buccinator' OR species='buccinator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='buccinator' OR species='buccinator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='buccinator' OR junior_species='buccinator')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='Pristimantis' AND (species='buccinator' OR species='buccinator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allobates' AND (junior_species='conspicuus' OR junior_species='conspicuus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allobates' AND (species='conspicuus' OR species='conspicuus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allobates' AND (species='conspicuus' OR species='conspicuus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allobates' AND (junior_species='conspicuus' OR junior_species='conspicuus')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='Allobates' AND (species='conspicuus' OR species='conspicuus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='toftae' OR junior_species='toftae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='toftae' OR species='toftae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='toftae' OR species='toftae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='toftae' OR junior_species='toftae')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='Pristimantis' AND (species='toftae' OR species='toftae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='nitens' OR junior_species='nitens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anolis' AND (species='nitens' OR species='nitens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anolis' AND (species='nitens' OR species='nitens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anolis' AND (junior_species='nitens' OR junior_species='nitens')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='nitens' OR species='nitens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameerega' AND (junior_species='trivittata' OR junior_species='trivittata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameerega' AND (species='trivittata' OR species='trivittata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameerega' AND (species='trivittata' OR species='trivittata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameerega' AND (junior_species='trivittata' OR junior_species='trivittata')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='Ameerega' AND (species='trivittata' OR species='trivittata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='freibergi' OR junior_species='freibergii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Physalaemus' AND (species='freibergi' OR species='freibergii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Physalaemus' AND (species='freibergi' OR species='freibergii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Physalaemus' AND (junior_species='freibergi' OR junior_species='freibergii')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='Physalaemus' AND (species='freibergi' OR species='freibergii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrophryniscus' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrophryniscus' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrophryniscus' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrophryniscus' AND (junior_species='minutus' OR junior_species='minutus')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='Dendrophryniscus' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='cruralis' OR junior_species='cruralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='cruralis' OR species='cruralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='cruralis' OR species='cruralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='cruralis' OR junior_species='cruralis')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='Pristimantis' AND (species='cruralis' OR species='cruralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteocephalus' AND (junior_species='buckleyi' OR junior_species='buckleyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Osteocephalus' AND (species='buckleyi' OR species='buckleyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Osteocephalus' AND (species='buckleyi' OR species='buckleyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Osteocephalus' AND (junior_species='buckleyi' OR junior_species='buckleyii')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='Osteocephalus' AND (species='buckleyi' OR species='buckleyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='margaritifera' OR junior_species='margaritifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='margaritifera' OR species='margaritifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='margaritifera' OR species='margaritifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='margaritifera' OR junior_species='margaritifera')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='Rhinella' AND (species='margaritifera' OR species='margaritifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiphractus' AND (junior_species='scutatus' OR junior_species='scutatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemiphractus' AND (species='scutatus' OR species='scutatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemiphractus' AND (species='scutatus' OR species='scutatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiphractus' AND (junior_species='scutatus' OR junior_species='scutatus')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='Hemiphractus' AND (species='scutatus' OR species='scutatus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=446