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=1532 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1532SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1034SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1532 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammia' AND (junior_species='williamsi' OR junior_species='williamsii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Grammia' AND (species='williamsi' OR species='williamsii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Grammia' AND (species='williamsi' OR species='williamsii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Grammia' AND (junior_species='williamsi' OR junior_species='williamsii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Grammia' AND (species='williamsi' OR species='williamsii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxostege' AND (junior_species='commixtalis' OR junior_species='commixtalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxostege' AND (species='commixtalis' OR species='commixtalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loxostege' AND (species='commixtalis' OR species='commixtalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loxostege' AND (junior_species='commixtalis' OR junior_species='commixtalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Loxostege' AND (species='commixtalis' OR species='commixtalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysstroma' AND (junior_species='citrata' OR junior_species='citrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysstroma' AND (species='citrata' OR species='citrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysstroma' AND (species='citrata' OR species='citrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysstroma' AND (junior_species='citrata' OR junior_species='citrata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dysstroma' AND (species='citrata' OR species='citrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ecliptopera' AND (junior_species='silaceata' OR junior_species='silaceata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ecliptopera' AND (species='silaceata' OR species='silaceata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ecliptopera' AND (species='silaceata' OR species='silaceata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ecliptopera' AND (junior_species='silaceata' OR junior_species='silaceata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ecliptopera' AND (species='silaceata' OR species='silaceata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enypia' AND (junior_species='venata' OR junior_species='venata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enypia' AND (species='venata' OR species='venata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enypia' AND (species='venata' OR species='venata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enypia' AND (junior_species='venata' OR junior_species='venata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enypia' AND (species='venata' OR species='venata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epirranthis' AND (junior_species='substriataria' OR junior_species='substriataria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epirranthis' AND (species='substriataria' OR species='substriataria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epirranthis' AND (species='substriataria' OR species='substriataria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epirranthis' AND (junior_species='substriataria' OR junior_species='substriataria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epirranthis' AND (species='substriataria' OR species='substriataria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulithis' AND (junior_species='xylina' OR junior_species='xylina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulithis' AND (species='xylina' OR species='xylina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulithis' AND (species='xylina' OR species='xylina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulithis' AND (junior_species='xylina' OR junior_species='xylina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulithis' AND (species='xylina' OR species='xylina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydriomena' AND (junior_species='morosata' OR junior_species='morosata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hydriomena' AND (species='morosata' OR species='morosata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hydriomena' AND (species='morosata' OR species='morosata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hydriomena' AND (junior_species='morosata' OR junior_species='morosata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hydriomena' AND (species='morosata' OR species='morosata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoterpes' AND (junior_species='trianguliferata' OR junior_species='trianguliferata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neoterpes' AND (species='trianguliferata' OR species='trianguliferata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neoterpes' AND (species='trianguliferata' OR species='trianguliferata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neoterpes' AND (junior_species='trianguliferata' OR junior_species='trianguliferata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Neoterpes' AND (species='trianguliferata' OR species='trianguliferata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pero' AND (junior_species='behrensarius' OR junior_species='behrensarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pero' AND (species='behrensarius' OR species='behrensarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pero' AND (species='behrensarius' OR species='behrensarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pero' AND (junior_species='behrensarius' OR junior_species='behrensarius')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pero' AND (species='behrensarius' OR species='behrensarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rheumaptera' AND (junior_species='hastate' OR junior_species='hastate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rheumaptera' AND (species='hastate' OR species='hastate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rheumaptera' AND (species='hastate' OR species='hastate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rheumaptera' AND (junior_species='hastate' OR junior_species='hastate')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rheumaptera' AND (species='hastate' OR species='hastate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='inductata' OR junior_species='inductata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scopula' AND (species='inductata' OR species='inductata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scopula' AND (species='inductata' OR species='inductata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='inductata' OR junior_species='inductata')SELECT d.diet,d.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='inductata' OR species='inductata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' 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='Scopula' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scopula' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' 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='Scopula' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semiothisa' AND (junior_species='neptaria' OR junior_species='neptaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Semiothisa' AND (species='neptaria' OR species='neptaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Semiothisa' AND (species='neptaria' OR species='neptaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semiothisa' AND (junior_species='neptaria' OR junior_species='neptaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Semiothisa' AND (species='neptaria' OR species='neptaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semiothisa' AND (junior_species='subminiata' OR junior_species='subminiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Semiothisa' AND (species='subminiata' OR species='subminiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Semiothisa' AND (species='subminiata' OR species='subminiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Semiothisa' AND (junior_species='subminiata' OR junior_species='subminiata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Semiothisa' AND (species='subminiata' OR species='subminiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spargania' AND (junior_species='magnoliata' OR junior_species='magnoliata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spargania' AND (species='magnoliata' OR species='magnoliata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spargania' AND (species='magnoliata' OR species='magnoliata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spargania' AND (junior_species='magnoliata' OR junior_species='magnoliata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spargania' AND (species='magnoliata' OR species='magnoliata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='abrasaria' OR junior_species='abrasaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthorhoe' AND (species='abrasaria' OR species='abrasaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthorhoe' AND (species='abrasaria' OR species='abrasaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='abrasaria' OR junior_species='abrasaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthorhoe' AND (species='abrasaria' OR species='abrasaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='pontiaria' OR junior_species='pontiaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthorhoe' AND (species='pontiaria' OR species='pontiaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthorhoe' AND (species='pontiaria' OR species='pontiaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='pontiaria' OR junior_species='pontiaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthorhoe' AND (species='pontiaria' OR species='pontiaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geometridae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geometridae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geometridae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geometridae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Geometridae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malacosom' AND (junior_species='californicum' OR junior_species='californicum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Malacosom' AND (species='californicum' OR species='californicum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Malacosom' AND (species='californicum' OR species='californicum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Malacosom' AND (junior_species='californicum' OR junior_species='californicum')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Malacosom' AND (species='californicum' OR species='californicum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllodesma' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phyllodesma' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phyllodesma' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phyllodesma' AND (junior_species='americana' OR junior_species='americana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phyllodesma' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='impressa' OR junior_species='impressa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronicta' AND (species='impressa' OR species='impressa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronicta' AND (species='impressa' OR species='impressa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='impressa' OR junior_species='impressa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acronicta' AND (species='impressa' OR species='impressa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='lepusculina' OR junior_species='lepusculina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronicta' AND (species='lepusculina' OR species='lepusculina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronicta' AND (species='lepusculina' OR species='lepusculina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='lepusculina' OR junior_species='lepusculina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acronicta' AND (species='lepusculina' OR species='lepusculina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Admetovis' AND (junior_species='oxymorus' OR junior_species='oxymorus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Admetovis' AND (species='oxymorus' OR species='oxymorus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Admetovis' AND (species='oxymorus' OR species='oxymorus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Admetovis' AND (junior_species='oxymorus' OR junior_species='oxymorus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Admetovis' AND (species='oxymorus' OR species='oxymorus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrotis' AND (junior_species='venerabilis' OR junior_species='venerabilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrotis' AND (species='venerabilis' OR species='venerabilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrotis' AND (species='venerabilis' OR species='venerabilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrotis' AND (junior_species='venerabilis' OR junior_species='venerabilis')SELECT d.diet,d.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='venerabilis' OR species='venerabilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropolia' AND (junior_species='contacta' OR junior_species='contacta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Andropolia' AND (species='contacta' OR species='contacta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Andropolia' AND (species='contacta' OR species='contacta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Andropolia' AND (junior_species='contacta' OR junior_species='contacta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Andropolia' AND (species='contacta' OR species='contacta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomogyna' AND (junior_species='vernilis' OR junior_species='vernilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anomogyna' AND (species='vernilis' OR species='vernilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anomogyna' AND (species='vernilis' OR species='vernilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anomogyna' AND (junior_species='vernilis' OR junior_species='vernilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anomogyna' AND (species='vernilis' OR species='vernilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='alia' OR junior_species='alia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apamea' AND (species='alia' OR species='alia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apamea' AND (species='alia' OR species='alia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='alia' OR junior_species='alia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apamea' AND (species='alia' OR species='alia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='atrosuffusa' OR junior_species='atrosuffusa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apamea' AND (species='atrosuffusa' OR species='atrosuffusa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apamea' AND (species='atrosuffusa' OR species='atrosuffusa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='atrosuffusa' OR junior_species='atrosuffusa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apamea' AND (species='atrosuffusa' OR species='atrosuffusa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='inficita' OR junior_species='inficita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apamea' AND (species='inficita' OR species='inficita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apamea' AND (species='inficita' OR species='inficita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='inficita' OR junior_species='inficita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apamea' AND (species='inficita' OR species='inficita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='infinita' OR junior_species='infinita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apamea' AND (species='infinita' OR species='infinita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apamea' AND (species='infinita' OR species='infinita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='infinita' OR junior_species='infinita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apamea' AND (species='infinita' OR species='infinita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='lateritia' OR junior_species='lateritia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apamea' AND (species='lateritia' OR species='lateritia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apamea' AND (species='lateritia' OR species='lateritia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='lateritia' OR junior_species='lateritia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apamea' AND (species='lateritia' OR species='lateritia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aseptis' AND (junior_species='binotata' OR junior_species='binotata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aseptis' AND (species='binotata' OR species='binotata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aseptis' AND (species='binotata' OR species='binotata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aseptis' AND (junior_species='binotata' OR junior_species='binotata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aseptis' AND (species='binotata' OR species='binotata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discestra' AND (junior_species='farnhami' OR junior_species='farnhamii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Discestra' AND (species='farnhami' OR species='farnhamii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Discestra' AND (species='farnhami' OR species='farnhamii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Discestra' AND (junior_species='farnhami' OR junior_species='farnhamii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Discestra' AND (species='farnhami' OR species='farnhamii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drasteria' AND (junior_species='hudsonica' OR junior_species='hudsonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drasteria' AND (species='hudsonica' OR species='hudsonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drasteria' AND (species='hudsonica' OR species='hudsonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drasteria' AND (junior_species='hudsonica' OR junior_species='hudsonica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drasteria' AND (species='hudsonica' OR species='hudsonica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enargia' AND (junior_species='decolor' OR junior_species='decolor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Enargia' AND (species='decolor' OR species='decolor') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Enargia' AND (species='decolor' OR species='decolor')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Enargia' AND (junior_species='decolor' OR junior_species='decolor')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Enargia' AND (species='decolor' OR species='decolor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplexia' AND (junior_species='benesimilis' OR junior_species='benesimilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplexia' AND (species='benesimilis' OR species='benesimilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplexia' AND (species='benesimilis' OR species='benesimilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplexia' AND (junior_species='benesimilis' OR junior_species='benesimilis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euplexia' AND (species='benesimilis' OR species='benesimilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxoa' AND (junior_species='divergens' OR junior_species='divergens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euxoa' AND (species='divergens' OR species='divergens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euxoa' AND (species='divergens' OR species='divergens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxoa' AND (junior_species='divergens' OR junior_species='divergens')SELECT d.diet,d.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='divergens' OR species='divergens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxoa' AND (junior_species='terrena' OR junior_species='terrena')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euxoa' AND (species='terrena' OR species='terrena') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euxoa' AND (species='terrena' OR species='terrena')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxoa' AND (junior_species='terrena' OR junior_species='terrena')SELECT d.diet,d.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='terrena' OR species='terrena') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxoa' AND (junior_species='tessellata' OR junior_species='tessellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euxoa' AND (species='tessellata' OR species='tessellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euxoa' AND (species='tessellata' OR species='tessellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euxoa' AND (junior_species='tessellata' OR junior_species='tessellata')SELECT d.diet,d.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='tessellata' OR species='tessellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hada' AND (junior_species='sutrina' OR junior_species='sutrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hada' AND (species='sutrina' OR species='sutrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hada' AND (species='sutrina' OR species='sutrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hada' AND (junior_species='sutrina' OR junior_species='sutrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hada' AND (species='sutrina' OR species='sutrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hadena' AND (junior_species='jola' OR junior_species='jola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hadena' AND (species='jola' OR species='jola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hadena' AND (species='jola' OR species='jola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hadena' AND (junior_species='jola' OR junior_species='jola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hadena' AND (species='jola' OR species='jola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hadena' AND (junior_species='variolata' OR junior_species='variolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hadena' AND (species='variolata' OR species='variolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hadena' AND (species='variolata' OR species='variolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hadena' AND (junior_species='variolata' OR junior_species='variolata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hadena' AND (species='variolata' OR species='variolata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyppa' AND (junior_species='brunneicrista' OR junior_species='brunneicrista')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyppa' AND (species='brunneicrista' OR species='brunneicrista') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyppa' AND (species='brunneicrista' OR species='brunneicrista')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyppa' AND (junior_species='brunneicrista' OR junior_species='brunneicrista')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hyppa' AND (species='brunneicrista' OR species='brunneicrista') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyppa' AND (junior_species='xylinoides' OR junior_species='xylinoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyppa' AND (species='xylinoides' OR species='xylinoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyppa' AND (species='xylinoides' OR species='xylinoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyppa' AND (junior_species='xylinoides' OR junior_species='xylinoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hyppa' AND (species='xylinoides' OR species='xylinoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacanobia' AND (junior_species='nevadae' OR junior_species='nevadae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacanobia' AND (species='nevadae' OR species='nevadae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacanobia' AND (species='nevadae' OR species='nevadae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacanobia' AND (junior_species='nevadae' OR junior_species='nevadae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lacanobia' AND (species='nevadae' OR species='nevadae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacinipolia' AND (junior_species='olivacea' OR junior_species='olivacea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacinipolia' AND (species='olivacea' OR species='olivacea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacinipolia' AND (species='olivacea' OR species='olivacea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacinipolia' AND (junior_species='olivacea' OR junior_species='olivacea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lacinipolia' AND (species='olivacea' OR species='olivacea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiestra' 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='Lasiestra' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiestra' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiestra' 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='Lasiestra' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='conjugata' OR junior_species='conjugata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasionycta' AND (species='conjugata' OR species='conjugata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasionycta' AND (species='conjugata' OR species='conjugata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='conjugata' OR junior_species='conjugata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasionycta' AND (species='conjugata' OR species='conjugata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='leucocycla' OR junior_species='leucocycla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasionycta' AND (species='leucocycla' OR species='leucocycla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasionycta' AND (species='leucocycla' OR species='leucocycla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='leucocycla' OR junior_species='leucocycla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasionycta' AND (species='leucocycla' OR species='leucocycla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='perplexa' OR junior_species='perplexa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasionycta' AND (species='perplexa' OR species='perplexa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasionycta' AND (species='perplexa' OR species='perplexa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='perplexa' OR junior_species='perplexa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasionycta' AND (species='perplexa' OR species='perplexa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='subfuscula' OR junior_species='subfuscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasionycta' AND (species='subfuscula' OR species='subfuscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasionycta' AND (species='subfuscula' OR species='subfuscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='subfuscula' OR junior_species='subfuscula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasionycta' AND (species='subfuscula' OR species='subfuscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucania' AND (junior_species='insueta' OR junior_species='insueta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leucania' AND (species='insueta' OR species='insueta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leucania' AND (species='insueta' OR species='insueta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leucania' AND (junior_species='insueta' OR junior_species='insueta')SELECT d.diet,d.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='insueta' OR species='insueta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mamestra' 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='Mamestra' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mamestra' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mamestra' 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='Mamestra' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanchra' AND (junior_species='adjuncta' OR junior_species='adjuncta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanchra' AND (species='adjuncta' OR species='adjuncta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanchra' AND (species='adjuncta' OR species='adjuncta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanchra' AND (junior_species='adjuncta' OR junior_species='adjuncta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanchra' AND (species='adjuncta' OR species='adjuncta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanchra' AND (junior_species='pulverulenta' OR junior_species='pulverulenta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanchra' AND (species='pulverulenta' OR species='pulverulenta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanchra' AND (species='pulverulenta' OR species='pulverulenta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanchra' AND (junior_species='pulverulenta' OR junior_species='pulverulenta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanchra' AND (species='pulverulenta' OR species='pulverulenta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mniotype' 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='Mniotype' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mniotype' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mniotype' 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='Mniotype' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oncocnemis' AND (junior_species='dayi' OR junior_species='dayii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oncocnemis' AND (species='dayi' OR species='dayii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oncocnemis' AND (species='dayi' OR species='dayii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oncocnemis' AND (junior_species='dayi' OR junior_species='dayii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oncocnemis' AND (species='dayi' OR species='dayii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradiarsia' AND (junior_species='littoralis' OR junior_species='littoralis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paradiarsia' AND (species='littoralis' OR species='littoralis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paradiarsia' AND (species='littoralis' OR species='littoralis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradiarsia' AND (junior_species='littoralis' OR junior_species='littoralis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paradiarsia' AND (species='littoralis' OR species='littoralis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polia' AND (junior_species='purpurissata' OR junior_species='purpurissata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polia' AND (species='purpurissata' OR species='purpurissata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polia' AND (species='purpurissata' OR species='purpurissata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polia' AND (junior_species='purpurissata' OR junior_species='purpurissata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polia' AND (species='purpurissata' OR species='purpurissata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protolampra' AND (junior_species='rufipectis' OR junior_species='rufipectis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protolampra' AND (species='rufipectis' OR species='rufipectis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protolampra' AND (species='rufipectis' OR species='rufipectis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protolampra' AND (junior_species='rufipectis' OR junior_species='rufipectis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protolampra' AND (species='rufipectis' OR species='rufipectis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scoliopteryx' AND (junior_species='libatrix' OR junior_species='libatrix')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scoliopteryx' AND (species='libatrix' OR species='libatrix') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scoliopteryx' AND (species='libatrix' OR species='libatrix')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scoliopteryx' AND (junior_species='libatrix' OR junior_species='libatrix')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Scoliopteryx' AND (species='libatrix' OR species='libatrix') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spaelotis' 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='Spaelotis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spaelotis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spaelotis' 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='Spaelotis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syngrapha' AND (junior_species='angulidens' OR junior_species='angulidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syngrapha' AND (species='angulidens' OR species='angulidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syngrapha' AND (species='angulidens' OR species='angulidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syngrapha' AND (junior_species='angulidens' OR junior_species='angulidens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syngrapha' AND (species='angulidens' OR species='angulidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syngrapha' AND (junior_species='ignea' OR junior_species='ignea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Syngrapha' AND (species='ignea' OR species='ignea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Syngrapha' AND (species='ignea' OR species='ignea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Syngrapha' AND (junior_species='ignea' OR junior_species='ignea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Syngrapha' AND (species='ignea' OR species='ignea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoplexia' 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='Trichoplexia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichoplexia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichoplexia' 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='Trichoplexia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichordestra' AND (junior_species='beanii' OR junior_species='beani')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichordestra' AND (species='beanii' OR species='beani') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichordestra' AND (species='beanii' OR species='beani')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichordestra' AND (junior_species='beanii' OR junior_species='beani')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichordestra' AND (species='beanii' OR species='beani') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='oblata' OR junior_species='oblata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='oblata' OR species='oblata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='oblata' OR species='oblata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='oblata' OR junior_species='oblata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xestia' AND (species='oblata' OR species='oblata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='perquiritata' OR junior_species='perquiritata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='perquiritata' OR species='perquiritata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='perquiritata' OR species='perquiritata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='perquiritata' OR junior_species='perquiritata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xestia' AND (species='perquiritata' OR species='perquiritata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='speciosa' OR junior_species='speciosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='speciosa' OR species='speciosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='speciosa' OR species='speciosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='speciosa' OR junior_species='speciosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xestia' AND (species='speciosa' OR species='speciosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctuidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctuidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctuidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clostera' AND (junior_species='albosigma' OR junior_species='albosigma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clostera' AND (species='albosigma' OR species='albosigma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clostera' AND (species='albosigma' OR species='albosigma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clostera' AND (junior_species='albosigma' OR junior_species='albosigma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Clostera' AND (species='albosigma' OR species='albosigma') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clostera' AND (junior_species='brucei' OR junior_species='bruceii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clostera' AND (species='brucei' OR species='bruceii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clostera' AND (species='brucei' OR species='bruceii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clostera' AND (junior_species='brucei' OR junior_species='bruceii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Clostera' AND (species='brucei' OR species='bruceii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcula' AND (junior_species='scolopendrina' OR junior_species='scolopendrina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Furcula' AND (species='scolopendrina' OR species='scolopendrina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Furcula' AND (species='scolopendrina' OR species='scolopendrina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Furcula' AND (junior_species='scolopendrina' OR junior_species='scolopendrina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Furcula' AND (species='scolopendrina' OR species='scolopendrina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gluphisia' AND (junior_species='severa' OR junior_species='severa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gluphisia' AND (species='severa' OR species='severa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gluphisia' AND (species='severa' OR species='severa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gluphisia' AND (junior_species='severa' OR junior_species='severa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gluphisia' AND (species='severa' OR species='severa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheosia' AND (junior_species='rimosa' OR junior_species='rimosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pheosia' AND (species='rimosa' OR species='rimosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pheosia' AND (species='rimosa' OR species='rimosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pheosia' AND (junior_species='rimosa' OR junior_species='rimosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pheosia' AND (species='rimosa' OR species='rimosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyles' AND (junior_species='lineata' OR junior_species='lineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyles' AND (species='lineata' OR species='lineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyles' AND (species='lineata' OR species='lineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyles' AND (junior_species='lineata' OR junior_species='lineata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hyles' AND (species='lineata' OR species='lineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smerinthus' AND (junior_species='cerisyi' OR junior_species='cerisyii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Smerinthus' AND (species='cerisyi' OR species='cerisyii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Smerinthus' AND (species='cerisyi' OR species='cerisyii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Smerinthus' AND (junior_species='cerisyi' OR junior_species='cerisyii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Smerinthus' AND (species='cerisyi' OR species='cerisyii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphinx' AND (junior_species='vashti' OR junior_species='vashtii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphinx' AND (species='vashti' OR species='vashtii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphinx' AND (species='vashti' OR species='vashtii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphinx' AND (junior_species='vashti' OR junior_species='vashtii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Sphinx' AND (species='vashti' OR species='vashtii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choristoneura' AND (junior_species='conflictana' OR junior_species='conflictana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Choristoneura' AND (species='conflictana' OR species='conflictana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Choristoneura' AND (species='conflictana' OR species='conflictana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Choristoneura' AND (junior_species='conflictana' OR junior_species='conflictana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Choristoneura' AND (species='conflictana' OR species='conflictana') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1532 The Ecological Register: Rocky Mountain Biological Laboratory (moths)
Rocky Mountain Biological Laboratory (moths)
Basic information
Sample name: Rocky Mountain Biological Laboratory (moths)

Reference: T. H. Ricketts, G. C. Daily, and P. R. Ehrlich. 2002. Does butterfly diversity predict moth diversity? Testing a popular indicator taxon at local scales. Biological Conservation 103:361-370 [ER 1034]
Geography
Country: United States

State: Colorado


Coordinate: 38° 40' N, 107° 1' W
Coordinate basis: based on political unit

Geography comments: coordinate based on Gunnison County

•
Environment
Habitat: temperate broadleaf/mixed forest

Substrate: ground surface

Habitat comments: subalpine "meadows, aspen forests, and conifer forests"

Methods
Life forms: moths

Sites: 19

Sampling methods: no design,UV light traps

Sample size: 4961 individuals

Days: 9

Seasons: summer

Nets or traps: 133

Net or trap nights: 1197

Sampling comments: "bucket traps with 1-A fluorescent black lights" deployed at 19 sites "between mid-June and mid-August 1997, with six–eight traps in operation each night. Each site was sampled 8–10 times"

Metadata
Sample number: 1532

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-09 15:14:24

Modified: 2015-05-09 06:23:03

Abundance distribution
91 species
14 singletons
total count 4961
extrapolated richness: 127.1
Fisher's α: 15.823
geometric series k: 0.9317
Hurlbert's PIE: 0.9455
Shannon's H: 3.3560
Good's u: 0.9972
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Grammia williamsi37
Loxostege commixtalis1
Dysstroma citrata2
Ecliptopera silaceata19
Enypia venata276
Epirranthis substriataria2
Eulithis xylina1
Hydriomena morosata3
Neoterpes trianguliferata6
Pero behrensarius151
Rheumaptera hastate26
Scopula inductata40
Scopula sp.11
Semiothisa neptaria4
Semiothisa subminiata3
Spargania magnoliata140
Xanthorhoe abrasaria1
Xanthorhoe pontiaria44
Geometridae indet.1
Malacosom californicum96
Phyllodesma americana21
Acronicta impressa2
Acronicta lepusculina2
Admetovis oxymorus90
Agrotis venerabilis343
Andropolia contacta1
Anomogyna vernilis1
Apamea alia27
Apamea atrosuffusa66
Apamea inficita2
Apamea infinita5
Apamea lateritia5
Aseptis binotata3
Discestra farnhami29
Drasteria hudsonica70
Enargia decolor59
Euplexia benesimilis8
Euxoa divergens364
Euxoa terrena8
Euxoa tessellata1
Hada sutrina6
Hadena jola46
Hadena variolata14
Hyppa brunneicrista2
Hyppa xylinoides5
Lacanobia nevadae32
Lacinipolia olivacea70
Lasiestra sp.2
Lasionycta conjugata99
Lasionycta leucocycla coloradensis2
Lasionycta perplexa558
Lasionycta subfuscula136
Leucania insueta243
Mamestra sp.1
Melanchra adjuncta24
Melanchra pulverulenta199
Mniotype sp. 122
Oncocnemis dayi2
Paradiarsia littoralis581
Polia purpurissata5
Protolampra rufipectis13
Scoliopteryx libatrix2
Spaelotis sp.15
Syngrapha angulidens108
Syngrapha ignea1
Trichoplexia sp.22
Trichordestra beanii14
Xestia oblata323
Xestia perquiritata2
Xestia speciosa3
Noctuidae indet. 11
Noctuidae indet. 21
Noctuidae indet. 3105
Noctuidae indet. 420
Noctuidae indet. 51
Noctuidae indet. 63
Noctuidae indet. 79
Noctuidae indet. 81
Noctuidae indet. 930
Noctuidae indet. 104
Noctuidae indet. 113
Noctuidae indet. 121
Clostera albosigma3
Clostera brucei5
Furcula scolopendrina36
Gluphisia severa14
Pheosia rimosa10
Hyles lineata3
Smerinthus cerisyi88
Sphinx vashti6
Choristoneura conflictana94