Coordinate: 13° 6' 12" S, 71° 34' 14" W
climate data based on station 84686 (Cusco)
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=327 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=327SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=150SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=327 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyalinobatrachium' AND (junior_species='bergeri' OR junior_species='bergerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyalinobatrachium' AND (species='bergeri' OR species='bergerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyalinobatrachium' AND (species='bergeri' OR species='bergerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyalinobatrachium' AND (junior_species='bergeri' OR junior_species='bergerii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hyalinobatrachium' AND (species='bergeri' OR species='bergerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrotheca' AND (junior_species='ochoai' OR junior_species='ochoaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gastrotheca' AND (species='ochoai' OR species='ochoaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gastrotheca' AND (species='ochoai' OR species='ochoaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrotheca' AND (junior_species='ochoai' OR junior_species='ochoaii')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='Gastrotheca' AND (species='ochoai' OR species='ochoaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrotheca' AND (junior_species='excubitor' OR junior_species='excubitor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gastrotheca' AND (species='excubitor' OR species='excubitor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gastrotheca' AND (species='excubitor' OR species='excubitor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gastrotheca' AND (junior_species='excubitor' OR junior_species='excubitor')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='Gastrotheca' AND (species='excubitor' OR species='excubitor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bryophryne' AND (junior_species='cophites' OR junior_species='cophites')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bryophryne' AND (species='cophites' OR species='cophites') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bryophryne' AND (species='cophites' OR species='cophites')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bryophryne' AND (junior_species='cophites' OR junior_species='cophites')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='Bryophryne' AND (species='cophites' OR species='cophites') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='balzani' OR junior_species='balzanii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsiboas' AND (species='balzani' OR species='balzanii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsiboas' AND (species='balzani' OR species='balzanii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsiboas' AND (junior_species='balzani' OR junior_species='balzanii')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='Hypsiboas' AND (species='balzani' OR species='balzanii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noblella' 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='Noblella' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noblella' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noblella' 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='Noblella' 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='danae' OR junior_species='danae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='danae' OR species='danae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='danae' OR species='danae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='danae' OR junior_species='danae')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='danae' OR species='danae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='pharangobates' OR junior_species='pharangobates')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='pharangobates' OR species='pharangobates') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='pharangobates' OR species='pharangobates')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='pharangobates' OR junior_species='pharangobates')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='pharangobates' OR species='pharangobates') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='platydactylus' OR junior_species='platydactylus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='platydactylus' OR species='platydactylus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='platydactylus' OR species='platydactylus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='platydactylus' OR junior_species='platydactylus')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='platydactylus' OR species='platydactylus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='salaputium' OR junior_species='salaputium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pristimantis' AND (species='salaputium' OR species='salaputium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='salaputium' OR species='salaputium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' AND (junior_species='salaputium' OR junior_species='salaputium')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='salaputium' OR species='salaputium') 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='Pristimantis' 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='Pristimantis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pristimantis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pristimantis' 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='Pristimantis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychrophrynella' AND (junior_species='usurpator' OR junior_species='usurpator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Psychrophrynella' AND (species='usurpator' OR species='usurpator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psychrophrynella' AND (species='usurpator' OR species='usurpator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychrophrynella' AND (junior_species='usurpator' OR junior_species='usurpator')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='Psychrophrynella' AND (species='usurpator' OR species='usurpator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychrophrynella' 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='Psychrophrynella' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Psychrophrynella' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Psychrophrynella' 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='Psychrophrynella' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='inca' OR junior_species='inca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinella' AND (species='inca' OR species='inca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinella' AND (species='inca' OR species='inca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinella' AND (junior_species='inca' OR junior_species='inca')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='inca' OR species='inca') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=327