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=3198 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3198SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2986SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3198 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miathyria' AND (junior_species='marcella' OR junior_species='marcella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miathyria' AND (species='marcella' OR species='marcella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miathyria' AND (species='marcella' OR species='marcella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miathyria' AND (junior_species='marcella' OR junior_species='marcella')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='Miathyria' AND (species='marcella' OR species='marcella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perithemis' AND (junior_species='domitia' OR junior_species='domitia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perithemis' AND (species='domitia' OR species='domitia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perithemis' AND (species='domitia' OR species='domitia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perithemis' AND (junior_species='domitia' OR junior_species='domitia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perithemis' AND (species='domitia' OR species='domitia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='unimaculata' OR junior_species='unimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='unimaculata' OR species='unimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='unimaculata' OR species='unimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='unimaculata' OR junior_species='unimaculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrodiplax' AND (species='unimaculata' OR species='unimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='funerea' OR junior_species='funerea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='funerea' OR species='funerea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='funerea' OR species='funerea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='funerea' OR junior_species='funerea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrodiplax' AND (species='funerea' OR species='funerea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthemis' AND (species='ferruginea' OR species='ferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthemis' AND (species='ferruginea' OR species='ferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthemis' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthemis' AND (species='ferruginea' OR species='ferruginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dythemis' AND (junior_species='velox' OR junior_species='velox')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dythemis' AND (species='velox' OR species='velox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dythemis' AND (species='velox' OR species='velox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dythemis' AND (junior_species='velox' OR junior_species='velox')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dythemis' AND (species='velox' OR species='velox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='inequiunguis' OR junior_species='inequiunguis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macrothemis' AND (species='inequiunguis' OR species='inequiunguis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macrothemis' AND (species='inequiunguis' OR species='inequiunguis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macrothemis' AND (junior_species='inequiunguis' OR junior_species='inequiunguis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macrothemis' AND (species='inequiunguis' OR species='inequiunguis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uracis' AND (junior_species='imbuta' OR junior_species='imbuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Uracis' AND (species='imbuta' OR species='imbuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Uracis' AND (species='imbuta' OR species='imbuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Uracis' AND (junior_species='imbuta' OR junior_species='imbuta')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='Uracis' AND (species='imbuta' OR species='imbuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='vesiculosa' OR junior_species='vesiculosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythemis' AND (species='vesiculosa' OR species='vesiculosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythemis' AND (species='vesiculosa' OR species='vesiculosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='vesiculosa' OR junior_species='vesiculosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythemis' AND (species='vesiculosa' OR species='vesiculosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='plebeja' OR junior_species='plebeja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythemis' AND (species='plebeja' OR species='plebeja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythemis' AND (species='plebeja' OR species='plebeja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='plebeja' OR junior_species='plebeja')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythemis' AND (species='plebeja' OR species='plebeja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='peruviana' OR junior_species='peruviana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythemis' AND (species='peruviana' OR species='peruviana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythemis' AND (species='peruviana' OR species='peruviana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythemis' AND (junior_species='peruviana' OR junior_species='peruviana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythemis' AND (species='peruviana' OR species='peruviana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrathyria' AND (junior_species='hagenii' OR junior_species='hageni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micrathyria' AND (species='hagenii' OR species='hageni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micrathyria' AND (species='hagenii' OR species='hageni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micrathyria' AND (junior_species='hagenii' OR junior_species='hageni')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='Micrathyria' AND (species='hagenii' OR species='hageni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='connata' OR junior_species='connata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erythrodiplax' AND (species='connata' OR species='connata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erythrodiplax' AND (species='connata' OR species='connata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erythrodiplax' AND (junior_species='connata' OR junior_species='connata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erythrodiplax' AND (species='connata' OR species='connata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllogomphoides' AND (junior_species='appendiculatus' OR junior_species='appendiculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllogomphoides' AND (species='appendiculatus' OR species='appendiculatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllogomphoides' AND (species='appendiculatus' OR species='appendiculatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllogomphoides' AND (junior_species='appendiculatus' OR junior_species='appendiculatus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phyllogomphoides' AND (species='appendiculatus' OR species='appendiculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphylla' AND (junior_species='obscura' OR junior_species='obscura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphylla' AND (species='obscura' OR species='obscura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphylla' AND (species='obscura' OR species='obscura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphylla' AND (junior_species='obscura' OR junior_species='obscura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aphylla' AND (species='obscura' OR species='obscura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='macropus' OR junior_species='macropus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='macropus' OR species='macropus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='macropus' OR species='macropus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='macropus' OR junior_species='macropus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hetaerina' AND (species='macropus' OR species='macropus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='caja' OR junior_species='caja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hetaerina' AND (species='caja' OR species='caja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hetaerina' AND (species='caja' OR species='caja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hetaerina' AND (junior_species='caja' OR junior_species='caja')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hetaerina' AND (species='caja' OR species='caja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecistogaster' AND (junior_species='ornatus' OR junior_species='ornatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mecistogaster' AND (species='ornatus' OR species='ornatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mecistogaster' AND (species='ornatus' OR species='ornatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mecistogaster' AND (junior_species='ornatus' OR junior_species='ornatus')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='Mecistogaster' AND (species='ornatus' OR species='ornatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='tinctipennis' OR junior_species='tinctipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='tinctipennis' OR species='tinctipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='tinctipennis' OR species='tinctipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='tinctipennis' OR junior_species='tinctipennis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Argia' AND (species='tinctipennis' OR species='tinctipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='orichalcea' OR junior_species='orichalcea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='orichalcea' OR species='orichalcea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='orichalcea' OR species='orichalcea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='orichalcea' OR junior_species='orichalcea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Argia' AND (species='orichalcea' OR species='orichalcea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='pulla' OR junior_species='pulla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='pulla' OR species='pulla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='pulla' OR species='pulla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='pulla' OR junior_species='pulla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Argia' AND (species='pulla' OR species='pulla') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3198