Coordinate: 45° 39' 31" N, 9° 36' 24" E
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=2373 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2373SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2274SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2373 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='aeneicollis' OR junior_species='aeneicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='aeneicollis' OR species='aeneicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='aeneicollis' OR species='aeneicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='aeneicollis' OR junior_species='aeneicollis')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='Atheta' AND (species='aeneicollis' OR species='aeneicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='triangulum' OR junior_species='triangulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='triangulum' OR species='triangulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='triangulum' OR species='triangulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='triangulum' OR junior_species='triangulum')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='Atheta' AND (species='triangulum' OR species='triangulum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='oblita' OR junior_species='oblita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Atheta' AND (species='oblita' OR species='oblita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Atheta' AND (species='oblita' OR species='oblita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Atheta' AND (junior_species='oblita' OR junior_species='oblita')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='Atheta' AND (species='oblita' OR species='oblita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicerus' AND (junior_species='obscurus' OR junior_species='obscurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callicerus' AND (species='obscurus' OR species='obscurus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callicerus' AND (species='obscurus' OR species='obscurus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callicerus' AND (junior_species='obscurus' OR junior_species='obscurus')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='Callicerus' AND (species='obscurus' OR species='obscurus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drusilla' AND (junior_species='canaliculata' OR junior_species='canaliculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drusilla' AND (species='canaliculata' OR species='canaliculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drusilla' AND (species='canaliculata' OR species='canaliculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drusilla' AND (junior_species='canaliculata' OR junior_species='canaliculata')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='Drusilla' AND (species='canaliculata' OR species='canaliculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagria' AND (junior_species='sulcatula' OR junior_species='sulcatula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falagria' AND (species='sulcatula' OR species='sulcatula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falagria' AND (species='sulcatula' OR species='sulcatula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagria' AND (junior_species='sulcatula' OR junior_species='sulcatula')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='Falagria' AND (species='sulcatula' OR species='sulcatula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagrioma' AND (junior_species='thoracica' OR junior_species='thoracica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falagrioma' AND (species='thoracica' OR species='thoracica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falagrioma' AND (species='thoracica' OR species='thoracica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagrioma' AND (junior_species='thoracica' OR junior_species='thoracica')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='Falagrioma' AND (species='thoracica' OR species='thoracica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boreaphilus' 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='Boreaphilus' AND (species='velox' OR species='velox') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boreaphilus' AND (species='velox' OR species='velox')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boreaphilus' 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='Boreaphilus' AND (species='velox' OR species='velox') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omalium' AND (junior_species='caesum' OR junior_species='caesum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omalium' AND (species='caesum' OR species='caesum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omalium' AND (species='caesum' OR species='caesum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omalium' AND (junior_species='caesum' OR junior_species='caesum')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='Omalium' AND (species='caesum' OR species='caesum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraphloeostiba' AND (junior_species='gayndahensis' OR junior_species='gayndahensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraphloeostiba' AND (species='gayndahensis' OR species='gayndahensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraphloeostiba' AND (species='gayndahensis' OR species='gayndahensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraphloeostiba' AND (junior_species='gayndahensis' OR junior_species='gayndahensis')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='Paraphloeostiba' AND (species='gayndahensis' OR species='gayndahensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotylus' AND (junior_species='inustus' OR junior_species='inustus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anotylus' AND (species='inustus' OR species='inustus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anotylus' AND (species='inustus' OR species='inustus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anotylus' AND (junior_species='inustus' OR junior_species='inustus')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='Anotylus' AND (species='inustus' OR species='inustus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astenus' AND (junior_species='lyonessius' OR junior_species='lyonessius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Astenus' AND (species='lyonessius' OR species='lyonessius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Astenus' AND (species='lyonessius' OR species='lyonessius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Astenus' AND (junior_species='lyonessius' OR junior_species='lyonessius')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='Astenus' AND (species='lyonessius' OR species='lyonessius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proteinus' AND (junior_species='ovalis' OR junior_species='ovalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Proteinus' AND (species='ovalis' OR species='ovalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Proteinus' AND (species='ovalis' OR species='ovalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Proteinus' AND (junior_species='ovalis' OR junior_species='ovalis')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='Proteinus' AND (species='ovalis' OR species='ovalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocypus' AND (junior_species='olens' OR junior_species='olens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ocypus' AND (species='olens' OR species='olens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ocypus' AND (species='olens' OR species='olens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ocypus' AND (junior_species='olens' OR junior_species='olens')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='Ocypus' AND (species='olens' OR species='olens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quedius' AND (junior_species='curtipennis' OR junior_species='curtipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quedius' AND (species='curtipennis' OR species='curtipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quedius' AND (species='curtipennis' OR species='curtipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quedius' AND (junior_species='curtipennis' OR junior_species='curtipennis')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='Quedius' AND (species='curtipennis' OR species='curtipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quedius' AND (junior_species='levicollis' OR junior_species='levicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quedius' AND (species='levicollis' OR species='levicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quedius' AND (species='levicollis' OR species='levicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quedius' AND (junior_species='levicollis' OR junior_species='levicollis')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='Quedius' AND (species='levicollis' OR species='levicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quedius' AND (junior_species='meridiocarpathicus' OR junior_species='meridiocarpathicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quedius' AND (species='meridiocarpathicus' OR species='meridiocarpathicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quedius' AND (species='meridiocarpathicus' OR species='meridiocarpathicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quedius' AND (junior_species='meridiocarpathicus' OR junior_species='meridiocarpathicus')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='Quedius' AND (species='meridiocarpathicus' OR species='meridiocarpathicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xantholinus' AND (junior_species='linearis' OR junior_species='linearis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xantholinus' AND (species='linearis' OR species='linearis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xantholinus' AND (species='linearis' OR species='linearis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xantholinus' AND (junior_species='linearis' OR junior_species='linearis')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='Xantholinus' AND (species='linearis' OR species='linearis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyporus' AND (junior_species='nitidulus' OR junior_species='nitidulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyporus' AND (species='nitidulus' OR species='nitidulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyporus' AND (species='nitidulus' OR species='nitidulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyporus' AND (junior_species='nitidulus' OR junior_species='nitidulus')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='Tachyporus' AND (species='nitidulus' OR species='nitidulus') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2373