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=1529 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1529SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1032SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1529 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiusa' AND (junior_species='coronate' OR junior_species='coronate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ophiusa' AND (species='coronate' OR species='coronate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ophiusa' AND (species='coronate' OR species='coronate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ophiusa' AND (junior_species='coronate' OR junior_species='coronate')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='Ophiusa' AND (species='coronate' OR species='coronate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pindara' AND (junior_species='illibata' OR junior_species='illibata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pindara' AND (species='illibata' OR species='illibata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pindara' AND (species='illibata' OR species='illibata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pindara' AND (junior_species='illibata' OR junior_species='illibata')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='Pindara' AND (species='illibata' OR species='illibata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artena' AND (junior_species='dotala' OR junior_species='dotala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Artena' AND (species='dotala' OR species='dotala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Artena' AND (species='dotala' OR species='dotala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Artena' AND (junior_species='dotala' OR junior_species='dotala')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='Artena' AND (species='dotala' OR species='dotala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mocis' AND (junior_species='undata' OR junior_species='undata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mocis' AND (species='undata' OR species='undata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mocis' AND (species='undata' OR species='undata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mocis' AND (junior_species='undata' OR junior_species='undata')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='Mocis' AND (species='undata' OR species='undata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mocis' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mocis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mocis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mocis' AND (junior_species='sp.' OR junior_species='sp.')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='Mocis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parallelia' AND (junior_species='mandschurica' OR junior_species='mandschurica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parallelia' AND (species='mandschurica' OR species='mandschurica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parallelia' AND (species='mandschurica' OR species='mandschurica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parallelia' AND (junior_species='mandschurica' OR junior_species='mandschurica')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='Parallelia' AND (species='mandschurica' OR species='mandschurica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parallelia' AND (junior_species='arctotaemia' OR junior_species='arctotaemia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parallelia' AND (species='arctotaemia' OR species='arctotaemia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parallelia' AND (species='arctotaemia' OR species='arctotaemia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parallelia' AND (junior_species='arctotaemia' OR junior_species='arctotaemia')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='Parallelia' AND (species='arctotaemia' OR species='arctotaemia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammodes' AND (junior_species='geometrica' OR junior_species='geometrica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grammodes' AND (species='geometrica' OR species='geometrica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grammodes' AND (species='geometrica' OR species='geometrica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammodes' AND (junior_species='geometrica' OR junior_species='geometrica')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='Grammodes' AND (species='geometrica' OR species='geometrica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalciope' AND (junior_species='mygdon' OR junior_species='mygdon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chalciope' AND (species='mygdon' OR species='mygdon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chalciope' AND (species='mygdon' OR species='mygdon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chalciope' AND (junior_species='mygdon' OR junior_species='mygdon')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='Chalciope' AND (species='mygdon' OR species='mygdon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achae' AND (junior_species='janata' OR junior_species='janata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Achae' AND (species='janata' OR species='janata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Achae' AND (species='janata' OR species='janata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achae' AND (junior_species='janata' OR junior_species='janata')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='Achae' AND (species='janata' OR species='janata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Remigia' AND (junior_species='frugalis' OR junior_species='frugalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Remigia' AND (species='frugalis' OR species='frugalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Remigia' AND (species='frugalis' OR species='frugalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Remigia' AND (junior_species='frugalis' OR junior_species='frugalis')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='Remigia' AND (species='frugalis' OR species='frugalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spirama' AND (junior_species='helicina' OR junior_species='helicina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spirama' AND (species='helicina' OR species='helicina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spirama' AND (species='helicina' OR species='helicina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spirama' AND (junior_species='helicina' OR junior_species='helicina')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='Spirama' AND (species='helicina' OR species='helicina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupatula' AND (junior_species='macrops' OR junior_species='macrops')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupatula' AND (species='macrops' OR species='macrops') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupatula' AND (species='macrops' OR species='macrops')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupatula' AND (junior_species='macrops' OR junior_species='macrops')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='Eupatula' AND (species='macrops' OR species='macrops') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erebus' AND (junior_species='hieroglyphica' OR junior_species='hieroglyphica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erebus' AND (species='hieroglyphica' OR species='hieroglyphica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erebus' AND (species='hieroglyphica' OR species='hieroglyphica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erebus' AND (junior_species='hieroglyphica' OR junior_species='hieroglyphica')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='Erebus' AND (species='hieroglyphica' OR species='hieroglyphica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hulodes' AND (junior_species='drylla' OR junior_species='drylla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hulodes' AND (species='drylla' OR species='drylla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hulodes' AND (species='drylla' OR species='drylla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hulodes' AND (junior_species='drylla' OR junior_species='drylla')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='Hulodes' AND (species='drylla' OR species='drylla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthodes' AND (junior_species='intersepta' OR junior_species='intersepta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthodes' AND (species='intersepta' OR species='intersepta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthodes' AND (species='intersepta' OR species='intersepta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthodes' AND (junior_species='intersepta' OR junior_species='intersepta')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='Xanthodes' AND (species='intersepta' OR species='intersepta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthoplusia' AND (junior_species='aganta' OR junior_species='aganta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acanthoplusia' AND (species='aganta' OR species='aganta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acanthoplusia' AND (species='aganta' OR species='aganta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acanthoplusia' AND (junior_species='aganta' OR junior_species='aganta')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='Acanthoplusia' AND (species='aganta' OR species='aganta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysodeixis' 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='Chrysodeixis' AND (species='acuta' OR species='acuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysodeixis' AND (species='acuta' OR species='acuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysodeixis' 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='Chrysodeixis' AND (species='acuta' OR species='acuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysodeixis' AND (junior_species='minutus' OR junior_species='minutus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysodeixis' AND (species='minutus' OR species='minutus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysodeixis' AND (species='minutus' OR species='minutus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysodeixis' AND (junior_species='minutus' OR junior_species='minutus')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='Chrysodeixis' AND (species='minutus' OR species='minutus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oruza' AND (junior_species='divisa' OR junior_species='divisa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oruza' AND (species='divisa' OR species='divisa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oruza' AND (species='divisa' OR species='divisa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oruza' AND (junior_species='divisa' OR junior_species='divisa')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='Oruza' AND (species='divisa' OR species='divisa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oruza' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oruza' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oruza' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oruza' AND (junior_species='sp.' OR junior_species='sp.')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='Oruza' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corgatha' AND (junior_species='pygmaea' OR junior_species='pygmaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corgatha' AND (species='pygmaea' OR species='pygmaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corgatha' AND (species='pygmaea' OR species='pygmaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corgatha' AND (junior_species='pygmaea' OR junior_species='pygmaea')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='Corgatha' AND (species='pygmaea' OR species='pygmaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naranga' AND (junior_species='aenescens' OR junior_species='aenescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Naranga' AND (species='aenescens' OR species='aenescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Naranga' AND (species='aenescens' OR species='aenescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Naranga' AND (junior_species='aenescens' OR junior_species='aenescens')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='Naranga' AND (species='aenescens' OR species='aenescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maliattha' AND (junior_species='signifera' OR junior_species='signifera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maliattha' AND (species='signifera' OR species='signifera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maliattha' AND (species='signifera' OR species='signifera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maliattha' AND (junior_species='signifera' OR junior_species='signifera')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='Maliattha' AND (species='signifera' OR species='signifera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithacidia' AND (junior_species='elaeostygia' OR junior_species='elaeostygia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithacidia' AND (species='elaeostygia' OR species='elaeostygia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithacidia' AND (species='elaeostygia' OR species='elaeostygia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithacidia' AND (junior_species='elaeostygia' OR junior_species='elaeostygia')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='Lithacidia' AND (species='elaeostygia' OR species='elaeostygia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoplusia' AND (junior_species='orichalcea' OR junior_species='orichalcea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichoplusia' AND (species='orichalcea' OR species='orichalcea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichoplusia' AND (species='orichalcea' OR species='orichalcea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoplusia' AND (junior_species='orichalcea' OR junior_species='orichalcea')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='Trichoplusia' AND (species='orichalcea' OR species='orichalcea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Othreis' AND (junior_species='fullonia' OR junior_species='fullonia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Othreis' AND (species='fullonia' OR species='fullonia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Othreis' AND (species='fullonia' OR species='fullonia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Othreis' AND (junior_species='fullonia' OR junior_species='fullonia')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='Othreis' AND (species='fullonia' OR species='fullonia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pandytia' AND (junior_species='metaspila' OR junior_species='metaspila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pandytia' AND (species='metaspila' OR species='metaspila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pandytia' AND (species='metaspila' OR species='metaspila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pandytia' AND (junior_species='metaspila' OR junior_species='metaspila')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='Pandytia' AND (species='metaspila' OR species='metaspila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ericeia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ericeia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ericeia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ericeia' AND (junior_species='sp.' OR junior_species='sp.')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='Ericeia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polydesma' AND (junior_species='boarmoides' OR junior_species='boarmoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polydesma' AND (species='boarmoides' OR species='boarmoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polydesma' AND (species='boarmoides' OR species='boarmoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polydesma' AND (junior_species='boarmoides' OR junior_species='boarmoides')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='Polydesma' AND (species='boarmoides' OR species='boarmoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anticarsia' AND (junior_species='irrorata' OR junior_species='irrorata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anticarsia' AND (species='irrorata' OR species='irrorata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anticarsia' AND (species='irrorata' OR species='irrorata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anticarsia' AND (junior_species='irrorata' OR junior_species='irrorata')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='Anticarsia' AND (species='irrorata' OR species='irrorata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Othreis' AND (junior_species='homaena' OR junior_species='homaena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Othreis' AND (species='homaena' OR species='homaena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Othreis' AND (species='homaena' OR species='homaena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Othreis' AND (junior_species='homaena' OR junior_species='homaena')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='Othreis' AND (species='homaena' OR species='homaena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomis' AND (junior_species='flava' OR junior_species='flava')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anomis' AND (species='flava' OR species='flava') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anomis' AND (species='flava' OR species='flava')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomis' AND (junior_species='flava' OR junior_species='flava')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='Anomis' AND (species='flava' OR species='flava') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anticarsia' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anticarsia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anticarsia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anticarsia' AND (junior_species='sp.' OR junior_species='sp.')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='Anticarsia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='litura' OR junior_species='litura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spodoptera' AND (species='litura' OR species='litura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spodoptera' AND (species='litura' OR species='litura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='litura' OR junior_species='litura')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='Spodoptera' AND (species='litura' OR species='litura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='mauritia' OR junior_species='mauritia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spodoptera' AND (species='mauritia' OR species='mauritia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spodoptera' AND (species='mauritia' OR species='mauritia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='mauritia' OR junior_species='mauritia')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='Spodoptera' AND (species='mauritia' OR species='mauritia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='depravata' OR junior_species='depravata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spodoptera' AND (species='depravata' OR species='depravata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spodoptera' AND (species='depravata' OR species='depravata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='depravata' OR junior_species='depravata')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='Spodoptera' AND (species='depravata' OR species='depravata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='exigue' OR junior_species='exigue')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spodoptera' AND (species='exigue' OR species='exigue') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spodoptera' AND (species='exigue' OR species='exigue')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='exigue' OR junior_species='exigue')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='Spodoptera' AND (species='exigue' OR species='exigue') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='cilium' OR junior_species='cilium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spodoptera' AND (species='cilium' OR species='cilium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spodoptera' AND (species='cilium' OR species='cilium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spodoptera' AND (junior_species='cilium' OR junior_species='cilium')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='Spodoptera' AND (species='cilium' OR species='cilium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platysenta' AND (junior_species='illecta' OR junior_species='illecta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platysenta' AND (species='illecta' OR species='illecta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platysenta' AND (species='illecta' OR species='illecta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platysenta' AND (junior_species='illecta' OR junior_species='illecta')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='Platysenta' AND (species='illecta' OR species='illecta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='placida' OR junior_species='placida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athetis' AND (species='placida' OR species='placida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athetis' AND (species='placida' OR species='placida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='placida' OR junior_species='placida')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='placida' OR species='placida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='lapidea' OR junior_species='lapidea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athetis' AND (species='lapidea' OR species='lapidea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athetis' AND (species='lapidea' OR species='lapidea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='lapidea' OR junior_species='lapidea')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='lapidea' OR species='lapidea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='striolata' OR junior_species='striolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athetis' AND (species='striolata' OR species='striolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athetis' AND (species='striolata' OR species='striolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='striolata' OR junior_species='striolata')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='striolata' OR species='striolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='furvula' OR junior_species='furvula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athetis' AND (species='furvula' OR species='furvula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athetis' AND (species='furvula' OR species='furvula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='furvula' OR junior_species='furvula')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='furvula' OR species='furvula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sesamia' AND (junior_species='inferens' OR junior_species='inferens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sesamia' AND (species='inferens' OR species='inferens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sesamia' AND (species='inferens' OR species='inferens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sesamia' AND (junior_species='inferens' OR junior_species='inferens')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='Sesamia' AND (species='inferens' OR species='inferens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chasminodes' 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='Chasminodes' AND (species='japonica' OR species='japonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chasminodes' AND (species='japonica' OR species='japonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chasminodes' 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='Chasminodes' AND (species='japonica' OR species='japonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anapamea' AND (junior_species='minor' OR junior_species='minor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anapamea' AND (species='minor' OR species='minor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anapamea' AND (species='minor' OR species='minor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anapamea' AND (junior_species='minor' OR junior_species='minor')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='Anapamea' AND (species='minor' OR species='minor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrotis' AND (junior_species='ipsilon' OR junior_species='ipsilon')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrotis' AND (species='ipsilon' OR species='ipsilon') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrotis' AND (species='ipsilon' OR species='ipsilon')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrotis' AND (junior_species='ipsilon' OR junior_species='ipsilon')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='Agrotis' AND (species='ipsilon' OR species='ipsilon') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxoa' AND (junior_species='nigrata' OR junior_species='nigrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euxoa' AND (species='nigrata' OR species='nigrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euxoa' AND (species='nigrata' OR species='nigrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxoa' AND (junior_species='nigrata' OR junior_species='nigrata')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='Euxoa' AND (species='nigrata' OR species='nigrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucania' AND (junior_species='compta' OR junior_species='compta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucania' AND (species='compta' OR species='compta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucania' AND (species='compta' OR species='compta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucania' AND (junior_species='compta' OR junior_species='compta')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='Leucania' AND (species='compta' OR species='compta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucania' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucania' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucania' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucania' AND (junior_species='sp.' OR junior_species='sp.')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='Leucania' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acantholeucania' AND (junior_species='loreyimima' OR junior_species='loreyimima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acantholeucania' AND (species='loreyimima' OR species='loreyimima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acantholeucania' AND (species='loreyimima' OR species='loreyimima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acantholeucania' AND (junior_species='loreyimima' OR junior_species='loreyimima')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='Acantholeucania' AND (species='loreyimima' OR species='loreyimima') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypena' AND (junior_species='indicatalis' OR junior_species='indicatalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypena' AND (species='indicatalis' OR species='indicatalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypena' AND (species='indicatalis' OR species='indicatalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypena' AND (junior_species='indicatalis' OR junior_species='indicatalis')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='Hypena' AND (species='indicatalis' OR species='indicatalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypena' AND (junior_species='longipennis' OR junior_species='longipennis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypena' AND (species='longipennis' OR species='longipennis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypena' AND (species='longipennis' OR species='longipennis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypena' AND (junior_species='longipennis' OR junior_species='longipennis')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='Hypena' AND (species='longipennis' OR species='longipennis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simplicia' AND (junior_species='ryukyuensis' OR junior_species='ryukyuensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Simplicia' AND (species='ryukyuensis' OR species='ryukyuensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Simplicia' AND (species='ryukyuensis' OR species='ryukyuensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Simplicia' AND (junior_species='ryukyuensis' OR junior_species='ryukyuensis')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='Simplicia' AND (species='ryukyuensis' OR species='ryukyuensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracolax' AND (junior_species='biquncta' OR junior_species='biquncta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paracolax' AND (species='biquncta' OR species='biquncta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paracolax' AND (species='biquncta' OR species='biquncta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracolax' AND (junior_species='biquncta' OR junior_species='biquncta')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='Paracolax' AND (species='biquncta' OR species='biquncta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicoverpa' AND (junior_species='armigera' OR junior_species='armigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicoverpa' AND (species='armigera' OR species='armigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicoverpa' AND (species='armigera' OR species='armigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicoverpa' AND (junior_species='armigera' OR junior_species='armigera')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='Helicoverpa' AND (species='armigera' OR species='armigera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicoverpa' AND (junior_species='assulta' OR junior_species='assulta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicoverpa' AND (species='assulta' OR species='assulta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicoverpa' AND (species='assulta' OR species='assulta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicoverpa' AND (junior_species='assulta' OR junior_species='assulta')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='Helicoverpa' AND (species='assulta' OR species='assulta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethaloessa' AND (junior_species='calidalis' OR junior_species='calidalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethaloessa' AND (species='calidalis' OR species='calidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethaloessa' AND (species='calidalis' OR species='calidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethaloessa' AND (junior_species='calidalis' OR junior_species='calidalis')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='Aethaloessa' AND (species='calidalis' OR species='calidalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maruca' AND (junior_species='testulalis' OR junior_species='testulalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Maruca' AND (species='testulalis' OR species='testulalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Maruca' AND (species='testulalis' OR species='testulalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Maruca' AND (junior_species='testulalis' OR junior_species='testulalis')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='Maruca' AND (species='testulalis' OR species='testulalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaphania' 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='Diaphania' AND (species='indica' OR species='indica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaphania' AND (species='indica' OR species='indica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaphania' 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='Diaphania' AND (species='indica' OR species='indica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omphisa' AND (junior_species='anastomosalis' OR junior_species='anastomosalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Omphisa' AND (species='anastomosalis' OR species='anastomosalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Omphisa' AND (species='anastomosalis' OR species='anastomosalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Omphisa' AND (junior_species='anastomosalis' OR junior_species='anastomosalis')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='Omphisa' AND (species='anastomosalis' OR species='anastomosalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphodes' AND (junior_species='formosanus' OR junior_species='formosanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glyphodes' AND (species='formosanus' OR species='formosanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glyphodes' AND (species='formosanus' OR species='formosanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphodes' AND (junior_species='formosanus' OR junior_species='formosanus')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='Glyphodes' AND (species='formosanus' OR species='formosanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenia' AND (junior_species='recurvalis' OR junior_species='recurvalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hymenia' AND (species='recurvalis' OR species='recurvalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hymenia' AND (species='recurvalis' OR species='recurvalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hymenia' AND (junior_species='recurvalis' OR junior_species='recurvalis')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='Hymenia' AND (species='recurvalis' OR species='recurvalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurrhyparodes' AND (junior_species='accessalis' OR junior_species='accessalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurrhyparodes' AND (species='accessalis' OR species='accessalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurrhyparodes' AND (species='accessalis' OR species='accessalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurrhyparodes' AND (junior_species='accessalis' OR junior_species='accessalis')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='Eurrhyparodes' AND (species='accessalis' OR species='accessalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraponyx' AND (junior_species='fluctuosalis' OR junior_species='fluctuosalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraponyx' AND (species='fluctuosalis' OR species='fluctuosalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraponyx' AND (species='fluctuosalis' OR species='fluctuosalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraponyx' AND (junior_species='fluctuosalis' OR junior_species='fluctuosalis')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='Paraponyx' AND (species='fluctuosalis' OR species='fluctuosalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetogramma' AND (junior_species='stultalis' OR junior_species='stultalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herpetogramma' AND (species='stultalis' OR species='stultalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herpetogramma' AND (species='stultalis' OR species='stultalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetogramma' AND (junior_species='stultalis' OR junior_species='stultalis')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='Herpetogramma' AND (species='stultalis' OR species='stultalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetogramma' AND (junior_species='licarsisalis' OR junior_species='licarsisalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herpetogramma' AND (species='licarsisalis' OR species='licarsisalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herpetogramma' AND (species='licarsisalis' OR species='licarsisalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetogramma' AND (junior_species='licarsisalis' OR junior_species='licarsisalis')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='Herpetogramma' AND (species='licarsisalis' OR species='licarsisalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetogramma' AND (junior_species='okamoto' OR junior_species='okamoto')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herpetogramma' AND (species='okamoto' OR species='okamoto') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herpetogramma' AND (species='okamoto' OR species='okamoto')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetogramma' AND (junior_species='okamoto' OR junior_species='okamoto')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='Herpetogramma' AND (species='okamoto' OR species='okamoto') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetogramma' AND (junior_species='phaeopteralis' OR junior_species='phaeopteralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herpetogramma' AND (species='phaeopteralis' OR species='phaeopteralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herpetogramma' AND (species='phaeopteralis' OR species='phaeopteralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herpetogramma' AND (junior_species='phaeopteralis' OR junior_species='phaeopteralis')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='Herpetogramma' AND (species='phaeopteralis' OR species='phaeopteralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnaphaocrocis' AND (junior_species='medinalis' OR junior_species='medinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cnaphaocrocis' AND (species='medinalis' OR species='medinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cnaphaocrocis' AND (species='medinalis' OR species='medinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cnaphaocrocis' AND (junior_species='medinalis' OR junior_species='medinalis')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='Cnaphaocrocis' AND (species='medinalis' OR species='medinalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hedylepta' AND (junior_species='misera' OR junior_species='misera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hedylepta' AND (species='misera' OR species='misera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hedylepta' AND (species='misera' OR species='misera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hedylepta' AND (junior_species='misera' OR junior_species='misera')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='Hedylepta' AND (species='misera' OR species='misera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Botyodes' AND (junior_species='asialis' OR junior_species='asialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Botyodes' AND (species='asialis' OR species='asialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Botyodes' AND (species='asialis' OR species='asialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Botyodes' AND (junior_species='asialis' OR junior_species='asialis')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='Botyodes' AND (species='asialis' OR species='asialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrinia' AND (junior_species='scapulalis' OR junior_species='scapulalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ostrinia' AND (species='scapulalis' OR species='scapulalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ostrinia' AND (species='scapulalis' OR species='scapulalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrinia' AND (junior_species='scapulalis' OR junior_species='scapulalis')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='Ostrinia' AND (species='scapulalis' OR species='scapulalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrinia' AND (junior_species='orientalis' OR junior_species='orientalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ostrinia' AND (species='orientalis' OR species='orientalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ostrinia' AND (species='orientalis' OR species='orientalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ostrinia' AND (junior_species='orientalis' OR junior_species='orientalis')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='Ostrinia' AND (species='orientalis' OR species='orientalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pygospila' AND (junior_species='tyres' OR junior_species='tyres')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pygospila' AND (species='tyres' OR species='tyres') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pygospila' AND (species='tyres' OR species='tyres')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pygospila' AND (junior_species='tyres' OR junior_species='tyres')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='Pygospila' AND (species='tyres' OR species='tyres') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyspanodes' 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='Tyspanodes' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tyspanodes' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tyspanodes' 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='Tyspanodes' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Udea' AND (junior_species='testacea' OR junior_species='testacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Udea' AND (species='testacea' OR species='testacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Udea' AND (species='testacea' OR species='testacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Udea' AND (junior_species='testacea' OR junior_species='testacea')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='Udea' AND (species='testacea' OR species='testacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnarmon' AND (junior_species='cribrata' OR junior_species='cribrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pycnarmon' AND (species='cribrata' OR species='cribrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pycnarmon' AND (species='cribrata' OR species='cribrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pycnarmon' AND (junior_species='cribrata' OR junior_species='cribrata')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='Pycnarmon' AND (species='cribrata' OR species='cribrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marasmia' AND (junior_species='limbalis' OR junior_species='limbalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marasmia' AND (species='limbalis' OR species='limbalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marasmia' AND (species='limbalis' OR species='limbalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marasmia' AND (junior_species='limbalis' OR junior_species='limbalis')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='Marasmia' AND (species='limbalis' OR species='limbalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piletocera' AND (junior_species='sodalis' OR junior_species='sodalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Piletocera' AND (species='sodalis' OR species='sodalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Piletocera' AND (species='sodalis' OR species='sodalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Piletocera' AND (junior_species='sodalis' OR junior_species='sodalis')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='Piletocera' AND (species='sodalis' OR species='sodalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucinodes' AND (junior_species='orbonalis' OR junior_species='orbonalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucinodes' AND (species='orbonalis' OR species='orbonalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucinodes' AND (species='orbonalis' OR species='orbonalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucinodes' AND (junior_species='orbonalis' OR junior_species='orbonalis')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='Leucinodes' AND (species='orbonalis' OR species='orbonalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goniorhynchus' AND (junior_species='butyrosa' OR junior_species='butyrosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Goniorhynchus' AND (species='butyrosa' OR species='butyrosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Goniorhynchus' AND (species='butyrosa' OR species='butyrosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Goniorhynchus' AND (junior_species='butyrosa' OR junior_species='butyrosa')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='Goniorhynchus' AND (species='butyrosa' OR species='butyrosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphodes' AND (junior_species='pyloalis' OR junior_species='pyloalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glyphodes' AND (species='pyloalis' OR species='pyloalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glyphodes' AND (species='pyloalis' OR species='pyloalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyphodes' AND (junior_species='pyloalis' OR junior_species='pyloalis')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='Glyphodes' AND (species='pyloalis' OR species='pyloalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='excerptalis' OR junior_species='excerptalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scirpophaga' AND (species='excerptalis' OR species='excerptalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scirpophaga' AND (species='excerptalis' OR species='excerptalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='excerptalis' OR junior_species='excerptalis')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='Scirpophaga' AND (species='excerptalis' OR species='excerptalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='praelata' OR junior_species='praelata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scirpophaga' AND (species='praelata' OR species='praelata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scirpophaga' AND (species='praelata' OR species='praelata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='praelata' OR junior_species='praelata')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='Scirpophaga' AND (species='praelata' OR species='praelata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='xantho' OR junior_species='xantho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scirpophaga' AND (species='xantho' OR species='xantho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scirpophaga' AND (species='xantho' OR species='xantho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='xantho' OR junior_species='xantho')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='Scirpophaga' AND (species='xantho' OR species='xantho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='virginia' OR junior_species='virginia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scirpophaga' AND (species='virginia' OR species='virginia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scirpophaga' AND (species='virginia' OR species='virginia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='virginia' OR junior_species='virginia')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='Scirpophaga' AND (species='virginia' OR species='virginia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='goto' OR junior_species='goto')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scirpophaga' AND (species='goto' OR species='goto') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scirpophaga' AND (species='goto' OR species='goto')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='goto' OR junior_species='goto')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='Scirpophaga' AND (species='goto' OR species='goto') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='nivella' OR junior_species='nivella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scirpophaga' AND (species='nivella' OR species='nivella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scirpophaga' AND (species='nivella' OR species='nivella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='nivella' OR junior_species='nivella')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='Scirpophaga' AND (species='nivella' OR species='nivella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='incertulas' OR junior_species='incertulas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scirpophaga' AND (species='incertulas' OR species='incertulas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scirpophaga' AND (species='incertulas' OR species='incertulas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='incertulas' OR junior_species='incertulas')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='Scirpophaga' AND (species='incertulas' OR species='incertulas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='parvalis' OR junior_species='parvalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scirpophaga' AND (species='parvalis' OR species='parvalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scirpophaga' AND (species='parvalis' OR species='parvalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scirpophaga' AND (junior_species='parvalis' OR junior_species='parvalis')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='Scirpophaga' AND (species='parvalis' OR species='parvalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microchilo' AND (junior_species='inouei' OR junior_species='inoueii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microchilo' AND (species='inouei' OR species='inoueii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microchilo' AND (species='inouei' OR species='inoueii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microchilo' AND (junior_species='inouei' OR junior_species='inoueii')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='Microchilo' AND (species='inouei' OR species='inoueii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parapediasia' AND (junior_species='teterrella' OR junior_species='teterrella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parapediasia' AND (species='teterrella' OR species='teterrella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parapediasia' AND (species='teterrella' OR species='teterrella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parapediasia' AND (junior_species='teterrella' OR junior_species='teterrella')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='Parapediasia' AND (species='teterrella' OR species='teterrella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareromene' AND (junior_species='vermeeri' OR junior_species='vermeerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pareromene' AND (species='vermeeri' OR species='vermeerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pareromene' AND (species='vermeeri' OR species='vermeerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pareromene' AND (junior_species='vermeeri' OR junior_species='vermeerii')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='Pareromene' AND (species='vermeeri' OR species='vermeerii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopediasia' AND (junior_species='mixtalis' OR junior_species='mixtalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neopediasia' AND (species='mixtalis' OR species='mixtalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neopediasia' AND (species='mixtalis' OR species='mixtalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neopediasia' AND (junior_species='mixtalis' OR junior_species='mixtalis')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='Neopediasia' AND (species='mixtalis' OR species='mixtalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calamotropha' AND (junior_species='yamanakai' OR junior_species='yamanakaii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calamotropha' AND (species='yamanakai' OR species='yamanakaii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calamotropha' AND (species='yamanakai' OR species='yamanakaii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calamotropha' AND (junior_species='yamanakai' OR junior_species='yamanakaii')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='Calamotropha' AND (species='yamanakai' OR species='yamanakaii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphula' AND (junior_species='enixalis' OR junior_species='enixalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nymphula' AND (species='enixalis' OR species='enixalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nymphula' AND (species='enixalis' OR species='enixalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nymphula' AND (junior_species='enixalis' OR junior_species='enixalis')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='Nymphula' AND (species='enixalis' OR species='enixalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraponyx' AND (junior_species='vittalis' OR junior_species='vittalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paraponyx' AND (species='vittalis' OR species='vittalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paraponyx' AND (species='vittalis' OR species='vittalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paraponyx' AND (junior_species='vittalis' OR junior_species='vittalis')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='Paraponyx' AND (species='vittalis' OR species='vittalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsopygia' AND (junior_species='kawabei' OR junior_species='kawabeii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypsopygia' AND (species='kawabei' OR species='kawabeii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypsopygia' AND (species='kawabei' OR species='kawabeii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypsopygia' AND (junior_species='kawabei' OR junior_species='kawabeii')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='Hypsopygia' AND (species='kawabei' OR species='kawabeii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quasipuer' AND (junior_species='infamella' OR junior_species='infamella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Quasipuer' AND (species='infamella' OR species='infamella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Quasipuer' AND (species='infamella' OR species='infamella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Quasipuer' AND (junior_species='infamella' OR junior_species='infamella')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='Quasipuer' AND (species='infamella' OR species='infamella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homoeosoma' AND (junior_species='matsumyrellum' OR junior_species='matsumyrellum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homoeosoma' AND (species='matsumyrellum' OR species='matsumyrellum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homoeosoma' AND (species='matsumyrellum' OR species='matsumyrellum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homoeosoma' AND (junior_species='matsumyrellum' OR junior_species='matsumyrellum')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='Homoeosoma' AND (species='matsumyrellum' OR species='matsumyrellum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Creatonotos' AND (junior_species='gangis' OR junior_species='gangis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Creatonotos' AND (species='gangis' OR species='gangis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Creatonotos' AND (species='gangis' OR species='gangis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Creatonotos' AND (junior_species='gangis' OR junior_species='gangis')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='Creatonotos' AND (species='gangis' OR species='gangis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Creatonotos' AND (junior_species='transiens' OR junior_species='transiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Creatonotos' AND (species='transiens' OR species='transiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Creatonotos' AND (species='transiens' OR species='transiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Creatonotos' AND (junior_species='transiens' OR junior_species='transiens')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='Creatonotos' AND (species='transiens' OR species='transiens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Utetheisa' AND (junior_species='pulchelloides' OR junior_species='pulchelloides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Utetheisa' AND (species='pulchelloides' OR species='pulchelloides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Utetheisa' AND (species='pulchelloides' OR species='pulchelloides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Utetheisa' AND (junior_species='pulchelloides' OR junior_species='pulchelloides')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='Utetheisa' AND (species='pulchelloides' OR species='pulchelloides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Utetheisa' AND (junior_species='lotrix' OR junior_species='lotrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Utetheisa' AND (species='lotrix' OR species='lotrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Utetheisa' AND (species='lotrix' OR species='lotrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Utetheisa' AND (junior_species='lotrix' OR junior_species='lotrix')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='Utetheisa' AND (species='lotrix' OR species='lotrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilosoma' AND (junior_species='obliqua' OR junior_species='obliqua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilosoma' AND (species='obliqua' OR species='obliqua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilosoma' AND (species='obliqua' OR species='obliqua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilosoma' AND (junior_species='obliqua' OR junior_species='obliqua')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='Spilosoma' AND (species='obliqua' OR species='obliqua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilosoma' AND (junior_species='seriatopunctata' OR junior_species='seriatopunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilosoma' AND (species='seriatopunctata' OR species='seriatopunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilosoma' AND (species='seriatopunctata' OR species='seriatopunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilosoma' AND (junior_species='seriatopunctata' OR junior_species='seriatopunctata')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='Spilosoma' AND (species='seriatopunctata' OR species='seriatopunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilosoma' AND (junior_species='inaequalis' OR junior_species='inaequalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilosoma' AND (species='inaequalis' OR species='inaequalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilosoma' AND (species='inaequalis' OR species='inaequalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilosoma' AND (junior_species='inaequalis' OR junior_species='inaequalis')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='Spilosoma' AND (species='inaequalis' OR species='inaequalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilosoma' AND (junior_species='inaequalis' OR junior_species='inaequalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilosoma' AND (species='inaequalis' OR species='inaequalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilosoma' AND (species='inaequalis' OR species='inaequalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilosoma' AND (junior_species='inaequalis' OR junior_species='inaequalis')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='Spilosoma' AND (species='inaequalis' OR species='inaequalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyparioides' AND (junior_species='nebulosus' OR junior_species='nebulosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyparioides' AND (species='nebulosus' OR species='nebulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyparioides' AND (species='nebulosus' OR species='nebulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyparioides' AND (junior_species='nebulosus' OR junior_species='nebulosus')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='Rhyparioides' AND (species='nebulosus' OR species='nebulosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eilema' AND (junior_species='laevis' OR junior_species='laevis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eilema' AND (species='laevis' OR species='laevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eilema' AND (species='laevis' OR species='laevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eilema' AND (junior_species='laevis' OR junior_species='laevis')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='Eilema' AND (species='laevis' OR species='laevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miltochrista' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miltochrista' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miltochrista' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miltochrista' AND (junior_species='sp.' OR junior_species='sp.')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='Miltochrista' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stigmatophora' AND (junior_species='bipuncta' OR junior_species='bipuncta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stigmatophora' AND (species='bipuncta' OR species='bipuncta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stigmatophora' AND (species='bipuncta' OR species='bipuncta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stigmatophora' AND (junior_species='bipuncta' OR junior_species='bipuncta')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='Stigmatophora' AND (species='bipuncta' OR species='bipuncta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctemer' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctemer' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctemer' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctemer' AND (junior_species='sp.' OR junior_species='sp.')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='Nyctemer' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Comibaena' AND (junior_species='diluta' OR junior_species='diluta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Comibaena' AND (species='diluta' OR species='diluta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Comibaena' AND (species='diluta' OR species='diluta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Comibaena' AND (junior_species='diluta' OR junior_species='diluta')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='Comibaena' AND (species='diluta' OR species='diluta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Comibaena' AND (junior_species='amoenaria' OR junior_species='amoenaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Comibaena' AND (species='amoenaria' OR species='amoenaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Comibaena' AND (species='amoenaria' OR species='amoenaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Comibaena' AND (junior_species='amoenaria' OR junior_species='amoenaria')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='Comibaena' AND (species='amoenaria' OR species='amoenaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalassodes' AND (junior_species='subquadrodris' OR junior_species='subquadrodris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thalassodes' AND (species='subquadrodris' OR species='subquadrodris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thalassodes' AND (species='subquadrodris' OR species='subquadrodris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalassodes' AND (junior_species='subquadrodris' OR junior_species='subquadrodris')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='Thalassodes' AND (species='subquadrodris' OR species='subquadrodris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalassodes' AND (junior_species='proquadraria' OR junior_species='proquadraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thalassodes' AND (species='proquadraria' OR species='proquadraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thalassodes' AND (species='proquadraria' OR species='proquadraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalassodes' AND (junior_species='proquadraria' OR junior_species='proquadraria')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='Thalassodes' AND (species='proquadraria' OR species='proquadraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalassodes' AND (junior_species='immissaria' OR junior_species='immissaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thalassodes' AND (species='immissaria' OR species='immissaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thalassodes' AND (species='immissaria' OR species='immissaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalassodes' AND (junior_species='immissaria' OR junior_species='immissaria')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='Thalassodes' AND (species='immissaria' OR species='immissaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pamphlebia' AND (junior_species='rubrolimbraria' OR junior_species='rubrolimbraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pamphlebia' AND (species='rubrolimbraria' OR species='rubrolimbraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pamphlebia' AND (species='rubrolimbraria' OR species='rubrolimbraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pamphlebia' AND (junior_species='rubrolimbraria' OR junior_species='rubrolimbraria')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='Pamphlebia' AND (species='rubrolimbraria' OR species='rubrolimbraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorissa' AND (junior_species='anadema' OR junior_species='anadema')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chlorissa' AND (species='anadema' OR species='anadema') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chlorissa' AND (species='anadema' OR species='anadema')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chlorissa' AND (junior_species='anadema' OR junior_species='anadema')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='Chlorissa' AND (species='anadema' OR species='anadema') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Comostola' AND (junior_species='subtiliaria' OR junior_species='subtiliaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Comostola' AND (species='subtiliaria' OR species='subtiliaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Comostola' AND (species='subtiliaria' OR species='subtiliaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Comostola' AND (junior_species='subtiliaria' OR junior_species='subtiliaria')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='Comostola' AND (species='subtiliaria' OR species='subtiliaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyposidra' AND (junior_species='talaca' OR junior_species='talaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyposidra' AND (species='talaca' OR species='talaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyposidra' AND (species='talaca' OR species='talaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyposidra' AND (junior_species='talaca' OR junior_species='talaca')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='Hyposidra' AND (species='talaca' OR species='talaca') 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='Eumelea' AND (junior_species='biflavata' OR junior_species='biflavata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eumelea' AND (species='biflavata' OR species='biflavata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eumelea' AND (species='biflavata' OR species='biflavata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eumelea' AND (junior_species='biflavata' OR junior_species='biflavata')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='Eumelea' AND (species='biflavata' OR species='biflavata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Derambila' AND (junior_species='saponaria' OR junior_species='saponaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Derambila' AND (species='saponaria' OR species='saponaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Derambila' AND (species='saponaria' OR species='saponaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Derambila' AND (junior_species='saponaria' OR junior_species='saponaria')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='Derambila' AND (species='saponaria' OR species='saponaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnoscelis' AND (junior_species='ishigakinsis' OR junior_species='ishigakinsis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnoscelis' AND (species='ishigakinsis' OR species='ishigakinsis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnoscelis' AND (species='ishigakinsis' OR species='ishigakinsis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnoscelis' AND (junior_species='ishigakinsis' OR junior_species='ishigakinsis')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='ishigakinsis' OR species='ishigakinsis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='superciliata' OR junior_species='superciliata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scopula' AND (species='superciliata' OR species='superciliata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scopula' AND (species='superciliata' OR species='superciliata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='superciliata' OR junior_species='superciliata')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='superciliata' OR species='superciliata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='subpunctata' OR junior_species='subpunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scopula' AND (species='subpunctata' OR species='subpunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scopula' AND (species='subpunctata' OR species='subpunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='subpunctata' OR junior_species='subpunctata')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='subpunctata' OR species='subpunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='neovalida' OR junior_species='neovalida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idaea' AND (species='neovalida' OR species='neovalida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idaea' AND (species='neovalida' OR species='neovalida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='neovalida' OR junior_species='neovalida')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='Idaea' AND (species='neovalida' OR species='neovalida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parocneria' AND (junior_species='furva' OR junior_species='furva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parocneria' AND (species='furva' OR species='furva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parocneria' AND (species='furva' OR species='furva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parocneria' AND (junior_species='furva' OR junior_species='furva')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='Parocneria' AND (species='furva' OR species='furva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euproctis' AND (junior_species='pulverea' OR junior_species='pulverea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euproctis' AND (species='pulverea' OR species='pulverea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euproctis' AND (species='pulverea' OR species='pulverea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euproctis' AND (junior_species='pulverea' OR junior_species='pulverea')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='Euproctis' AND (species='pulverea' OR species='pulverea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctornis' AND (junior_species='album' OR junior_species='album')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arctornis' AND (species='album' OR species='album') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arctornis' AND (species='album' OR species='album')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arctornis' AND (junior_species='album' OR junior_species='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='Arctornis' AND (species='album' OR species='album') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliteara' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliteara' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliteara' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliteara' AND (junior_species='sp.' OR junior_species='sp.')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='Calliteara' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euproctis' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euproctis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euproctis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euproctis' AND (junior_species='sp.' OR junior_species='sp.')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='Euproctis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euproctis' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euproctis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euproctis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euproctis' AND (junior_species='sp.' OR junior_species='sp.')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='Euproctis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrius' AND (junior_species='convolvuli' OR junior_species='convolvulii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrius' AND (species='convolvuli' OR species='convolvulii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrius' AND (species='convolvuli' OR species='convolvulii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrius' AND (junior_species='convolvuli' OR junior_species='convolvulii')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='Agrius' AND (species='convolvuli' OR species='convolvulii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thereta' AND (junior_species='clotho' OR junior_species='clotho')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thereta' AND (species='clotho' OR species='clotho') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thereta' AND (species='clotho' OR species='clotho')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thereta' AND (junior_species='clotho' OR junior_species='clotho')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='Thereta' AND (species='clotho' OR species='clotho') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thereta' AND (junior_species='pinastrina' OR junior_species='pinastrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thereta' AND (species='pinastrina' OR species='pinastrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thereta' AND (species='pinastrina' OR species='pinastrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thereta' AND (junior_species='pinastrina' OR junior_species='pinastrina')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='Thereta' AND (species='pinastrina' OR species='pinastrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyncholaba' AND (junior_species='acteus' OR junior_species='acteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhyncholaba' AND (species='acteus' OR species='acteus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhyncholaba' AND (species='acteus' OR species='acteus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhyncholaba' AND (junior_species='acteus' OR junior_species='acteus')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='Rhyncholaba' AND (species='acteus' OR species='acteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amata' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amata' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amata' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amata' AND (junior_species='sp.' OR junior_species='sp.')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='Amata' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amata' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amata' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amata' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amata' AND (junior_species='sp.' OR junior_species='sp.')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='Amata' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amata' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amata' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amata' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amata' AND (junior_species='sp.' OR junior_species='sp.')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='Amata' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latoia' AND (junior_species='sinica' OR junior_species='sinica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Latoia' AND (species='sinica' OR species='sinica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Latoia' AND (species='sinica' OR species='sinica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Latoia' AND (junior_species='sinica' OR junior_species='sinica')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='Latoia' AND (species='sinica' OR species='sinica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Susica' 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='Susica' AND (species='fusca' OR species='fusca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Susica' AND (species='fusca' OR species='fusca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Susica' 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='Susica' AND (species='fusca' OR species='fusca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agnidra' AND (junior_species='scabiosa' OR junior_species='scabiosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agnidra' AND (species='scabiosa' OR species='scabiosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agnidra' AND (species='scabiosa' OR species='scabiosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agnidra' AND (junior_species='scabiosa' OR junior_species='scabiosa')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='Agnidra' AND (species='scabiosa' OR species='scabiosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bambalina' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bambalina' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bambalina' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bambalina' AND (junior_species='sp.' OR junior_species='sp.')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='Bambalina' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meganola' AND (junior_species='pseudohypena' OR junior_species='pseudohypena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meganola' AND (species='pseudohypena' OR species='pseudohypena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meganola' AND (species='pseudohypena' OR species='pseudohypena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meganola' AND (junior_species='pseudohypena' OR junior_species='pseudohypena')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='Meganola' AND (species='pseudohypena' OR species='pseudohypena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zaranga' AND (junior_species='permagna' OR junior_species='permagna')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zaranga' AND (species='permagna' OR species='permagna') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zaranga' AND (species='permagna' OR species='permagna')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zaranga' AND (junior_species='permagna' OR junior_species='permagna')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='Zaranga' AND (species='permagna' OR species='permagna') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odonestis' AND (junior_species='pruni' OR junior_species='prunii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odonestis' AND (species='pruni' OR species='prunii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odonestis' AND (species='pruni' OR species='prunii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odonestis' AND (junior_species='pruni' OR junior_species='prunii')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='Odonestis' AND (species='pruni' OR species='prunii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asota' AND (junior_species='caricae' OR junior_species='caricae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asota' AND (species='caricae' OR species='caricae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asota' AND (species='caricae' OR species='caricae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asota' AND (junior_species='caricae' OR junior_species='caricae')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='Asota' AND (species='caricae' OR species='caricae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asota' AND (junior_species='paphos' OR junior_species='paphos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asota' AND (species='paphos' OR species='paphos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asota' AND (species='paphos' OR species='paphos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asota' AND (junior_species='paphos' OR junior_species='paphos')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='Asota' AND (species='paphos' OR species='paphos') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1529 The Ecological Register: Atomic Energy Research Establishment
Atomic Energy Research Establishment
Basic information
Sample name: Atomic Energy Research Establishment

Reference: A. T. M. F. Islam, M. H. Islam, A. S. M. Saifullah, and A. Yamanaka. 2013. A preliminary report of moth's fauna in the campus of Atomic Energy Research Establishment (AERE), Savar, Dhaka, Bangladesh. International Journal of Fauna and Biological Studies 1(1):56-62 [ER 1032]
Geography
Country: Bangladesh


Coordinate: 23° 52' N, 90° 16' E
Coordinate basis: based on nearby landmark

Geography comments: "in AERE campus Savar which is situated at north-west suburbs of Dhaka" (coordinate based on Savar Upazila)

Environment
Habitat: tropical/subtropical dry broadleaf forest

Altered habitat: cropland

Substrate: ground surface

Habitat comments: "fields, forests and gardens, i. e. fields of fruit plants, timber plants, ornamental plants and grasses, flower gardens and ponds in addition to buildings of offices and resident apartments"

Methods
Life forms: moths

Sampling methods: no design,light traps

Sample size: 1488 individuals

Years: 2011

Sampling comments: "moths were collected by using a light trap for an hour following the sunset. The light trap was consisted of a white cloth (1m X 3m) positioned perpendicular to the ground, and four 40-W white florescent lights and a 200-W mercury light were used as the light sources"
sampling effort is unclear

Metadata
Sample number: 1529

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-06 19:14:57

Modified: 2015-05-06 10:19:08

Abundance distribution
153 species
71 singletons
total count 1488
extrapolated richness: 349.9
Fisher's α: 42.763
geometric series k: 0.9614
Hurlbert's PIE: 0.9107
Shannon's H: 3.5801
Good's u: 0.9523
Each square represents a species. Square sizes are proportional to counts.
Register
Ophiusa coronate6
Pindara illibata1
Artena dotala2
Mocis undata12
Mocis sp.1
Parallelia mandschurica14
Parallelia arctotaemia1
Grammodes geometrica4
Chalciope mygdon3
Achae janata8
Remigia frugalis19
Spirama helicina1
Eupatula macrops1
Erebus hieroglyphica3
Hulodes drylla1
Xanthodes intersepta1
Acanthoplusia aganta15
Chrysodeixis acuta3
Chrysodeixis minutus1
Oruza divisa1
Oruza sp.1
Corgatha pygmaea1
Naranga aenescens17
Maliattha signifera7
Lithacidia elaeostygia1
Trichoplusia orichalcea1
Othreis fullonia6
Pandytia metaspila3
Ericeia sp.1
Polydesma boarmoides4
Anticarsia irrorata1
Othreis homaena2
Anomis flava flava1
Anticarsia sp.4
Spodoptera litura62
Spodoptera mauritia aconyctoides13
Spodoptera depravata31
Spodoptera exigue4
Spodoptera cilium13
Platysenta illecta4
Athetis placida3
Athetis lapidea7
Athetis striolata3
Athetis furvula lentina5
Sesamia inferens12
Chasminodes japonica1
Anapamea minor7
Agrotis ipsilon27
Euxoa nigrata1
Leucania compta89
Leucania sp.7
Acantholeucania loreyimima5
Hypena indicatalis5
Hypena longipennis1
Simplicia ryukyuensis1
Paracolax biquncta5
Helicoverpa armigera armigera8
Helicoverpa assulta assulta1
Aethaloessa calidalis1
Maruca testulalis4
Diaphania indica1
Omphisa anastomosalis1
Glyphodes formosanus9
Hymenia recurvalis17
Eurrhyparodes accessalis6
Paraponyx fluctuosalis17
Herpetogramma stultalis18
Herpetogramma licarsisalis4
Herpetogramma okamoto17
Herpetogramma phaeopteralis15
Cnaphaocrocis medinalis397
Hedylepta misera1
Botyodes asialis1
Ostrinia scapulalis subpacifica6
Ostrinia orientalis orientalis1
Pygospila tyres19
Tyspanodes gracilis1
Udea testacea8
Pycnarmon cribrata5
Marasmia limbalis1
Piletocera sodalis1
Leucinodes orbonalis1
Goniorhynchus butyrosa1
Glyphodes pyloalis2
Scirpophaga excerptalis12
Scirpophaga praelata1
Scirpophaga xantho1
Scirpophaga virginia4
Scirpophaga goto3
Scirpophaga nivella1
Scirpophaga incertulas42
Scirpophaga parvalis16
Microchilo inouei1
Parapediasia teterrella1
Pareromene vermeeri2
Neopediasia mixtalis1
Calamotropha yamanakai owadai1
Nymphula enixalis34
Paraponyx vittalis4
Hypsopygia kawabei1
Quasipuer infamella1
Homoeosoma matsumyrellum1
Creatonotos gangis1
Creatonotos transiens diasetsuzana19
Utetheisa pulchelloides17
Utetheisa lotrix lotrix6
Spilosoma obliqua127
Spilosoma seriatopunctata ozumai1
Spilosoma inaequalis sakasuchii4
Spilosoma inaequalis inaequalis1
Rhyparioides nebulosus14
Eilema laevis1
Miltochrista sp.4
Stigmatophora bipuncta11
Nyctemer sp.1
Comibaena diluta1
Comibaena amoenaria1
Thalassodes subquadrodris2
Thalassodes proquadraria1
Thalassodes immissaria immissaria1
Pamphlebia rubrolimbraria1
Chlorissa anadema1
Comostola subtiliaria kawazoei2
Hyposidra talaca22
Heterolocha aristonaria3
Eumelea biflavata insulate1
Derambila saponaria fragilis1
Gymnoscelis ishigakinsis1
Scopula superciliata1
Scopula subpunctata1
Idaea neovalida1
Parocneria furva1
Euproctis pulverea1
Arctornis album1
Calliteara sp.7
Euproctis sp. 122
Euproctis sp. 21
Agrius convolvuli1
Thereta clotho clotho1
Thereta pinastrina pinastrina2
Rhyncholaba acteus1
Amata sp. 11
Amata sp. 25
Amata sp. 32
Latoia sinica1
Susica fusca16
Agnidra scabiosa scabiosa7
Bambalina sp.1
Meganola pseudohypena1
Zaranga permagna4
Odonestis pruni japonensis1
Asota caricae15
Asota paphos3