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=1599 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1599SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1086SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1599 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorolestes' AND (junior_species='conspicuus' OR junior_species='conspicuus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorolestes' AND (species='conspicuus' OR species='conspicuus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorolestes' AND (species='conspicuus' OR species='conspicuus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorolestes' AND (junior_species='conspicuus' OR junior_species='conspicuus')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='Chlorolestes' AND (species='conspicuus' OR species='conspicuus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorolestes' AND (junior_species='umbratus' OR junior_species='umbratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorolestes' AND (species='umbratus' OR species='umbratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorolestes' AND (species='umbratus' OR species='umbratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorolestes' AND (junior_species='umbratus' OR junior_species='umbratus')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='Chlorolestes' AND (species='umbratus' OR species='umbratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ecchlorolestes' AND (junior_species='peringueyi' OR junior_species='peringueyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ecchlorolestes' AND (species='peringueyi' OR species='peringueyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ecchlorolestes' AND (species='peringueyi' OR species='peringueyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ecchlorolestes' AND (junior_species='peringueyi' OR junior_species='peringueyii')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='Ecchlorolestes' AND (species='peringueyi' OR species='peringueyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='frenulata' OR junior_species='frenulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattoneura' AND (species='frenulata' OR species='frenulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattoneura' AND (species='frenulata' OR species='frenulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='frenulata' OR junior_species='frenulata')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='frenulata' OR species='frenulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='glabrum' OR junior_species='glabrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceriagrion' AND (species='glabrum' OR species='glabrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceriagrion' AND (species='glabrum' OR species='glabrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='glabrum' OR junior_species='glabrum')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='glabrum' OR species='glabrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='draconis' OR junior_species='draconis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='draconis' OR species='draconis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='draconis' OR species='draconis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='draconis' OR junior_species='draconis')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='draconis' OR species='draconis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='furcigerum' OR junior_species='furcigerum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='furcigerum' OR species='furcigerum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='furcigerum' OR species='furcigerum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='furcigerum' OR junior_species='furcigerum')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='furcigerum' OR species='furcigerum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='kersteni' OR junior_species='kerstenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='kersteni' OR species='kerstenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='kersteni' OR species='kerstenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='kersteni' OR junior_species='kerstenii')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='kersteni' OR species='kerstenii') 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='Africallagma' AND (junior_species='glaucum' OR junior_species='glaucum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Africallagma' AND (species='glaucum' OR species='glaucum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Africallagma' AND (species='glaucum' OR species='glaucum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Africallagma' AND (junior_species='glaucum' OR junior_species='glaucum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Africallagma' AND (species='glaucum' OR species='glaucum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='falcifera' OR junior_species='falcifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriocnemis' AND (species='falcifera' OR species='falcifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriocnemis' AND (species='falcifera' OR species='falcifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='falcifera' OR junior_species='falcifera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agriocnemis' AND (species='falcifera' OR species='falcifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azuragrion' AND (junior_species='nigridorsum' OR junior_species='nigridorsum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Azuragrion' AND (species='nigridorsum' OR species='nigridorsum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Azuragrion' AND (species='nigridorsum' OR species='nigridorsum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Azuragrion' AND (junior_species='nigridorsum' OR junior_species='nigridorsum')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='Azuragrion' AND (species='nigridorsum' OR species='nigridorsum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycypha' AND (junior_species='fitzsimonsi' OR junior_species='fitzsimonsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platycypha' AND (species='fitzsimonsi' OR species='fitzsimonsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycypha' AND (species='fitzsimonsi' OR species='fitzsimonsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycypha' AND (junior_species='fitzsimonsi' OR junior_species='fitzsimonsii')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='Platycypha' AND (species='fitzsimonsi' OR species='fitzsimonsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratogomphus' AND (junior_species='pictus' OR junior_species='pictus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceratogomphus' AND (species='pictus' OR species='pictus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceratogomphus' AND (species='pictus' OR species='pictus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceratogomphus' AND (junior_species='pictus' OR junior_species='pictus')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='Ceratogomphus' AND (species='pictus' OR species='pictus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paragomphus' AND (junior_species='cognatus' OR junior_species='cognatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paragomphus' AND (species='cognatus' OR species='cognatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paragomphus' AND (species='cognatus' OR species='cognatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paragomphus' AND (junior_species='cognatus' OR junior_species='cognatus')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='Paragomphus' AND (species='cognatus' OR species='cognatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paragomphus' AND (junior_species='genei' OR junior_species='geneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paragomphus' AND (species='genei' OR species='geneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paragomphus' AND (species='genei' OR species='geneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paragomphus' AND (junior_species='genei' OR junior_species='geneii')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='Paragomphus' AND (species='genei' OR species='geneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='minuscula' OR junior_species='minuscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeshna' AND (species='minuscula' OR species='minuscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeshna' AND (species='minuscula' OR species='minuscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='minuscula' OR junior_species='minuscula')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='Aeshna' AND (species='minuscula' OR species='minuscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='subpupillata' OR junior_species='subpupillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aeshna' AND (species='subpupillata' OR species='subpupillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aeshna' AND (species='subpupillata' OR species='subpupillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aeshna' AND (junior_species='subpupillata' OR junior_species='subpupillata')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='Aeshna' AND (species='subpupillata' OR species='subpupillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='imperator' OR junior_species='imperator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='imperator' OR species='imperator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='imperator' OR species='imperator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='imperator' OR junior_species='imperator')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='imperator' OR species='imperator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='speratus' OR junior_species='speratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anax' AND (species='speratus' OR species='speratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anax' AND (species='speratus' OR species='speratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anax' AND (junior_species='speratus' OR junior_species='speratus')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='speratus' OR species='speratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncordulia' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syncordulia' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syncordulia' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncordulia' AND (junior_species='gracilis' OR junior_species='gracilis')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='Syncordulia' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncordulia' AND (junior_species='venator' OR junior_species='venator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syncordulia' AND (species='venator' OR species='venator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syncordulia' AND (species='venator' OR species='venator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syncordulia' AND (junior_species='venator' OR junior_species='venator')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='Syncordulia' AND (species='venator' OR species='venator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='abbotti' OR junior_species='abbottii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='abbotti' OR species='abbottii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='abbotti' OR species='abbottii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='abbotti' OR junior_species='abbottii')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='abbotti' OR species='abbottii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='caffrum' OR junior_species='caffrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='caffrum' OR species='caffrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='caffrum' OR species='caffrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='caffrum' OR junior_species='caffrum')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='caffrum' OR species='caffrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='julia' OR junior_species='julia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='julia' OR species='julia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='julia' OR species='julia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='julia' OR junior_species='julia')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='julia' OR species='julia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='trinacria' OR junior_species='trinacria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='trinacria' OR species='trinacria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='trinacria' OR species='trinacria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='trinacria' OR junior_species='trinacria')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='trinacria' OR species='trinacria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='farinosa' OR junior_species='farinosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesciothemis' AND (species='farinosa' OR species='farinosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nesciothemis' AND (species='farinosa' OR species='farinosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='farinosa' OR junior_species='farinosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nesciothemis' AND (species='farinosa' OR species='farinosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='erythraea' OR junior_species='erythraea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocothemis' AND (species='erythraea' OR species='erythraea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocothemis' AND (species='erythraea' OR species='erythraea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='erythraea' OR junior_species='erythraea')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='Crocothemis' AND (species='erythraea' OR species='erythraea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='sanguinolenta' OR junior_species='sanguinolenta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocothemis' AND (species='sanguinolenta' OR species='sanguinolenta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocothemis' AND (species='sanguinolenta' OR species='sanguinolenta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocothemis' AND (junior_species='sanguinolenta' OR junior_species='sanguinolenta')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='Crocothemis' AND (species='sanguinolenta' OR species='sanguinolenta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='fonscolombii' OR junior_species='fonscolombi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='fonscolombii' OR species='fonscolombi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='fonscolombii' OR species='fonscolombi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='fonscolombii' OR junior_species='fonscolombi')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='fonscolombii' OR species='fonscolombi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='arteriosa' OR junior_species='arteriosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='arteriosa' OR species='arteriosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='arteriosa' OR species='arteriosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='arteriosa' OR junior_species='arteriosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trithemis' AND (species='arteriosa' OR species='arteriosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='dorsalis' OR junior_species='dorsalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='dorsalis' OR species='dorsalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='dorsalis' OR species='dorsalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='dorsalis' OR junior_species='dorsalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trithemis' AND (species='dorsalis' OR species='dorsalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='furva' OR junior_species='furva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='furva' OR species='furva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='furva' OR species='furva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='furva' OR junior_species='furva')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trithemis' AND (species='furva' OR species='furva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='pluvialis' OR junior_species='pluvialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='pluvialis' OR species='pluvialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='pluvialis' OR species='pluvialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='pluvialis' OR junior_species='pluvialis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trithemis' AND (species='pluvialis' OR species='pluvialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='stictica' OR junior_species='stictica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='stictica' OR species='stictica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='stictica' OR species='stictica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='stictica' OR junior_species='stictica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trithemis' AND (species='stictica' OR species='stictica') 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='Tramea' AND (junior_species='limbata' OR junior_species='limbata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tramea' AND (species='limbata' OR species='limbata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tramea' AND (species='limbata' OR species='limbata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tramea' AND (junior_species='limbata' OR junior_species='limbata')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='limbata' OR species='limbata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygonyx' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zygonyx' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zygonyx' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zygonyx' AND (junior_species='natalensis' OR junior_species='natalensis')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='Zygonyx' AND (species='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1599 The Ecological Register: Kogelberg Biosphere Reserve
Kogelberg Biosphere Reserve
Basic information
Sample name: Kogelberg Biosphere Reserve

Reference: P. B. C. Grant and M. J. Samways. 2007. Montane refugia for endemic and Red Listed dragonflies in the Cape Floristic Region biodiversity hotspot. Biodiversity and Conservation 16:787-805 [ER 1086]
Geography
Country: South Africa

State: Western Cape


Coordinate: 34° 14' S, 19° 0' E
Coordinate basis: stated in text as range

Geography comments: "30 km east from Cape Point"
coordinate is the midpoint of ranges stated in the text

•
Environment
Habitat: Mediterranean woodland

Protection: biosphere reserve

Substrate: ground surface

Habitat comments: "a Mediterranean-type climate" with much of the vegetation being fynbos

Methods
Life forms: odonates

Sites: 255

Sampling methods: quadrat,visual

Sample size: 5380 captures or sightings

Years: 2003, 2004

Sampling comments: sites were "3 x 3 m quadrats" and counts were of "numbers of male individuals and species, perched or flying"

Metadata
Sample number: 1599

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-25 20:43:03

Modified: 2015-05-25 10:43:03

Abundance distribution
38 species
5 singletons
total count 5380
extrapolated richness: 45.8
Fisher's α: 5.521
geometric series k: 0.8307
Hurlbert's PIE: 0.9111
Shannon's H: 2.8185
Good's u: 0.9991
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Chlorolestes conspicuus136
Chlorolestes umbratus131
Ecchlorolestes peringueyi191
Elattoneura frenulata958
Ceriagrion glabrum119
Pseudagrion draconis112
Pseudagrion furcigerum414
Pseudagrion kersteni7
Ischnura senegalensis202
Africallagma glaucum2
Agriocnemis falcifera17
Azuragrion nigridorsum36
Platycypha fitzsimonsi fitzsimonsi222
Ceratogomphus pictus60
Paragomphus cognatus85
Paragomphus genei1
Aeshna minuscula17
Aeshna subpupillata28
Anax imperator73
Anax speratus89
Syncordulia gracilis101
Syncordulia venator1
Orthetrum abbotti1
Orthetrum caffrum1
Orthetrum julia capicola531
Orthetrum trinacria29
Nesciothemis farinosa73
Crocothemis erythraea7
Crocothemis sanguinolenta147
Sympetrum fonscolombii46
Trithemis arteriosa882
Trithemis dorsalis23
Trithemis furva223
Trithemis pluvialis60
Trithemis stictica336
Pantala flavescens1
Tramea limbata13
Zygonyx natalensis5