Coordinate: 23° 52' N, 90° 16' E
sampling effort is unclear
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