Coordinate: 7° 47' 24" N, 124° 4' 26" E
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=1603 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1603SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1090SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1603 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemicordulia' AND (junior_species='mindana' OR junior_species='mindana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemicordulia' AND (species='mindana' OR species='mindana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemicordulia' AND (species='mindana' OR species='mindana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemicordulia' AND (junior_species='mindana' OR junior_species='mindana')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='Hemicordulia' AND (species='mindana' OR species='mindana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idionyx' AND (junior_species='philippa' OR junior_species='philippa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idionyx' AND (species='philippa' OR species='philippa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idionyx' AND (species='philippa' OR species='philippa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idionyx' AND (junior_species='philippa' OR junior_species='philippa')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='Idionyx' AND (species='philippa' OR species='philippa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' AND (junior_species='tenax' OR junior_species='tenax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictinogomphus' AND (species='tenax' OR species='tenax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictinogomphus' AND (species='tenax' OR species='tenax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' AND (junior_species='tenax' OR junior_species='tenax')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='Ictinogomphus' AND (species='tenax' OR species='tenax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acisoma' AND (junior_species='panorpoides' OR junior_species='panorpoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acisoma' AND (species='panorpoides' OR species='panorpoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acisoma' AND (species='panorpoides' OR species='panorpoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acisoma' AND (junior_species='panorpoides' OR junior_species='panorpoides')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='Acisoma' AND (species='panorpoides' OR species='panorpoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='braueri' OR junior_species='brauerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplacina' AND (species='braueri' OR species='brauerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplacina' AND (species='braueri' OR species='brauerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='braueri' OR junior_species='brauerii')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='braueri' OR species='brauerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='nana' OR junior_species='nana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diplacina' AND (species='nana' OR species='nana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diplacina' AND (species='nana' OR species='nana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diplacina' AND (junior_species='nana' OR junior_species='nana')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='nana' OR species='nana') 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='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='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='Agriocnemis' AND (junior_species='rubescens' OR junior_species='rubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriocnemis' AND (species='rubescens' OR species='rubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriocnemis' AND (species='rubescens' OR species='rubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='rubescens' OR junior_species='rubescens')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='Agriocnemis' AND (species='rubescens' OR species='rubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='lieftincki' OR junior_species='lieftinckii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceriagrion' AND (species='lieftincki' OR species='lieftinckii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceriagrion' AND (species='lieftincki' OR species='lieftinckii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='lieftincki' OR junior_species='lieftinckii')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='Ceriagrion' AND (species='lieftincki' OR species='lieftinckii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pericnemis' 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='Pericnemis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pericnemis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pericnemis' 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='Pericnemis' AND (species='sp.' OR species='sp.') 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='Teinobasis' AND (junior_species='filamentum' OR junior_species='filamentum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Teinobasis' AND (species='filamentum' OR species='filamentum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Teinobasis' AND (species='filamentum' OR species='filamentum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teinobasis' AND (junior_species='filamentum' OR junior_species='filamentum')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='Teinobasis' AND (species='filamentum' OR species='filamentum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Risiocnemis' AND (junior_species='flammea' OR junior_species='flammea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Risiocnemis' AND (species='flammea' OR species='flammea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Risiocnemis' AND (species='flammea' OR species='flammea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Risiocnemis' AND (junior_species='flammea' OR junior_species='flammea')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='Risiocnemis' AND (species='flammea' OR species='flammea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Risiocnemis' AND (junior_species='tendipes' OR junior_species='tendipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Risiocnemis' AND (species='tendipes' OR species='tendipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Risiocnemis' AND (species='tendipes' OR species='tendipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Risiocnemis' AND (junior_species='tendipes' OR junior_species='tendipes')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='Risiocnemis' AND (species='tendipes' OR species='tendipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanosticta' AND (junior_species='lestoides' OR junior_species='lestoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drepanosticta' AND (species='lestoides' OR species='lestoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drepanosticta' AND (species='lestoides' OR species='lestoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanosticta' AND (junior_species='lestoides' OR junior_species='lestoides')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='Drepanosticta' AND (species='lestoides' OR species='lestoides') 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=1603