Coordinate: 17° 13' 30" N, 101° 18' 30" E
MAP stated in text; CMT and WMT based on station 48378 (Nai Mueang), which is almost at the same altitude and has almost the same MAP
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=364 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=364SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=163SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=364 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptolalax' AND (junior_species='pelodytoides' OR junior_species='pelodytoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptolalax' AND (species='pelodytoides' OR species='pelodytoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptolalax' AND (species='pelodytoides' OR species='pelodytoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptolalax' AND (junior_species='pelodytoides' OR junior_species='pelodytoides')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='Leptolalax' AND (species='pelodytoides' OR species='pelodytoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenophrys' AND (junior_species='major' OR junior_species='major')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xenophrys' AND (species='major' OR species='major') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xenophrys' AND (species='major' OR species='major')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xenophrys' AND (junior_species='major' OR junior_species='major')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='Xenophrys' AND (species='major' OR species='major') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='gyldenstolpei' OR junior_species='gyldenstolpeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='gyldenstolpei' OR species='gyldenstolpeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='gyldenstolpei' OR species='gyldenstolpeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='gyldenstolpei' OR junior_species='gyldenstolpeii')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='Limnonectes' AND (species='gyldenstolpei' OR species='gyldenstolpeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='kuhlii' OR junior_species='kuhli')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='kuhlii' OR species='kuhli') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='kuhlii' OR species='kuhli')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='kuhlii' OR junior_species='kuhli')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='Limnonectes' AND (species='kuhlii' OR species='kuhli') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='limborgi' OR junior_species='limborgii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limnonectes' AND (species='limborgi' OR species='limborgii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limnonectes' AND (species='limborgi' OR species='limborgii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limnonectes' AND (junior_species='limborgi' OR junior_species='limborgii')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='Limnonectes' AND (species='limborgi' OR species='limborgii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='cubitalis' OR junior_species='cubitalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='cubitalis' OR species='cubitalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='cubitalis' OR species='cubitalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='cubitalis' OR junior_species='cubitalis')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='Hylarana' AND (species='cubitalis' OR species='cubitalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='nigrovittata' OR junior_species='nigrovittata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='nigrovittata' OR species='nigrovittata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='nigrovittata' OR species='nigrovittata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='nigrovittata' OR junior_species='nigrovittata')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='Hylarana' AND (species='nigrovittata' OR species='nigrovittata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='taipehensis' OR junior_species='taipehensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hylarana' AND (species='taipehensis' OR species='taipehensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hylarana' AND (species='taipehensis' OR species='taipehensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hylarana' AND (junior_species='taipehensis' OR junior_species='taipehensis')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='Hylarana' AND (species='taipehensis' OR species='taipehensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='aureola' OR junior_species='aureola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odorrana' AND (species='aureola' OR species='aureola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odorrana' AND (species='aureola' OR species='aureola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='aureola' OR junior_species='aureola')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='Odorrana' AND (species='aureola' OR species='aureola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='chloronota' OR junior_species='chloronota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odorrana' AND (species='chloronota' OR species='chloronota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odorrana' AND (species='chloronota' OR species='chloronota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odorrana' AND (junior_species='chloronota' OR junior_species='chloronota')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='Odorrana' AND (species='chloronota' OR species='chloronota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquixalus' AND (junior_species='bisacculus' OR junior_species='bisacculus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aquixalus' AND (species='bisacculus' OR species='bisacculus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aquixalus' AND (species='bisacculus' OR species='bisacculus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquixalus' AND (junior_species='bisacculus' OR junior_species='bisacculus')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='Aquixalus' AND (species='bisacculus' OR species='bisacculus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philautus' AND (junior_species='parvulus' OR junior_species='parvulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philautus' AND (species='parvulus' OR species='parvulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philautus' AND (species='parvulus' OR species='parvulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philautus' AND (junior_species='parvulus' OR junior_species='parvulus')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='Philautus' AND (species='parvulus' OR species='parvulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='leucomystax' OR junior_species='leucomystax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polypedates' AND (species='leucomystax' OR species='leucomystax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polypedates' AND (species='leucomystax' OR species='leucomystax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypedates' AND (junior_species='leucomystax' OR junior_species='leucomystax')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='Polypedates' AND (species='leucomystax' OR species='leucomystax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='berdmorei' OR junior_species='berdmoreii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microhyla' AND (species='berdmorei' OR species='berdmoreii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microhyla' AND (species='berdmorei' OR species='berdmoreii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microhyla' AND (junior_species='berdmorei' OR junior_species='berdmoreii')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='Microhyla' AND (species='berdmorei' OR species='berdmoreii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micryletta' AND (junior_species='inornata' OR junior_species='inornata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micryletta' AND (species='inornata' OR species='inornata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micryletta' AND (species='inornata' OR species='inornata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micryletta' AND (junior_species='inornata' OR junior_species='inornata')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='Micryletta' AND (species='inornata' OR species='inornata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=364