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=3156 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3156SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2956SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3156 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='erate' OR junior_species='erate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colias' AND (species='erate' OR species='erate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colias' AND (species='erate' OR species='erate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colias' AND (junior_species='erate' OR junior_species='erate')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='erate' OR species='erate') 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='Pieris' AND (junior_species='extensa' OR junior_species='extensa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='extensa' OR species='extensa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='extensa' OR species='extensa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='extensa' OR junior_species='extensa')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='extensa' OR species='extensa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='canidia' OR junior_species='canidia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='canidia' OR species='canidia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='canidia' OR species='canidia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='canidia' OR junior_species='canidia')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='canidia' OR species='canidia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='melete' OR junior_species='melete')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='melete' OR species='melete') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='melete' OR species='melete')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='melete' OR junior_species='melete')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='melete' OR species='melete') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonepteryx' AND (junior_species='mahaguru' OR junior_species='mahaguru')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gonepteryx' AND (species='mahaguru' OR species='mahaguru') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gonepteryx' AND (species='mahaguru' OR species='mahaguru')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gonepteryx' AND (junior_species='mahaguru' OR junior_species='mahaguru')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='mahaguru' OR species='mahaguru') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporia' AND (junior_species='hippia' OR junior_species='hippia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aporia' AND (species='hippia' OR species='hippia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aporia' AND (species='hippia' OR species='hippia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aporia' AND (junior_species='hippia' OR junior_species='hippia')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='hippia' OR species='hippia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptidea' AND (junior_species='morsei' OR junior_species='morseii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptidea' AND (species='morsei' OR species='morseii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptidea' AND (species='morsei' OR species='morseii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptidea' AND (junior_species='morsei' OR junior_species='morseii')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='morsei' OR species='morseii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='maackii' OR junior_species='maacki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='maackii' OR species='maacki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='maackii' OR species='maacki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='maackii' OR junior_species='maacki')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='maackii' OR species='maacki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='argus' OR junior_species='argus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plebejus' AND (species='argus' OR species='argus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plebejus' AND (species='argus' OR species='argus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plebejus' AND (junior_species='argus' OR junior_species='argus')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='argus' OR species='argus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Everes' AND (junior_species='argiades' OR junior_species='argiades')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Everes' AND (species='argiades' OR species='argiades') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Everes' AND (species='argiades' OR species='argiades')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Everes' AND (junior_species='argiades' OR junior_species='argiades')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='Everes' AND (species='argiades' OR species='argiades') 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='Fabriciana' AND (junior_species='adippe' OR junior_species='adippe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fabriciana' AND (species='adippe' OR species='adippe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fabriciana' AND (species='adippe' OR species='adippe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fabriciana' AND (junior_species='adippe' OR junior_species='adippe')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='Fabriciana' AND (species='adippe' OR species='adippe') 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='Neptis' AND (junior_species='philyroides' OR junior_species='philyroides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='philyroides' OR species='philyroides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='philyroides' OR species='philyroides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='philyroides' OR junior_species='philyroides')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='Neptis' AND (species='philyroides' OR species='philyroides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='rivularis' OR junior_species='rivularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='rivularis' OR species='rivularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='rivularis' OR species='rivularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='rivularis' OR junior_species='rivularis')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='Neptis' AND (species='rivularis' OR species='rivularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='philyra' OR junior_species='philyra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='philyra' OR species='philyra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='philyra' OR species='philyra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='philyra' OR junior_species='philyra')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='Neptis' AND (species='philyra' OR species='philyra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='pryeri' OR junior_species='pryerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='pryeri' OR species='pryerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='pryeri' OR species='pryerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='pryeri' OR junior_species='pryerii')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='Neptis' AND (species='pryeri' OR species='pryerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='thisbe' OR junior_species='thisbe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='thisbe' OR species='thisbe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='thisbe' OR species='thisbe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='thisbe' OR junior_species='thisbe')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='Neptis' AND (species='thisbe' OR species='thisbe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='vau-album' OR junior_species='vau-album')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphalis' AND (species='vau-album' OR species='vau-album') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphalis' AND (species='vau-album' OR species='vau-album')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='vau-album' OR junior_species='vau-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='Nymphalis' AND (species='vau-album' OR species='vau-album') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='xanthomelas' OR junior_species='xanthomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphalis' AND (species='xanthomelas' OR species='xanthomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphalis' AND (species='xanthomelas' OR species='xanthomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphalis' AND (junior_species='xanthomelas' OR junior_species='xanthomelas')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='xanthomelas' OR species='xanthomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphydryas' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphydryas' AND (species='intermedia' OR species='intermedia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphydryas' AND (species='intermedia' OR species='intermedia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphydryas' AND (junior_species='intermedia' OR junior_species='intermedia')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='Euphydryas' AND (species='intermedia' OR species='intermedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimathyma' AND (junior_species='schrenckii' OR junior_species='schrencki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimathyma' AND (species='schrenckii' OR species='schrencki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimathyma' AND (species='schrenckii' OR species='schrencki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimathyma' AND (junior_species='schrenckii' OR junior_species='schrencki')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='Mimathyma' AND (species='schrenckii' OR species='schrencki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimathyma' AND (junior_species='nycteis' OR junior_species='nycteis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimathyma' AND (species='nycteis' OR species='nycteis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimathyma' AND (species='nycteis' OR species='nycteis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimathyma' AND (junior_species='nycteis' OR junior_species='nycteis')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='Mimathyma' AND (species='nycteis' OR species='nycteis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aldania' AND (junior_species='raddei' OR junior_species='raddeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aldania' AND (species='raddei' OR species='raddeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aldania' AND (species='raddei' OR species='raddeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aldania' AND (junior_species='raddei' OR junior_species='raddeii')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='Aldania' AND (species='raddei' OR species='raddeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apatura' AND (junior_species='ilia' OR junior_species='ilia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apatura' AND (species='ilia' OR species='ilia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apatura' AND (species='ilia' OR species='ilia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apatura' AND (junior_species='ilia' OR junior_species='ilia')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='Apatura' AND (species='ilia' OR species='ilia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apatura' AND (junior_species='laverna' OR junior_species='laverna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apatura' AND (species='laverna' OR species='laverna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apatura' AND (species='laverna' OR species='laverna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apatura' AND (junior_species='laverna' OR junior_species='laverna')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='Apatura' AND (species='laverna' OR species='laverna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apatura' AND (junior_species='metis' OR junior_species='metis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apatura' AND (species='metis' OR species='metis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apatura' AND (species='metis' OR species='metis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apatura' AND (junior_species='metis' OR junior_species='metis')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='Apatura' AND (species='metis' OR species='metis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apatura' AND (junior_species='iris' OR junior_species='iris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apatura' AND (species='iris' OR species='iris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apatura' AND (species='iris' OR species='iris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apatura' AND (junior_species='iris' OR junior_species='iris')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='Apatura' AND (species='iris' OR species='iris') 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='Limenitis' AND (junior_species='moltrechti' OR junior_species='moltrechtii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limenitis' AND (species='moltrechti' OR species='moltrechtii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limenitis' AND (species='moltrechti' OR species='moltrechtii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='moltrechti' OR junior_species='moltrechtii')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='Limenitis' AND (species='moltrechti' OR species='moltrechtii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='homeyeri' OR junior_species='homeyerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limenitis' AND (species='homeyeri' OR species='homeyerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limenitis' AND (species='homeyeri' OR species='homeyerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='homeyeri' OR junior_species='homeyerii')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='Limenitis' AND (species='homeyeri' OR species='homeyerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='helmanni' OR junior_species='helmannii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limenitis' AND (species='helmanni' OR species='helmannii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limenitis' AND (species='helmanni' OR species='helmannii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='helmanni' OR junior_species='helmannii')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='Limenitis' AND (species='helmanni' OR species='helmannii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' 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='Limenitis' AND (species='camilla' OR species='camilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limenitis' AND (species='camilla' OR species='camilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' 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='Limenitis' AND (species='camilla' OR species='camilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='sydyi' OR junior_species='sydyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Limenitis' AND (species='sydyi' OR species='sydyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Limenitis' AND (species='sydyi' OR species='sydyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Limenitis' AND (junior_species='sydyi' OR junior_species='sydyii')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='Limenitis' AND (species='sydyi' OR species='sydyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brenthis' AND (junior_species='daphne' OR junior_species='daphne')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brenthis' AND (species='daphne' OR species='daphne') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brenthis' AND (species='daphne' OR species='daphne')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brenthis' AND (junior_species='daphne' OR junior_species='daphne')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='daphne' OR species='daphne') 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='Clossiana' AND (junior_species='thore' OR junior_species='thore')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clossiana' AND (species='thore' OR species='thore') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clossiana' AND (species='thore' OR species='thore')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clossiana' AND (junior_species='thore' OR junior_species='thore')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='Clossiana' AND (species='thore' OR species='thore') 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='Araschnia' AND (junior_species='prorsoides' OR junior_species='prorsoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Araschnia' AND (species='prorsoides' OR species='prorsoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Araschnia' AND (species='prorsoides' OR species='prorsoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araschnia' AND (junior_species='prorsoides' OR junior_species='prorsoides')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='prorsoides' OR species='prorsoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropterus' AND (junior_species='morpheus' OR junior_species='morpheus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heteropterus' AND (species='morpheus' OR species='morpheus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heteropterus' AND (species='morpheus' OR species='morpheus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heteropterus' AND (junior_species='morpheus' OR junior_species='morpheus')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='Heteropterus' AND (species='morpheus' OR species='morpheus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='ochracea' OR junior_species='ochracea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochlodes' AND (species='ochracea' OR species='ochracea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochlodes' AND (species='ochracea' OR species='ochracea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochlodes' AND (junior_species='ochracea' OR junior_species='ochracea')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='ochracea' OR species='ochracea') 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='Erebia' AND (junior_species='neriere' OR junior_species='neriere')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erebia' AND (species='neriere' OR species='neriere') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erebia' AND (species='neriere' OR species='neriere')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erebia' AND (junior_species='neriere' OR junior_species='neriere')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='Erebia' AND (species='neriere' OR species='neriere') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='motschulskyi' OR junior_species='motschulskyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ypthima' AND (species='motschulskyi' OR species='motschulskyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='motschulskyi' OR species='motschulskyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' AND (junior_species='motschulskyi' OR junior_species='motschulskyii')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='Ypthima' AND (species='motschulskyi' OR species='motschulskyii') 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='Ninguta' AND (junior_species='schrenkii' OR junior_species='schrenki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ninguta' AND (species='schrenkii' OR species='schrenki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ninguta' AND (species='schrenkii' OR species='schrenki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ninguta' AND (junior_species='schrenkii' OR junior_species='schrenki')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='Ninguta' AND (species='schrenkii' OR species='schrenki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='hero' OR junior_species='hero')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coenonympha' AND (species='hero' OR species='hero') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coenonympha' AND (species='hero' OR species='hero')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coenonympha' AND (junior_species='hero' OR junior_species='hero')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='hero' OR species='hero') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3156 The Ecological Register: Liangshui Nature Reserve (original forest)
Liangshui Nature Reserve (original forest)
Basic information
Sample name: Liangshui Nature Reserve (original forest)

Reference: W. Gu, L. Ma, Z. Liu, Y. Jiao, L. Wang, C. Zhang, H. Sun, and M. Sun. 2015. Diversity of butterflies in Liangshui nature reserves of Xiao Xing'an Mountains. Acta Ecologica Sinica 35(22):7387-7396 [ER 2956]
Geography
Country: China

State: Heilongjiang


Coordinate: 47° 10' 50" N, 128° 53' 20" E
Coordinate basis: stated in text

Geography comments: "in the eastern part of Dalidailing Mountain"
coordinate is for the Liangshui Nature Reserve and is from Xu et al. (2015, Chinese Journal of Ecology 35:2449-2454)

•
Environment
Habitat: temperate broadleaf/mixed forest

Protection: nature reserve

Substrate: ground surface

MAT: -0.3

MAP: 680.0

Habitat comments: "temperate continental monsoon climate" with "broad-leaved Korean pine forest"

Methods
Life forms: butterflies

Sampling methods: line transect,butterfly nets

Sample size: 524 individuals

Years: 2013

Seasons: summer

Sampling comments: "net-catching" was "the main method to collect"
collecting was from "mid-June to the end of August" in 2012 and 2013, but the survey data are only from 2013
a 2 km transect was sampled in each area

Metadata
Sample number: 3156

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-12-31 17:22:48

Modified: 2018-12-31 06:22:48

Abundance distribution
50 species
12 singletons
total count 524
extrapolated richness: 85.9
Fisher's α: 13.597
geometric series k: 0.9178
Hurlbert's PIE: 0.9357
Shannon's H: 3.1243
Good's u: 0.9772
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Colias erate1
Pieris napi4
Pieris rapae2
Pieris extensa2
Pieris canidia30
Pieris melete1
Gonepteryx mahaguru41
Aporia crataegi9
Aporia hippia3
Leptidea morsei1
Papilio maackii67
Plebejus argus3
Everes argiades6
Argynnis paphia10
Fabriciana adippe4
Polygonia c-album51
Neptis philyroides16
Neptis rivularis56
Neptis philyra29
Neptis pryeri2
Neptis thisbe3
Nymphalis vau-album1
Nymphalis xanthomelas3
Euphydryas intermedia2
Mimathyma schrenckii9
Mimathyma nycteis7
Aldania raddei4
Apatura ilia1
Apatura laverna1
Apatura metis1
Apatura iris9
Melitaea diamina1
Limenitis moltrechti1
Limenitis homeyeri4
Limenitis helmanni7
Limenitis camilla1
Limenitis sydyi1
Brenthis daphne2
Brenthis ino1
Clossiana thore2
Araschnia levana37
Araschnia prorsoides2
Heteropterus morpheus7
Ochlodes ochracea3
Aphantopus hyperantus29
Erebia neriere2
Ypthima motschulskyi23
Lopinga achine2
Ninguta schrenkii17
Coenonympha hero3