Coordinate: 8° 18' 2" N, 123° 49' 4" E
specimens are definitely adults
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=1647 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1647SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1127SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1647 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='bolivari' OR junior_species='bolivarii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplacina' AND (species='bolivari' OR species='bolivarii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplacina' AND (species='bolivari' OR species='bolivarii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='bolivari' OR junior_species='bolivarii')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='Diplacina' AND (species='bolivari' OR species='bolivarii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='ramburii' OR junior_species='ramburi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neurothemis' AND (species='ramburii' OR species='ramburi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neurothemis' AND (species='ramburii' OR species='ramburi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='ramburii' OR junior_species='ramburi')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='Neurothemis' AND (species='ramburii' OR species='ramburi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='pruinosum' OR junior_species='pruinosum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='pruinosum' OR species='pruinosum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='pruinosum' OR species='pruinosum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='pruinosum' OR junior_species='pruinosum')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='Orthetrum' AND (species='pruinosum' OR species='pruinosum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='sabina' OR junior_species='sabina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='sabina' OR species='sabina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='sabina' OR species='sabina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='sabina' OR junior_species='sabina')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='Orthetrum' AND (species='sabina' OR species='sabina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='testaceum' OR junior_species='testaceum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='testaceum' OR species='testaceum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='testaceum' OR species='testaceum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='testaceum' OR junior_species='testaceum')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='Orthetrum' AND (species='testaceum' OR species='testaceum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantala' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantala' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='flavescens' OR junior_species='flavescens')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='Pantala' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='aurora' OR junior_species='aurora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='aurora' OR species='aurora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='aurora' OR species='aurora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='aurora' OR junior_species='aurora')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='Trithemis' AND (species='aurora' OR species='aurora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='festiva' OR junior_species='festiva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='festiva' OR species='festiva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='festiva' OR species='festiva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='festiva' OR junior_species='festiva')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='Trithemis' AND (species='festiva' OR species='festiva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vestalis' AND (junior_species='melania' OR junior_species='melania')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vestalis' AND (species='melania' OR species='melania') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vestalis' AND (species='melania' OR species='melania')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vestalis' AND (junior_species='melania' OR junior_species='melania')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='Vestalis' AND (species='melania' OR species='melania') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocypha' AND (junior_species='colorata' OR junior_species='colorata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhinocypha' AND (species='colorata' OR species='colorata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinocypha' AND (species='colorata' OR species='colorata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocypha' AND (junior_species='colorata' OR junior_species='colorata')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='Rhinocypha' AND (species='colorata' OR species='colorata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='pilidorsum' OR junior_species='pilidorsum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='pilidorsum' OR species='pilidorsum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='pilidorsum' OR species='pilidorsum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='pilidorsum' OR junior_species='pilidorsum')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='Pseudagrion' AND (species='pilidorsum' OR species='pilidorsum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='integra' OR junior_species='integra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prodasineura' AND (species='integra' OR species='integra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prodasineura' AND (species='integra' OR species='integra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='integra' OR junior_species='integra')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='Prodasineura' AND (species='integra' OR species='integra') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1647