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=3221 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3221SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2996SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3221 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='fumipennis' OR junior_species='fumipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argia' AND (species='fumipennis' OR species='fumipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argia' AND (species='fumipennis' OR species='fumipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argia' AND (junior_species='fumipennis' OR junior_species='fumipennis')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='fumipennis' OR species='fumipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chromagrion' AND (junior_species='conditum' OR junior_species='conditum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chromagrion' AND (species='conditum' OR species='conditum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chromagrion' AND (species='conditum' OR species='conditum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chromagrion' AND (junior_species='conditum' OR junior_species='conditum')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='Chromagrion' AND (species='conditum' OR species='conditum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='boreale' OR junior_species='boreale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='boreale' OR species='boreale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='boreale' OR species='boreale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='boreale' OR junior_species='boreale')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enallagma' AND (species='boreale' OR species='boreale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='cyathigerum' OR junior_species='cyathigerum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='cyathigerum' OR species='cyathigerum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='cyathigerum' OR species='cyathigerum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='cyathigerum' OR junior_species='cyathigerum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enallagma' AND (species='cyathigerum' OR species='cyathigerum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='ebrium' OR junior_species='ebrium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='ebrium' OR species='ebrium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='ebrium' OR species='ebrium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='ebrium' OR junior_species='ebrium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enallagma' AND (species='ebrium' OR species='ebrium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='hageni' OR junior_species='hagenii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enallagma' AND (species='hageni' OR species='hagenii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enallagma' AND (species='hageni' OR species='hagenii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enallagma' AND (junior_species='hageni' OR junior_species='hagenii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enallagma' AND (species='hageni' OR species='hagenii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='verticalis' OR junior_species='verticalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ischnura' AND (species='verticalis' OR species='verticalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ischnura' AND (species='verticalis' OR species='verticalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ischnura' AND (junior_species='verticalis' OR junior_species='verticalis')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='verticalis' OR species='verticalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' 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='Gomphus' AND (species='exilis' OR species='exilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphus' AND (species='exilis' OR species='exilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphus' 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='Gomphus' AND (species='exilis' OR species='exilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didymops' AND (junior_species='transversa' OR junior_species='transversa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Didymops' AND (species='transversa' OR species='transversa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Didymops' AND (species='transversa' OR species='transversa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Didymops' AND (junior_species='transversa' OR junior_species='transversa')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='Didymops' AND (species='transversa' OR species='transversa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragoneuria' AND (junior_species='spinigera' OR junior_species='spinigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tetragoneuria' AND (species='spinigera' OR species='spinigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tetragoneuria' AND (species='spinigera' OR species='spinigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tetragoneuria' AND (junior_species='spinigera' OR junior_species='spinigera')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='Tetragoneuria' AND (species='spinigera' OR species='spinigera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helocordulia' AND (junior_species='uhleri' OR junior_species='uhlerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helocordulia' AND (species='uhleri' OR species='uhlerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helocordulia' AND (species='uhleri' OR species='uhlerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helocordulia' AND (junior_species='uhleri' OR junior_species='uhlerii')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='Helocordulia' AND (species='uhleri' OR species='uhlerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorocordulia' AND (junior_species='lepida' OR junior_species='lepida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dorocordulia' AND (species='lepida' OR species='lepida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dorocordulia' AND (species='lepida' OR species='lepida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dorocordulia' AND (junior_species='lepida' OR junior_species='lepida')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='Dorocordulia' AND (species='lepida' OR species='lepida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulia' AND (junior_species='shurtleffi' OR junior_species='shurtleffii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cordulia' AND (species='shurtleffi' OR species='shurtleffii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cordulia' AND (species='shurtleffi' OR species='shurtleffii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cordulia' AND (junior_species='shurtleffi' OR junior_species='shurtleffii')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='Cordulia' AND (species='shurtleffi' OR species='shurtleffii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ladona' AND (junior_species='exusta' OR junior_species='exusta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ladona' AND (species='exusta' OR species='exusta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ladona' AND (species='exusta' OR species='exusta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ladona' AND (junior_species='exusta' OR junior_species='exusta')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='Ladona' AND (species='exusta' OR species='exusta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ladona' 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='Ladona' AND (species='julia' OR species='julia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ladona' AND (species='julia' OR species='julia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ladona' 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='Ladona' AND (species='julia' OR species='julia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='quadrimaculata' OR junior_species='quadrimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libellula' AND (species='quadrimaculata' OR species='quadrimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libellula' AND (species='quadrimaculata' OR species='quadrimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libellula' AND (junior_species='quadrimaculata' OR junior_species='quadrimaculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Libellula' AND (species='quadrimaculata' OR species='quadrimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucorrhinia' AND (junior_species='hudsonica' OR junior_species='hudsonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucorrhinia' AND (species='hudsonica' OR species='hudsonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucorrhinia' AND (species='hudsonica' OR species='hudsonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucorrhinia' AND (junior_species='hudsonica' OR junior_species='hudsonica')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='Leucorrhinia' AND (species='hudsonica' OR species='hudsonica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3221