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=1530 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1530SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1033SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1530 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiplema' AND (junior_species='plagifera' OR junior_species='plagifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epiplema' AND (species='plagifera' OR species='plagifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epiplema' AND (species='plagifera' OR species='plagifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epiplema' AND (junior_species='plagifera' OR junior_species='plagifera')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='Epiplema' AND (species='plagifera' OR species='plagifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroclystis' AND (junior_species='v-ata' OR junior_species='v-ata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloroclystis' AND (species='v-ata' OR species='v-ata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroclystis' AND (species='v-ata' OR species='v-ata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroclystis' AND (junior_species='v-ata' OR junior_species='v-ata')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='Chloroclystis' AND (species='v-ata' OR species='v-ata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Descoreba' AND (junior_species='simplex' OR junior_species='simplex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Descoreba' AND (species='simplex' OR species='simplex') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Descoreba' AND (species='simplex' OR species='simplex')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Descoreba' AND (junior_species='simplex' OR junior_species='simplex')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='Descoreba' AND (species='simplex' OR species='simplex') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectropis' AND (junior_species='aigneri' OR junior_species='aignerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectropis' AND (species='aigneri' OR species='aignerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectropis' AND (species='aigneri' OR species='aignerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectropis' AND (junior_species='aigneri' OR junior_species='aignerii')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='Ectropis' AND (species='aigneri' OR species='aignerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectropis' AND (junior_species='excellens' OR junior_species='excellens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectropis' AND (species='excellens' OR species='excellens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectropis' AND (species='excellens' OR species='excellens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectropis' AND (junior_species='excellens' OR junior_species='excellens')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='Ectropis' AND (species='excellens' OR species='excellens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eilicrinia' AND (junior_species='paryula' OR junior_species='paryula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eilicrinia' AND (species='paryula' OR species='paryula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eilicrinia' AND (species='paryula' OR species='paryula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eilicrinia' AND (junior_species='paryula' OR junior_species='paryula')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='Eilicrinia' AND (species='paryula' OR species='paryula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='clavifera' OR junior_species='clavifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupithecia' AND (species='clavifera' OR species='clavifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupithecia' AND (species='clavifera' OR species='clavifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='clavifera' OR junior_species='clavifera')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='Eupithecia' AND (species='clavifera' OR species='clavifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evecliptopera' AND (junior_species='decurrens' OR junior_species='decurrens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Evecliptopera' AND (species='decurrens' OR species='decurrens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Evecliptopera' AND (species='decurrens' OR species='decurrens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Evecliptopera' AND (junior_species='decurrens' OR junior_species='decurrens')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='Evecliptopera' AND (species='decurrens' OR species='decurrens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnoscelis' AND (junior_species='esakii' OR junior_species='esaki')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnoscelis' AND (species='esakii' OR species='esaki') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnoscelis' AND (species='esakii' OR species='esaki')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnoscelis' AND (junior_species='esakii' OR junior_species='esaki')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='Gymnoscelis' AND (species='esakii' OR species='esaki') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterolocha' AND (junior_species='aristonaria' OR junior_species='aristonaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heterolocha' AND (species='aristonaria' OR species='aristonaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterolocha' AND (species='aristonaria' OR species='aristonaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterolocha' AND (junior_species='aristonaria' OR junior_species='aristonaria')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='Heterolocha' AND (species='aristonaria' OR species='aristonaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterothera' AND (junior_species='postalbida' OR junior_species='postalbida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Heterothera' AND (species='postalbida' OR species='postalbida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Heterothera' AND (species='postalbida' OR species='postalbida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Heterothera' AND (junior_species='postalbida' OR junior_species='postalbida')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='Heterothera' AND (species='postalbida' OR species='postalbida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypomecis' AND (junior_species='pseudopunctinalis' OR junior_species='pseudopunctinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypomecis' AND (species='pseudopunctinalis' OR species='pseudopunctinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypomecis' AND (species='pseudopunctinalis' OR species='pseudopunctinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypomecis' AND (junior_species='pseudopunctinalis' OR junior_species='pseudopunctinalis')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='Hypomecis' AND (species='pseudopunctinalis' OR species='pseudopunctinalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypomecis' AND (junior_species='punctinalis' OR junior_species='punctinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypomecis' AND (species='punctinalis' OR species='punctinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypomecis' AND (species='punctinalis' OR species='punctinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypomecis' AND (junior_species='punctinalis' OR junior_species='punctinalis')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='Hypomecis' AND (species='punctinalis' OR species='punctinalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idiotephria' AND (junior_species='amelia' OR junior_species='amelia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idiotephria' AND (species='amelia' OR species='amelia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idiotephria' AND (species='amelia' OR species='amelia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idiotephria' AND (junior_species='amelia' OR junior_species='amelia')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='Idiotephria' AND (species='amelia' OR species='amelia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jodis' AND (junior_species='lactearia' OR junior_species='lactearia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jodis' AND (species='lactearia' OR species='lactearia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jodis' AND (species='lactearia' OR species='lactearia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jodis' AND (junior_species='lactearia' OR junior_species='lactearia')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='Jodis' AND (species='lactearia' OR species='lactearia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ninodes' AND (junior_species='splendens' OR junior_species='splendens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ninodes' AND (species='splendens' OR species='splendens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ninodes' AND (species='splendens' OR species='splendens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ninodes' AND (junior_species='splendens' OR junior_species='splendens')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='Ninodes' AND (species='splendens' OR species='splendens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothomiza' AND (junior_species='aureolaria' OR junior_species='aureolaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nothomiza' AND (species='aureolaria' OR species='aureolaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nothomiza' AND (species='aureolaria' OR species='aureolaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nothomiza' AND (junior_species='aureolaria' OR junior_species='aureolaria')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='Nothomiza' AND (species='aureolaria' OR species='aureolaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareclipsis' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareclipsis' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareclipsis' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareclipsis' AND (junior_species='gracilis' OR junior_species='gracilis')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='Pareclipsis' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagodis' AND (junior_species='pulveraria' OR junior_species='pulveraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plagodis' AND (species='pulveraria' OR species='pulveraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plagodis' AND (species='pulveraria' OR species='pulveraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagodis' AND (junior_species='pulveraria' OR junior_species='pulveraria')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='Plagodis' AND (species='pulveraria' OR species='pulveraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiomorpha' AND (junior_species='punctilinearia' OR junior_species='punctilinearia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plesiomorpha' AND (species='punctilinearia' OR species='punctilinearia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plesiomorpha' AND (species='punctilinearia' OR species='punctilinearia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plesiomorpha' AND (junior_species='punctilinearia' OR junior_species='punctilinearia')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='Plesiomorpha' AND (species='punctilinearia' OR species='punctilinearia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pylargosceles' AND (junior_species='steganioides' OR junior_species='steganioides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pylargosceles' AND (species='steganioides' OR species='steganioides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pylargosceles' AND (species='steganioides' OR species='steganioides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pylargosceles' AND (junior_species='steganioides' OR junior_species='steganioides')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='Pylargosceles' AND (species='steganioides' OR species='steganioides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='ignobilis' OR junior_species='ignobilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scopula' AND (species='ignobilis' OR species='ignobilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scopula' AND (species='ignobilis' OR species='ignobilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='ignobilis' OR junior_species='ignobilis')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='Scopula' AND (species='ignobilis' OR species='ignobilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='biriviata' OR junior_species='biriviata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthorhoe' AND (species='biriviata' OR species='biriviata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthorhoe' AND (species='biriviata' OR species='biriviata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='biriviata' OR junior_species='biriviata')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='Xanthorhoe' AND (species='biriviata' OR species='biriviata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerodes' AND (junior_species='albonotaria' OR junior_species='albonotaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xerodes' AND (species='albonotaria' OR species='albonotaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xerodes' AND (species='albonotaria' OR species='albonotaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xerodes' AND (junior_species='albonotaria' OR junior_species='albonotaria')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='Xerodes' AND (species='albonotaria' OR species='albonotaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='pulverosa' OR junior_species='pulverosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronicta' AND (species='pulverosa' OR species='pulverosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronicta' AND (species='pulverosa' OR species='pulverosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='pulverosa' OR junior_species='pulverosa')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='Acronicta' AND (species='pulverosa' OR species='pulverosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='rumicis' OR junior_species='rumicis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronicta' AND (species='rumicis' OR species='rumicis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronicta' AND (species='rumicis' OR species='rumicis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='rumicis' OR junior_species='rumicis')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='Acronicta' AND (species='rumicis' OR species='rumicis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arcte' AND (junior_species='coerula' OR junior_species='coerula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arcte' AND (species='coerula' OR species='coerula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arcte' AND (species='coerula' OR species='coerula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arcte' AND (junior_species='coerula' OR junior_species='coerula')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='Arcte' AND (species='coerula' OR species='coerula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='cinerascens' OR junior_species='cinerascens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athetis' AND (species='cinerascens' OR species='cinerascens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athetis' AND (species='cinerascens' OR species='cinerascens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='cinerascens' OR junior_species='cinerascens')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='Athetis' AND (species='cinerascens' OR species='cinerascens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='stellata' OR junior_species='stellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athetis' AND (species='stellata' OR species='stellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athetis' AND (species='stellata' OR species='stellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='stellata' OR junior_species='stellata')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='Athetis' AND (species='stellata' OR species='stellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerastis' AND (junior_species='pallescens' OR junior_species='pallescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cerastis' AND (species='pallescens' OR species='pallescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cerastis' AND (species='pallescens' OR species='pallescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cerastis' AND (junior_species='pallescens' OR junior_species='pallescens')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='Cerastis' AND (species='pallescens' OR species='pallescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clavipalpula' AND (junior_species='aurariae' OR junior_species='aurariae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clavipalpula' AND (species='aurariae' OR species='aurariae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clavipalpula' AND (species='aurariae' OR species='aurariae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clavipalpula' AND (junior_species='aurariae' OR junior_species='aurariae')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='Clavipalpula' AND (species='aurariae' OR species='aurariae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='albipuncta' OR junior_species='albipuncta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conistra' AND (species='albipuncta' OR species='albipuncta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conistra' AND (species='albipuncta' OR species='albipuncta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='albipuncta' OR junior_species='albipuncta')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='Conistra' AND (species='albipuncta' OR species='albipuncta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='ardescens' OR junior_species='ardescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conistra' AND (species='ardescens' OR species='ardescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conistra' AND (species='ardescens' OR species='ardescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='ardescens' OR junior_species='ardescens')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='Conistra' AND (species='ardescens' OR species='ardescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diarsia' AND (junior_species='canescens' OR junior_species='canescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diarsia' AND (species='canescens' OR species='canescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diarsia' AND (species='canescens' OR species='canescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diarsia' AND (junior_species='canescens' OR junior_species='canescens')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='Diarsia' AND (species='canescens' OR species='canescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinumma' AND (junior_species='deponens' OR junior_species='deponens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dinumma' AND (species='deponens' OR species='deponens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dinumma' AND (species='deponens' OR species='deponens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dinumma' AND (junior_species='deponens' OR junior_species='deponens')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='Dinumma' AND (species='deponens' OR species='deponens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gadirtha' AND (junior_species='uniformis' OR junior_species='uniformis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gadirtha' AND (species='uniformis' OR species='uniformis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gadirtha' AND (species='uniformis' OR species='uniformis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gadirtha' AND (junior_species='uniformis' OR junior_species='uniformis')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='Gadirtha' AND (species='uniformis' OR species='uniformis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gelastocera' AND (junior_species='hallasana' OR junior_species='hallasana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gelastocera' AND (species='hallasana' OR species='hallasana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gelastocera' AND (species='hallasana' OR species='hallasana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gelastocera' AND (junior_species='hallasana' OR junior_species='hallasana')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='Gelastocera' AND (species='hallasana' OR species='hallasana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herita' AND (junior_species='belinda' OR junior_species='belinda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herita' AND (species='belinda' OR species='belinda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herita' AND (species='belinda' OR species='belinda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herita' AND (junior_species='belinda' OR junior_species='belinda')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='Herita' AND (species='belinda' OR species='belinda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydrillodes' AND (junior_species='morosa' OR junior_species='morosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydrillodes' AND (species='morosa' OR species='morosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydrillodes' AND (species='morosa' OR species='morosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydrillodes' AND (junior_species='morosa' OR junior_species='morosa')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='Hydrillodes' AND (species='morosa' OR species='morosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypersypnoides' AND (junior_species='astrigera' OR junior_species='astrigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypersypnoides' AND (species='astrigera' OR species='astrigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypersypnoides' AND (species='astrigera' OR species='astrigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypersypnoides' AND (junior_species='astrigera' OR junior_species='astrigera')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='Hypersypnoides' AND (species='astrigera' OR species='astrigera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygephila' AND (junior_species='recta' OR junior_species='recta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lygephila' AND (species='recta' OR species='recta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lygephila' AND (species='recta' OR species='recta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lygephila' AND (junior_species='recta' OR junior_species='recta')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='Lygephila' AND (species='recta' OR species='recta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligonyx' AND (junior_species='vulnerata' OR junior_species='vulnerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligonyx' AND (species='vulnerata' OR species='vulnerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligonyx' AND (species='vulnerata' OR species='vulnerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligonyx' AND (junior_species='vulnerata' OR junior_species='vulnerata')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='Oligonyx' AND (species='vulnerata' OR species='vulnerata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='paromoea' OR junior_species='paromoea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthosia' AND (species='paromoea' OR species='paromoea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthosia' AND (species='paromoea' OR species='paromoea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='paromoea' OR junior_species='paromoea')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='Orthosia' AND (species='paromoea' OR species='paromoea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panolis' 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='Panolis' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panolis' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panolis' 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='Panolis' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perigrapha' AND (junior_species='hoenei' OR junior_species='hoeneii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perigrapha' AND (species='hoenei' OR species='hoeneii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perigrapha' AND (species='hoenei' OR species='hoeneii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perigrapha' AND (junior_species='hoenei' OR junior_species='hoeneii')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='Perigrapha' AND (species='hoenei' OR species='hoeneii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perigrapha' AND (junior_species='munda' OR junior_species='munda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perigrapha' AND (species='munda' OR species='munda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perigrapha' AND (species='munda' OR species='munda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perigrapha' AND (junior_species='munda' OR junior_species='munda')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='Perigrapha' AND (species='munda' OR species='munda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoips' AND (junior_species='sylpha' OR junior_species='sylpha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoips' AND (species='sylpha' OR species='sylpha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoips' AND (species='sylpha' OR species='sylpha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoips' AND (junior_species='sylpha' OR junior_species='sylpha')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='Pseudoips' AND (species='sylpha' OR species='sylpha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchina' AND (junior_species='cramboides' OR junior_species='cramboides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhynchina' AND (species='cramboides' OR species='cramboides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhynchina' AND (species='cramboides' OR species='cramboides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhynchina' AND (junior_species='cramboides' OR junior_species='cramboides')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='Rhynchina' AND (species='cramboides' OR species='cramboides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schrankia' AND (junior_species='separatalis' OR junior_species='separatalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Schrankia' AND (species='separatalis' OR species='separatalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Schrankia' AND (species='separatalis' OR species='separatalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Schrankia' AND (junior_species='separatalis' OR junior_species='separatalis')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='Schrankia' AND (species='separatalis' OR species='separatalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopolia' AND (junior_species='bella' OR junior_species='bella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xylopolia' AND (species='bella' OR species='bella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xylopolia' AND (species='bella' OR species='bella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xylopolia' AND (junior_species='bella' OR junior_species='bella')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='Xylopolia' AND (species='bella' OR species='bella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neodrymonia' AND (junior_species='marginalis' OR junior_species='marginalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neodrymonia' AND (species='marginalis' OR species='marginalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neodrymonia' AND (species='marginalis' OR species='marginalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neodrymonia' AND (junior_species='marginalis' OR junior_species='marginalis')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='Neodrymonia' AND (species='marginalis' OR species='marginalis') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1530 The Ecological Register: Mt. Seungdal-san
Mt. Seungdal-san
Basic information
Sample name: Mt. Seungdal-san

Reference: J.-S. An and S.-W. Choi. 2013. The role of winter weather in the population dynamics of spring moths in the southwest Korean peninsula. Journal of Asia-Pacific Entomology 16:49-53 [ER 1033]
Geography
Country: South Korea


Coordinate: 34° 59' N, 126° 28' E
Coordinate basis: based on nearby landmark

Geography comments: "Muan, South Korea" (coordinate based on Muan County)

Environment
Habitat: temperate coniferous forest

Substrate: ground surface

Habitat comments: "coniferous forest"

Methods
Life forms: moths

Sampling methods: no design,UV light traps

Sample size: 686 individuals

Years: 2007 - 2009

Days: 84

Nets or traps: 1

Net or trap nights: 84

Sampling comments: "a 22-Watt Ultraviolet Light trap (BioQuip, USA) operated by a 12-volt portable battery"

Metadata
Sample number: 1530

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-06 20:11:36

Modified: 2015-05-06 10:11:36

Abundance distribution
51 species
23 singletons
total count 686
extrapolated richness: 124.9
Fisher's α: 12.734
geometric series k: 0.8845
Hurlbert's PIE: 0.5353
Shannon's H: 1.6623
Good's u: 0.9665
Each square represents a species. Square sizes are proportional to counts.
Register