Coordinate: 50° 48' N, 1° 59' W
climate data based on station 3862 (Bournemouth Airport)
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=1320 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1320SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=831SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1320 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='brassicae' OR junior_species='brassicae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='brassicae' OR species='brassicae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='brassicae' OR species='brassicae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='brassicae' OR junior_species='brassicae')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='Pieris' AND (species='brassicae' OR species='brassicae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='rapae' OR species='rapae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='rapae' OR species='rapae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='rapae' OR junior_species='rapae')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='Pieris' AND (species='rapae' OR species='rapae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='napi' OR junior_species='napii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='napi' OR species='napii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='napi' OR species='napii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='napi' OR junior_species='napii')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='Pieris' AND (species='napi' OR species='napii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanargia' AND (junior_species='galathea' OR junior_species='galathea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanargia' AND (species='galathea' OR species='galathea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanargia' AND (species='galathea' OR species='galathea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanargia' AND (junior_species='galathea' OR junior_species='galathea')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='Melanargia' AND (species='galathea' OR species='galathea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonepteryx' AND (junior_species='rhamni' OR junior_species='rhamnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonepteryx' AND (species='rhamni' OR species='rhamnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonepteryx' AND (species='rhamni' OR species='rhamnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonepteryx' AND (junior_species='rhamni' OR junior_species='rhamnii')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='Gonepteryx' AND (species='rhamni' OR species='rhamnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pararge' AND (junior_species='aegeria' OR junior_species='aegeria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pararge' AND (species='aegeria' OR species='aegeria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pararge' AND (species='aegeria' OR species='aegeria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pararge' AND (junior_species='aegeria' OR junior_species='aegeria')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='Pararge' AND (species='aegeria' OR species='aegeria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maniola' AND (junior_species='jurtina' OR junior_species='jurtina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maniola' AND (species='jurtina' OR species='jurtina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maniola' AND (species='jurtina' OR species='jurtina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maniola' AND (junior_species='jurtina' OR junior_species='jurtina')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='Maniola' AND (species='jurtina' OR species='jurtina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiommata' AND (junior_species='megera' OR junior_species='megera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiommata' AND (species='megera' OR species='megera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiommata' AND (species='megera' OR species='megera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiommata' AND (junior_species='megera' OR junior_species='megera')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='Lasiommata' AND (species='megera' OR species='megera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyronia' AND (junior_species='tithonus' OR junior_species='tithonus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyronia' AND (species='tithonus' OR species='tithonus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyronia' AND (species='tithonus' OR species='tithonus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyronia' AND (junior_species='tithonus' OR junior_species='tithonus')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='Pyronia' AND (species='tithonus' OR species='tithonus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphantopus' AND (junior_species='hyperantus' OR junior_species='hyperantus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphantopus' AND (species='hyperantus' OR species='hyperantus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphantopus' AND (species='hyperantus' OR species='hyperantus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphantopus' AND (junior_species='hyperantus' OR junior_species='hyperantus')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='Aphantopus' AND (species='hyperantus' OR species='hyperantus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynthia' AND (junior_species='cardui' OR junior_species='carduii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cynthia' AND (species='cardui' OR species='carduii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cynthia' AND (species='cardui' OR species='carduii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cynthia' AND (junior_species='cardui' OR junior_species='carduii')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='Cynthia' AND (species='cardui' OR species='carduii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagoda' AND (junior_species='camilla' OR junior_species='camilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lagoda' AND (species='camilla' OR species='camilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lagoda' AND (species='camilla' OR species='camilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lagoda' AND (junior_species='camilla' OR junior_species='camilla')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='Lagoda' AND (species='camilla' OR species='camilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boloria' AND (junior_species='euphrosyne' OR junior_species='euphrosyne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boloria' AND (species='euphrosyne' OR species='euphrosyne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boloria' AND (species='euphrosyne' OR species='euphrosyne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boloria' AND (junior_species='euphrosyne' OR junior_species='euphrosyne')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='Boloria' AND (species='euphrosyne' OR species='euphrosyne') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argynnis' AND (junior_species='paphia' OR junior_species='paphia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argynnis' AND (species='paphia' OR species='paphia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argynnis' AND (species='paphia' OR species='paphia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argynnis' AND (junior_species='paphia' OR junior_species='paphia')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='Argynnis' AND (species='paphia' OR species='paphia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='venatus' OR junior_species='venatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlodes' AND (species='venatus' OR species='venatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlodes' AND (species='venatus' OR species='venatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='venatus' OR junior_species='venatus')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='Ochlodes' AND (species='venatus' OR species='venatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='sylvestris' OR junior_species='sylvestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thymelicus' AND (species='sylvestris' OR species='sylvestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thymelicus' AND (species='sylvestris' OR species='sylvestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='sylvestris' OR junior_species='sylvestris')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='Thymelicus' AND (species='sylvestris' OR species='sylvestris') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1320