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=3191 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3191SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2981SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3191 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podolestes' AND (junior_species='chrysopus' OR junior_species='chrysopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podolestes' AND (species='chrysopus' OR species='chrysopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podolestes' AND (species='chrysopus' OR species='chrysopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podolestes' AND (junior_species='chrysopus' OR junior_species='chrysopus')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='Podolestes' AND (species='chrysopus' OR species='chrysopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podolestes' AND (junior_species='harrissoni' OR junior_species='harrissonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podolestes' AND (species='harrissoni' OR species='harrissonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podolestes' AND (species='harrissoni' OR species='harrissonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podolestes' AND (junior_species='harrissoni' OR junior_species='harrissonii')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='Podolestes' AND (species='harrissoni' OR species='harrissonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podolestes' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podolestes' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podolestes' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podolestes' AND (junior_species='orientalis' OR junior_species='orientalis')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='Podolestes' AND (species='orientalis' OR species='orientalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podolestes' 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='Podolestes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podolestes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podolestes' 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='Podolestes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellago' AND (junior_species='hyalina' OR junior_species='hyalina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libellago' AND (species='hyalina' OR species='hyalina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellago' AND (species='hyalina' OR species='hyalina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellago' AND (junior_species='hyalina' OR junior_species='hyalina')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='Libellago' AND (species='hyalina' OR species='hyalina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycypha' AND (junior_species='aurea' OR junior_species='aurea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycypha' AND (species='aurea' OR species='aurea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycypha' AND (species='aurea' OR species='aurea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycypha' AND (junior_species='aurea' OR junior_species='aurea')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='Pachycypha' AND (species='aurea' OR species='aurea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' 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='Coeliccia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coeliccia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coeliccia' 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='Coeliccia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='aurantiaca' OR junior_species='aurantiaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattoneura' AND (species='aurantiaca' OR species='aurantiaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattoneura' AND (species='aurantiaca' OR species='aurantiaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='aurantiaca' OR junior_species='aurantiaca')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='Elattoneura' AND (species='aurantiaca' OR species='aurantiaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychargia' AND (junior_species='atrocyana' OR junior_species='atrocyana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onychargia' AND (species='atrocyana' OR species='atrocyana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onychargia' AND (species='atrocyana' OR species='atrocyana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onychargia' AND (junior_species='atrocyana' OR junior_species='atrocyana')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='Onychargia' AND (species='atrocyana' OR species='atrocyana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphicnemis' AND (junior_species='annae' OR junior_species='annae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphicnemis' AND (species='annae' OR species='annae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphicnemis' AND (species='annae' OR species='annae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphicnemis' AND (junior_species='annae' OR junior_species='annae')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='Amphicnemis' AND (species='annae' OR species='annae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphicnemis' AND (junior_species='wallacii' OR junior_species='wallaci')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphicnemis' AND (species='wallacii' OR species='wallaci') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphicnemis' AND (species='wallacii' OR species='wallaci')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphicnemis' AND (junior_species='wallacii' OR junior_species='wallaci')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='Amphicnemis' AND (species='wallacii' OR species='wallaci') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphicnemis' AND (junior_species='dactylostyla' OR junior_species='dactylostyla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphicnemis' AND (species='dactylostyla' OR species='dactylostyla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphicnemis' AND (species='dactylostyla' OR species='dactylostyla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphicnemis' AND (junior_species='dactylostyla' OR junior_species='dactylostyla')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='Amphicnemis' AND (species='dactylostyla' OR species='dactylostyla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archibasis' AND (junior_species='melanocyana' OR junior_species='melanocyana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archibasis' AND (species='melanocyana' OR species='melanocyana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archibasis' AND (species='melanocyana' OR species='melanocyana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archibasis' AND (junior_species='melanocyana' OR junior_species='melanocyana')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='Archibasis' AND (species='melanocyana' OR species='melanocyana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archibasis' AND (junior_species='viola' OR junior_species='viola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archibasis' AND (species='viola' OR species='viola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archibasis' AND (species='viola' OR species='viola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archibasis' AND (junior_species='viola' OR junior_species='viola')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='Archibasis' AND (species='viola' OR species='viola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='cerinorubellum' OR junior_species='cerinorubellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceriagrion' AND (species='cerinorubellum' OR species='cerinorubellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceriagrion' AND (species='cerinorubellum' OR species='cerinorubellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='cerinorubellum' OR junior_species='cerinorubellum')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='cerinorubellum' OR species='cerinorubellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' 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='Ceriagrion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceriagrion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' 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='Ceriagrion' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='senegalensis' OR junior_species='senegalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='senegalensis' OR species='senegalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='senegalensis' OR species='senegalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='senegalensis' OR junior_species='senegalensis')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='senegalensis' OR species='senegalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mortonagrion' AND (junior_species='indraneil' OR junior_species='indraneil')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mortonagrion' AND (species='indraneil' OR species='indraneil') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mortonagrion' AND (species='indraneil' OR species='indraneil')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mortonagrion' AND (junior_species='indraneil' OR junior_species='indraneil')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='Mortonagrion' AND (species='indraneil' OR species='indraneil') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='coomansi' OR junior_species='coomansii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='coomansi' OR species='coomansii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='coomansi' OR species='coomansii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='coomansi' OR junior_species='coomansii')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='coomansi' OR species='coomansii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='microcephalum' OR junior_species='microcephalum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='microcephalum' OR species='microcephalum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='microcephalum' OR species='microcephalum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='microcephalum' OR junior_species='microcephalum')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='microcephalum' OR species='microcephalum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gynacantha' AND (junior_species='dohrni' OR junior_species='dohrnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gynacantha' AND (species='dohrni' OR species='dohrnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gynacantha' AND (species='dohrni' OR species='dohrnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gynacantha' AND (junior_species='dohrni' OR junior_species='dohrnii')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='Gynacantha' AND (species='dohrni' OR species='dohrnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliaeschna' AND (junior_species='idae' OR junior_species='idae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heliaeschna' AND (species='idae' OR species='idae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heliaeschna' AND (species='idae' OR species='idae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heliaeschna' AND (junior_species='idae' OR junior_species='idae')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='idae' OR species='idae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoaeschna' AND (junior_species='foliacea' OR junior_species='foliacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligoaeschna' AND (species='foliacea' OR species='foliacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligoaeschna' AND (species='foliacea' OR species='foliacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligoaeschna' AND (junior_species='foliacea' OR junior_species='foliacea')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='Oligoaeschna' AND (species='foliacea' OR species='foliacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracanthagyna' AND (junior_species='plagiata' OR junior_species='plagiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetracanthagyna' AND (species='plagiata' OR species='plagiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetracanthagyna' AND (species='plagiata' OR species='plagiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetracanthagyna' AND (junior_species='plagiata' OR junior_species='plagiata')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='Tetracanthagyna' AND (species='plagiata' OR species='plagiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' AND (junior_species='acutus' OR junior_species='acutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictinogomphus' AND (species='acutus' OR species='acutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictinogomphus' AND (species='acutus' OR species='acutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' AND (junior_species='acutus' OR junior_species='acutus')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='acutus' OR species='acutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' AND (junior_species='decoratus' OR junior_species='decoratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictinogomphus' AND (species='decoratus' OR species='decoratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictinogomphus' AND (species='decoratus' OR species='decoratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictinogomphus' AND (junior_species='decoratus' OR junior_species='decoratus')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='decoratus' OR species='decoratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrogomphus' AND (junior_species='decemlineatus' OR junior_species='decemlineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrogomphus' AND (species='decemlineatus' OR species='decemlineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrogomphus' AND (species='decemlineatus' OR species='decemlineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrogomphus' AND (junior_species='decemlineatus' OR junior_species='decemlineatus')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='Macrogomphus' AND (species='decemlineatus' OR species='decemlineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='cincta' OR junior_species='cincta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macromia' AND (species='cincta' OR species='cincta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macromia' AND (species='cincta' OR species='cincta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macromia' AND (junior_species='cincta' OR junior_species='cincta')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='Macromia' AND (species='cincta' OR species='cincta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemicordulia' AND (junior_species='tenera' OR junior_species='tenera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemicordulia' AND (species='tenera' OR species='tenera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemicordulia' AND (species='tenera' OR species='tenera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemicordulia' AND (junior_species='tenera' OR junior_species='tenera')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='tenera' OR species='tenera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachygonia' AND (junior_species='oculata' OR junior_species='oculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachygonia' AND (species='oculata' OR species='oculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachygonia' AND (species='oculata' OR species='oculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachygonia' AND (junior_species='oculata' OR junior_species='oculata')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='Brachygonia' AND (species='oculata' OR species='oculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachygonia' AND (junior_species='ophelia' OR junior_species='ophelia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachygonia' AND (species='ophelia' OR species='ophelia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachygonia' AND (species='ophelia' OR species='ophelia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachygonia' AND (junior_species='ophelia' OR junior_species='ophelia')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='Brachygonia' AND (species='ophelia' OR species='ophelia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachygonia' AND (junior_species='puella' OR junior_species='puella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachygonia' AND (species='puella' OR species='puella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachygonia' AND (species='puella' OR species='puella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachygonia' AND (junior_species='puella' OR junior_species='puella')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='Brachygonia' AND (species='puella' OR species='puella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalybeothemis' 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='Chalybeothemis' AND (species='fluviatilis' OR species='fluviatilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalybeothemis' AND (species='fluviatilis' OR species='fluviatilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalybeothemis' 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='Chalybeothemis' AND (species='fluviatilis' OR species='fluviatilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nannophya' AND (junior_species='pygmaea' OR junior_species='pygmaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nannophya' AND (species='pygmaea' OR species='pygmaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nannophya' AND (species='pygmaea' OR species='pygmaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nannophya' AND (junior_species='pygmaea' OR junior_species='pygmaea')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='Nannophya' AND (species='pygmaea' OR species='pygmaea') 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='pruinans' OR junior_species='pruinans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orchithemis' AND (species='pruinans' OR species='pruinans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orchithemis' AND (species='pruinans' OR species='pruinans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orchithemis' AND (junior_species='pruinans' OR junior_species='pruinans')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='pruinans' OR species='pruinans') 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='Orchithemis' AND (junior_species='xanthosoma' OR junior_species='xanthosoma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orchithemis' AND (species='xanthosoma' OR species='xanthosoma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orchithemis' AND (species='xanthosoma' OR species='xanthosoma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orchithemis' AND (junior_species='xanthosoma' OR junior_species='xanthosoma')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='xanthosoma' OR species='xanthosoma') 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='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='Pornothemis' AND (junior_species='serrata' OR junior_species='serrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pornothemis' AND (species='serrata' OR species='serrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pornothemis' AND (species='serrata' OR species='serrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pornothemis' AND (junior_species='serrata' OR junior_species='serrata')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='Pornothemis' AND (species='serrata' OR species='serrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodothemis' AND (junior_species='rufa' OR junior_species='rufa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodothemis' AND (species='rufa' OR species='rufa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodothemis' AND (species='rufa' OR species='rufa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodothemis' AND (junior_species='rufa' OR junior_species='rufa')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='Rhodothemis' AND (species='rufa' OR species='rufa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='fulgens' OR junior_species='fulgens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyothemis' AND (species='fulgens' OR species='fulgens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyothemis' AND (species='fulgens' OR species='fulgens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='fulgens' OR junior_species='fulgens')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='fulgens' OR species='fulgens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='obsolescens' OR junior_species='obsolescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyothemis' AND (species='obsolescens' OR species='obsolescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyothemis' AND (species='obsolescens' OR species='obsolescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyothemis' AND (junior_species='obsolescens' OR junior_species='obsolescens')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='obsolescens' OR species='obsolescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyriobapta' AND (junior_species='laidlawi' OR junior_species='laidlawii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tyriobapta' AND (species='laidlawi' OR species='laidlawii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyriobapta' AND (species='laidlawi' OR species='laidlawii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyriobapta' AND (junior_species='laidlawi' OR junior_species='laidlawii')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='Tyriobapta' AND (species='laidlawi' OR species='laidlawii') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zyxomma' AND (junior_species='petiolatum' OR junior_species='petiolatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zyxomma' AND (species='petiolatum' OR species='petiolatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zyxomma' AND (species='petiolatum' OR species='petiolatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zyxomma' AND (junior_species='petiolatum' OR junior_species='petiolatum')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='Zyxomma' AND (species='petiolatum' OR species='petiolatum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3191 The Ecological Register: Maludam National Park
Maludam National Park
Basic information
Sample name: Maludam National Park

Reference: R. A. Dow, R. W. J. Ngiam, and R. Ahmad. 2015. Odonata of Maludam National Park, Sarawak, Malaysia. Journal of Threatened Taxa 7(1):6764-6773 [ER 2981]
Geography
Country: Malaysia

State: Sarawak


Coordinate: 1° 33' N, 111° 6' E
Coordinate basis: based on nearby landmark

Geography comments: "The main areas of collection were: Sungai Maludam near Rumah Tanjong Baru (outside the national park boundary); Sungai Maludam inside the national park, this is referred to below as Ulu (upriver) Maludam; in swamp adjacent to, and small streams flowing into Ulu Maludam"
coordinate based on Maludam National Park

•
Environment
Habitat: tropical/subtropical wetland

Protection: national/state park

Substrate: ground surface

Methods
Life forms: odonates

Sampling methods: no design,other nets

Sample size: 373 individuals

Years: 2012

Days: 6

Sampling comments: "Adult Odonata were collected using handheld nets on six days from 6 to 11 July 2012... On the Sungai Maludam, sampling was conducted from a boat. Sampling in swamp and small streams flowing into Sungai Maludam was conducted on foot"

Metadata
Sample number: 3191

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-01-08 18:25:02

Modified: 2019-01-08 07:25:02

Abundance distribution
47 species
12 singletons
total count 373
extrapolated richness: 77.4
Fisher's α: 14.225
geometric series k: 0.9281
Hurlbert's PIE: 0.9586
Shannon's H: 3.4078
Good's u: 0.9679
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Podolestes chrysopus26
Podolestes harrissoni18
Podolestes orientalis5
Podolestes sp.3
said to be new
Libellago hyalina15
Pachycypha aurea1
Coeliccia sp.4
Elattoneura aurantiaca31
Onychargia atrocyana1
Amphicnemis annae17
Amphicnemis wallacii12
Amphicnemis cf. dactylostyla3
Archibasis melanocyana22
Archibasis viola6
Ceriagrion cerinorubellum9
Ceriagrion sp.12
said to be new
Ischnura senegalensis1
Mortonagrion indraneil14
Pseudagrion coomansi9
Pseudagrion microcephalum3
Gynacantha dohrni1
Heliaeschna idae9
Oligoaeschna foliacea3
Tetracanthagyna plagiata1
Ictinogomphus acutus15
Ictinogomphus decoratus melaenops2
Macrogomphus decemlineatus2
Macromia cincta3
Hemicordulia tenera19
Brachygonia oculata21
Brachygonia ophelia2
Brachygonia puella13
Chalybeothemis fluviatilis9
Nannophya pygmaea4
Neurothemis fluctuans1
Orchithemis pruinans1
Orchithemis pulcherrima1
Orchithemis xanthosoma11
Orthetrum chrysis1
Orthetrum sabina1
Pornothemis serrata6
Rhodothemis rufa1
Rhyothemis fulgens4
Rhyothemis obsolescens1
Tyriobapta laidlawi20
Urothemis signata insignata7
Zyxomma petiolatum2