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=1728 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1728SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1194SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1728 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='americana' OR junior_species='americana')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='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archilestes' AND (junior_species='grandis' OR junior_species='grandis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Archilestes' AND (species='grandis' OR species='grandis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Archilestes' AND (species='grandis' OR species='grandis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Archilestes' AND (junior_species='grandis' OR junior_species='grandis')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='Archilestes' AND (species='grandis' OR species='grandis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='alacer' OR junior_species='alacer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestes' AND (species='alacer' OR species='alacer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestes' AND (species='alacer' OR species='alacer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestes' AND (junior_species='alacer' OR junior_species='alacer')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='alacer' OR species='alacer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protoneura' AND (junior_species='cara' OR junior_species='cara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protoneura' AND (species='cara' OR species='cara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protoneura' AND (species='cara' OR species='cara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protoneura' AND (junior_species='cara' OR junior_species='cara')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='Protoneura' AND (species='cara' OR species='cara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apanisagrion' AND (junior_species='lais' OR junior_species='lais')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apanisagrion' AND (species='lais' OR species='lais') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apanisagrion' AND (species='lais' OR species='lais')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apanisagrion' AND (junior_species='lais' OR junior_species='lais')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='Apanisagrion' AND (species='lais' OR species='lais') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='aniceps' OR junior_species='aniceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='aniceps' OR species='aniceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='aniceps' OR species='aniceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='aniceps' OR junior_species='aniceps')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='aniceps' OR species='aniceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='carlcooki' OR junior_species='carlcookii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='carlcooki' OR species='carlcookii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='carlcooki' OR species='carlcookii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='carlcooki' OR junior_species='carlcookii')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='carlcooki' OR species='carlcookii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='extranea' OR junior_species='extranea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='extranea' OR species='extranea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='extranea' OR species='extranea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='extranea' OR junior_species='extranea')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='extranea' OR species='extranea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='hinei' OR junior_species='hineii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='hinei' OR species='hineii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='hinei' OR species='hineii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='hinei' OR junior_species='hineii')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='hinei' OR species='hineii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='oculata' OR species='oculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='oculata' OR species='oculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' 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='Argia' AND (species='oculata' OR species='oculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='oenea' OR junior_species='oenea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='oenea' OR species='oenea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='oenea' OR species='oenea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='oenea' OR junior_species='oenea')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='oenea' OR species='oenea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='pallens' OR junior_species='pallens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='pallens' OR species='pallens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='pallens' OR species='pallens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='pallens' OR junior_species='pallens')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='pallens' OR species='pallens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='sabino' OR junior_species='sabino')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='sabino' OR species='sabino') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='sabino' OR species='sabino')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='sabino' OR junior_species='sabino')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='sabino' OR species='sabino') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='tezpi' OR junior_species='tezpii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='tezpi' OR species='tezpii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='tezpi' OR species='tezpii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='tezpi' OR junior_species='tezpii')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='tezpi' OR species='tezpii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='civile' OR junior_species='civile')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='civile' OR species='civile') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='civile' OR species='civile')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='civile' OR junior_species='civile')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='civile' OR species='civile') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='praevarum' OR junior_species='praevarum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='praevarum' OR species='praevarum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='praevarum' OR species='praevarum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='praevarum' OR junior_species='praevarum')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='praevarum' OR species='praevarum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='semicirculare' OR junior_species='semicirculare')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='semicirculare' OR species='semicirculare') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='semicirculare' OR species='semicirculare')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='semicirculare' OR junior_species='semicirculare')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='semicirculare' OR species='semicirculare') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telebasis' AND (junior_species='salva' OR junior_species='salva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Telebasis' AND (species='salva' OR species='salva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Telebasis' AND (species='salva' OR species='salva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Telebasis' AND (junior_species='salva' OR junior_species='salva')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='salva' OR species='salva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='junius' OR junior_species='junius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='junius' OR species='junius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='junius' OR species='junius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='junius' OR junior_species='junius')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='Anax' AND (species='junius' OR species='junius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='walsinghami' OR junior_species='walsinghamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='walsinghami' OR species='walsinghamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='walsinghami' OR species='walsinghamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='walsinghami' OR junior_species='walsinghamii')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='Anax' AND (species='walsinghami' OR species='walsinghamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhionaeschna' AND (junior_species='multicolor' OR junior_species='multicolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhionaeschna' AND (species='multicolor' OR species='multicolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhionaeschna' AND (species='multicolor' OR species='multicolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhionaeschna' AND (junior_species='multicolor' OR junior_species='multicolor')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='Rhionaeschna' AND (species='multicolor' OR species='multicolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhionaeschna' AND (junior_species='psilus' OR junior_species='psilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhionaeschna' AND (species='psilus' OR species='psilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhionaeschna' AND (species='psilus' OR species='psilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhionaeschna' AND (junior_species='psilus' OR junior_species='psilus')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='Rhionaeschna' AND (species='psilus' OR species='psilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphylla' AND (junior_species='protracta' OR junior_species='protracta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphylla' AND (species='protracta' OR species='protracta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphylla' AND (species='protracta' OR species='protracta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphylla' AND (junior_species='protracta' OR junior_species='protracta')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='Aphylla' AND (species='protracta' OR species='protracta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erpetogomphus' AND (junior_species='elaps' OR junior_species='elaps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erpetogomphus' AND (species='elaps' OR species='elaps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erpetogomphus' AND (species='elaps' OR species='elaps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erpetogomphus' AND (junior_species='elaps' OR junior_species='elaps')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='Erpetogomphus' AND (species='elaps' OR species='elaps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllogomphoides' AND (junior_species='nayaritensis' OR junior_species='nayaritensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllogomphoides' AND (species='nayaritensis' OR species='nayaritensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllogomphoides' AND (species='nayaritensis' OR species='nayaritensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllogomphoides' AND (junior_species='nayaritensis' OR junior_species='nayaritensis')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='Phyllogomphoides' AND (species='nayaritensis' OR species='nayaritensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='borealis' OR junior_species='borealis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Progomphus' AND (species='borealis' OR species='borealis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Progomphus' AND (species='borealis' OR species='borealis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='borealis' OR junior_species='borealis')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='borealis' OR species='borealis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='clendoni' OR junior_species='clendonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Progomphus' AND (species='clendoni' OR species='clendonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Progomphus' AND (species='clendoni' OR species='clendonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Progomphus' AND (junior_species='clendoni' OR junior_species='clendonii')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='clendoni' OR species='clendonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brechmorhoga' AND (junior_species='mendax' OR junior_species='mendax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brechmorhoga' AND (species='mendax' OR species='mendax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brechmorhoga' AND (species='mendax' OR species='mendax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brechmorhoga' AND (junior_species='mendax' OR junior_species='mendax')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='Brechmorhoga' AND (species='mendax' OR species='mendax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brechmorhoga' 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='Brechmorhoga' AND (species='praecox' OR species='praecox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brechmorhoga' AND (species='praecox' OR species='praecox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brechmorhoga' 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='Brechmorhoga' AND (species='praecox' OR species='praecox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dythemis' AND (junior_species='maya' OR junior_species='maya')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dythemis' AND (species='maya' OR species='maya') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dythemis' AND (species='maya' OR species='maya')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dythemis' AND (junior_species='maya' OR junior_species='maya')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='Dythemis' AND (species='maya' OR species='maya') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dythemis' AND (junior_species='nigrescens' OR junior_species='nigrescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dythemis' AND (species='nigrescens' OR species='nigrescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dythemis' AND (species='nigrescens' OR species='nigrescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dythemis' AND (junior_species='nigrescens' OR junior_species='nigrescens')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='Dythemis' AND (species='nigrescens' OR species='nigrescens') 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='basifusca' OR junior_species='basifusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='basifusca' OR species='basifusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='basifusca' OR species='basifusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='basifusca' OR junior_species='basifusca')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='basifusca' OR species='basifusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='croceipennis' OR junior_species='croceipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libellula' AND (species='croceipennis' OR species='croceipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellula' AND (species='croceipennis' OR species='croceipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='croceipennis' OR junior_species='croceipennis')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='Libellula' AND (species='croceipennis' OR species='croceipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='saturata' OR junior_species='saturata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libellula' AND (species='saturata' OR species='saturata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellula' AND (species='saturata' OR species='saturata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='saturata' OR junior_species='saturata')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='Libellula' AND (species='saturata' OR species='saturata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='inacuta' OR junior_species='inacuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrothemis' AND (species='inacuta' OR species='inacuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrothemis' AND (species='inacuta' OR species='inacuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='inacuta' OR junior_species='inacuta')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='inacuta' OR species='inacuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='pseudimitans' OR junior_species='pseudimitans')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrothemis' AND (species='pseudimitans' OR species='pseudimitans') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrothemis' AND (species='pseudimitans' OR species='pseudimitans')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='pseudimitans' OR junior_species='pseudimitans')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='pseudimitans' OR species='pseudimitans') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='discolor' OR junior_species='discolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthemis' AND (species='discolor' OR species='discolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthemis' AND (species='discolor' OR species='discolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='discolor' OR junior_species='discolor')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='discolor' OR species='discolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthemis' AND (species='ferruginea' OR species='ferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthemis' AND (species='ferruginea' OR species='ferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='ferruginea' OR junior_species='ferruginea')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='ferruginea' OR species='ferruginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paltothemis' AND (junior_species='lineatipes' OR junior_species='lineatipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paltothemis' AND (species='lineatipes' OR species='lineatipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paltothemis' AND (species='lineatipes' OR species='lineatipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paltothemis' AND (junior_species='lineatipes' OR junior_species='lineatipes')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='Paltothemis' AND (species='lineatipes' OR species='lineatipes') 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='Pantala' AND (junior_species='hymenaea' OR junior_species='hymenaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pantala' AND (species='hymenaea' OR species='hymenaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pantala' AND (species='hymenaea' OR species='hymenaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pantala' AND (junior_species='hymenaea' OR junior_species='hymenaea')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='hymenaea' OR species='hymenaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perithemis' AND (junior_species='intensa' OR junior_species='intensa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perithemis' AND (species='intensa' OR species='intensa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perithemis' AND (species='intensa' OR species='intensa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perithemis' AND (junior_species='intensa' OR junior_species='intensa')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='intensa' OR species='intensa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoleon' AND (junior_species='superbus' OR junior_species='superbus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoleon' AND (species='superbus' OR species='superbus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoleon' AND (species='superbus' OR species='superbus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoleon' AND (junior_species='superbus' OR junior_species='superbus')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='Pseudoleon' AND (species='superbus' OR species='superbus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='corruptum' OR junior_species='corruptum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='corruptum' OR species='corruptum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='corruptum' OR species='corruptum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='corruptum' OR junior_species='corruptum')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='Sympetrum' AND (species='corruptum' OR species='corruptum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='illotum' OR junior_species='illotum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='illotum' OR species='illotum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='illotum' OR species='illotum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='illotum' OR junior_species='illotum')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='Sympetrum' AND (species='illotum' OR species='illotum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='onusta' OR junior_species='onusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tramea' AND (species='onusta' OR species='onusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tramea' AND (species='onusta' OR species='onusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='onusta' OR junior_species='onusta')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='onusta' OR species='onusta') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1728 The Ecological Register: San Javier
San Javier
Basic information
Sample name: San Javier

Reference: E. González-Soriano, F. A. Noguera, S. Zaragoza-Caballero, and E. Ramírez-García. 2009. Odonata de un bosque tropical caducifolio: sierra de San Javier, Sonora, México. Revista Mexicana de Biodiversidad 80(2):341-348 [ER 1194]
Geography
Country: Mexico

State: Sonora


Coordinate: 28° 36' N, 109° 44' W
Coordinate basis: stated in text

Geography comments: "El municipio de San Javier se localiza en el extremo suroeste de la sierra El Aliso, a 25 km al oeste del río Yaqui" and collecting was along "un transecto de aproximadamente 17 km (Kms. 140-157) de la carretera Hermosillo-Yécora" with five permanent sites and three occasionally visited sites

•
Environment
Habitat: tropical/subtropical dry broadleaf forest

Substrate: ground surface

Methods
Life forms: odonates

Sites: 8

Sampling methods: no design,other nets

Sample size: 1013 individuals

Years: 2003, 2004

Sampling comments: captures were with "una red entomológica"

Metadata
Sample number: 1728

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-08-02 20:05:23

Modified: 2015-08-02 10:05:23

Abundance distribution
47 species
4 singletons
total count 1013
extrapolated richness: 57.8
Fisher's α: 10.199
geometric series k: 0.9030
Hurlbert's PIE: 0.9510
Shannon's H: 3.3371
Good's u: 0.9961
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Hetaerina americana53
Archilestes grandis43
Lestes alacer3
Protoneura cara4
Apanisagrion lais9
Argia aniceps4
Argia carlcooki28
Argia extranea72
Argia hinei26
Argia oculata5
Argia oenea33
Argia pallens101
Argia sabino1
Argia tezpi109
Enallagma civile36
Enallagma praevarum24
Enallagma semicirculare12
Telebasis salva71
Anax junius8
Anax walsinghami2
Rhionaeschna multicolor2
Rhionaeschna psilus6
Aphylla protracta1
Erpetogomphus elaps1
Phyllogomphoides nayaritensis1
Progomphus borealis6
Progomphus clendoni4
Brechmorhoga mendax5
Brechmorhoga praecox12
Dythemis maya15
Dythemis nigrescens9
Erythemis vesiculosa7
Erythrodiplax basifusca24
Libellula croceipennis16
Libellula saturata25
Macrothemis inacuta15
Macrothemis pseudimitans14
Orthemis discolor14
Orthemis ferruginea22
Paltothemis lineatipes37
Pantala flavescens19
Pantala hymenaea7
Perithemis intensa51
Pseudoleon superbus24
Sympetrum corruptum10
Sympetrum illotum7
Tramea onusta15