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=1528 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1528SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=1031SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1528 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthrix' AND (junior_species='potatoria' OR junior_species='potatoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euthrix' AND (species='potatoria' OR species='potatoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euthrix' AND (species='potatoria' OR species='potatoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euthrix' AND (junior_species='potatoria' OR junior_species='potatoria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euthrix' AND (species='potatoria' OR species='potatoria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglia' AND (junior_species='tau' OR junior_species='tau')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aglia' AND (species='tau' OR species='tau') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aglia' AND (species='tau' OR species='tau')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aglia' AND (junior_species='tau' OR junior_species='tau')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aglia' AND (species='tau' OR species='tau') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Watsonalla' AND (junior_species='binaria' OR junior_species='binaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Watsonalla' AND (species='binaria' OR species='binaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Watsonalla' AND (species='binaria' OR species='binaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Watsonalla' AND (junior_species='binaria' OR junior_species='binaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Watsonalla' AND (species='binaria' OR species='binaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Watsonalla' AND (junior_species='cultraria' OR junior_species='cultraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Watsonalla' AND (species='cultraria' OR species='cultraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Watsonalla' AND (species='cultraria' OR species='cultraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Watsonalla' AND (junior_species='cultraria' OR junior_species='cultraria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Watsonalla' AND (species='cultraria' OR species='cultraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyatira' AND (junior_species='batis' OR junior_species='batis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thyatira' AND (species='batis' OR species='batis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thyatira' AND (species='batis' OR species='batis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thyatira' AND (junior_species='batis' OR junior_species='batis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thyatira' AND (species='batis' OR species='batis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habrosyne' AND (junior_species='pyritoides' OR junior_species='pyritoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Habrosyne' AND (species='pyritoides' OR species='pyritoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Habrosyne' AND (species='pyritoides' OR species='pyritoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Habrosyne' AND (junior_species='pyritoides' OR junior_species='pyritoides')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Habrosyne' AND (species='pyritoides' OR species='pyritoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geometra' AND (junior_species='papilionaria' OR junior_species='papilionaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Geometra' AND (species='papilionaria' OR species='papilionaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Geometra' AND (species='papilionaria' OR species='papilionaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Geometra' AND (junior_species='papilionaria' OR junior_species='papilionaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Geometra' AND (species='papilionaria' OR species='papilionaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Comibaena' AND (junior_species='bajularia' OR junior_species='bajularia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Comibaena' AND (species='bajularia' OR species='bajularia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Comibaena' AND (species='bajularia' OR species='bajularia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Comibaena' AND (junior_species='bajularia' OR junior_species='bajularia')SELECT d.diet,d.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='bajularia' OR species='bajularia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalera' AND (junior_species='fimbrialis' OR junior_species='fimbrialis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thalera' AND (species='fimbrialis' OR species='fimbrialis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thalera' AND (species='fimbrialis' OR species='fimbrialis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thalera' AND (junior_species='fimbrialis' OR junior_species='fimbrialis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thalera' AND (species='fimbrialis' OR species='fimbrialis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='dimidiata' OR junior_species='dimidiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idaea' AND (species='dimidiata' OR species='dimidiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idaea' AND (species='dimidiata' OR species='dimidiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='dimidiata' OR junior_species='dimidiata')SELECT d.diet,d.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='dimidiata' OR species='dimidiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='trigeminata' OR junior_species='trigeminata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idaea' AND (species='trigeminata' OR species='trigeminata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idaea' AND (species='trigeminata' OR species='trigeminata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='trigeminata' OR junior_species='trigeminata')SELECT d.diet,d.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='trigeminata' OR species='trigeminata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='biselata' OR junior_species='biselata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idaea' AND (species='biselata' OR species='biselata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idaea' AND (species='biselata' OR species='biselata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='biselata' OR junior_species='biselata')SELECT d.diet,d.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='biselata' OR species='biselata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='aversata' OR junior_species='aversata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idaea' AND (species='aversata' OR species='aversata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idaea' AND (species='aversata' OR species='aversata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='aversata' OR junior_species='aversata')SELECT d.diet,d.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='aversata' OR species='aversata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='degeneraria' OR junior_species='degeneraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idaea' AND (species='degeneraria' OR species='degeneraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idaea' AND (species='degeneraria' OR species='degeneraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='degeneraria' OR junior_species='degeneraria')SELECT d.diet,d.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='degeneraria' OR species='degeneraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='deversaria' OR junior_species='deversaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idaea' AND (species='deversaria' OR species='deversaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idaea' AND (species='deversaria' OR species='deversaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idaea' AND (junior_species='deversaria' OR junior_species='deversaria')SELECT d.diet,d.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='deversaria' OR species='deversaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='nigropunctata' OR junior_species='nigropunctata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scopula' AND (species='nigropunctata' OR species='nigropunctata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scopula' AND (species='nigropunctata' OR species='nigropunctata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='nigropunctata' OR junior_species='nigropunctata')SELECT d.diet,d.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='nigropunctata' OR species='nigropunctata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='floslactata' OR junior_species='floslactata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Scopula' AND (species='floslactata' OR species='floslactata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Scopula' AND (species='floslactata' OR species='floslactata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Scopula' AND (junior_species='floslactata' OR junior_species='floslactata')SELECT d.diet,d.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='floslactata' OR species='floslactata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Timandra' AND (junior_species='comae' OR junior_species='comae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Timandra' AND (species='comae' OR species='comae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Timandra' AND (species='comae' OR species='comae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Timandra' AND (junior_species='comae' OR junior_species='comae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Timandra' AND (species='comae' OR species='comae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='annularia' OR junior_species='annularia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclophora' AND (species='annularia' OR species='annularia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclophora' AND (species='annularia' OR species='annularia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='annularia' OR junior_species='annularia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclophora' AND (species='annularia' OR species='annularia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='quercimontaria' OR junior_species='quercimontaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclophora' AND (species='quercimontaria' OR species='quercimontaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclophora' AND (species='quercimontaria' OR species='quercimontaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='quercimontaria' OR junior_species='quercimontaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclophora' AND (species='quercimontaria' OR species='quercimontaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='ruficiliaria' OR junior_species='ruficiliaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclophora' AND (species='ruficiliaria' OR species='ruficiliaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclophora' AND (species='ruficiliaria' OR species='ruficiliaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='ruficiliaria' OR junior_species='ruficiliaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclophora' AND (species='ruficiliaria' OR species='ruficiliaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='porata' OR junior_species='porata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclophora' AND (species='porata' OR species='porata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclophora' AND (species='porata' OR species='porata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='porata' OR junior_species='porata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclophora' AND (species='porata' OR species='porata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='punctaria' OR junior_species='punctaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclophora' AND (species='punctaria' OR species='punctaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclophora' AND (species='punctaria' OR species='punctaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='punctaria' OR junior_species='punctaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclophora' AND (species='punctaria' OR species='punctaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='linearia' OR junior_species='linearia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyclophora' AND (species='linearia' OR species='linearia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyclophora' AND (species='linearia' OR species='linearia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyclophora' AND (junior_species='linearia' OR junior_species='linearia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cyclophora' AND (species='linearia' OR species='linearia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='spadicearia' OR junior_species='spadicearia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthorhoe' AND (species='spadicearia' OR species='spadicearia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthorhoe' AND (species='spadicearia' OR species='spadicearia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='spadicearia' OR junior_species='spadicearia')SELECT d.diet,d.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='spadicearia' OR species='spadicearia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='ferrugata' OR junior_species='ferrugata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthorhoe' AND (species='ferrugata' OR species='ferrugata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthorhoe' AND (species='ferrugata' OR species='ferrugata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='ferrugata' OR junior_species='ferrugata')SELECT d.diet,d.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='ferrugata' OR species='ferrugata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='fluctuata' OR junior_species='fluctuata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthorhoe' AND (species='fluctuata' OR species='fluctuata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthorhoe' AND (species='fluctuata' OR species='fluctuata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='fluctuata' OR junior_species='fluctuata')SELECT d.diet,d.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='fluctuata' OR species='fluctuata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epirrhoe' AND (junior_species='alternata' OR junior_species='alternata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epirrhoe' AND (species='alternata' OR species='alternata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epirrhoe' AND (species='alternata' OR species='alternata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epirrhoe' AND (junior_species='alternata' OR junior_species='alternata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epirrhoe' AND (species='alternata' OR species='alternata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphyia' AND (junior_species='biangulata' OR junior_species='biangulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphyia' AND (species='biangulata' OR species='biangulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphyia' AND (species='biangulata' OR species='biangulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphyia' AND (junior_species='biangulata' OR junior_species='biangulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euphyia' AND (species='biangulata' OR species='biangulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camptogramma' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Camptogramma' AND (species='bilineata' OR species='bilineata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camptogramma' AND (species='bilineata' OR species='bilineata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camptogramma' AND (junior_species='bilineata' OR junior_species='bilineata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Camptogramma' AND (species='bilineata' OR species='bilineata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anticlea' AND (junior_species='badiata' OR junior_species='badiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anticlea' AND (species='badiata' OR species='badiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anticlea' AND (species='badiata' OR species='badiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anticlea' AND (junior_species='badiata' OR junior_species='badiata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anticlea' AND (species='badiata' OR species='badiata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesoleuca' AND (junior_species='albicillata' OR junior_species='albicillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesoleuca' AND (species='albicillata' OR species='albicillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesoleuca' AND (species='albicillata' OR species='albicillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesoleuca' AND (junior_species='albicillata' OR junior_species='albicillata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesoleuca' AND (species='albicillata' OR species='albicillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropteryx' AND (junior_species='suffumata' OR junior_species='suffumata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lampropteryx' AND (species='suffumata' OR species='suffumata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lampropteryx' AND (species='suffumata' OR species='suffumata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lampropteryx' AND (junior_species='suffumata' OR junior_species='suffumata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lampropteryx' AND (species='suffumata' OR species='suffumata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cosmorhoe' AND (junior_species='ocellata' OR junior_species='ocellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cosmorhoe' AND (species='ocellata' OR species='ocellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cosmorhoe' AND (species='ocellata' OR species='ocellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cosmorhoe' AND (junior_species='ocellata' OR junior_species='ocellata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cosmorhoe' AND (species='ocellata' OR species='ocellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebula' AND (junior_species='salicata' OR junior_species='salicata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nebula' AND (species='salicata' OR species='salicata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nebula' AND (species='salicata' OR species='salicata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nebula' AND (junior_species='salicata' OR junior_species='salicata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Nebula' AND (species='salicata' OR species='salicata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroclysta' AND (junior_species='siterata' OR junior_species='siterata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloroclysta' AND (species='siterata' OR species='siterata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroclysta' AND (species='siterata' OR species='siterata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroclysta' AND (junior_species='siterata' OR junior_species='siterata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chloroclysta' AND (species='siterata' OR species='siterata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysstroma' AND (junior_species='truncata' OR junior_species='truncata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysstroma' AND (species='truncata' OR species='truncata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysstroma' AND (species='truncata' OR species='truncata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysstroma' AND (junior_species='truncata' OR junior_species='truncata')SELECT d.diet,d.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='truncata' OR species='truncata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thera' AND (junior_species='britannica' OR junior_species='britannica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thera' AND (species='britannica' OR species='britannica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thera' AND (species='britannica' OR species='britannica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thera' AND (junior_species='britannica' OR junior_species='britannica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Thera' AND (species='britannica' OR species='britannica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Electrophaes' AND (junior_species='corylata' OR junior_species='corylata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Electrophaes' AND (species='corylata' OR species='corylata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Electrophaes' AND (species='corylata' OR species='corylata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Electrophaes' AND (junior_species='corylata' OR junior_species='corylata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Electrophaes' AND (species='corylata' OR species='corylata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colostygia' AND (junior_species='olivata' OR junior_species='olivata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colostygia' AND (species='olivata' OR species='olivata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colostygia' AND (species='olivata' OR species='olivata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colostygia' AND (junior_species='olivata' OR junior_species='olivata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colostygia' AND (species='olivata' OR species='olivata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colostygia' AND (junior_species='pectinataria' OR junior_species='pectinataria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colostygia' AND (species='pectinataria' OR species='pectinataria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colostygia' AND (species='pectinataria' OR species='pectinataria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colostygia' AND (junior_species='pectinataria' OR junior_species='pectinataria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colostygia' AND (species='pectinataria' OR species='pectinataria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Horisme' AND (junior_species='tersata' OR junior_species='tersata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Horisme' AND (species='tersata' OR species='tersata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Horisme' AND (species='tersata' OR species='tersata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Horisme' AND (junior_species='tersata' OR junior_species='tersata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Horisme' AND (species='tersata' OR species='tersata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanthia' AND (junior_species='procellata' OR junior_species='procellata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanthia' AND (species='procellata' OR species='procellata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanthia' AND (species='procellata' OR species='procellata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanthia' AND (junior_species='procellata' OR junior_species='procellata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Melanthia' AND (species='procellata' OR species='procellata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anticollix' AND (junior_species='sparsata' OR junior_species='sparsata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anticollix' AND (species='sparsata' OR species='sparsata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anticollix' AND (species='sparsata' OR species='sparsata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anticollix' AND (junior_species='sparsata' OR junior_species='sparsata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anticollix' AND (species='sparsata' OR species='sparsata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philereme' AND (junior_species='transversata' OR junior_species='transversata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philereme' AND (species='transversata' OR species='transversata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philereme' AND (species='transversata' OR species='transversata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philereme' AND (junior_species='transversata' OR junior_species='transversata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Philereme' AND (species='transversata' OR species='transversata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epirrita' AND (junior_species='dilutata' OR junior_species='dilutata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Epirrita' AND (species='dilutata' OR species='dilutata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Epirrita' AND (species='dilutata' OR species='dilutata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Epirrita' AND (junior_species='dilutata' OR junior_species='dilutata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Epirrita' AND (species='dilutata' OR species='dilutata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perizoma' AND (junior_species='alchemillata' OR junior_species='alchemillata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perizoma' AND (species='alchemillata' OR species='alchemillata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perizoma' AND (species='alchemillata' OR species='alchemillata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perizoma' AND (junior_species='alchemillata' OR junior_species='alchemillata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Perizoma' AND (species='alchemillata' OR species='alchemillata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='abbreviata' OR junior_species='abbreviata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupithecia' AND (species='abbreviata' OR species='abbreviata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupithecia' AND (species='abbreviata' OR species='abbreviata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='abbreviata' OR junior_species='abbreviata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eupithecia' AND (species='abbreviata' OR species='abbreviata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='tantillaria' OR junior_species='tantillaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupithecia' AND (species='tantillaria' OR species='tantillaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupithecia' AND (species='tantillaria' OR species='tantillaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='tantillaria' OR junior_species='tantillaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eupithecia' AND (species='tantillaria' OR species='tantillaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='subfuscata' OR junior_species='subfuscata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupithecia' AND (species='subfuscata' OR species='subfuscata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupithecia' AND (species='subfuscata' OR species='subfuscata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='subfuscata' OR junior_species='subfuscata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eupithecia' AND (species='subfuscata' OR species='subfuscata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asthena' AND (junior_species='albulata' OR junior_species='albulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asthena' AND (species='albulata' OR species='albulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asthena' AND (species='albulata' OR species='albulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asthena' AND (junior_species='albulata' OR junior_species='albulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Asthena' AND (species='albulata' OR species='albulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichopteryx' AND (junior_species='carpinata' OR junior_species='carpinata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trichopteryx' AND (species='carpinata' OR species='carpinata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trichopteryx' AND (species='carpinata' OR species='carpinata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trichopteryx' AND (junior_species='carpinata' OR junior_species='carpinata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trichopteryx' AND (species='carpinata' OR species='carpinata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acasis' AND (junior_species='viretata' OR junior_species='viretata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acasis' AND (species='viretata' OR species='viretata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acasis' AND (species='viretata' OR species='viretata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acasis' AND (junior_species='viretata' OR junior_species='viretata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Acasis' AND (species='viretata' OR species='viretata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abraxas' AND (junior_species='grossulariata' OR junior_species='grossulariata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abraxas' AND (species='grossulariata' OR species='grossulariata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abraxas' AND (species='grossulariata' OR species='grossulariata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abraxas' AND (junior_species='grossulariata' OR junior_species='grossulariata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abraxas' AND (species='grossulariata' OR species='grossulariata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lomaspilis' AND (junior_species='marginata' OR junior_species='marginata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lomaspilis' AND (species='marginata' OR species='marginata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lomaspilis' AND (species='marginata' OR species='marginata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lomaspilis' AND (junior_species='marginata' OR junior_species='marginata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lomaspilis' AND (species='marginata' OR species='marginata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ligdia' AND (junior_species='adustata' OR junior_species='adustata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ligdia' AND (species='adustata' OR species='adustata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ligdia' AND (species='adustata' OR species='adustata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ligdia' AND (junior_species='adustata' OR junior_species='adustata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ligdia' AND (species='adustata' OR species='adustata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaria' AND (junior_species='notata' OR junior_species='notata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaria' AND (species='notata' OR species='notata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaria' AND (species='notata' OR species='notata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaria' AND (junior_species='notata' OR junior_species='notata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macaria' AND (species='notata' OR species='notata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaria' AND (junior_species='alternata' OR junior_species='alternata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaria' AND (species='alternata' OR species='alternata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaria' AND (species='alternata' OR species='alternata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaria' AND (junior_species='alternata' OR junior_species='alternata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Macaria' AND (species='alternata' OR species='alternata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagodis' AND (junior_species='pulveraria' OR junior_species='pulveraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plagodis' AND (species='pulveraria' OR species='pulveraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plagodis' AND (species='pulveraria' OR species='pulveraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagodis' AND (junior_species='pulveraria' OR junior_species='pulveraria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Plagodis' AND (species='pulveraria' OR species='pulveraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagodis' AND (junior_species='dolabraria' OR junior_species='dolabraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Plagodis' AND (species='dolabraria' OR species='dolabraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Plagodis' AND (species='dolabraria' OR species='dolabraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Plagodis' AND (junior_species='dolabraria' OR junior_species='dolabraria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Plagodis' AND (species='dolabraria' OR species='dolabraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoxystis' AND (junior_species='pluviaria' OR junior_species='pluviaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypoxystis' AND (species='pluviaria' OR species='pluviaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypoxystis' AND (species='pluviaria' OR species='pluviaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypoxystis' AND (junior_species='pluviaria' OR junior_species='pluviaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypoxystis' AND (species='pluviaria' OR species='pluviaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apeira' AND (junior_species='syringaria' OR junior_species='syringaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apeira' AND (species='syringaria' OR species='syringaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apeira' AND (species='syringaria' OR species='syringaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apeira' AND (junior_species='syringaria' OR junior_species='syringaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Apeira' AND (species='syringaria' OR species='syringaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ennomos' AND (junior_species='autumnaria' OR junior_species='autumnaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ennomos' AND (species='autumnaria' OR species='autumnaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ennomos' AND (species='autumnaria' OR species='autumnaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ennomos' AND (junior_species='autumnaria' OR junior_species='autumnaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ennomos' AND (species='autumnaria' OR species='autumnaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ennomos' AND (junior_species='quercinaria' OR junior_species='quercinaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ennomos' AND (species='quercinaria' OR species='quercinaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ennomos' AND (species='quercinaria' OR species='quercinaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ennomos' AND (junior_species='quercinaria' OR junior_species='quercinaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ennomos' AND (species='quercinaria' OR species='quercinaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Selenia' AND (junior_species='dentaria' OR junior_species='dentaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Selenia' AND (species='dentaria' OR species='dentaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Selenia' AND (species='dentaria' OR species='dentaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Selenia' AND (junior_species='dentaria' OR junior_species='dentaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Selenia' AND (species='dentaria' OR species='dentaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Selenia' AND (junior_species='lunularia' OR junior_species='lunularia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Selenia' AND (species='lunularia' OR species='lunularia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Selenia' AND (species='lunularia' OR species='lunularia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Selenia' AND (junior_species='lunularia' OR junior_species='lunularia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Selenia' AND (species='lunularia' OR species='lunularia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Selenia' AND (junior_species='tetralunaria' OR junior_species='tetralunaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Selenia' AND (species='tetralunaria' OR species='tetralunaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Selenia' AND (species='tetralunaria' OR species='tetralunaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Selenia' AND (junior_species='tetralunaria' OR junior_species='tetralunaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Selenia' AND (species='tetralunaria' OR species='tetralunaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocallis' AND (junior_species='elinguaria' OR junior_species='elinguaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocallis' AND (species='elinguaria' OR species='elinguaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocallis' AND (species='elinguaria' OR species='elinguaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocallis' AND (junior_species='elinguaria' OR junior_species='elinguaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Crocallis' AND (species='elinguaria' OR species='elinguaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotois' AND (junior_species='pennaria' OR junior_species='pennaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colotois' AND (species='pennaria' OR species='pennaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colotois' AND (species='pennaria' OR species='pennaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colotois' AND (junior_species='pennaria' OR junior_species='pennaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colotois' AND (species='pennaria' OR species='pennaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Angerona' AND (junior_species='prunaria' OR junior_species='prunaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Angerona' AND (species='prunaria' OR species='prunaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Angerona' AND (species='prunaria' OR species='prunaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Angerona' AND (junior_species='prunaria' OR junior_species='prunaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Angerona' AND (species='prunaria' OR species='prunaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycia' AND (junior_species='hirtaria' OR junior_species='hirtaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lycia' AND (species='hirtaria' OR species='hirtaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lycia' AND (species='hirtaria' OR species='hirtaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lycia' AND (junior_species='hirtaria' OR junior_species='hirtaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lycia' AND (species='hirtaria' OR species='hirtaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriopis' AND (junior_species='leucophaearia' OR junior_species='leucophaearia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriopis' AND (species='leucophaearia' OR species='leucophaearia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriopis' AND (species='leucophaearia' OR species='leucophaearia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriopis' AND (junior_species='leucophaearia' OR junior_species='leucophaearia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agriopis' AND (species='leucophaearia' OR species='leucophaearia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriopis' AND (junior_species='aurantiaria' OR junior_species='aurantiaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriopis' AND (species='aurantiaria' OR species='aurantiaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriopis' AND (species='aurantiaria' OR species='aurantiaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriopis' AND (junior_species='aurantiaria' OR junior_species='aurantiaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agriopis' AND (species='aurantiaria' OR species='aurantiaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriopis' AND (junior_species='marginaria' OR junior_species='marginaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agriopis' AND (species='marginaria' OR species='marginaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agriopis' AND (species='marginaria' OR species='marginaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agriopis' AND (junior_species='marginaria' OR junior_species='marginaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agriopis' AND (species='marginaria' OR species='marginaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erannis' AND (junior_species='defoliaria' OR junior_species='defoliaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erannis' AND (species='defoliaria' OR species='defoliaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Erannis' AND (species='defoliaria' OR species='defoliaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erannis' AND (junior_species='defoliaria' OR junior_species='defoliaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Erannis' AND (species='defoliaria' OR species='defoliaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peribatodes' AND (junior_species='rhomboidaria' OR junior_species='rhomboidaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peribatodes' AND (species='rhomboidaria' OR species='rhomboidaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peribatodes' AND (species='rhomboidaria' OR species='rhomboidaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peribatodes' AND (junior_species='rhomboidaria' OR junior_species='rhomboidaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peribatodes' AND (species='rhomboidaria' OR species='rhomboidaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcis' AND (junior_species='repandata' OR junior_species='repandata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcis' AND (species='repandata' OR species='repandata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcis' AND (species='repandata' OR species='repandata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcis' AND (junior_species='repandata' OR junior_species='repandata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Alcis' AND (species='repandata' OR species='repandata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypomecis' AND (junior_species='roboraria' OR junior_species='roboraria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypomecis' AND (species='roboraria' OR species='roboraria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypomecis' AND (species='roboraria' OR species='roboraria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypomecis' AND (junior_species='roboraria' OR junior_species='roboraria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypomecis' AND (species='roboraria' OR species='roboraria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypomecis' AND (junior_species='punctinalis' OR junior_species='punctinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypomecis' AND (species='punctinalis' OR species='punctinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypomecis' AND (species='punctinalis' OR species='punctinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypomecis' AND (junior_species='punctinalis' OR junior_species='punctinalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hypomecis' AND (species='punctinalis' OR species='punctinalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectropis' AND (junior_species='crepuscularia' OR junior_species='crepuscularia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectropis' AND (species='crepuscularia' OR species='crepuscularia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectropis' AND (species='crepuscularia' OR species='crepuscularia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectropis' AND (junior_species='crepuscularia' OR junior_species='crepuscularia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectropis' AND (species='crepuscularia' OR species='crepuscularia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradarisa' AND (junior_species='consonaria' OR junior_species='consonaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paradarisa' AND (species='consonaria' OR species='consonaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paradarisa' AND (species='consonaria' OR species='consonaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paradarisa' AND (junior_species='consonaria' OR junior_species='consonaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Paradarisa' AND (species='consonaria' OR species='consonaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parectropis' AND (junior_species='similaria' OR junior_species='similaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parectropis' AND (species='similaria' OR species='similaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parectropis' AND (species='similaria' OR species='similaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parectropis' AND (junior_species='similaria' OR junior_species='similaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Parectropis' AND (species='similaria' OR species='similaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethalura' AND (junior_species='punctulata' OR junior_species='punctulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aethalura' AND (species='punctulata' OR species='punctulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aethalura' AND (species='punctulata' OR species='punctulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aethalura' AND (junior_species='punctulata' OR junior_species='punctulata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aethalura' AND (species='punctulata' OR species='punctulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cabera' AND (junior_species='pusaria' OR junior_species='pusaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cabera' AND (species='pusaria' OR species='pusaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cabera' AND (species='pusaria' OR species='pusaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cabera' AND (junior_species='pusaria' OR junior_species='pusaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cabera' AND (species='pusaria' OR species='pusaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cabera' AND (junior_species='exanthemata' OR junior_species='exanthemata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cabera' AND (species='exanthemata' OR species='exanthemata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cabera' AND (species='exanthemata' OR species='exanthemata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cabera' AND (junior_species='exanthemata' OR junior_species='exanthemata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cabera' AND (species='exanthemata' OR species='exanthemata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lomographa' AND (junior_species='bimaculata' OR junior_species='bimaculata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lomographa' AND (species='bimaculata' OR species='bimaculata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lomographa' AND (species='bimaculata' OR species='bimaculata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lomographa' AND (junior_species='bimaculata' OR junior_species='bimaculata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lomographa' AND (species='bimaculata' OR species='bimaculata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campaea' AND (junior_species='margaritata' OR junior_species='margaritata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Campaea' AND (species='margaritata' OR species='margaritata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Campaea' AND (species='margaritata' OR species='margaritata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Campaea' AND (junior_species='margaritata' OR junior_species='margaritata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Campaea' AND (species='margaritata' OR species='margaritata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stauropus' AND (junior_species='fagi' OR junior_species='fagii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stauropus' AND (species='fagi' OR species='fagii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stauropus' AND (species='fagi' OR species='fagii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stauropus' AND (junior_species='fagi' OR junior_species='fagii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Stauropus' AND (species='fagi' OR species='fagii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymonia' AND (junior_species='dodonea' OR junior_species='dodonea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymonia' AND (species='dodonea' OR species='dodonea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymonia' AND (species='dodonea' OR species='dodonea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymonia' AND (junior_species='dodonea' OR junior_species='dodonea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drymonia' AND (species='dodonea' OR species='dodonea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymonia' AND (junior_species='ruficornis' OR junior_species='ruficornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Drymonia' AND (species='ruficornis' OR species='ruficornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Drymonia' AND (species='ruficornis' OR species='ruficornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Drymonia' AND (junior_species='ruficornis' OR junior_species='ruficornis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Drymonia' AND (species='ruficornis' OR species='ruficornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridea' AND (junior_species='anceps' OR junior_species='anceps')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peridea' AND (species='anceps' OR species='anceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peridea' AND (species='anceps' OR species='anceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peridea' AND (junior_species='anceps' OR junior_species='anceps')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Peridea' AND (species='anceps' OR species='anceps') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostoma' AND (junior_species='palpina' OR junior_species='palpina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pterostoma' AND (species='palpina' OR species='palpina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pterostoma' AND (species='palpina' OR species='palpina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pterostoma' AND (junior_species='palpina' OR junior_species='palpina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pterostoma' AND (species='palpina' OR species='palpina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilodon' AND (junior_species='capucina' OR junior_species='capucina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilodon' AND (species='capucina' OR species='capucina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilodon' AND (species='capucina' OR species='capucina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilodon' AND (junior_species='capucina' OR junior_species='capucina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptilodon' AND (species='capucina' OR species='capucina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalera' AND (junior_species='bucephala' OR junior_species='bucephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Phalera' AND (species='bucephala' OR species='bucephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Phalera' AND (species='bucephala' OR species='bucephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Phalera' AND (junior_species='bucephala' OR junior_species='bucephala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Phalera' AND (species='bucephala' OR species='bucephala') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rivula' AND (junior_species='sericealis' OR junior_species='sericealis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rivula' AND (species='sericealis' OR species='sericealis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rivula' AND (species='sericealis' OR species='sericealis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rivula' AND (junior_species='sericealis' OR junior_species='sericealis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rivula' AND (species='sericealis' OR species='sericealis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trisateles' AND (junior_species='emortualis' OR junior_species='emortualis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trisateles' AND (species='emortualis' OR species='emortualis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trisateles' AND (species='emortualis' OR species='emortualis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trisateles' AND (junior_species='emortualis' OR junior_species='emortualis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trisateles' AND (species='emortualis' OR species='emortualis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idia' AND (junior_species='calvaria' OR junior_species='calvaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Idia' AND (species='calvaria' OR species='calvaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Idia' AND (species='calvaria' OR species='calvaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Idia' AND (junior_species='calvaria' OR junior_species='calvaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Idia' AND (species='calvaria' OR species='calvaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracolax' AND (junior_species='tristalis' OR junior_species='tristalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Paracolax' AND (species='tristalis' OR species='tristalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Paracolax' AND (species='tristalis' OR species='tristalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Paracolax' AND (junior_species='tristalis' OR junior_species='tristalis')SELECT d.diet,d.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='tristalis' OR species='tristalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herminia' AND (junior_species='tarsipennalis' OR junior_species='tarsipennalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herminia' AND (species='tarsipennalis' OR species='tarsipennalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herminia' AND (species='tarsipennalis' OR species='tarsipennalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herminia' AND (junior_species='tarsipennalis' OR junior_species='tarsipennalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Herminia' AND (species='tarsipennalis' OR species='tarsipennalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herminia' AND (junior_species='tarsicrinalis' OR junior_species='tarsicrinalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herminia' AND (species='tarsicrinalis' OR species='tarsicrinalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herminia' AND (species='tarsicrinalis' OR species='tarsicrinalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herminia' AND (junior_species='tarsicrinalis' OR junior_species='tarsicrinalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Herminia' AND (species='tarsicrinalis' OR species='tarsicrinalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herminia' AND (junior_species='grisealis' OR junior_species='grisealis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Herminia' AND (species='grisealis' OR species='grisealis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Herminia' AND (species='grisealis' OR species='grisealis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Herminia' AND (junior_species='grisealis' OR junior_species='grisealis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Herminia' AND (species='grisealis' OR species='grisealis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypogon' AND (junior_species='tentacularia' OR junior_species='tentacularia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polypogon' AND (species='tentacularia' OR species='tentacularia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polypogon' AND (species='tentacularia' OR species='tentacularia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polypogon' AND (junior_species='tentacularia' OR junior_species='tentacularia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Polypogon' AND (species='tentacularia' OR species='tentacularia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanclognatha' AND (junior_species='lunalis' OR junior_species='lunalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zanclognatha' AND (species='lunalis' OR species='lunalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zanclognatha' AND (species='lunalis' OR species='lunalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zanclognatha' AND (junior_species='lunalis' OR junior_species='lunalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Zanclognatha' AND (species='lunalis' OR species='lunalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypena' AND (junior_species='proboscidalis' OR junior_species='proboscidalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hypena' AND (species='proboscidalis' OR species='proboscidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hypena' AND (species='proboscidalis' OR species='proboscidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hypena' AND (junior_species='proboscidalis' OR junior_species='proboscidalis')SELECT d.diet,d.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='proboscidalis' OR species='proboscidalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobochyla' AND (junior_species='salicalis' OR junior_species='salicalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colobochyla' AND (species='salicalis' OR species='salicalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colobochyla' AND (species='salicalis' OR species='salicalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colobochyla' AND (junior_species='salicalis' OR junior_species='salicalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colobochyla' AND (species='salicalis' OR species='salicalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymantria' AND (junior_species='dispar' OR junior_species='dispar')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lymantria' AND (species='dispar' OR species='dispar') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lymantria' AND (species='dispar' OR species='dispar')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymantria' AND (junior_species='dispar' OR junior_species='dispar')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lymantria' AND (species='dispar' OR species='dispar') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliteara' AND (junior_species='pudibunda' OR junior_species='pudibunda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Calliteara' AND (species='pudibunda' OR species='pudibunda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Calliteara' AND (species='pudibunda' OR species='pudibunda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Calliteara' AND (junior_species='pudibunda' OR junior_species='pudibunda')SELECT d.diet,d.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='pudibunda' OR species='pudibunda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaphora' AND (junior_species='mendica' OR junior_species='mendica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diaphora' AND (species='mendica' OR species='mendica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diaphora' AND (species='mendica' OR species='mendica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diaphora' AND (junior_species='mendica' OR junior_species='mendica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diaphora' AND (species='mendica' OR species='mendica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplagia' AND (junior_species='quadripunctaria' OR junior_species='quadripunctaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplagia' AND (species='quadripunctaria' OR species='quadripunctaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplagia' AND (species='quadripunctaria' OR species='quadripunctaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplagia' AND (junior_species='quadripunctaria' OR junior_species='quadripunctaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Euplagia' AND (species='quadripunctaria' OR species='quadripunctaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miltochrista' AND (junior_species='miniata' OR junior_species='miniata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Miltochrista' AND (species='miniata' OR species='miniata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Miltochrista' AND (species='miniata' OR species='miniata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Miltochrista' AND (junior_species='miniata' OR junior_species='miniata')SELECT d.diet,d.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='miniata' OR species='miniata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithosia' AND (junior_species='quadra' OR junior_species='quadra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithosia' AND (species='quadra' OR species='quadra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithosia' AND (species='quadra' OR species='quadra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithosia' AND (junior_species='quadra' OR junior_species='quadra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lithosia' AND (species='quadra' OR species='quadra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eilema' AND (junior_species='depressa' OR junior_species='depressa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eilema' AND (species='depressa' OR species='depressa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eilema' AND (species='depressa' OR species='depressa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eilema' AND (junior_species='depressa' OR junior_species='depressa')SELECT d.diet,d.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='depressa' OR species='depressa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eilema' AND (junior_species='lurideola' OR junior_species='lurideola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eilema' AND (species='lurideola' OR species='lurideola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eilema' AND (species='lurideola' OR species='lurideola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eilema' AND (junior_species='lurideola' OR junior_species='lurideola')SELECT d.diet,d.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='lurideola' OR species='lurideola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysauxes' AND (junior_species='ancilla' OR junior_species='ancilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dysauxes' AND (species='ancilla' OR species='ancilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dysauxes' AND (species='ancilla' OR species='ancilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dysauxes' AND (junior_species='ancilla' OR junior_species='ancilla')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dysauxes' AND (species='ancilla' OR species='ancilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catephia' AND (junior_species='alchymista' OR junior_species='alchymista')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catephia' AND (species='alchymista' OR species='alchymista') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catephia' AND (species='alchymista' OR species='alchymista')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catephia' AND (junior_species='alchymista' OR junior_species='alchymista')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catephia' AND (species='alchymista' OR species='alchymista') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Minucia' AND (junior_species='lunaris' OR junior_species='lunaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Minucia' AND (species='lunaris' OR species='lunaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Minucia' AND (species='lunaris' OR species='lunaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Minucia' AND (junior_species='lunaris' OR junior_species='lunaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Minucia' AND (species='lunaris' OR species='lunaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catocala' AND (junior_species='promissa' OR junior_species='promissa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catocala' AND (species='promissa' OR species='promissa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catocala' AND (species='promissa' OR species='promissa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catocala' AND (junior_species='promissa' OR junior_species='promissa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catocala' AND (species='promissa' OR species='promissa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoips' AND (junior_species='prasinana' OR junior_species='prasinana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pseudoips' AND (species='prasinana' OR species='prasinana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pseudoips' AND (species='prasinana' OR species='prasinana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pseudoips' AND (junior_species='prasinana' OR junior_species='prasinana')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Pseudoips' AND (species='prasinana' OR species='prasinana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrostola' AND (junior_species='triplasia' OR junior_species='triplasia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abrostola' AND (species='triplasia' OR species='triplasia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abrostola' AND (species='triplasia' OR species='triplasia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrostola' AND (junior_species='triplasia' OR junior_species='triplasia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Abrostola' AND (species='triplasia' OR species='triplasia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protodeltote' AND (junior_species='pygarga' OR junior_species='pygarga')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protodeltote' AND (species='pygarga' OR species='pygarga') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Protodeltote' AND (species='pygarga' OR species='pygarga')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Protodeltote' AND (junior_species='pygarga' OR junior_species='pygarga')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protodeltote' AND (species='pygarga' OR species='pygarga') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colocasia' AND (junior_species='coryli' OR junior_species='corylii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colocasia' AND (species='coryli' OR species='corylii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colocasia' AND (species='coryli' OR species='corylii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colocasia' AND (junior_species='coryli' OR junior_species='corylii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Colocasia' AND (species='coryli' OR species='corylii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Craniophora' AND (junior_species='ligustri' OR junior_species='ligustrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Craniophora' AND (species='ligustri' OR species='ligustrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Craniophora' AND (species='ligustri' OR species='ligustrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Craniophora' AND (junior_species='ligustri' OR junior_species='ligustrii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Craniophora' AND (species='ligustri' OR species='ligustrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moma' AND (junior_species='alpium' OR junior_species='alpium')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Moma' AND (species='alpium' OR species='alpium') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Moma' AND (species='alpium' OR species='alpium')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Moma' AND (junior_species='alpium' OR junior_species='alpium')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Moma' AND (species='alpium' OR species='alpium') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='alni' OR junior_species='alnii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronicta' AND (species='alni' OR species='alnii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronicta' AND (species='alni' OR species='alnii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='alni' OR junior_species='alnii')SELECT d.diet,d.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='alni' OR species='alnii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphipyra' AND (junior_species='pyramidea' OR junior_species='pyramidea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphipyra' AND (species='pyramidea' OR species='pyramidea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphipyra' AND (species='pyramidea' OR species='pyramidea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphipyra' AND (junior_species='pyramidea' OR junior_species='pyramidea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphipyra' AND (species='pyramidea' OR species='pyramidea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphipyra' AND (junior_species='livida' OR junior_species='livida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphipyra' AND (species='livida' OR species='livida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphipyra' AND (species='livida' OR species='livida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphipyra' AND (junior_species='livida' OR junior_species='livida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphipyra' AND (species='livida' OR species='livida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphipyra' AND (junior_species='tragopoginis' OR junior_species='tragopoginis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphipyra' AND (species='tragopoginis' OR species='tragopoginis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphipyra' AND (species='tragopoginis' OR species='tragopoginis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphipyra' AND (junior_species='tragopoginis' OR junior_species='tragopoginis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Amphipyra' AND (species='tragopoginis' OR species='tragopoginis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asteroscopus' AND (junior_species='sphinx' OR junior_species='sphinx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Asteroscopus' AND (species='sphinx' OR species='sphinx') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Asteroscopus' AND (species='sphinx' OR species='sphinx')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Asteroscopus' AND (junior_species='sphinx' OR junior_species='sphinx')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Asteroscopus' AND (species='sphinx' OR species='sphinx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachionycha' AND (junior_species='nubeculosa' OR junior_species='nubeculosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Brachionycha' AND (species='nubeculosa' OR species='nubeculosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Brachionycha' AND (species='nubeculosa' OR species='nubeculosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Brachionycha' AND (junior_species='nubeculosa' OR junior_species='nubeculosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Brachionycha' AND (species='nubeculosa' OR species='nubeculosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophyes' AND (junior_species='oxyacanthae' OR junior_species='oxyacanthae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Allophyes' AND (species='oxyacanthae' OR species='oxyacanthae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Allophyes' AND (species='oxyacanthae' OR species='oxyacanthae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Allophyes' AND (junior_species='oxyacanthae' OR junior_species='oxyacanthae')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Allophyes' AND (species='oxyacanthae' OR species='oxyacanthae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caradrina' AND (junior_species='aspersa' OR junior_species='aspersa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caradrina' AND (species='aspersa' OR species='aspersa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caradrina' AND (species='aspersa' OR species='aspersa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caradrina' AND (junior_species='aspersa' OR junior_species='aspersa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Caradrina' AND (species='aspersa' OR species='aspersa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplodrina' AND (junior_species='blanda' OR junior_species='blanda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplodrina' AND (species='blanda' OR species='blanda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplodrina' AND (species='blanda' OR species='blanda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplodrina' AND (junior_species='blanda' OR junior_species='blanda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hoplodrina' AND (species='blanda' OR species='blanda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplodrina' AND (junior_species='superstes' OR junior_species='superstes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplodrina' AND (species='superstes' OR species='superstes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplodrina' AND (species='superstes' OR species='superstes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplodrina' AND (junior_species='superstes' OR junior_species='superstes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hoplodrina' AND (species='superstes' OR species='superstes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplodrina' AND (junior_species='ambigua' OR junior_species='ambigua')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplodrina' AND (species='ambigua' OR species='ambigua') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplodrina' AND (species='ambigua' OR species='ambigua')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplodrina' AND (junior_species='ambigua' OR junior_species='ambigua')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hoplodrina' AND (species='ambigua' OR species='ambigua') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charanyca' AND (junior_species='trigrammica' OR junior_species='trigrammica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Charanyca' AND (species='trigrammica' OR species='trigrammica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Charanyca' AND (species='trigrammica' OR species='trigrammica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Charanyca' AND (junior_species='trigrammica' OR junior_species='trigrammica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Charanyca' AND (species='trigrammica' OR species='trigrammica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rusina' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rusina' AND (species='ferruginea' OR species='ferruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rusina' AND (species='ferruginea' OR species='ferruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rusina' AND (junior_species='ferruginea' OR junior_species='ferruginea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rusina' AND (species='ferruginea' OR species='ferruginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dypterygia' AND (junior_species='scabriuscula' OR junior_species='scabriuscula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dypterygia' AND (species='scabriuscula' OR species='scabriuscula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dypterygia' AND (species='scabriuscula' OR species='scabriuscula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dypterygia' AND (junior_species='scabriuscula' OR junior_species='scabriuscula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dypterygia' AND (species='scabriuscula' OR species='scabriuscula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachea' AND (junior_species='atriplicis' OR junior_species='atriplicis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trachea' AND (species='atriplicis' OR species='atriplicis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trachea' AND (species='atriplicis' OR species='atriplicis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trachea' AND (junior_species='atriplicis' OR junior_species='atriplicis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Trachea' AND (species='atriplicis' OR species='atriplicis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplexia' AND (junior_species='lucipara' OR junior_species='lucipara')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euplexia' AND (species='lucipara' OR species='lucipara') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euplexia' AND (species='lucipara' OR species='lucipara')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euplexia' AND (junior_species='lucipara' OR junior_species='lucipara')SELECT d.diet,d.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='lucipara' OR species='lucipara') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='syriaca' OR junior_species='syriaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apamea' AND (species='syriaca' OR species='syriaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apamea' AND (species='syriaca' OR species='syriaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='syriaca' OR junior_species='syriaca')SELECT d.diet,d.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='syriaca' OR species='syriaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loscopia' AND (junior_species='scolopacina' OR junior_species='scolopacina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loscopia' AND (species='scolopacina' OR species='scolopacina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loscopia' AND (species='scolopacina' OR species='scolopacina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loscopia' AND (junior_species='scolopacina' OR junior_species='scolopacina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Loscopia' AND (species='scolopacina' OR species='scolopacina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesapamea' AND (junior_species='secalis' OR junior_species='secalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesapamea' AND (species='secalis' OR species='secalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesapamea' AND (species='secalis' OR species='secalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesapamea' AND (junior_species='secalis' OR junior_species='secalis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesapamea' AND (species='secalis' OR species='secalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesapamea' AND (junior_species='secalella' OR junior_species='secalella')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesapamea' AND (species='secalella' OR species='secalella') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mesapamea' AND (species='secalella' OR species='secalella')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mesapamea' AND (junior_species='secalella' OR junior_species='secalella')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesapamea' AND (species='secalella' OR species='secalella') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligia' AND (junior_species='latruncula' OR junior_species='latruncula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oligia' AND (species='latruncula' OR species='latruncula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oligia' AND (species='latruncula' OR species='latruncula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oligia' AND (junior_species='latruncula' OR junior_species='latruncula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oligia' AND (species='latruncula' OR species='latruncula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cosmia' AND (junior_species='trapezina' OR junior_species='trapezina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cosmia' AND (species='trapezina' OR species='trapezina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cosmia' AND (species='trapezina' OR species='trapezina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cosmia' AND (junior_species='trapezina' OR junior_species='trapezina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cosmia' AND (species='trapezina' OR species='trapezina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliacea' AND (junior_species='citrago' OR junior_species='citrago')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiliacea' AND (species='citrago' OR species='citrago') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiliacea' AND (species='citrago' OR species='citrago')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliacea' AND (junior_species='citrago' OR junior_species='citrago')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Tiliacea' AND (species='citrago' OR species='citrago') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithophane' AND (junior_species='socia' OR junior_species='socia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithophane' AND (species='socia' OR species='socia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithophane' AND (species='socia' OR species='socia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithophane' AND (junior_species='socia' OR junior_species='socia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lithophane' AND (species='socia' OR species='socia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithophane' AND (junior_species='ornitopus' OR junior_species='ornitopus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lithophane' AND (species='ornitopus' OR species='ornitopus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lithophane' AND (species='ornitopus' OR species='ornitopus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lithophane' AND (junior_species='ornitopus' OR junior_species='ornitopus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lithophane' AND (species='ornitopus' OR species='ornitopus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupsilia' AND (junior_species='transversa' OR junior_species='transversa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupsilia' AND (species='transversa' OR species='transversa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupsilia' AND (species='transversa' OR species='transversa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupsilia' AND (junior_species='transversa' OR junior_species='transversa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eupsilia' AND (species='transversa' OR species='transversa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='vaccinii' OR junior_species='vaccini')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conistra' AND (species='vaccinii' OR species='vaccini') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conistra' AND (species='vaccinii' OR species='vaccini')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='vaccinii' OR junior_species='vaccini')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conistra' AND (species='vaccinii' OR species='vaccini') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='rubiginosa' OR junior_species='rubiginosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conistra' AND (species='rubiginosa' OR species='rubiginosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conistra' AND (species='rubiginosa' OR species='rubiginosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='rubiginosa' OR junior_species='rubiginosa')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conistra' AND (species='rubiginosa' OR species='rubiginosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='rubiginea' OR junior_species='rubiginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conistra' AND (species='rubiginea' OR species='rubiginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conistra' AND (species='rubiginea' OR species='rubiginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='rubiginea' OR junior_species='rubiginea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conistra' AND (species='rubiginea' OR species='rubiginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' AND (junior_species='nitida' OR junior_species='nitida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrochola' AND (species='nitida' OR species='nitida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrochola' AND (species='nitida' OR species='nitida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' AND (junior_species='nitida' OR junior_species='nitida')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agrochola' AND (species='nitida' OR species='nitida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' 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='Agrochola' AND (species='litura' OR species='litura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrochola' AND (species='litura' OR species='litura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' 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='Agrochola' AND (species='litura' OR species='litura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' AND (junior_species='helvola' OR junior_species='helvola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrochola' AND (species='helvola' OR species='helvola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrochola' AND (species='helvola' OR species='helvola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' AND (junior_species='helvola' OR junior_species='helvola')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agrochola' AND (species='helvola' OR species='helvola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' AND (junior_species='macilenta' OR junior_species='macilenta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrochola' AND (species='macilenta' OR species='macilenta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrochola' AND (species='macilenta' OR species='macilenta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' AND (junior_species='macilenta' OR junior_species='macilenta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agrochola' AND (species='macilenta' OR species='macilenta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' AND (junior_species='circellaris' OR junior_species='circellaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrochola' AND (species='circellaris' OR species='circellaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrochola' AND (species='circellaris' OR species='circellaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' AND (junior_species='circellaris' OR junior_species='circellaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Agrochola' AND (species='circellaris' OR species='circellaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' 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='Agrochola' AND (species='laevis' OR species='laevis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrochola' AND (species='laevis' OR species='laevis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrochola' 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='Agrochola' AND (species='laevis' OR species='laevis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthia' AND (junior_species='togata' OR junior_species='togata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthia' AND (species='togata' OR species='togata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthia' AND (species='togata' OR species='togata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthia' AND (junior_species='togata' OR junior_species='togata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthia' AND (species='togata' OR species='togata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthia' AND (junior_species='icteritia' OR junior_species='icteritia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthia' AND (species='icteritia' OR species='icteritia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthia' AND (species='icteritia' OR species='icteritia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthia' AND (junior_species='icteritia' OR junior_species='icteritia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthia' AND (species='icteritia' OR species='icteritia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthia' AND (junior_species='ocellaris' OR junior_species='ocellaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthia' AND (species='ocellaris' OR species='ocellaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthia' AND (species='ocellaris' OR species='ocellaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthia' AND (junior_species='ocellaris' OR junior_species='ocellaris')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Xanthia' AND (species='ocellaris' OR species='ocellaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichonia' AND (junior_species='aeruginea' OR junior_species='aeruginea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichonia' AND (species='aeruginea' OR species='aeruginea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichonia' AND (species='aeruginea' OR species='aeruginea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichonia' AND (junior_species='aeruginea' OR junior_species='aeruginea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dichonia' AND (species='aeruginea' OR species='aeruginea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichonia' AND (junior_species='aprilina' OR junior_species='aprilina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dichonia' AND (species='aprilina' OR species='aprilina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dichonia' AND (species='aprilina' OR species='aprilina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dichonia' AND (junior_species='aprilina' OR junior_species='aprilina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dichonia' AND (species='aprilina' OR species='aprilina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharita' AND (junior_species='satura' OR junior_species='satura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Blepharita' AND (species='satura' OR species='satura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Blepharita' AND (species='satura' OR species='satura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Blepharita' AND (junior_species='satura' OR junior_species='satura')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Blepharita' AND (species='satura' OR species='satura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mythimna' AND (junior_species='pallens' OR junior_species='pallens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mythimna' AND (species='pallens' OR species='pallens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mythimna' AND (species='pallens' OR species='pallens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mythimna' AND (junior_species='pallens' OR junior_species='pallens')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mythimna' AND (species='pallens' OR species='pallens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mythimna' AND (junior_species='albipuncta' OR junior_species='albipuncta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mythimna' AND (species='albipuncta' OR species='albipuncta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mythimna' AND (species='albipuncta' OR species='albipuncta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mythimna' AND (junior_species='albipuncta' OR junior_species='albipuncta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mythimna' AND (species='albipuncta' OR species='albipuncta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mythimna' AND (junior_species='ferrago' OR junior_species='ferrago')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mythimna' AND (species='ferrago' OR species='ferrago') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mythimna' AND (species='ferrago' OR species='ferrago')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mythimna' AND (junior_species='ferrago' OR junior_species='ferrago')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mythimna' AND (species='ferrago' OR species='ferrago') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polia' AND (junior_species='nebulosa' OR junior_species='nebulosa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Polia' AND (species='nebulosa' OR species='nebulosa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Polia' AND (species='nebulosa' OR species='nebulosa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Polia' AND (junior_species='nebulosa' OR junior_species='nebulosa')SELECT d.diet,d.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='nebulosa' OR species='nebulosa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mamestra' AND (junior_species='brassicae' OR junior_species='brassicae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mamestra' AND (species='brassicae' OR species='brassicae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mamestra' AND (species='brassicae' OR species='brassicae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mamestra' AND (junior_species='brassicae' OR junior_species='brassicae')SELECT d.diet,d.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='brassicae' OR species='brassicae') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hada' AND (junior_species='plebeja' OR junior_species='plebeja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hada' AND (species='plebeja' OR species='plebeja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hada' AND (species='plebeja' OR species='plebeja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hada' AND (junior_species='plebeja' OR junior_species='plebeja')SELECT d.diet,d.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='plebeja' OR species='plebeja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='incerta' OR junior_species='incerta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthosia' AND (species='incerta' OR species='incerta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthosia' AND (species='incerta' OR species='incerta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='incerta' OR junior_species='incerta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthosia' AND (species='incerta' OR species='incerta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='cerasi' OR junior_species='cerasii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthosia' AND (species='cerasi' OR species='cerasii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthosia' AND (species='cerasi' OR species='cerasii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='cerasi' OR junior_species='cerasii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthosia' AND (species='cerasi' OR species='cerasii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='cruda' OR junior_species='cruda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthosia' AND (species='cruda' OR species='cruda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthosia' AND (species='cruda' OR species='cruda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='cruda' OR junior_species='cruda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthosia' AND (species='cruda' OR species='cruda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='populeti' OR junior_species='populetii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthosia' AND (species='populeti' OR species='populetii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthosia' AND (species='populeti' OR species='populetii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='populeti' OR junior_species='populetii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthosia' AND (species='populeti' OR species='populetii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='gothica' OR junior_species='gothica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthosia' AND (species='gothica' OR species='gothica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthosia' AND (species='gothica' OR species='gothica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='gothica' OR junior_species='gothica')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Orthosia' AND (species='gothica' OR species='gothica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anorthoa' AND (junior_species='munda' OR junior_species='munda')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anorthoa' AND (species='munda' OR species='munda') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anorthoa' AND (species='munda' OR species='munda')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anorthoa' AND (junior_species='munda' OR junior_species='munda')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anorthoa' AND (species='munda' OR species='munda') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrotis' AND (junior_species='exclamationis' OR junior_species='exclamationis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrotis' AND (species='exclamationis' OR species='exclamationis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrotis' AND (species='exclamationis' OR species='exclamationis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrotis' AND (junior_species='exclamationis' OR junior_species='exclamationis')SELECT d.diet,d.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='exclamationis' OR species='exclamationis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrotis' AND (junior_species='segetum' OR junior_species='segetum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agrotis' AND (species='segetum' OR species='segetum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agrotis' AND (species='segetum' OR species='segetum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agrotis' AND (junior_species='segetum' OR junior_species='segetum')SELECT d.diet,d.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='segetum' OR species='segetum') 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='Ochropleura' AND (junior_species='plecta' OR junior_species='plecta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ochropleura' AND (species='plecta' OR species='plecta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochropleura' AND (species='plecta' OR species='plecta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochropleura' AND (junior_species='plecta' OR junior_species='plecta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ochropleura' AND (species='plecta' OR species='plecta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='pronuba' OR junior_species='pronuba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctua' AND (species='pronuba' OR species='pronuba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctua' AND (species='pronuba' OR species='pronuba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='pronuba' OR junior_species='pronuba')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctua' AND (species='pronuba' OR species='pronuba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='fimbriata' OR junior_species='fimbriata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctua' AND (species='fimbriata' OR species='fimbriata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctua' AND (species='fimbriata' OR species='fimbriata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='fimbriata' OR junior_species='fimbriata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctua' AND (species='fimbriata' OR species='fimbriata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='interposita' OR junior_species='interposita')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctua' AND (species='interposita' OR species='interposita') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctua' AND (species='interposita' OR species='interposita')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='interposita' OR junior_species='interposita')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctua' AND (species='interposita' OR species='interposita') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='comes' OR junior_species='comes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctua' AND (species='comes' OR species='comes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctua' AND (species='comes' OR species='comes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='comes' OR junior_species='comes')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctua' AND (species='comes' OR species='comes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='janthina' OR junior_species='janthina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctua' AND (species='janthina' OR species='janthina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctua' AND (species='janthina' OR species='janthina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='janthina' OR junior_species='janthina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctua' AND (species='janthina' OR species='janthina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='janthe' OR junior_species='janthe')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Noctua' AND (species='janthe' OR species='janthe') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Noctua' AND (species='janthe' OR species='janthe')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Noctua' AND (junior_species='janthe' OR junior_species='janthe')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Noctua' AND (species='janthe' OR species='janthe') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurois' AND (junior_species='occulta' OR junior_species='occulta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eurois' AND (species='occulta' OR species='occulta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eurois' AND (species='occulta' OR species='occulta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eurois' AND (junior_species='occulta' OR junior_species='occulta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eurois' AND (species='occulta' OR species='occulta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='baja' OR junior_species='baja')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='baja' OR species='baja') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='baja' OR species='baja')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='baja' OR junior_species='baja')SELECT d.diet,d.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='baja' OR species='baja') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='stigmatica' OR junior_species='stigmatica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='stigmatica' OR species='stigmatica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='stigmatica' OR species='stigmatica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='stigmatica' OR junior_species='stigmatica')SELECT d.diet,d.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='stigmatica' OR species='stigmatica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='xanthographa' OR junior_species='xanthographa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='xanthographa' OR species='xanthographa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='xanthographa' OR species='xanthographa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='xanthographa' OR junior_species='xanthographa')SELECT d.diet,d.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='xanthographa' OR species='xanthographa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='c-nigrum' OR junior_species='c-nigrum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='c-nigrum' OR species='c-nigrum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='c-nigrum' OR species='c-nigrum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='c-nigrum' OR junior_species='c-nigrum')SELECT d.diet,d.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='c-nigrum' OR species='c-nigrum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metagnorisma' AND (junior_species='depuncta' OR junior_species='depuncta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metagnorisma' AND (species='depuncta' OR species='depuncta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metagnorisma' AND (species='depuncta' OR species='depuncta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metagnorisma' AND (junior_species='depuncta' OR junior_species='depuncta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Metagnorisma' AND (species='depuncta' OR species='depuncta') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1528 The Ecological Register: Sopron Mountains (young stand)
Sopron Mountains (young stand)
Basic information
Sample name: Sopron Mountains (young stand)

Reference: B. Horváth, V. Tóth, and G. Kovács. 2013. The effect of herb layer on nocturnal macrolepidoptera (lepidoptera: Macroheterocera) communities. Acta Silvatica et Lignaria Hungarica 9(1):43-56 [ER 1031]
Geography
Country: Hungary


Coordinate: 47° 39' N, 16° 28' E
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Sopron Mountains

Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: secondary forest

Substrate: ground surface

Habitat comments: "Approximately 90% of the area is forested" and the stand is in "sessile oak-hornbeam woodlands" that is "23 years old"

Methods
Life forms: moths

Sampling methods: no design,UV light traps

Sample size: 2233 individuals

Years: 2011

Seasons: spring,summer,autumn

Sampling comments: two "portable [UV] light traps" that were "positioned on the ground and with 50 m apart"

Metadata
Sample number: 1528

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-05 20:40:14

Modified: 2015-05-05 10:40:14

Abundance distribution
192 species
62 singletons
total count 2233
extrapolated richness: 362.2
Fisher's α: 50.331
geometric series k: 0.9703
Hurlbert's PIE: 0.9574
Shannon's H: 3.9944
Good's u: 0.9722
Each square represents a species. Square sizes are proportional to counts.
Register
Euthrix potatoria1
Aglia tau1
Watsonalla binaria9
Watsonalla cultraria1
Thyatira batis5
Habrosyne pyritoides11
Geometra papilionaria1
Comibaena bajularia1
Thalera fimbrialis8
Idaea dimidiata1
Idaea trigeminata1
Idaea biselata8
Idaea aversata7
Idaea degeneraria4
Idaea deversaria1
Scopula nigropunctata2
Scopula floslactata20
Timandra comae3
Cyclophora annularia5
Cyclophora quercimontaria1
Cyclophora ruficiliaria7
Cyclophora porata6
Cyclophora punctaria18
Cyclophora linearia4
Xanthorhoe spadicearia3
Xanthorhoe ferrugata3
Xanthorhoe fluctuata1
Epirrhoe alternata4
Euphyia biangulata16
Camptogramma bilineata6
Anticlea badiata1
Mesoleuca albicillata3
Lampropteryx suffumata4
Cosmorhoe ocellata1
Nebula salicata1
Chloroclysta siterata1
Dysstroma truncata1
Thera britannica2
Electrophaes corylata1
Colostygia olivata4
Colostygia pectinataria6
Horisme tersata1
Melanthia procellata2
Anticollix sparsata1
Philereme transversata1
Epirrita dilutata124
Perizoma alchemillata10
Eupithecia abbreviata5
Eupithecia tantillaria2
Eupithecia subfuscata2
Asthena albulata17
Trichopteryx carpinata1
Acasis viretata1
Abraxas grossulariata1
Lomaspilis marginata1
Ligdia adustata34
Macaria notata6
Macaria alternata6
Plagodis pulveraria23
Plagodis dolabraria7
Hypoxystis pluviaria1
Apeira syringaria4
Ennomos autumnaria1
Ennomos quercinaria66
Selenia dentaria5
Selenia lunularia4
Selenia tetralunaria15
Crocallis elinguaria10
Colotois pennaria167
Angerona prunaria12
Lycia hirtaria1
Agriopis leucophaearia2
Agriopis aurantiaria9
Agriopis marginaria16
Erannis defoliaria3
Peribatodes rhomboidaria118
Alcis repandata2
Hypomecis roboraria4
Hypomecis punctinalis53
Ectropis crepuscularia64
Paradarisa consonaria2
Parectropis similaria15
Aethalura punctulata2
Cabera pusaria7
Cabera exanthemata10
Lomographa bimaculata3
Campaea margaritata320
Stauropus fagi1
Drymonia dodonea59
Drymonia ruficornis6
Peridea anceps3
Pterostoma palpina2
Ptilodon capucina1
Phalera bucephala2
Rivula sericealis4
Trisateles emortualis7
Idia calvaria1
Paracolax tristalis23
Herminia tarsipennalis4
Herminia tarsicrinalis13
Herminia grisealis23
Polypogon tentacularia1
Zanclognatha lunalis8
Hypena proboscidalis80
Colobochyla salicalis1
Lymantria dispar1
Calliteara pudibunda2
Diaphora mendica1
Euplagia quadripunctaria3
Miltochrista miniata1
Lithosia quadra1
Eilema depressa5
Eilema lurideola10
Dysauxes ancilla1
Catephia alchymista1
Minucia lunaris1
Catocala promissa3
Pseudoips prasinana2
Abrostola triplasia1
Protodeltote pygarga6
Colocasia coryli85
Craniophora ligustri2
Moma alpium3
Acronicta (Jocheaera) alni1
Amphipyra (Amphipyra) pyramidea9
Amphipyra (Amphipyra) livida1
Amphipyra (Amphipyra) tragopoginis1
Asteroscopus sphinx15
Brachionycha nubeculosa1
Allophyes oxyacanthae2
Caradrina (Platyperigea) aspersa1
Hoplodrina blanda1
Hoplodrina superstes1
Hoplodrina ambigua27
Charanyca trigrammica3
Rusina ferruginea10
Dypterygia scabriuscula14
Trachea atriplicis5
Euplexia lucipara15
Apamea syriaca tallosi1
Loscopia scolopacina1
Mesapamea secalis12
Mesapamea secalella3
Oligia latruncula1
Cosmia (Calymnia) trapezina98
Tiliacea citrago6
Lithophane socia3
Lithophane ornitopus10
Eupsilia transversa7
Conistra (Conistra) vaccinii15
Conistra (Conistra) rubiginosa1
Conistra (Dasycampa) rubiginea3
Agrochola (Anchoscelis) nitida1
Agrochola (Anchoscelis) litura1
Agrochola (Anchoscelis) helvola1
Agrochola (Leptologia) macilenta6
Agrochola (Sunira) circellaris1
Agrochola (Propenistra) laevis22
Xanthia togata4
Xanthia icteritia1
Xanthia ocellaris1
Dichonia aeruginea1
Dichonia aprilina5
Blepharita satura59
Mythimna (Mythimna) pallens1
Mythimna (Hyphilare) albipuncta4
Mythimna (Hyphilare) ferrago16
Polia nebulosa1
Mamestra brassicae2
Hada plebeja1
Orthosia (Orthosia) incerta2
Orthosia (Monima) cerasi3
Orthosia (Microorthosia) cruda24
Orthosia (Poporthosia) populeti2
Orthosia (Semiophora) gothica11
Anorthoa munda5
Agrotis exclamationis2
Agrotis segetum9
Agrotis ipsilon4
Ochropleura plecta2
Noctua pronuba10
Noctua fimbriata2
Noctua interposita5
Noctua comes5
Noctua janthina2
Noctua janthe1
Eurois occulta2
Xestia (Xestia) baja3
Xestia (Xestia) stigmatica1
Xestia (Xestia) xanthographa2
Xestia (Megasema) c-nigrum16
Metagnorisma depuncta11