The Ecological Register: Sopron Mountains (old stand)

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=1527 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1527SELECT 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=1527 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecliocampa' AND (junior_species='populi' OR junior_species='populii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecliocampa' AND (species='populi' OR species='populii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecliocampa' AND (species='populi' OR species='populii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecliocampa' AND (junior_species='populi' OR junior_species='populii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Poecliocampa' AND (species='populi' OR species='populii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiocampa' AND (junior_species='quercus' OR junior_species='quercus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasiocampa' AND (species='quercus' OR species='quercus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasiocampa' AND (species='quercus' OR species='quercus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasiocampa' AND (junior_species='quercus' OR junior_species='quercus')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasiocampa' AND (species='quercus' OR species='quercus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrolimus' AND (junior_species='pini' OR junior_species='pinii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendrolimus' AND (species='pini' OR species='pinii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendrolimus' AND (species='pini' OR species='pinii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendrolimus' AND (junior_species='pini' OR junior_species='pinii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Dendrolimus' AND (species='pini' OR species='pinii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endromis' AND (junior_species='versicolora' OR junior_species='versicolora')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Endromis' AND (species='versicolora' OR species='versicolora') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Endromis' AND (species='versicolora' OR species='versicolora')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Endromis' AND (junior_species='versicolora' OR junior_species='versicolora')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Endromis' AND (species='versicolora' OR species='versicolora') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphinx' 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='Sphinx' AND (species='ligustri' OR species='ligustrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphinx' AND (species='ligustri' OR species='ligustrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphinx' 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='Sphinx' AND (species='ligustri' OR species='ligustrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyloicus' AND (junior_species='pinastri' OR junior_species='pinastrii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyloicus' AND (species='pinastri' OR species='pinastrii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyloicus' AND (species='pinastri' OR species='pinastrii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyloicus' AND (junior_species='pinastri' OR junior_species='pinastrii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hyloicus' AND (species='pinastri' OR species='pinastrii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laothoe' AND (junior_species='populi' OR junior_species='populii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Laothoe' AND (species='populi' OR species='populii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Laothoe' AND (species='populi' OR species='populii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Laothoe' AND (junior_species='populi' OR junior_species='populii')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Laothoe' AND (species='populi' OR species='populii') 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='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='Cymatophorima' AND (junior_species='diluta' OR junior_species='diluta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cymatophorima' AND (species='diluta' OR species='diluta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cymatophorima' AND (species='diluta' OR species='diluta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cymatophorima' AND (junior_species='diluta' OR junior_species='diluta')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Cymatophorima' AND (species='diluta' OR species='diluta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achyla' AND (junior_species='flavicornis' OR junior_species='flavicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Achyla' AND (species='flavicornis' OR species='flavicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Achyla' AND (species='flavicornis' OR species='flavicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Achyla' AND (junior_species='flavicornis' OR junior_species='flavicornis')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Achyla' AND (species='flavicornis' OR species='flavicornis') 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='Jodis' AND (junior_species='lactearia' OR junior_species='lactearia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Jodis' AND (species='lactearia' OR species='lactearia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Jodis' AND (species='lactearia' OR species='lactearia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Jodis' AND (junior_species='lactearia' OR junior_species='lactearia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Jodis' AND (species='lactearia' OR species='lactearia') 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='Hemithea' AND (junior_species='aestivaria' OR junior_species='aestivaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hemithea' AND (species='aestivaria' OR species='aestivaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemithea' AND (species='aestivaria' OR species='aestivaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemithea' AND (junior_species='aestivaria' OR junior_species='aestivaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Hemithea' AND (species='aestivaria' OR species='aestivaria') 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='Rhodostrophia' AND (junior_species='vibicaria' OR junior_species='vibicaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhodostrophia' AND (species='vibicaria' OR species='vibicaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhodostrophia' AND (species='vibicaria' OR species='vibicaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhodostrophia' AND (junior_species='vibicaria' OR junior_species='vibicaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Rhodostrophia' AND (species='vibicaria' OR species='vibicaria') 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='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='quadrifasciata' OR junior_species='quadrifasciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xanthorhoe' AND (species='quadrifasciata' OR species='quadrifasciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xanthorhoe' AND (species='quadrifasciata' OR species='quadrifasciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xanthorhoe' AND (junior_species='quadrifasciata' OR junior_species='quadrifasciata')SELECT d.diet,d.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='quadrifasciata' OR species='quadrifasciata') 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='Catarhoe' AND (junior_species='rubidata' OR junior_species='rubidata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catarhoe' AND (species='rubidata' OR species='rubidata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catarhoe' AND (species='rubidata' OR species='rubidata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catarhoe' AND (junior_species='rubidata' OR junior_species='rubidata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catarhoe' AND (species='rubidata' OR species='rubidata') 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='Euphyia' AND (junior_species='unangulata' OR junior_species='unangulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Euphyia' AND (species='unangulata' OR species='unangulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Euphyia' AND (species='unangulata' OR species='unangulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Euphyia' AND (junior_species='unangulata' OR junior_species='unangulata')SELECT d.diet,d.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='unangulata' OR species='unangulata') 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='Eulithis' AND (junior_species='populata' OR junior_species='populata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eulithis' AND (species='populata' OR species='populata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eulithis' AND (species='populata' OR species='populata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eulithis' AND (junior_species='populata' OR junior_species='populata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Eulithis' AND (species='populata' OR species='populata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ecliptopera' AND (junior_species='silaceata' OR junior_species='silaceata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ecliptopera' AND (species='silaceata' OR species='silaceata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ecliptopera' AND (species='silaceata' OR species='silaceata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ecliptopera' AND (junior_species='silaceata' OR junior_species='silaceata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ecliptopera' AND (species='silaceata' OR species='silaceata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='Chloroclysta' AND (junior_species='miata' OR junior_species='miata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chloroclysta' AND (species='miata' OR species='miata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chloroclysta' AND (species='miata' OR species='miata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chloroclysta' AND (junior_species='miata' OR junior_species='miata')SELECT d.diet,d.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='miata' OR species='miata') 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='variata' OR junior_species='variata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Thera' AND (species='variata' OR species='variata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Thera' AND (species='variata' OR species='variata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Thera' AND (junior_species='variata' OR junior_species='variata')SELECT d.diet,d.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='variata' OR species='variata') 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='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='Triphosa' AND (junior_species='dubitata' OR junior_species='dubitata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Triphosa' AND (species='dubitata' OR species='dubitata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Triphosa' AND (species='dubitata' OR species='dubitata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Triphosa' AND (junior_species='dubitata' OR junior_species='dubitata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Triphosa' AND (species='dubitata' OR species='dubitata') 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='Perizoma' 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='Perizoma' AND (species='albulata' OR species='albulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perizoma' AND (species='albulata' OR species='albulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perizoma' 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='Perizoma' AND (species='albulata' OR species='albulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='plumbeolata' OR junior_species='plumbeolata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupithecia' AND (species='plumbeolata' OR species='plumbeolata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupithecia' AND (species='plumbeolata' OR species='plumbeolata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='plumbeolata' OR junior_species='plumbeolata')SELECT d.diet,d.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='plumbeolata' OR species='plumbeolata') 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='lariciata' OR junior_species='lariciata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eupithecia' AND (species='lariciata' OR species='lariciata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eupithecia' AND (species='lariciata' OR species='lariciata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eupithecia' AND (junior_species='lariciata' OR junior_species='lariciata')SELECT d.diet,d.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='lariciata' OR species='lariciata') 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='Aplocera' AND (junior_species='plagiata' OR junior_species='plagiata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aplocera' AND (species='plagiata' OR species='plagiata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aplocera' AND (species='plagiata' OR species='plagiata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplocera' AND (junior_species='plagiata' OR junior_species='plagiata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Aplocera' AND (species='plagiata' OR species='plagiata') 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='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='Macaria' AND (junior_species='liturata' OR junior_species='liturata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Macaria' AND (species='liturata' OR species='liturata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Macaria' AND (species='liturata' OR species='liturata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Macaria' AND (junior_species='liturata' OR junior_species='liturata')SELECT d.diet,d.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='liturata' OR species='liturata') 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='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='Odontopera' AND (junior_species='bidentata' OR junior_species='bidentata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odontopera' AND (species='bidentata' OR species='bidentata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Odontopera' AND (species='bidentata' OR species='bidentata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odontopera' AND (junior_species='bidentata' OR junior_species='bidentata')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Odontopera' AND (species='bidentata' OR species='bidentata') 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='Biston' AND (junior_species='betularia' OR junior_species='betularia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Biston' AND (species='betularia' OR species='betularia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Biston' AND (species='betularia' OR species='betularia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Biston' AND (junior_species='betularia' OR junior_species='betularia')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Biston' AND (species='betularia' OR species='betularia') 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='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='Alcis' AND (junior_species='bastelbergeri' OR junior_species='bastelbergerii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alcis' AND (species='bastelbergeri' OR species='bastelbergerii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Alcis' AND (species='bastelbergeri' OR species='bastelbergerii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alcis' AND (junior_species='bastelbergeri' OR junior_species='bastelbergerii')SELECT d.diet,d.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='bastelbergeri' OR species='bastelbergerii') 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='Fagivorina' AND (junior_species='arenaria' OR junior_species='arenaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fagivorina' AND (species='arenaria' OR species='arenaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fagivorina' AND (species='arenaria' OR species='arenaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fagivorina' AND (junior_species='arenaria' OR junior_species='arenaria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Fagivorina' AND (species='arenaria' OR species='arenaria') 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='Lomographa' AND (junior_species='temerata' OR junior_species='temerata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lomographa' AND (species='temerata' OR species='temerata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lomographa' AND (species='temerata' OR species='temerata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lomographa' AND (junior_species='temerata' OR junior_species='temerata')SELECT d.diet,d.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='temerata' OR species='temerata') 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='Spatalia' AND (junior_species='argentina' OR junior_species='argentina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spatalia' AND (species='argentina' OR species='argentina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spatalia' AND (species='argentina' OR species='argentina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spatalia' AND (junior_species='argentina' OR junior_species='argentina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spatalia' AND (species='argentina' OR species='argentina') 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='Ptilodon' AND (junior_species='cucullina' OR junior_species='cucullina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilodon' AND (species='cucullina' OR species='cucullina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilodon' AND (species='cucullina' OR species='cucullina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilodon' AND (junior_species='cucullina' OR junior_species='cucullina')SELECT d.diet,d.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='cucullina' OR species='cucullina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilophora' AND (junior_species='plumigera' OR junior_species='plumigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ptilophora' AND (species='plumigera' OR species='plumigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ptilophora' AND (species='plumigera' OR species='plumigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ptilophora' AND (junior_species='plumigera' OR junior_species='plumigera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ptilophora' AND (species='plumigera' OR species='plumigera') 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='Clostera' AND (junior_species='pigra' OR junior_species='pigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clostera' AND (species='pigra' OR species='pigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clostera' AND (species='pigra' OR species='pigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clostera' AND (junior_species='pigra' OR junior_species='pigra')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Clostera' AND (species='pigra' OR species='pigra') 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='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='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='Lymantria' AND (junior_species='monacha' OR junior_species='monacha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lymantria' AND (species='monacha' OR species='monacha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lymantria' AND (species='monacha' OR species='monacha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lymantria' AND (junior_species='monacha' OR junior_species='monacha')SELECT d.diet,d.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='monacha' OR species='monacha') 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='Spilarctia' AND (junior_species='lutea' OR junior_species='lutea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spilarctia' AND (species='lutea' OR species='lutea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spilarctia' AND (species='lutea' OR species='lutea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spilarctia' AND (junior_species='lutea' OR junior_species='lutea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Spilarctia' AND (species='lutea' OR species='lutea') 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='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='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='nupta' OR junior_species='nupta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catocala' AND (species='nupta' OR species='nupta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catocala' AND (species='nupta' OR species='nupta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catocala' AND (junior_species='nupta' OR junior_species='nupta')SELECT d.diet,d.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='nupta' OR species='nupta') 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='Meganola' AND (junior_species='strigula' OR junior_species='strigula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meganola' AND (species='strigula' OR species='strigula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meganola' AND (species='strigula' OR species='strigula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meganola' AND (junior_species='strigula' OR junior_species='strigula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meganola' AND (species='strigula' OR species='strigula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meganola' AND (junior_species='albula' OR junior_species='albula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meganola' AND (species='albula' OR species='albula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meganola' AND (species='albula' OR species='albula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meganola' AND (junior_species='albula' OR junior_species='albula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Meganola' AND (species='albula' OR species='albula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrostola' AND (junior_species='asclepiadis' OR junior_species='asclepiadis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Abrostola' AND (species='asclepiadis' OR species='asclepiadis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Abrostola' AND (species='asclepiadis' OR species='asclepiadis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Abrostola' AND (junior_species='asclepiadis' OR junior_species='asclepiadis')SELECT d.diet,d.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='asclepiadis' OR species='asclepiadis') 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='Autographa' AND (junior_species='gamma' OR junior_species='gamma')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Autographa' AND (species='gamma' OR species='gamma') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Autographa' AND (species='gamma' OR species='gamma')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Autographa' AND (junior_species='gamma' OR junior_species='gamma')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Autographa' AND (species='gamma' OR species='gamma') 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='Deltote' AND (junior_species='deceptoria' OR junior_species='deceptoria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Deltote' AND (species='deceptoria' OR species='deceptoria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Deltote' AND (species='deceptoria' OR species='deceptoria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Deltote' AND (junior_species='deceptoria' OR junior_species='deceptoria')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Deltote' AND (species='deceptoria' OR species='deceptoria') 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='Diloba' AND (junior_species='caeruleocephala' OR junior_species='caeruleocephala')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diloba' AND (species='caeruleocephala' OR species='caeruleocephala') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diloba' AND (species='caeruleocephala' OR species='caeruleocephala')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diloba' AND (junior_species='caeruleocephala' OR junior_species='caeruleocephala')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diloba' AND (species='caeruleocephala' OR species='caeruleocephala') 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='tridens' OR junior_species='tridens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronicta' AND (species='tridens' OR species='tridens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronicta' AND (species='tridens' OR species='tridens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='tridens' OR junior_species='tridens')SELECT d.diet,d.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='tridens' OR species='tridens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='rumicis' OR junior_species='rumicis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acronicta' AND (species='rumicis' OR species='rumicis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acronicta' AND (species='rumicis' OR species='rumicis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acronicta' AND (junior_species='rumicis' OR junior_species='rumicis')SELECT d.diet,d.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='rumicis' OR species='rumicis') 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='berbera' OR junior_species='berbera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amphipyra' AND (species='berbera' OR species='berbera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amphipyra' AND (species='berbera' OR species='berbera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amphipyra' AND (junior_species='berbera' OR junior_species='berbera')SELECT d.diet,d.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='berbera' OR species='berbera') 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='Helicoverpa' AND (junior_species='armigera' OR junior_species='armigera')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Helicoverpa' AND (species='armigera' OR species='armigera') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Helicoverpa' AND (species='armigera' OR species='armigera')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Helicoverpa' AND (junior_species='armigera' OR junior_species='armigera')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Helicoverpa' AND (species='armigera' OR species='armigera') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caradrina' AND (junior_species='morpheus' OR junior_species='morpheus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caradrina' AND (species='morpheus' OR species='morpheus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caradrina' AND (species='morpheus' OR species='morpheus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caradrina' AND (junior_species='morpheus' OR junior_species='morpheus')SELECT d.diet,d.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='morpheus' OR species='morpheus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caradrina' AND (junior_species='kadenii' OR junior_species='kadeni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Caradrina' AND (species='kadenii' OR species='kadeni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Caradrina' AND (species='kadenii' OR species='kadeni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Caradrina' AND (junior_species='kadenii' OR junior_species='kadeni')SELECT d.diet,d.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='kadenii' OR species='kadeni') 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='octogenaria' OR junior_species='octogenaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplodrina' AND (species='octogenaria' OR species='octogenaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplodrina' AND (species='octogenaria' OR species='octogenaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplodrina' AND (junior_species='octogenaria' OR junior_species='octogenaria')SELECT d.diet,d.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='octogenaria' OR species='octogenaria') 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='respersa' OR junior_species='respersa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hoplodrina' AND (species='respersa' OR species='respersa') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hoplodrina' AND (species='respersa' OR species='respersa')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hoplodrina' AND (junior_species='respersa' OR junior_species='respersa')SELECT d.diet,d.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='respersa' OR species='respersa') 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='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='Athetis' AND (junior_species='furvula' OR junior_species='furvula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Athetis' AND (species='furvula' OR species='furvula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Athetis' AND (species='furvula' OR species='furvula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Athetis' AND (junior_species='furvula' OR junior_species='furvula')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Athetis' AND (species='furvula' OR species='furvula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='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='monoglypha' OR junior_species='monoglypha')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Apamea' AND (species='monoglypha' OR species='monoglypha') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apamea' AND (species='monoglypha' OR species='monoglypha')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' AND (junior_species='monoglypha' OR junior_species='monoglypha')SELECT d.diet,d.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='monoglypha' OR species='monoglypha') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' 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='Apamea' AND (species='anceps' OR species='anceps') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apamea' AND (species='anceps' OR species='anceps')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apamea' 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='Apamea' AND (species='anceps' OR species='anceps') 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='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='Tiliacea' AND (junior_species='aurago' OR junior_species='aurago')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tiliacea' AND (species='aurago' OR species='aurago') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tiliacea' AND (species='aurago' OR species='aurago')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tiliacea' AND (junior_species='aurago' OR junior_species='aurago')SELECT d.diet,d.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='aurago' OR species='aurago') 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='veronicae' OR junior_species='veronicae')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conistra' AND (species='veronicae' OR species='veronicae') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Conistra' AND (species='veronicae' OR species='veronicae')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Conistra' AND (junior_species='veronicae' OR junior_species='veronicae')SELECT d.diet,d.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='veronicae' OR species='veronicae') 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='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='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='turca' OR junior_species='turca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mythimna' AND (species='turca' OR species='turca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mythimna' AND (species='turca' OR species='turca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mythimna' AND (junior_species='turca' OR junior_species='turca')SELECT d.diet,d.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='turca' OR species='turca') 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='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='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='Lacanobia' AND (junior_species='thalassina' OR junior_species='thalassina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacanobia' AND (species='thalassina' OR species='thalassina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacanobia' AND (species='thalassina' OR species='thalassina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacanobia' AND (junior_species='thalassina' OR junior_species='thalassina')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lacanobia' AND (species='thalassina' OR species='thalassina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacanobia' AND (junior_species='oleracea' OR junior_species='oleracea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lacanobia' AND (species='oleracea' OR species='oleracea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lacanobia' AND (species='oleracea' OR species='oleracea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lacanobia' AND (junior_species='oleracea' OR junior_species='oleracea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lacanobia' AND (species='oleracea' OR species='oleracea') 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='Lasionycta' AND (junior_species='proxima' OR junior_species='proxima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lasionycta' AND (species='proxima' OR species='proxima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lasionycta' AND (species='proxima' OR species='proxima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lasionycta' AND (junior_species='proxima' OR junior_species='proxima')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Lasionycta' AND (species='proxima' OR species='proxima') 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='opima' OR junior_species='opima')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Orthosia' AND (species='opima' OR species='opima') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Orthosia' AND (species='opima' OR species='opima')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Orthosia' AND (junior_species='opima' OR junior_species='opima')SELECT d.diet,d.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='opima' OR species='opima') 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='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='Diarsia' AND (junior_species='brunnea' OR junior_species='brunnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Diarsia' AND (species='brunnea' OR species='brunnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diarsia' AND (species='brunnea' OR species='brunnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diarsia' AND (junior_species='brunnea' OR junior_species='brunnea')SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Diarsia' AND (species='brunnea' OR species='brunnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diarsia' 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='Diarsia' AND (species='mendica' OR species='mendica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Diarsia' AND (species='mendica' OR species='mendica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Diarsia' 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='Diarsia' AND (species='mendica' OR species='mendica') 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='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='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='castanea' OR junior_species='castanea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='castanea' OR species='castanea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='castanea' OR species='castanea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='castanea' OR junior_species='castanea')SELECT d.diet,d.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='castanea' OR species='castanea') 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='Xestia' AND (junior_species='triangulum' OR junior_species='triangulum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Xestia' AND (species='triangulum' OR species='triangulum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Xestia' AND (species='triangulum' OR species='triangulum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Xestia' AND (junior_species='triangulum' OR junior_species='triangulum')SELECT d.diet,d.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='triangulum' OR species='triangulum') 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=1527 The Ecological Register: Sopron Mountains (old stand)

Sopron Mountains (old stand)

Basic information

Sample name: Sopron Mountains (old stand)

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

Geography

Country: Hungary

Coordinate: 47° 39' N, 16° 28' E

Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Sopron Mountains

•

Environment

Habitat: temperate broadleaf/mixed forest

Altered habitat: secondary forest

Substrate: ground surface

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

Methods

Life forms: moths

Sampling methods: no design,UV light traps

Sample size: 3270 individuals

Years: 2011

Seasons: spring,summer,autumn

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

Metadata

Sample number: 1527

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-05-05 20:13:43

Modified: 2015-05-05 10:15:39

Abundance distribution

203 species

64 singletons

total count 3270

extrapolated richness: 367.2

Fisher's α: 47.900

geometric series k: 0.9683

Hurlbert's PIE: 0.9291

Shannon's H: 3.6676

Good's u: 0.9804

Each square represents a species. Square sizes are proportional to counts.

• Find matching samples

Poecliocampa populi	1
Lasiocampa quercus	1
Dendrolimus pini	3
Endromis versicolora	1
Sphinx ligustri	13
Hyloicus pinastri	9
Laothoe populi	1
Aglia tau	3
Watsonalla binaria	1
Thyatira batis	5
Habrosyne pyritoides	10
Cymatophorima diluta	6
Achyla flavicornis	1
Geometra papilionaria	4
Comibaena bajularia	9
Jodis lactearia	3
Thalera fimbrialis	2
Hemithea aestivaria	3
Idaea trigeminata	4
Idaea biselata	8
Idaea aversata	22
Idaea degeneraria	3
Idaea deversaria	10
Scopula nigropunctata	6
Scopula floslactata	7
Rhodostrophia vibicaria	1
Timandra comae	1
Cyclophora annularia	9
Cyclophora ruficiliaria	4
Cyclophora porata	1
Cyclophora punctaria	20
Cyclophora linearia	6
Xanthorhoe spadicearia	6
Xanthorhoe ferrugata	11
Xanthorhoe quadrifasciata	1
Xanthorhoe fluctuata	5
Catarhoe rubidata	2
Epirrhoe alternata	1
Euphyia biangulata	7
Euphyia unangulata	1
Anticlea badiata	1
Mesoleuca albicillata	9
Lampropteryx suffumata	23
Cosmorhoe ocellata	1
Nebula salicata	4
Eulithis populata	2
Ecliptopera silaceata	1
Chloroclysta siterata	1
Chloroclysta miata	1
Dysstroma truncata	2
Thera variata	11
Thera britannica	4
Electrophaes corylata	1
Colostygia olivata	23
Colostygia pectinataria	30
Melanthia procellata	7
Anticollix sparsata	5
Triphosa dubitata	1
Epirrita dilutata	318
Perizoma alchemillata	8
Perizoma albulata	3
Eupithecia plumbeolata	2
Eupithecia abbreviata	20
Eupithecia tantillaria	4
Eupithecia lariciata	1
Eupithecia subfuscata	1
Aplocera plagiata	1
Asthena albulata	33
Abraxas grossulariata	1
Lomaspilis marginata	1
Ligdia adustata	16
Macaria notata	7
Macaria alternata	1
Macaria liturata	11
Plagodis pulveraria	19
Plagodis dolabraria	25
Ennomos quercinaria	83
Selenia dentaria	6
Selenia lunularia	4
Selenia tetralunaria	20
Crocallis elinguaria	4
Odontopera bidentata	2
Colotois pennaria	671
Angerona prunaria	7
Biston betularia	3
Agriopis aurantiaria	14
Erannis defoliaria	14
Peribatodes rhomboidaria	31
Alcis repandata	8
Alcis bastelbergeri	4
Hypomecis roboraria	70
Hypomecis punctinalis	291
Fagivorina arenaria	20
Ectropis crepuscularia	91
Paradarisa consonaria	7
Parectropis similaria	4
Aethalura punctulata	1
Cabera pusaria	18
Cabera exanthemata	3
Lomographa bimaculata	4
Lomographa temerata	1
Campaea margaritata	202
Stauropus fagi	11
Drymonia dodonea	134
Drymonia ruficornis	2
Peridea anceps	3
Spatalia argentina	6
Ptilodon capucina	15
Ptilodon cucullina	3
Ptilophora plumigera	1
Phalera bucephala	4
Clostera pigra	1
Rivula sericealis	10
Trisateles emortualis	4
Paracolax tristalis	69
Herminia tarsicrinalis	8
Herminia grisealis	24
Polypogon tentacularia	3
Zanclognatha lunalis	16
Hypena proboscidalis	26
Colobochyla salicalis	1
Lymantria dispar	7
Lymantria monacha	22
Calliteara pudibunda	27
Spilarctia lutea	1
Euplagia quadripunctaria	2
Miltochrista miniata	4
Eilema depressa	8
Eilema lurideola	16
Dysauxes ancilla	1
Minucia lunaris	1
Catocala nupta	6
Catocala promissa	3
Meganola strigula	7
Meganola albula	1
Abrostola asclepiadis	1
Abrostola triplasia	1
Autographa gamma	1
Protodeltote pygarga	2
Deltote deceptoria	1
Colocasia coryli	144
Diloba caeruleocephala	1
Moma alpium	1
Acronicta (Triaena) tridens	1
Acronicta (Viminia) rumicis	3
Amphipyra (Amphipyra) pyramidea	3
Amphipyra (Amphipyra) berbera	1
Asteroscopus sphinx	8
Helicoverpa armigera	1
Caradrina (Caradrina) morpheus	2
Caradrina (Platyperigea) kadenii	1
Caradrina (Platyperigea) aspersa	2
Hoplodrina octogenaria	2
Hoplodrina blanda	1
Hoplodrina superstes	1
Hoplodrina respersa	1
Hoplodrina ambigua	5
Rusina ferruginea	12
Athetis (Athetis) furvula	1
Dypterygia scabriuscula	8
Trachea atriplicis	9
Euplexia lucipara	4
Apamea monoglypha	1
Apamea anceps	1
Mesapamea secalis	1
Cosmia (Calymnia) trapezina	29
Tiliacea citrago	2
Tiliacea aurago	1
Lithophane socia	1
Lithophane ornitopus	10
Eupsilia transversa	8
Conistra (Conistra) vaccinii	20
Conistra (Conistra) veronicae	1
Agrochola (Leptologia) macilenta	5
Agrochola (Propenistra) laevis	7
Blepharita satura	17
Mythimna (Mythimna) turca	2
Mythimna (Mythimna) pallens	1
Mythimna (Hyphilare) ferrago	5
Mamestra brassicae	4
Lacanobia (Dianobia) thalassina	5
Lacanobia (Diataraxia) oleracea	3
Hada plebeja	1
Lasionycta (Lasionhada) proxima	1
Orthosia (Orthosia) incerta	1
Orthosia (Monima) cerasi	6
Orthosia (Microorthosia) cruda	22
Orthosia (Cororthosia) opima	1
Orthosia (Semiophora) gothica	3
Anorthoa munda	2
Agrotis exclamationis	1
Agrotis segetum	1
Ochropleura plecta	5
Diarsia brunnea	1
Diarsia mendica	1
Noctua pronuba	8
Noctua interposita	10
Noctua comes	3
Xestia (Xestia) baja	2
Xestia (Xestia) castanea	1
Xestia (Megasema) c-nigrum	6
Xestia (Megasema) triangulum	2
Metagnorisma depuncta	9