Coordinate: 3° 53' N, 18° 0' E
coordinate based on Mbaïka
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=3178 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3178SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2971SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3178 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='serrulatum' OR junior_species='serrulatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='serrulatum' OR species='serrulatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='serrulatum' OR species='serrulatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='serrulatum' OR junior_species='serrulatum')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='serrulatum' OR species='serrulatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='coeruleiceps' OR junior_species='coeruleiceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='coeruleiceps' OR species='coeruleiceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='coeruleiceps' OR species='coeruleiceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='coeruleiceps' OR junior_species='coeruleiceps')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='coeruleiceps' OR species='coeruleiceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='kibalense' OR junior_species='kibalense')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudagrion' AND (species='kibalense' OR species='kibalense') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudagrion' AND (species='kibalense' OR species='kibalense')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudagrion' AND (junior_species='kibalense' OR junior_species='kibalense')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='kibalense' OR species='kibalense') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='exilis' OR junior_species='exilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriocnemis' AND (species='exilis' OR species='exilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriocnemis' AND (species='exilis' OR species='exilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriocnemis' AND (junior_species='exilis' OR junior_species='exilis')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='exilis' OR species='exilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='victoriae' OR junior_species='victoriae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='victoriae' OR species='victoriae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='victoriae' OR species='victoriae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='victoriae' OR junior_species='victoriae')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='victoriae' OR species='victoriae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='aphrodite' OR junior_species='aphrodite')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorocypha' AND (species='aphrodite' OR species='aphrodite') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorocypha' AND (species='aphrodite' OR species='aphrodite')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorocypha' AND (junior_species='aphrodite' OR junior_species='aphrodite')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='aphrodite' OR species='aphrodite') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapho' AND (junior_species='puella' OR junior_species='puella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sapho' AND (species='puella' OR species='puella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sapho' AND (species='puella' OR species='puella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sapho' AND (junior_species='puella' OR junior_species='puella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sapho' AND (species='puella' OR species='puella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrathemis' AND (junior_species='sulci' OR junior_species='sulcii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetrathemis' AND (species='sulci' OR species='sulcii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetrathemis' AND (species='sulci' OR species='sulcii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetrathemis' AND (junior_species='sulci' OR junior_species='sulcii')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='Tetrathemis' AND (species='sulci' OR species='sulcii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiothemis' AND (junior_species='robertsi' OR junior_species='robertsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiothemis' AND (species='robertsi' OR species='robertsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiothemis' AND (species='robertsi' OR species='robertsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiothemis' AND (junior_species='robertsi' OR junior_species='robertsii')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='Notiothemis' AND (species='robertsi' OR species='robertsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hadrothemis' AND (junior_species='versuta' OR junior_species='versuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hadrothemis' AND (species='versuta' OR species='versuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hadrothemis' AND (species='versuta' OR species='versuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hadrothemis' AND (junior_species='versuta' OR junior_species='versuta')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='Hadrothemis' AND (species='versuta' OR species='versuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='microstigma' OR junior_species='microstigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthetrum' AND (species='microstigma' OR species='microstigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthetrum' AND (species='microstigma' OR species='microstigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthetrum' AND (junior_species='microstigma' OR junior_species='microstigma')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='microstigma' OR species='microstigma') 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='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='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='Trithemis' AND (junior_species='nuptialis' OR junior_species='nuptialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trithemis' AND (species='nuptialis' OR species='nuptialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trithemis' AND (species='nuptialis' OR species='nuptialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trithemis' AND (junior_species='nuptialis' OR junior_species='nuptialis')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='nuptialis' OR species='nuptialis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3178