Coordinate: 48° 21' N, 106° 14' E
collection was made on 15 July 2006
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=3149 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3149SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2954SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3149 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muschampia' AND (junior_species='cribrellum' OR junior_species='cribrellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Muschampia' AND (species='cribrellum' OR species='cribrellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Muschampia' AND (species='cribrellum' OR species='cribrellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Muschampia' AND (junior_species='cribrellum' OR junior_species='cribrellum')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='Muschampia' AND (species='cribrellum' OR species='cribrellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albulina' AND (junior_species='orbitulus' OR junior_species='orbitulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Albulina' AND (species='orbitulus' OR species='orbitulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Albulina' AND (species='orbitulus' OR species='orbitulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Albulina' AND (junior_species='orbitulus' OR junior_species='orbitulus')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='Albulina' AND (species='orbitulus' OR species='orbitulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aricia' AND (junior_species='allous' OR junior_species='allous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aricia' AND (species='allous' OR species='allous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aricia' AND (species='allous' OR species='allous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aricia' AND (junior_species='allous' OR junior_species='allous')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='Aricia' AND (species='allous' OR species='allous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aricia' AND (junior_species='eumedon' OR junior_species='eumedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aricia' AND (species='eumedon' OR species='eumedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aricia' AND (species='eumedon' OR species='eumedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aricia' AND (junior_species='eumedon' OR junior_species='eumedon')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='Aricia' AND (species='eumedon' OR species='eumedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maculinea' AND (junior_species='teleius' OR junior_species='teleius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maculinea' AND (species='teleius' OR species='teleius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maculinea' AND (species='teleius' OR species='teleius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maculinea' AND (junior_species='teleius' OR junior_species='teleius')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='Maculinea' AND (species='teleius' OR species='teleius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='subsolanus' OR junior_species='subsolanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plebejus' AND (species='subsolanus' OR species='subsolanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plebejus' AND (species='subsolanus' OR species='subsolanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='subsolanus' OR junior_species='subsolanus')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='Plebejus' AND (species='subsolanus' OR species='subsolanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphanthopus' AND (junior_species='hyperanthus' OR junior_species='hyperanthus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphanthopus' AND (species='hyperanthus' OR species='hyperanthus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphanthopus' AND (species='hyperanthus' OR species='hyperanthus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphanthopus' AND (junior_species='hyperanthus' OR junior_species='hyperanthus')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='Aphanthopus' AND (species='hyperanthus' OR species='hyperanthus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brenthis' AND (junior_species='ino' OR junior_species='ino')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brenthis' AND (species='ino' OR species='ino') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brenthis' AND (species='ino' OR species='ino')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brenthis' AND (junior_species='ino' OR junior_species='ino')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='Brenthis' AND (species='ino' OR species='ino') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='glycerion' OR junior_species='glycerion')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='glycerion' OR species='glycerion') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='glycerion' OR species='glycerion')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='glycerion' OR junior_species='glycerion')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='Coenonympha' AND (species='glycerion' OR species='glycerion') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='oedippus' OR junior_species='oedippus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='oedippus' OR species='oedippus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='oedippus' OR species='oedippus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='oedippus' OR junior_species='oedippus')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='Coenonympha' AND (species='oedippus' OR species='oedippus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lopinga' AND (junior_species='achine' OR junior_species='achine')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lopinga' AND (species='achine' OR species='achine') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lopinga' AND (species='achine' OR species='achine')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lopinga' AND (junior_species='achine' OR junior_species='achine')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='Lopinga' AND (species='achine' OR species='achine') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaea' AND (junior_species='centralasiae' OR junior_species='centralasiae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melitaea' AND (species='centralasiae' OR species='centralasiae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melitaea' AND (species='centralasiae' OR species='centralasiae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaea' AND (junior_species='centralasiae' OR junior_species='centralasiae')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='Melitaea' AND (species='centralasiae' OR species='centralasiae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaea' AND (junior_species='diamina' OR junior_species='diamina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melitaea' AND (species='diamina' OR species='diamina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melitaea' AND (species='diamina' OR species='diamina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitaea' AND (junior_species='diamina' OR junior_species='diamina')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='Melitaea' AND (species='diamina' OR species='diamina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporia' AND (junior_species='crataegi' OR junior_species='crataegii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporia' AND (species='crataegi' OR species='crataegii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporia' AND (species='crataegi' OR species='crataegii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporia' AND (junior_species='crataegi' OR junior_species='crataegii')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='Aporia' AND (species='crataegi' OR species='crataegii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3149