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=3120 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3120SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2904SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3120 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='sarpedon' OR junior_species='sarpedon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Graphium' AND (species='sarpedon' OR species='sarpedon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Graphium' AND (species='sarpedon' OR species='sarpedon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Graphium' AND (junior_species='sarpedon' OR junior_species='sarpedon')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='Graphium' AND (species='sarpedon' OR species='sarpedon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='xuthus' OR junior_species='xuthus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='xuthus' OR species='xuthus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='xuthus' OR species='xuthus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='xuthus' OR junior_species='xuthus')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='xuthus' OR species='xuthus') 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='Papilio' AND (junior_species='memnon' OR junior_species='memnon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='memnon' OR species='memnon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='memnon' OR species='memnon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='memnon' OR junior_species='memnon')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='memnon' OR species='memnon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='protenor' OR junior_species='protenor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='protenor' OR species='protenor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='protenor' OR species='protenor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='protenor' OR junior_species='protenor')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='protenor' OR species='protenor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Papilio' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Papilio' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Papilio' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptidea' AND (junior_species='amurensis' OR junior_species='amurensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leptidea' AND (species='amurensis' OR species='amurensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leptidea' AND (species='amurensis' OR species='amurensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leptidea' AND (junior_species='amurensis' OR junior_species='amurensis')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='amurensis' OR species='amurensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='spp.' OR junior_species='spp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pieris' AND (species='spp.' OR species='spp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pieris' AND (species='spp.' OR species='spp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pieris' AND (junior_species='spp.' OR junior_species='spp.')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='spp.' OR species='spp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='laeta' OR junior_species='laeta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='laeta' OR species='laeta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='laeta' OR species='laeta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='laeta' OR junior_species='laeta')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='Eurema' AND (species='laeta' OR species='laeta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='mandarina' OR junior_species='mandarina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurema' AND (species='mandarina' OR species='mandarina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurema' AND (species='mandarina' OR species='mandarina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurema' AND (junior_species='mandarina' OR junior_species='mandarina')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='Eurema' AND (species='mandarina' OR species='mandarina') ORDER BY year,last_namesSELECT 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='Curetis' AND (junior_species='acuta' OR junior_species='acuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Curetis' AND (species='acuta' OR species='acuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Curetis' AND (species='acuta' OR species='acuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Curetis' AND (junior_species='acuta' OR junior_species='acuta')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='Curetis' AND (species='acuta' OR species='acuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Narathura' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Narathura' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Narathura' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Narathura' AND (junior_species='japonica' OR junior_species='japonica')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='Narathura' AND (species='japonica' OR species='japonica') 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='Niphanda' AND (junior_species='fusca' OR junior_species='fusca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Niphanda' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Niphanda' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Niphanda' AND (junior_species='fusca' OR junior_species='fusca')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='Niphanda' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizina' AND (junior_species='otis' OR junior_species='otis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizina' AND (species='otis' OR species='otis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizina' AND (species='otis' OR species='otis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizina' AND (junior_species='otis' OR junior_species='otis')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='Zizina' AND (species='otis' OR species='otis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizeeria' AND (junior_species='maha' OR junior_species='maha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zizeeria' AND (species='maha' OR species='maha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zizeeria' AND (species='maha' OR species='maha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zizeeria' AND (junior_species='maha' OR junior_species='maha')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='Zizeeria' AND (species='maha' OR species='maha') 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='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='Shijimiaeoides' AND (junior_species='divinus' OR junior_species='divinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Shijimiaeoides' AND (species='divinus' OR species='divinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Shijimiaeoides' AND (species='divinus' OR species='divinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Shijimiaeoides' AND (junior_species='divinus' OR junior_species='divinus')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='Shijimiaeoides' AND (species='divinus' OR species='divinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libythea' AND (junior_species='lepita' OR junior_species='lepita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Libythea' AND (species='lepita' OR species='lepita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Libythea' AND (species='lepita' OR species='lepita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Libythea' AND (junior_species='lepita' OR junior_species='lepita')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='Libythea' AND (species='lepita' OR species='lepita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araschnia' AND (junior_species='burejana' OR junior_species='burejana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Araschnia' AND (species='burejana' OR species='burejana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Araschnia' AND (species='burejana' OR species='burejana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Araschnia' AND (junior_species='burejana' OR junior_species='burejana')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='burejana' OR species='burejana') 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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='indica' OR junior_species='indica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vanessa' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vanessa' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vanessa' AND (junior_species='indica' OR junior_species='indica')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='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='c-aureum' OR junior_species='c-aureum')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-aureum' OR species='c-aureum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polygonia' AND (species='c-aureum' OR species='c-aureum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polygonia' AND (junior_species='c-aureum' OR junior_species='c-aureum')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-aureum' OR species='c-aureum') 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='Kaniska' AND (junior_species='canace' OR junior_species='canace')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kaniska' AND (species='canace' OR species='canace') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kaniska' AND (species='canace' OR species='canace')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kaniska' AND (junior_species='canace' OR junior_species='canace')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='Kaniska' AND (species='canace' OR species='canace') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyronome' AND (junior_species='laodice' OR junior_species='laodice')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argyronome' AND (species='laodice' OR species='laodice') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argyronome' AND (species='laodice' OR species='laodice')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyronome' AND (junior_species='laodice' OR junior_species='laodice')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='Argyronome' AND (species='laodice' OR species='laodice') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyronome' AND (junior_species='ruslana' OR junior_species='ruslana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argyronome' AND (species='ruslana' OR species='ruslana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argyronome' AND (species='ruslana' OR species='ruslana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyronome' AND (junior_species='ruslana' OR junior_species='ruslana')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='Argyronome' AND (species='ruslana' OR species='ruslana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Damora' AND (junior_species='sagana' OR junior_species='sagana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Damora' AND (species='sagana' OR species='sagana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Damora' AND (species='sagana' OR species='sagana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Damora' AND (junior_species='sagana' OR junior_species='sagana')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='Damora' AND (species='sagana' OR species='sagana') 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='Argyreus' AND (junior_species='hyperbius' OR junior_species='hyperbius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Argyreus' AND (species='hyperbius' OR species='hyperbius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Argyreus' AND (species='hyperbius' OR species='hyperbius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Argyreus' AND (junior_species='hyperbius' OR junior_species='hyperbius')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='Argyreus' AND (species='hyperbius' OR species='hyperbius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichorragia' AND (junior_species='nesimachus' OR junior_species='nesimachus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichorragia' AND (species='nesimachus' OR species='nesimachus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichorragia' AND (species='nesimachus' OR species='nesimachus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichorragia' AND (junior_species='nesimachus' OR junior_species='nesimachus')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='Dichorragia' AND (species='nesimachus' OR species='nesimachus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='sappho' OR junior_species='sappho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neptis' AND (species='sappho' OR species='sappho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neptis' AND (species='sappho' OR species='sappho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neptis' AND (junior_species='sappho' OR junior_species='sappho')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='sappho' OR species='sappho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hestina' AND (junior_species='japonica' OR junior_species='japonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hestina' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hestina' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hestina' AND (junior_species='japonica' OR junior_species='japonica')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='Hestina' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' 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='Ypthima' AND (species='argus' OR species='argus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ypthima' AND (species='argus' OR species='argus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ypthima' 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='Ypthima' AND (species='argus' OR species='argus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kirinia' AND (junior_species='fentoni' OR junior_species='fentonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Kirinia' AND (species='fentoni' OR species='fentonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Kirinia' AND (species='fentoni' OR species='fentonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Kirinia' AND (junior_species='fentoni' OR junior_species='fentonii')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='Kirinia' AND (species='fentoni' OR species='fentonii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Minois' AND (junior_species='dryas' OR junior_species='dryas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Minois' AND (species='dryas' OR species='dryas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Minois' AND (species='dryas' OR species='dryas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Minois' AND (junior_species='dryas' OR junior_species='dryas')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='Minois' AND (species='dryas' OR species='dryas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='phedima' OR junior_species='phedima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitis' AND (species='phedima' OR species='phedima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitis' AND (species='phedima' OR species='phedima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitis' AND (junior_species='phedima' OR junior_species='phedima')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='Melanitis' AND (species='phedima' OR species='phedima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='diana' OR junior_species='diana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lethe' AND (species='diana' OR species='diana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lethe' AND (species='diana' OR species='diana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lethe' AND (junior_species='diana' OR junior_species='diana')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='Lethe' AND (species='diana' OR species='diana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neope' AND (junior_species='niphonica' OR junior_species='niphonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neope' AND (species='niphonica' OR species='niphonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neope' AND (species='niphonica' OR species='niphonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neope' AND (junior_species='niphonica' OR junior_species='niphonica')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='Neope' AND (species='niphonica' OR species='niphonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choaspes' AND (junior_species='benjaminii' OR junior_species='benjamini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Choaspes' AND (species='benjaminii' OR species='benjamini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Choaspes' AND (species='benjaminii' OR species='benjamini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choaspes' AND (junior_species='benjaminii' OR junior_species='benjamini')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='Choaspes' AND (species='benjaminii' OR species='benjamini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daimio' AND (junior_species='tethys' OR junior_species='tethys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Daimio' AND (species='tethys' OR species='tethys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Daimio' AND (species='tethys' OR species='tethys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Daimio' AND (junior_species='tethys' OR junior_species='tethys')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='Daimio' AND (species='tethys' OR species='tethys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thymelicus' AND (species='sylvaticus' OR species='sylvaticus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thymelicus' AND (species='sylvaticus' OR species='sylvaticus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thymelicus' AND (junior_species='sylvaticus' OR junior_species='sylvaticus')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='sylvaticus' OR species='sylvaticus') 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='Potanthus' AND (junior_species='flavus' OR junior_species='flavus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Potanthus' AND (species='flavus' OR species='flavus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Potanthus' AND (species='flavus' OR species='flavus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Potanthus' AND (junior_species='flavus' OR junior_species='flavus')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='Potanthus' AND (species='flavus' OR species='flavus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polytremis' AND (junior_species='pellucida' OR junior_species='pellucida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polytremis' AND (species='pellucida' OR species='pellucida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polytremis' AND (species='pellucida' OR species='pellucida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polytremis' AND (junior_species='pellucida' OR junior_species='pellucida')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='Polytremis' AND (species='pellucida' OR species='pellucida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnara' AND (junior_species='guttata' OR junior_species='guttata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parnara' AND (species='guttata' OR species='guttata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parnara' AND (species='guttata' OR species='guttata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parnara' AND (junior_species='guttata' OR junior_species='guttata')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='Parnara' AND (species='guttata' OR species='guttata') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3120 The Ecological Register: Mt. Aso (non-grazing, 2005)
Mt. Aso (non-grazing, 2005)
Basic information
Sample name: Mt. Aso (non-grazing, 2005)

Reference: K. Murata and A. Matsuura. 2011. Effect of grazing intensity on species diversity of butterfly communities in the habitat of Shijimiaeoides divinus asonis (Matsumura). Lepidoptera Science 62(1):41-50 [ER 2904]
Geography
Country: Japan


Coordinate: 32° 53' N, 131° 6' E
Coordinate basis: based on nearby landmark

Geography comments: "on the volcanic slopes of Mt. Aso" (which is in Aso Kuju National Park)
coordinate is based on Mount Aso

•
Environment
Habitat: montane grassland

Protection: national/state park

Substrate: ground surface

Habitat comments: "grasslands mainly covered with natural herbaceous plants"

Methods
Life forms: butterflies

Sampling methods: line transect,butterfly nets,visual

Sample size: 700 captures or sightings

Years: 2005

Days: 24

Sampling comments: "Butterflies were monitored by the route census method during the flight season (April to October)... for a total of 24 days each year... along a 500 m route taking about 10 minutes... Individuals that were not distinguished in the field were captured for identification and then released"

Metadata
Sample number: 3120

Contributor: John Alroy

Enterer: John Alroy

Created: 2018-12-21 17:05:26

Modified: 2018-12-21 06:05:45

Abundance distribution
48 species
11 singletons
total count 700
extrapolated richness: 78.4
Fisher's α: 11.679
geometric series k: 0.8908
Hurlbert's PIE: 0.8578
Shannon's H: 2.6813
Good's u: 0.9843
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Graphium sarpedon nipponum2
Papilio xuthus1
Papilio machaon hippocrates6
Papilio memnon thunbergii1
Papilio protenor demetrius1
Papilio spp.1
"dehaanii or maackii"
Leptidea amurensis1
Pieris spp.1
"nesis or melete"
Eurema laeta betheseba11
Eurema mandarina56
Colias erate poliographus52
Curetis acuta paracuta5
Narathura japonica3
Lycaena phlaeas daimio36
Niphanda fusca2
Zizina otis emelina3
Zizeeria maha7
Everes argiades9
Celastrina argiolus labonides80
Shijimiaeoides divinus asonis229
Libythea lepita celtoides5
Araschnia burejana strigosa2
Vanessa cardui2
Vanessa indica1
Polygonia c-aureum6
Nymphalis xanthomelas japonica1
Kaniska canace nojaponicum3
Argyronome laodice japonica4
Argyronome ruslana17
Damora sagana liane5
Fabriciana adippe pallescens5
Argyreus hyperbius9
Dichorragia nesimachus nesiotes1
Neptis sappho intermedia4
Hestina japonica3
Ypthima argus43
Kirinia fentoni12
Minois dryas bipunctata16
Melanitis phedima oitensis2
Lethe diana7
Neope niphonica11
Choaspes benjaminii japonica1
Daimio tethys1
Thymelicus sylvaticus7
Ochlodes ochracea5
"Ochlodes ochraceus"
Potanthus flavus2
Polytremis pellucida14
Parnara guttata4