Coordinate: 7° 17' 26" N, 5° 8' 41" E
dry forest based on location
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=2310 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2310SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2250SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2310 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestinogomphus' AND (junior_species='angustus' OR junior_species='angustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lestinogomphus' AND (species='angustus' OR species='angustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lestinogomphus' AND (species='angustus' OR species='angustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lestinogomphus' AND (junior_species='angustus' OR junior_species='angustus')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='Lestinogomphus' AND (species='angustus' OR species='angustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachythemis' AND (junior_species='lacustris' OR junior_species='lacustris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachythemis' AND (species='lacustris' OR species='lacustris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachythemis' AND (species='lacustris' OR species='lacustris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachythemis' AND (junior_species='lacustris' OR junior_species='lacustris')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='Brachythemis' AND (species='lacustris' OR species='lacustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachythemis' AND (junior_species='leucosticte' OR junior_species='leucosticte')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachythemis' AND (species='leucosticte' OR species='leucosticte') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachythemis' AND (species='leucosticte' OR species='leucosticte')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachythemis' AND (junior_species='leucosticte' OR junior_species='leucosticte')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='Brachythemis' AND (species='leucosticte' OR species='leucosticte') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcostephia' AND (junior_species='flavifrons' OR junior_species='flavifrons')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalcostephia' AND (species='flavifrons' OR species='flavifrons') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalcostephia' AND (species='flavifrons' OR species='flavifrons')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalcostephia' AND (junior_species='flavifrons' OR junior_species='flavifrons')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='Chalcostephia' AND (species='flavifrons' OR species='flavifrons') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Congothemis' AND (junior_species='dubia' OR junior_species='dubia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Congothemis' AND (species='dubia' OR species='dubia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Congothemis' AND (species='dubia' OR species='dubia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Congothemis' AND (junior_species='dubia' OR junior_species='dubia')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='Congothemis' AND (species='dubia' OR species='dubia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Congothemis' AND (junior_species='leakeyi' OR junior_species='leakeyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Congothemis' AND (species='leakeyi' OR species='leakeyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Congothemis' AND (species='leakeyi' OR species='leakeyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Congothemis' AND (junior_species='leakeyi' OR junior_species='leakeyii')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='Congothemis' AND (species='leakeyi' OR species='leakeyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lokia' AND (junior_species='erythromelas' OR junior_species='erythromelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lokia' AND (species='erythromelas' OR species='erythromelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lokia' AND (species='erythromelas' OR species='erythromelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lokia' AND (junior_species='erythromelas' OR junior_species='erythromelas')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='Lokia' AND (species='erythromelas' OR species='erythromelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='nigeriensis' OR junior_species='nigeriensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesciothemis' AND (species='nigeriensis' OR species='nigeriensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nesciothemis' AND (species='nigeriensis' OR species='nigeriensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='nigeriensis' OR junior_species='nigeriensis')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='nigeriensis' OR species='nigeriensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='farinose' OR junior_species='farinose')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesciothemis' AND (species='farinose' OR species='farinose') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nesciothemis' AND (species='farinose' OR species='farinose')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='farinose' OR junior_species='farinose')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='farinose' OR species='farinose') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='pujoli' OR junior_species='pujolii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nesciothemis' AND (species='pujoli' OR species='pujolii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nesciothemis' AND (species='pujoli' OR species='pujolii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nesciothemis' AND (junior_species='pujoli' OR junior_species='pujolii')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='pujoli' OR species='pujolii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='africanum' OR junior_species='africanum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='africanum' OR species='africanum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='africanum' OR species='africanum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='africanum' OR junior_species='africanum')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='africanum' OR species='africanum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='brachiale' OR junior_species='brachiale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='brachiale' OR species='brachiale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='brachiale' OR species='brachiale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='brachiale' OR junior_species='brachiale')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='brachiale' OR species='brachiale') 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='chrysostigma' OR junior_species='chrysostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='chrysostigma' OR species='chrysostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='chrysostigma' OR species='chrysostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='chrysostigma' OR junior_species='chrysostigma')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='chrysostigma' OR species='chrysostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='hintzi' OR junior_species='hintzii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='hintzi' OR species='hintzii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='hintzi' OR species='hintzii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='hintzi' OR junior_species='hintzii')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='hintzi' OR species='hintzii') 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='machadoi' OR junior_species='machadoii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='machadoi' OR species='machadoii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='machadoi' OR species='machadoii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='machadoi' OR junior_species='machadoii')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='machadoi' OR species='machadoii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='stemmale' OR junior_species='stemmale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='stemmale' OR species='stemmale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='stemmale' OR species='stemmale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='stemmale' OR junior_species='stemmale')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='stemmale' OR species='stemmale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpopleura' AND (junior_species='lucia' OR junior_species='lucia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palpopleura' AND (species='lucia' OR species='lucia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palpopleura' AND (species='lucia' OR species='lucia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpopleura' AND (junior_species='lucia' OR junior_species='lucia')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='Palpopleura' AND (species='lucia' OR species='lucia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpopleura' AND (junior_species='portia' OR junior_species='portia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palpopleura' AND (species='portia' OR species='portia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Palpopleura' AND (species='portia' OR species='portia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Palpopleura' AND (junior_species='portia' OR junior_species='portia')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='Palpopleura' AND (species='portia' OR species='portia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='navasi' OR junior_species='navasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sympetrum' AND (species='navasi' OR species='navasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sympetrum' AND (species='navasi' OR species='navasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sympetrum' AND (junior_species='navasi' OR junior_species='navasii')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='navasi' OR species='navasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='dichroa' OR junior_species='dichroa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='dichroa' OR species='dichroa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='dichroa' OR species='dichroa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='dichroa' OR junior_species='dichroa')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='dichroa' OR species='dichroa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='imitate' OR junior_species='imitate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='imitate' OR species='imitate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='imitate' OR species='imitate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='imitate' OR junior_species='imitate')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='imitate' OR species='imitate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaon' AND (junior_species='camerunensis' OR junior_species='camerunensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaon' AND (species='camerunensis' OR species='camerunensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaon' AND (species='camerunensis' OR species='camerunensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaon' AND (junior_species='camerunensis' OR junior_species='camerunensis')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='Phaon' AND (species='camerunensis' OR species='camerunensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaon' AND (junior_species='iridipennis' OR junior_species='iridipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phaon' AND (species='iridipennis' OR species='iridipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phaon' AND (species='iridipennis' OR species='iridipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phaon' AND (junior_species='iridipennis' OR junior_species='iridipennis')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='Phaon' AND (species='iridipennis' OR species='iridipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saphon' AND (junior_species='ciliata' OR junior_species='ciliata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saphon' AND (species='ciliata' OR species='ciliata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Saphon' AND (species='ciliata' OR species='ciliata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saphon' AND (junior_species='ciliata' OR junior_species='ciliata')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='Saphon' AND (species='ciliata' OR species='ciliata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' 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='Umma' AND (species='cincta' OR species='cincta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Umma' AND (species='cincta' OR species='cincta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' 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='Umma' AND (species='cincta' OR species='cincta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' AND (junior_species='declivium' OR junior_species='declivium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Umma' AND (species='declivium' OR species='declivium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Umma' AND (species='declivium' OR species='declivium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' AND (junior_species='declivium' OR junior_species='declivium')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='Umma' AND (species='declivium' OR species='declivium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' AND (junior_species='mesostigma' OR junior_species='mesostigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Umma' AND (species='mesostigma' OR species='mesostigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Umma' AND (species='mesostigma' OR species='mesostigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' AND (junior_species='mesostigma' OR junior_species='mesostigma')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='Umma' AND (species='mesostigma' OR species='mesostigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' AND (junior_species='saphirina' OR junior_species='saphirina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Umma' AND (species='saphirina' OR species='saphirina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Umma' AND (species='saphirina' OR species='saphirina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' AND (junior_species='saphirina' OR junior_species='saphirina')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='Umma' AND (species='saphirina' OR species='saphirina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' AND (junior_species='mesumbei' OR junior_species='mesumbeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Umma' AND (species='mesumbei' OR species='mesumbeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Umma' AND (species='mesumbei' OR species='mesumbeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Umma' AND (junior_species='mesumbei' OR junior_species='mesumbeii')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='Umma' AND (species='mesumbei' OR species='mesumbeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='cancellata' OR junior_species='cancellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='cancellata' OR species='cancellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='cancellata' OR species='cancellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='cancellata' OR junior_species='cancellata')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='Chlorocypha' AND (species='cancellata' OR species='cancellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='centripunctata' OR junior_species='centripunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='centripunctata' OR species='centripunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='centripunctata' OR species='centripunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='centripunctata' OR junior_species='centripunctata')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='Chlorocypha' AND (species='centripunctata' OR species='centripunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='consueta' OR junior_species='consueta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='consueta' OR species='consueta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='consueta' OR species='consueta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='consueta' OR junior_species='consueta')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='Chlorocypha' AND (species='consueta' OR species='consueta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='dahli' OR junior_species='dahlii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='dahli' OR species='dahlii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='dahli' OR species='dahlii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='dahli' OR junior_species='dahlii')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='Chlorocypha' AND (species='dahli' OR species='dahlii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='autorea' OR junior_species='autorea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='autorea' OR species='autorea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='autorea' OR species='autorea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='autorea' OR junior_species='autorea')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='Chlorocypha' AND (species='autorea' OR species='autorea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='luminosa' OR junior_species='luminosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='luminosa' OR species='luminosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='luminosa' OR species='luminosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='luminosa' OR junior_species='luminosa')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='Chlorocypha' AND (species='luminosa' OR species='luminosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='victorae' OR junior_species='victorae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='victorae' OR species='victorae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='victorae' OR species='victorae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='victorae' OR junior_species='victorae')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='Chlorocypha' AND (species='victorae' OR species='victorae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='dispar' OR junior_species='dispar')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='dispar' OR species='dispar') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='dispar' OR species='dispar')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='dispar' OR junior_species='dispar')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='Chlorocypha' AND (species='dispar' OR species='dispar') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='glauca' OR junior_species='glauca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='glauca' OR species='glauca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='glauca' OR species='glauca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='glauca' OR junior_species='glauca')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='Chlorocypha' AND (species='glauca' OR species='glauca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='curta' OR junior_species='curta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='curta' OR species='curta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='curta' OR species='curta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='curta' OR junior_species='curta')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='Chlorocypha' AND (species='curta' OR species='curta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='radix' OR junior_species='radix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='radix' OR species='radix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='radix' OR species='radix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='radix' OR junior_species='radix')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='Chlorocypha' AND (species='radix' OR species='radix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='flammea' OR junior_species='flammea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='flammea' OR species='flammea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='flammea' OR species='flammea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='flammea' OR junior_species='flammea')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='Chlorocypha' AND (species='flammea' OR species='flammea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='trifaria' OR junior_species='trifaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='trifaria' OR species='trifaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='trifaria' OR species='trifaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='trifaria' OR junior_species='trifaria')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='Chlorocypha' AND (species='trifaria' OR species='trifaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='pyriformosa' OR junior_species='pyriformosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='pyriformosa' OR species='pyriformosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='pyriformosa' OR species='pyriformosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='pyriformosa' OR junior_species='pyriformosa')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='Chlorocypha' AND (species='pyriformosa' OR species='pyriformosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycypha' AND (junior_species='auripes' OR junior_species='auripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platycypha' AND (species='auripes' OR species='auripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycypha' AND (species='auripes' OR species='auripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycypha' AND (junior_species='auripes' OR junior_species='auripes')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='auripes' OR species='auripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycypha' AND (junior_species='eliseva' OR junior_species='eliseva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platycypha' AND (species='eliseva' OR species='eliseva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platycypha' AND (species='eliseva' OR species='eliseva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platycypha' AND (junior_species='eliseva' OR junior_species='eliseva')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='eliseva' OR species='eliseva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aciagrion' AND (junior_species='heterostica' OR junior_species='heterostica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aciagrion' AND (species='heterostica' OR species='heterostica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aciagrion' AND (species='heterostica' OR species='heterostica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aciagrion' AND (junior_species='heterostica' OR junior_species='heterostica')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='Aciagrion' AND (species='heterostica' OR species='heterostica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aciagrion' AND (junior_species='hamoni' OR junior_species='hamonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aciagrion' AND (species='hamoni' OR species='hamonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aciagrion' AND (species='hamoni' OR species='hamonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aciagrion' AND (junior_species='hamoni' OR junior_species='hamonii')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='Aciagrion' AND (species='hamoni' OR species='hamonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Africallagma' AND (junior_species='vaginale' OR junior_species='vaginale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Africallagma' AND (species='vaginale' OR species='vaginale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Africallagma' AND (species='vaginale' OR species='vaginale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Africallagma' AND (junior_species='vaginale' OR junior_species='vaginale')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='vaginale' OR species='vaginale') 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='Ceriagrion' AND (junior_species='suave' OR junior_species='suave')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ceriagrion' AND (species='suave' OR species='suave') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ceriagrion' AND (species='suave' OR species='suave')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ceriagrion' AND (junior_species='suave' OR junior_species='suave')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='suave' OR species='suave') 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='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='Pseudagrion' AND (junior_species='melanicterum' OR junior_species='melanicterum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='melanicterum' OR species='melanicterum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='melanicterum' OR species='melanicterum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='melanicterum' OR junior_species='melanicterum')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='melanicterum' OR species='melanicterum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='risi' OR junior_species='risii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='risi' OR species='risii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='risi' OR species='risii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='risi' OR junior_species='risii')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='risi' OR species='risii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='sublacteum' OR junior_species='sublacteum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='sublacteum' OR species='sublacteum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='sublacteum' OR species='sublacteum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='sublacteum' OR junior_species='sublacteum')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='sublacteum' OR species='sublacteum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='torridum' OR junior_species='torridum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='torridum' OR species='torridum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='torridum' OR species='torridum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='torridum' OR junior_species='torridum')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='torridum' OR species='torridum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teinobasis' AND (junior_species='alluaudi' OR junior_species='alluaudii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Teinobasis' AND (species='alluaudi' OR species='alluaudii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Teinobasis' AND (species='alluaudi' OR species='alluaudii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Teinobasis' AND (junior_species='alluaudi' OR junior_species='alluaudii')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='Teinobasis' AND (species='alluaudi' OR species='alluaudii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurolestes' AND (junior_species='trinervis' OR junior_species='trinervis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neurolestes' AND (species='trinervis' OR species='trinervis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neurolestes' AND (species='trinervis' OR species='trinervis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neurolestes' AND (junior_species='trinervis' OR junior_species='trinervis')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='Neurolestes' AND (species='trinervis' OR species='trinervis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesocnemis' AND (junior_species='saralisa' OR junior_species='saralisa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesocnemis' AND (species='saralisa' OR species='saralisa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesocnemis' AND (species='saralisa' OR species='saralisa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesocnemis' AND (junior_species='saralisa' OR junior_species='saralisa')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='Mesocnemis' AND (species='saralisa' OR species='saralisa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesocnemis' AND (junior_species='singularis' OR junior_species='singularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesocnemis' AND (species='singularis' OR species='singularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesocnemis' AND (species='singularis' OR species='singularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesocnemis' AND (junior_species='singularis' OR junior_species='singularis')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='Mesocnemis' AND (species='singularis' OR species='singularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreocnemis' AND (junior_species='phoenix' OR junior_species='phoenix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oreocnemis' AND (species='phoenix' OR species='phoenix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oreocnemis' AND (species='phoenix' OR species='phoenix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oreocnemis' AND (junior_species='phoenix' OR junior_species='phoenix')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='Oreocnemis' AND (species='phoenix' OR species='phoenix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocnemis' AND (junior_species='nigripesi' OR junior_species='nigripesii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocnemis' AND (species='nigripesi' OR species='nigripesii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocnemis' AND (species='nigripesi' OR species='nigripesii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocnemis' AND (junior_species='nigripesi' OR junior_species='nigripesii')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='Chlorocnemis' AND (species='nigripesi' OR species='nigripesii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocnemis' AND (junior_species='superb' OR junior_species='superb')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocnemis' AND (species='superb' OR species='superb') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocnemis' AND (species='superb' OR species='superb')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocnemis' AND (junior_species='superb' OR junior_species='superb')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='Chlorocnemis' AND (species='superb' OR species='superb') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='centrafricana' OR junior_species='centrafricana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattoneura' AND (species='centrafricana' OR species='centrafricana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattoneura' AND (species='centrafricana' OR species='centrafricana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='centrafricana' OR junior_species='centrafricana')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='centrafricana' OR species='centrafricana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='incerta' OR junior_species='incerta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattoneura' AND (species='incerta' OR species='incerta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattoneura' AND (species='incerta' OR species='incerta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='incerta' OR junior_species='incerta')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='incerta' OR species='incerta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattoneura' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattoneura' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='nigra' OR junior_species='nigra')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='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='lliba' OR junior_species='lliba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattoneura' AND (species='lliba' OR species='lliba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattoneura' AND (species='lliba' OR species='lliba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='lliba' OR junior_species='lliba')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='lliba' OR species='lliba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='pasquinii' OR junior_species='pasquini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Elattoneura' AND (species='pasquinii' OR species='pasquini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Elattoneura' AND (species='pasquinii' OR species='pasquini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Elattoneura' AND (junior_species='pasquinii' OR junior_species='pasquini')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='pasquinii' OR species='pasquini') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2310