Coordinate: 4° 34' S, 39° 45' W
coordinate is the midpoint of the three
only physically capture specimens were counted
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=3209 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3209SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2993SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3209 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='rosea' OR junior_species='rosea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='rosea' OR species='rosea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='rosea' OR species='rosea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='rosea' OR junior_species='rosea')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='Hetaerina' AND (species='rosea' OR species='rosea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='forficula' OR junior_species='forficula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestes' AND (species='forficula' OR species='forficula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestes' AND (species='forficula' OR species='forficula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='forficula' OR junior_species='forficula')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='Lestes' AND (species='forficula' OR species='forficula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthagrion' AND (junior_species='gracile' OR junior_species='gracile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthagrion' AND (species='gracile' OR species='gracile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthagrion' AND (species='gracile' OR species='gracile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthagrion' AND (junior_species='gracile' OR junior_species='gracile')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='Acanthagrion' AND (species='gracile' OR species='gracile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='modesta' OR junior_species='modesta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='modesta' OR species='modesta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='modesta' OR species='modesta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='modesta' OR junior_species='modesta')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='Argia' AND (species='modesta' OR species='modesta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='novaehispaniae' OR junior_species='novaehispaniae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='novaehispaniae' OR species='novaehispaniae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='novaehispaniae' OR species='novaehispaniae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='novaehispaniae' OR junior_species='novaehispaniae')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='Enallagma' AND (species='novaehispaniae' OR species='novaehispaniae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='capreolus' OR junior_species='capreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='capreolus' OR species='capreolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='capreolus' OR junior_species='capreolus')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='Ischnura' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='fluviatilis' OR junior_species='fluviatilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='fluviatilis' OR species='fluviatilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='fluviatilis' OR species='fluviatilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='fluviatilis' OR junior_species='fluviatilis')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='Ischnura' AND (species='fluviatilis' OR species='fluviatilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telebasis' AND (junior_species='corallina' OR junior_species='corallina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telebasis' AND (species='corallina' OR species='corallina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telebasis' AND (species='corallina' OR species='corallina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telebasis' AND (junior_species='corallina' OR junior_species='corallina')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='Telebasis' AND (species='corallina' OR species='corallina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telebasis' AND (junior_species='filiola' OR junior_species='filiola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telebasis' AND (species='filiola' OR species='filiola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telebasis' AND (species='filiola' OR species='filiola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telebasis' AND (junior_species='filiola' OR junior_species='filiola')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='Telebasis' AND (species='filiola' OR species='filiola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoneura' AND (junior_species='sylvatica' OR junior_species='sylvatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoneura' AND (species='sylvatica' OR species='sylvatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoneura' AND (species='sylvatica' OR species='sylvatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoneura' AND (junior_species='sylvatica' OR junior_species='sylvatica')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='Neoneura' AND (species='sylvatica' OR species='sylvatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllocycla' AND (junior_species='gladiata' OR junior_species='gladiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllocycla' AND (species='gladiata' OR species='gladiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllocycla' AND (species='gladiata' OR species='gladiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllocycla' AND (junior_species='gladiata' OR junior_species='gladiata')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='Phyllocycla' AND (species='gladiata' OR species='gladiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='dorsopallidus' OR junior_species='dorsopallidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Progomphus' AND (species='dorsopallidus' OR species='dorsopallidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Progomphus' AND (species='dorsopallidus' OR species='dorsopallidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='dorsopallidus' OR junior_species='dorsopallidus')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='Progomphus' AND (species='dorsopallidus' OR species='dorsopallidus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymesia' AND (junior_species='furcata' OR junior_species='furcata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachymesia' AND (species='furcata' OR species='furcata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachymesia' AND (species='furcata' OR species='furcata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymesia' AND (junior_species='furcata' OR junior_species='furcata')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='Brachymesia' AND (species='furcata' OR species='furcata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymesia' AND (junior_species='praecox' OR junior_species='praecox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachymesia' AND (species='praecox' OR species='praecox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachymesia' AND (species='praecox' OR species='praecox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachymesia' AND (junior_species='praecox' OR junior_species='praecox')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='Brachymesia' AND (species='praecox' OR species='praecox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasythemis' AND (junior_species='esmeralda' OR junior_species='esmeralda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dasythemis' AND (species='esmeralda' OR species='esmeralda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dasythemis' AND (species='esmeralda' OR species='esmeralda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dasythemis' AND (junior_species='esmeralda' OR junior_species='esmeralda')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='Dasythemis' AND (species='esmeralda' OR species='esmeralda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='plebeja' OR junior_species='plebeja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythemis' AND (species='plebeja' OR species='plebeja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythemis' AND (species='plebeja' OR species='plebeja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='plebeja' OR junior_species='plebeja')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='Erythemis' AND (species='plebeja' OR species='plebeja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='vesiculosa' OR junior_species='vesiculosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythemis' AND (species='vesiculosa' OR species='vesiculosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythemis' AND (species='vesiculosa' OR species='vesiculosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='vesiculosa' OR junior_species='vesiculosa')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='Erythemis' AND (species='vesiculosa' OR species='vesiculosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='basalis' OR junior_species='basalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='basalis' OR species='basalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='basalis' OR species='basalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='basalis' OR junior_species='basalis')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='Erythrodiplax' AND (species='basalis' OR species='basalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='fusca' OR junior_species='fusca')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='Erythrodiplax' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='latimaculata' OR junior_species='latimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='latimaculata' OR species='latimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='latimaculata' OR species='latimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='latimaculata' OR junior_species='latimaculata')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='Erythrodiplax' AND (species='latimaculata' OR species='latimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='leticia' OR junior_species='leticia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='leticia' OR species='leticia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='leticia' OR species='leticia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='leticia' OR junior_species='leticia')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='Erythrodiplax' AND (species='leticia' OR species='leticia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='umbrata' OR junior_species='umbrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='umbrata' OR species='umbrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='umbrata' OR species='umbrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='umbrata' OR junior_species='umbrata')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='Erythrodiplax' AND (species='umbrata' OR species='umbrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' 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='Erythrodiplax' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' 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='Erythrodiplax' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='griseofrons' OR junior_species='griseofrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrothemis' AND (species='griseofrons' OR species='griseofrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrothemis' AND (species='griseofrons' OR species='griseofrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='griseofrons' OR junior_species='griseofrons')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='Macrothemis' AND (species='griseofrons' OR species='griseofrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='hemichlora' OR junior_species='hemichlora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrothemis' AND (species='hemichlora' OR species='hemichlora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrothemis' AND (species='hemichlora' OR species='hemichlora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='hemichlora' OR junior_species='hemichlora')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='Macrothemis' AND (species='hemichlora' OR species='hemichlora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='lutea' OR junior_species='lutea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrothemis' AND (species='lutea' OR species='lutea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrothemis' AND (species='lutea' OR species='lutea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='lutea' OR junior_species='lutea')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='Macrothemis' AND (species='lutea' OR species='lutea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miathyria' AND (junior_species='marcella' OR junior_species='marcella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miathyria' AND (species='marcella' OR species='marcella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miathyria' AND (species='marcella' OR species='marcella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miathyria' AND (junior_species='marcella' OR junior_species='marcella')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='Miathyria' AND (species='marcella' OR species='marcella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrathyria' AND (junior_species='hesperis' OR junior_species='hesperis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrathyria' AND (species='hesperis' OR species='hesperis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrathyria' AND (species='hesperis' OR species='hesperis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrathyria' AND (junior_species='hesperis' OR junior_species='hesperis')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='Micrathyria' AND (species='hesperis' OR species='hesperis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='aequilbris' OR junior_species='aequilbris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthemis' AND (species='aequilbris' OR species='aequilbris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthemis' AND (species='aequilbris' OR species='aequilbris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='aequilbris' OR junior_species='aequilbris')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='Orthemis' AND (species='aequilbris' OR species='aequilbris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='flavopicta' OR junior_species='flavopicta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthemis' AND (species='flavopicta' OR species='flavopicta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthemis' AND (species='flavopicta' OR species='flavopicta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='flavopicta' OR junior_species='flavopicta')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='Orthemis' AND (species='flavopicta' OR species='flavopicta') 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='Perithemis' AND (junior_species='mooma' OR junior_species='mooma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perithemis' AND (species='mooma' OR species='mooma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perithemis' AND (species='mooma' OR species='mooma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perithemis' AND (junior_species='mooma' OR junior_species='mooma')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='Perithemis' AND (species='mooma' OR species='mooma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tauriphila' AND (junior_species='australis' OR junior_species='australis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tauriphila' AND (species='australis' OR species='australis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tauriphila' AND (species='australis' OR species='australis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tauriphila' AND (junior_species='australis' OR junior_species='australis')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='Tauriphila' AND (species='australis' OR species='australis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='calverti' OR junior_species='calvertii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tramea' AND (species='calverti' OR species='calvertii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tramea' AND (species='calverti' OR species='calvertii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='calverti' OR junior_species='calvertii')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='Tramea' AND (species='calverti' OR species='calvertii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='cophysa' OR junior_species='cophysa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tramea' AND (species='cophysa' OR species='cophysa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tramea' AND (species='cophysa' OR species='cophysa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='cophysa' OR junior_species='cophysa')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='Tramea' AND (species='cophysa' OR species='cophysa') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3209