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=1169 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1169SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=820SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1169 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='pamphilus' OR junior_species='pamphilus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='pamphilus' OR species='pamphilus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='pamphilus' OR species='pamphilus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='pamphilus' OR junior_species='pamphilus')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='pamphilus' OR species='pamphilus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='icarus' OR junior_species='icarus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='icarus' OR species='icarus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='icarus' OR species='icarus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='icarus' OR junior_species='icarus')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='Polyommatus' AND (species='icarus' OR species='icarus') 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='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='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='Lycaena' AND (junior_species='phlaeas' OR junior_species='phlaeas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='phlaeas' OR species='phlaeas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='phlaeas' OR species='phlaeas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='phlaeas' OR junior_species='phlaeas')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='Lycaena' AND (species='phlaeas' OR species='phlaeas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boloria' AND (junior_species='dia' OR junior_species='dia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Boloria' AND (species='dia' OR species='dia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Boloria' AND (species='dia' OR species='dia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Boloria' AND (junior_species='dia' OR junior_species='dia')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='dia' OR species='dia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='lineola' OR junior_species='lineola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thymelicus' AND (species='lineola' OR species='lineola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thymelicus' AND (species='lineola' OR species='lineola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='lineola' OR junior_species='lineola')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='lineola' OR species='lineola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araschnia' AND (junior_species='levana' OR junior_species='levana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Araschnia' AND (species='levana' OR species='levana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Araschnia' AND (species='levana' OR species='levana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araschnia' AND (junior_species='levana' OR junior_species='levana')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='Araschnia' AND (species='levana' OR species='levana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erynnis' AND (junior_species='tages' OR junior_species='tages')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erynnis' AND (species='tages' OR species='tages') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erynnis' AND (species='tages' OR species='tages')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erynnis' AND (junior_species='tages' OR junior_species='tages')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='Erynnis' AND (species='tages' OR species='tages') 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='Lycaena' AND (junior_species='tityrus' OR junior_species='tityrus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='tityrus' OR species='tityrus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='tityrus' OR species='tityrus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='tityrus' OR junior_species='tityrus')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='Lycaena' AND (species='tityrus' OR species='tityrus') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phengaris' AND (junior_species='nausithous' OR junior_species='nausithous')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phengaris' AND (species='nausithous' OR species='nausithous') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phengaris' AND (species='nausithous' OR species='nausithous')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phengaris' AND (junior_species='nausithous' OR junior_species='nausithous')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='Phengaris' AND (species='nausithous' OR species='nausithous') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='rubi' OR junior_species='rubii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Callophrys' AND (species='rubi' OR species='rubii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Callophrys' AND (species='rubi' OR species='rubii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Callophrys' AND (junior_species='rubi' OR junior_species='rubii')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='Callophrys' AND (species='rubi' OR species='rubii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptidea' AND (junior_species='reali' OR junior_species='realii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptidea' AND (species='reali' OR species='realii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptidea' AND (species='reali' OR species='realii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptidea' AND (junior_species='reali' OR junior_species='realii')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='Leptidea' AND (species='reali' OR species='realii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='malvae' OR junior_species='malvae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pyrgus' AND (species='malvae' OR species='malvae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pyrgus' AND (species='malvae' OR species='malvae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pyrgus' AND (junior_species='malvae' OR junior_species='malvae')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='Pyrgus' AND (species='malvae' OR species='malvae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocharis' AND (junior_species='cardamines' OR junior_species='cardamines')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anthocharis' AND (species='cardamines' OR species='cardamines') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anthocharis' AND (species='cardamines' OR species='cardamines')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anthocharis' AND (junior_species='cardamines' OR junior_species='cardamines')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='Anthocharis' AND (species='cardamines' OR species='cardamines') 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='Aglais' AND (junior_species='urticae' OR junior_species='urticae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglais' AND (species='urticae' OR species='urticae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglais' AND (species='urticae' OR species='urticae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglais' AND (junior_species='urticae' OR junior_species='urticae')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='Aglais' AND (species='urticae' OR species='urticae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lassiomata' 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='Lassiomata' AND (species='megera' OR species='megera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lassiomata' AND (species='megera' OR species='megera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lassiomata' 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='Lassiomata' AND (species='megera' OR species='megera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inachis' AND (junior_species='io' OR junior_species='io')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Inachis' AND (species='io' OR species='io') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Inachis' AND (species='io' OR species='io')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Inachis' AND (junior_species='io' OR junior_species='io')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='Inachis' AND (species='io' OR species='io') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phengaris' 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='Phengaris' AND (species='teleius' OR species='teleius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phengaris' AND (species='teleius' OR species='teleius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phengaris' 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='Phengaris' AND (species='teleius' OR species='teleius') ORDER BY year,last_namesSELECT 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='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='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='Issoria' AND (junior_species='lathonia' OR junior_species='lathonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Issoria' AND (species='lathonia' OR species='lathonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Issoria' AND (species='lathonia' OR species='lathonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Issoria' AND (junior_species='lathonia' OR junior_species='lathonia')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='Issoria' AND (species='lathonia' OR species='lathonia') 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='Ochlodes' AND (junior_species='sylvanus' OR junior_species='sylvanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlodes' AND (species='sylvanus' OR species='sylvanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlodes' AND (species='sylvanus' OR species='sylvanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='sylvanus' OR junior_species='sylvanus')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='sylvanus' OR species='sylvanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='argyrognomon' OR junior_species='argyrognomon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plebejus' AND (species='argyrognomon' OR species='argyrognomon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plebejus' AND (species='argyrognomon' OR species='argyrognomon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='argyrognomon' OR junior_species='argyrognomon')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='argyrognomon' OR species='argyrognomon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argynnis' AND (junior_species='aglaja' OR junior_species='aglaja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argynnis' AND (species='aglaja' OR species='aglaja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argynnis' AND (species='aglaja' OR species='aglaja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argynnis' AND (junior_species='aglaja' OR junior_species='aglaja')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='aglaja' OR species='aglaja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitea' AND (junior_species='athalia' OR junior_species='athalia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melitea' AND (species='athalia' OR species='athalia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melitea' AND (species='athalia' OR species='athalia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melitea' AND (junior_species='athalia' OR junior_species='athalia')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='Melitea' AND (species='athalia' OR species='athalia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='machaon' OR junior_species='machaon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='machaon' OR species='machaon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='machaon' OR species='machaon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='machaon' OR junior_species='machaon')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='Papilio' AND (species='machaon' OR species='machaon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='atalanta' OR junior_species='atalanta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='atalanta' OR species='atalanta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='atalanta' OR species='atalanta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='atalanta' OR junior_species='atalanta')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='Vanessa' AND (species='atalanta' OR species='atalanta') 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='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Celastrina' AND (species='argiolus' OR species='argiolus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Celastrina' AND (species='argiolus' OR species='argiolus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Celastrina' AND (junior_species='argiolus' OR junior_species='argiolus')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='Celastrina' AND (species='argiolus' OR species='argiolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='hyale' OR junior_species='hyale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='hyale' OR species='hyale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='hyale' OR species='hyale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='hyale' OR junior_species='hyale')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='Colias' AND (species='hyale' OR species='hyale') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='virgaureae' OR junior_species='virgaureae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycaena' AND (species='virgaureae' OR species='virgaureae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycaena' AND (species='virgaureae' OR species='virgaureae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycaena' AND (junior_species='virgaureae' OR junior_species='virgaureae')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='Lycaena' AND (species='virgaureae' OR species='virgaureae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='antiopa' OR junior_species='antiopa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphalis' AND (species='antiopa' OR species='antiopa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphalis' AND (species='antiopa' OR species='antiopa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='antiopa' OR junior_species='antiopa')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='Nymphalis' AND (species='antiopa' OR species='antiopa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='c-album' OR junior_species='c-album')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polygonia' AND (species='c-album' OR species='c-album') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonia' AND (species='c-album' OR species='c-album')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='c-album' OR junior_species='c-album')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='Polygonia' AND (species='c-album' OR species='c-album') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='coridon' OR junior_species='coridon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polyommatus' AND (species='coridon' OR species='coridon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polyommatus' AND (species='coridon' OR species='coridon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polyommatus' AND (junior_species='coridon' OR junior_species='coridon')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='Polyommatus' AND (species='coridon' OR species='coridon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' 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='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='cardui' OR species='carduii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' 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='Vanessa' AND (species='cardui' OR species='carduii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1169 The Ecological Register: Southern Poland
Southern Poland
Basic information
Sample name: Southern Poland

Reference: P. Skórka, M. Lenda, D. Morón, K. Kalarus, and P. Tryjanowski. 2013. Factors affecting road mortality and the suitability of road verges for butterflies. Biological Conservation 159:148-157 [ER 820]
Geography
Country: Poland


Coordinate: 50° 20' N, 21° 0' E
Coordinate basis: estimated from map

Geography comments: "in the environs of the cities of Kraków, Tarnów and Rzeszów" (coordinate is the approximate median of points shown on a map)

•
Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: cropland

Substrate: ground surface

MAT: 8.2

WMT: 18.5

CMT: -3.0

MAP: 645.0

Habitat comments: crops cover 54% of the study area, grasslands 10%, fallow 10%, forests 14%, and settlements 10%

Methods
Life forms: butterflies

Sites: 60

Sampling methods: line transect,visual

Sample size: 7713 individuals

Years: 2010

Seasons: spring,summer

Sampling comments: 60 200 m transects, each consisting of "two parallel lines, one on either side of the road" and each surveyed 12 times for about 20 minutes

Metadata
Sample number: 1169

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-09-23 20:02:41

Modified: 2014-09-23 10:02:41

Abundance distribution
42 species
0 singletons
total count 7713
extrapolated richness: 43.4
Fisher's α: 5.845
geometric series k: 0.8652
Hurlbert's PIE: 0.9402
Shannon's H: 3.1848
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Coenonympha pamphilus1138
Polyommatus icarus616
Pieris napi356
Pieris rapae836
Aphantopus hyperantus470
Lycaena phlaeas103
Boloria dia121
Thymelicus lineola214
Araschnia levana153
Erynnis tages174
Coenonympha glycerion49
Lycaena tityrus89
Thymelicus sylvestris166
Phengaris nausithous68
Callophrys rubi57
Leptidea reali48
Pyrgus malvae120
Anthocharis cardamines357
Maniola jurtina321
Aglais urticae273
Lassiomata megera114
Inachis io193
Phengaris teleius57
Pieris brassicae294
Brenthis ino57
Gonepteryx rhamni269
Issoria lathonia159
Melanargia galathea140
Ochlodes sylvanus55
Plebejus argyrognomon3
Argynnis aglaja4
Melitea athalia17
Papilio machaon206
Vanessa atalanta152
Argynnis paphia19
Celastrina argiolus18
Colias hyale68
Lycaena virgaureae28
Nymphalis antiopa6
Polygonia c-album8
Polyommatus coridon40
Vanessa cardui77