Coordinate: 47° 20' N, 10° 12' E
climate data apply to the province
MAT 2 to 4ยบ C
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=2136 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2136SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2145SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2136 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphocerus' AND (junior_species='sibiricus' OR junior_species='sibiricus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gomphocerus' AND (species='sibiricus' OR species='sibiricus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gomphocerus' AND (species='sibiricus' OR species='sibiricus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gomphocerus' AND (junior_species='sibiricus' OR junior_species='sibiricus')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='Gomphocerus' AND (species='sibiricus' OR species='sibiricus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='montanus' OR junior_species='montanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='montanus' OR species='montanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='montanus' OR species='montanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='montanus' OR junior_species='montanus')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='Chorthippus' AND (species='montanus' OR species='montanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='parallelus' OR junior_species='parallelus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chorthippus' AND (species='parallelus' OR species='parallelus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chorthippus' AND (species='parallelus' OR species='parallelus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chorthippus' AND (junior_species='parallelus' OR junior_species='parallelus')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='Chorthippus' AND (species='parallelus' OR species='parallelus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decticus' AND (junior_species='verrucivorus' OR junior_species='verrucivorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Decticus' AND (species='verrucivorus' OR species='verrucivorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Decticus' AND (species='verrucivorus' OR species='verrucivorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Decticus' AND (junior_species='verrucivorus' OR junior_species='verrucivorus')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='Decticus' AND (species='verrucivorus' OR species='verrucivorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miramella' AND (junior_species='alpina' OR junior_species='alpina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miramella' AND (species='alpina' OR species='alpina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miramella' AND (species='alpina' OR species='alpina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miramella' AND (junior_species='alpina' OR junior_species='alpina')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='Miramella' AND (species='alpina' OR species='alpina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='viridulus' OR junior_species='viridulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omocestus' AND (species='viridulus' OR species='viridulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omocestus' AND (species='viridulus' OR species='viridulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omocestus' AND (junior_species='viridulus' OR junior_species='viridulus')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='Omocestus' AND (species='viridulus' OR species='viridulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pholidoptera' AND (junior_species='aptera' OR junior_species='aptera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pholidoptera' AND (species='aptera' OR species='aptera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pholidoptera' AND (species='aptera' OR species='aptera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pholidoptera' AND (junior_species='aptera' OR junior_species='aptera')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='Pholidoptera' AND (species='aptera' OR species='aptera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenobothrus' AND (junior_species='lineatus' OR junior_species='lineatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenobothrus' AND (species='lineatus' OR species='lineatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenobothrus' AND (species='lineatus' OR species='lineatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenobothrus' AND (junior_species='lineatus' OR junior_species='lineatus')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='Stenobothrus' AND (species='lineatus' OR species='lineatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stethophyma' AND (junior_species='grossum' OR junior_species='grossum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stethophyma' AND (species='grossum' OR species='grossum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stethophyma' AND (species='grossum' OR species='grossum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stethophyma' AND (junior_species='grossum' OR junior_species='grossum')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='Stethophyma' AND (species='grossum' OR species='grossum') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2136