Coordinate: 47° 39' N, 16° 28' E
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