Coordinate: 2° 20' 25" N, 102° 36' 50" E
sampled during 3 - 5 December 2016, 24 - 26 February 2017, and 25 - 27 April 2017
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=3195 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3195SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2984SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3195 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vestalis' AND (junior_species='amoena' OR junior_species='amoena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vestalis' AND (species='amoena' OR species='amoena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vestalis' AND (species='amoena' OR species='amoena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vestalis' AND (junior_species='amoena' OR junior_species='amoena')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='amoena' OR species='amoena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aristocypha' AND (junior_species='fenestrella' OR junior_species='fenestrella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aristocypha' AND (species='fenestrella' OR species='fenestrella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aristocypha' AND (species='fenestrella' OR species='fenestrella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aristocypha' AND (junior_species='fenestrella' OR junior_species='fenestrella')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='Aristocypha' AND (species='fenestrella' OR species='fenestrella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliocypha' AND (junior_species='biforata' OR junior_species='biforata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliocypha' AND (species='biforata' OR species='biforata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliocypha' AND (species='biforata' OR species='biforata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliocypha' AND (junior_species='biforata' OR junior_species='biforata')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='Heliocypha' AND (species='biforata' OR species='biforata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliocypha' AND (junior_species='perforata' OR junior_species='perforata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliocypha' AND (species='perforata' OR species='perforata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliocypha' AND (species='perforata' OR species='perforata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliocypha' AND (junior_species='perforata' OR junior_species='perforata')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='Heliocypha' AND (species='perforata' OR species='perforata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysphaea' AND (junior_species='dimidiata' OR junior_species='dimidiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysphaea' AND (species='dimidiata' OR species='dimidiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysphaea' AND (species='dimidiata' OR species='dimidiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysphaea' AND (junior_species='dimidiata' OR junior_species='dimidiata')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='Dysphaea' AND (species='dimidiata' OR species='dimidiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaea' AND (junior_species='impar' OR junior_species='impar')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaea' AND (species='impar' OR species='impar') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaea' AND (species='impar' OR species='impar')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaea' AND (junior_species='impar' OR junior_species='impar')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='Euphaea' AND (species='impar' OR species='impar') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaea' AND (junior_species='ochracea' OR junior_species='ochracea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphaea' AND (species='ochracea' OR species='ochracea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphaea' AND (species='ochracea' OR species='ochracea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphaea' AND (junior_species='ochracea' OR junior_species='ochracea')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='Euphaea' AND (species='ochracea' OR species='ochracea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argiocnemis' 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='Argiocnemis' AND (species='rubescens' OR species='rubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argiocnemis' AND (species='rubescens' OR species='rubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argiocnemis' 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='Argiocnemis' AND (species='rubescens' OR species='rubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='albicauda' OR junior_species='albicauda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliccia' AND (species='albicauda' OR species='albicauda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliccia' AND (species='albicauda' OR species='albicauda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='albicauda' OR junior_species='albicauda')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='Coeliccia' AND (species='albicauda' OR species='albicauda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='didyma' OR junior_species='didyma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliccia' AND (species='didyma' OR species='didyma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliccia' AND (species='didyma' OR species='didyma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='didyma' OR junior_species='didyma')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='Coeliccia' AND (species='didyma' OR species='didyma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='octogesima' OR junior_species='octogesima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coeliccia' AND (species='octogesima' OR species='octogesima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliccia' AND (species='octogesima' OR species='octogesima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' AND (junior_species='octogesima' OR junior_species='octogesima')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='Coeliccia' AND (species='octogesima' OR species='octogesima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indocnemis' AND (junior_species='orang' OR junior_species='orang')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Indocnemis' AND (species='orang' OR species='orang') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Indocnemis' AND (species='orang' OR species='orang')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indocnemis' AND (junior_species='orang' OR junior_species='orang')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='Indocnemis' AND (species='orang' OR species='orang') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='humeralis' OR junior_species='humeralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prodasineura' AND (species='humeralis' OR species='humeralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prodasineura' AND (species='humeralis' OR species='humeralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prodasineura' AND (junior_species='humeralis' OR junior_species='humeralis')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='humeralis' OR species='humeralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanosticta' AND (junior_species='quadrata' OR junior_species='quadrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drepanosticta' AND (species='quadrata' OR species='quadrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drepanosticta' AND (species='quadrata' OR species='quadrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drepanosticta' AND (junior_species='quadrata' OR junior_species='quadrata')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='quadrata' OR species='quadrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protosticta' AND (junior_species='foersteri' OR junior_species='foersterii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protosticta' AND (species='foersteri' OR species='foersterii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protosticta' AND (species='foersteri' OR species='foersterii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protosticta' AND (junior_species='foersteri' OR junior_species='foersterii')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='Protosticta' AND (species='foersteri' OR species='foersterii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliaeschna' AND (junior_species='crassa' OR junior_species='crassa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliaeschna' AND (species='crassa' OR species='crassa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliaeschna' AND (species='crassa' OR species='crassa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliaeschna' AND (junior_species='crassa' OR junior_species='crassa')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='Heliaeschna' AND (species='crassa' OR species='crassa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indaeschna' AND (junior_species='grubaueri' OR junior_species='grubauerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Indaeschna' AND (species='grubaueri' OR species='grubauerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Indaeschna' AND (species='grubaueri' OR species='grubauerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Indaeschna' AND (junior_species='grubaueri' OR junior_species='grubauerii')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='Indaeschna' AND (species='grubaueri' OR species='grubauerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrionoptera' AND (junior_species='insignis' OR junior_species='insignis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrionoptera' AND (species='insignis' OR species='insignis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrionoptera' AND (species='insignis' OR species='insignis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrionoptera' AND (junior_species='insignis' OR junior_species='insignis')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='Agrionoptera' AND (species='insignis' OR species='insignis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachydiplax' AND (junior_species='farinosa' OR junior_species='farinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachydiplax' AND (species='farinosa' OR species='farinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachydiplax' AND (species='farinosa' OR species='farinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachydiplax' AND (junior_species='farinosa' OR junior_species='farinosa')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='Brachydiplax' AND (species='farinosa' OR species='farinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cratilla' AND (junior_species='metallica' OR junior_species='metallica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cratilla' AND (species='metallica' OR species='metallica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cratilla' AND (species='metallica' OR species='metallica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cratilla' AND (junior_species='metallica' OR junior_species='metallica')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='Cratilla' AND (species='metallica' OR species='metallica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathrecista' AND (junior_species='asiatica' OR junior_species='asiatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lathrecista' AND (species='asiatica' OR species='asiatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lathrecista' AND (species='asiatica' OR species='asiatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lathrecista' AND (junior_species='asiatica' OR junior_species='asiatica')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='Lathrecista' AND (species='asiatica' OR species='asiatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lyriothemis' AND (junior_species='biappendiculata' OR junior_species='biappendiculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lyriothemis' AND (species='biappendiculata' OR species='biappendiculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lyriothemis' AND (species='biappendiculata' OR species='biappendiculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lyriothemis' AND (junior_species='biappendiculata' OR junior_species='biappendiculata')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='Lyriothemis' AND (species='biappendiculata' OR species='biappendiculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='fluctuans' OR junior_species='fluctuans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neurothemis' AND (species='fluctuans' OR species='fluctuans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neurothemis' AND (species='fluctuans' OR species='fluctuans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurothemis' AND (junior_species='fluctuans' OR junior_species='fluctuans')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='fluctuans' OR species='fluctuans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orchithemis' AND (junior_species='pulcherrima' OR junior_species='pulcherrima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orchithemis' AND (species='pulcherrima' OR species='pulcherrima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orchithemis' AND (species='pulcherrima' OR species='pulcherrima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orchithemis' AND (junior_species='pulcherrima' OR junior_species='pulcherrima')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='Orchithemis' AND (species='pulcherrima' OR species='pulcherrima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='chrysis' OR junior_species='chrysis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='chrysis' OR species='chrysis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='chrysis' OR species='chrysis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='chrysis' OR junior_species='chrysis')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='chrysis' OR species='chrysis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='glaucum' OR junior_species='glaucum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='glaucum' OR species='glaucum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='glaucum' OR species='glaucum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='glaucum' OR junior_species='glaucum')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='glaucum' OR species='glaucum') 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='Potamarcha' AND (junior_species='congener' OR junior_species='congener')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potamarcha' AND (species='congener' OR species='congener') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Potamarcha' AND (species='congener' OR species='congener')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potamarcha' AND (junior_species='congener' OR junior_species='congener')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='Potamarcha' AND (species='congener' OR species='congener') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='phyllis' OR junior_species='phyllis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyothemis' AND (species='phyllis' OR species='phyllis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyothemis' AND (species='phyllis' OR species='phyllis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='phyllis' OR junior_species='phyllis')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='Rhyothemis' AND (species='phyllis' OR species='phyllis') 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='Urothemis' AND (junior_species='signata' OR junior_species='signata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urothemis' AND (species='signata' OR species='signata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urothemis' AND (species='signata' OR species='signata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urothemis' AND (junior_species='signata' OR junior_species='signata')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='Urothemis' AND (species='signata' OR species='signata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3195